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 separately compiled modules of a program, A system program that com...

A system program that combines the separately compiled modules of a program into a form suitable for execution A. assembler B. linking loader C. cross compiler D. load

Explain customers preferred bidders list for future contract, A customer is...

A customer is unhappy with the performance thus far on a project. The customer states that, unless scope changes are made at the contractors expense, the contractor would be remove

Case Study, Combine your list with the lists of a few other class members a...

Combine your list with the lists of a few other class members and categorize the items under a series of major headings.

Use cases, A case study presents an account of what happened to an organisa...

A case study presents an account of what happened to an organisation or business over a period of time. It chronicles the events that occurred within that organisation and which th

Explain project management body of knowledge, Definition of a Project" •Acc...

Definition of a Project" •According to the Project Management Body of Knowledge (PMBOK), explain one of the major knowledge areas and why it is important to project management. Eva

Explain what is the tax on salvage value, Mars Inc. is considering the purc...

Mars Inc. is considering the purchase of a new machine that will reduce manufacturing costs by $5,000 annually. Mars will use the MACRS accelerated method to depreciate the machine

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?

Explain approaches that project managers, Project managers frequently face ...

Project managers frequently face competing constraints. Identify these common constraints and describe approaches that project managers can use to make the trade-offs required to s

Explain secure an access database, 1. To delete the filter shown below clic...

1. To delete the filter shown below click Filter in the Sort & Filter group and select Clear Filter. Click Remove Filter in the Sort & Filter group. Right click on any number in th

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