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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education