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 fairly complex for job shops, Why is scheduling fairly simple for r...

Why is scheduling fairly simple for repetitive systems but fairly complex for job shops?

Explain traditionally non-user input environment, To what extent should end...

To what extent should end users be involved in the design of a database? How have our ideas of agile development environments affected this traditionally non-user input environment

Gantt load chart, Gantt Load Chart The Gantt charts were developed by...

Gantt Load Chart The Gantt charts were developed by Henry L. Gantt about a century ago. Their purpose is to provided an immediate comparison between schedule an reality ( i,

Pressume that a security model is needed for the protection, Assume that a ...

Assume that a security model is needed for the protection of information in your class. Using the CNSS model, examine each of the cells and write a brief statement on how you would

Explain can you provide examples of voluntary boundaries, Can you provide e...

Can you provide examples of voluntary boundaries, core practices, and mandated boundaries in various industries? Why do the boundaries you identify fit within each category?

Gantt chart, Gantt Chart The Gantt chart were made by Henry L. Gantt ...

Gantt Chart The Gantt chart were made by Henry L. Gantt approximately a century ago. Their aim is to provide an immediate comparison between schedule and realty( i.e. among p

Find the number the number of meals and the amount of sales, The restaurant...

The restaurant would serve dinner Tuesday through Saturday. Brian has noticed a restaurant for lease. The restaurant has seven tables, each of which can seat four. Tables can be mo

Explain production budget, Explain production budget. A production bu...

Explain production budget. A production budget may be made by production manager in consultation along with his assistants after obtaining the sales Budget. A production budg

Management consultant firm, After working for 30 years, Ramjee Somjee Dutt ...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busine

Compute the optimal quantity and period for this problem, A large supplier ...

A large supplier of electronic components has decided to control the inventory of a certain item by a periodic review, order up to R policy. The mean demand rate for this item is 5

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