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 estimate of the dates of the milestones, You are in charge of organ...

You are in charge of organizing a dinner-dance concert for a local charity. You have reserved a hall which will seat 30 couples and have hired a band. Develop a scope statement for

Describe traffic accidents requiring medical assistance, It has been observ...

It has been observed that the average number of traffic accidents requiring medical assistance in Santa Clara between 7 and 8 AM on Wednesday mornings is 1. What, then, is the chan

What are few strategies that you might in order to achieve, Suppose you are...

Suppose you are the CEO of a growing fast food company, specializing in hamburgers. You are interested in expanding your business into new domains. What are some strategies that yo

Libertarian view on the importance of consumer rights, Compare a Utilitaria...

Compare a Utilitarian and a Libertarian view on the importance and enforcement of consumer rights.

Explain human resource role, A program that provides employee relocation an...

A program that provides employee relocation and trailing spouse employment assistance is an example of which human resource role: Answer A) counsellor B) employee advocate C) strat

Explain implementation of a transnational strategy, What do you see as the ...

What do you see as the main organizational problems that are likely to be associated with implementation of a transnational strategy? Explain

Explain stanley milgram''s famous experiment, Describe Stanley Milgram's fa...

Describe Stanley Milgram's famous experiment. What are its most significant implications?

Define summarize the organization technological solution, 1. Briefly summar...

1. Briefly summarize the organization technological solution. 2. Would you classify this as an enterprise or workgroup solution (review the Case Study Areas of Focus document in

Define disputes and the contractual means used for resolving, What is the c...

What is the cause of disputes and the contractual means used for resolving them?

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