a. Formulate a linear programming model for this problem on a spreadsheet. b. Use the spreadsheet to check if (x, X2, X)= (1, 2, 2) is a feasible solution and, if so, what the daily cost would be for this diet. How many units of each nutritional ingredient would this diet provte daily c. Take a few minutes to use a trial-and-ecior appros h with the spreadsheet to develop your best guess for the optimal solution. What is the daily cost for your wareho made montns months quite di solution? amoun d. Use Solver to find an optimal solution. other h e. Express the model in algebraic form. Maureen Laird is the chief financial officer for the Alva Electric Co., a major public utility in the Midwest. The com- pany has scheduled the construction of new hydroelectric plants 5, 10, and 20 years from now to meet the needs of the growing population in the region served by the company. To cover the months expens five m changi lease a every i

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter9: Systems Of Equations And Inequalities
Section9.4: Linear Programming
Problem 29E
Question

Need the answer for a,d and e

a. Formulate a linear programming model for this
problem on a spreadsheet.
b. Use the spreadsheet to check if (x, X2, X3} 3 (1, 2, 2)
is a feasible solution and, if so, what the daily cost
would be for this diet. How many units of each
nutritional ingredient would this diet proviie datly?
3.13
vareho
made
c. Take a few minutes to use a trial-and-ecror appr0sch
with the spreadsheet to develop your best guess for
the optimal solution. What is the daily cost for your
months
months
quite d
solution?
d. Use Solver to find an optimal solution.
unoun
other h
e. Express the model in algebraic form.
months
Maureen Laird is the chief financial officer for the Alva
expens
five m
Electric Co., a major public utility in the Midwest. The com-
pany has scheduled the construction of new hydroelectric plants
5, 10, and 20 years from now to meet the needs of the growing
population in the region served by the company. To cover the
changi
lease a
every i
Transcribed Image Text:a. Formulate a linear programming model for this problem on a spreadsheet. b. Use the spreadsheet to check if (x, X2, X3} 3 (1, 2, 2) is a feasible solution and, if so, what the daily cost would be for this diet. How many units of each nutritional ingredient would this diet proviie datly? 3.13 vareho made c. Take a few minutes to use a trial-and-ecror appr0sch with the spreadsheet to develop your best guess for the optimal solution. What is the daily cost for your months months quite d solution? d. Use Solver to find an optimal solution. unoun other h e. Express the model in algebraic form. months Maureen Laird is the chief financial officer for the Alva expens five m Electric Co., a major public utility in the Midwest. The com- pany has scheduled the construction of new hydroelectric plants 5, 10, and 20 years from now to meet the needs of the growing population in the region served by the company. To cover the changi lease a every i
234 5
ormulation and Applications
problem having the
The space requirement and 1
leasing periods are as follows
assets produce income 5, 10, and 20 years from now, and thot
income is needed to cover minimum cash flow requirements in
Month
Minimum
those years, as shown in the following table.
1.
Acceptable
Level
Income per Unit of Asset
4.
08
Minimum
09
110
Cash Flow
Year
Asset 1
Asset 2
Asset 3
Required
$2 million
4 million
Leasing Period
(Months)
$8 million
5.
$4 million
$1.6 billion
ing model for this
2 million
2 million
400 million
6 million
8 million
1.2 billion
n choosing for the
sheet to check each
Maureen wishes to determine the mix of investments in these
le, for the value of
assets that will cover the cash flow requirements while minimiz-
ing the total amount invested.
asible guess has the
a) Formulate a linear programming model for this
problem on a spreadsheet.
b. Use the spreadsheet to check the possibility of pur-
chasing 100 units of asset 1, 100 units of asset 2, and
200 units of asset 3. How much cash flow would this
mix of investments generate 5, 10, and 20
now? What would be the total amount invested?
lution.
ned farm. To sup-
The objectives o minim
rm, Fred also raises
ing the space reqrements.
a. Indicate why thi
lem by identifyi
efits being sough
b. Identify verbally
-Ind
he quantities of the
alfa) that should be
of these feed types,
years from
meet certain nutri-
number of units of
Take a few minutes to use a trial-and-error approach
with the spreadsheet to develop your best guess
for the optimal solution. What is the total amount
invested for your solution?
ined within a kilo-
straints on these
g table, along with
of performance
c. Convert these v
is.
and the measur
expressions in t
d. Formulate a spre
Minimum
Kilogram
Kilogram of
Tankage
Daily
Requirement
of Alfalfa
tify the data cell:
and the other o
09
180
tion for each o
08
150
20
72
09
UCT function. T
09
e. Summarize the
3.14.
Consider the follow
benefit-trade-off problem
model for this
Use Solver to find an optimal solution.
Summarize the model in algebraic form.
and A4):
, X) = (1, 2, 2)
at the daily cost
units of each
3.13.
2.13 Web Mercantile sells many household products
uch an online catalog. The company needs substantial
Minimize Co
warehouse space for storing its goods. Plans now are beine
made for leasing warenouse storage space over the next five
subject to
provide daily?
-error approach
months. Just how much space will be required in each
Transcribed Image Text:234 5 ormulation and Applications problem having the The space requirement and 1 leasing periods are as follows assets produce income 5, 10, and 20 years from now, and thot income is needed to cover minimum cash flow requirements in Month Minimum those years, as shown in the following table. 1. Acceptable Level Income per Unit of Asset 4. 08 Minimum 09 110 Cash Flow Year Asset 1 Asset 2 Asset 3 Required $2 million 4 million Leasing Period (Months) $8 million 5. $4 million $1.6 billion ing model for this 2 million 2 million 400 million 6 million 8 million 1.2 billion n choosing for the sheet to check each Maureen wishes to determine the mix of investments in these le, for the value of assets that will cover the cash flow requirements while minimiz- ing the total amount invested. asible guess has the a) Formulate a linear programming model for this problem on a spreadsheet. b. Use the spreadsheet to check the possibility of pur- chasing 100 units of asset 1, 100 units of asset 2, and 200 units of asset 3. How much cash flow would this mix of investments generate 5, 10, and 20 now? What would be the total amount invested? lution. ned farm. To sup- The objectives o minim rm, Fred also raises ing the space reqrements. a. Indicate why thi lem by identifyi efits being sough b. Identify verbally -Ind he quantities of the alfa) that should be of these feed types, years from meet certain nutri- number of units of Take a few minutes to use a trial-and-error approach with the spreadsheet to develop your best guess for the optimal solution. What is the total amount invested for your solution? ined within a kilo- straints on these g table, along with of performance c. Convert these v is. and the measur expressions in t d. Formulate a spre Minimum Kilogram Kilogram of Tankage Daily Requirement of Alfalfa tify the data cell: and the other o 09 180 tion for each o 08 150 20 72 09 UCT function. T 09 e. Summarize the 3.14. Consider the follow benefit-trade-off problem model for this Use Solver to find an optimal solution. Summarize the model in algebraic form. and A4): , X) = (1, 2, 2) at the daily cost units of each 3.13. 2.13 Web Mercantile sells many household products uch an online catalog. The company needs substantial Minimize Co warehouse space for storing its goods. Plans now are beine made for leasing warenouse storage space over the next five subject to provide daily? -error approach months. Just how much space will be required in each
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 9 steps with 9 images

Blurred answer
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell