on excel

Ruestion 1. ila Battle has determined that the annual demand for number 6 screws is 100,000 screws. Lila, who works in her rother's hardware store, is in charge of purchasing. She estimates that it costs $10 every time an order is placed. This Jost includes her wages, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the Lost of carrying one screw in inventory for a year is two and half cents. Assume that the demand is constant throughout he year. 1. How many number 6 screws should Lila order at a time if she wishes to minimize total inventory cost? (1 point) .2. How many orders per year would be placed? (1 point) 3 What would the annual holding cost be? (1 point) Data Demand rate, D Setup order.costs Holding cos Unit price, Answers: 1.1. 1.2. 1.3. Results Optimal order Quantity Maximum inventory Averare inventory Number of orders Holdin.COM Setup cost Unit costs Total costs, TC