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 key aspects of operations management, 1- With respect to a firm's s...

1- With respect to a firm's supply chain design, what are some key challenges in terms of achieving an optimal level of mass customization? 2 - Articulate key aspects of operati

Explain what kind of router could connect network, What kind of router coul...

What kind of router could connect network segments that use cat5 utp with other segments that use fibre optic cable? A. Modular router B. Translational router C. Bridge ro

Compute the labour productivity, 10 person assembly line, 160 valves produc...

10 person assembly line, 160 valves produced during 8 hour shift, calculate the labour productivity

Explain receive advice from immediate supervisor, What are some of the poss...

What are some of the possible reasons Scott did not seek or receive advice from her immediate supervisor?

Explain what assignment minimizes the total traffic flow, Please kindly sho...

Please kindly show step by step solutions. Six processes are to be laid out in six areas along a long corridor at Linda Babat Accounting Services. The distance between adjacent

Game theory is important for the understanding of what, Game theory is impo...

Game theory is important for the understanding of __________. A. competitive markets B. oligopolies C. all market structures D. monopolies

Define the five-component model of an information system, Explain the five-...

Explain the five-component model of an information system. How can you use them?

Explain disadvantages of the open innovation approach, How might businesses...

How might businesses use the Internet to identify untapped customer needs through open innovation? What do you see as the major advantages and disadvantages of the open innovation

Small organizations or large organizations differ in design, How do small o...

How do small organizations and large organizations differ in design?

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