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
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.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started