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 what is the probability distribution of the time, Consider a queuin...

Consider a queuing system with 2 types of customers. Type 1 customers arrive according to a Poisson process with a mean rate of 5 per hour. Type 2 customers arrive according to a P

Describe what would be the total number of workers, In the precedence chart...

In the precedence chart to the right, times are in seconds. 1 Assume that the plant runs one 7.5 hour shift per day and the assembly line is designed with 5 stations (one worker pe

Multifactor productivity, A company that makes shopping carts for supermark...

A company that makes shopping carts for supermarkets and other stores recently purchased some new equipment that reduces the labor content of the jobs needed to produce the shoppin

Explain characteristics of database backup, Discuss the importance and char...

Discuss the importance and characteristics of database backup and recovery procedures. Then, describe the actions that must be detailed in backup and recovery plans?

Describe corruption and bribery, Corruption and bribery are common in some ...

Corruption and bribery are common in some countries. Would you simply avoid locating in such a country, or locate there and deal with it? If the latter, how would you deal with it?

Explain hierarchy of managers, 1. What are the common characteristics of al...

1. What are the common characteristics of all companies? Can a manager have operation responsibilities? Explain. What are three characteristics that a manager must have to be succe

Give a specific definition of time study, Give a specific definition of tim...

Give a specific definition of time study. Time study It is defined as a work measurement technique for recording the times and rate of working for the component of a speci

Explain what is the relationship between swot and strategy, What is the rel...

What is the relationship between SWOT and Strategy? Provide real world examples. Additional research is necessary by using scholarly publications. Cite accordingly.

Define the negative impacts of business intelligence, What are the negative...

What are the negative impacts of business intelligence? How does a database and data warehouse support business intelligence?

Constraint Management, Elucidate Theory of Constraints and constraint manag...

Elucidate Theory of Constraints and constraint managment

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