Question: please help! Can you also post excel formulas please Problem 1 To graduate from Southeastern University with a major in operations research (OR), a student

please help! Can you also post excel formulas please

please help! Can you also post excel formulas

Problem 1 To graduate from Southeastern University with a major in operations research (OR), a student must complete at least two Math courses, at least two OR courses, and at least two Computer courses. Seven courses are offered, among which some courses can be used to fulfill more than one requirement, listed in the table below. (1 if it fills a requirement, if not) Calculus Operations Data Business Research Structures Statistics Simulation Forecasting Offered Course Requirement OR Math Computer Intro to Computer Programming 0 0 1 0 1 0 1 1 1 1 1 1 0 1 0 1 1 0 1 0 0 Some courses are prerequisites for others: Calculus is a prerequisite for Business Statistics; Intro to Computer Programming is a prerequisite for Simulation and for Data Structure; and Business statistics is a prerequisite for Forecasting. A course requiring prerequisite can be taken only if its prerequisite course is taken. Determine how to minimize the number of courses needed to satisfy the major requirements. (a) Formulate appropriately as an IP model. Provide the algebraic model formulation in your submission. Must be neatly presented. (b) Input and solve the formulation using Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!