Lexington Company produces baseball bats and cricket paddles. It has two departments that process all products. During July, beginning work in process in the finishing department was 40% complete as to conversion. Direct materials for finishing the units are added when the units are 90% complete (90% through the process). Beginning inventories included $30,000 for transferred-in costs and $40,000 for conversion costs. Ending inventory was 60% complete (60% through the process). Additional information about the two departments follows:

	Cutting	Finishing
Beginning work-in-process units	20,000	40,000
Units started/transferred in this period	80,000
Units transferred out this period	70,000	80,000
Ending work-in-process units		30,000
Material costs added this period	$48,000	$34,000
Conversion costs added this period	28,000	68,500
Cost of units transferred out this period	128,000

Required:

Create an excel worksheet with tables and Complete the appropriate cells (i.e., identify the missing information and then complete it) in the production cost worksheet below, using FIFO