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 assessment of the quality of the decision, Watch the video, how to ...

Watch the video, how to perform a SWOT Analysis, and then conduct a SWOT analysis using the Starbucks' Global Quest 2006: Is the Best Yet to Come? Case provided in the Course Mater

What was jimmy efficiency, 1) Jimmy runs a business in his basement that sp...

1) Jimmy runs a business in his basement that spin aligns and marks golf balls with logos for tournaments. The automated machine goes through three serial steps; the first step tak

Explain messages are transmitted from low speed terminals, Messages are tra...

Messages are transmitted from low speed terminals and arrive at a message concentrator at a Poisson rate of 600/hr. They are held in a buffer until a hi-speed trunk line is free to

Role or forecasting in capacity planning, Role or Forecasting in capacity P...

Role or Forecasting in capacity Planning The marketing department plays a major role in providing demand forecasts based on which both long term as well as short term capacity p

Describe the scope of the business process outsourcing, List five considera...

List five considerations to consider when starting to define the scope of the business process outsourcing transaction and discuss the importance of each in relation to outsourcing

Explain marketing phenomenon occurs when there exists, The following market...

The following marketing phenomenon occurs when there exists within two city blocks the following hamburger outlets: McDonald's, Burger King, Sonic, and Wendys.

Explain why is it important to develop their products, Why is it important ...

Why is it important to develop their products/services marketing plan in writing?

Explain what is the critical path, The following represents a project that ...

The following represents a project that should be scheduled using CPM: Time (DAYS) Activity Immediate Predecessors a m b A - 1 3 5 B - 1 2 3 C A 1 2 3 D A 2 3 4 E B 3 4 11 F

Explain modern sweatshops are a problem, 1) List the four schools of though...

1) List the four schools of thought along with the basic cause of the labour problem and solution to the labour problem for each. 2) Explore the online exhibit about the 1911 Tr

Explain mean confidence interval for the population, You wk for a consumer ...

You wk for a consumer advocate agency and want to find the mean repair cost of a washing machine. As part of your study, you randomly select 45 repair costs and find the mean to be

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