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 leadership is more important in today''s flatter, Do you think lead...

Do you think leadership is more important in today's flatter, team based, employee empowered organizations? Why or why not?

How davis teaches supply chain management, Professor Davis teaches a course...

Professor Davis teaches a course in supply chain management at North Texas State University. She is scheduled to give her class of 32 students a final exam on the last day of exam

Define which of the following are valid range names in excel, Which of the ...

Which of the following are valid range names in Excel? Total Profit TotalProfit Total_Profit All of these b and c only

Explain what is the total cost of this policy, Rocky Mountain Tire Center s...

Rocky Mountain Tire Center sells 20,000 go-cart tires per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. Th

Explain the impact of increasing fuel prices on logistics, Describe the imp...

Describe the impact of increasing fuel prices on logistics network design

Explain assess the impact of group think and slackers, Assess the impact of...

Assess the impact of group think and slackers to the overall performance of the team and make two recommendations for how that impact could be mitigated. Provide specific examples

Objectives of operation process chart, Objectives of Operation Process char...

Objectives of Operation Process chart 1. It helps to decide whether a further and more detailed record is needed. 2. It is used in the design stages to assist the layout of th

Explain why employees join unions, Over which of the principle reasons why ...

Over which of the principle reasons why employees join unions does a supervisor have the most direct control?

Explain different steps of the supply process, When concerned with project ...

When concerned with project procurement management regarding a project, list the different steps of the supply process and reasons why or why not the project would have been more s

Explain what should susan recommend, Susan Gilbert, a purchasing agent for ...

Susan Gilbert, a purchasing agent for Wisconsin Plastic Inc (WSI) is reviewing quotations from suppliers for a new plastic gear. Susan plans to either place an order for 12000 year

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