If possible to see the solution in excel to clearly see the data please. thank you for your help.

Inventory Costing Methods A Gross Profit Operating Expenses $1,400.00 Gross Profit %== Net income AVERAGE COST Average Cost Per Unit= Cost of Goods Sold=== Ending Inventory ==== Income Statement Sales Cost of Goods Sold Gross Profit Operating Expenses Net Income $1,400.00 Gross Profit %===>