'Excel Online Structured Activity: OOQ with Quantity Discounts $2$

The Soon Corporation is a multinational company that purchases one of its crucial components from a supplier that offers quantity discounts to encourage larger order quantities. The supply chain manager of the company, Dr$.$ Mohd Rizaimy Shaharudin, wants to determine the optimal order quantity to minimize the total annual inventory cost. The company's annual demand forecast for the item is $990$ units, its order cost is $$30$ per order, and its annual holding rate is $37$ percent. The price schedule is:

$\backslash$table$[[$Order Quantity,Price per Unit $($$$)],[1-250,5\mathrm{.}50],[251-350,4\mathrm{.}50],[351$ and above,$3\mathrm{.}50]]$

The first break pofint is $251$ units and the second is $351$ units. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations.

X

Open spreadsheet

Questions

What is the first feasible EOQ for this component? Round your answer to two decimal places.

units

Find the total annual inventory costs for the first feasible EOQ and for the price break points at each lower price level. $(251$ units at $$4\mathrm{.}50$ and $351$ units at $$3\mathrm{.}50)$ Round your answers to the nearest cent.

TAICEOQ: $ $$

TAIC ${?}_Q=251$:$ $$

TAIC $=351$:$ $$