Please do in excel and show formulas! Thanks!

% N 4 u 7 15. 8 Given the following conditions determine: 9 The inventory shortage or overage %: 0 Retail 1 opening inventory $430,000.00 2 gross purchases $165,000.00 3 returns to vendors $25,000.00 transfers in $11,000.00 5 total merch handled 6 gross sales $125,000.00 7 customer returns $20,000.00 net markdowns $15,000.00 9 employee discounts $2,000.00 0 total retail deductions 1 closing book inventory 2 closing physical inventory $455,000.00 3 shortage /overage $ shortage / overage % 5 8 w N 4 un A 6