Management science

Homework 3

Started: Feb 6 at 11:44pm

Quiz Instructions

The goal of this assignment (in a Quiz format) is to achieve the following learning outcomes in LP Applications:

·

1. Formulate problems in marketing, finance, and operations management as LP models;

2. Enter LP models using Canvas editors;

3. Set up the LP problem in Excel;

4. Solve the problem using Excel Solver;

5. Interpret the solution provided by Solver.

Three problems are assigned from the 15th

 

Edition of 
Introduction to Management Science: Quantitative Approaches to Decision Making by Anderson, et al., unless specified otherwise.

· Ch4, Problem 1

· Ch4, Problem 7

· Ch4, Problem 14

Note:

· Excel spreadsheet modeling is an important learning outcome of this course. It is also a marketable skill. See 

an article (Links to an external site.)

 from Monster. However, it cannot be tested in exams. Therefore, you must demonstrate that you have attained this learning outcome in multiple homework assignments. Points will be deducted if the Excel model does not match with LP formulation, or Solver is not used to obtain the solution.

· Submit a separate file for each problem that requires a file submission.

Detailed instructions are given to each question, click on Take the Quiz to see the instructions  BEFORE starting your homework. After viewing the instructions, do NOT click on Submit Quiz. Simply leave the quiz (by clicking on Quizzes on the left panel), this allows you to revisit the quiz by clicking on Resume Quiz.  Click on Submit Quiz only when you are ready to submit your homework. 

Top of Form

 

Flag question: Spacer

Policy on collaboration:

The instructor strongly encourages students to form pairs and collaborate on homework. Students, however, must report such collaboration by answering the first two questions in every homework assignment. Further, every student must type-up or write-up the solutions himself/herself and create his/her own Excel spreadsheet.

The following acts violate academic integrity:

· Two or more students submit the same file;

· The collaboration question is not answered;

· Statements of collaboration do not corroborate. Example: A stated working alone, while B claimed to work with A.

Penalty for violating academic integrity:

· First offense: all students receive a zero on their homework, along with a warning from the instructor.

· Second offense: all students are reported to the DOS in addition to receiving a zero on their homework.

· Third offense: all students fail the course.

 

Flag question: Question 1

Question 10 pts

Did you collaborate with another student in this class? 

If yes, in the box provided below write the following sentence and fill in your collaborator’s full name:

I collaborated with (Student’s full name). 

If no, simply write:

I worked alone. 

Note: if this question is not answered, or it does not match with your collaborator’s statement, this assignment will not be graded and you will receive a zero.

View keyboard shortcuts

pView keyboard shortcutsAccessibility Checker

0 words

Switch to the html editorFullscreen

 
Flag question: Spacer

Policy on homework submission:

·
The cutoff submission time is set at 11:30 pm on the due date.

·
Late submission is not accepted and will receive zero points.

·
No submissions via email will be accepted.

·
You may be asked to type their answers in the given space or to upload files that contain detailed work. Only two formats are accepted: portable document format (pdf) and Excel spreadsheet (xls or xlsx).

· If a question requires 
a pdf file submission, you may either type up their answers or scan their hand-written answers. Label each part of the question and sort them either in a numerical order (part 1, part 2, etc.) or in an alphabetical order (part a, part b, etc.).

· If a question requires 
an xls or xlsx submission, you must submit a single Excel spreadsheet that includes both the model and the solution. I will run the model to check whether the solution is generated by the Solver. Use multiple tabs if more than one model is required.

·
Submit a separate file for each problem that requires a file submission. See section 2.1.1 of the Syllabus for reasonings.

Example of how homework questions are graded: Two questions (Q1 and Q2) in an assignment require file submissions. 

·

· Correct submission:

· Submit one file (F1) to Q1 and another (F2) to Q2.

· Grading: Q1 will be graded based on F1 and assigned a grade. Q2 will be graded, after everyone’s Q1 is graded, based on F2 and assigned another grade.

· Incorrect submission:

· Submit a single file (F) to Q1 and submit no file to Q2. F has answers to both Q1 and Q2.

· Grading: Q1 will be graded based on F and assigned a grade. Q2 will receive zero points because no file was submitted to Q2.

 

Flag question: Question 2

Question 230 pts

Ch4, Problem 1

· Part a: in an Excel file, write the formulation, set up the model and find the solution using Solver.

· Part b: in the same Excel file, modify the formulation and model, and find the new solution using Solver.

· Under Resources – Excel Solver on the 
Home page, you can find examples of how to set up a LP model in Excel and solve it using Solver.

· You may find it easier to use separate tabs, one for each part. Label each tab clearly.

·
Upload a single Excel file.

Upload 

Choose a File

 

Flag question: Question 3

Question 335 pts

Ch4, Problem 7, Part a and d only

· Part a: in an Excel file, write the formulation, set up the model and find the solution using Solver.

· Part d: in the same Excel file, modify the formulation and model, and find the new solution using Solver.

· Under Resources – Excel Solver on the 
Home page, you can find examples of how to set up a LP model in Excel and solve it using Solver.

· You may find it easier to use separate tabs, one for each part. Label each tab clearly.
·
Upload a single Excel file.

Upload 
Choose a File
 

Flag question: Question 4

Question 415 pts

Ch4, Problem 14: Part a – LP Formulation

Write down the formulation in the answer box below. 

Make sure the following four components are included:

1. Variable definitions:

· Use a separate line for variable;

· Start each variable definition with “Let”;

· Example: Let x1 denote …

· Specify the units.

· Example: number of bags, gallons of a liquid, pounds (lbs) of flours, etc.

2. An objective function:

· Start with either “max Z=” or “min Z=”;

· Include only linear terms of decision variables after “=”.

3. A set of constraints:

· Start with “s.t.” for the 1st constraint; 

· Left-hand-side (LHS) of each constraint should only include linear terms of decision variables;

· Right-hand-side (RHS) of each constraint should only have numbers;

· Do not include “s.t.” for other constraints.

4. A set of variable restrictions:

· Start with “and”;

· Group variable restrictions if they are all non-negatively restricted.

Suggestion: you may find it easier to use the Table editor (
 ) so that the objective function, each constraint, and the variable restrictions are in their separate lines. 

View keyboard shortcuts

EditViewInsertFormatToolsTable

12pt

Paragraph

pView keyboard shortcutsAccessibility Checker
0 words
Switch to the html editorFullscreen
 

Flag question: Question 5

Question 520 pts

Ch4, Problem 14, Part b – Solving LP

· In an Excel file, set up the model and find the solution using Solver.

· In the same Excel file, develop the table that will show for each quarter the number of units to manufacture, the ending inventory, and the costs incurred.

· Under Resources – Excel Solver on the 
Home page, you can find examples of how to set up a LP model in Excel and solve it using Solver.

·
Upload a single Excel file.

Upload 
Choose a File

Bottom of Form

image1