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 about the intention of survey or sample of buyer, Explain about the...

Explain about the intention of survey or sample of buyer Survey or sample of buyer’s intentions preferably suited for short and medium-term sales forecasting, the outcomes

Explain groups differently from other employees is necessary, Compare and c...

Compare and contrast what motivates Millennials from Baby Boomers, Generation X, and Generation Y. Assess whether motivating these groups differently from other employees is necess

General model of the operations function, General Model of the Operations F...

General Model of the Operations Function This figure illustrates the basic concept of the operations function. Firstly inputs are transformed (converted) to outputs with the m

Principle of motion economy, Principle of Motion Economy: The improvem...

Principle of Motion Economy: The improvement of any method is generally  accomplished using the ideas chosen from the alternatives  throw up during the critical examination ph

Provide source of enlightenment to the problem, Assume you are the CFO of A...

Assume you are the CFO of ABC Corporation, a multi-state supplier of janitorial supplies. The CEO as just met with you and "suggested" your job might depend on your ability to hide

Explain how do you approach the situation, In the middle of acquiring a new...

In the middle of acquiring a new company overseas, the deal hits a roadblock and your negotiation team is sent in. Based on the eight negotiation steps, how do you approach the sit

Describe corruption and bribery, Corruption and bribery are common in some ...

Corruption and bribery are common in some countries. Would you simply avoid locating in such a country, or locate there and deal with it? If the latter, how would you deal with it?

Explain what does it mean to exploit a system constraint, 1) If an operatio...

1) If an operation uses a pull system and lean manufacturing techniques do they need to use forecasts? How about production schedules and shop floor control systems? Explain why/wh

Is focused factory concept applicable in service sector, Is the 'focused fa...

Is the 'focused factory' concept described by Skinner applicable in the service sector? Answer:  Yes, think of Schmenner's service-process matrix and the lower quadrant entitled

Are there different types of operations systems, 1. Are there different typ...

1. Are there different types of operations systems?  Ans: Yes, characteristics show that manufacturing companies break down into categories as do service organisations. Once the

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