Question

In: Statistics and Probability

**SHOW ALL WORK IN EXCEL QM** Problem-5: In the previous problem suppose the sale of football...

**SHOW ALL WORK IN EXCEL QM**

Problem-5:

In the previous problem suppose the sale of football programs described by the probability distribution only applies to days when the weather is good. When poor weather occurs on the day of a football game, the crowd that attends the game is only half of capacity. When this occurs, the sales of programs decreases, and the total sales are given in the following table:

Number (in 100s) of Programs Sold

Probability

12

0.25

13

0.24

14

0.19

15

0.17

16

0.15

Programs must be printed two days prior to game day. The university is trying to establish a policy for determining the number of programs to print based on the weather forecast.

  1. If the forecast is for a 20% chance of bad weather, simulate the weather for ten games with this forecast.
  2. Simulate the demand for programs at 10 games in which the weather is bad.
  3. Beginning with a 20% chance of bad weather and an 80% chance of good weather, develop a flowchart that would be used to prepare a simulation of the demand for football programs for 10 games.
  4. Suppose there is a 20% chance of bad weather, and the university has decided to print 2,500 programs. Simulate the total profits that would be achieved for 10 football games.

Solutions

Expert Solution

Answer:-

Given That:-

The university is trying to establish a policy for determining the number of programs to print based on the weather forecast.

(a)

If the forecast is for a 20% chance of bad weather, simulate the weather for ten games with this forecast.

(b)

Simulate the demand for programs at 10 games in which the weather is bad.

(c)

Beginning with a 20% chance of bad weather and an 80% chance of good weather, develop a flowchart that would be used to prepare a simulation of the demand for football programs for 10 games

(d)

Suppose there is a 20% chance of bad weather, and the university has decided to print 2,500 programs. Simulate the total profits that would be achieved for 10 football games.

if you face any trouble to understand the answer to the problem please mention it in the comment box.
if you are satisfied, please give me a LIKE if possible.


Related Solutions

**SHOW ALL WORK IN EXCEL QM** Problem-4: Every home football game for the past eight years...
**SHOW ALL WORK IN EXCEL QM** Problem-4: Every home football game for the past eight years at Eastern State University has been sold out. The revenues from ticket sales are significant, but the sale of food, beverages, and souvenirs has contributed greatly to the overall profitability of the football program. One particular souvenir is the football program for each game. The number of programs sold at each game is described by the following probability distribution: Number (in 100s) of Programs...
**SHOW ALL WORK IN EXCEL QM** Problem-7: Management of the First Syracuse Bank is concerned about...
**SHOW ALL WORK IN EXCEL QM** Problem-7: Management of the First Syracuse Bank is concerned about a loss of customers at its main office downtown. One solution that has been proposed is to add one or more drive-through teller stations to make it easier for customers in cars to obtain quick service without parking. Chris Carlson, the bank president, thinks the bank should only risk the cost of installing one drive-through. He is informed by his staff that the cost...
Work the following problem in Excel or Excel QM Zoe Garcia is the manager of a...
Work the following problem in Excel or Excel QM Zoe Garcia is the manager of a small office-support business that supplies copying, binding, and other services for local companies. Zoe must replace a worn-out copy machine that is used for black-and- white copying. Two machines are being considered, and each of these has a monthly lease cost plus a cost for each page that is copied. Machine 1 has a monthly lease cost of $600, and there is a cost...
For the Week 5 Problem Set, show all work in an Excel book, labeling each item...
For the Week 5 Problem Set, show all work in an Excel book, labeling each item by the problem number. Save the file in the format flastname_Unit_5_Learning_Activity.xlsx, where flastname is your first initial and your last name, and submit it to the appropriate Dropbox. For full credit, be sure to use appropriate formulas to solve each exercise or problem. Chapter 7 (page 149) 1. Calculate the present value (PV ) of a cash inflow of $500 in one year, and...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
Please solve the following breakeven analysis problem and show all systems of equations and work. (Excel...
Please solve the following breakeven analysis problem and show all systems of equations and work. (Excel solver is not neccessary for this problem) Jim and Pam are going to Culinary School! There are a group of students at the school who are drug dealers, and the Captain has received information that they are looking to start selling a dangerous new street drug to the residents of the town nearby. Jim and Pam infiltrate this group and propose that they use...
show Excel ( show all work including formulars ) As a senior analyst for the company...
show Excel ( show all work including formulars ) As a senior analyst for the company you have been asked to evaluate a new IT software project. The company has just paid a consulting firm $50,000 for a test marketing analysis. After looking at the project plan, you anticipate that the project will need to acquire computer hardware for a cost of $400,000. The Australian Taxation Office rules allow an effective life for the computer hardware of five years. The...
show Excel ( show all work including formulars ) You are considering an investment in the...
show Excel ( show all work including formulars ) You are considering an investment in the stock market and have identified two potential stocks, they are Westpac Banking Corp. (ASX: WBC) and Singapore Airlines Ltd. (SGX: C6L). The historical prices for the past 10 years are shown in the table below. in the table below. Year ASX: WBC SGX: C6L 2009 23.70 13.82 2010 22.85 14.76 2011 21.01 11.1 2012 27.85 10.99 2013 30.66 9.59 2014 34.23 12.65 2015 30.85...
Formulate the problem as a linear programming model use excel and show your excel work. Thank...
Formulate the problem as a linear programming model use excel and show your excel work. Thank you. To (cost, in 100's) From New york Philadelphia Chicago Boston Supply Tampa $9 $14 $12 $17 200 Miami 11 10 6 10 200 Fresno 12 8 15 7 200 Demand 130 170 100 50
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT