Please answer with excel formulas showing. Screenshots work perfectly!

order instead of the EOQ. What impact will the 100-unit 3. You're a buyer for fictional Quality Kitchen Appliances. The store has a demand for 1,000 toaster ovens per year. The cost of each toaster oven is US$78. The ordering cost is US$100 per order. The holding cost is 40% of the cost the oven per unit per year. a. What is the optimal order quantity? b. How many orders will be placed per year? c. What is the total annual cost (in U.S. dollars)? d. If the holding cost decreases to 30% of the unit cost of the oven, what effect will it have on EOQ and the total annual cost? e. Suppose the store manager purchases 100 ovens per order size have on the firm's total annual cost