So the work will be in Excel and needs to be show the formulas for how I got the work.

8-37. Compute Costs per Equivalent Unit: Weighted-Average Method ( LO 8-2, 3) The following cost information is available for July for the Crest Plant at Calvert Company: Materials are added at the beginning of the proeess. The following quantities have been recorded: - Beginning inventory, 40,000 partially complete gallons, 25 percent complete with respect to conversion costs. - Units started in July, 80,000 gallons. - Units transferred out in July, 90,000 gallons. - Ending inventory, 30,000 gallons, 40 percent complete with respect to conversion costs. Compute the cost per equivalent unit for direct materials and conversion costs for July using the weighted-average method. 8-38. Assign Costs to Goods Transferred Out and Ending Inventory: Weighted-Average Method ( LO 8-2, 3) Refer to the data in average method. 8-39. Compute Costs per Equivalent Unit: FIFO Method ( 8-2, 5) Refer to Exercise 8-37. Compute the cost per equivalent unit for direct materials and for conversion costs for July using the FIFO method. 8-40. Assign Costs to Goods Transferred Out and Ending Inventory: FIFO Method ( LO 8-2, 5) Refer to the data in Exercise 8-37. Compute the cost of goods transferred out and the ending inventory for July using the FIFO method. Complete Exercises 8-39 and 8-40 in Excel (FIFO method only), using Excel functionality - no points will be given for just typing in numbers that should be formulas