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

Production control function, Production control Function 1. Dispatchi...

Production control Function 1. Dispatching : Dispatching may be  defined as setting  production activities in motion through  the  release  of orders ( work order shop order)

What is collective bargaining process, What are three cost-containment meas...

What are three cost-containment measures that were implemented through the collective bargaining process in 1985? Why were these considered milestones in curtailing health benefit

Location, What are potential advantages and disadvantage of locating a prod...

What are potential advantages and disadvantage of locating a production facility in foreign country instead of using domestic location?

What do you think joe thomas must do about this matter?, What do you think ...

What do you think Joe Thomas should do about this matter?

Describe how current laws regarding search and seizure, Discuss how current...

Discuss how current laws regarding search and seizure have the potential to violate the Fourth Amendment. In your response, provide specific examples of how this violation may occu

Focused improvement programmes - improving productivity, Focused Improvemen...

Focused Improvement Programmes - Improving Productivity Allan Lawlor (1985), Director of Action Learning Associates (ALA) suggests - based on his experiences in industry and

Explain requirements of alliance membership, In what ways might the divisio...

In what ways might the divisionalized forms of most airlines lend themselves to the requirements of alliance membership? In what ways might they be compatible with the organization

Compute the slope and the intercept of the trend equation, Demand for a sur...

Demand for a surgical procedure at St. Elsewhere Hospital has increased steadily over the past few years: Year 1 2 3 4 5 Heart Transplants 45 50 52 56 61 Use the

Explain probabilities of various caseloads to be unreliable, The director o...

The director of social services of a county has learned that the state has mandated additional information requirements. This will place an additional burden on the agency. The dir

Devise a regression equation or predict the profitability, Consider the tab...

Consider the table below. This time, the historical profitability of eight locations is listed in the table. Devise a regression equation and predict the profitability of a new sit

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