toSave OD 2 Home Insert 3 X cut 3 format Painter Clipboard Page Layout Liberation Sans BIUD Excel Template Assignment cho3 (1) Excel S earch Formulas Data Review View HelpDYMO Label QuickBooks 12 AA EE Wrap Text A E I Menge & Center % 9 'General -3 Insert Delete Conditional Formatas Cell Formatting Table Styles Styles Fort Number C D A B CD3 - Excel Tutorial GHIDKL CURRENT DESIGNS Building a kayak using the composite method is a very labor-intensive process. In the Fabrication Department, the kayaks go through 5 several steps as employees carefully place layers of Kevlar in a mold and then use resin to fuse together the layers. The excess resin is 6 removed with a vacuum process, and the upper shell and lower shell are removed from the molds and assembled. The seat, hatch, and other 7 components are added in the Finishing Department 8 At the beginning of April, Current Designs had 30 kayaks in process in the Fabrication Department. Rick Thrune, the production manager, 9 estimated that about 80% of the material costs had been added to these boats, which were about 50% complete with respect to the conversion 10 costs. The costs of this inventory had been calculated to be $8.400 in materials and $9,000 in conversion costs. 11) During April, 72 boats were started. At the end of the month, the 35 kayaks in the ending Inventory had 20% of the materials and 40% of 12 the conversion costs added to them. 13 A review of the accounting records for April showed that materials with a cost of $17.500 had been requisitioned by the Fabrication 14 Department and that the conversion costs for the month were $39,600. 16 Instructions 17 Complete a production report for April 2017 for the Fabrication Department using the weighted average method. 16 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". CURRENT DESIGNS Fabrication Department Production Cost Report For the Month ended April 30, 2017 Equivalent Units Physical Conversion Units Materials Costs 27 Quantities 1037 13-11CDS - Type here to search Excel TemplateAssignment_cho3 (1) Formulas Data Review View Excel Help S earch DYMO Label QuickBooks utoSave OOP Home Insert X cut - Cb Copy 3 Format Painter Clipboard Page Layout Uberation Sans BIV A A General 12 A == ? Wrap Text ESSE Merge & Center - $ % , Number A CURRENT DESIGNS Fabrication Department Production Cost Report For the Month ended April 30, 2017 Equivalent Units Physical Conversion Quantities Units Materials Costs Units to be accounted for Work in process, April 1 Value Started into production Total units Value Units accounted for Transferred out Work in process, April 30 Total units Value Value ? Value Value Value ? ? Materials Conversion Costs Total Costs Unit costs Total cost(a) Equivalent units (b) Unit costs (a) (b) ? ? Value ? ? Value ? ? Costs to be accounted for Work in process, April 1 3-7 E3-11CD3 > New sheet Type here to search @elem - Uw HP UYMU Label QuickBooks 12 AA 2 3 Xcut Copy ~ Format Painter Cipboard 5 Liberation Sans BI 0 Wrap Text Merge & Center General $ % 948-93 A S E Conditional Fomats ce Formatting Table Sole Alamat Number 5 Unit costs Total cost(a) Equivalent units (b) Unit costs (a) (b) Value Costs to be accounted for Work in process, April 1 Started into production Total costs Cost Reconciliation Schedule Cost accounted for Transferred out Work in Process, April 30 Materials Conversion costs Total costs 60 Altor you have completed the requirements of CD3, con dorthis addtional question, Assume that 25 kayaks remained in ending work in process and conversion costs incurred during the period changed to 42,500. $60,000. Show the impact of this change on the calculation of equivalent units, unit cost, and on the cost reconciliation schedule (Round calculation of cost per equivalent units to 3 decimal points)