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

List the five styles of leadership are situational, The five types of leade...

The five types of leadership styles are most applicable in certain situations. Discuss the applicability of each of the five types in project leadership situations and its usefulne

Explain logos and ethos and pathos, Explain what Logos, Ethos and Pathos ar...

Explain what Logos, Ethos and Pathos are and their relevance to being understood. Also discuss their preferred order of use. Construct an example following this model. Grading r

Explain what will be the average tardiness of these orders, A single machin...

A single machine work center has five jobs assigned to it. They are labeled, in the order of their arrival in the shop, as jobs A, B, C, D and E. The work center may work on only o

Interaction - service process matrix, Interaction - Service Process Matrix ...

Interaction - Service Process Matrix Interaction refers to the degree to which the customer can intervene in the process (eg in a restaurant, the customer may call a waiter at

Activities of operation manager in operation management, Responsibilities o...

Responsibilities of Operations Managers in Operation Management The responsibilities of operations managers  1. Understand and participate in setting business strategy

Explain what would be the impact of purchasing electronic, What would be th...

What would be the impact of purchasing electronic slot machines that do not use coins?

Explain what are the issues of management, What are the issues of managemen...

What are the issues of management does the Rhino Capture in Kruger National Park face and how are they analysed and evaluated?

Advantages of work measurement, Advantages of Work Measurement: 1.    ...

Advantages of Work Measurement: 1.        It serves as a basis  for  methods  analysis by comparing  the efficiency  of alternative  work  method. Other  conditions  beings  t

Describe the steps accuracy of the information, Rate, from the best to the ...

Rate, from the best to the worst, each of the sources you indicated in #1 above as being sources you will use in your analysis in terms of its probable reliability. Discuss the ste

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