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

What is performance measures, Last year, the manager of the service departm...

Last year, the manager of the service department at East Woods Ford instituted a customer opinion program to find out how to improve service. One week after service on a vehicle wa

Differentiate between quality assurance and quality control, Question: ...

Question: (a) ‘Quality has been identified as one of the performance objectives.' Give three reasons why quality is important for a service provider such as a Tourist resort

When needed extra money to spend, Please explain in detail the answer for t...

Please explain in detail the answer for the following scenario: Your boss looks at his budget in April and realizes that he has extra money to spend, so he tells you to create and

Explain implications of the competitive advantage of nations, Porter's Five...

Porter's Five Forces Model and the implications of the Competitive advantage of Nations' research on this model

Explain what is product configuration, What is product configuration? Provi...

What is product configuration? Provide an example of how this practice is used in the sale of commercial stereo equipment

Identify and research information and discuss, Identify and research three ...

Identify and research three of your employers of choice and visit their websites. Create a 6 - 8 slide Microsoft PowerPoint presentation identifying and discussing how well each co

Describing the classical and contemporary views, There are five elements of...

There are five elements of organizational design and structure that are used to manage an organization, Division of Labour, Span of Control, Unity of Command, Authority/Responsibil

Explain develop an mrp planning schedule showing gross, Assume that Z is ma...

Assume that Z is made of two units of A and four units of B. A is made of three units of C and four of D. D is made of two units of E. Lead times for purchase or fabrication of ea

Plant layout, possible quesstions of plant layout

possible quesstions of plant layout

Explain vent-promotion bauiness, Hirizontal intergration has benefits to th...

Hirizontal intergration has benefits to the firms involved. Consider the consolidation in the vent-promotion bauiness when Live Nation bought Ticketmaster in 2010. List some specif

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