Please do question in Excel and not on paper, Thanks!

86 87 9. 88 Given the following conditions determine: 89 A. Is there an inventory shortage or overage? 90 B. The inventory shortage or overage %: 91 Retail 92 opening inventory $325,000.00 93 gross purchases $ 165,000.00 34 returns to vendors $25,000.00 35 transfers in $10,000.00 26 total merch handled 27 gross sales $125,000.00 28 customer returns $20,000.00 29 net markdowns $15,000.00 DO employee discounts $2,000.00 01 total retail deductions 02 closing book inventory 3 closing physical inventory $350,000.00 4 shortage /overage $ 05 shortage /overage % 26