Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Chemical Engineering Design And Analysis An Introduction

Authors: T. Michael Duncan, Jeffrey A. Reimer

2nd Edition

1108421474, 9781108421478

More Books

Students also viewed these Chemical Engineering questions

Question

What is RAM as far as telecommunication is concerned?

Answered: 1 week ago

Question

Question 1: What is reproductive system? Question 2: What is Semen?

Answered: 1 week ago

Question

Describe the sources of long term financing.

Answered: 1 week ago

Question

How do retail promotions differ from consumer promotions?

Answered: 1 week ago

Question

Why are co-op advertising programmes not always good for a brand?

Answered: 1 week ago

Question

How does branding strategy inform corporate image advertising?

Answered: 1 week ago