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

Describe porter''s five forces model, You have been working for some time a...

You have been working for some time at UMUC Pizza, a pizza restaurant located near the UMUC campus. The owner, Bill, is very interested in expanding his successful business. He h

Explain testing your business perspective of a typical ie, Page maximum req...

Page maximum required for this question. This is testing your business perspective of a typical IE problem. Given that you have a starting standard time for a job of ninety (90) mi

Explain requirements to offer someone a top manager position, Which are you...

Which are your top 10 requirements to offer someone a top manager position?

What are the pros and cons of cumulative voting, Discuss the pros and cons ...

Discuss the pros and cons of cumulative voting vice regular voting for Directors of a company. Why would a company choose one over the other? Who benefits from each type: sharehold

I want help with writing an rcode to analyze an experiment, I need help wit...

I need help with writing an rcode to analyze an experiment for a two way layout without replication. There are two factors each with 3 levels.

Describe customer service level for an inventory system, Discuss customer s...

Discuss customer service level for an inventory system within the context of quality management

Explain the high physical demands of the job, The Dubuque Cement Company pa...

The Dubuque Cement Company packs 80-pound bags of concrete mix. Time-study data for the filling activity are shown in the following table. Because of the high physical demands of t

Productivity, discuss productivity in the service sector

discuss productivity in the service sector

Hidden markov models, Hidden Markov Models: We discussed an example of...

Hidden Markov Models: We discussed an example of determining the most probable state path with the Viterbi algorithm. We also discussed in the class how to calculate the margi

Explain the probable destiny competing products, Consider this: Lee Peterso...

Consider this: Lee Peterson has invented a new product that detects water leaks due to broken pipes and sends out an alarm similar to a smoke alarm. However, Lee has very little pe

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