explain how to do it PLEASE STEP

BY STEP EXCEL

Economic ordering quantity (L07-5) 13. Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 49,000 units per year, an ordering cost of $8 per order, and carrying costs of $1.60 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? C. What will the average inventory be? d. What is the total cost of ordering and carrying inventory? Economic ordering quantity (L07-5) 14. (See Problem 13 for basic data.) In the second year, Fisk Corporation finds that it can reduce ordering costs to $2 per order but that carrying costs stay the same at $1.60 per unit. Also, volume remains at 49,000 units per year. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory