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

What are the advantages of the chase demand strategies, What are the advant...

What are the advantages of the chase demand strategies? The advantages of the chase demand strategies are as illustrated below: a. Flexible utilisation of resources for inst

Define what is a principle within a health care organization, What is a pri...

What is a principle within a health care organization?

Describe customer-contact matrix perspective, Describe a company of your ch...

Describe a company of your choice from the customer-contact matrix perspective. Discuss the operations of the organization from your perspective using the three elements of the cus

Explain is herzog a partner in the a1a car wash business, White, Fring, and...

White, Fring, and Pinkman are partners in the operation of the A1A car wash. Without Fring's knowledge, White and Pinkman sold 10 percent of their interest in the business and its

Explain collective bargaining, Collective bargaining replaces management's ...

Collective bargaining replaces management's traditional authority to unilaterally establish terms and conditions of employment with bilateral negotiations. How has the collective b

What are programmed and non-programmed decisions, What are programmed and n...

What are programmed and non-programmed decisions? Programmed decisions are which made in accordance with some procedure, rule or habit. Non-Programmed decisions are those which

Explain how would you evaluate this contest, Part 2: Case Floor-Shine Clea...

Part 2: Case Floor-Shine Cleaning Products Case Focus: This case illustrates the use of a sales contest in an attempt to boost sales. Several potential problems resulting fro

Explain understanding of human behaviour, Explain understanding of human be...

Explain understanding of human behaviour. Understanding of Human Behaviour: Understanding human behaviour is significant for any one dealing along with human resources. This

Process through bank supply its customer with cash on demand, 1. Think of f...

1. Think of four different processes by which a bank might supply its customers with cash on demand. Answer: Examples: over-the-counter at branches, by ATM dispensers in shoppin

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