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 connect network segments that use cat5 utp, What kind of router cou...

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

Describe a manufacturing company preparing to build a plant, A manufacturin...

A manufacturing company preparing to build a new plant is considering three potential locations for it. The fixed and variable costs for each alternative location are presented bel

Define the periodic inventory control systems, Define the periodic inventor...

Define the periodic inventory control systems. Periodic (or bin) Inventory Control Systems: Stock levels are reviewed at pre-found intervals of time and an order is posit

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 how much should the father deposit, On the day his son was born, a ...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

Process Design, Discuss how the five Operational Performance Objectives may...

Discuss how the five Operational Performance Objectives may influence decision-making associated with process design and layouts.

Explain production standards place managements, State how production standa...

State how production standards place managements and unions at odds against each other. Why do some unions prefer the right to strike in this matter while others prefer arbitration

Explain developed mrp planning schedule, Product A is and end item and is m...

Product A is and end item and is made from 2 units of B and four of C. B is made of 3 units of D and two of E. C is made of two units of F and two of E. A has a lead time of 1 week

Productivity, how to calculate individual productivity

how to calculate individual productivity

Compare today''s business world with the one of 40 ago, How does today's bu...

How does today's business world compare with the one of 40 ago? What is different about today and what is not so different? Electronincs assembly Inc. operates two 8 hour shifts

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