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
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...
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 $](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F901df299-20da-43a2-931e-18e3316b9a2d%2Ff927787f-ad91-490c-b82e-23fe2e443c9c%2Fot36cj_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
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
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
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
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College