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 what is the stocks required rate of return, GD inc has preferred st...

GD inc has preferred stock outstanding that pays a dividend of $5 at the end of each year. The preferred sells for $50 a share. What is the stocks required rate of return? Show wor

Calculate the quarterly index, Over the past year, Meredith and Smunt Manuf...

Over the past year, Meredith and Smunt Manufacturing had annual sales of 10,000 portable water pumps. The average quarterly sales for the past 5 years have averaged: Spring 4,00

Explain the local publix grocery has five regular lanes, The local Publix G...

The local Publix Grocery has five regular lanes and one express lane (12 items or less only). Based on a sampling study, it takes 11 minutes on the average for a customer to go thr

Success of change initiatives is why many initiatives fail, Failure to anti...

Failure to anticipate and mitigate circumstances that might impede the success of change initiatives is why so many initiatives fail. From a business managers perspective, what doe

Explain how this can affect people''s sense of responsibility, In the morde...

In the mordern world most people work in organisations. Describe how this can affect people's sense of responsibility and the morality of their conduct.

How to find the optimum number of units, A manufacturing company sells its ...

A manufacturing company sells its products directly to customers and operates 5 days a week, 52 weeks a year. The production department of this company can produce at the rate of 6

Explain task sociocultural technological political economic, The ____ dimen...

The ____ dimension refers to the methods available for converting resources into products and services. Task sociocultural technological political economic

Initiate an organizing campaign for the technical employees, 1) Company A w...

1) Company A wants to discourage unionization through the United Technical Workers of America. True or False: In order to do so, it can initiate an organizing campaign for the Tech

What is the expected cost per period of the photocopier, Suppose that at an...

Suppose that at any period of time a photo-copier machine can either be working properly, in need of maintenance, in need of minor repair, or in need of major repair. If the photoc

Turnround at the preston plant, what are the most significant events in the...

what are the most significant events in the story of how the plant survived because of its adoption of quality based principles

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