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 main benefits of the just-in-time system, 1) What are at least thre...

1) What are at least three main benefits of the just-in-time system? Present and explain them 2) What are at least three main drawbacks/problems of the just-in-time system? Pres

Explain acronym ltpd, Explain acronym LTPD. Ans: The acronym LTPD is...

Explain acronym LTPD. Ans: The acronym LTPD is Lot Tolerance Percent Defective.

MAD & MAPE, Sales of vegetable dehydrators at Bud Banis'' discount departme...

Sales of vegetable dehydrators at Bud Banis'' discount department store in St. Louis over the past year are shown below. Management prepared a forecast using a combination of expon

Explain optimized the websites for taking applications, What are your thoug...

What are your thoughts on this article ?According to an article dated February 24, 2013 in the Tech section USA Today News (electronic issue), many employers maybe missing out on h

Explain productivity change for labour and investment, Refer to problem 1.1...

Refer to problem 1.13. The pay will be $8 per hour for employees. Charles lacket can also improve the yield by purchasing a new blender. The new blender will mean an increase in hi

Explain what is the present value of the following annuities, What is the p...

What is the present value of the following annuities? a. $2,500 a year for 10 years discounted back to the present at 7% b. $70 a year for 3 years discounted back to the pres

Explain the forecast for aug based on a weighted moving, What is the foreca...

What is the forecast for Aug based on a weighted moving average applied to the following past demand data and using the weights: 5, 3, 1.5? (largest weight is for most recent data)

Can someone help describe what to do, I feel like there is not enough infor...

I feel like there is not enough information to even start. Can someone help explain what to do? Maybe if I can start, then I can do the rest on my own.

What is process of implementing a new strategy, In most cases, organization...

In most cases, organizations adjusted their structures as part of the process of implementing a new strategy. Why might this practice not be advisable?

Assignment 2000 words, Assignment EITHER A. Practical application of concep...

Assignment EITHER A. Practical application of concepts in a local organisation • You are required to analyse and evaluate a key aspect of operations management covered in this subj

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