Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units. gin by calculating the projected cost to produce each unit in 2018 based on projected sales. (Hint: In "Cost per unit" table, cell references come from Direct Materials, Direct Lab e'=ROUND' function to round the fixed manufacturing overhead cost per unit to two decimal places. epare a Cost of Goods Sold Budget. (Hint: Units per month calculated using cell references to both sales budget and production budget.) Cost per unit ect material cost per unit $ 7.95 10.00 ect labor cost per unit hufacturing overhead cost per unit 9.09 al projected manufacturing cost per unit $ 27.04 2018 get #6: Cost of Goods Sold Budget Jan Mar Q1 Total $ 86,400.00 inning Finished Goods Inventory, 3,600 units. $ 86,400.00 ts produced and sold in 2018 ost per unit 27.04 Inits per month 14,400 3040 300 336 Feb 27.04 24,000 CAO 27.04 30,000 04 200

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter6: Process Costing
Section: Chapter Questions
Problem 46E: Weighted Average Method, Unit Costs, Valuing Inventories Byford Inc. produces a product that passes...
icon
Related questions
Question
Thunder Creek Company uses the first-in, first-out (FIFO) inventory costing method.
The Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units.
Begin by calculating the projected cost to produce each unit in 2018 based on projected sales. (Hint: In "Cost per unit" table, cell references come from Direct Materials, Direct Labor, and Manufacturing Overhead budgets.)
Use '=ROUND' function to round the fixed manufacturing overhead cost per unit to two decimal places.
Prepare a Cost of Goods Sold Budget. (Hint: Units per month calculated using cell references to both sales budget and production budget.)
Cost per unit
$
Direct material cost per unit
7.95
10.00
Direct labor cost per unit
Manufacturing overhead cost per unit
9.09
27.04
Total projected manufacturing cost per unit
$
2018
Budget #6: Cost of Goods Sold Budget
Jan
Mar
Q1 Total
Beginning Finished Goods Inventory, 3,600 units.
$
86,400.00
$ 86,400.00
Units produced and sold in 2018
Cost per unit
27.04
Units per month
14,400
Total cost of units produced and sold in 2018
389,376
Total budgeted cost of goods sold
$
475,776 $
1,935,936
Feb
27.04
24,000
648,960
648,960 $
27.04
30,000
811,200
811,200 $
Transcribed Image Text:Thunder Creek Company uses the first-in, first-out (FIFO) inventory costing method. The Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units. Begin by calculating the projected cost to produce each unit in 2018 based on projected sales. (Hint: In "Cost per unit" table, cell references come from Direct Materials, Direct Labor, and Manufacturing Overhead budgets.) Use '=ROUND' function to round the fixed manufacturing overhead cost per unit to two decimal places. Prepare a Cost of Goods Sold Budget. (Hint: Units per month calculated using cell references to both sales budget and production budget.) Cost per unit $ Direct material cost per unit 7.95 10.00 Direct labor cost per unit Manufacturing overhead cost per unit 9.09 27.04 Total projected manufacturing cost per unit $ 2018 Budget #6: Cost of Goods Sold Budget Jan Mar Q1 Total Beginning Finished Goods Inventory, 3,600 units. $ 86,400.00 $ 86,400.00 Units produced and sold in 2018 Cost per unit 27.04 Units per month 14,400 Total cost of units produced and sold in 2018 389,376 Total budgeted cost of goods sold $ 475,776 $ 1,935,936 Feb 27.04 24,000 648,960 648,960 $ 27.04 30,000 811,200 811,200 $
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cost estimation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College