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

Discuss the validity of losing control of fulfilment, Discuss the validity ...

Discuss the validity of the following statement: "Using third-party fulfilment means losing control of fulfilment

Explain development of organizational policies, In what way does a person's...

In what way does a person's value system impact the development of organizational policies? Please limit your answer in just in four paragraphs.

Explain why is external competitiveness so important, External vs. Internal...

External vs. Internal Policies. Distinguish policies on external competitiveness from policies on internal alignment. Why is external competitiveness so important? What factors sha

Computer simulation used to evaluate capacity, Computer simulation Used to ...

Computer simulation Used to Evaluate Capacity In many systems, proper scheduling of the conveners ion can lead to better use of existing capacity. Sometimes a careful analysis r

Find number of job requests, Value: 10.00 points Problem 3-4 An electrical ...

Value: 10.00 points Problem 3-4 An electrical contractor's records during the last five weeks indicate the number of job requests: Week: 1 2 3 4 5 Requests: 16 18 14 17 18 Predict

How does nestle have multiple facilities in a single country, Where in Euro...

Where in Europe, Africa, and Asia does Nestlé have operations? How many factories do they have in Spain and Thailand? Why does Nestlé have multiple facilities in a single country?

Explain project selection, "Project Selection" •For the purpose of completi...

"Project Selection" •For the purpose of completing the requirements of this course, select an actual business or personal project that assumes duration of 15 months and a functiona

Explain bottom-up and top-down estimating approaches, What are the differen...

What are the differences between bottom-up and top-down estimating approaches? Determine advantages and disadvantages for using each approach. Under what conditions would you prefe

Explain multinational business and the role of corruption, I am brainstormi...

I am brainstorming ideas and topics for possible use to launch my dissertation for my PhD in management. My current topic under consideration is: Multinational business and the rol

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