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

Describe objective functions for an lp model equivalent, Are the following ...

Are the following objective functions for an LP model equivalent? That is, if they are both used, one at a time, to solve a problem with exactly the same constraints, will the opti

Statistical aspects of variability, Statistical Aspects of Variability  ...

Statistical Aspects of Variability  Consider a pharmaceutical process producing paracetamol tablets, for which the weight of the active ingredient (nominally 500 mg per tablet

Explain productivity change for labour and investment, Refer to problem 1.1...

Refer to problem 1.13. The pay will be $8 per hour for employees. Charles lacket can also improve the yield by purchasing a new blender. The new blender will mean an increase in hi

Compute the aggregate production rate, The BackPack Company produces a line...

The BackPack Company produces a line of backpacks. The manager, Jill Nicholas, has decided that the BackPack Company must have very good customer service. She has asked you to d

Briefly describe the four different approaches to social, Briefly explain t...

Briefly explain the four different approaches to social responsibility that an organization can adopt.

Describe what is the economic order quantity, The Central Valve Company sel...

The Central Valve Company sells industrial valves and fluid control devices. One of Central's most popular valves, the Western, has an annual demand of 6,000 units. The price of ea

Define what would the average inventory be for this lot size, A chemical fi...

A chemical firm produces sodium bisulfate in 100-pound bags. Demand for this product is 20 tons per day. The capacity for producing the product is 50 tons per day. Setup costs $100

Identify the feasible region for the set of constraints, Identify the feasi...

Identify the feasible region for the following set of constraints: 3A - 2B ? 0 2A - 1b ? 200 1A ? 150 A, B >=0 This will need to include graphing or I will not ra

Explain separately compiled modules of a program, A system program that com...

A system program that combines the separately compiled modules of a program into a form suitable for execution A. assembler B. linking loader C. cross compiler D. load

How efficient is your system with the cycle time you compute, A firm uses a...

A firm uses a serial assembly system and needs answers to the following- a. A desired output of 900 units per shift (7.5 hours) is desired for a new processing system. The syst

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