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 external competitive policies and techniques, 1. How might a compan...

1. How might a company's business strategy affect the internal alignment policies and techniques of its Total Compensation system? 2. How might a company's business strategy affect

Trying to affect tangibles quality dimension, Dave noticed that at the plac...

Dave noticed that at the place where he gets his haircut, Hair Town, there is an employee who sweeps up hair every 15 minutes. By doing this, the management at Hair Town is trying

Depict a fish-bone chart showing causes of defective product, Boston Electr...

Boston Electric Generators has been getting many complaints from its major customer, House Station, about the quality of its shipments of home generators. Daniel shimshak , the pla

Explain the need for management to motivate their employees, Problem 1: ...

Problem 1: Team working is gaining importance in modern organisations. Do you agree that all members of an organisation could be expected to be team players? Discuss with exa

Explain information systems, Write an essay of between 750-1000 words, doub...

Write an essay of between 750-1000 words, double-spaced, on the topic of information systems being leveraged to create competitive advantage for the business. Use well-known indust

Identify five major economic variables, Identify five key economic variable...

Identify five key economic variables that could represent major opportunities or threats to a bank in your town or city. Identify which that you believe to be most important, and d

Linear programming, A small-scale industry manufactures electrical regulato...

A small-scale industry manufactures electrical regulators, the assembly of which is being accomplished by a small group of skilled workers, both men and women. Due to the limitat

Compounded annually means, What is the present value of $10000 to be receiv...

What is the present value of $10000 to be received 20 years from now , if the principle is invested at 8% per year, compounded annually ?

Compute the bias and mad for each set of forecasts, Given the series of dem...

Given the series of demand data below Period: 1 2 3 4 5 6 7 8 9 10 Demand: 43 31 52 44 23 48 40 39 30 40 Calculated forecasts for periods 7 through 11 using moving average

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