For the case study, you will use data, graphs, and tables to analyze the emissions of three firms. Each frim...

For the case study, you will use data, graphs, and tables to analyze the emissions of three firms. Each frim is currently emitting 10 parts per million (ppm) per week, so total emissions are 30 ppm per week. Suppose we wish to reduce total emission by 50%, to 15 ppm per week. Analyze the given data and make a recommendation. Your submission should address the following critical elements:

1. Enter the given data and create charts in a spreadsheet tool such as Microsoft Excel

2. Use the data to generate totals for ppm/cost using the equiproportionate reduction formula to decrease emissions.

a). Atomic Air total $/ppm

b). Bppmer total $/ppm

c). CASADE total $/ppm

3. Calculate a decrease using the equimarginal principle and satisfy the equimarginal rule to reduce total emissions by 50%, to 15 ppm per week.

a). Atomic Air total $/ppm

b). Boomer total $/ppm

c). CASDE total $/ppm

4. Compare the data on each firm's equiproportionate reduction to the decrease of the equimarginal principle, including the marginal abatement costs in aggregate.

5. Write recommendations for policy makers with details on each firm.

Here is the data