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

Quality and reliability & after sales service, Quality and Reliability & Af...

Quality and Reliability & After Sales Service - Operation Strategy Quality and reliability  The extent to which the customers' expectations are satisfied or exceeded by

Modern global business environment, Describe briefly, major opportunities f...

Describe briefly, major opportunities for an organisation operating in a modern global business environment.   There are several significant opportunities for an organisation o

Explain all the principles of organization, Explain all the principles of o...

Explain all the principles of organization. Principles of Organization: Organization is a structure or mechanism which enables living things to work efficiently together.

Explain waiting for my physical delivery, Can I access the eBook while wait...

Can I access the eBook while waiting for my physical delivery?

Explain define the behaviour of leaders modelling excellence, Describe the ...

Describe the behaviours of leaders modelling excellence. How do you assess excellence and how does that inspire you to perform at higher level?

Describe concentrate on one source of competitive advantage, Do you think i...

Do you think it is better to concentrate on one source of competitive advantage (cost versus differentiation versus speed) or to nurture all three in a firm's operation?

Sunshine enterprises case study answers, what is the average value of loyal...

what is the average value of loyal customer at abby''s restaurants?

Activities and types of scheduling, Activities and Types of Scheduling ...

Activities and Types of Scheduling Scheduling includes the followings activities 1. Allocation of quality and rate of output of the plant or department. And 2. Allocation

Different roles that need to be performed by team members, Question : (...

Question : (a) "When a team is performing at its best, you'll usually find that each team member has clear responsibilities. You'll also see that every role needed to achieve t

Decide on that is the best alternative and choose weights, 1.Decide on whic...

1.Decide on which is the best alternative and choose weights for the two capacity factors based on your findings. 2.Once you have selected the factors for the two capacity alter

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