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 international compensation, Existing salary for managers is 45,000...

Existing salary for managers is 45,000 euros (58,567 us dollars) plus bonuses. Average salary for managers in range is 60,000 euros (78,090), no bonuses. Recommendations must inclu

What do you understand by “line balancing”? What happens if , What do you u...

What do you understand by “line balancing”? What happens if balance doesn’t exist?..

Explain how does this sort of thing happen in organizations, We have all wo...

We have all worked with someone who did not seem to fit the role for which he or she was hired, or did not seem to fit in with the organization, or did not have the right skills fo

Explain when great technological projects, Superior expertise about how tec...

Superior expertise about how technologies work does not guarantee superior judgment about how they should be used, regulated, or governed. As technology becomes more sophisticated,

Determine the appropriate sample size, Determine the Appropriate Sample Siz...

Determine the Appropriate Sample Size The following work sampling data was collected from observing a retail assistant:  Activity

Explain the strategy or strategies used by parties, Identify negotiation ta...

Identify negotiation tactics of the sequence of events that transpired just before the United States began operation freedom in Iraq. Describe the strategy or strategies used by an

Explain functional aggregation, Describe functional aggregation and discuss...

Describe functional aggregation and discuss how this is relevant to logistics

Find intermediate calculations to 3 decimal places, travel on Mountain Airl...

travel on Mountain Airlines for the past 18 weeks was: Week Passengers Week Passengers 1 402 10 440 2 410 11 446 3 420 12 451 4 415 13 455 5 412 14 462 6 414 15 466 7 424 16 474 8

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