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

Explain why is following up important with participants, Why is following u...

Why is following up important with participants who did not show up for their scheduled participation in your research?

What is the process mapping, What is the process mapping? Process map...

What is the process mapping? Process mapping: For processes to be enhanced they should first be demonstrated. Flow charts can help the use of process mapping as an exampl

Explain the challenges in using the mbti instrument, Describe the challenge...

Describe the challenges in using the MBTI instruments or Keirsey Temperament sorter in project management situation and how you would address them. Speculate the acceptance level o

Explain actionable claim for discrimination under ada, 1. If Rosa hires Cal...

1. If Rosa hires Caleb and after working for two months, Caleb requests additional time off to take care of his ailing wife and Rosa denies his request: A. Caleb has an actionab

Stepping stone method, what advantage and disadvantage stepping stone metho...

what advantage and disadvantage stepping stone method?

Explain can you provide examples of voluntary boundaries, Can you provide e...

Can you provide examples of voluntary boundaries, core practices, and mandated boundaries in various industries? Why do the boundaries you identify fit within each category?

Explain what is the average setup cot per year, Radovilsky Manufacturing Co...

Radovilsky Manufacturing Company, in Hayward. California. Makes flashing lights for toys. The company operates its production facility 300 days per year. It has orders fo about 12,

Explain why is mis one of the most important courses, Why is MIS one of the...

Why is MIS one of the most important courses for a business student?

Explain benefits of using qualitative and quantitative data, Compare and co...

Compare and contrast the benefits of using qualitative and quantitative data collection methods as they apply to organizational development (OD).

Explain triangular distribution, An Accute care facility treats non-emergen...

An Accute care facility treats non-emergency patients (cuts, cold, etc.). Patients arrive according to an exponential interarrival-time distribution with a mean of 11 (all times in

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