COMPLETE USING EXCEL

SHOWING FORUMLAS

In 2. (25 points) You are analyzing consultation with y Value). ng various programs to reduce water pollution from poultry operations. programs our staff, you have developed the following matrix of effects (wher TAX 80 15 1,500 1.2 67 STANDARD STANDARD STANDARD POLLUTION PV TOTAL COST (S MILLION) ANNUAL PLANT COSTS (S MILLION) FOOD PROCESSING JOBS LOST TONS OF BOD REDUCED (MILLIONS) S/TON OF BOD REMOVED 225 22.5 2,200 1.5 150 150 50 1,650 1,200 0.8 60 80 70 100 130 PV TOTAL BENEFITS (S MILLION) present value of each alternative? Which alternative has the highest net benefits? efit-cost ratio for each alternative. Which alternative has the highest benefit-cost a. What is the net of e ratio? c. Which alternative gives the "biggest bang for the buck" -that is, has the lowest cost per ton of pollution removed