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

Major operations management processes, Major operations management processe...

Major operations management processes     Processes                                                             Outputs Operations strategy

Disadvantages of process layout, Disadvantages of Process Layout 1. Co...

Disadvantages of Process Layout 1. Complexity of production Planning and Control: The absence of sequential mechanized channels for production make routing and scheduling more

Explain management techniques, Provide two examples of current leaders and ...

Provide two examples of current leaders and describe how they demonstrate their leadership characteristics. What separates these characteristics from management techniques? How eff

Explain the expected rate of return, Debt: Jones Industries borrows $6...

Debt: Jones Industries borrows $600,000 for 10 years with an annual payment of $100,000. What is the expected interest rate (cost of debt)? Internal common stock:

Explain effectiveness of the changes made in the us, Evaluate the effective...

Evaluate the effectiveness of the changes made in the US Air Force Academy after the 2005 religious intolerance complaints

How to prove inadequate for governing the new nation, Why did the Articles ...

Why did the Articles of Confederation prove inadequate for governing the new nation? (Think about: national unity under the Articles; lack of an executive branch; economic issues

Sectors of the economy - manufacturing and service operation, Sectors of th...

Sectors of the Economy - Manufacturing and Service Operations Any operations system, if examined in sufficient detail, will be found to be unique. However, there are distinct

Draw a diagram of the factory and finding the maximum rate, Factory is a ba...

Factory is a bathtub with 50 gallons capacity, drain is outlet to market and can output 3 gallons per hour. Faucet is raw material input and allows materials in at a rate of 4 gall

Analytical estimating, Analytical Estimating This technique  of work m...

Analytical Estimating This technique  of work measurement  is used  to determine the  time  values for jobs  having  long and  non repetitive  operations. The time  values  ar

Organisations operations strategy, Question: Operations strategies are ...

Question: Operations strategies are developed to ensure managers deliver goods or services that are better, cheaper and more responsive to customer needs. Comment on any three

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