Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Sanding Department of Quik Furniture Company has the following production and manufacturing cost data for March 2022, the first month of operation. Prepare a
The Sanding Department of Quik Furniture Company has the following production and manufacturing cost data for March 2022, the first month of operation. Prepare a production cost report.
Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or the work area as indicated. Use the SUM function for totals as indicated. Prepare a production cost report Quik Furniture Company Sanding Department Production Cost Report For the Month Ended March 31, 2022 3 Using Excel To Prepare a Production Report 4 5 The Sanding Department of Quik Furniture Company has the 6 following production and manufacturing cost data for March 2022, 7 the first month of operation. 8 9 Production 10 Units in process, March 1 0 11 Units in process, March 31 3.000 12 Units finished and transferred out 7.000 13 Units transferred out, percentage complete 100% 14 Units in process, March 31 15 Direct materials - percentage complete 100% 16 Conversion costs - percentage complete 20% 17 18 Manufacturing costs 19 Costs of units in process, March 1 $ 20 Costs added during April 21 Materials 33.000 22 Labor 21,000 23 Overhead 36.000 24 25 26 27 Physical Units Conversion Costs Materials Quantities Units to be accounted for Work in process March 1 Started into production Total units Units to be accounted for Transferred out Work in process March 31 Total units Conversion Costs Materials Total Costs Costs to be accounted for 28 29 30 31 32 33 Unit costs Cost Reconciliation Schedule 34 35 36 37 38 Total costs 39 40 41 42 43 44 45 46 Materials Conversion costs Total costsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started