please answer using the excel format

Q1 Perpetual Inventory Using FIFO Beginning inventory, purchase and sales data for portable DVD player April 1 Inventory 75 units 599 10 Sale 58 units 15 Purchase 43 units $103 20 Sale 26 units 24 Sale 14 units 30 Purchase 25 units @ $ 109 b. Based upon the preceding data, would you expect the inventory to be higher or lower using the last-in, first-out method? Purch. Total Cost Qty Sold Sales Unit Cost Sales Total Cost Inv. Qty. Inv. Unit Cost Inv Total Cost Date Qty Purchased Purch. Unit Cost 3 1-Apr 1 2 10-Apr 3 4 5 16 15-Apr 7 18 19 20 20-Apr 21 24-Apr 30-Apr 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 30-Apr Balances