Using Excel Solver, solve the following LP model. x₁ = In-state freshmen in college i; i = 1, 2, ... 6 y₁ = Outofstate freshmen in college i; i = 1, 2, ….. 6 Maximize Z = 8,600(Σ.x;)+19,200 (Σ.y) subject to X₁+₁ ≤ 470 X2 + y₂ ≤1300 X3 + Y3 ≤ 240 X4+4 ≤820 X5 +15 ≤1060 X6 +16 ≤610 ESATI, (x) + ESATO, (y) 1150 Σx; + Σy; ≥ ΣΥ; Σx; + Σ.y; Xi X¡ + Yi ≤.47 Xį, Y¡ ≥ 0 - ≥.30, i = 1, 2, ... 6 Σx; +Σy; ≤ 4,500

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter5: Inverse, Exponential, And Logarithmic Functions
Section5.3: The Natural Exponential Function
Problem 41E
Question
Using Excel Solver, solve the following LP model.
x₁ = In-state freshmen in college i; i = 1, 2, ... 6
y₁ = Outofstate freshmen in college i; i = 1, 2, ….. 6
Maximize Z = 8,600(Σ.x; )+19,200 (Σ»)
subject to
X₁+₁ ≤ 470
X2 + y₂ ≤1300
x3 + 1/3 ≤ 240
X4+4 ≤820
X5 +15 ≤1060
X6 +16 ≤610
ΣSATI, (x;) + ΣSATO; (y;)
Σx; + Σy;
ΣΥ;
Σx; + Σy;
Xi
X¡ + Yi
≤.47
Xį, Y¡ ≥ 0
- ≥.30, i = 1, 2, ... 6
Σx; +Σy; ≤ 4,500
≥ 1150
Transcribed Image Text:Using Excel Solver, solve the following LP model. x₁ = In-state freshmen in college i; i = 1, 2, ... 6 y₁ = Outofstate freshmen in college i; i = 1, 2, ….. 6 Maximize Z = 8,600(Σ.x; )+19,200 (Σ») subject to X₁+₁ ≤ 470 X2 + y₂ ≤1300 x3 + 1/3 ≤ 240 X4+4 ≤820 X5 +15 ≤1060 X6 +16 ≤610 ΣSATI, (x;) + ΣSATO; (y;) Σx; + Σy; ΣΥ; Σx; + Σy; Xi X¡ + Yi ≤.47 Xį, Y¡ ≥ 0 - ≥.30, i = 1, 2, ... 6 Σx; +Σy; ≤ 4,500 ≥ 1150
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
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
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill