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 specific actions entrepreneurs can take, Consider the four maj...

Consider the four major reasons for new business failure. Discuss what specific actions entrepreneurs can take to minimize or avoid these causes of failure

Explain what is the capacity of the factory, Hickory Manufacturing Company ...

Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. Year 1 2 3 4 5 Forecast demand 60 79 81 84 84 Currently

How many cells must be used to represent each constraint, In excel how many...

In excel how many cells should be used to represent each constraint?

Product layout, how to identify layout ex holidays resort

how to identify layout ex holidays resort

What are generally accepted accounting principles, Yvon, an accountant, is ...

Yvon, an accountant, is charged with negligence by Zesty Sauce, Inc., a client. Yvon may successfully defend against the claim if she can show that (Points : 2) scienter was lackin

Give specific example of all type of strategy marketing plan, Imagine that ...

Imagine that you are creating a marketing plan for a company that will sell motor scooters . As you consider the marketing program, what types of strategy should you consider inc

Distribution among between affect international businesses, How do differen...

How do differences in income levels and income distribution among nations affect international businesses?

Japanese firms used the which concept, Q All of the following are responsib...

Q All of the following are responsibilities of operations managers except Question options: 1) acquiring financial resources 2) managing inventories 3) planning production 4) sched

Explain companys competitive advantage, Which is most important for a compa...

Which is most important for a companys competitive advantage: internal consistency or market competitiveness?

Explain the role of a pilot project in information systems, Petrie's Electr...

Petrie's Electronics Case, Chapter 10, Questions 1%u20135 (page 359). 4. What is the role of a pilot project in information systems analysis? Why do you think the Petrie%u2019s

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