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

Retail $80,000.00 $65,000.00 $12,000.00 $30,000.00 146 147 13 148 Given the following information calculate: Value 149 B. gross cost of merch sold: 150 Cost 151 opening inventory $38,400.00 152 gross purchases $31,200.00 153 returns to vendors $5,760.00 154 net transfers in $14,400.00 55 freight $2,000.00 56 total merch handled 57 net sales 58 net markdowns 59 employee discounts 50 total retail deductions 51 clsoing book inventory 2 closing physical inventory 3 inventory shortage 4 gross cost of merch sold CMU = $75,000.00 cost % = $12,000.00 $0.00 $73,000.00