please do with deeper analysis and must be in excel

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 can occur the over or under stock. Other data are given in Table 3. 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