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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!