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 00SOR6 Math7 Computer910 Course takenA1 Choosing college courses23 Requirements (along side) th1516Bi12 Prerequisite constraints1342318 Major requirement constrain20 OR21 Math22 Computer2324 Total courses2526272829m m m m m mGGet Data (PowerQuery)303132333435PointRetirPlanninXescData fromPictureP6-40ject xlsyBELfx010=B10=G10=G10-E10=E10Page LayoutP6-44RefreshAllF1BFormulas DataQueries & ConnectionsPropertiesEdit Links-SUMPRODUCT($B$10:$I$10,B5:15)-SUMPRODUCT($B$10:$I$10,B6:16)=SUMPRODUCT($B$10:$1$10,B7:17)CalculusP6-44(2a)CalculusCourses takenSUM(B20:B22)Courses required: Calculus, OR, Bus StaStep 3: Solution1P6-44(2b)JUL1216120F3XXXXX+COR332000000F4ReviewORStocks011=E10=F10=D10=H10-110ViewF5WindowDDGeographySolverTable for MacData StructuresData StructuresRequiredalt110F6ALZ↓M05_qa_ColbertΖΙΑAIZMacBook ProSortSort FilterEBus StatsBus StatsAATell me101ClearReapplyAdvancedA I OFDIIBText toColumnsSimulation(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)Simulation100Set Objective:To:XWhat-IfAnalysisMaxGSelect a Solving Method:Intro to Comp ProgIntro to Comp Prog$B$24O MinGroupzf Ungroup vSubtotalBy Changing Variable Cells:$B$10:$I$10Subject to the Constraints:$B$10:$1$10 = binary$B$13:$B$17 >= $D$13:$D$17$B$20:$B$22 >= $D$20:$D$22Solver ParametersMake Unconstrained Variables Non-NegativeSimplex LP110Value Of:0Solving MethodSelect the GRG Nonlinear engine for Solver Problems that are smoothnonlinear. Select the LP Simplex engine for linear Solver Problems,and select the Evolutionary engine for Solver problems that are non-smooth.OptionsDeleteReset AllAddLoad/Save2 SolverChangeForecastingAnalysis ToolsForecasting Data mining+ 100%111QShareData mining 126AB1 Choosing college courses28MathComputer10 Course taken1112 Prerequisite constraints13x✓ fxX272829N33 Requirements (along side) that are met by taking available courses (along top) (1 if it fills reqt, 0 if not)4CalculusOR Data StructuresBus Stats5 OR167303132333435Ready1415161718 Major requirement constraints19Courses taken20 OR21 Math22 Computer2324 Total courses2526010P6-40CalculusRetirPlannin iect xlsx111111 >=3328CP6-44>EXXX10DOR Data Structures1P6-44(2a)13320OOPPRequired10011TimeEP6-44(2b)Step 3: SolutionCourses required: Calculus, OR, Bus Stats, Simulation, Intro to Comp Prog1010Bus Stats1okup & Math &Reference TrigF+107MoreFunctions1GSimulation Intro to Comp Prog Forecasting Data mining0(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 Prog101NameManagerH101Use in FormulaCreate from Selection01Forecasting Data mining0111JTrace PrTrace DeFRemove AK

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

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).

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...