***Show formulas please***

M N O 1 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 Units Costs 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 9 10 26,000 54,000* 26,000 54,000 21,000 5,000 26,00054,000 12 13 14 15 Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. 16 ALWAYS use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Enter all 17 amounts as positive values. Do not use a minus sign or parentheses for any values. 18 19 Requirement *Includes $18,000 direct materials and $36,000 conversion costs Possible Points 34 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 weighted-average method 20 2 1