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

Describe the problem with labour productivity, Two types of cars (Deluxe an...

Two types of cars (Deluxe and Limited) were produced by a car manufacturer in 1997. Quantities sold, price per unit, and labour hours follow. What is the productivity for each car?

Explain would the public approve of this campaign, The marketing team prese...

The marketing team presents a children's cereal brand manager with "Less Sugar" ad campaign for three of her brands. Large print and dynamic type on the package exclaiming "75% LES

Connected flow and disconnected flow system, Connected Flow and Disconnecte...

Connected Flow and Disconnected Flow System Such systems deliver very low unit costs, they are vulnerable; because of the absence of work-in-progress buffers, if one process f

How excellent results in generating revenue and profit, What does it take t...

What does it take to influence a sales team to achieve excellent results in generating revenue and profit? To help understand this process, discuss some of the most important cri

Explain a wealthy farmer owns fifty acres of land, A wealthy farmer owns fi...

A wealthy farmer owns fifty acres of land. He is going to plant each acre with sugarcane or corn. Each acre planted with sugarcane yields Rs 16,000 profit; each with corn yields Rs

Explain meeting organizational objectives, Write a 350- to 700-word paper t...

Write a 350- to 700-word paper that defines and compares and contrasts the following: • Innovation• Design• Creativity Describe the importance of the three items in meeting organiz

Explain when a firm is able to move to an assemble, When a firm is able to ...

When a firm is able to move to an assemble- To- Order capability from a make -To- Stock approach, there can be a substantial reduction in the number of things that must be tracked

Product /management, Define Product Management,functions of Product managem...

Define Product Management,functions of Product management

Job Design, compare and contrast job design with related or dependent proce...

compare and contrast job design with related or dependent processes

Explain how to do aon in excel 2010, Does anyone know how to do aon in Exce...

Does anyone know how to do aon in Excel 2010 and if so can they contact me and wlk me through it sso that I can understand it

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