Need help with the excel formulas

1 Optimal Order Quantity with Quantity Discounts 4 Annual Demand Forecast Order cost per order Annual holding rate 3300 $25.00 11% Order Quantity 250 251 350 351 1.00E+99 Price per unit $3.50 $2.50 $1.50 Feasible? EOQ at the highest price point EOQ at the middle price point EOQ at the lowest price point TAIC The Kuantan Corporation purchases a component from a supplier who offers quantity discounts to encourage larger order quantities. The supply chain manager of the company wants to determine the optimal order quantity to ensure the total annual inventory cost is minimized. The company's annual demand forecast for the item is 3,300 units, the order cost is $25 per order, and the annual holding rate is 11 percent. The price schedule for the item is: Order Quantity 1-250 251-350 351 and above Price per Unit ($) 3.50 2.50 1.50