Chapter 20 Using Excel P2046 Usi ng Excel to prepare a production cost report Salish Craft Beers provides the following information for the Melting Department for the month of August 2018: 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 * Includes $18,000 direct materials and $35,000 conversion costs. Requirements Complete a production cost report lor the Melting 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 weighted-average method. Excel Skills 1. 2. 3. 4 Enter numbers into cells. Create formulas. Format the cells requiring dollar signs. Format the cells requiring a single underline and cells requiring double underlines. Units 26300 20000 21000 5'000 26,000 Costs 54,000 * 54,000 ? 54,000I SALISH CRAFT BEERS Production Cost Report - MALTING DEPARTMENT Month Ended August 31, 2018 Equivalent Units UNITS Physical Units Direct Materials Conversion Costs Units to account for: Beginning work-in-process Started in Production Total units to account for Units accounted for: Completed and transferred out Ending work-in-process Total units accounted for COSTS Direct Materials Conversion Costs Total 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