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 entrepreneurial and machine bureaucracy, Find 5 organizations (one ...

Find 5 organizations (one that fits each of the below categories) and include the Web site link and the reason it fits the category: 1-Entrepreneurial 2-Machine bureaucracy

What are programmed and non-programmed decisions, What are programmed and n...

What are programmed and non-programmed decisions? Programmed decisions are which made in accordance with some procedure, rule or habit. Non-Programmed decisions are those which

Define what are the three steps in completing a job analysis, As an entrepr...

As an entrepreneur, how would you go about doing a job analysis for the first employee you are going to hire in your new business? What are the three steps in completing a job anal

Explain marketing and selling, What is your understanding of the terms: mar...

What is your understanding of the terms: marketing and selling? Are they the same? How do you differentiate the two terminologies? Provide examples to support your points.

Explain job design be used to create a motivated workforce, How can job des...

How can job design be used to create a more motivated workforce? Be specific.

Explain security professionals as technology advances, Identify potential e...

Identify potential ethical challenges that may be faced by security professionals as technology advances, applications become more mobile, and computer criminals become more innova

Explain what is an interim plan, Answer the following questions: 1) ...

Answer the following questions: 1) What is the difference between a task dependency and a task constraint? 2) Give a real-world situation when you might used the foll

Explain what monthly penalty is the company incurring, A food processor use...

A food processor uses approximately 29,730 glass jars a month for its fruit juice product. Because of storage limitations, a lot size of 4,000 jars has been used. Monthly holding c

Explain about figuring out what your startup costs will be, Let's switch ge...

Let's switch gears and take a look at starting your own business, instead of buying an existing one. When you think about starting a brand new business, you need to know how much y

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