Specifics Amount $($$$)$

Inventory in process, April $1,7,000$ gallons:

Direct materials cost, for $7,000$ gallons $7,000$

Conversion costs, for $7,000$ gallons, $70\%$ completed $3,225$

Total inventory Costs processed in April $10,225$

Direct materials cost for April, $62,000$ gallons $68,000$

Direct labor cost for April $12,500$

Factory overhead applied for April $9,275$

Total production cost to account for $100,000$

Gallons transferred to Packaging in April $($includes units in process on April $1),64,000$ gallons $?$

Inventory in process, April $30,5,000$ gallons, $25\%$ conversion costs $?$

Requirements

a$.$ Turn in EXCEL file using FORMULAS to complete the cost sheet. $(50$ points$)$