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 a university web server has five main components, A University Web ...

A University Web server has five main components each with the same reliability. All five components must work for the server to function as intended. If the University wants to ha

Explain visual inspection, Develop a forecast for years 2 through 12 using ...

Develop a forecast for years 2 through 12 using exponential smoothing with ? = .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and the nai

Explain challenges in leading a multi-generational workforce, Challenges in...

Challenges in leading a multi-generational and/or multi-cultural workforces: Need a complete summary for the listed assignment, references. Please at least one page of information

Explain drum-buffer-rope, According to Elyahu Goldratt, the TOC system uses...

According to Elyahu Goldratt, the TOC system uses a scheduling approach called _____. drum-buffer-rope drum-buffer-string drum-rope-buffer drum-buffer-line

Explain develop an aggregate production plan, ABC Company, a manufacturer o...

ABC Company, a manufacturer of roofing supplies, has developed monthly forecasts for roofing tiles. The forecasted demand and the expected production days for months March to Augus

Explain geographical information system help companies, 1. Briefly describe...

1. Briefly describe each of the four quantitative methods used to evaluate location alternatives. 2. How does a geographical information system help companies like Red Lobster or L

Explain ennoblement in addition to the primary deliverable, Almost all proj...

Almost all project have deliverables dealing with documentation and customer ennoblement in addition to the primary deliverable

Explain lower control limits for mean and range charts, Determine upper and...

Determine upper and lower control limits for mean and range charts.

Explain how can i get the solutions, I would like to know how can i get th...

I would like to know how can i get the solutions maual for the book systems analysis and design 9th edition by kendall & kendall can you please let me know how to do it

Depict a decision tree for problem, A manager is trying to decide whether t...

A manager is trying to decide whether to build a small medium, or large facility. Demand can be low, average, or high, with the estimated probabilities being 0.25, 0.40, and 0.35,

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