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 attack advertising, In 2007, the Cartoon Network was fined for publ...

In 2007, the Cartoon Network was fined for public disruption of the Bostonian transportation system while using a new form of public relations called: Answer > Guerilla advertising

Calculate the standard production, Calculate the standard production  per s...

Calculate the standard production  per shift  of 8 hours duration  with the followings data: Observed time  per unit 5 minutes  Rating  factor 120 %  Total allowances 33.3

Abc, Explain in brief the meaning, Steps involved in linear programming pro...

Explain in brief the meaning, Steps involved in linear programming problem formulation with and example

Explain how the employees effectively execute strategy, Select a company th...

Select a company that you believe uses employees to achieve a competitive advantage. Discuss how the employees effectively execute the strategy and how the company can sustain this

How to create a high-level objective for each functional, I have determined...

I have determined that McDonald's utilizes a Divisional Structure by Geographic Region organizational structure. First, is this correct? Second, what type of structure would best s

Why a small business owner consider the demographics, Why should the small ...

Why should the small business owner consider the demographics of an area when choosing a location for opening a new business? Name some sources of demographic information that are

Explain definition of a project, Definition of a Project •Analyze how proje...

Definition of a Project •Analyze how project management supports the concept of strategic planning.

Describe how you perceive personality, In this assignment, you will develop...

In this assignment, you will develop a ten item survey that will be given to all applicants at your company. The purpose of this survey is to determine whether the applicant is a p

Explain the rop that will provide a risk of stockout, Given this informatio...

Given this information Expected demand during lead time = 300 units Standard deviation of lead time demand = 30 units Determine each of the following, assuming that lead t

Time lag effects - operations function, Time Lag Effects - Operations Funct...

Time Lag Effects - Operations Function Feedback control in complex systems can bring its own problems, due to time lag between measuring the output deviation and realising the

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