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

Determining Sample Design, Determining Sample Design: All the items ...

Determining Sample Design: All the items consideration in any field of inquiry constitute a universe or population. A complete enumeration of all the items in the populat

Circumstances is a code of ethics most as well least likely, Under what cir...

Under what circumstances is a code of ethics most and least likely to be effective? Why?

Explain requirements to offer someone a top manager position, Which are you...

Which are your top 10 requirements to offer someone a top manager position?

Explain security measures for the wireless classes, Imagine you are the Pre...

Imagine you are the President or Dean of a new school. This school is going to be completely mobile and wireless class for the future. Describe and design your school, taking into

Blockbuster offer potential partners to improve its position, Looking to th...

Looking to the future, what value-added components could Blockbuster offer potential partners to enhance its position in the environment?

Explain how many storage rooms of each size to build, Personal Mini Warehou...

Personal Mini Warehouses is planning to expand its successful Nashua business into Lowell. In doing so, the company must determine how many storage rooms of each size to build. The

Road transportation business, After working for 30 years, Ramjee Somjee Dut...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busine

Explain upper control limit for an r-chart, Twenty samples of subgroup size...

Twenty samples of subgroup size 3 (n=3) were collected for a variable measurement. Determine the upper control limit (UCL) for an R-chart if the mean of the sample ranges equals

Explain marketing and selling, What is your understanding of the terms: mar...

What is your understanding of the terms: marketing and selling? Are they the same? How do you differentiate the two terminologies? Provide examples to support your points.

Evaluate the servicescape dimensions, Question: (a) Services are usuall...

Question: (a) Services are usually produced and consumed simultaneously, and in many cases the customer has to enter the service facilities and be within the servicescape befo

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