Au Fle Home Insert Page Layout Formulas Data & Cut Liberation Sara Copy Parte BIV 12 AA A- &-A- Format Painter Clipboard Fant M19 R D Chapter3Homework Questions + Review View Search (Ah- A Autumn Howel Comments Share Autasum Wrap Test Custom Comma 2 Comme 3 Currency 2 Merge & Center 5 % 73 Conditions Format as Percent 2 Formatting-Table- Normal Bad Normal 2 Good 27 Insert Delete Format WHY Clear- Sort & Find & File-S- Analy Dala Alignment Number Styles Cels Edeng Analy M 0 F R T V x A AR AC 1 Function: SUM; Formulax: Multiply, Divide, Call References Using Excel To Prepare a Production Report 5 The Sanding Department of Oak Future Company has the following production and manufacturing cost data for March 72002, the fral month of operation Production 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 SUIV function for findicated Prepare a production cost report Up, March 1 0 UpMarch 31 3,000 Units finished and transferred out 7,000 Unu, parag 100% Unipro, March 31 D-percentage comple 100% Covers cala-page comp 20% Quantes Manufacturing costs Cata of uproarch Cadding Apr Q Company Sunding Production Coal Report For the Month Endod March 31, 2022 Physical Unita Ma Conversion Curb 31 30 Vaters Lubar Overd 50 52 Enter Answer + Ready Type here to search 30.000 Totalunts 21.003 38003 Tataunts Co Unit costs Cost Recenciat Total cost Materi Conversion coel Total E Marb Conversion Club Total AG AH A A AK AL v 70% 32F Clear ^4 7:43 PM 2/8/2007 A Autumn Howell Comments Share AutoSum Comma 2 Conditional Format as Formatting Table- Percent 2 Comme 3 Normal Currency 2 Normal 2 27 O Bad Good Insert Delete Format WHY Clear Sort & Find & File-S- Anslyne Dala Number Styles Cels Edeng A K L M N 0 P Q R S T U V W Sanding Department Production Cost Report For the Month Ended March 31, 2022 Au Chapter Homework Questionbal Search (Ah- Fle Home Insert Page Layout Formulas Data Review View & Cut Liberation Sara 12 AA 7. Wrap Test Text Copy Paste BIU A- - A- Merge & Center 5 % Format Panter Capboard Fant 2 Alignment G18 A B C D FG H 12 Units finished and transferred out 7,000 13 14 Units transferred out, percentage complete Units in process, March 31 100% 15 Direct materials - percentage complete 100% 16 Conversion costs - percentage complete 20% 17 Quantities 18 Manufacturing costs 19 Costs of units in process, March 1 $ Costs to benef 20 Costs added during April Costs accounted fre Units to be accounted for Units accounted for 21 Materials 33,000 Totor drit 22 Labor 21,000 23 Overhead 36,000 24 25 26 Total units 27 28 29 Costs 30 31 32 33 34 35 Unit costs Cost Reconciliation Schedule 36 37 38 39 Total costs 40 41 42 43 Enter Answer + Ready Type here to search E Physical Units Materials Conversion Costs Materials Conversion Costs Total 115% 32F Clear ^4 7:43 PM 2/8/2007 A Autumn Howell Comments Share AutoSum Comma 2 Conditional Format as Formatting Table- Percent 2 Comme 3 Normal Currency 2 Normal 2 27 O Bad Good Insert Delete Format WHY Clear Sort & Find & File-S- Anslyne Dala Number Styles Cels Edeng A K L M N 0 P Q R S T U V W Sanding Department Production Cost Report For the Month Ended March 31, 2022 Au Chapter Homework Questionbal Search (Ah- Fle Home Insert Page Layout Formulas Data Review View & Cut Liberation Sara 12 AA 7. Wrap Test Text Copy Parte BIU A- - A- Merge & Center 5 % Format Panter Capboard Fant 2 Alignment H24 A B C D FG H 12 Units finished and transferred out 7,000 13 14 Units transferred out, percentage complete Units in process, March 31 100% 15 Direct materials - percentage complete 100% 16 Conversion costs - percentage complete 20% 17 Quantities 18 Manufacturing costs 19 Costs of units in process, March 1 $ 20 Costs added during April 21 Materials 22 Labor 23 Overhead 33,000 21,000 36,000 Total units 24 25 26 27 28 29 | Work in process March 1 Work in process March 31 Started into production Transferred in Transfe Equivalent units Tutal cust Sold 30 31 32 33 34 35 Unit costs Cost Reconciliation Schedule 36 37 38 39 Total costs 40 41 42 43 Enter Answer + Ready Type here to search E Physical Units Materials Conversion Costs Materials Conversion Costs Total 115% 32F Clear ^4 7:43 PM 2/8/2007