Solve on Excel if possible!

a. How many units were started AND completed? Completed?

b. Using FIFO, calculate equivalent units produced

c. Using your answer in b. what is the total material cost added this month?

d. Using FIFO, calculate the cost per equivalent unit produced.

e. Using FIFO, calculate the cost per equivalent unit produced.

f. Using FIFO, what are the unit costs? (hint: you should have 2 numbers)

g. Using Weighted Average, calculate equivalent units of production.

h. Using Weighted Average, what is the cost per equivalent unit of production.

i. Using Weighted Average, what is the journal entry for transferred to finished goods?

j. Using Weighted Average, what is the cost per unit?

Process Costing (50 points) Our company manufactures Chemical X. Assume the company uses weighted average. Separate direct materials and conversion costs. Chemical X is comprised of two liquids, Liquid A and Liquid B. The formula of Chemical X is 60% Liquid A, 40% Liquid B. 75% of the mixed liquid is added at the beginning of the process; 25% is added at the very end, This month, the liquid mix costs $42 per gallon, At the beginning of the month, there was 1,000 gallons in process, 75% through the process. The total costs in beginning WIP is $20,875 for materials and $20,975 for conversion costs. During the month, 10,000 gallons were started. Conversion costs were $343,000 for the month. Compute direct material costs (hint use DM EUP under FIFO) At the end of the month, there were 1,500 gallons in process, 70% through the process