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

Data show that women earn only following, Data show that women earn only---...

Data show that women earn only----------------cents per dollar earn by men/1.68 cents/2.75 cents/3 50 cents/4 95 cents/4/ 95 cents/5 90 cents/ which is the correct answer for this

I need to cancel my order i made earlier today, I want to cancel my order I...

I want to cancel my order I made earlier today. How do I do this and get a full refund?

Operations management case, Operations Management Case: choose one com...

Operations Management Case: choose one company. You must study the chosen company from the point of view of the ten critical operations management decisions. The group will wr

Describe methods to diagnose employee stress, Discuss methods to diagnose e...

Discuss methods to diagnose employee stress and the specific OD (organizational development practitioner) interventions aimed at alleviating it in the workplace.

Explain the working of employees in flexible organisations, Explain the wor...

Explain the working of employees in flexible organisations. Working of employees in flexible organisations: • Production workers may be needed to take on indirect tasks as l

Explain when quality discounts are introduced, When quality discounts are i...

When quality discounts are introduced, will optimum order quantity be made smaller, unchanged, or larger? Illustrate by using a numerical example.

Explain variable costs, Explain Variable costs. Variable costs converse...

Explain Variable costs. Variable costs conversely, tend to vary directly along with the volume of output. Illustrations of variable cost are: - * Direct production labour co

Discussion questions for barriers to enterprise, Complete the Case Study Di...

Complete the Case Study Discussion Questions and Critical Thinking Questions in Case Two "Barriers to Enterprise 2.0," Stair,

Explain what are the problems that walmart has faced, What are the problems...

What are the problems that Walmart has faced and what has the company done to address

External factors - factor affecting productivity improvement, External Fact...

External Factors - Factors Affecting Productivity Improvement As was previously stated, the organisation has no direct control over external factors, be they government policy

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