Could you slove this using Python instead of Excel Please, thank you.

31. 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 2,500 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. The three types of coal can be mixed and burned in any combination. The resulting emission of sulfur or coal dust and the pounds of steam produced by any mixture are given as the weighted average of the values shown in the table for each type of coal. For example, if the coals are mixed to produce a blend that consists of 35% of coal 1,40% of coal 2 , and 25% of coal 3 , the sulfur emission (in ppm) resulting from burning one ton of this blend is: 0.351,100+0.403,500+0.251,300=2,110 The manager of this facility wants to determine the blend of coal that will produce the maximum pounds of steam per ton without violating the EPA requirements. a. Formulate an LP model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver. c. What is the optimal solution? d. If the furnace can burn up to 30 tons of coal per hour, what is the maximum amount of steam that can be produced per hour? 31. 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 2,500 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. The three types of coal can be mixed and burned in any combination. The resulting emission of sulfur or coal dust and the pounds of steam produced by any mixture are given as the weighted average of the values shown in the table for each type of coal. For example, if the coals are mixed to produce a blend that consists of 35% of coal 1,40% of coal 2 , and 25% of coal 3 , the sulfur emission (in ppm) resulting from burning one ton of this blend is: 0.351,100+0.403,500+0.251,300=2,110 The manager of this facility wants to determine the blend of coal that will produce the maximum pounds of steam per ton without violating the EPA requirements. a. Formulate an LP model for this problem. b. Create a spreadsheet model for this problem and solve it using Solver. c. What is the optimal solution? d. If the furnace can burn up to 30 tons of coal per hour, what is the maximum amount of steam that can be produced per hour