Santosh 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:

1.Data should be input in the sheet

DATA SECTION
Company Name	St. John's Corporation
Department
Period Ending
Cost Flow					Enter 1 or 2 in Cell B15
					1=FIFO	2=AVERAGE COST
		Percentage Complete				Dollars of Cost
		Prior	Direct	Direct	Manufacturing	Prior	Direct	Direct	Manufacturing
	Physical	Department	Materials	Labor	Overhead	Department	Materials	Labor	Overhead
	Units	Costs	Costs	Cost	Cost	Costs	Cost	Cost	Cost
Beginning WIP
United Started
Units Completed
Current Period
Costs
Normal Spoilage
(Units) OR
(Percentage of
Good Units)
Ending WIP