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

Patient management, i want to no how they management patient were to start...

i want to no how they management patient were to start up to the end

Explain spread harmful rumours gossips uses bad language, Sara spread harmf...

Sara spread harmful rumours gossips uses bad language and lack civility in relationship while at work/ in which of the following is sarah engaging in/1.proert deviance/ 2 productio

Define monte carlo simulation is a technique used as part of, Monte Carlo s...

Monte Carlo simulation is a technique used as part of: Answer Risk identification Risk assessment Risk monitoring and control Risk handling

Explain characterize the bacterial and bacterial-like, Characterize the bac...

Characterize the bacterial and bacterial-like STIs, focusing on infectious agents and manifestations

Important functions of maintenance department, Problem 1: What are the ...

Problem 1: What are the important functions of maintenance department? Day to day activities Keeping the machinery, equipment, and services in proper working condition

Responsiveness - customers needs for a product, Responsiveness - Customers ...

Responsiveness - Customers Needs for a Product How quickly the operations system reacts to changes in customer demand. This may be considered as customisation but in terms of

Define the operation process, Recalling your participation in Workshop 1, i...

Recalling your participation in Workshop 1, identify a process at your organisation that has been or could be analysed and/or improved using simulation (via software such as Extend

Explain cutting edge or don''t have a lot of precedents, In what ways do yo...

In what ways do you think that scoping projects that are cutting edge or don't have a lot of precedents is a problem, and how do you think a project manager can address this

Describe ways of improving decision making process, Question 1: (a) Exp...

Question 1: (a) Explain the specific steps you would take to ensure that an individual has the appropriate abilities to satisfactorily do a given job. (b) Explain  the four

Explain what is the dpmo measure, 1) The following table lists all costs of...

1) The following table lists all costs of quality incurred by Sam's Surf Shop last year. What was Sam's appraisal cost for quality last year? Annual inspection costs $ 155,000

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