HELP: Im not sure how to enter data into excel.

Fields Company has two manufacturing departments, Forming and Painting. The company uses the weighted average method and reports the following unit data for the Forming department. Units completed in the Forming department are transferred to the Painting department.

Units Direct Materials Conversion

Percent Complete Percent Complete

Beginning work in process inventory $25,00060\%40\%$

Units started this period $300,000$

Completed and transferred out $295,000$

Ending work in process inventory $30,00080\%30\%$

Production cost information for the Forming department follows:

Beginning work in process

Direct materials $ $44,800$

Conversion $15,300$ $ $60,100$

Costs added this period

Direct materials $1,231,200$

Conversion $896,7002,127,900$

Total costs to account for $ $2,188,000$

Required:

Calculate the equivalent units of production for both direct materials and conversion for the Forming department.

Calculate the costs per equivalent unit of production for both direct materials and conversion for the Forming department.

Using the weighted average method, assign costs to the Forming department$$s output$$specifically$,$ its units transferred to Painting and its ending work in process inventory.