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 value differences among national cultures, What are some managerial...

What are some managerial styles you would employ in managing an emloyee who is considered baby boomer List and explain hofstedes five dimensions of value differences among natio

Find annual sales is thousands of bottles, Problem 3-5 A cosmetics manufact...

Problem 3-5 A cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream. Ft = 80

Explain similar job classifications, When you look at the pay of unionized ...

When you look at the pay of unionized employees vs non-union in similar job classifications, what are the differences in terms of amount of pay, how the pay levels are determined,

Explain direct effects and indirect effects of goals, What is the differenc...

What is the difference between direct effects and indirect effects of Goals on choice of strategy?

Dicuss business and conduct a feasibility analysis, Develop an idea for a n...

Develop an idea for a new business and conduct a feasibility analysis. Please be as creative as you like in the development of your idea (but as careful as you can be in your analy

Illustrate your discussion using a service organisation, Question 1: "Y...

Question 1: "Yield management guides the decision of how to allocate undifferentiated units of capacity to available demand in such a way as to maximize profit or revenue." Cri

Explain what are the pros and cons of the control system, What kind of cont...

What kind of control systems are being used to measure the performance of hospitals and their different kinds of employees such as doctors and nurses? What are the pros and cons

Explain artists and producers royalties, Downloading music, radio, and vide...

Downloading music, radio, and video programs from the Internet is easier than in the past, but some companies are still worried that people will illegally obtain copies of this pro

Explain dual chains of command can create more problems, Some people argue ...

Some people argue that the matrix structure should be adopted only as a last resort because the dual chains of command can create more problems than they solve. Discuss. Do you agr

I want examples of some of these that are associated stories, I need exampl...

I need examples of some of these that are associated with the university. Liberty University. I know what they are i just need help with stories or exaples of these things that are

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