3 P20-46 Using Excel to prepare a production cost report s Sallsh Craft Beers provides the following information for the Malting Department for the month of August 2018 4 6 2 Units Costs 8 9 10 26,000 26,000 21,000 54,000 54,000 11 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 12 13 5,000 26,000 ? 54,000 15 Includes $18,000 direct materials and $36,000 conversion costs. 16 17 Requirements Complete a production cost report for the Malting Department for the month of August 2018 to determine the cost of the units completed and transferred out, and the cost of the ending Work in Process Inventory. Assume Salish Craft Beers uses the 18 weighted average method. 19 20 Excel Skills 21 1. Enter numbers into cells. 22 2 Create formulas 23 3. Format the cells requiring dollar signs. 24 4. Format the cells requiring a single underline and cells requiring double underlines, 25 26 27