Using Excel to prepare a production cost report.

Salish Craft Beers provides the following information for the Malting Department for the month of August 2018

Process costing 2. Using Excel to prepare a production cost report 4 Salish Craft Beers provides the following information for the Malting Department for the month of August 2018: 3 Units Costs 5 6 7 8 32,000 32,000 26,000 66,000 66,000 ? 9 10 Beginning Work-in-process inventory Started in Production in August Total to Account For Completed and Transferred to Packaging Department during August Ending Work-in-Process Inventory, 30% complete for direct materials and 60% complete for conversion costs. Total Accounted for 11 6,000 32,000 ? 66,000 12 13 14 * Includes $22,000 direct materials and $44,000 conversion costs. 15 is the blue shaded areas on the ENTER ANSWERS tab for inputs. + Total units accounted for 32,000 27,800 29,600 9 0 1 Direct Materials Conversion Costs Total Costs 2 3 14 5 6 17 8 29 10 11 B2 33 COSTS Costs to account for: Beginning work in process Costs added during period Total costs to account for Divided by: Total EUP Cost per equivalent unit Costs accounted for: Completed and transferred out Ending work in process Total costs accounted for Work-in-Process Inventory 31 Ending work-in-process 32 Total costs accounted for 33 34 35 36 Requirement 2 37 38 bal. 39 40 91 2 33 34 Requirement 3 15 Malting Department: -6 Cost of Goods Manufactured -7 Ending Work In Process Inventory Balance 8 &