Please show me the steps to answer this in excel.

Thanks! :)

The 3 Broomsticks makes the world's best Butterbeer! Information about January and February 2024 is as follows: Note: the ingredients are added at the beginning and then it takes 4 days to heat, cool and stir the drink January 31st 2024 During February REQUIRED: Work in process 40,000 gallons complete with respect to materials 1/4 complete with respect to conversion Work in process $155,000 $80,000 material ($2 per gallon) $75000 conversion material added 220,000 gallons $440,000 ($2 per gallon) conversion costs $999,000 On February 29th work in process 60,000 gallons 1/2 complete with respect to conversion A) USING WEIGHTED AVERAGE PROCESS COSTING DETERMINE A1) FINISHED GOODS FEBRUARY A2) WORK IN PROCESS FEBRUARY 29TH B) USING FIFO PROCESS COSTING DETERMINE 81) FINISHED GOODS STARTED JANUARY FINISHED FEBRUARY 82) FINISHED GOODS STARTED AND ENDED IN FEBRUARY 83) WORK IN PROCESS FEBRUARY 29TH (IN DOLLARS) (IN DOLLARS)