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

Why customer driven analytics to make managerial decisions, 1) What assumpt...

1) What assumptions are necessary when using customer driven analytics to make managerial decisions? 2) How does the IT strategy of 7/11 influence other aspects of the business

Define internal vs external recruiting, Compare internal vs external recrui...

Compare internal vs external recruiting. When would you want to use each option? what are some advantages and disadvantages of each?

Explain it is important that lean six sigma efforts, It is important that L...

It is important that Lean Six Sigma efforts be linked specifically to strategic goals of the organization.

Explain how you would use situational leadership, Describe how you would us...

Describe how you would use Situational Leadership to diagnose the situation and identify the appropriate leadership style.?

Types of process designs, Types of Process Designs The basic type of p...

Types of Process Designs The basic type of production system and the finished goods inventory policy to be used must be decided at the earliest stages of process planning. The

Distribution among between affect international businesses, How do differen...

How do differences in income levels and income distribution among nations affect international businesses?

Explain why is this qbe implementation so effective, Identify an Internet s...

Identify an Internet site that has a very effective Query-by-Example (QBE) implementation for complex queries (multiple simultaneous attributes/fields) to efficiently navigate amon

Determine the overall project completion time, Question : (a) Under wha...

Question : (a) Under what conditions is PERT preferred to CPM in project management ? Illustrate your answer with examples of projects. (b) Several stages are involved in

Explain intangible assets and human capital, Companies are now more and mor...

Companies are now more and more interested in using intangible assets and human capital as a way to gain an advantage over competitors. True False

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