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

Process design, what is process design in operation management

what is process design in operation management

Explain wrong dimensions and unevenstitches, Jim's Outfitters, Inc., makes ...

Jim's Outfitters, Inc., makes custom fancy shirts for cowboys. The shirts could be flawed in various ways, including flaws in the weave or color of the fabric, loose buttons or dec

Availability of labour and amenities, Availability of Labour and Amenities ...

Availability of Labour and Amenities Availability of Labour and skills: Certain geographical area has traditional skills but is very are that a location can be found which h

Explain what are the four communication styles, 1) Describe the five major ...

1) Describe the five major principles that support communication-style theory. 2) What two dimensions of human behavior are used to identify communication style? 3) What are

Explain line and staff organisation, Explain Line and Staff Organisation. ...

Explain Line and Staff Organisation. Line and Staff Organisation: When the industry grew in size and complicated, the line executives could not perform appropriately all othe

Explain international monetary fund, After reading your assigned readings o...

After reading your assigned readings on international monetary policy in this unit, visit the global beverage company of your choice. Note the number of different countries that th

Explain key factors facing your college or university, List three opportuni...

List three opportunities and three threats that could represent key factors facing your college or university. Briefly state your view of what institution should do in light of the

Describe several advantages of linear programming, Discuss several advantag...

Discuss several advantages of linear programming; clearly explain the reasons for your choices.

Explain should audio cables buy the new equipment, Audio cables, INC. is cu...

Audio cables, INC. is currently manufacturing an adapter that has a variable cost of $.50 per unit and a selling price of $1.00 per unit. Fixed cost are $14,000. Current sales volu

Bloomsday Outfitters produces T-shirts for road races. They , 1.How many st...

1.How many stamping machines are required? 2.what would be the quantities that would need amendment as far as Distribution Manager is concerned to service for week two and onwards?

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