Homework Help is Here – Start Your Trial Now!
Math
Advanced Math
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
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter3: Functions And Graphs
Section3.3: Lines
Problem 27E
See similar textbooks
icon
Related questions
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

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