ch 17 ? 12 it is all one question please answer all parts

The debits to Work in Process - Roasting Department for Morning Brew Coffee Company for August, together with information concerning peoductian, are as follows: 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, Filform the required analysis, and input your answers in the questions below. Open spreadsheet a. Prepare a cost of productien report, presenting the following computations: 1. Direct materials and conversion equivalent units of production for Aughust 2. Direct materials and conversion costs per equivalent unit for August 3. Cost of goods finished during August If an amount is sero, entes 0. Round the answers in units to the nearest whole number, the ansiner for tho cost per equivalent une ts the nearest cart, and the other monetary answers to the nearest whole dollar. b. Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous manth (July). Round your anseers to the nearest cent. Total costs assigned by the Roasting Department 9. 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. Feotback r chear by Wirh 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 grior 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 af ecuivalent units the same for materials and conversion? b. Compare the costs per equivalent unit for July and August. The July costs per equitualent unit for materials and conversion are in the Alagust 1 work in process inventory