please give the calculation Excel

1. Calculate the ordering cost, the holding cost and total inventory cost for the current policy. (5)

2. If the management proposes to apply the EOQ, Calculate the ordering cost, the holding cost, and the total inventory cost. Draw the EOQ graph. (10)

3. Compare the order frequency, order interval, average inventory, and total inventory cost between the current policy and EOQ. (5)

4. The supplier offers a 5% discount, if the company purchase up to and above 1,000 units and a 10% discount, if the company purchase up to and above 1,500 units. Should the management take this offer? (10)

Montegut Manufacturing purchase a part for which the annual usage and purchase can be seen in Table 2. Currently, the management policy is to buy the part monthly. This policy ann arrue tha avas ariundar otarl nther Usage