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 how do mncs analyze this risk, In the context of International busi...

In the context of International business, what is meant by the term Cpolitical risk? In general, how do MNCs analyze this risk?

Capacity planning and controlling, #theories and techniques can help if app...

#theories and techniques can help if applies properly.

Explain the common grounds for discharge, Describe the common grounds for d...

Describe the common grounds for discharge and the procedural requirements that are outlined in many collective bargaining agreements. State why the following are important when the

Gravity center of method, hello , we need to news of practical example of c...

hello , we need to news of practical example of company''s gravity of method

Line balancing, what do you understand by line balancing what happens if ba...

what do you understand by line balancing what happens if balance doesn''t exist?

Explain the role of managers in quality and patient safety, What is the rol...

What is the role of managers in quality and patient safety?

Explain score for energy cost increases, Daniel Tracy, owner of Martin Manu...

Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a location for this factory has been narrowed to four sites: A, B, C and D. The f

ERP implementation, These 7 to 8 page essay is a synthesis paper on critic...

These 7 to 8 page essay is a synthesis paper on critical success factors for ERP implementations. For this assignment, the general topic has been provided to you – critical success

How to increase customer satisfaction, Question: (a) Show how supply ch...

Question: (a) Show how supply chains can be managed more effectively to provide more effective service delivery in order to increase customer satisfaction, while also increasin

Explain how is the critical incident technique, 1) How do effective manager...

1) How do effective managers assess performance and what is the role and process of the Behaviourally Anchored Rating Scale (BARS)? 2) How is the critical incident technique used t

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