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 car rental agency that calculates rental charges, Create a project ...

Create a project for the local car rental agency that calculates rental charges. The agency that calculates $15 per day plus $0.12 per mile. Form: Use text boxes for the customer n

What impacts are there if any of the project team is leftout, There are 3 m...

There are 3 main components to the systems implementation process, which are, organizing the team, determining project scope and expectations and establishing a project plan. Each

Automation trends in operations management, how automation helps in trends ...

how automation helps in trends of operations management

Succession planning and workforce plan evaluation, Succession Planning and ...

Succession Planning and Workforce Plan Evaluation Develop a succession plan that addresses internal labour needs in the medium to long term, utilising succession planning princ

Explain who is most likely to win the business, A Chicago-based manufacture...

A Chicago-based manufacturer is looking for someone to handle its shipments to the West Coast. In order to evaluate potential transportation providers, the manufacturer has develop

Explain strategic decisions influence the power of the party, Determining t...

Determining the bargaining unit occurs before certification is obtained whereas determining the bargaining structure occurs after, but both strategic decisions influence the power

Explain symptoms related to customer contact, Unit 1 Discussion Suppose you...

Unit 1 Discussion Suppose you were conducting a marketing analysis for a new textbook about technology management. What would you need to know to identify a market segment? How wou

Explain which an organization can be engaged be engaged, The categories of ...

The categories of global participation in which an organization can be engaged be engaged

Explain was any sexual harassment involved in this situation, Was any sexua...

Was any sexual harassment involved in this situation? If so what kind was it?

Make scope statement for this project that contains examples, You are in ch...

You are in charge of organizing a dinner-dance concert for a local charity. You have reserved a hall that will seat 40 couples and have hired a jazz combo. Develop a  of all the

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