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

Compute present value of cash flow stream by interest rates, Calculate the ...

Calculate the present value of the cash flow stream in problem 2 with the following interest rates- 1. Year 1 = 8% 2. Year 2 = 6% 3. Year 3 = 10% 4. Year 4 = 4% 5. Year 5 = 6% 6. Y

Factors affecting productivity improvement, Factors Affecting Productivity ...

Factors Affecting Productivity Improvement  As has already been stressed, productivity improvement is not simply concerned with finding ways of making people work harder, nor

Explain own personal devices used for work, BYOD and we are reading so much...

BYOD and we are reading so much about BYOD (bring-your-own-device). Are the mobile devices you use for business owned by the company or are they your own personal devices used for

Explain coaching for performance changes, Motivation and rewards: coaching ...

Motivation and rewards: coaching for performance changes. References

Explain what are the challenges associated with erp system, Research ERP sy...

Research ERP systems by visiting the ERP company provider website of your choice (i.e., SAP, Ellucian, Oracle, Peoplesoft, Microsoft, Workday, etc.) Write an essay of between 750-1

Calculate wal-marts shift in strategy from just saving money, "Wal-Mart Sto...

"Wal-Mart Stores Inc." Please respond to the following: • Assess how the constant bashing of Wal-Mart by the media impacted Wal-Marts ability to operate effectively in the commu

Developing a service strategy - operations strategy, Developing a Service S...

Developing a Service Strategy - Operations Strategy The figure below gives an outline of the three steps of developing an operations strategy based on the Platts-Gregory appro

Explain when managing organizational change, When managing organizational c...

When managing organizational change, which would be more effective in overcoming resistance to change: rational persuasion, leader-follower relationship, both, or something else

Operation planning and scheduling system, Operation Planning and Scheduling...

Operation Planning and Scheduling System Operation planning g and scheduling system concern the volume and timing of the outputs utilizations of the operations capacity and the

Observation of behaviour of company - service process matrix, Observation o...

Observation of behaviour of company - Service Process Matrix Schmenner observes that many service industries seem to be adopting competitive stances which imply moving up the

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