Question: Please help solve using excel. Please include steps and formulas. 10 - 34. Jesse's Plumbing Service's monthly demand follows a discrete uniform distribution between 40

Please help solve using excel. Please include steps and formulas.

Please help solve using excel. Please include
10 - 34. Jesse's Plumbing Service's monthly demand follows a discrete uniform distribution between 40 and 55 jobs. The probability that a specific job will be for minor service (e.qg., clogged sink) is 0.65 , and the probability that it will be for a major service (e.g., flooded basement) is 0.35 . Revenues for minor service follow a normal distribution, with a mean of $100 and a standard deviation of $15. For major projects, Jesse estimates that revenues will be S600 with 302 chance, $900 with 40% chance, or $1, 200 with 30% chance. Set up a simulation model for Jesse's problem and replicate it N times to calculate his average monthly revenue solve Using excel. Please include steps and formulas Probilem 10-34 Expected Revenus Mata Table [ [11]

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 Mathematics Questions!