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 is your assessment of the health of the project, On day 51, a ...

On day 51, a project has an earned value of $600, an actual cost of $650, and a planned cost of $560. Compute the SV, CV, and CPI for the project. What is your assessment of the he

Quality management, what are stra thetegies used in TQM to deal with issue ...

what are stra thetegies used in TQM to deal with issue of cost of quality

Explain what are the internal and external factors, What are the internal a...

What are the internal and external factors (HR/Business) that will affect the global organization today when doing business overseas

Explain what is the negative impact on that stakeholder, Which stakeholders...

Which stakeholders that was affected by the bp spill situation in America. What is the negative impact on that stakeholder?

Explain control process flow diagram, A typical change request from will in...

A typical change request from will include which of the following content item? a. a description of the change a long with the impact of marking the change. b. a status accounting

Explain improve motivation of the employees, You are a manager of a Consult...

You are a manager of a Consulting firm, with 25 employees under your supervision. Employee Motivation appears to be slipping as well as employee performance. Employees seem to have

Explain functions in which industrial manager is involved, Explain function...

Explain functions in which industrial manager is involved? The Industrial Manager is occupied in the given functions:- (i) Design products which will find acceptance in comp

Key performance objectives of operation strategy, Key Performance Objective...

Key Performance Objectives of Operation Strategy There is broad consensus that supports the view that operational competitive priorities which satisfy customers such as price

Explain charlotte inventory levels, L. Houts Plastics is a large manufactur...

L. Houts Plastics is a large manufacturer of injection moulded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the informat

Post industrial society - operations function, Post Industrial Society - Op...

Post Industrial Society - Operations Function In the post -industrial society, industrial production has become so efficient that the average worker can now afford products th

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