all i need is answers for this one
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, B00 pounds, 30% completed $4,084 Direct materials (800 x 54.70) $3,760 Conversion (800X 30% $1.35) 324 $4,084 Coffee beans added during August, 16,343 pounds Conversion costs during August 24,960 Work in process, August 31, 443 pounds, 42% completed Goods finished during August, 16,700 pounds 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 anays, and input your answers in the question below 74,361 ? 3 HT! 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 cost 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 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 COSTS Conversion Total Direct Materials Conversion Total COSTS Costs per equivalent uniti 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 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 100 111 b. Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month July). Round your answers to the nearest cent b. Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month July). Round your answers to the nearest cent. Amount Increase or Decrease Change in direct materials cost per equivalent unit Decrease Change in conversion cost per equivalent unit Increase Feed Check My Wort a. How much more (percentage amount) needed to be done to the beginning work in process units to make the units to complete to transfer to the next department? Did these units require more material cost or more conversion cost? How much, in terms of cost, had been done to these units in the prior period? In order for units to be transferred to the next department, the units have to be complete with respect to both materials and conversion. When are materials added in the process? How complete are the units in ending inventory with respect to materials? How compete are the units in ending inventory with respect to conversion? Materials and conversion cost needs to be allocated among the equivalent units, Are the number of equivalent units the same for materials and conversion? b. Compare the costs per equivalent unit for July and August. The July costs per equivalent unit for materials and conversion are in the August 1 work in process Inventory
