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 project management at the phoenician video case, Project Management...

Project Management at the Phoenician video case Many times, project decision makers do not rely solely on financial hurdles, such as return on investment or internal rates of re

Statistical aspects of variability, Statistical Aspects of Variability  ...

Statistical Aspects of Variability  Consider a pharmaceutical process producing paracetamol tablets, for which the weight of the active ingredient (nominally 500 mg per tablet

Goldratt - theory of constraints, Goldratt - Theory of Constraints 1 i...

Goldratt - Theory of Constraints 1 identify the systems constraints  2 exploit the systems constraints  3 subordinate everything else to the above decision  4 elevate

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

Define activity a can be finished and not delay any activity, Using the dat...

Using the data in Table 13-4, determine the latest time activity A can be finished and not delay any activity? Table 13-4 The following represents a project with known activity tim

What are the potential advantages of profit sharing plan, To compete more e...

To compete more effectively, your organization is considering a profit sharing plan to increase employee effort and to encourage employees to think like owners. What are the potent

Complete the below table using rationale, Complete the below table. Which o...

Complete the below table. Which one of these techniques would you recommend to use and indicate your rationale? Technique Ave Bias Ave MAD MSE Ave MAPE Naïve

Explain never underestimate the other guy, Jack Welch, the former CEO of Ge...

Jack Welch, the former CEO of General Electric of 20 years, respected business leader and writer proposes ten fundamental leadership principles (from his 2001 book 'Jack: Straight

Solve the problem requires an excel solution, The problem requires an excel...

The problem requires an excel solution and an algebraic solution with variables: During the month of July, Pittsburgh resident Bill Fly must make four round trip flights between Pi

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