Solved: Optimization models

0 Comments

ECA Submission Guidelines
Please follow the submission instructions stated below:
A – What Must Be Submitted
You are required to submit the following ONE (1) items for marking and grading:

  • A Report
    Please verify your submissions after you have submitted the above item.
    B – Submission Deadline
  • The Report is to be submitted by 12 noon on the submission deadline.
  • You are allowed multiple submissions till the cut-off date for each of the Report.
  • Late submission of any of the Report will be subjected to mark-deduction
    scheme by the University. Please refer to Section 5.2 Para 2.4 of the Student
    Handbook.
    C – How the (3) Items Should Be Submitted
  • The Report: submit online to Canvas via TurnItIn (for plagiarism detection)
  • void using a public WiFi connection for submitting large video files. If you are
    using public wireless (WiFi) connection (e.g. SG Wireless at public areas), you
    might encounter a break in the connection when sending large files.
    D – Additional guidelines on file formatting are given as follows:
  1. Report • Please ensure that your Microsoft Word document is
    generated by Microsoft Word 2016 or higher.
  • The report must be saved in
    .docx format.
    ANL355 Copyright © 2024 Singapore University of Social Sciences (SUSS)
    ECA – January Semester 2024 Page 3 of 7
  1. Video • Showing your PowerPoint projection in the
    background is NOT required.
  • Time Duration: a minimum of 3 minutes and a
    maximum of 6 minutes
    There are two methods for ECA video assignment
    submission; either Record Media or Upload Media.
    For Record Media
    Video can be recorded via Canvas through desktop/laptop
    with built-in webcam and microphone or through Canvas
    mobile app. Live recording duration must be less than 10
    minutes. No file size limit for live recording.
    For Upload Media
    Video can be recorded using other recording devices and
    uploaded as a media file. Do ensure that your video file
    conforms to these requirements:
    a. File Format: .mp4
    b. File Size: No more than 500MB
    Note: Refer to Canvas L/LG course site’s announcement on
    “ECA Video Submission Technical Know How”, which
    will be posted three weeks before the ECA cut-off date.
  1. Presentation
    Summary
  • Your PowerPoint presentation must contain at least
    20 words.
  • Please ensure that your PowerPoint presentation is
    converted to PDF format before you submit.
  • The maximum number of slides is fifteen (15).
  • Please do NOT download and use PowerPoint slide
    design templates from the Internet.
    E – Please be Aware of the Following:
    Submission in hardcopy or any other means not given in the above guidelines will not
    be accepted. You do not need to submit any other forms or cover sheets (e.g. form ET3)
    with your ECA.
    You are reminded that electronic transmission is not immediate. The network traffic
    may be particularly heavy on the date of submission deadline and connections to the
    system cannot be guaranteed. Hence, you are advised to submit your work early.
    Canvas will allow you to submit your work late but your work will be subjected to
    the mark-deduction scheme. You should therefore not jeopardise your course result
    by submitting your ECA at the last minute.
    It is your responsibility to check and ensure that your files are successfully submitted
    to Canvas.
    F – Plagiarism and Collusion
    ANL355 Copyright © 2024 Singapore University of Social Sciences (SUSS)
    ECA – January Semester 2024 Page 4 of 7
    Plagiarism and collusion are forms of cheating and are not acceptable in any form in a
    student’s work, including this ECA. Plagiarism and collusion are taking work done by
    others or work done together with others respectively and passing it off as your own.
    You can avoid plagiarism by giving appropriate references when you use other people’s
    ideas, words or pictures (including diagrams). Refer to the APA Manual if you need
    reminding about quoting and referencing. You can avoid collusion by ensuring that
    your submission is based on your own individual effort.
    The electronic submission of your ECA will be screened by plagiarism detection
    software. For more information about plagiarism and collusion, you should refer to the
    Student Handbook (Section 5.2.1.3). You are reminded that SUSS takes a tough stance
    against plagiarism or collusion. Serious cases will normally result in the student being
    referred to SUSS’s Student Disciplinary Group. For other cases, significant mark
    penalties or expulsion from the course will be imposed.
    G – Use of Generative AI Tools (Allowed)
    The use of generative AI tools is allowed for this assignment.
  • You are expected to provide proper attribution if you use generative AI tools
    while completing the assignment, including appropriate and disciplinespecific citation, a table detailing the name of the AI tool used, the approach
    to using the tool (e.g. what prompts were used), the full output provided by the
    tool, and which part of the output was adapted for the assignment;
  • To take note of section 3, paragraph 3.2 and section 5.2, paragraph 2A.1 (Viva
    Voce) of the Student Handbook;
  • The University has the right to exercise the viva voce option to determine the
    authorship of a student’s submission should there be reasonable grounds to
    suspect that the submission may not be fully the student’s own work.
  • For more details on academic integrity and guidance on responsible use of
    generative AI tools in assignments, please refer to the TLC website for more
    details;
  • The University will continue to review the use of generative AI tools based on
    feedback and in light of developments in AI and related technologies.
    ANL355 Copyright © 2024 Singapore University of Social Sciences (SUSS)
    ECA – January Semester 2024 Page 5 of 7
    (Full marks: 100)
    Section A (100 marks)
    Answer all questions in this section.
    Question 1
    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 Prerequisites 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
    7 Data Mining II July 2, 6 3 8
    8 Text Mining Jan 1,3 5 7
    ANL355 Copyright © 2024 Singapore University of Social Sciences (SUSS)
    ECA – January Semester 2024 Page 6 of 7
    9 Statistical Methods 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
    Table 1. The listed courses Johnny is mostly interested
    Question 1a
    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.
    (40 marks)
    Question 1b
    Construct a spreadsheet model for your formulated optimization model in Q1(a) using
    the Excel solver to solve the optimal solutions. (Present the screenshots of the
    spreadsheet model and solution as part of your answer.)
    (20 marks)
    ANL355 Copyright © 2024 Singapore University of Social Sciences (SUSS)
    ECA – January Semester 2024 Page 7 of 7
    Question 1c
    Try to amend your model in order to generate a different solution with the same
    (optimal) objective value as in Q1(b).
  • What is the other optimal course schedule?
  • Based in the given context, which solution should Johnny use? Justify your
    answer.
    (10 marks)
    Question 1d
    While selecting courses based solely on interest levels might seem ideal, it’s often
    crucial to also consider the relevance of the skills gained for future job prospects.
    Balancing multiple objectives, such as personal interests and the acquisition of jobrelevant skills, is a more realistic and pragmatic approach. In reality, people often
    employ various methods to incorporate and balance these multiple objectives. This
    discussion invites you to propose two distinct methods commonly used for integrating
    multiple objectives in course selection. Additionally, please describe the necessary
    steps and considerations for effectively evaluating this multifaceted decision-making
    process.
    (30 marks)

Get Homework Help Now

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts