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 areas of internal systems and technology, Given that the question o...

Given that the question of open and closed systems is more of a continuum than a yes/no question, do you believe that more closed systems are better able to assess and improve thei

Mathematical analysis of the normal distribution curve, Mathematical Analys...

Mathematical Analysis of the Normal Distribution Curve Mathematical analysis of the normal distribution curve has produced data tables which provide population statistics in r

Explain what will be dividend pay-out ratio, Axel telecommunications has a ...

Axel telecommunications has a target capital structure that consists of 70% debt and 30% equity. The company anticipates that its capital budget for the upcoming year will be $3mil

Computer the reorder point, (b) Suppose Norwitch has worked out a new contr...

(b) Suppose Norwitch has worked out a new contract, accepted by all its customers, of being allowed up to one week to satisfy each demand. Norwitch still uses a 99% "fill rate" as

Describe the scope of the business process outsourcing, List five considera...

List five considerations to consider when starting to define the scope of the business process outsourcing transaction and discuss the importance of each in relation to outsourcing

Determine the order size that will minimize the total cost, You are the Sto...

You are the Stores Manager at the Ministry of Information and you have the responsibility of managing store room No. 101 where all blank papers for this Ministry are kept. The ann

Mass Production and Continuous Flow Manufacturing, Mass Production and Cont...

Mass Production and Continuous Flow Manufacturing  Continuous systems lie at the other extreme, where demand for a single product is sufficiently high to warrant the installa

What is the relationship among companies and profit motives, What is the re...

What is the relationship between companies, profit motives, competition and private property?

Operation strategy for globaltel in Asia, write a list of elements that sho...

write a list of elements that should be included in an operations strategy for global tel

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