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

List countries that lead in export and import of merchandise, The WTO's Int...

The WTO's International Trade Statistics is an annual report that provides comprehensive, comparable, and updated statistics on trade in merchandise and commercial services. This r

Compute a simple exponential smoothing forecast, The actual demand of the p...

The actual demand of the patients at Omaha Emergency Medical clinic for the first six weeks of the year are as follows: week Actual # of patients 1 65 2 62 3 70 4 48 5 63 6

Explain project management at the phoenician video case, Project Management...

Project Management at the Phoenician video case Many times, project decision makers do not rely solely on financial hurdles, such as return on investment or internal rates of re

Explain what are the positive and negative impact of tariffs, 1) What are a...

1) What are at least three factors that would motivate a company to set up a foreign operation? 2) What are the positive and negative impact of tariffs? Give a specific example

Describe the differences between a scenario method approach, Can you explai...

Can you explain the differences between a scenario method approach that pre-supposes a classical economic paradigm and a critical scenario method approach? I have tried to find the

Case Study, Bloomsday Outfitters produces T-shirts for road races. They nee...

Bloomsday Outfitters produces T-shirts for road races. They need to acquire some new stamping machines to produce 30,000 good T-shirts per month. Their plant operates 200 hours per

Explain why is it important to develop their products, Why is it important ...

Why is it important to develop their products/services marketing plan in writing?

Explain what is the status of the internet contract, Beth advertised her 20...

Beth advertised her 2005 Corvette for sale on the Internet. In her advertisement, she falsely stated that the vehicle had only been driven 60,000 miles when in fact it had been dri

Explain investment spending sharply declined in the us, In early 2001, inve...

In early 2001, investment spending sharply declined in the U.S.. In the two months following the Sept. 11, 2001 attacks on the U.S., consumption also declined. Use AD-AS analysis t

Describe independent populations where the variances, In order to test the ...

In order to test the difference in population's means, samples were collected for two independent populations where the variances are assumed equal and the population normally dist

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