Question

In: Statistics and Probability

Weekly demand for golf balls at the Happy Valley Golf Club pro shop is normally distributed...

  1. Weekly demand for golf balls at the Happy Valley Golf Club pro shop is normally distributed with a mean of 23 cases and a standard deviation of 6.5 cases. The club gets a profit of $24 per case.
  1. Simulate 52 weeks of demand and calculate the average weekly profit.

  1. What is the probability that weekly profit will exceed $500?

How do I do this in Microsoft excel?

Solutions

Expert Solution

For the part (a) we have to simulate 52 sample from N( 23 , 6.52 ). Then take the average of 52 samples. This average will give us the average weekly profit.

R code with outputs :

x=rnorm(52,mean=23,sd=6.5) ## simulating random sample

##... the generated random sample


  20.704169 25.221456 29.272282 14.346871 24.036673 24.340370 20.598006
33.971030 21.741900 41.558686 20.029663 23.666392 20.439161 24.185303
30.651066 16.330701 21.872000 19.914429 17.857747 26.383415 31.898270
18.300568 26.980371 19.337225 23.108444 18.900966 21.952243 29.100218
26.280539 7.181248 20.449257 24.466836 17.086236 16.897833 28.606257
17.616832 24.118150 22.682653 13.329532 22.911879 17.818902 17.638422
23.527078 19.788865 24.629377 25.263527 25.271971 15.779744 22.238125
29.683797 21.513359 24.161373

##..... average

mean(x)

22.60849 ## answer.

Hence the average weekly profit is 22.60849.

(b)

(OR)

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWERS ....***PLEASE SUPPORT ME WITH YOUR RATING...THANK YOU....

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Weekly demand for golf balls at the Happy Valley Golf Club pro shop is normally distributed...
Weekly demand for golf balls at the Happy Valley Golf Club pro shop is normally distributed with a mean of 23 cases and a standard deviation of 6.5 cases. The club gets a profit of $24 per case. Simulate 52 weeks of demand, and calculate the average weekly profit. What is the probability that weekly profit will exceed $500?
Weekly demand at a grocery store for a brand of breakfast cereal is normally distributed with...
Weekly demand at a grocery store for a brand of breakfast cereal is normally distributed with a mean of 850 boxes and a standard deviation of 80 boxes b) What is the probability that weekly demand is: Less than 900 boxes? More than 1020 boxes? Less than 660 boxes or greater than 980 boxes?
A golf equipment manufacturer would like to convince members of a club that its golf balls...
A golf equipment manufacturer would like to convince members of a club that its golf balls travel farther than those of a rival. For the comparison, twelve golfers were randomly selected from the club to each drive a ball from this manufacturer and from the rival. The results show the distance traveled, in yards. The complete set of results is provided below: Should every golfer hit the rival ball first and then the manufacturer’s ball second? Explain your answer. State...
The weekly demand for Papa’s pizzas on a Friday night is a normally distributed random variable...
The weekly demand for Papa’s pizzas on a Friday night is a normally distributed random variable with mean 222 and standard deviation 8. Show your work. Find the probability that demand exceeds 220. Find the probability that demand is between 230 and 245. Find the probability that demand less than 240. Find the value of X for the lowest 25 percent. Suppose the store wants to make sure they are able to meet demand 90% of the time, how many...
Galaxy Manufacturing Company makes golf balls to be distributed and sold at local golf clubs. The...
Galaxy Manufacturing Company makes golf balls to be distributed and sold at local golf clubs. The golf balls have special features that increase distance and speed at the driving range. The company uses a process costing system to accumulate product costs as the golf balls move through the two stages of production: molding the rubber into cases and stamping. All materials are added at the beginning of both molding and stamping processes, while conversion costs are applied evenly throughout the...
OU Country Club is estimated yearly demand schedule for each customer’s in the golf club is...
OU Country Club is estimated yearly demand schedule for each customer’s in the golf club is P = 100-2Q with a constant marginal cost of 20 per customer per play and a yearly fixed cost of $500,000. The marketing manager projected that there are 500 identical customers. They are going to use a two-part pricing strategy, where F is the country club membership and r is a usage charge per customer. (10 points) a) What is the optimal F and...
When the firm "Pro Swing" entered the market for golf balls twoyears​ ago, it kept...
When the firm "Pro Swing" entered the market for golf balls two years ago, it kept the price of its product low to attract customers away from its leading competitor. The firm has now established itself and has a market share of 20 percent. Management is considering a price increase from the current $2.00 per golf ball to $2.50. Jim Walters, the firm's marketing head, believes the price increase will reduce quantity demanded drastically from the current 1,200 units to...
Valley Club is considering adding a miniature golf course to its facility. The course would cost...
Valley Club is considering adding a miniature golf course to its facility. The course would cost $44,000, would be depreciated on a straight-line basis over its 4-year life, and would have a zero salvage value. The estimated income from the golfing fees would be $33,000 a year with $9,000 of that amount being variable cost. The fixed cost would be $6,200. The project will require $3,000 of net working capital, which is recoverable at the end of the project. What...
Valley Club is considering adding a miniature golf course to its facility. The course would cost...
Valley Club is considering adding a miniature golf course to its facility. The course would cost $44,000, would be depreciated on a straight-line basis over its 4-year life, and would have a zero salvage value. The estimated income from the golfing fees would be $33,000 a year with $9,000 of that amount being variable cost. The fixed cost would be $6,200. The project will require $3,000 of net working capital, which is recoverable at the end of the project. What...
The diameter of a brand of tennis balls is approximately normally​ distributed, with a mean of...
The diameter of a brand of tennis balls is approximately normally​ distributed, with a mean of 2.58 inches and a standard deviation of .04 inch. A random sample of 11 tennis balls is selected. Complete parts​ (a) through​ (d) below. a. What is the sampling distribution of the​ mean? A.Because the population diameter of tennis balls is approximately normally​ distributed, the sampling distribution of samples of size 11 will be the uniform distribution. B.Because the population diameter of tennis balls...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT