Use the attached excel sheet to answer the following question. To graduate from Southeastern University with a major in operations research (OR), a student must complete at least three math courses, at least three OR courses, and at least two computer courses. Some courses can be used to fulfill more than one requirement: Calculus can fulfill the math requirement; Operations Research can fulfill the math and OR requirements; Data Structures can fulfill the computer and math requirements; Business Statistics can fulfill the math and OR requirements; Computer Simulation can fulfill the OR and computer requirements; Introduction to Computer Programming can fulfill the computer requirement; Forecasting can fulfill the OR and math requirements; and Data Mining can fulfill the OR, math, and computer requirements. Some courses are prerequisites for others: Calculus is a prerequisite for Business Statistics; Introduction to Computer Programming is a prerequisite for Computer Simulation and for Data Structures; and Business Statistics is a prerequisite for Forecasting and Data Mining. Determine how to minimize the number of courses needed to satisfy the major requirements. (Hint: Because Calculus is a prerequisite for Business Statistics, for example, you will need a constraint that ensures that the decision variable for Calculus is greater than or equal to the decision variable for Business Statistics.)

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Use the attached excel sheet to answer the following question.

To graduate from Southeastern University with a major in operations research (OR), a student must complete at least three math courses, at least three OR courses, and at least two computer courses. Some courses can be used to fulfill more than one requirement: Calculus can fulfill the math requirement; Operations Research can fulfill the math and OR requirements; Data Structures can fulfill the computer and math requirements; Business Statistics can fulfill the math and OR requirements; Computer Simulation can fulfill the OR and computer requirements; Introduction to Computer Programming can fulfill the computer requirement; Forecasting can fulfill the OR and math requirements; and Data Mining can fulfill the OR, math, and computer requirements. Some courses are prerequisites for others: Calculus is a prerequisite for Business Statistics; Introduction to Computer Programming is a prerequisite for Computer Simulation and for Data Structures; and Business Statistics is a prerequisite for Forecasting and Data Mining. Determine how to minimize the number of courses needed to satisfy the major requirements. (Hint: Because Calculus is a prerequisite for Business Statistics, for example, you will need a constraint that ensures that the decision variable for Calculus is greater than or equal to the decision variable for Business Statistics.)

EA
S
C
5
OR
6 Math
ni 7 Computer
8
1 Choosing college courses
2
3
4
B
14
te 15
16
009
de
10 Course taken
11
12 Prerequisite constraints
13
26
In 27
28
29
A
30
31
32
me 33
off
17
S 18 Major requirement constraints
19
20 OR
21 Math
22 Computer
23
24 Total courses
25
A ▶
Ready
B
Requirements (along side) that are met by taking available courses (along top) (1 if it fills reqt, 0 if not)
Calculus
OR
Data Structures
Bus Stats
Simulation
P6-40
Calculus
Courses taken
C
P6-44
D
+
OR Data Structures
E
Required
F
Bus Stats
Simulation
G
<
Intro to Comp Prog
Intro to Comp Prog
(Calculus for Bus Stats)
(Intro to Comp Prog for Simulation)
(Intro to Comp Prog for Data Structures)
(Bus Stats for Forecasting)
% 9
H
←0.00
.00 ➜.0
Forecasting
Forecasting
1
88
Fo
Ce
E
Transcribed Image Text:EA S C 5 OR 6 Math ni 7 Computer 8 1 Choosing college courses 2 3 4 B 14 te 15 16 009 de 10 Course taken 11 12 Prerequisite constraints 13 26 In 27 28 29 A 30 31 32 me 33 off 17 S 18 Major requirement constraints 19 20 OR 21 Math 22 Computer 23 24 Total courses 25 A ▶ Ready B Requirements (along side) that are met by taking available courses (along top) (1 if it fills reqt, 0 if not) Calculus OR Data Structures Bus Stats Simulation P6-40 Calculus Courses taken C P6-44 D + OR Data Structures E Required F Bus Stats Simulation G < Intro to Comp Prog Intro to Comp Prog (Calculus for Bus Stats) (Intro to Comp Prog for Simulation) (Intro to Comp Prog for Data Structures) (Bus Stats for Forecasting) % 9 H ←0.00 .00 ➜.0 Forecasting Forecasting 1 88 Fo Ce E
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY