I've seen variations of this problem, but the formulas they are using are not working for me. Any help is appreciated. Thank you in advance!

Cast Iron Grills, Inc., manufactures premium gas barbecue grills. The company reports Inventory and cost of goods sold based on calculations from a LIFO periodic Inventory system. Cast Iron's December 31, 2021, fiscal year-end Inventory consisted of the following (listed in chronological order of acquisition): Units 6,800 4,900 7,800 Unit Cost $ 600 700 800 The replacement cost of the grills throughout 2022 was $900. Cast Iron sold 36,000 grills during 2022. The company's selling price is set at 200% of the current replacement cost. Required: 1. & 2. Compute the gross profit (sales minus cost of goods sold) and the gross profit ratio for 2022 under two different assumptions. First, that Cast Iron purchased 37,000 units and second, that Cast Iron purchased 19,500 units during the year. 4. Compute the gross profit (sales minus cost of goods sold) and the gross profit ratio for 2022 assuming that Cast Iron purchased 37,000 units (as per the first assumption) and 19,500 units (as per the second assumption) during the year and uses the FIFO Inventory cost method rather than the LIFO method. Complete this question by entering your answers in the tabs below. Reg 1 and 2 Reg 4 Compute the gross profit (sales minus cost of goods sold) and the gross profit ratio for 2022 assuming that Cast Iron purchased 37,000 units (as per the first assumption) and 19,500 units (as per the second assumption) during the year and uses the FIFO inventory cost method rather than the LIFO method. (Round "Gross profit ratio answer to 1 decimal place (i.e. 0.123 needs to be entered as 12.3%.)) Show less Gross Profit Purchased Units 37,000 19,500 Gross Profit Ratio % %