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 were mcdonalds inventory turns, McDonalds Inventory $128.40Rev...

McDonalds Inventory $128.40Revenue $17, 140.50COGS $ 11943, 70Gross Profit $5,196.80 Wendy's Inventory: $54.40Revenue: 3148.90COGS: 1634.60Gross Profit: 1514.40 A. What were

Compensation and benefits employer can offer their employees, Compensation ...

Compensation and benefits; what are all that an employer can offer their employees? What kind of compensation? What kind of benefits?

Explain some of the key decisions its management, Describe some of the key ...

Describe some of the key decisions its management has faced within the past year or two. Identify an ethical issue the organization either faces or has faced in the past. If it has

Explain linear programming problem graphically, Solve the following linear ...

Solve the following linear programming problem graphically by enumerating the corner points. MAX: 3X1 + 4X2 Subject to: X1 X2 4X1 + 6X2 X1, X2 > 0 First

Characteristics of job order production, Characteristics of job order Produ...

Characteristics of job order Production Small Production Runs: Job order production is characterized by the manufacturing of one or few numbers of single product designe

Explain router could not be used as a fire wall, Which of the following cou...

Which of the following could not be used as a fire wall? a. hub b. router c. server d. PC

Assignment 2000 words, Assignment EITHER A. Practical application of concep...

Assignment EITHER A. Practical application of concepts in a local organisation • You are required to analyse and evaluate a key aspect of operations management covered in this subj

Explain forecast including trend for the month, A manufacturer of printed c...

A manufacturer of printed circuit boards uses exponential smoothing with trend to forecast monthly demand of its product. At the end of December, the company wishes to forecast sal

Qn, a firm whether to make or buy a part required in its operation. cost an...

a firm whether to make or buy a part required in its operation. cost and volume estimate are as follows annual fixed cost make $15000 buy none, variable cost make $60 buy $80, annu

Describe the importance of each in relation to outsourcing, List five consi...

List five considerations to consider when starting to define the scope of the business process outsourcing transaction and discuss the importance of each in relation to outsourcing

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