One simple economic question on EXCEL

profileyassier66
assignment_5.xlsx

Sheet1

Assignment #5
1) 1) The residents of the town ectenia all love economics, and the mayor proposes building an economics museum. The museum has a fixed cost of $2,400,000 and no variable costs. There are 100,000 town residents and each has the same demand for museum visits: QD=10-P, where p is the price of admission.
a)      Graph the museums average total cost curve and its marginal cost curve. What kind of market would describe this museum?
*Price P QD MD TC ATC MC Total Revenue
*Quanity Demanded 0 10 100000 2400000
*Market Demand 1 9 90000 2400000
*Total Cost 2 8 80000 2400000
*Average Total Cost 3 7 70000 2400000
*Marginal Cost 4 6 60000 2400000
Total Revenue 5 5 50000 2400000
6 4 40000 2400000
7 3 30000 2400000
8 2 20000 2400000
9 1 10000 2400000
10 0 0
b)     The mayor proposes financing the museum with a lump-sum tax of $24 and then opening the museum to the public for free. How many times would each person visit? Calculate the benefit each person would get from the museum, measured as the consumer surplus minus the new tax.
C)      The mayor’s anti-tax opponent says the museum should finance itself by charging an admission fee. What is the lowest price the museum can charge without incurring losses? (Hint: find the number of visits and museum profits for prices of 2, 3, 4, and 5.)
d)      For the break-even price you found in part (c) calculate each resident’s consumer surplus. Compared with the mayor’s plan, who is better off with this admission fee, and who is worse off? Explain.
e)      What real world considerations absent in the problem above might provide reasons to favor an admission fee?