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

Expalin possible core competencies of wild west, Wild west,Inc., is a regio...

Wild west,Inc., is a regional telephone company that inherited nearly 100,000 employees and 50,000 retirees from AT&T. Wild West Inc. has a new mission: to difersify.It calls fo

Vertically integrated or virtual organisation, Vertically Integrated or Vir...

Vertically Integrated or Virtual Organisation An organisation might decide not to source goods or services externally but to own the supplier company itself. For instance a

Describe the difference between consumer products, Explain the difference b...

Explain the difference between consumer products and business products. Why are some products difficult to categorize as one or the other? Give an example of a business product, a

Valuate the production quantity, Using the data, suppose the manufacturer h...

Using the data, suppose the manufacturer has an inflated demand forecast as follows: Quantity Probability 2,200 5% 2,300 6% 2,400 10% 2,500 17% 2,600 30% 2,700

Explain the steps involved in conducting a risk, Describe the steps involve...

Describe the steps involved in conducting a risk and opportunity assessment.

Desicion making chapter 1, analyze the decision tree in figure A.8 what is ...

analyze the decision tree in figure A.8 what is the expected payoff for the best alternative? first be sure to infer the missing probabilities

Different types of performance objectives, Question : (a) According to...

Question : (a) According to Slack et al. (2001), in any organisation the factors that define customer requirements are referred to as competitive factors which are influenced

Productivity measurement in organisations, Productivity Measurement In...

Productivity Measurement In Productivity measurement, we identify the factors affecting productivity and divide them into two major categories: external and internal. We ident

Explain expected profit function to be maximized, A foundry receives an ord...

A foundry receives an order for specialty castings. Cost of producing each casting is estimated to be $15,000. The customer requires that exactly 4 good castings be supplied. The c

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