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 the common grounds for discharge and the procedural, Describe the c...

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

Explain how would you make a needs assessment, Suppose you were conducting ...

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 would you make a need

MB 0044 - Production and Operation Management, What do you understand by “l...

What do you understand by “line balancing”? What happens if balance doesn’t exist?

Describe human resource management, The impact Spurlock v. United Airlines ...

The impact Spurlock v. United Airlines (1972) has made to Human Resource Management.

Explain the capability index, Q 1 The capability index (Cpk) calculates the...

Q 1 The capability index (Cpk) calculates the percentage of items being produced within specifications. Q 2 Design quality in products refers to the degree to which a product or

Explain streaming video, Streaming Video: The Job Market for Graduates DQ V...

Streaming Video: The Job Market for Graduates DQ Video Document Discussion Topic What is your opinion of the interviewing tips given in the video? Which tips of your own would you

Explain evaluation or rewards systems a source of conflict, How are differe...

How are different evaluation or rewards systems a source of conflict?

Explain why employees join unions, Over which of the principle reasons why ...

Over which of the principle reasons why employees join unions does a supervisor have the most direct control?

Explain terms of developing a project plan, In terms of developing a projec...

In terms of developing a project plan, specifically recommend how this resource could expedite that process.

Why needed physicians and licensed independent practitioners, Why do you th...

Why do you think health care organizations are held accountable for ensuring the competence of their physicians and licensed independent practitioners?

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