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

Explain what do you think needs to be improvement, B. Using the IT Savvy fo...

B. Using the IT Savvy four types of the CIO (page 146 IT Savvy), choose a type for each of CIO or IT leaders for all of the cases we have reviewed in this class. Give example of w

Explain operations research and management science, In the Howard Raffia ar...

In the Howard Raffia article on Decision Analysis, there is an excellent perspective on one man's intellectual journey through the use of quantitative and qualitative analysis to a

Explain the behaviors needed from leaders, Given the new science realities,...

Given the new science realities, write your ropes to know and ropes to skip for leaders, including guidelines for planning, measuring, motivating people, managing change and inform

Explain the quantitative, 1.   Explain the quantitative foundation of Six S...

1.   Explain the quantitative foundation of Six Sigma, and discuss how following the phases of the DMAIC improvement lifecycle ensures that the quantitative aspect of the approach

Explain what is the new waiting time at lhs, Newt Philly needs to decide wh...

Newt Philly needs to decide where to get a haircut. He has narrowed the choice down to two local hair salons - Large Hair Salon (LHS) and Small Hair Cutters (SHC). During busy peri

Explain what is the average completion time of all jobs, A single machine w...

A single machine work center has five jobs assigned to it. They are labelled, in the order of their arrival in the shop, as jobs A, B, C, D and E. The work center may work on only

Explain did jeanne do a good job of communicating, Did Jeanne do a good job...

Did Jeanne do a good job of communicating with her manager?

Factors for plant location choice, Factors for plant Location choice ...

Factors for plant Location choice Safety Requirements : Some production units may present, or may be believed to present potential dangers to the surrounding neighbourhood, e

Explain the internal and external environments, Describe the internal and e...

Describe the internal and external environments of 2 real world companies using an environmental scan. What competitive advantages does each company have and what strategies are ea

Explain theories in management response, Theories in Management Response co...

Theories in Management Response consider the various management theories of the past 100 years. What are the benefits of understanding these theories and their evolution? How are t

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