A soccer team’s parent company, Lanternyard Inc., determines the prices for match tickets. Let’s assume that there is only one type of ticket for matches in their stadium and that the relationship between the demand D (as the number of persons) and the price for a match ticket (in TL) is described by p = 80 − 0.001 D+ 100000/D. The company has estimated that it has a fixed cost of 54,000 TL per match and a variable cost of 27 TL per person. The stadium has a maximum capacity of 33,500 people.
a) What is the profitable range of demand for each match?
b) Find the profit-maximizing level of demand for each match. What is the ticket price at this level of demand? What is the total profit?
c) How would your answer to parts (a) and (b) change if the stadium had a maximum capacity of 15,000 people?
d) Using Excel, plot total revenue, total cost and total profit on the same chart. Locate and mark the quantities asked in parts (a), (b), and (c) on this chart.
e) Construction/investment mogul Donald McTrump wants to buy this stadium from Lanternyard. Suppose the stadium hosts about 48 matches per year in their stadium, and that the total profit from each match is as you found in part (b). Lanteryard asking price is the capitalized worth of the stadium using a MARR = 1.6% per month. Calculate this price.
f) Perform an Excel analysis of the PW of the stadium versus its “useful life” (with no salvage value). Using the MARR above, plot the PW of the stadium versus its useful life in months. By trial and error, find the value N of the useful life where the increase in the PW by adding one more month is less than (i) 1000 TL, (ii) one ticket price, or (iii) 1 TL. Express your results in years and months for better interpretation.