Question

In: Statistics and Probability

**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 Sold

Probability

23

0.15

24

0.22

25

0.24

26

0.21

27

0.18

Historically, Eastern has never sold fewer than 2,300 programs or more than 2,700 programs at one game. Each program costs $0.80 to produce and sells for $2.00. Any programs that are not sold are donated to a recycling center and do not produce any revenue.

  1. Simulate the sales of programs at 10 football games. Use the random number table.
  2. If the university decided to print 2,500 programs for each game, what would the average profits be for the 10 games simulated in part (a)?
  3. If the university decided to print 2,600 programs for each game, what would the average profits be for the 10 games simulated in part (a)?

Solutions

Expert Solution

if any quire's please comment below and rate by thumb up Thank you


Related Solutions

**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...
**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...
SHOW ALL WORK At the end of each of the past 14 years, Vanessa deposited $450...
SHOW ALL WORK At the end of each of the past 14 years, Vanessa deposited $450 in an account that earned 8 percent compounded annually. (a) How much is in the account today? (b) How much would be in the account if the deposits were made at the beginning each year rather than at the end of each year?
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...
For the Chapter 4 problems, show all work in an Excel book, labeling each item by...
For the Chapter 4 problems, show all work in an Excel book, labeling each item by the problem number. Save the file in the format flastname_Unit_1_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. Star Inc. has Year 1 revenues of $80 million, net income of $9 million, assets of $65 million, and equity of $40...
For the Chapter 4 problems, show all work in an Excel book, labeling each item by...
For the Chapter 4 problems, show all work in an Excel book, labeling each item by the problem number. Save the file in the format flastname_Unit_1_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. Star Inc. has Year 1 revenues of $80 million, net income of $9 million, assets of $65 million, and equity of $40...
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...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT