Ch$17-$Excel Exercises

eBook

Show Me How

Office $365$

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,900$ pounds, $10\%$ completed

$$2,898**$

$*$Direct materials $(900$$$3\mathrm{.}10)$

Conversion $(90010\%$$$1\mathrm{.}20)$

$$2,790$

$108$

$$2,898$

Coffee beans added during August, $28,000$ pounds

Conversion costs during August

$85,400$

Work in process, August $31,1,400$ pounds, $70\%$ completed

$36,907$

Goods finished during August, $27,500$ 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 analysis, and input your answers in the questions below.

Open spreadsheet

a$.$ Prepare a cost of production report, presenting the following computations:

Direct materials and conversion equivalent units of production for August

Direct materials and conversion costs per equivalent unit for August

Cost of goods finished during August

Cost of work in process at August $31$

If an amount is zero, enter in $"0".$ For the cost per equivalent unit, round your answer to the nearest cent.

Morning Brew Coffee Company

Cost of Production Report$-$Roasting Department

$2$ more Check My Work uses remaining.