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 appropriate technique to develop a forecast, Air travel Mountain A...

Air travel Mountain Airlines for the past 18 weeks was: Week Passengers 1 405 2 410 3 420 4 415 5 412 6 420 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 464 15 466 16 474 17 47

Explain fire wire sure wire surfboard''s strongest competitor, 1. Identify ...

1. Identify and describe fire wire sure wire surfboard's strongest competitor .how is this rival positioned in the marketplace? 2. What recommendation would you make to mark pri

Explain employees effectively execute the strategy, Select a company that y...

Select a company that you believe uses its employees to achieve a competitive advantage. Discuss how the employees effectively execute the strategy and how the company can sustain

Explain the major categories of information, Indicate the major categories ...

Indicate the major categories of information you would expect to find in a project review

Explain obstacles employees faced with pension plan funding, What are four ...

What are four safeguards that the ERISA legislation specified to address the many obstacles employees faced with pension plan funding? How did the Pension Protection Act add additi

Explain how is the search industry changing, How is the search industry cha...

How is the search industry changing? What forces seem most likely to bring about major change to the industry within the next three to five years?

What are routine and strategic decisions, What are routine and strategic de...

What are routine and strategic decisions? Routine decisions are of repetitive nature that do not need much analysis and evaluation, are in the context of everyday operations of

Find what will the productivity of the bakery, If charles lackey's utility ...

If charles lackey's utility costs remain constant at $500 per month, labor at $8 per hour, and cost of ingredients at $0.35 per loaf, but Charles does not purchase the blender sugg

Computation to receive credit, Your company has a market share of 25%. The ...

Your company has a market share of 25%. The total market size is $100 million. Your contribution margin (the ratio of the contribution per unit over the price per unit) is 20%. You

Logistics Management, What modification would you suggest in enhancing the ...

What modification would you suggest in enhancing the existing logistics system

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