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 motivating employees, What are some effective ways companies are mo...

What are some effective ways companies are motivating employees for (retention and best return). Will rate accordingly. Thanks

Explain quality is considered to be a structural element, Quality is consid...

Quality is considered to be a structural element of the strategic service concept.

What is the safety stock and rop, Chicago's Hard Rock Hotel distributes a m...

Chicago's Hard Rock Hotel distributes a mean of 1000 bath towels per day to guests at the pool and in their rooms. This demand is normally distributed with a standard deviation of

Explain the relationship between financial forecasting, • Describe the requ...

• Describe the requirements of forecast demand and capacity requirements for financial planning, leading to proper business valuation. • Explain the financial risks to a healthc

Find expected value for the add assembly line option, Howard Weiss, Inc., i...

Howard Weiss, Inc., is considering building a sensitive new airport scanning device. His managers believe that there is a probability of 0.40 that the ATR Co. will come out with a

How minimizes the number orders waiting in the queue, Which of the followin...

Which of the following rules maximizes the number of orders processed in a center and minimizes the number orders waiting in the queue? Shortest operation next First-come/fir

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

Explain model of behaviour modification, Model of behaviour modification an...

Model of behaviour modification and the four contingencies of reinforcement.(cited/referenced)

Explain employees explicit rights to free speech, Giving employees explicit...

Giving employees explicit rights to free speech, just cause dismissal, and information are three possibilities for transforming U.S. labour law.

Dont know, Q. A textile manufacturer is interested in optimally determined...

Q. A textile manufacturer is interested in optimally determined inventories for cutting operations for a children’s product line. The production manager would like to establish th

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