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

Determine the optimal order size and total inventory cost, Case Study: ...

Case Study: The ePoint Store stocks paint in its warehouse and sells it online on its Internet Web site. The store stocks several brands of paint; however, its biggest seller i

Explain the legal environment of hrm includes eeo, The Legal environment of...

The Legal environment of HRM includes EEO, Affirmative Action, and Americans with Disabilities Act. Discuss each explaining significance.

Mathematical analysis of the normal distribution curve, Mathematical Analys...

Mathematical Analysis of the Normal Distribution Curve Mathematical analysis of the normal distribution curve has produced data tables which provide population statistics in r

Find out the nash equilibrium, In a project, executive and boss are working...

In a project, executive and boss are working together. The executive can be sincere  or insincere, and the Boss can either reward or penalize. The executive gets no advantage for b

Advantages of production planning and control, Advantages of Production Pla...

Advantages of Production Planning and Control 1. Higher productivity: The productivity can be improved by taking care of production methods and time. 2. Removal of Hurdles

Linear programming, what is the operation management in linear programming

what is the operation management in linear programming

Explain challenges in leading a multi-generational workforce, Challenges in...

Challenges in leading a multi-generational and/or multi-cultural workforces: Need a complete summary for the listed assignment, references. Please at least one page of information

Explain how selling products online internationally can harm, The question ...

The question from my book is "How might Evo's (a business selling products online in the USA) international success actually harm its business?" I understand the question but I don

Describe what the customer''s expectations, Explain what the customer's exp...

Explain what the customer's expectations are concerning the salesperson's attitude toward competition

Solve lp problem using the graphical technique, Consider the following LP p...

Consider the following LP problem: Maximize Z = 30X1 + 10X2 Subject to: 3x1 + x2 300 x1 + x2 200 x1 100 x2 50 and x1,x2 0 Solve using the graphical technique

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