Hayword, Incorporated uses weighted$-$average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations.

Work in process, beginning:

Units in process

Completion with respect to materials $,300$

Completion with respect to conversion $40\%$

Costs in the beginning inventory:

Materials cost

Conversion cost

Units started into production during the period

$$10,500$

$$6,750$

Costs added to production during the period:

Materials cost.

$6,200$

Conversion cost

$$332,150$ $$407,645$

Work in process, ending:

Units in process

Completion with respect to materials

$450$

Completion with respect to conversion $,40\%$

Required:

Use the data to fill in the following information.

Compute equivalent units.

Compute costs.

Assign costs.

Prepare report.

Navigation:

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.

show work use excel