File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share A1 : X V Function: SUM; Formulas: Multiply, Divide, Cell References B C D E F G H J K L M N O P Q R S T A U 25 26 Total units 27 28 Conversion 29 Costs Materials Costs Total 30 31 32 33 Unit costs 34 35 Cost Reconciliation Schedule 36 37 38 39 Total costs 40 41 42 43 44 Materials 45 Conversion costs 46 Total costs 47A1 X V Function: SUM; Formulas: Multiply, Divide, Cell References A B C D E F G H J K L M N 0 P Q R S T U Function: SUM; Formulas: Multiply, Divide, Cell References Using Excel To Prepare a Production Report Student Work Area + w Required: Provide input into cells shaded in yellow in this template. Use mathematical 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 6 following production and manufacturing cost data for March function for totals as indicated 2022, the first month of operation. CO Prepare a production cost report. Production 10 Units in process, March 1 0 Units in process, March 31 3,000 Quik Furniture Company 12 Units finished and transferred out 7,000 Sanding Department 13 Units transferred out, percentage complete 100% Production Cost Report 14 Units in process, March 31 For the Month Ended March 31, 2022 15 Direct materials - percentage complete 100% 16 Conversion costs - percentage complete 20% Physical Conversion 17 Quantities Units Materials Costs 18 Manufacturing costs 19 Costs of units in process, March 1 $ 20 Costs added during April 21 Materials 33,000 Total units 22 Labor 21,000 23 Overhead 36,000 24 25 26 Total units 27 28 Conversion 29 Costs Materials Costs Total