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 justify a strategic information system, Why might it be difficult t...

Why might it be difficult to justify a strategic information system?

Poor industrial relations vs.a conditions for good ir, Explain causes of Po...

Explain causes of Poor Industrial Relations vs.a conditions for good IR. Insufficient fixation of wages and wage structure - There is a requirement for payment of fair wag

Explain management techniques, Provide two examples of current leaders and ...

Provide two examples of current leaders and describe how they demonstrate their leadership characteristics. What separates these characteristics from management techniques? How eff

How to write goodwill message to a client, Need to know how to write a prof...

Need to know how to write a professional Goodwill Message goodwill is that intangible that makes the world go round. With our overtasked lives, I'm not sure it is getting the at

Explain what opportunities in the marketing environment, What opportunities...

What opportunities in the marketing environment did Gannet seize in launching USA? What unmet benefits are added and what value is created for the customer by USA Today?

Explain internet for marketing communications, How you Google's do expected...

How you Google's do expected dominance of the online display advertising market will affect marketers who already use the Internet for marketing communications? Will its push into

The abc system, The ABC system is a method of  Managing inventory.

The ABC system is a method of  Managing inventory.

Explain efects in the accounts receivable department, Category- 1) Invoi...

Category- 1) Invoice Amount does not agree with check amount 2) Invoice not on record 3) No formal invoice issued 4) Check (payment) not recieved on time 5) Check no

Explain social responsibility on the part of businesses, What are the argum...

What are the arguments for and against social responsibility on the part of businesses? Research the topic and discuss. In addition, which set of arguments is more compelling?

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