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

Describe innovative and creative ways, Discuss innovative and creative ways...

Discuss innovative and creative ways to use the patient ID bracelet containing a bar-code representation of the patient's ID and a bar-code scanner that could lead to improved qual

Employee involvement will enhance decision making quality, As OB practition...

As OB practitioners we know that emotions form preferences before we consciously evaluate those choices and this impacts the quality of the decisions made at the company. The presi

Described in the initial kickoff meeting for a project, Which of the follow...

Which of the following would be the first item to be discussed in the initial kickoff meeting for a project? Answer Understanding of the requirements Understanding of the

I need to cancel my order i made earlier today, I want to cancel my order I...

I want to cancel my order I made earlier today. How do I do this and get a full refund?

Explain reporting biases can occur, The use of surveys of experts to estima...

The use of surveys of experts to estimate long-run production costs may be undermined by the fact that- Reporting biases can occur It is dependent on the judgments of individ

Location decision and layout selection, 1. general procedures for making lo...

1. general procedures for making location decision 2. factors to consider in layout selecgtion

Explain a way in which resistance to change can be reduced, According to di...

According to dictionary.com, the term change is defined as follows: -verb (used with object) 1. to make the form, nature, content, future course, etc., of (something) different

Explain line and staff organisation, Explain Line and Staff Organisation. ...

Explain Line and Staff Organisation. Line and Staff Organisation: When the industry grew in size and complicated, the line executives could not perform appropriately all othe

Explain inventory decreases and inventory increases, What happens to invent...

What happens to inventory as the number of kanban cards increases? Inventory decreases Inventory increases Inventory remains the same The number of kanban cards has no

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