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 criminally liable for actions of a few employees, Respondeat superi...

Respondeat superior is the theoretical basis for holding companies criminally liable for actions of their employees. Companies oftentimes have little defense against prosecution. C

Explain filbert or sword types shapes of what tool, Round, flat, filbert or...

Round, flat, filbert or sword types/shapes of what tool

Forecasting adn Time Series Anlaysis, To answer Question 1: Use the forecas...

To answer Question 1: Use the forecasting module that you opened in the POM-QM for Windows software to solve the Southwestern University case study at the end of Chapter 4 of the H

How performance based pay systems might be better designed, Is performance-...

Is performance-based pay effective? Why or why not? How performance based pay systems might be better designed to ensure optimal results

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

Operation management functions, Operation Management functions Operatio...

Operation Management functions Operations Management has many functions to carry out the transformation procedure efficiently. The function incorporates various roles which are

Explain how are sla''s performance standards agreed upon, How are SLA's per...

How are SLA's performance standards agreed upon? Give three examples of SLA's and how they would be agree upon.

Define performance appraisal, Define performance appraisal. Performanc...

Define performance appraisal. Performance Appraisal:   It is a systematic and impartial assessment of an employee's performance on the job, along with a view to discovering ho

Describe schedule of matches for the couples, Chris Lane, the head professi...

Chris Lane, the head professional at Royal Oak Country club, must develop a schedule of matches for the couples' golf league that begins its season at 4PM tomorrow. Eighteen couple

Explain how the market value of the shares, St James Ltd. Has just paid a d...

St James Ltd. Has just paid a dividend of £0.22 per share. The market expects this dividend to grow constantly in each future year at the rate of 7% p.a. The cost of capital for St

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