Cost of Production Report The debits to Work in Process-Roasting Department for Morning Brew Coffee Company for August, together with information concerning production, are as follows: Work in process, August 1, 1,000 pounds, 60% completed *Direct materials (1,000 x $2.90) Conversion (1,000 60% x $1.20) Coffee beans added during August, 31,000 pounds Conversion costs during August Work in process, August 31, 1,600 pounds, 30% completed Goods finished during August, 30,400 pounds $3,620* $2,900 720 $3,620 88,350 39,364 ? ? All direct materials are placed in process at the beginning of production. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions belo X Open spreadsheet a. Prepare a cost of production report, presenting the following computations: 1. Direct materials and conversion equivalent units of production for August 2. Direct materials and conversion costs per equivalent unit for August 3. Cost of goods finished during August 4. Cost of work in process at August 31 If an amount is zero, enter in "0". For the cost per equivalent unit, round your answer to the nearest cent. If an amount is zero, enter in "0". For the cost per equivalent unit, round your answer to the nearest cent. Morning Brew Coffee Company Cost of Production Report-Roasting Department For the Month Ended August 31 Whole Units Equivalent Units Direct Materials (1) Equivalent Units Conversion (1) Units Units charged to production: Inventory in process, August 1 1,000 Received from materials storeroom 31,000 Total units accounted for by the Roasting Department 32,000 Units to be assigned costs: Inventory in process, August 1 1,000 Started and completed in August Transferred to finished goods in August Inventory in process, August 31 30,400 X Total units to be assigned costs Costs Cost per equivalent unit: Total costs for August in Roasting Department 32,000 Costs Direct Materials Conversion Total Costs Costs Costs Cost per equivalent unit: Total costs for August in Roasting Department Total equivalent units Cost per equivalent unit (2) Costs assigned to production: Inventory in process, August 1 Costs incurred in August Total costs accounted for by the Roasting Department Costs allocated to completed and partially completed units: Inventory in process, August 1 balance To complete inventory in process, August 1 Cost of completed August 1 work in process Started and completed in August Transferred to finished goods in August (3) Inventory in process, August 31 (4) Total costs assigned by the Roasting Department Direct Materials Conversion Total Costs x b. Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month (July). If required, round your answers to two decimal places. Change in direct materials cost per equivalent unit Change in conversion cost per equivalent unit Increase or Decrease Decrease Increase $ Amount