Question: The monthly demand for the latest computer at Newland Computers follows a normal distribution with a mean of 3 5 0 and standard deviation of

The monthly demand for the latest computer at Newland Computers follows a normal distribution with a mean of 350 and standard deviation of 75. Newland purchases these computers for $1,200 and sells them for $2,300. It costs the company $100 to place an order and $12 for every computer held in inventory at the end of each month. Currently, the company places an order for 1,000 computers whenever the inventory at the end of a month falls below 100 units. Assume the beginning inventory is 400 units, unmet demand in any month is lost to competitors, and orders placed at the end of one month arrive at the beginning of the next month. a. Create a spreadsheet model to simulate the profit the company will earn on this product over the next 2 years. What is the average level of profit the company will earn? b. Suppose the company wants to determine the optimum reorder point and order quantity. Which combination of reorder point and order quantity will provide the highest average profit over the next 2 years?

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!