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

Suggest productivity measurements - operations manager, 1. Suggest producti...

1. Suggest productivity measurements which operations managers might consider important to be used in a:  (a) hotel  (b) University  (c) Department store  (d) Hospital

Explain what the average number of accounts payable checks, An accounts pay...

An accounts payable manager processes 200 checks per day with an average processing time of 15 working days. What is the average number of accounts payable checks being processed i

Describe fully and provide citations, On February 1, Mary verbally agrees t...

On February 1, Mary verbally agrees to work as a businessperson on a temporary basis for the firm of Blacke & Blewe, P.C. The job that Mary is assigned to do will take eight months

Policies that contribute and relate main business objectives, How can a fir...

How can a firm's security policies contribute and relate to the six main business objectives? Give examples.

Explain how is ace products organized, Steffi Graf has assumed leadership o...

Steffi Graf has assumed leadership of Ace Products after many years of loyal service. Ace Products is an international manufacturer of copiers, printers, and fax machines. Historic

Explain good business practices and ethics, Kim was in a financial bind. Ju...

Kim was in a financial bind. Just last year, she had purchased a personal plane and an exclusive home that housed the plane in its garage. The total costs were $1 million and Kim's

Mass Production and Continuous Flow Manufacturing, Mass Production and Cont...

Mass Production and Continuous Flow Manufacturing  Continuous systems lie at the other extreme, where demand for a single product is sufficiently high to warrant the installa

Explain levels of management by management skills, Explain levels of Manage...

Explain levels of Management by Management Skills. Management Skills needed successful manager, be categorized as given below: Technical skill refers to the pro

Explain because the confidence interval includes zero, A study was done to ...

A study was done to examine whether the perception of service quality at hotels differed by gender. Hotels were randomly selected to rate service items on a 50point scale. The sum

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