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

Why benefits are strategically important to employers, Why benefits are str...

Why benefits are strategically important to employers, and what are some key strategic considerations?

Explain what are the coordinates of the central location, A small rural cou...

A small rural county has experienced unprecedented growth over the past 6 years, and as a result, the local school district built the new 500-student North Park Elementary School.

Explain socially responsible company, In light of these actions, can GM sti...

In light of these actions, can GM still be a socially responsible company? If so, how?

Explain type of franchise network, Why is it that small businesses like Col...

Why is it that small businesses like Cold Stone Creamery are at a disadvantage as they pursue non-Web-based international expansion strategies? What other international markets is

Ramjee Somjee Dutt, After working for 30 years, Ramjee Somjee Dutt opted fo...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busine

What is grapevine, What is Grapevine? Ans: Grapevine is an informal ...

What is Grapevine? Ans: Grapevine is an informal communication system.

MBA-2, What do you understand by"line balancing"?What happens if balance do...

What do you understand by"line balancing"?What happens if balance doesn''t exist?

What steps must to be taken to maximize the sales-price, Identify key gaps ...

Identify key gaps in planning for the exit. Provide recommendations on the exit strategy. Is the sale the right one? What steps ought to be taken to maximize the sales-price? What

Compute the standard time for each work, The Arkade Company has decided to ...

The Arkade Company has decided to use a 15 percent allowance factor based on job time. Calculate the standard time for each work element and for the total job. The frequency equals

What is industrial mnagement, What is industrial mnagement? Explain. ...

What is industrial mnagement? Explain. Industrial Management: Industrial Management includes guidance, leadership and control or efforts of a group of individuals toward sev

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