Question: Problem 3 140 points]: Computco sells personal computers. The demand for its computers during a month follows a normal distribution, with a mean of 400

Problem 3 140 points]: Computco sells personal

Problem 3 140 points]: Computco sells personal computers. The demand for its computers during a month follows a normal distribution, with a mean of 400 and standard deviation of 100. Each time an order is placed, costs of $600 per order and $1500 per computer are in- curred. Computers are sold for $2800, and if Computco does not have a computer in stock, the customer will buy a computer from a competitor. At the end of each month, a holding cost of $10 per computer is incurred. Orders are placed at the end of each month, and they arrive at the beginning of the next month. Four ordering policies are under consideration: Policy 1 Place an order for 900 computers whenever the end-of-month inventory is 50 or less. Policy 2: Place an order for 600 computers whenever the end-of-month inventory is 200 or less. Policy 3: Place an order for 1000 computers whenever the end-of-month inventory is 400 or less. Policy 4 Place an order for 1200 computers whenever the end-of- month inventory is 500 or less. Please develop a simulation model by Excel built-in tools or Crystal Ball and run 1000 itera- tions of the model to determine which ordering policy maximizes Computco's expected profit for a 2-year period. To get a more accurate idea of expected profit, you can credit Computco with a salvage value of $1500 for each computer left at the end of the last month. Assume that 400 computers are in inventory at the beginning of the first month

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!