Question

Exercise 21-05 a-b In Sunland Company, materials are entered at the beginning of each process. Work in process inventories, with the percentage of work done on conversion costs, and production data for its Sterilizing Department in selected months during 2020 are as follows. Ending Work in Process Beginning Work in Process Conversion Units Cost% Conversion Month 60 January March May July Units Transferred Out 11,600 12,600 15,100 10,200 Units 1,900 4,100 7,140 1,700 0

Answer 1

	January	May
Units to be accounted for
Beginning work in process	-	-
Started into production	13,500	22,240
Total Units	13,500	22,240
Units acounted for
Transferred out	11,600	15,100
Ending work in process	1,900	7,140
Total units	13,500	22,240

Here is the formula version

	January	May
Units to be accounted for
Beginning work in process	0	0
Started into production	=11600+1900	=15100+7140
Total Units	=SUM(D11:D12)	=SUM(E11:E12)
Units acounted for
Transferred out	11600	15100
Ending work in process	1900	7140
Total units	=SUM(D16:D17)	=SUM(E16:E17)

	Material	Conversion Costs
January	13,500	12,740
March	16,700	13,953
May	22,240	20,812
July	11,900	10,999

Here is the formula version

	Material	Conversion Costs
January	=11600+1900	=11600+1900*60%
March	=12600+4100	=12600+4100*33%
May	=15100+7140	=15100+7140*80%
July	=10200+1700	=10200+1700*47%