The gentry garden center sells 90,000 bags of lawn fertilizer annually. The optimal safety stock (which is on hand initially) is 1000 bags. Each bag cost the firm $1.50, inventory carrying costs are 20%, and the cost of placing an order with its supplier is $15.
a. What is the economic ordering quantity?
b. What is the maximum inventory of fertilizer?
c. What will be the firms average inventory?
d. How often must the company order?
Please do the questions in EXCEL so i can see the work!
