(Q1) In August of the current year, a car dealer is trying to determine how many cars of the next…

Written by

in

(Q1) In August of the current year, a car dealer is trying to determine how many cars of the next model year to order. Each car ordered in August costs $20,000. The demand for the dealer’s next year models has the probability distribution shown in the first tab of the Excel Template. Each car sells for $25,000. If demand for next year’s cars exceeds the number of cars ordered in August, the dealer must reorder at a cost of $22,000 per car. Excess cars can be disposed of at $17,000 per car. Considering potential delays in restocking and the effects on planning and customer relationships, the car dealer excludes the sales of cars that are reordered from the sales value calculation.
(a)
Use simulation to determine how many cars to order in August, if the goal is to maximize mean profit. Narrow your search from 20 to 40 at increments of 5 cars, i.e., choose from 20, 25, 30, 35, and 40.
(b)
For your optimal order quantity, find a 95% confidence interval for the expected profit. Hint: In order to check whether you develop the right simulation model, the final distribution of the mean profit for different order quantities (20,25,30, 35, 40) should have a similar distribution/pattern as below (Note: you will not get the exact numbers shown in the following plot due to the random number generation):

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *