If you can please put the answer in an excel format and take a picture.

The following is the inventory record of widgets for the ABC Company: Units Cost/Unit 1/1 Beginning Inventory 100 $ 10.00 4/15 Purchase 200 $ 11.00 8/24 Purchase 300 $ 12.00 11/27 Purchase 400 $ 13.00 At the end of the fiscal year, the physical inventory found 450 widgets on hand at 12/31. Total sales for the year were 500 widgets sold at a retail price of $20.00 per widget. REQUIRED a) Calculate the ending inventory value under each of the following inventory methods: i. FIFO ii. LIFO ini. Weighted Average b) Calculate the gross profit for each of the inventory methods