show excel formulas please

1 Find the net profit or loss as a percentage and the gross margin as a dollar amount 2 3 Gross sales $220,000 4 Customer returns and allowances $15,800 5 Opening inventory at cost $39,000 6 Billed cost of goods $99 600 7 Inward freight $5,200 8 Cash discount $6.100 9 Closing inventory at cost $37,000 10 Payroll $49,000 11 Occupancy $28,500 12 Wrapping and packing $1,250 13 Utilities $2,050 14 Delivery $2,900 15 16 17 18 19 $Cost SRetail 20 Gross sales $220,000 21 Customer returns and allowances $15,000 22 Net Sales $205,000 23 24 Opening inventory at cost $38.000 $38.000 25 Billed cost of goods 599,000 26 Inward freight 5000 27 Cost of goods purchased 28 Total Inventory Handled 29 Closing inventory at cost $36.000 30 Gross Cost of goods sold 31 Cash Discount 56.000 32 Net Cost of Goods Sold 33 Alteration & Workroom costs 34 Total cost of Goods Sold 35 Gross Margin 36 Payroll 48000 37 Occupancy 28000 30 Wrapping and packing 1200 39 Utilities 2000 Delivery 2800 Operating expenses MAO 1 Find the net profit or loss as a percentage and the gross margin as a dollar amount 2 3 Gross sales $220,000 4 Customer returns and allowances $15,800 5 Opening inventory at cost $39,000 6 Billed cost of goods $99 600 7 Inward freight $5,200 8 Cash discount $6.100 9 Closing inventory at cost $37,000 10 Payroll $49,000 11 Occupancy $28,500 12 Wrapping and packing $1,250 13 Utilities $2,050 14 Delivery $2,900 15 16 17 18 19 $Cost SRetail 20 Gross sales $220,000 21 Customer returns and allowances $15,000 22 Net Sales $205,000 23 24 Opening inventory at cost $38.000 $38.000 25 Billed cost of goods 599,000 26 Inward freight 5000 27 Cost of goods purchased 28 Total Inventory Handled 29 Closing inventory at cost $36.000 30 Gross Cost of goods sold 31 Cash Discount 56.000 32 Net Cost of Goods Sold 33 Alteration & Workroom costs 34 Total cost of Goods Sold 35 Gross Margin 36 Payroll 48000 37 Occupancy 28000 30 Wrapping and packing 1200 39 Utilities 2000 Delivery 2800 Operating expenses MAO