Question: solve using excel, please show formuals and steps Question 1. Lila Battle has determined that the annual demand for number 6 screws is 170,000 screws.

solve using excel, please show formuals and steps solve using excel, please show formuals and steps
Question 1. Lila Battle has determined that the annual demand for number 6 screws is 170,000 screws. Lila, who works in her brother's hardware store, is in charge of purchasing. She estimates that it costs $13 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the cost of carrying one screw in inventory for a year is three and half cents. Assume that the demand is constant throughout the year. 1.1. How many number 6 screws should Lila order at a time if she wishes to minimize total inventory cost? (1 point) 1.2. How many orders per year would be placed? (1 point) 1.3 What would the annual holding cost be? (1 point) Data Demand rate, D Setup/order cost, Holding cost, Unit price, Answers: 1.1. 1.2. 1.3. Results Optimal order Quantity, Q" Maximum inventory Average Inventory Number of orders Holding cost Setup cost Unit costs Total costs, TC

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!