I need by Excel program

Inventory Valuation - Perpetual Inventory System Arab Trading Establishment uses the perpetual Inventory system and had the following transactions for the month of August. Price per Unit Total (in Transaction Date Units OMR) (in OMR) 100 5.00 500.00 1Aug Beginning Inventory 5.85 75 438.75 10- Aug Purchase 15-Aug 150 930.00 Purchase 6:20 21-Aus Sales (at retail price 285 12.00 3,420.00 Purchase 130 6.60 24-Aug 858.00 27.Aug Sales at retail price) 100 12.50 1,250.00 Required: 1. Compute total goods available for sale in units and in riyals) 2 Compute total sales in units and in riyals) Compute the ending inventory in units. 4 Compute the cost of goods sold and ending inventory using 8. FIFO Perpetual b. LFO Perpetual Moving Average S. Compute gross profit using FIFO Perpetual b. LFO Perpetual Moving Average