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

Political risk for an organisation, Identify, with examples, groups that ma...

Identify, with examples, groups that may represent a significant political risk for an organisation that is considering engaging in Foreign Direct Investment.  When companies a

Industrial production index, Industrial Production Index The measure of...

Industrial Production Index The measure of the combined output of all products like mining, manufacturing, and electric and natural gas utilities organization in the United Sta

Total and partial factor productivity measurements, Total and Partial Facto...

Total and Partial Factor Productivity Measurements  Total factor productivity (TFP) is the best measure when describing national productivity, because it includes all the inpu

Explain selected product to the selected demographic group, ASSIGNMENT THIS...

ASSIGNMENT THIS IS A GRADED ASSIGNMENT THAT IS A COURSE REQUIREMENT? Select one specific product (For example: iPhone Levi jeans, Adidas sports shoes, Chevrolet Volt)? Select one o

Explain participatory management style, Leslie Igles is being sent to Irela...

Leslie Igles is being sent to Ireland as the new manager of a local subsidiary of a U.S. firm. She has a participatory management style and is known for her ability to relate to th

Explain enable them to limit the probability of a stockout, A wine company'...

A wine company's daily demand is normally distributed with a mean of 18 bottles, and a standard deviation of 4 bottles. This company checks their winery's stock every 30 days. In t

Explain what is the firm''s break-even point in sales dollars, You have dev...

You have developed the following income statement for the Hugo Boss Corporation. It represents the most recent year's operations, which ended yesterday. Sales $ 50,439,375 Va

Discuss factors are vital for the success, Selecting the right projects ...

Selecting the right projects Selecting the right parteners Providing an effective leadership Discuss why these factors are vital for the success of international construct

Servqual model - consumption of service products, SERVQUAL Model - Consumpt...

SERVQUAL Model - Consumption of Service Products In later publications PZB, having analysed their data using factor analysis, reduced the original ten dimensions to the follow

Line balancing, #quest What happens if line balance doesn’t existion..

#quest What happens if line balance doesn’t existion..

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