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

Gantt load chart, Gantt Load Chart The Gantt charts were developed by...

Gantt Load Chart The Gantt charts were developed by Henry L. Gantt about a century ago. Their purpose is to provided an immediate comparison between schedule an reality ( i,

Explain what allowance factor is better when all of the jobs, The Arkade Co...

The Arkade Company has decided to use a 15 percent allowance factor based on job time. Calculate the standard time for each work element and for the total job. The frequency equals

Explain organizational structure, Analyze the reason for the type of organi...

Analyze the reason for the type of organizational structure employed by the organization, and identify the key positions that support that organizational structure.

Explain managements and unions at odds against each other, State how produc...

State how production standards place managements and unions at odds against each other. Why do some unions prefer the right to strike in this matter while others prefer arbitration

Explain suppose you run hr at a large organization, Suppose you run HR at a...

Suppose you run HR at a large organization. How will you determine supply and demand? How will employee turnover factor into your decisions? Suppose you want to retain your two

What does b stand for in the bcg matrix, Which of the following does B stan...

Which of the following does B stand for in the BCG Matrix? (a) Boom (b) Balance (c) Bankruptcy (d) Boston

Facility layout, critic facility layout of an organisation

critic facility layout of an organisation

Explain counteract prejudice, Counteracting Prejudice One of the simplest a...

Counteracting Prejudice One of the simplest and most powerful ways to counteract prejudice and discrimination is to articulate and share stereotypes and preconceived notions. How c

Define constraint its associated binary decision variables, Consider the fo...

Consider the following constraint and its associated binary decision variables: XA + XB + XC = 2. This constraint is an example of a mutually exclusive constraint.

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