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

How understanding of consumer behaviour helped groupon grow, How has an und...

How has an understanding of consumer behaviour helped Groupon grow from 400 subscribers in Chicago in 2008 to 60 million subscribers in 40 countries today? What is the Groupon Prom

PROJECT MANAGEMENT CPM/PERT CHAT, prepare CPM/PERT chat and determine the s...

prepare CPM/PERT chat and determine the shortest time this project can be completed (using crash time )

Explain evaluating the personal requests of employees, 1. do managers like ...

1. do managers like janis blancero face a more complication when evaluating the personal requests of employees versus evaluating employee's individual work performance ? explain ?

Explain government use to facilitate economic development, Reflect upon the...

Reflect upon the IT strategies that are used to encourage economic development. Select two strategies and discuss how economic factors affect the strategies that a government may u

How efficient is your system with the cycle time you compute, A firm uses a...

A firm uses a serial assembly system and needs answers to the following- a. A desired output of 900 units per shift (7.5 hours) is desired for a new processing system. The syst

Activity sampling - process design, Activity Sampling - Process Design ...

Activity Sampling - Process Design This is a method of finding the percentage occurrence of a certain activity by statistical sampling and random observation. It is used when

What is operations strategy, What is operations strategy? Operations ...

What is operations strategy? Operations strategy: According to Slack and Lewis the definition operations strategy: The total pattern of decisions that shape the long

Explain the ten commandments of america culture, Go toto gmi.org and search...

Go toto gmi.org and search for "The Ten Commandments of America Culture." The list presents ten sayings that represent commonly accepted American cultural values. Think about how t

Productivity -numerically defined, Productivity -Numerically Defined T...

Productivity -Numerically Defined Total factor productivity (TFP) = Pt = Ot/(L+C+R+Q)  Partial factor productivity (PFP) = Ot/L or C or Ot/a combination of  inputs   Pt

Explain managers have satisfied when making these decisions, To what extent...

To what extent do you think Verwaayen and other top managers have satisfied when making these decisions?

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