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

Describe the differences between utilization and efficiency, Discuss the di...

Discuss the differences between utilization and efficiency as measures of system performance. Which (if any) is the most useful measure for an operations manager? Why?

How much should the father deposit at the end of each year, On the day his ...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

Explain loosening the constraints, Which of the following actions would exp...

Which of the following actions would expand the feasible region of an LP model? A.Loosening the constraints. B.Tightening the constraints. C.Multiplying each constraint by

Selection criteria for the type of scheduling, Selection Criteria for the T...

Selection Criteria for the Type of Scheduling There are several types of scheduling system selection of a particular system depends on a number of factor. Some of these are des

Explain enterprisewide analytical capabilities, Knowledge: List the reasons...

Knowledge: List the reasons a business would need consistently updated enterprisewide analytical capabilities

Define organizational behaviours in certain situations, A number of persona...

A number of personality dimensions are identified (Big Five, attitudes, locus of control, etc.). What are the strengths and weaknesses of some of the personality dimensions in vari

How might the imposition of a quota on cell phones impact, Nokia Corporatio...

Nokia Corporation, headquartered in Finland, is a world leader in the cell phone industry. Because much of Finland is heavily forested and sparsely populated, it is difficult and e

Explain inventory tracking systems, Bill of Materials are kept current with...

Bill of Materials are kept current with changes using: a) Inventory Tracking Systems b) Engineering Change Order Systems c) Master Scheduling Systems d) Capacity Planni

Explain the concept of merit goods, Explain the concept of merit goods with...

Explain the concept of merit goods with reference to the formal provision of education in a country.  Merit goods are those goods and services that society values and the gover

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