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 one attribute or capacity of servant leadership, Write a 500-750-wo...

Write a 500-750-word paper analyzing emerging leadership theories. Address the following questions and concepts 1) Describe one attribute or capacity of servant leadership an

Analyze the points involved in preparing a cash budget, Analyze the steps i...

Analyze the steps involved in preparing a cash budget and determine which steps presents the GREATEST number of obstacles to the GREATEST number of small businesses. Explain your r

Location decision and layout selection, 1. general procedures for making lo...

1. general procedures for making location decision 2. factors to consider in layout selecgtion

Explain electronic information exchanges throughout firms, Of focus in any ...

Of focus in any HMIS is data compatibility, which includes the use of common codes and data definitions, specifically used for electronic information exchanges throughout the organ

After working for 30 years, In the table given below the Distribution Manag...

In the table given below the Distribution Manager is expected to service these DCs as per the demands placed. If the actual sales after completing week one is as follows, what woul

Explain the current yield on alaska power company bonds, Alaska Power Compa...

Alaska Power Company issued $1,000 bonds that have an annual coupon rate of 7.5%. The present market value of the bonds is $1,125. If the bonds have 15 years remaining until maturi

Explain the 5-s practice, Explain the 5-S practice for improving both the p...

Explain the 5-S practice for improving both the physical and thinking environment of an organisation. The 5-S practice is an approach to achieving an organised, clean and stand

Describe the various views of ethics, Discuss the various views of ethics (...

Discuss the various views of ethics (e.g. justice view, moral rights, etc.) and why they are important in business.

Explain the need for management to motivate their employees, Problem 1: ...

Problem 1: Team working is gaining importance in modern organisations. Do you agree that all members of an organisation could be expected to be team players? Discuss with exa

Explain end-user computing and systems, End-User Computing and Systems- Ple...

End-User Computing and Systems- Please respond to the following: •Discuss the advantages and disadvantages of end-user computing and determine if this is an application that should

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