The debits to Work in Process-Roasting Department for Morning Brew Colfee Company for August, together with information conceming production, are as follows: All direct materieis are placed in process at the beginning of production. This intormation has been collected in the Microsoft Excel Ontine file. Open the spreadsheet, perform the required analysis, and input your answers in the questions beiow. Open spreadsheet a. Prepare a cost of production report, presenting the following computations: 1. Direct materials and conversion equivalent units of probuction for August 2. Direct materials and conversion costs per equivalent unit for August 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 " 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 othe monetary answers to the nearest whole doliar. 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 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