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:

PLEASE DO AS IT SHOWS!!

Process costing 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: 5 6 Units Costs Beginning Work in Process Inventory B Started in Production in August 32,000 66,000 9 Total to Account For 32,000 66,000 10 Completed and Transferred to Packaging Department during August 26,000 ? Ending Work in Process Inventory, 30% complete for direct materials and 60% complete 11 for conversion costs. 6,000 ? 12 Total Accounted For 32,000 66,000 13 14 * Includes $22,000 direct materials and $44,000 conversion costs 15 Use the blue shaded areas on the ENTER-ANSWERS tob 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 17 wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. 16 Units accounted for: 17 Completed and transferred out 18 Ending work-in-process 19 Total units accounted for 20 26,000 6,000 32,000 26,000 1,800 27,800 26,000 3,600 29,600 Direct Materials Conversion Costs Total Costs 21 COSTS 22 Costs to account for: 23 Beginning work-in-process 24 Costs added during period 25 Total costs to account for 26 Divided by: Total EUP 27 Cost per equivalent unit 28 29 Costs accounted for: 30 Completed and transferred out 31 Ending work-in-process 32. Total costs accounted for 35 36 Requirement 2 37 38 Work-in-Process Inventory bal. 39 40 41 42 ol 43 44 Requirement 3 45 Malting Department: 46 Cost of Goods Manufactured 47 Ending Work In Process Inventory Balance