运筹学课业代写 二进制编程代写 线性规划代写 ADM2302代写

ASSIGNMENT # 2

Transportation, Assignments, and Integer/Binary Programming Problems

运筹学课业代写 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.

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?

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

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” of the optimal decision plan that will meets the electrical needs for the day at the minimum cost. (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 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代写 论文代写 写手招聘 英国留学生代写