beginning of production. 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: This information has been collected in the Microsoft Excel Online flle. Open the spreadsheet, perform the required analysis, and Input your answers in the questions below. Open spreadsheet a. Prepare a cost of production report, presenting the following computations: 1. Direct materials and conversion equlvalent units of production for August 2. Direct materlals and conversion costs per equlvalent unit for August. 3. Cost of goods finished during August 4. Cost of work in process at August 31