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

Predetermined time standards (pts) - process design, Predetermined Time Sta...

Predetermined Time Standards (PTS) - Process Design This is a work measurement technique whereby times established for basic human motions (classified according to the nature

Explain public-sector bargaining law, • Explain why some states do and othe...

• Explain why some states do and other states don't have a public-sector bargaining law or laws that cover some public employees but not others. • From the second e-Activity, co

Explain how can service level agreements be monitored, How can service leve...

How can service level agreements be monitored? Construct a short service level agreement first, then discuss how this service level agreement can be monitored

Why hrm-r technologies financial impact of talent management, • Analyze the...

• Analyze the article's perspectives concerning talent management and technology issues. • Suggest strategies for evaluating HRM-r technologies financial impact of talent manage

Explain graph based layout construction method, Is the Graph based layout c...

Is the Graph based layout construction method always produces maximally Planar Graph & Maximally Planar weighted graph?

Explain the three forms of ownership, Answer the following questions on the...

Answer the following questions on the Topic of Forms of Business Ownership 1. Describe the three forms of ownership. Describe two advantages and two disadvantages of each. 2.

Linear trend equation, A cosmetics manufacturers marketing department has d...

A cosmetics manufacturers marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand and Foot Cream. We are given F sub

Question eXAM, Defining Operation Management Operations performance...

Defining Operation Management Operations performance Function of operations Evolution of operations management E-business Integrated value c

Explain eliminating the scrap, An operation has a 10% scrap rate. As a resu...

An operation has a 10% scrap rate. As a result, 72 pieces per hour are produced. What is the potential increase in labour productivity that could be achieved by eliminating the scr

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