UNITS:
beginning WIP inventory (20% complete as to CC)	5,000
units started	20,000
units completed and transferred out	15,000
ending WIP inventory (Mat 100%, CC 50% complete)	10,000
Costs:
beginning inventory
materials	$ 4,000
CC	$ 1,000
Current period:
materials	$ 16,000
CC	$ 4,000
All materials are added at the beginning of the process

Please show the calculations! doing it in excel!

1. What is your products equivalent units (EUP) for Mat & CC using weighted average? -->	Materials EUP = ?	CC EUP = ?
2. What is your products equivalent units (EUP) for Mat & CC using FIFO? -->	Materials EUP = ?	CC EUP = ?
3. What is your products cost per equivalent unit (EUP) for Mat & CC using weighted average? -->	Materials cost per EUP = ?	CC cost per EUP = ?
4. What is your products cost per equivalent unit (EUP) for Mat & CC using FIFO? -->	Materials cost per EUP = ?	CC cost per EUP = ?
5. What is your products cost of ending WIP inventory using weighted average? -->	End MAT cost in WIP = ?	End CC cost in WIP = ?
6. What is your products cost of ending WIP inventory using FIFO? -->	End MAT cost in WIP = ?	End CC cost in WIP = ?
Check figures:
	weighted average	FIFO
your products total cost (Mat & CC) per equivalent unit is:	$ 1.05	$ 1.01