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 what is the economic order quality, Quick cheif cookers sell at an ...

Quick cheif cookers sell at an average [ace of 12500 per month. Each cooker costs the company $100. The annual carrying cost for each cooker is 10%. Each Each order that is place

Define management information system and its scope, Normal 0 fa...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Jumpin jack flash case study, What management skills did Jack use as market...

What management skills did Jack use as marketing manager for travel products company? And management skills did he use as VP the consumer products firm?

Explain what is the current multifactor productivity, Question 1 of 6. Ambe...

Question 1 of 6. Amber Patel operates a delicatessen store in South Lambert, Nevada. Currently, the store has 4 employees, each one working 160 hours per month. Because of its exce

Discuss the internal factors as means of improving business, 1.Read the fol...

1.Read the following case:  'Mr Soft n Cool Gelato' is an Ice Cream business owned by Alfredo and Guido Corleone. Since they started the business 18 years ago the firm has expan

Explain statistical differences between men and women, What rule of thumb o...

What rule of thumb or guidelines would you recommend for deciding whether statistical differences between men and women, or non-minorities and minorities, reflect discrimination oc

Explain the employers responsibility, Describe the employers responsibility...

Describe the employers responsibility, giving at least three examples. Be sure to use a credible academic/professional source and include the link in your summary.

Explain the skills of an engineer and an engineer manager, Compare the skil...

Compare the skills of an engineer and an engineer manager

Linear programing, Ask question #Minimum 100 words acceptNas food produces ...

Ask question #Minimum 100 words acceptNas food produces to kinds of popular dark chocolate bars. the banana and coffee. the banana bar costs 0.22 to make and sells of 0.35, where a

How enhance ethical behavior at work, Discuss options companies use to enha...

Discuss options companies use to enhance ethical behavior at work

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