Thu debits to Work in Process-lasting Department for Morning Brew Coffee Company for August, together with information concerning production, elle Work in proces, August 1, 500 pounds, 30% conpleted 52.498 Drect materials (500 $4.60) 52.000 Conversion (500 x 30' 51.32) 198 $2.408 Coffee beans added during August 10,214 pounds 45,963 Conversion costs during August 14,142 Work in process, August 31, 314 pounds, 42% completed Goods finished during August 10,400 pounds 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, perform the required anys, and input your neers n the questions below X1 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 costa por 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 Tom Round the answers in units to the nearest whole number the answer for the cost per equwalent unit to the nearest cent, and the other monetary answers to the nearest whole della