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

Operations management , #question: mass customisation and rapid product dev...

#question: mass customisation and rapid product development can be regarded as current trends in morden manufacturing operations. explain each of these and discuss the relationship

Explain the companys core competencies, As the end of the year comes to a c...

As the end of the year comes to a close, the CEO is evaluating Motorola's strategic approach and its ability to produce desired results for the company in the future. The CEO has a

Explain advantages of division of labour, Explain advantages of Division of...

Explain advantages of Division of Labour.  As the same worker does similar work repeatedly:- (i) It gains proficiency and skill on the job and becomes a professional. (ii

Explain the role of purchasing, Describe the role of purchasing in contribu...

Describe the role of purchasing in contributing to the profitability of the enterprise

What is network perspectives in innovative research, What are the different...

What are the different network perspectives in innovative research? Why do authors differ in how they define innovation networks? How can networks influence actions of its members?

The transformation process model and systems thinkin, #qu1) Using the trans...

#qu1) Using the transformation process model and systems thinking concepts, explain the key operations TGL works. Pay particular attention to flow of materials and the role played

Explain what advice might herzberg give bridget, Bridget Jones has been the...

Bridget Jones has been the manager of the research office at her company for over a year. She is beginning to wonder if she will ever be comfortable in this role. Her employees see

Define differences among productivity and its subcomponents, Describe the d...

Describe the differences between productivity and its subcomponents (total measure productivity, partial measure productivity, and multifactor measure productivity) related to prod

Describe the use of strike replacements, Itemize and discuss the different ...

Itemize and discuss the different types of strikes and lock outs, their roles in labour relations and their legal restrictions in private and public sectors. Discuss the use of str

Explain what are the legal and ethical ramifications, What are the legal an...

What are the legal and ethical ramifications for falsifying a resume?

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