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 methods companies use to train their employees, 1. What is the sequ...

1. What is the sequence of steps that should occur before you are hired for a full-time position ? 2. Describe the types of methods companies use to train their employees. 3.

Internet often depicted as a cloud on network diagrams, Why is the internet...

Why is the internet often depicted as a cloud on network diagrams?

Explain alternatives for meeting a customer requirement, A company has two ...

A company has two alternatives for meeting a customer requirement for 9,000 units of a specialty molding. If done in-house, fixed cost would be $350,000 with variable cost at $30 p

Explain fairly complex for job shops, Why is scheduling fairly simple for r...

Why is scheduling fairly simple for repetitive systems but fairly complex for job shops?

Evaluate the two competitor''s strategies, As the industry watches to see h...

As the industry watches to see how United Airlines' strategy performs against American Airlines' strategy, management at United Airlines is anxiously monitoring market signs to det

What is acquisition management, In your own words, what do you think acquis...

In your own words, what do you think acquisition management is and what are your impressions on how it is done in the DoD?

Explain competencies required of hr management, Review the competencies req...

Review the competencies required of HR management and recommend at least two additional areas in which HR managers should be competent. Provide specific examples to support your re

Describe with specific ethical reasons, When a government is corrupt and it...

When a government is corrupt and it is taking the life of innocent people, do we have the moral right to destroy the government by force? Please explain with specific ethical reaso

Increased involvement in the colonies use examples, As mentioned in the att...

As mentioned in the attached reading on Revolutionary radicalism, the colonial response to British laws following the French and Indian War was extremely violent in many cases. Ma

Describe the role of ethics and social responsibility, Explain the role of ...

Explain the role of ethics and social responsibility in developing a strategic plan, considering stakeholder needs. Explain how your ethical perspective has evolved throughout t

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