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

Explain how many pounds of pepperoni would you order, Charlie's Pizza order...

Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every eight weeks to take

Explain differences between management and leadership, Suppose you realize ...

Suppose you realize one day that you are dissatisfied with your job. What might you do to improve your situation? What are the basic differences between management and leadership?

Explain about the economics of scope of lean production, Explain about the ...

Explain about the economics of scope of lean production. Economies of scope: It is possible while resources as like machinery or labour can be shared to manufacture vari

Explain development performance management, Human resource activities that ...

Human resource activities that do NOT relate to motivating workers include: Answer career development performance management training initiatives retention initiatives

Use cases, A case study presents an account of what happened to an organisa...

A case study presents an account of what happened to an organisation or business over a period of time. It chronicles the events that occurred within that organisation and which th

Explain the advantages of the scientific method, Describe the advantages an...

Describe the advantages and disadvantages of the scientific method and qualitative approaches to research

Explain productivity in terms of management, Explain Productivity in terms ...

Explain Productivity in terms of management. Productivity may be defined as the ratio in between output and input. Output implies the amount produced or the no. of items prod

Explain project charter is to help the project team, One purpose of the pro...

One purpose of the project charter is to help the project team and the project sponsor to commit to the project

Explain efects in the accounts receivable department, Category- 1) Invoi...

Category- 1) Invoice Amount does not agree with check amount 2) Invoice not on record 3) No formal invoice issued 4) Check (payment) not recieved on time 5) Check no

Explain graphic project report used in project management, Which of the fol...

Which of the following is a graphic project report used in project management?

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