代写运筹学作业 OPERATIONS RESEARCH代写 线性规划代写
41OPERATIONS RESEARCH Exercises Linear Programming 代写运筹学作业 Ex 1 A retailer wants to obtain a quantity no less than five tonnes of a certain product. The product can be ordered from ...
View detailsSearch the whole station
运筹学课业代写 ADM2302 students are reminded that submitted assignments must be typed (i.e., can NOT be hand written), neat, readable, and well-organized.
ADM2302 students are reminded that submitted assignments must be typed (i.e., can NOT be hand written), neat, readable, and well-organized. Assignment marks will be adjusted for sloppiness, poor grammar, spelling mistakes and technical errors. Submitted assignment solutions (if applicable) must include “managerial statements” that communicate the results of the analyses in plain language. 运筹学课业代写
The assignment is to be submitted electronically as a single PDF Document file via Brightspace by the updated new date Wednesday November 24 th prior to 23:59. The front page of the PDF document must include the title of the assignment, the course code and section, and the student’s name and number. The second page is the SIGNED Statement of Integrity.
Note: Each student must provide an individual original submission of completed Assignment #2.
Assignment 2 is an individual effort. The student must complete it individually (i.e., alone). Failing to do so is considered academic fraud. Paying someone to assist with solving it (i.e., Tutor), or joining a group on WhatsApp/Discord seeking the answers…, or using an online service website like Chegg to find the answers to questions are considered acts of plagiarism.
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?
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)
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 |
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.
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)
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” of the optimal decision plan that will meets the electrical needs for the day at the minimum cost. (i.e., describe verbally the results).
The board of directors of a large manufacturing firm is considering a set of investments shown in the following table. Let R_{i} be the total revenue from investment i and C_{i} 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.
更多代写：Cs网课托管 多邻国考试作弊 英国EAP代写代考 compare essay代写 Conclusion写作格式 鉴别专业代写机构
合作平台：essay代写 论文代写 写手招聘 英国留学生代写
OPERATIONS RESEARCH Exercises Linear Programming 代写运筹学作业 Ex 1 A retailer wants to obtain a quantity no less than five tonnes of a certain product. The product can be ordered from ...
View details