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 this can affect people''s sense of responsibility, In the morde...

In the mordern world most people work in organisations. Describe how this can affect people's sense of responsibility and the morality of their conduct.

Explain ways to embed organizational culture, Which of the two ways to embe...

Which of the two ways to embed organizational culture has SAS used to create its current culture? Provide examples to support your conclusions.

Explain when developing your communication strategy, Why should you conside...

Why should you consider the context of your message when developing your communication strategy? Identify four questions you should ask yourself to help you understand the context

Compute the expected weeks of supply, The owner of Genuine Reproductions (G...

The owner of Genuine Reproductions (GR), a company that manufactures reproduction furniture, is interested in measuring inventory effectiveness. Last year the cost of goods sold at

Explain hamilton marketing services, Could someone help me to figure out th...

Could someone help me to figure out this case? Thanks very much. Alex Hamilton founded Hamilton Marketing Services in 1999 after leaving a major marketing consulting firm in Chicag

Explain what forecast is the most accurate, Data collected on the monthly d...

Data collected on the monthly demand for lawn mower at Azaka Gaarden Supply are shown in the following table Period Demand for lawn mower January 10 February 12 March 18 April 16 M

Compute the probability that a type1 customer arrives, Consider a queuing s...

Consider a queuing system with 2 types of customers. Type 1 customers arrive according to a Poisson process with a mean rate of 5 per hour. Type 2 customers arrive according to a P

Explain major forms and methods for performance appraisal, Discuss each of ...

Discuss each of the major forms and methods for performance appraisal. Provide an adequate summary of each

Create an is strategy for an organisation, 1. Create an IS strategy for you...

1. Create an IS strategy for your organisation.  2. Give examples of the Data, Information and Knowledge that are used in your organisation. 3. How would the idea of sustaini

Explain ethical for employers to use information technologie, Is it ethical...

Is it ethical for employers to use information technologies to extend work into employees home lives?

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