QSearch Sheet Chapter 16 Example Problem Home A+ Share A Review View Insert Page Layout Formulas Data Insert A- A EtWrap Text Liberation Sans 10 General Delete Conditional Format Formatting as Table Merge & Center % Paste U Cell Styles Sort & Format Filter ofE16-7, consider this additional question. fAfter you have completed the requirements A52 A C D G K M N C 1E16-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 opcration. Production: 7,000 units finishcd and transfcrred out; 3,000 units started that are 100% complcte as to 4 materials and 20% complete as Manufacturing costs: Materials $33,000; labor S21,000; overhead $36,000. conversion costs. 5 6 7 8 Instructions Prcparc a production cost report. 9 10 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 11 QUIK FURNITURE COMPANY 14 Sanding Department Production Cost Report 15 16 For the Month ended March 31, 2017 17 Equivalent Units 18 Conversion 19 Quantities Physical Units Materials Costs 20 Units to be accounted for Work in proccss, March 1 Started into production Valuc 21 Valuc 22 23 Total units E16-7 Ready 130% QSearch Sheet Chapter 16 Example Problem tShare A Page Layout Home Insert Formulas Data Review View Insert A A Wrap Text General Liberation Sans 10 Delete U A Merge & Center % Paste 7 Formattina Tle Filter Styles Format fe A52 After you have completed the requirements of E16-7, consider this additional question. C D G H K N Total units 23 24 25 Units accounted for Transferred out Value Value Value 26 Work in process, March 31 Total units Value Value 27 28 29 30 Total 31 Costs Materials Conversion Costs 32 Unit costs Total cost(a) 33 Equivalent units (b) Value Value 34 Unit costs (a)(b) 35 36 37 Costs to be accounted for Work in process, March Started into production Value 38 Value 39 40 Total costs 41 42 Cost Rcconciliation Schcdulc 43 Cost accounted for Transferred out Value 44. E16-7 Ready 130% |VOD 42 Cost Rcconciliation Schedule 43 Cost accounted for Transferred out Value 4 Work in Process, March 31 Value Materials 46 Conversion costs Value 47 48 Total costs 49