Please do this in excel and not on paper, thanks!

60 20 51 Given the following information, calculate the gross cost of merchandise sold: Cost Retail 52 53 opening inventory $164,250.00 $365,000.00 54 gross purchases $83,250.00 $185,000.00 5 returns to vendors $6,750.00 $15,000.00 6 freight $2,500.00 7 total merch handled $243,250.00 $535,000.00 CMU = 8 net sales $150,000.00 cost % = 3 net markdowns $30,000.00 employee discounts $5,000.00 total retail deductions closing book inventory closing physical inventory $320,000.00 gross cost of merch sold