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

Analytic also synthetic methods of manufacturing operations, Analytic and s...

Analytic and synthetic methods of manufacturing operations may be on the final exam. What is the difference between them? Please include an example

Explain operations management for improving a process, Recently some Operat...

Recently some Operations Management experts have begun insisting that simple minimizing process velocity, which actually means minimizing the time that it takes to process somethin

Operations function - transformation processes and planning, Operations Fun...

Operations Function - Transformation Processes and Planning The operations function is concerned with the design of transformation processes, planning their use, and organisin

Explain develop an aggregate production plan, ABC Company, a manufacturer o...

ABC Company, a manufacturer of roofing supplies, has developed monthly forecasts for roofing tiles. The forecasted demand and the expected production days for months March to Augus

Explain regulatory organizations, "Regulatory Organizations" Please respond...

"Regulatory Organizations" Please respond to the following: • Evaluate the effectiveness of JCAHO%u2019s recommendations for emergency preparedness. Discuss which recommendation

Explain what is the expected value of perfect information, Renesmee Corpora...

Renesmee Corporation is a chemical company. The research and development manager is trying to decide whether or not to develop a new solvent that would work at all conditions. It i

Explain terminals and arrive at a message concentrator, Messages are transm...

Messages are transmitted from low speed terminals and arrive at a message concentrator at a Poisson rate of 600/hr. They are held in a buffer until a hi-speed trunk line is free to

Explain sow contains words such as nearly or approximately, If the customer...

If the customers SOW contains words such as nearly or approximately, then: Answer The project manager uses his discretion in determining the meaning The sponsor uses his d

Explain make-or-buy in decision, Consider the make-or- buy in decision. Giv...

Consider the make-or- buy in decision. Give three examples of situations in which a business should make, rather than buy. Give three examples of situations in which a business sho

Define difference between a stock dividend and a stock split, What is the d...

What is the difference between a stock dividend and a stock split? As a stockholder, would you prefer to see your company declares a 100 percent stock dividend or two-for-one split

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