Consulting

Results 1 to 3 of 3

Thread: Market Survey Monte Carlo

  1. #1
    Problem
    A market survey company wants to study the investment in a detergent factory based
    on three factors. These factors are
    Independent of each other. The probability distribution of each are

    Annual Demand Profit/Unit Required Investment
    Units Probability Rs. Probability Rs. Probability
    20 0.05 3.00 0.10 1,750.00 0.25
    25 0.10 5.00 0.20 2,000.00 0.50
    30 0.20 7.00 0.40 2,500.00 0.25
    35 0.30 9.00 0.20
    40 0.15 10.00 0.10
    45 0.15
    50 0.05

    Use Monte-Carlo simulation for 1000 iterations and estimate the ROI percentage based on profit
    {(Profit*Demand)/Investment}

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Did you try the addin mentioned in the thread you originally hijacked?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    Homework?
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •