Constraints: Semester Limit: Johnny can only take up to five courses every semester. This may be expressed for each semester j as: Σ(X_ij) <= 5 for all j (Jan, July) Required January Course: Σ(X_1j) >= 3 for j = Jan where the summation iterates only over courses 1 (Quantitative Methods), 2 (Business Application & Modeling), 3 (Economic Theory), 6 (Data Mining I), and 20 (Business Communications). Prerequisite Course: A course can only be taken if all of its requirements have been fulfilled or are being taken concurrently. This may be described using the following constraints: X_ij <= Σ(X_kj) for all courses i, j (Jan, July) where k is a prerequisite of course i Text Mining vs. Natural Language Processing: X_8j + X_14j <= 1 for j = Jan/July (any semester) Minimum Course Constraints: Johnny takes at least one course in Digital Marketing and one in Supply Chain Management. =X_10+ X_(11 )≥1 ( Digital Marketing Constraint) =X_12+ X_(13 )≥1 ( Supply Chain Management Constraint) Based on the above information, Construct a spreadsheet model for your formulated optimization model in Q1(a) using the Excel solver to solve the optimal solutions.

Johnny Chew recently accepted an offer from SUSS Business School to major in Business Analytics. He is now planning his course schedule for the upcoming academic year. The academic year at SUSS is divided into two semesters, and Johnny has a wide range of courses to choose from. He has shortlisted twenty potential courses that align with his interests and are beneficial for future job skills. His interest in each course is rated on a scale of 3 to 5, while the relevance to job skills is rated between 1 and 10, as indicated in the fifth and sixth columns of Table 1. Johnny is allowed to take at most five courses in each semester. In determining his course schedule, Johnny needs to consider the following: • Johnny can only take a course if he has completed or is concurrently taking all courses that are prerequisites for the course. The prerequisites for all twenty courses are shown in the fourth column of Table 1. • In the upcoming Jan semester, Johnny must take at least three of the following five courses: Quantitative Methods (course 1), Business Application & Modeling (course 2), Economic Theory (course 3), Data Mining I (course 6), and Business Communications (course 20) • If Johnny takes Text Mining (course 8), he will not be allowed to take Natural Language Processing (course 14), because these two courses cover fairly similar contents. • Johnny would like to take at least one course in Digital Marketing (course 12 and/ or 13) and at least one course in Supply Chain Management (course 10 and/ or 11). Course Index Subject Semester Prerequisities Interest Level Job skill level 1 Quantitative Methods Jan 5 7 2 Business Applications & Modeling Jan 5 6 3 Economic Theory Jan & July 4 3 4 Modern Finance Jan 4 4 5 Fintech July 4 3 4 6 Data Mining I Jan 3 8 7 Data Mining II July 2,6 3 8 8 Text Mining Jan 1,3 5 7 9 Statistical Method July 1 4 5 10 Supply Chain Management I Jan 4 4 11 Supply Chain Management Ii July 1,10 4 3 12 Digital Marketing I Jan 3 4 13 Digital Marketing II July 9,12 3 4 14 Natural Language Process July 3 5 7 15 Information System I Jan 4 6 16 Information System II July 15 4 6 17 Financial Leadership July 4 4 3 18 New Product Development July 10,12,17 3 7 19 Web 3.0 Organizations Jan 4 3 3 20 Business Communications Jan 5 5 Suppose that Johnny’s overall objective is to maximize his total interest level. Formulate a discrete optimization model that can be used to determine Johnny’s optimal course schedule. You answer should include the following: • Determine the objective of the proposed model; • Define the necessary decision variables; • List all the constraints and give the explanation.

Step-1: Model in MiniZinc an Exam Scheduling problem of some university having #N students taking over #M open credit courses (total of all the courses). The MiniZinc model, with the help of the off-the-shelf solvers, should be able to generate a schedule of all of the course exams into #T time slots and #R rooms. Step-2: Solve the model using any online (https://play.minizinc.dev/) or offline solver. Step-3: Submit the following -- i) model ii) solution iii) a pdf report (containing detail explanation) in a zipped folder **Hint: Exploit the following built-in constraints -- "alternative, cumulative, disjunctive, disjunctive_strict, span" Supporting resources: 1. A MiniZinc Tutorial: https://www.minizinc.org/doc-2.7.6/en/part_2_tutorial.html 2. An example model: https://github.com/hakank/hakank/blob/master/minizinc/timetable.mzn 3. Paper: https://github.com/mushfiqur11/ClassSchedule 4. Paper-Codebase: https://github.com/mushfiqur11/ClassSchedule

t a university, 3 courses are offered: "Programming", "Databases" and "Software Engineering".Each course is offered by a lecturer.Create for each course an instance of type COURSE (=class) using a constructor (parameters: name of the course and the lecturer).The lecturer is stored in a data member of type LECTURER (=class). The class LECTURER should have at least the data member academic_title.The courses have a maximum of 10 and a minimum of 3 course participants.The courses can be attended not only by our own students, but also by students from other universities.The class STUDENT should have at least the following data members: Matriculation numberUniversityStudents from their own university may take any course.Students from other universities may only take one course.The classes LECTURER and STUDENT should derive from the class PERSON.The class PERSON should have at least the following data members:SurnameFirst nameEmailTask: Create a program with a menu that covers the following situation:1. Registration for a course (including querying student data). Each student has a unique email, meaning there can't be two or more students with the same email in the same course.2. Output of one/all courses with data of the participants.    Please note that if there are fewer than 3 participants in a course, an additional message must be displayed - "Course will not take place".3. Output of all courses that are not fully booked yet. The output must include the number of free places, the name of the course and the academic name of the lecturer with its academic title.4. End of program: A message will be displayed stating which participants (=all data members of the class PERSON) have to be notified because your course is not taking place.If necessary (creation, search, and so on), corresponding messages are to be displayed.Permanent storage of the data is not required. The data must only be available at the runtime of the program.Use comments in the source code to document your program.

Marvin used the Quantitative Reasoning Process to build a budget while he is going to college. He worked hard over the summer and saved $3,212.65 to live on during the next two semesters of school. Marvin will receive a scholarship each semester for $959.90. If he plans to use up all of his savings while at school, how much money can Marvin spend each month, on average, for things like groceries, entertainment, and miscellaneous items? Assume two semesters equals 8 months total. Also assume Marvin has no other expenses than what he has listed here. Scholarship for each Semester: $959.90 Tuition & Books Cost per Semester: $2,200Housing Cost for a two-semester Contract: $1,025 If he has money left, what is the average monthly amount Marvin can afford to spend each month?If he has overspent, what is the average monthly amount Marvin would be in debt each month?(Indicate this amount with a negative sign) (Round your answer to the nearest cent

Marvin used the Quantitative Reasoning Process to build a budget while he is going to college. He worked hard over the summer and saved $3,212.65 to live on during the next two semesters of school. Marvin will receive a scholarship each semester for $959.90. If he plans to use up all of his savings while at school, how much money can Marvin spend each month, on average, for things like groceries, entertainment, and miscellaneous items? Assume two semesters equals 8 months total. Also assume Marvin has no other expenses than what he has listed here. Scholarship for each Semester: $959.90 Tuition & Books Cost per Semester: $2,200Housing Cost for a two-semester Contract: $1,025 If he has money left, what is the average monthly amount Marvin can afford to spend each month?If he has overspent, what is the average monthly amount Marvin would be in debt each month?(Indicate this amount with a negative sign) (Round your answer to the nearest cent)