AutoSave OOD R E xcelTemplateAssignment Ch03 (1) Protected View Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing X R E3-7 Prepare a production report A ABCD 1 E3-7\Prepare a production report 2 The Sanding Department of Quik Furniture Company has the following production and manufacturing cost 3 data for March 2017, the first month of operation. Production: 7,000 units finished and transferred out; 3,000 units started that are 100% complete as to materials and 20% complete as to conversion costs. Manufacturing costs: Materials $33,000, labor $21,000, overhead $36,000, 8 Instructions 9 Prepare a production cost report. 10 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". QUIK FURNITURE COMPANY Sanding Department Production Cost Report For the Month ended March 31, 2017 Equivalent Units Physical Conversion 19 Quantities Units Materials Costs 20 Units to be accounted for 21 Work in process, March 1 22 Started into production 23 Total units Valde Value Value 25 Units accounted for Transferred out 27 Work in process, March 31 28 Total units Value Value Value Value D- 703-1100 Enable Ed AutoSave O R Excel TemplateAssignment_Ch03 (1) . Protected View Excel Search File Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View AI . : X fi E3-7 Prepare a production report A B C D Conversion 31 Costs Materials Costs Total 32 Unit costs 33 Total cost(a) Equivalent units (b) Value Value 35 Unit costs (a) + (b) 34 For Value Value 37 Costs to be accounted for 38 Work in process, March 1 39 Started into production 40 Total costs 41 42 Cost Reconciliation Schedule 43 Cost accounted for 44 Transferred out 45 Work in Process, March 31 Materials 47 Conversion costs 48 Total costs Value Value Value 52 A or you have completed the requiroments of E3-7, consider this addicional question 531. Assume that 9,000 units were completed and transferred out. Show the impact of this change on the calculation of equivalent units, unit cost, and on the cost reconciliation schedule. 01- 7 03-11 C031 - Type here to search 011 M e w @eleman