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

Corporate strategies- operation strategy, Corporate Strategies- Operation S...

Corporate Strategies- Operation Strategy Often it is not obvious to participants that an organisation has a corporate strategy. Consider this illustration. A visitor to a Poly

Expected effectiveness of plan, Expected effectiveness of plan: Ramon ...

Expected effectiveness of plan: Ramon Martinez is the general manager of Classic Inn, a local mid-priced hotelwith 100 rooms. His job objectives include providing resourceful

Explain who is most likely to win the business, A Chicago-based manufacture...

A Chicago-based manufacturer is looking for someone to handle its shipments to the West Coast. In order to evaluate potential transportation providers, the manufacturer has develop

Research and specific examples of laws into business ethics, Discuss how la...

Discuss how laws tie into business ethics. Support your ideas with research and specific examples of laws discussed in your text. What specifically does the Sarbanes-Oxley Act s

Explain managers viewed emotional intelligence as important, 1.A credit car...

1.A credit card company is interested in the average balance tht is carried by its college aged card holders. They are particularly interested in whether the average balance of the

Explain the mystery cat, In TS Elliot's book of practical cats name the mys...

In TS Elliot's book of practical cats name the mystery cat?

What are two reasons project management is not good, What are two reasons p...

What are two reasons project management is not well done in corporations? Why? What are some specific examples?

What is the safety stock and rop, Chicago's Hard Rock Hotel distributes a m...

Chicago's Hard Rock Hotel distributes a mean of 1000 bath towels per day to guests at the pool and in their rooms. This demand is normally distributed with a standard deviation of

Manufacturing sector - car industry, Manufacturing Sector - Car Industry ...

Manufacturing Sector - Car Industry 1. A new era of globalisation 2. Current over capacity - increased competition - price pressure 3. Reduction in the number of compani

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