Question: please help solving this using simquick Example 14: A warehouse A warehouse temporarily holds printers for a chain of computer stores. Trucks from the stores

 please help solving this using simquick Example 14: A warehouse A

please help solving this using simquick

Example 14: A warehouse A warehouse temporarily holds printers for a chain of computer stores. Trucks from the stores arrive periodically to pick up printers. Exactly when pick-ups occur and how many printers are picked up is uncertain because it depends on the demand at the stores. The time between the arrival of each truck can be approximated by an exponential distribution with a mean of 2 days. The number of printers that are requested at each pick-up can be approximated by a normal distribution with a mean of 12 and a standard deviation of 1. The time to receive an order from the factory can be approximated by a normal distribution with a mean of 7 days and a standard deviation of 1 day. The warehouse wants to satisfy at least 90% of the demand from the stores. The warehouse is considering the reorder point scenarios (rows) in the following table. Order Size 120 160 200 80 120 160 200 Reorder Point 50 50 50 50 60 60 60 60 Exercise 14: a. The warehouse estimates that it costs them $.25 per day for every printer held in inventory and costs $300 for every order placed to the factory (regardless of the order size). The warehouse estimates that demand should remain about the same for the next 53 200 days (time units in SimQuick should represent days). For each scenario, run 30 simulations and report the overall mean service level and the estimated total cost. Which scenario would you recommend? Hint: For the Exit in the model, you must enter statistical distributions for both Time between departures" and "Num. objects per departure." b. The warehouse is considering using a different company to transport printers from the factory. The delivery time for this company can be estimated by a normal distribution with a mean of 4 days and a standard deviation of 1 day; however, the fixed cost per order would increase to $500. The warehouse believes this will allow them to significantly lower their reorder point, but will probably require them to increase their order size. For each scenario (row) in the following table, run 30 simulations and report the overall mean service level and the estimated total cost. Would you recommend switching delivery companies and, if so, which scenario would you recommend? Order Size 80 120 160 200 240 Reorder Point 20 20 20 20 20 Example 14: A warehouse A warehouse temporarily holds printers for a chain of computer stores. Trucks from the stores arrive periodically to pick up printers. Exactly when pick-ups occur and how many printers are picked up is uncertain because it depends on the demand at the stores. The time between the arrival of each truck can be approximated by an exponential distribution with a mean of 2 days. The number of printers that are requested at each pick-up can be approximated by a normal distribution with a mean of 12 and a standard deviation of 1. The time to receive an order from the factory can be approximated by a normal distribution with a mean of 7 days and a standard deviation of 1 day. The warehouse wants to satisfy at least 90% of the demand from the stores. The warehouse is considering the reorder point scenarios (rows) in the following table. Order Size 120 160 200 80 120 160 200 Reorder Point 50 50 50 50 60 60 60 60 Exercise 14: a. The warehouse estimates that it costs them $.25 per day for every printer held in inventory and costs $300 for every order placed to the factory (regardless of the order size). The warehouse estimates that demand should remain about the same for the next 53 200 days (time units in SimQuick should represent days). For each scenario, run 30 simulations and report the overall mean service level and the estimated total cost. Which scenario would you recommend? Hint: For the Exit in the model, you must enter statistical distributions for both Time between departures" and "Num. objects per departure." b. The warehouse is considering using a different company to transport printers from the factory. The delivery time for this company can be estimated by a normal distribution with a mean of 4 days and a standard deviation of 1 day; however, the fixed cost per order would increase to $500. The warehouse believes this will allow them to significantly lower their reorder point, but will probably require them to increase their order size. For each scenario (row) in the following table, run 30 simulations and report the overall mean service level and the estimated total cost. Would you recommend switching delivery companies and, if so, which scenario would you recommend? Order Size 80 120 160 200 240 Reorder Point 20 20 20 20 20

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 Finance Questions!