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

Compute the past growth rate in earnings, The Bouchard Company's EPS was $6...

The Bouchard Company's EPS was $6.96 in 2005, up from $3.34 in 2000. The company pays out 50% of its earnings as dividends, and its common stock sells for $40. a. Calculate the

Explain compile a list of major system life-cycle activities, Compile a lis...

Compile a list of major system life-cycle activities. For each activity on the list, try to find the related supply chain activities. Present your finding in a table with the syste

Explain grievances handling, Explain grievances handling. Grievances H...

Explain grievances handling. Grievances Handling: Individual workers generally have some complaints termed as grievances against the working rules of the business enterprise,

Define how a researcher goes about determining sample size, Discuss how a r...

Discuss how a researcher goes about determining sample size. Provide specific examples to support your ideas

Explain payoff table provides profits based on decision, The following payo...

The following payoff table provides profits based on various possible decision alternatives and various levels of demand at Amber Gardner's software firm: DEMAND Decision LOW

Define what ethical implications does organizational reality, You must pond...

You must ponder on an organizations responsibility to its workers whose skills have become obsolete. Considering the rapid pace of technological change, workers jobs will (and must

Human resource manager for a coordinated system, You have been named human ...

You have been named human resource manager for a company that has 180 employees and no formal base pay system. What steps will you take to develope such a coordinated system?

Find market price of the bond, SWH Corporation issued bonds on January 1, 2...

SWH Corporation issued bonds on January 1, 2004. The bonds had a coupon rate of 4.5%, with interest paid semiannually. The face value of the bonds is $1,000 and the bonds mature on

Calculate the optimum order quantity, 1. The annual demand for a product is...

1. The annual demand for a product is 8,000 units. The order cost is $30 for a single order. The cost of the item is $10 and the holding cost has been calculated at $3 to carry one

Explain main parts of the operations planning control system, List and brie...

List and briefly discuss the five main parts of the operations planning control (OPC) system

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