Virginia Tech operates its own power generating plant. The electricity generated by this plant supplies power to the university and to local businesses and residences in the Blacksburg area. The plant burns three types of coal, which produce steam that drives the turbines that generate the electricity. The Environmental Protection Agency (EPA) requires that, for each ton of coal burned, the emissions from the coal furnace smoke stacks contain no more than 2500 parts per million (ppm) of sulfur and no more than 2.8 kilograms (kg) of coal dust. The following table summarizes the amounts of sulfur, coal dust, and steam that result from burning a ton of each type of coal.

Coal	Sulfur (in ppm)	Coal Dust (in kg)	Pounds of Steam
1	1100	1.7	24000
2	3500	3.2	36000
3	1300	2.4	28000

The three types of coal can be mixed and burned in any combination. However, there are only 400 tons of Coal 1, 1300 tons of Coal 2, and 500 tons of Coal 3 available for mixing. What is the maximum number of pounds of steam can you generate given these quantities? Are all three quantities of coal completely consumed?

A. Formulate an LP for this problem.

B. Solve it in Excel. Indicate how much coal of each type is used in the blend.

C. How many pounds of steam are generated?