Question

Can't reach this page Graphing Winter,3 (11p X< | + loads/Graphing%20Winter,39620(1),pdf Graphin&Assignment # 3 The city of Crawfordville, Florida has a very bad problem with the mosquito population from late April through late September almost every year. The City generally sprays the mosquito population to deal with the problem. The data below, collected and maintained by the City of Crawfordville's Finance Department, shows the City's market data for spraying for mosquitoes, The price is measured in us dollars per spraying and both quantities are measured in the number of spraying events per year, from 2002-2015 50 40 6 10 30 80 14 Qd2 60 20 70 12 10 1214 The Rennent ouantirative Grouo, uc, of Davie, Flonida,is a fim that specializes in local data collection. The Rennert Quantitative The firm at the request of the City Council has studied the Crawfordville population and discovered the City derives a positive externality of $20 for every spraying for mosquitoes a. in one clearly and accurately labeled graph, created using Excel, graph the market data as collected by the City Council as well as the market failure that the Rennert Group has discovered. (45 pts) b: Referencing only your graph, what equilibrium price and quantity does the market generate? (3 c. Referencing only your graph, what is the extent of market failure in this situation? What price pts) and quantity are consistert with an efficient levet of spraying? (6 pts) d. Given that there is market failure, provide one solution for how the efficient level of mosquito spraying can be achieved. (6 pts) Grophs for this ossignment must be propery constructed and created using Excel. Prepare your ossignment os a Ward document with embedded Excel charts. Number each step of the assignment.

Answer 1

a let NsCmanginal social cost Np cmasginal pi vate cost Mp R maiginal pri vate Rene t 80 HSC Co 20 20 lo. b The equiliim price is eual to so and l.เกา price is equil huicm antityis eual to p Nankel failure is epual to lo-g2 uni tr P-yo and aie consis tentcoith effcient lewping am P-o, th effrt e of spas could be achieuedinte makeé