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 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

Describe how investigators may go about collecting evidence, Discuss the le...

Discuss the legality of the hacker's actions as described in the "Hacking into Harvard" article. Explain how investigators may go about collecting evidence if a crime was thought t

Explain the part of machine level instruction, The part of machine level in...

The part of machine level instruction, which tells the central processor what has to be done, is A. Operation code B. Address C. Locator D. Flip-Flop E. None of the

Why hrm-r technologies financial impact of talent management, • Analyze the...

• Analyze the article's perspectives concerning talent management and technology issues. • Suggest strategies for evaluating HRM-r technologies financial impact of talent manage

Number of rules for string diagram, There are a number of rules developed a...

There are a number of rules developed and given under three broad headings: 1. Related to the use the Human Body : a. The two hands should beings as well as complete their

Explain importance of team preparation, • Prepare a 3 to 5 page paper discu...

• Prepare a 3 to 5 page paper discussing what conclusions you can reach on the importance of team preparation and member selection to the "Define" stage, and eventual success of Si

Explain hospital risk pool, A hospital has contracted with an HMO to provid...

A hospital has contracted with an HMO to provide acute care inpatient services for $1,000 per day, subject to a 10 percent withhold. The proposed budget for inpatient services is b

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