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

Appropriate control limits for the data, A quality team at Milburn Textiles...

A quality team at Milburn Textiles has been charged with setting up control charts to monitor a key dyeing process that has been improved and now stable.  The ideal temperature for

Explain employee for a top management position, Which would be the required...

Which would be the required qualifications to consider an employee for a top management position?

Explain inventory control, Explain inventory control. Inventory Contro...

Explain inventory control. Inventory Control - its importance and scope: Inventory control is the scientific way of finding out how much stock  be maintained so as to meet the

Explain the drug research and distribution industry, If Merck can donate $5...

If Merck can donate $50 million in free doses of ivermectin, what does that say about the amount of revenue the company generates in the drug research and distribution industry?

Explain factors in the operating environment, The model below depicts indus...

The model below depicts industry analysis and a funnel that focuses on remote factor analysis to better understand the impact of factors in Aubrey environment you find the small sa

Answer the this question as I found on the google search, Ask questioAn ups...

Ask questioAn upscale home fixture supplier has four locations. Each location manages its ordering independently. The specialized lighting fixture sells for $300 and sales are on a

Investment Management Assignment, Prepare an in-depth report recommending t...

Prepare an in-depth report recommending the appropriate investment of AUD$3 million for a five year investment period for a particular investment client. The investment portfolio i

Explain what standard time is applicable for operation, A recently negotiat...

A recently negotiated union contract allows workers in a shipping department 24 minutes for rest, 10 minutes for personal time, and 14 minutes for delays for each 4 hours worked. A

Explain what price would you try to negotiate, You have just received 10 un...

You have just received 10 units of a special sub assembly from an electronics manufacturer at a price of $250 per unit. A new order has also just come in for your computer's produc

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