Question: If you read Required: you will see it is asking to use mathematical formulas and cell referencing, SUMfunction. I have done the math so everything
If you read Required: you will see it is asking to use mathematical formulas and cell referencing, SUMfunction. I have done the math so everything in yellow is correct. But it is coming up wrong as i haven't entered them using SUMfunction and cell reference. What should i enter in the cells to get those answers?

A B C D E F G H J K L M N O P W N Using Excel To Prepare a Production Report Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical 5 The Sanding Department of Quik Furniture Company has the formulas with cell references to the Problem or the work area as indicated. Use the SUM following production and manufacturing cost data for March function for totals as indicated. 2022, the first month of operation. Prepare a production cost report. Production Units in process, March 1 0 Units in process, March 31 3,000 Quik Furniture Company Units finished and transferred out 7,000 Sanding Department Units transferred out, percentage complete 100% Production Cost Report Units in process, March 31 For the Month Ended March 31, 2022 Direct materials - percentage complete 100% Conversion costs - percentage complete 20% Physical Conversion Quantities Units Materials Costs Manufacturing costs Units to be accounted for Costs of units in process, March 1 $ Work in process March 1 Costs added during April Started into production 10,000 Materials 33,000 Total units 10,000 Labor 21,000 Overhead 36,000 Units accounted for Transferred out 7,000 7,000 7,000" Work in process March 31 3,000 3,000 600 26 Total units 10,000 10,000 7,600 Conversion Costs Materials Costs Total Unit costs Total cost $ 33,000 $ 57,000 $ 90,000 Equivalent units 10,000 7,600 Unit costs $ 3.30 $ 7.50 $ 10.80 35 Cost Reconciliation Schedule 36 Costs to be accounted for Work in process March 1 $ Started into production 90,000 Total costs $ 90,000 Costs accounted for Transferred out $ 75,600 Work in process March 31 Materials $ 9,900 * Conversion costs 4,500* 14,400 46 Total costs $ 90,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
