Each variable and solution must be clearly indicated on the excel worksheet, do not just solve the question, clearly define each variable and comment on the objective function and sensitivity analysis (explain each resulting sensitivity analysis page). Sensitivity analysis pages without your comments will not be graded.

1. Wyoming Electric Coop owns a steam-turbine power-generating plant. Because W yoming is rich in coal deposits, the plant generates its steam from coal. 11 lis, however, may result in emission that does not meet the Environmental Protection Agency standards. EPA regulations limit sulfur dioxide discharge to 2000 parts per million per ton of coal burned and smoke discharge from the plant stacks to 20lb per hour. The Coop receives two grades of pulverized coal, C1 and C2, for use in the steam plant.The two grades are usually mixed together before burning. For simplicity, it can be assumed that the amount of sulfur pollutant discharged (in parts per million) is a weighted average of the proportion of each grade used in the mixture. The following data are based on consumption of 1 ton per hour of each of the two coal grades. (a) Determine the optimal ratio for mixing the two coal grades. (b) Determine the effect of relaxing the smoke discharge limit by 1lb on the amount of generated steam per hour