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

Describe expect it to take for the customer to wait in line, A toll tunnel ...

A toll tunnel has decided to experiment with the use of a debit card for the collection of tolls. Initially, only one lane will be used. Cars are estimated to arrive at this experi

Explain discussion maker acted unfairly in this situation, Why do think the...

Why do think the discussion maker acted unfairly in this situation?

Explain what is your best choice using emv criterion, Dalton and Carla run ...

Dalton and Carla run a small bicycle shop called "D n C"Bicycles. They must order bicycles for the coming season. Orders for the bicycle must be placed in quantities of twenty(20).

ERP, DETAIL THE WORKFLOW OF HRM THAT DEPLOYES ERP

DETAIL THE WORKFLOW OF HRM THAT DEPLOYES ERP

What is decomposition principle, Solve the following linear program using t...

Solve the following linear program using the decomposition principle: minimize z = ?2x1 ? 5x2 subject to x1 + 2x2 = 13.5 x1 + 3x2 = 18.0 x1 ? 9 x2 ? 5 x1, x2 ? 0. Let the first two

MBA 2ND SEM, Q3. What do you understand by “line balancing”? What happens i...

Q3. What do you understand by “line balancing”? What happens if balance doesn’t exist?

How following has been cited as recommendation for changing, which of the f...

which of the following has been cited as a recommendation for changing structure and perfection to address the leakingipeline/1.create origination culture more satiating to women//

Explain why is it impirtant for pay to be externally fair, 1. Why is it imp...

1. Why is it impirtant for pay to be externally fair? 2. Why is it important for pay to be internally fair? 3. What should Costa Vida's compensation strategy look like?

Explain communication behaviours destroy trust, One of the most important f...

One of the most important factors determining whether organizations and their members will be high performance is the presence of trust between leaders and followers. What types of

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