this is cost accounting. please show calculation for me. it is so necessary, thank you

St.John's corporation produces a single product that is manufactured in two departments, Assembly and Finishing. Units of Product are started in the Assembly Department and then transferred to the Finishing Department, where they are completed. Units are inspected for spoilage in the Finishing Department exactly halfway through the production process. If spoilage is detected at this time,the spoiled units are removed from production and scrapped. Good units are transferred to finished goods inventory, normal spoilage is charged to good units completed, and abnormal spoilage is charged as a period expense to the income statement. Normal spoilage is expected to be 10% of the good units transferred to finished goods inventory during the month.

At the end of June, 12,000 units were still in process in the Finishing Department, 40% complete as to materials and 30% complete as to conversion costs. During July, 25,000 units were transferred from the Assembly Department to the Finishing Department, and 28,500 were transferred from the Finishing Department to finished goods inventory. At the end of July, the Finishing Department still had 4,500 units in process, 60% complete as to materials, and 40% complete as to conversion costs. Cost data related to July operations for the Finishing Department is provided below. Manufacturing overhead is applied to production in the Finishing Department at the rate of 120% of direct labor cost. Beginning Inventory: Cost From Preceding Department:$65,000 Direct Materials:12,000 Direct Labor:30,000 Current Period Costs: Costs From Preceding Department:76,200 Direct Materials:80,400 Direct Labor:227,000

Required:

Cost Summary Schedule

RESULT SECTION
COMPANY NAME
DEPARTMENT NAME
COST OF PRODUCTION REPORT--COST FLOW METHOD USED
FOR TIME PERIOD INVOLVED
		Prior
	Total	Department	Direct	Direct	Manufacturing
	Costs	Costs	Materials	Labor	Overhead
Costs Accounted For:
Cost of Units Completed:
Beginning WIP
To Complete Beginning WIP
Units Started and Completed During Current Period
Normal Spoilage
Total Cost of Units Completed and Transferred Out
Abnormal Spoilage
Ending WIP
Total Costs Accounted For