Question: Project Type Frequency Project Time (Uniform Distribution) Minor, s1 0.3 0.5 to 3.0 hours Small,s2 0.35 3 to 10 hours Medium,s3 0.2 10 to 25
|
| |||||||||||||||||||||||||||||||||||||||||||||||
Monthly expenses are estimated to be $2300, and your team would like to have an annual income (before tax) at least $75,000. Determine the potential profitability of this business if the hourly consulting rates charged are $50, $60, or $70. Use Excel to build a Monte Carlo simulation model to solve this profitability problem. How can I solve this for profitability? What equation should I use?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
