Stone Company produces carrying cases for CDs. It has compiled the following information for the month of June:

	Physical Units	Percent Complete for Conversion
Beginning work in process	66,000	65%
Ending work in process	90,000	80

Stone adds all materials at the beginning of its manufacturing process. During the month, it started 176,000 units. Required: 1. Using the FIFO method, reconcile the number of physical units.

	Physical Units		Physical Units
Beg. Units		Units Compl.
Unit Started		Ending Units
Total

2. Using the FIFO method, calculate the number of equivalent units.

	Equivalent Units
	Physical Units	Direct Materials	Conversion
Beginning Inventory
Started and Completed
Ending Inventory
Total Unit

*Can you please show the result in excel format and the formula to help with understanding the problem?