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

Activities and advantage that providing facility to customer, Consider the ...

Consider the Gleneagles Hotel in Scotland - it is unique, not part of a chain. It is a six star hotel with world class sports facilities with two championship golf courses, which h

Explain when a female supervisor demands sexual favours, When a female supe...

When a female supervisor demands sexual favours from a male employee so that he can keep his job or get a raise, it is called this- a. same sex harassment b. quid pro quo har

I need to describe forecasting, I need to explain forecasting, also how it ...

I need to explain forecasting, also how it is performed at St. Arnold's Brewery (Houston, TX) also what forecasting error is and if there has been any in the past.

Explain how would you measure customer profitability, How would you measure...

How would you measure customer profitability? What approach would you use in maximizing customer lifetime value? Explain

Compute the expcted inflation rates for each year, The Fed is concerned wit...

The Fed is concerned with interest rate levels and the possibilitiy of inflation. Given the gollowing information, calculate the expected inflation premiums over hte next three yea

Explain companys competitive advantage, Which is most important for a compa...

Which is most important for a companys competitive advantage: internal consistency or market competitiveness?

Explain improvement that would benefit any organization, From the video, de...

From the video, determine how the hiring practices at Barcelona Restaurant Group could be leveraged at businesses that do not have such a tight focus on customer service. Provide s

Explain the internal and external environments, Describe the internal and e...

Describe the internal and external environments of 2 real world companies using an environmental scan. What competitive advantages does each company have and what strategies are ea

Explain critical path consists of only five activities, You are working on ...

You are working on a project that has 12 activities. You determine that the critical path consists of only five activities. You then compute the variances for the five critical pat

How you would address project management situation, MBTI and Keirsey Temper...

MBTI and Keirsey Temperament Sorter Describe the challenges you foresee in using the MBTI instrument or Keirsey Temperament Sorter in a project management situation and how you wo

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