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

Features of production and operation management, Features of Production and...

Features of Production and Operation Management 1. Production management is the process of making decisions. 2. Decisions are made regarding transformation of inputs outputs. 3

Digitra; cell phone, Ask que Prepare Paul Jordan’s report to John Smithers ...

Ask que Prepare Paul Jordan’s report to John Smithers using regression analysis. Provide a summary of the cell phone industry outlook as part of Paul’s response. stion #Minimum 100

Explain supply chain is inappropriate for services, Explain why the goods a...

Explain why the goods analogy of a supply chain is inappropriate for services

Explain why are service typically more difficult to automate, Why are servi...

Why are services typically more difficult to standardize, automate, and make efficient?

Define what is divine command theory, What is Divine Command theory? Given ...

What is Divine Command theory? Given the power gap between God and humanity how do we make the moral demands work? How do we make Divine command theory work?

Define diversification as a strategy, Diversification as a strategy. Con...

Diversification as a strategy. Consider GE and how large and global it is. What problems do you think GE's most senior executives encounter in trying to stay on top of all th

Where is performance appraisal help, Where is Performance Appraisal help? ...

Where is Performance Appraisal help? Performance Appraisal assists in operational decision making in personnel management gives clues to management for effecting improvements i

Explain the companys core competencies, As the end of the year comes to a c...

As the end of the year comes to a close, the CEO is evaluating Motorola's strategic approach and its ability to produce desired results for the company in the future. The CEO has a

Explain integration business-level strategy, The value chain priorities can...

The value chain priorities can be quite different for firms taking different business strategies. Create examples of value chains for three firms- one using cost leadership, anothe

Finance and the marketing function, Question 1: (a) What degree of aut...

Question 1: (a) What degree of autonomy does the HRM enjoy in relation to its various stakeholders? (b) Is conflict inherent in the relationship between the HR function on

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