A 1 Problem data B C D E F G H I J K L M 2 Unit cost 3 Selling price 4 Salvage value $25 per shirt $50 per shirt $10 per shirt 5 Shortage cost $15 per shirt 10 11 12 14 15 16 61890723456 7 Order quantity 9 Demand Regular sales Leftover Shortage Regular revenue Salvage revenue Purchase cost Shortage cost Profit Probability 500 $2,500 $1,250 $1,250 10% 750 $7,500 $3,750 $3,750 20% 1000 $20,000 $10,000 $10,000 40% 1250 $12,500 $6,250 $6,250 20% 1500 $7,500 $3,750 $3,750 10% Part a: enter formulas in B10:110 and copy and paste to rows 11-14. Part b Expected profit