The goal of this software assignment is to use Integer Programming to allocate treatment capacity to different cancer centers over a planning horizon

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Software Assignment

The goal of this software assignment is to use Integer Programming to allocate treatment capacity to different cancer centers over a planning horizon. Read the case description provided in a separate PDF file carefully and take the following steps:

(a) Formulate an IP to minimize the excess of demand over capacity across all cancer centers over the planning horizon.

I. What are the input data?

II. Define the decision variables.

III. Define the objective function.

IV. Define the constraints.

(b) Use Microsoft Excel Solver/OpenSolver to solve your IP formulation.

(c) Report the optimal allocation obtained from Microsoft Excel Solver following the table format provided below.

 

Cancer Center	Number of LINACS Allocated
	2013	2014	2015	2016	2017	Total
1
2
…

 

(d) Submit a report (PDF or MS Word document) describing your IP formulation as well as the optimal capacity allocation. Additionally, make sure to submit your final Excel spreadsheet containing your Excel Solver/OpenSolver model. Submissions not accompanied by the related Excel Solver/OpenSolver model will receive a grade of zero.

Attachments:

Expert's Answer

1458 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme