A B C D E F G H J K L M N 0 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 6 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 Costs of units in process, March 1 $ Costs added during April Materials 33,000 Total units Labor 21,000 Overhead 36,000 26 Total units Conversion Costs Materials Costs Total Unit costs 34 Cost Reconciliation Schedule 36 37 38 39 Total costs 40 43 44 Materials 45 Conversion costs 46 Total costs