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
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
Related questions
Question

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images

Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage

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
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage

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
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,

Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill