Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please use excel to simulate: 3) joe smith is a

Please use excel to simulate: 3) Joe Smith is a handyman who owns...

70.2K

Verified Solution

Question

Accounting

Please use excel to simulate:

image

3) Joe Smith is a handyman who owns his own plumbing business. In a typical month, the number of service calls that he gets varies according to the following distribution: 18 Number of Calls Probability 15 16 0.3 0.3 17 0.2 19 0.1 0.1 His revenues per service call are normally distributed with a mean of $100 and a standard deviation of $20. His monthly expenses can range between a minimum of $1000 and a maximum of $1500, where all values between the minimum and maximum occur with equal likelihood. a. Simulate Mr. Smith's average monthly profits for 12 months. b. Run 200 replications of the model using a Data Table

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students