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

Define a person stole a car from a car rental agency, A person stole a car ...

A person stole a car from a car rental agency. The police spotted the car and gave chase. The thief hit another car, seriously injuring that driver. The person who stole the car fl

Describe which organization provides that information, A union has just won...

A union has just won an election in your organization to represent the workers. You are now faced with negotiating a collective bargaining contract. Since you've never done this be

Explain executive team off-site meeting, Deliverable Length: 10-12 slides, ...

Deliverable Length: 10-12 slides, with presenter notes Details: You are an OD consultant for the Working Better Group. The President of a firm, BARTH Inc., requested a meeting w

Explain acceptability and vulnerability, Describe the four options highligh...

Describe the four options highlighted in the case in terms of their feasibility, acceptability and vulnerability.

Explain what makes the ipad a disruptive technology, 1. Evaluate the impact...

1. Evaluate the impact of the iPad using Porter's competitive forces model. 2. What makes the iPad a disruptive technology? Who are likely to be the winners and losers if the iP

Explain democracy of goods, The concept of the "democracy of goods" means w...

The concept of the "democracy of goods" means what? 1. Fill in the blanks: By Mistake, someone left spaces unfilled in the status report below. a. Please complete the report

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 how many pounds of pepperoni would you order, Charlie's Pizza order...

Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every eight weeks to take

Explain score for energy cost increases, Daniel Tracy, owner of Martin Manu...

Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a location for this factory has been narrowed to four sites: A, B, C and D. The f

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