Please use excel or show work. Thank you!

Q7 - Q21. Elliot Co. opened its doors for business on January 1st of 2022. Below is a chart outlining the purchases and sales of inventory for Elliot's first month of business: Date 1/3 1/6 1/9 1/11 1/14 1/15 Event Purchase Inventory Purchase Inventory Sell Inventory Purchase Inventory Purchase Inventory Sell Inventory Units Price 20 $20/unit 8 $25/unit 15 $50/unit 7 $30/unit 9 $40/unit 20 $55/unit Elliot Co. uses the perpetual system to account for its inventory. Please complete the chart below to illustrate how the various accounts will be reported under the FIFO and LIFO and Average Cost cost-flow assumptions for month of January (if there is no value for a cell below, input N/A into that cell): You may round all answers to the nearest dollar. Account FIFO Q7. LIFO Q12. Average Cost Q17. January 2022 Sales Revenue Q8. . Q13. Q18. January 2022 Cost of Goods Sold Q9. Q14. Q19. January 2022 Gross Margin (A/K/A Profit Margin) Q10. Q15. Q20. Inventory at 1/31/2022 Q11. Q16. Q21. LIFO Reserve at 1/31/2022