Use Excel spreadsheet

(25 points) Develop an EOQ calculator for the economic order quantity problem with zero lead times no backorders or lost sales. Your calculator should take as input the financial parameters h,k and c, the demand rate , the possibly finite production rate . The required outputs are: (a) The time average inventory level I as a function of Q. (b) The fixed ordering cost per unit time. (c) The total replenishment cost (including variable ordering cost) per unit time. (d) The optimal order quantity Q