Please show formulas so I can learn, thank you :)

IM.84 An outdoor equipment manufacturer sells a rugged water bottle to complement its product line. They sell this item to a variety of sporting goods stores and other retailers. The manufacturer offers quantity discounts per the following discount schedule: Option Plan Quantity Price A 1 - 2,899 $4.75 2,900 - 3,699 $4.30 3,700+ $3.80 B A large big-box retailer expects to sell 8,800 units this year. This retailer estimates that it incurs an internal administrative cost of $230 each time it places an order with the manufacturer. Holding cost for the retailer is $100 per case per year. There are 48 units or water bottles per case.) Based on this information, and not taking into account any quantity discount offers, what is the calculated EOQ (in units)? (Display your answer to the nearest whole number.) 1394 Based on this information, sort each quantity discount plan from left to right by dragging the MOST preferred option plan to the left, and the LEAST preferred option plan to the right: Option Plan C Option Plan B Option Plan A For the MOST preferred option, what will be the annual material cost? (Display your answer to the nearest whole number.) 374310 For the MOST preferred option, what will be the annual ordering cost? (Display your answer to the nearest whole number.) 1452 For the MOST preferred option, what will be the average inventory? (Display your answer to the nearest whole number.) 697 For the MOST preferred option, what will be the total annual inventory cost? (Display your answer to the nearest whole number.) 374310