The debts to work in POC pa $2.5389 ng Department for coming we Work in process, August 1, 500 pounds, 20% completed Direct materials (500 54.80) $2,400 Conversion (500 x 2096 X 51.38) $2.530 Coffee beans added during August, 10.214 pounds Conversion costs donng August Work in process, August 31, 314 pounds, 42% completed Good finished during August, 10.400 pounds 47,495 15,439 All direct materials are placed in process at the beginning of production This Information has been collected in the Microsoft Excel Online fie. Open the spreadsheet, perform the required was, and input your answers in the question below Opel spreadsheet Prepare a cost of production report, presenting the following computation 1. Direct materials and convention equivalent units of production for August 2. Direct materials and conversion. Der equivalent unit for August 3. Coot of good finished during August 4. Cost of work in process at August 31 If an amount to entero Round the answers in Units to the nearest when the one for the cost per tant to the nearest cent and the other monetary swers to the nearest woledo Costs Direct Materials Conversion Total COSTS Costs per equivalent unit Total costs for Augustin Roasting Department Total equivalent units Cost per equivalent unit (2) Costs assigned to productions 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 314) Totalcoats assigned by the Roasting Department 4 100 b. Computer and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month July). Round your answer to the nearest cent Amount Increase or Decrease Change in direct materials cost per equivalent unit Change in convention cost per equivalent unit 2. Direct materas and conversion Coots 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 *0". Round the answers in units to the nearest whole number, the answer for the cost per equivalent unit to the nearest cent, and the other monetary answers to the nearest whole dollar Morning Brew Coffee Company Cost of Production Report Roasting Department For the Month Ended August 31 Equivalent Units Direct Whole Materials Conversion UNITS Units (1) (1) Units charged to production Inventory in process, August 1 Received from matenals storeroom Total units accounted for by the Roasting Department Units to be assigned costs Inventory in process, August 1 Started and completed in August Transferred to finished goods in August Inventory in process, August 31 Total units to be assigned costs Costs 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, 500 pounds, 20% completed $2,538" Direct matenals (500 $4.80) $2,400 Conversion (500 20% * $1.38) 138 52,538 Coffee beans added during August, 10.214 pounds 47,495 Conversion costs during August 15,439 Work in process, August 31, 314 pounds, 42% completed Goods finished during August, 10,400 pounds 2 2 All direct materials are placed in process at the beginning of production This information has been collected in the Mirosoft Excel Online file: Open the spreadsheet, perform the required analysis, and input your answers in the questions below HI Open spreadsheet . 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 1. Direct materals 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 "o". Round the answers in units to the nearest whole number, the answer for the cost per equivalent unit to the nearest cent, and the other monetary answers to the nearest whole dollar Morning Brew Coffee Company Cost of Production Report-Roasting Department For the Month Ended August 31 Equivalent Units Direct Whole Materials Conversion UNITS Units (1) (1) 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 costa Inventory in proces, August 1 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 COSTS Costs per equivalent unit: Total costs for Augustin 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 unitsi Inventory in process, August 1-balance To complete inventory in process, August 1 Cost of completed August 1 work in progres 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 unt for direct matenals and conversion from the previous month Ouly). Round your answers to the nearest cent. Amount Increase or Decrease Change in direct materials cost per equivalent unit Change in conversion cost per equivalent unit