please show the formulas for everything and excel coordinates thank you

M N 0 ordering costs are $96. The following price schedule applies. Determine the following CALCUL A 10,000 or more M Jx B D J A mail-order house uses 18.000 boxes a year. Carrying costs are 60 cents per bot year, and The optimal order quantity The number of orders per year 8 9 10 Number of Boxes Price per Box 11 12 13 1,000 to 1,999 $1.25 14 15 2,000 to 4.999 1.20 16 5,000 to 9,999 1.15 17 18 1.10 19 20 halets and rings. The supplier quotes a price 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 AF B