2.You have collected the following data on output and total variable costs:

Q TVC ($)

10 24,450

20 39,600

30 48,150

40 52,800

50 56,250

60 61,200

70 70,350

80 86,400

90 112,050

100 150,000

a.Identify the range of output exhibiting increasing returns (increasing MP), and the range exhibiting diminishing returns (decreasing MP).

b.Current fixed costs for the company equal $14,300. Draw two graphs, both with Q on the horizontal axis: one graph shows TVC and TC, and the other shows AVC, AC, and MC.

c.Suppose that the government imposes a $11,500 property tax hike on all businesses; how will that affect your two graphs; i.e., which cost curves will be affected and how?

d.Suppose instead that the government considers your production process to be polluting, and imposes a $210 tax per unit produced (replacing the property tax in the previous question). How does this tax increase compare to the property tax increase, in terms of the effect on your company's cost curves?

e.Your boss says "either of these taxes is going to force us to change our production levels." Given what you know about optimization analysis, how would you respond?

Please explain in details with rules in excel and provide the graph image