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 physical well-being of a manager of co-worker, All of the following...

All of the following are examples of protected opposition except: a. Threatening to file a formal complaint alleging discrimination b. Refusing to obey an order because of a reason

Explain employee involvement will improve decision making, As OB practition...

As OB practitioners we know that emotions form preferences before we consciously evaluate those choices and this impacts the quality of the decisions made at the company. The presi

Determine control limits for a c-chart and np-chart, 1. If, instead, a cons...

1. If, instead, a constant sample size of 100 is chosen, determine the np-chart control limits. A later sample produces 15 defectives: what conclusion can be drawn?  2. 1000 bot

Describe how advancing technologies in the security, Explain how advancing ...

Explain how advancing technologies in the security field are changing how end users are identified. In your response, identify potential security gaps that may be caused by these n

Explain how might you use quality tools to determine, a) Determine the valu...

a) Determine the value of the p-bar, the mean fraction defective. Then determine the control limits for the p-chart using 99.73% confidence level (3 standard deviations). Is this p

Explain what is the multifactor productivity of the plant, An industrial pl...

An industrial plant needs to make 100,000 parts per month to meet demand. Each month contains 20 working days, each of which allows for 3 separate 8 hour shifts. a. If a worker can

Explain assembly of power steering pumps, A small assembly line for the ass...

A small assembly line for the assembly of power steering pumps needs to be balanced. Exhibit 8.11 in the text is the precedence diagram. The cycle time is determined to be 1.5 minu

How differentiate company products, How do marketers position and different...

How do marketers position and differentiate their company's products/services relative to competition? Provide examples in either the fast-food, hotel, airline or restaurant busine

Explain product life cycle, How does a product life cycle differ from a pro...

How does a product life cycle differ from a product life cycle?

Explain michael porter''s competitive forces model, Discuss Michael Porter'...

Discuss Michael Porter's Competitive Forces Model. Provide examples to illustrate your points.

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