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

Line balancing, What do you understand by “line balancing”?

What do you understand by “line balancing”?

Define potential risks and bottlenecks that occur in project, Briargrove ha...

Briargrove has agreed to your plan. The CLN Team is asking for a refined version of the plan making the corrections based on their recommendations. They are requesting a comprehens

Describe the differences between a scenario method approach, Can you explai...

Can you explain the differences between a scenario method approach that pre-supposes a classical economic paradigm and a critical scenario method approach? I have tried to find the

Identify the business level strategy of walmart corporation, Looking at Wal...

Looking at Walmart Corporation, identify it's Business Level Strategy. Short paper format about 100-300 words or as needed.

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

Explain characterize the bacterial and bacterial-like, Characterize the bac...

Characterize the bacterial and bacterial-like STIs, focusing on infectious agents and manifestations

We want to consider some accounting ideas, We need to consider some account...

We need to consider some accounting ideas in order to cover this weeks Objective # 3. So in that regard, for your own business, which method of accounting would you use, the "accru

As a result of testing 20, As a result of testing 20,00 electric bulbs manu...

As a result of testing 20,00 electric bulbs manufactured by a company it was found that the lifetime of the bulbs was normally distributed with a mean of life of 2040 hours with st

Explain impact far beyond their firm boundaries, Multinational enterprises ...

Multinational enterprises (MNEs) have an impact far beyond their firm boundaries. Assume you are working for a small firm that supplies a product or service to an MNE. How might yo

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