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 in what ways might using it, In what ways can tale presence help in...

In what ways can tale presence help increase a company's efficiency and effectiveness-for example, efficiency or customer responsiveness? 2. What are the possible drawbacks or dang

Explain how the market value of the shares, St James Ltd. Has just paid a d...

St James Ltd. Has just paid a dividend of £0.22 per share. The market expects this dividend to grow constantly in each future year at the rate of 7% p.a. The cost of capital for St

Service profit chain - operation strategy, Service Profit Chain - Operation...

Service Profit Chain - Operation Strategy Prior to their work on the service-profit chain, Heskett and colleagues produced what they considered as the linkages between the emp

Process charts - process design, Process Charts - Process Design The ...

Process Charts - Process Design The process flow chart is probably the most commonly used means of recording, and comes in several variants. Each of them uses some, or all, o

Explain an increased velocity in sensing and responding, Discuss an example...

Discuss an example of an unknown-unknown risk that proved damaging to a supply chain. Explain how the following strategies might have mitigated this risk: • Investment in redund

Explain methods of ''on - the job training'' for managers, Explain methods ...

Explain methods of 'On - the Job Training' for Managers. Methods of 'On - the Job Training' for Managers : (i) Experience: In this method a person who is to do something a

Successful writing at work, Ask qu Write an appropriate proposal—internal, ...

Ask qu Write an appropriate proposal—internal, solicited sales, or unsolicited sales—based on the information contained in one of the following two articles. Assume that your or yo

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?

Explain is herzog a partner in the a1a car wash business, White, Fring, and...

White, Fring, and Pinkman are partners in the operation of the A1A car wash. Without Fring's knowledge, White and Pinkman sold 10 percent of their interest in the business and its

Explain sales-force composite, List the specific weaknesses of each of thes...

List the specific weaknesses of each of these approaches to developing a forecast: a. Consumer surveys. b. Sales-force composite

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