$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!
Students Who Viewed This Also Studied
CSC445 Operations Research Linear Programming
Task
Assignment
Transportation, Assignments, and Integer/Binary Programming Problems
Problem 1: Assignment Problem (20 points)
The hospital administrator at Riverside General must appoint head nurses to four newly established departments: urology, cardiology, orthopedics, and obstetrics. In anticipation of this staffing problem, she had hired four nurses: Hopkins, Berry, Clooney, and Estephan. Believing in the decision modeling approach to problem solving (i.e., prescriptive analytics), the administrator has interviewed each nurse, considered his or her background, personality, and talents, and developed a cost scale ranging from 0 to 100 points rating to be used in the assignment.
A 0 for Nurse Berry being assigned to the cardiology unit implies that she/he would be perfectly suited for that task. A value close to 100, on the other hand, would imply that she/he is not at all suited to head that unit. The table below gives the complete set of cost (i.e., rating) figures that the hospital administrator felt represented all possible assignments. Which nurse should be assigned to which unit?
Department |
||||
|
Nurse |
Urology |
Cardiology |
Orthopedics |
Obstetrics |
|
Hopkins |
28 |
18 |
15 |
75 |
|
Berry |
32 |
48 |
23 |
38 |
|
Clooney |
31 |
36 |
24 |
36 |
|
Estephan |
25 |
38 |
55 |
12 |
a. Define the decision variables of this problem. (3 points)
b. Provide the algebraic formulation of the objective function. (2 points)
c. Formulate this problem as an “Assignment Model” on a spreadsheet and use Excel’s Solver to determine which nurse should be assigned to which unit and the optimal rating. (Provide the corresponding “Excel Spreadsheet” and the “Answer Report”). Include “managerial statements” that communicate the results of the analyses (i.e. describe verbally the results). (15 points)
Problem 2: Transportation + Binary Integer Programming Applications (Facilities location) (35 points)
The Hardgrave Machine Company produces computer components at its plants in Kingston, ON, Quebec City, QC and Prince George, BC. These plants have not been able to keep up with demand for orders at Hardgrave’s four warehouses in Hamilton, Winnipeg, Edmonton, and Regina. The firm has therefore decided to build one new plant to expand its productive capacity to meet the demand. The two sites being considered are Sudbury, ON and Abbotsford, BC.
The tables below present the production costs and capacities for: (i) each of the three existing plants; (ii) demand at each of the four warehouses; and (iii) estimated production costs for the new proposed plants.
|
Warehouse |
Monthly Demand (Units) |
|
Hamilton |
10,000 |
|
Winnipeg |
12,000 |
|
Edmonton |
15,000 |
|
Regina |
9,000 |
Total = 46,000 units
|
Production Plant |
Monthly Supply |
Production Cost per Unit ($) |
|
Kingston |
15,000 |
$48 |
|
Quebec City |
6,000 |
50 |
|
Prince George |
14,000 |
$52 |
Total = 35,000 units
Supply needed from new plant = 46,000 – 35,000 = 11,000 units per month
|
New Plant |
Estimated Production Cost per Unit at Proposed Plants |
|
Sudbury |
$53 |
|
Abbotsford |
$49 |
Transportation costs per unit from each plant to each warehouse are summarized in the following table:
|
To: From: |
Hamilton |
Winnipeg |
Edmonton |
Regina |
|
Kingston Quebec City Prince George |
$25 $35 $66 |
$40 $30 $45 |
$55 $50 $36 |
$60 $40 26 |
|
Sudbury Abbotsford |
$30 $60 |
30 38 |
$41 $30 |
$50 $27 |
Hardgrave estimates that the monthly fixed cost of operating the proposed facility in Sudbury would be $400,000. The Abbotsford plant would be somewhat cheaper due to the cheaper cost of living at that location. Hardgrave therefore estimates the monthly fixed cost of operating the proposed facility in Abbotsford would be $325,000. Note that the fixed costs at existing plants (i.e., plants in Kingston, Quebec City and Prince George) need not be considered since they will be incurred regardless of which plant Hardgrave decides to open.
a. Formulate algebraically the above problem to help Hardgrave decide which one of the new locations, Sudbury OR Abbotsford, will yield to the lowest production and transportation cost in combination with the existing plants and warehouses. (22 points)
b. Formulate this same linear programming problem on a spreadsheet and solve using Excel’s Solver (Provide the corresponding “Excel Spreadsheet” and the “Answer Report”). Include “managerial statements” that communicate where to build the new plant to expand its productive capacity, the optimal shipping quantities from the plants to the warehouses, and the corresponding optimal shipping, production and fixed operating costs. (i.e., describe verbally the results). (13 points)
Problem 3 (25 points:15 points for (a) and 10 points for (b))
Hillier Chapter 7, 7.16 (a) and (b) ONLY (e-book page 361/362)
For (b) provide the corresponding “Excel Spreadsheet” formulation and the “Answer Report”. Include “managerial statements” that communicate which books should be published and how many of each. (i.e., describe verbally the results).
Problem 4 (20 points)
The board of directors of a large manufacturing firm is considering a set of investments shown in the following table. Let Ri be the total revenue from investment i and Ci be the cost to make investment i.The board wishes to maximize the total revenue and invest no more than a total of M dollars. Formulate this model as a Binary Integer Programming Problem (BIP). Define your decision variables and write down the algebraic formulation of the model.
CSC445 Operations Research Linear Programming
Answer in Detail
Solved by qualified expert
Get Access to This Answer
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
42 More Pages to Come in This Document. Get access to the complete answer.
MyAssignmenthelp.com has emerged as a popular cheap assignment help provider since students cannot pay much for assignments. This is why, many students prefer our college paper writing services as we provide quality at an affordable price. Students, who pay our experts to write assignments, are guaranteed to receive highest quality assignment help. Our wide range of services includes report writing help, essay help, assistance with writing dissertations, thesis help online and much more.
More CSC445 CSC445 Operations Research Linear Programming: Questions & Answers
BAM6017 Business in operation management
1. Using a diagram to support your answer, outline how Alison could present lean philosophy to the executive team? 7 Marks2. Paul explained that a significant 5S process took place only 6 months ago but ensuring compliance with the rules was proving difficult. Based on this and Alison’s observ …
View Answer
BUS300 Operations Management
Question:
Scenario
You have been working in the operations department of your organization for the past three years as a senior operational manager. Over the past two years the operational performance of the company has been declining such that the company is facing difficulties in meeting its o …
View Answer
JNB534 Commercial Ship Management
Questions:
Question 1Liner shipping companies are facing several challenges in the present business environment. Explain at least seven challenges and discuss the strategies that they can use to overcome them. Use real-world examples to support your discussion.
Question 2a) Why …
View Answer
International Marketing
Question 1You have been requested by your Marketing Director to conduct a market research project examining the market-place for soft-drinks in India and Pakistan. However, he also told that you can only use the internal resources of your own marketing department. You endeavoured to explain to your …
View Answer
Content Removal Request
If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the
content removal request.
Choose Our Best Expert to Help You
Carlos Hancock
Pursuing Master in Management with Specialization in Project Management
798 – Completed Orders
Hire Me
Brody Cox
I have acquired my PhD in Economics from Cardiff University.
1200 – Completed Orders
Hire Me
Still in Two Minds? The Proof is in Numbers!
33845 Genuine Reviews With a Rating of 4.9/5.
Assignment
Essay: 2 Pages, Deadline:
3 days
Very quick done and professional job. Helped me to gain good marks. Easy to read as answers given very clear.
User ID: 5***21 Blanchardstown, Ireland
Statistics
Home Work: 3 Pages, Deadline:
11 hours
Thank you very much… YOU ARE A GREAT WRITER ! You provide this answer and saved my life !
User ID: 8***32 Blanchardstown, Sri Lanka
Civil Law
Home Work: 3.6 Pages, Deadline:
4 hours
Thanks for the time response and helped me in successfully submitting the assignment. Thanks for this time
User ID: 8***31 United Kingdom, Great Britain
Economics
Home Work: 1.2 Pages, Deadline:
2 hours
Thanks for helping at short notice. Great quality, in the short time provided. All the best
User ID: 8***61 United Kingdom, Great Britain
Management
Assignment: 5 Pages, Deadline:
5 days
This report addresses the assignment brief very well, with much detail on Unilever online presence. The recommendation are good, and more detail/ less …
User ID: 8***01 England, Great Britain
Maths
Home Work: 1 Page, Deadline:
54 minutes
Super quick response time, great detail and construction of the solution. Many thanks for your help in this assignment. All the best
User ID: 8***61 United Kingdom, Great Britain
Maths
Home Work: 1 Page, Deadline:
1 hour
The new answer seems correct and is well explained in detail. Thank you for reviewing the work and for your help on this assignment. All the best.
User ID: 8***61 United Kingdom, Great Britain
Maths
Home Work: 1 Page, Deadline:
1 hour
Very good solution, well explained in detail. Thank you very much for your help on this assignment. All the best.
User ID: 8***61 United Kingdom, Great Britain
Finance
Essay: 4 Pages, Deadline:
7 days
Awesome work! I am fully satisfied with the quality of the content. The writers worked hard to deliver such a deep and wide content. Keep it up.
User ID: 8***46 Batu Caves, Malaysia
Nursing
Assignment: 1 Page, Deadline:
4 days
This powerpoint was neat and concise. The expert definitely followed through with what was asked.
User ID: 6***42 Batu Caves, United States
Nursing
Assignment: 12 Pages, Deadline:
5 days
well written assignment. good references and all done in a timely manner. pricing was good and support available when needed
User ID: 6***93 United Kingdom, Great Britain
Maths
Course Work: 0.4 Pages, Deadline:
2 hours
Great, very clear, thank you very much For your help on this assignment. All the best
User ID: 8***61 United Kingdom, Great Britain
Marketing
Assignment: 3 Pages, Deadline:
3 days
This website has been absolutely amazing and been very helpful and beneficial to my progress in my program.
User ID: 5***18 Mobile, United States
Electronics
Essay: 1 Page, Deadline:
7 days
seems good (ok i am only writing this because of 80 characters, what more that seems good do you want?)
User ID: 8***00 Mobile, France
Biology
Programming: 4 Pages, Deadline:
1 day
The effort and work they do is excellent and they have a great speed to complete tasks, I will always cooperate with them
User ID: 8***67 Belfast, Great Britain
Statistics
Programming: 16 Pages, Deadline:
4 days
the assignment is good which gave me a good marks and feedback i got from uni is good attempt
User ID: 6***66 United Kingdom, Great Britain
Biology
Home Work: 5 Pages, Deadline:
5 days
good and fast will use again helped me understand more I was able to incorporate the work done with mine
User ID: 8***83 United Kingdom, Great Britain
Civil Law
Home Work: 10 Pages, Deadline:
8 days
written very well, appreciate the help with writing this assignment. will definitely go through you this service again. very happy
User ID: 7***52 Brisbane, Australia
Assignment
Assignment: 4 Pages, Deadline:
14 days
awesome work was very well written and covered all basics of the assignment. appreciate the help.
User ID: 7***52 Brisbane, Australia
Organizational Behavior
Essay: 7.2 Pages, Deadline:
2 days
The content was great and right on the mark. Very comprehensive and descriptive.
User ID: 8***23 Brisbane, Australia
Assignment
Essay: 2 Pages, Deadline:
3 days
Very quick done and professional job. Helped me to gain good marks. Easy to read as answers given very clear.
User ID: 5***21 Blanchardstown, Ireland
Statistics
Home Work: 3 Pages, Deadline:
11 hours
Thank you very much… YOU ARE A GREAT WRITER ! You provide this answer and saved my life !
User ID: 8***32 Blanchardstown, Sri Lanka
Civil Law
Home Work: 3.6 Pages, Deadline:
4 hours
Thanks for the time response and helped me in successfully submitting the assignment. Thanks for this time
User ID: 8***31 United Kingdom, Great Britain
Economics
Home Work: 1.2 Pages, Deadline:
2 hours
Thanks for helping at short notice. Great quality, in the short time provided. All the best
User ID: 8***61 United Kingdom, Great Britain
Management
Assignment: 5 Pages, Deadline:
5 days
This report addresses the assignment brief very well, with much detail on Unilever online presence. The recommendation are good, and more detail/ less …
User ID: 8***01 England, Great Britain
Maths
Home Work: 1 Page, Deadline:
54 minutes
Super quick response time, great detail and construction of the solution. Many thanks for your help in this assignment. All the best
User ID: 8***61 United Kingdom, Great Britain
Maths
Home Work: 1 Page, Deadline:
1 hour
The new answer seems correct and is well explained in detail. Thank you for reviewing the work and for your help on this assignment. All the best.
User ID: 8***61 United Kingdom, Great Britain
Maths
Home Work: 1 Page, Deadline:
1 hour
Very good solution, well explained in detail. Thank you very much for your help on this assignment. All the best.
User ID: 8***61 United Kingdom, Great Britain
Finance
Essay: 4 Pages, Deadline:
7 days
Awesome work! I am fully satisfied with the quality of the content. The writers worked hard to deliver such a deep and wide content. Keep it up.
User ID: 8***46 Batu Caves, Malaysia
Nursing
Assignment: 1 Page, Deadline:
4 days
This powerpoint was neat and concise. The expert definitely followed through with what was asked.
User ID: 6***42 Batu Caves, United States
Nursing
Assignment: 12 Pages, Deadline:
5 days
well written assignment. good references and all done in a timely manner. pricing was good and support available when needed
User ID: 6***93 United Kingdom, Great Britain
Maths
Course Work: 0.4 Pages, Deadline:
2 hours
Great, very clear, thank you very much For your help on this assignment. All the best
User ID: 8***61 United Kingdom, Great Britain
Marketing
Assignment: 3 Pages, Deadline:
3 days
This website has been absolutely amazing and been very helpful and beneficial to my progress in my program.
User ID: 5***18 Mobile, United States
Electronics
Essay: 1 Page, Deadline:
7 days
seems good (ok i am only writing this because of 80 characters, what more that seems good do you want?)
User ID: 8***00 Mobile, France
Biology
Programming: 4 Pages, Deadline:
1 day
The effort and work they do is excellent and they have a great speed to complete tasks, I will always cooperate with them
User ID: 8***67 Belfast, Great Britain
Statistics
Programming: 16 Pages, Deadline:
4 days
the assignment is good which gave me a good marks and feedback i got from uni is good attempt
User ID: 6***66 United Kingdom, Great Britain
Biology
Home Work: 5 Pages, Deadline:
5 days
good and fast will use again helped me understand more I was able to incorporate the work done with mine
User ID: 8***83 United Kingdom, Great Britain
Civil Law
Home Work: 10 Pages, Deadline:
8 days
written very well, appreciate the help with writing this assignment. will definitely go through you this service again. very happy
User ID: 7***52 Brisbane, Australia
Assignment
Assignment: 4 Pages, Deadline:
14 days
awesome work was very well written and covered all basics of the assignment. appreciate the help.
User ID: 7***52 Brisbane, Australia
Organizational Behavior
Essay: 7.2 Pages, Deadline:
2 days
The content was great and right on the mark. Very comprehensive and descriptive.
User ID: 8***23 Brisbane, Australia
