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 way that pandora could benefit from grid computing, Develop a way t...

Develop a way that Pandora could benefit from grid computing

Imagine this is the only position of its kind organization, Imagine this is...

Imagine this is the only position of its kind in the organization. From this perspective, design a performance appraisal program to assess your job performance.

Multiple activity chart, how to do a multiple activity chart on making pota...

how to do a multiple activity chart on making potatoe chips

Explain what organization sets standard for frame relay, What organization ...

What organization sets standard for frame relay? a. ITU b. IEEE c. IETF d. FCC

Explain which event was the labor productivity higher, A catering company p...

A catering company prepared and served 300 meals at an anniversary celebration last week using eight workers. The week before, six workers prepared and served 20 meals at a weedin

What is lead time, (a.)    Give an example (with justification) of a produc...

(a.)    Give an example (with justification) of a product for which EOQ ordering is more sensible (i.e., more economical) than JIT ordering. (b.)  What is lead time ?  What wou

Explain gauge reproducibility and repeatability, Describe gauge reproducibi...

Describe gauge reproducibility and repeatability. How does gauge R and R apply to a six sigma project?

Explain sexual assault prevention and response, What impact do you think th...

What impact do you think that the DODs new Sexual Assault Prevention and Response (SAPR) program will have on the culture and the historic problems of sexual assault/harassment and

Explain penetrated market, Which market do customers who have purchased and...

Which market do customers who have purchased and are driving Audi automobiles represent? a. Target market b. Available market c. Potential market d.

Explain damage and restrict water access, Please explain how you would hand...

Please explain how you would handle the following question: An environmental impact statement confirms that you are within your legal rights to build a hotel property in a scenic a

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