Chief Troy Company manufactures chemical additives for industrial applications. As the new

cost accountant for Chief Troy, you have been assigned the task of completing the production

cost report for the most recent period. Chief Troy uses the weighted average cost method of

process costing. The following information pertains to the most recent period:

Required:

Prepare a complete production report for the period using the weighted average cost method.

$($Round the cost per equivalent unit to three decimal places; round the costs in the cost report to

the nearest dollar.$)$

This needs to be done in excel, so please show all formulas$/$calculations so I can understand and learn it$.$ Thank you!