Question: Need help setting up the excel file for the Monte Carlo simulation problem below: A soon-to-graduate business student is considering starting his own information systems
Need help setting up the excel file for the Monte Carlo simulation problem below:
A soon-to-graduate business student is considering starting his own information systems consulting business. In assessing the market, he has categorized potential projects into five groups, with expected frequencies and time durations shown below:
| Project Type | Frequency | Time Duration |
| Minor | 30% | 0.5 to 3.0 hours |
| Small | 35% | 3 to 10 hours |
| Medium | 20% | 10 to 25 hours |
| Large | 10% | 25 to 35 hours |
| Major | 5% | 35 to 50 hours |
He estimates that the total number of projects per week, based on surveying similar firms in comparable cities, has the following distribution:
| Number of Projects per week | Probability | ||
| Consulting fee $50/hour | $60 | $70 | |
| 0 | 4% | 8% | 13% |
| 1 | 7% | 8% | 13% |
| 2 | 10% | 11% | 17% |
| 3 | 15% | 16% | 24% |
| 4 | 21% | 20% | 15% |
| 5 | 15% | 16% | 8% |
| 6 | 10% | 8% | 4% |
| 7 | 7% | 6% | 3% |
| 8 | 5% | 4% | 2% |
| 9 | 6% | 3% | 1% |
Monthly expenses are estimated to be $2300, and he would like to have an annual income that compares with his graduating classmates; that is, at least $75,000. Determine the potential profitability of this business if the hourly consulting rates charged are $50, $60, or $70.
Each group studies the profitability problem, use Excel to build a simulation model in order to solve this profitability problem.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
