n August of the current year, a car dealer is trying to determine how many...
60.1K
Verified Solution
Link Copied!
Question
Finance
n 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 dealers next year models has the probability distribution shown in the file S10_12.xlsx. Each car cells for $25,000. If demand for next years 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. Use simulation to determine how many cars to order in August. For your optimal order quantity, find a 95% confidence interval for the expected profit. Distribution of demand Demand Probability 20 0.30 25 0.15 30 0.15 35 0.20 40 0.20
PLEASE ANSWER IT STEP BY STEP ONLY THANK YOU.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!