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 what prompted the change effort at the irs, What prompted the chang...

What prompted the change effort at the IRS, and what was targeted to change? Why was the proposed change controversial?

Explain pareto chart based on the information in problem, Could someone sho...

Could someone show me how to do a Pareto chart based on the information in problem of mgmt production management?

Explain exponential smoothing adds a percentage, Exponential smoothing adds...

Exponential smoothing adds a percentage (called) of last period's forecast to estimate next period's demand

Stepping stone method, Stepping Stone Method: Continue the above ex...

Stepping Stone Method: Continue the above example containing the initial basic feasible solution obtained by least cost rule. In this there six empty cell :91,1) )1

Explain statutory law, Statutory law is: Answer a law enacted by a legislat...

Statutory law is: Answer a law enacted by a legislative body also known as the fundamental law of the nation a form of common law the separation of powers at the federal level all

Compute the value of cash flow based on discount rate, Calculate the presen...

Calculate the present value of a stream of cash flows based on a discount rate of 8%. Annual cash flow is as follows 1. Year 1 = $100,000 2. Year 2 = $150,000 3. Year 3 = $200,0

Is work measurement used in organisation - process design, Is work measurem...

Is work measurement used in Organisation - Process Design Is work measurement used in your own organisation? If not, then give thought to how: alternative methods are compared

Explain criminally liable for actions of a few employees, Respondeat superi...

Respondeat superior is the theoretical basis for holding companies criminally liable for actions of their employees. Companies oftentimes have little defense against prosecution. C

Explain buckroe beach virginia illegal, Buckroe Beach Virginia illegal put ...

Buckroe Beach Virginia illegal put what in someone's swimsuit

Find probability that the store is full, A drug store has two windows avail...

A drug store has two windows available for serving customers, who arrive at a Poisson rate of 40/hr. Service time is exponentially distributed with a mean of 2 min. Only one window

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