Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The University of Idaho owns and operates its own biomass power plant. The plant uses three types of food products to create steam power. The
The University of Idaho owns and operates its own biomass power plant. The plant uses three types of food products to create steam power. The EPA requires that for each ton of biomass burned, the emissions contain no more than 2,500 parts per million (ppm) of nitrogen and no more than 2.8 ppm of particulate matter. Wood Particulate Steam Nitrogen Product Matter Produced Chips 1100 1.7 24,000 Pellets 3500 3.2 36,000 Sawdust 1300 2.4 28,000 Assume that the emissions and steam produced are a weighted average of the components used in the fuel mix. For example, a mix of 35% chips, 40% pellets, and 25% sawdust would create (.35*1100+.4*3500+.25*1300) ppm of Nitrogen. Please formulate and solve this problem in Excel. Make sure to label your decision variables, objective function, and constraints. Upload the completed file here. The University of Idaho owns and operates its own biomass power plant. The plant uses three types of food products to create steam power. The EPA requires that for each ton of biomass burned, the emissions contain no more than 2,500 parts per million (ppm) of nitrogen and no more than 2.8 ppm of particulate matter. Wood Particulate Steam Nitrogen Product Matter Produced Chips 1100 1.7 24,000 Pellets 3500 3.2 36,000 Sawdust 1300 2.4 28,000 Assume that the emissions and steam produced are a weighted average of the components used in the fuel mix. For example, a mix of 35% chips, 40% pellets, and 25% sawdust would create (.35*1100+.4*3500+.25*1300) ppm of Nitrogen. Please formulate and solve this problem in Excel. Make sure to label your decision variables, objective function, and constraints. Upload the completed file here
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started