The debts to Work in Process Roasting Department for Morning Brew Coffee Company for August, together with informations concerning production, are as follows: Work in process, August 1, 500 pounds, 20% completed 52,379 "Direct materials (500 x 34.50) $2,250 Conversion (500 x 20% * $1.29) 129 $2,379 Coffee beans added during August 10,214 pounds 44,431 Conversion costs during August 14,500 Work in process, August 31, 314 pounds, 42% completed 2 Goods finished during August, 10.400 pounds 2 All direct materials are placed in process at the beginning of production This information has been collected in the Microsoft Excel Online . Open the spreadsheet, perform the required analysis, and input your answers in the questions below, . 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 4. Cost of work in process at August 31 If an amount is zero, entero 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 awers to the nearest whole dollar Morning Brew Coffee Company Cost of Production Report-Roasting Department For the Month Ended August 31 Equivalent units Direct Materials Conversion (1) (1) Whole Units 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: 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 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 units: Inventory in process, August 1-balance EX $ eBook Show Me How Office 365 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 ll $ b. Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month (July). Rom cent Amount Increase or Decrease Decrease Change in direct materials cost per equivalent unit Change in conversion cost per equivalent unit Increase Feedback Check My Work .. How much more (percentage amount) needed to be done to the beginning work in process units to make the units to comple department? Did these units require more material cost or more conversion cost? How much, in terms of cost, had been don period? In order for units to be transferred to the next department, the units have to be complete with respect to both mate materials added in the process? How complete are the units in ending inventory with respect to materials? How compete are respect to conversion Materials and conversion cost needs to be allocated among the equivalent units. Are the number of e materials and conversion? b. Compare the costs per equivalent unit for July and August. The July costs per equivalent unit for materials and conversion a inventory