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 conference related to effective management, Specific subject conten...

Specific subject content for a conference related to effective management

Explain what are the objectives of work-center scheduling, 1) What are the ...

1) What are the objectives of work-center scheduling? 2) Distinguish between a job shop, aGT cell and a flow shop?

Describe what is the expected value of perfect information, Director of leg...

Director of legal services of ABC Company must decide whether to hire another full-time lawyer or to hire part-time lawyers. Anticipated costs for the two options under three possi

Explian more and more people working together is called, The inefficiencies...

The inefficiencies created by more and more people working together is called

Operations management and globlization, Briefly explain operation managemen...

Briefly explain operation management and globalization

I, . What do you understand by “line balancing”? What happens

. What do you understand by “line balancing”? What happens

Explain in words your motivation to do a good job, Describe in words your m...

Describe in words your motivation to do a good job? Does your company recognize your value? Is your salary/wages indicative of your value?

Describe the several components of inventory holding cost, Question: (a...

Question: (a) (i) What are the assumptions to be respected while deriving the Economic Order Quantity formula. (ii) Describe the several components of inventory holding c

Describe expected monetary value, XYZ coating company has reviewed four new...

XYZ coating company has reviewed four new processes for improving their coating line. The four processes, labeled A, B, C, and D use different technology and have different capacit

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