Share via

Microsoft Monte Carlo Simulation Problem

Anonymous
2022-04-20T16:57:02+00:00
  1. A GMC dealer believes that demand for 2005 Envoys will be normally distributed with a mean of 200 and standard deviation of 30. His cost of receiving an Envoy is $25,000, and he sells an Envoy for $40,000. Half of all the Envoys not sold at full price can be sold for $30,000. He is considering ordering 200, 220, 240, 260, 280, or 300 Envoys. How many should he order?
Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-21T07:16:10+00:00

    Hi Marcomastrandrea,

    To know about this function please see Introduction to Monte Carlo simulation in Excel (microsoft.com)

    I also found a video about this function:

    https://www.youtube.com/watch?v=HwVBi--mE4M

    Regards,

    Neha

    Was this answer helpful?

    0 comments