Formulate an integer programming model using excel solver, Operation Management

Assignment Help:

New fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into five tracts, with no more than one fire station to be located in any given tract. The decisions to be made consist of the tracts to receive a fire station and the assignment of each of the tracts to one of the fire stations. The objective is to minimize the overall average of the response times to fires.

The following table gives the average response times to a fire in each tract if that tract is served by a station in a given tract. The bottom row gives the forecasted number of fires that will occur in each of the tracts per day.

Formulate an integer programming model for this problem and solve it using Excel Solver.


Related Discussions:- Formulate an integer programming model using excel solver

Considering strategic choice - operation strategy, Considering Strategic Ch...

Considering Strategic Choice - Operation Strategy (Strategic analysis will be covered in Strategy - Analysis and Evaluation).  The following points are an extract from Port

Explain how can i get the solutions, I would like to know how can i get th...

I would like to know how can i get the solutions maual for the book systems analysis and design 9th edition by kendall & kendall can you please let me know how to do it

Explain how might you use quality tools to determine, a) Determine the valu...

a) Determine the value of the p-bar, the mean fraction defective. Then determine the control limits for the p-chart using 99.73% confidence level (3 standard deviations). Is this p

Explain ethical dilemma, Ethical Dilemma CRM: Targeting or Discriminating? ...

Ethical Dilemma CRM: Targeting or Discriminating? Are they ethical? Why or why not.

Market forecasting methods for predicting demand levels, What are the marke...

What are the market forecasting methods for predicting demand levels? Market forecasting methods for predicting demand levels: a. Survey or sample of buyer’s intentions pr

Explain negotiable instrument, Nan read the note that Tom had just given he...

Nan read the note that Tom had just given her. She was doing some home repair for Tom. The note represented the $10,000 that Nan and Tom agreed upon for all of the work. The note r

Explain how can product development costs be minimized by, How can product ...

How can product development costs be minimized by entering the market late

Define coaches are matched to their situation, Word paper that analyzes the...

Word paper that analyzes the two leadership case studies, "Coach Knight: A Will to Win" and "Coach K: A Matter of the Heart." Address the following questions and concepts:

Customer satisfaction and service quality, Customer Satisfaction and Servic...

Customer Satisfaction and Service Quality - Operation Strategy Although you have seen examples of the dimensions along which companies compete and approaches to operations st

Justify the duration of the simulation and assumptions, Alabama Airlines op...

Alabama Airlines opened its doors in June 1995 as a commuter service with its headquarters and only hub located in Birmingham. A product of airline deregulation, Alabama Air joined

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd