Is my work correct? If not please show where I went wrong and how to fix the mistake.

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 require- ments; 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 vari- able for Business Statistics).
Transcribed Image Text:56 00 S OR 6 Math 7 Computer 9 10 Course taken A 1 Choosing college courses 2 3 Requirements (along side) th 15 16 Bi 12 Prerequisite constraints 13 4 23 18 Major requirement constrain 20 OR 21 Math 22 Computer 23 24 Total courses 25 26 27 28 29 m m m m m m G Get Data (Power Query) 30 31 32 33 34 35 Point Retir Plannin X esc Data from Picture P6-40 ject xlsy BEL fx 0 1 0 =B10 =G10 =G10 -E10 =E10 Page Layout P6-44 Refresh All F1 B Formulas Data Queries & Connections Properties Edit Links -SUMPRODUCT($B$10:$I$10,B5:15) -SUMPRODUCT($B$10:$I$10,B6:16) =SUMPRODUCT($B$10:$1$10,B7:17) Calculus P6-44(2a) Calculus Courses taken SUM(B20:B22) Courses required: Calculus, OR, Bus Sta Step 3: Solution 1 P6-44(2b) JUL 12 161 20 F3 X X X X X + C OR 332 000 000 F4 Review OR Stocks 0 1 1 =E10 =F10 =D10 =H10 -110 View F5 Window D D Geography SolverTable for Mac Data Structures Data Structures Required alt 1 1 0 F6 AL Z↓ M05_qa_Colbert ΖΙΑ AIZ MacBook Pro Sort Sort Filter E Bus Stats Bus Stats AA Tell me 1 0 1 Clear Reapply Advanced A I O F DII B Text to Columns Simulation (Calculus for Bus Stats) (Intro to Comp Prog for Simulation) (Intro to Comp Prog for Data Structures) (Bus Stats for Forecasting) (Bus Stats for data mining) Simulation 1 0 0 Set Objective: To: X What-If Analysis Max G Select a Solving Method: Intro to Comp Prog Intro to Comp Prog $B$24 O Min Group zf Ungroup v Subtotal By Changing Variable Cells: $B$10:$I$10 Subject to the Constraints: $B$10:$1$10 = binary $B$13:$B$17 >= $D$13:$D$17 $B$20:$B$22 >= $D$20:$D$22 Solver Parameters Make Unconstrained Variables Non-Negative Simplex LP 1 1 0 Value Of: 0 Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non- smooth. Options Delete Reset All Add Load/Save 2 Solver Change Forecasting Analysis Tools Forecasting Data mining + 100% 1 1 1 Q Share Data mining
Transcribed Image Text:126 A B 1 Choosing college courses 2 8 Math Computer 10 Course taken 11 12 Prerequisite constraints 13 x✓ fx X 27 28 29 N3 3 Requirements (along side) that are met by taking available courses (along top) (1 if it fills reqt, 0 if not) 4 Calculus OR Data Structures Bus Stats 5 OR 1 6 7 30 31 32 33 34 35 Ready 14 15 16 17 18 Major requirement constraints 19 Courses taken 20 OR 21 Math 22 Computer 23 24 Total courses 25 26 0 1 0 P6-40 Calculus Retir Plannin iect xlsx 1 1 1 1 1 1 >= 332 8 C P6-44 >E XXX 1 0 D OR Data Structures 1 P6-44(2a) 1 332 0 OOPP Required 1 0 0 1 1 Time E P6-44(2b) Step 3: Solution Courses required: Calculus, OR, Bus Stats, Simulation, Intro to Comp Prog 10 1 0 Bus Stats 1 okup & Math & Reference Trig F + 1 0 7 More Functions 1 G Simulation Intro to Comp Prog Forecasting Data mining 0 (Calculus for Bus Stats) (Intro to Comp Prog for Simulation) (Intro to Comp Prog for Data Structures) (Bus Stats for Forecasting) (Bus Stats for data mining) Simulation Intro to Comp Prog 1 0 1 Name Manager H 1 0 1 Use in Formula Create from Selection 0 1 Forecasting Data mining 0 1 1 1 J Trace Pr Trace De FRemove A K

Question

Is my work correct? If not please show where I went wrong and how to fix the mistake.

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 require- ments; 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 vari- able for Business Statistics).

56 00
S
OR
6 Math
7 Computer
9
10 Course taken
A
1 Choosing college courses
2
3 Requirements (along side) th
15
16
Bi
12 Prerequisite constraints
13
4
23
18 Major requirement constrain
20 OR
21 Math
22 Computer
23
24 Total courses
25
26
27
28
29
m m m m m m
G
Get Data (Power
Query)
30
31
32
33
34
35
Point
Retir
Plannin
X
esc
Data from
Picture
P6-40
ject xlsy
BEL
fx
0
1
0
=B10
=G10
=G10
-E10
=E10
Page Layout
P6-44
Refresh
All
F1
B
Formulas Data
Queries & Connections
Properties
Edit Links
-SUMPRODUCT($B$10:$I$10,B5:15)
-SUMPRODUCT($B$10:$I$10,B6:16)
=SUMPRODUCT($B$10:$1$10,B7:17)
Calculus
P6-44(2a)
Calculus
Courses taken
SUM(B20:B22)
Courses required: Calculus, OR, Bus Sta
Step 3: Solution
1
P6-44(2b)
JUL
12
161
20
F3
X
X
X
X
X
+
C
OR
332
000
000
F4
Review
OR
Stocks
0
1
1
=E10
=F10
=D10
=H10
-110
View
F5
Window
D
D
Geography
SolverTable for Mac
Data Structures
Data Structures
Required
alt
1
1
0
F6
AL
Z↓
M05_qa_Colbert
ΖΙΑ
AIZ
MacBook Pro
Sort
Sort Filter
E
Bus Stats
Bus Stats
AA
Tell me
1
0
1
Clear
Reapply
Advanced
A I O
F
DII
B
Text to
Columns
Simulation
(Calculus for Bus Stats)
(Intro to Comp Prog for Simulation)
(Intro to Comp Prog for Data Structures)
(Bus Stats for Forecasting)
(Bus Stats for data mining)
Simulation
1
0
0
Set Objective:
To:
X
What-If
Analysis
Max
G
Select a Solving Method:
Intro to Comp Prog
Intro to Comp Prog
$B$24
O Min
Group
zf Ungroup v
Subtotal
By Changing Variable Cells:
$B$10:$I$10
Subject to the Constraints:
$B$10:$1$10 = binary
$B$13:$B$17 >= $D$13:$D$17
$B$20:$B$22 >= $D$20:$D$22
Solver Parameters
Make Unconstrained Variables Non-Negative
Simplex LP
1
1
0
Value Of:
0
Solving Method
Select the GRG Nonlinear engine for Solver Problems that are smooth
nonlinear. Select the LP Simplex engine for linear Solver Problems,
and select the Evolutionary engine for Solver problems that are non-
smooth.
Options
Delete
Reset All
Add
Load/Save
2 Solver
Change
Forecasting
Analysis Tools
Forecasting Data mining
+ 100%
1
1
1
Q
Share
Data mining

126
A
B
1 Choosing college courses
2
8
Math
Computer
10 Course taken
11
12 Prerequisite constraints
13
x✓ fx
X
27
28
29
N3
3 Requirements (along side) that are met by taking available courses (along top) (1 if it fills reqt, 0 if not)
4
Calculus
OR Data Structures
Bus Stats
5 OR
1
6
7
30
31
32
33
34
35
Ready
14
15
16
17
18 Major requirement constraints
19
Courses taken
20 OR
21 Math
22 Computer
23
24 Total courses
25
26
0
1
0
P6-40
Calculus
Retir
Plannin iect xlsx
1
1
1
1
1
1 >=
332
8
C
P6-44
>E
XXX
1
0
D
OR Data Structures
1
P6-44(2a)
1
332
0
OOPP
Required
1
0
0
1
1
Time
E
P6-44(2b)
Step 3: Solution
Courses required: Calculus, OR, Bus Stats, Simulation, Intro to Comp Prog
10
1
0
Bus Stats
1
okup & Math &
Reference Trig
F
+
1
0
7
More
Functions
1
G
Simulation Intro to Comp Prog Forecasting Data mining
0
(Calculus for Bus Stats)
(Intro to Comp Prog for Simulation)
(Intro to Comp Prog for Data Structures)
(Bus Stats for Forecasting)
(Bus Stats for data mining)
Simulation Intro to Comp Prog
1
0
1
Name
Manager
H
1
0
1
Use in Formula
Create from Selection
0
1
Forecasting Data mining
0
1
1
1
J
Trace Pr
Trace De
FRemove A
K

Accepted Answer

Objective Functions and Constraints:
                Based on the given details, the objective…