Construction of new stadium for major league baseball team

Assignment Help Financial Management

Reference no: EM131849228

Preliminary plans are under way for the construction of a new stadium for a major league baseball team. City officials have questioned the number and profitability of the luxury corporate boxes planned for the upper deck of the stadium. Corporations and selected individuals may buy the boxes for $100,000 each. The fixed construction cost for the upper deck area is estimated to be $1,500,000 with a variable cost of $50,000 for each box constructed.

1. Use the data table tool in Excel (Data > What-If-Analysis > Data Table) to calculate the profit realized when s = 40 and Qvaries from 0 to 60 in increments of 5, i.e. Q = 0, 5, 10, 15, etc. and then use the graph wizard to graph the profit line as a function of Q. (you can cope your excel table to answer this question.)

A reliable sales forecast has been obtained indicating that City officials would be able to sell 40 boxes. However, the City officials are concerned that this conclusion might change if more accurate estimates were available for the fixed cost of construction, the marginal construction cost, and the unit revenue for each box. Therefore, before a final decision is made, management wants sensitivity analysis done on these cost/revenue estimates. Use the spreadsheet you developed in part c and use the goal seek command and/or data table features in Excel to perform the following sensitivity analysis. Note: Parts (e), (f), and (g) are independent of each other and each part refers to the original data.

2. How large can the fixed cost of construction before this project ceases to be profitable?

3. How large can the marginal construction cost be before this project ceases to be profitable?

4. How small can the unit revenue for each box be before this project ceases to be profitable?

Reference no: EM131849228

Questions Cloud

What is the lowest score someone can get : Everyone who scores in the top 30% of the distribution gets a certificate. What is the lowest score someone can get and still earn a certificate?

What did you observe about how social the person is : The purpose of this assignment is to recognize the concepts we have studied, at work in real life, in your observations of an adult or elderly person's daily.

What is the probability that the fisher chosen : What is the probability that the fisher chosen from Clearwater had a license and the fisher chosen from Mountain View did not have a license?

Define overextension and describe running commentaries : What can give a teacher insight into children's language behavior? How many new words might a preschooler acquire each day?

Construction of new stadium for major league baseball team : Preliminary plans are under way for the construction of a new stadium for a major league baseball team.

How many ways can allan arrange : In how many ways can Allan arrange the 9 songs on the? CD?Allan can burn the 9 songs on the CD in ____ different ways.

Summarize the characteristics of culturally relevant teacher : Describe the problem from Jeff Bliss's perspective as well as from Ms. Phung's perspective. Explain what probably caused it.

What is the probability that a randomly selected worker : What is the probability that a randomly selected worker primarily drives a van or takes public transportation to? work?

How would you defend your argument : Select an argument FOR or AGAINST either euthanasia or physician-assisted suicide. How would you defend your argument? and give example of which one is the most

User Account

All Pages