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 what is a learning organization?, Q1. What is a learning organizati...

Q1. What is a learning organization? Q2. 1. "JUST DO IT" advertisement for Nike. What is the marketing purpose of this slogan? Is this slogan effective? 2. "DAIMONDS ARE FORE

Explain improvement that would benefit any organization, From the video, de...

From the video, determine how the hiring practices at Barcelona Restaurant Group could be leveraged at businesses that do not have such a tight focus on customer service. Provide s

Cisco systems NPI, 1. Using an appropriate operations framework outline the...

1. Using an appropriate operations framework outline the challenges / risks faced by Cisco in introducing a new product. 2. What are the general operational / supply chain issues i

Explain the term organisation structure, Explain the term organisation stru...

Explain the term organisation structure. It is the systematic arrangement of the people doing work for the organisation so as to achieve predecided goals.  This structure is

Calculate the effectiveness of the police department, Q1. What recommendati...

Q1. What recommendations can you offer Dick Enrico to improve his chances of staying successful for the rest of his career? Normal 0 false fal

Line balancing, what do you understand by line balancing? what happens if b...

what do you understand by line balancing? what happens if balance does not exist?

What are the chase demand strategies, What are the Chase demand strategies?...

What are the Chase demand strategies? Chase demand strategies: It is just the opposite of a level capacity strategy. The organisation frequently chases customer demand an

Explain different types of business models, Give examples of a pair of comp...

Give examples of a pair of companies in an industry that pursue different types of business models? Explain the business models and how they differ. EXAMPLE. First come first serve

Explain does a valid contract exist between two persons, You are currently ...

You are currently an intern working for the largest law firm in Alabama. Your mentor and senior attorney introduces you to a new client, Dick Jefferson, the owner of House Doctor,

Ghant for Inventory Control, Hello! I need some help creating a ghant shed...

Hello! I need some help creating a ghant shedule for silo bins. I am harvesting, and I have large grain bins which will be filled depending on how fast we harvest. I also need to

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