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,100 pounds, 30% completed "Direct materials (1,100 x $5.20) Conversion (1,100 x 30% x $2.10) Coffee beans added during August, 34,000 pounds Conversion costs during August Work in process, August 31, 1,800 pounds, 70% completed Goods finished during August, 33,300 pounds $6,413" $5,720 693 $6,413 175,100 75,306 ? 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 below. Deen spreadsheet a. Prepare a cost of production report, presenting the following computations: 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. Morning Brew Coffee Company Cost of Production Report-Roasting Department For the Month Ended August 31 Units Units charged to production: Inventory in process, August 1 Received from materials storeroom Total units accounted for by the Roasting Department Units to be assigned costs: 1 Inventory in process, August 1 Started and completed in August Transferred to finished goods in August Inventory in process, August 31 Whole Units Equivalent Units Direct Materials (1) Equivalent Units Conversion (1) Total units to be assigned 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) Costs Direct Materials Conversion 00 00 Total Costs 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 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 2 3 5 1 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: DATA 6 Work in process, August 1 $6,413 7 (1,100 pounds, 30% completed) 8 Cost per equivalent unit of materials for July $5.20 9 Cost per equivalent unit of conversion cost for July $2.10 10 Direct materials $5.720 11 Conversion $693 12 $6.413 13 15 14 Coffee beans added during August (34,000 pounds) 16 Conversion costs during August 17 Work in process, August 31 18 (1,800 pounds, 70% completed) 19 Goods finished during August 20 (33,300 pounds) 175,100 75,306 21 22 Al direct materials are placed in process at the beginning of production 23 REQUIRED: 24 Prepare a cost of production report 25 26 26 29 Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cels show in the orange cells. Select conect answers corresponding directions of changes in the dropdowns in cells G67 GGB Transfer amounts to CNOWV2 for grading Moming Brew Coffee Company Cost of Production Report-Roasting Department For the Month Ended August 31 Equivalent Units Direct 36 READ 30 UNITS Whole Units Materials Conversion (1) (1) 31 32 33 Units charged to production Inventory in process, August 1 Received from materials storeroom 34 Total units accounted for by the 35 Units to be assigned costs Roasting Department Inventory in process. August 1 Formulas 39 40 41 42 43 44 Started and completed in August Transferred to finished goods in August Inventory in process, August 31 Total units to be assigned costs Costs Direct Materials Conversion Total 45 COSTS 46 Costs per equivalent unit 47 Total costs for August in Roasting 48 Department 49 Total equivalent units 50 Cost per equivalent unit (2) 51 Costs assigned to production 52 53 54 55 56 57 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 59 60 61 62 63 64 65 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 Reasting Department 66 REQUIRED: 67 Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month (July) 71 72 SSPER 68 69 Change in direct materials cost per equivalent unit 70 Change in conversion cost per equivalent unit Increase or Decrease Amount Formulas