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 objectives of organisational development, Explain objectives of org...

Explain objectives of organisational development. Objectives of Organisational Development (i) Enhancement in the performance of the organisation. (ii) Enhancement in t

Explain what should peter recommend to gwyn, What should Peter recommend to...

What should Peter recommend to Gwyn about Dana's case?

Explain measures that the government could employ, What are some of the mea...

What are some of the measures that governments can take to deter, detect, and prevent terrorists organized in small groups, bunch of guys (BOG) groups, cellular organizations, or a

Explain what has been their global competitive advantage, Select a company ...

Select a company of your choice. What has been their global competitive advantage (either successful or not)? If not, what would be your suggestion to this company if you were hire

Explain purchasing and supply management, Briefly discuss each of the seven...

Briefly discuss each of the seven periods in the evolution of purchasing and supply management. What do you forecast for the future?

Explain what is the maximum revenue with a single shift, Given the followin...

Given the following data for Albert's fabricating production area: Fixed costs for one shift = $60,000 Unit variable cost = $7 Selling price = $12 Number of machines = 5 Number of

Describe the significance of the estonia article, Answer the following ques...

Answer the following questions on the Topic of The History of the American Corporation 1-Describe what is the rule of law and its importance on a successful capitalistic society

Calculate the two missing amounts, A company is considering whether to repl...

A company is considering whether to replace a machine. The old machine costs $90,000 and is being depreciated at 10% per annum using the straight line method. It is written down va

Explain the defined retirement plan, 1. Why would the government not tax us...

1. Why would the government not tax us for the Employee Benefits we receive? 2. As a percent of payroll, how much does employer pay for Employee Benefits? 3. Explain the defe

Process focused production system, Process Focused Production System Th...

Process Focused Production System This is a form of production system in which production operations are grouped according to the type of process. In other words, all productio

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