Chapter 9 Linear Programming Applications and Computer Solutions
9-43
The Flying Chief supplies in-flight dinners to airlines. On a particular
run, the passengers are given their choice of beef, chicken, or fish
entrees. The owner must decide how many meals of each type to prepare in
order to minimize total cost. Historically, 55% of all passengers prefer
beef, 30% prefer chicken, and 15% prefer fish. However to compensate for
varying tastes from flight to flight, the number of meals provided must
be as great as the above percentages of total passengers. On the current
flight, there are 200 passengers and 300 meals must be provided. Airline
policy states that at least one-half the extra meals on any given flight
must be beef. Costs are $2 for each beef entrйe, $1.50 for chicken, and
$1 for fish.
formulate the linear program for this problem
solve this problem
How many meals of each type should be provided?
Business Homework Solutions
#93383
Quantitative Decsion Making (LAPIN/WHISLER): Linear programming problem
Chapter 9 Linear Programming Applications and Computer Solutions
9-43
The Flying Chief supplies in-flight dinners to airlines. On a particular run, the passengers are given their choice of beef, chicken, or fish entrees. The owner must decide how many meals of each type to prepare in order to minimize total cost. Historically, 55% of all passengers prefer beef, 30% prefer chicken, and 15% prefer fish. However to compensate for varying tastes from flight to flight, the number of meals provided must be as great as the above percentages of total passengers. On the current flight, there are 200 passengers and 300 meals must be provided. Airline policy states that at least one-half the extra meals on any given flight must be beef. Costs are $2 for each beef entrée, $1.50 for chicken, and $1 for fish.
A) formulate the linear program for this problem
B) solve this problem
C) How many meals of each type should be provided?
This posting contains a Linear programming problem formulation and solution using excel solver.
What is this?
By OTA - Overall OTA Rating
Neha Jain, ME - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
- Plain text response
- Attached file(s):
- 93383_answer.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Bloomington Brewery produces beer and ale. - Bloomington Brewery produces beer and ale. Beer sells for $5 per barrel, and ale sells for $2 per barrel. Producing a barrel of beer requires 5 pounds of corn and 2 pounds of hops. Producing a barrel ...
- Quantitative Methods - Danson furniture buys 2 products for resale: big shelves (B) and medium shelves (M). Each big shelf costs $500 and requires 100 cubic feet of storage space, and each medium shelf costs $300 and requir ...
- Linear programming - Need help with following using Excel:
- Quantitative Methods - The production manager for the Whoppy soft drink company is considering the production of 2 kinds of soft drinks: regular and diet. The company operates one "8 hour" shift per day. Therefore, the prod ...
- Solver - Excel - Someone has determined that the firm's capital investment budget will be $5,000,0000 for the upcoming year. Unfortunately, this amount is not sufficient to cover all the positive NPV projects that a ...
