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 how else might national origin discrimination occur, National origi...

National origin discrimination is prohibited against a job applicant or employee. Besides discriminating against the job applicant or employee directly, how else might national ori

Compute forecasted sales, In the table given below the Distribution Manager...

In the table given below the Distribution Manager is expected to service these DCs as per the demands placed. If the actual sales after completing week one is as follows, what woul

Explain project manager is normally directly accountable, The project manag...

The project manager is normally directly accountable for the project result, schedule and budget.

List any three business areas in the umuc pizza shops, List three business ...

List three business areas and/or processes used in the UMUC Pizza shops that could be supported by an IT solution.

Describe the graphical or the simplex lp method, Solve the following proble...

Solve the following problem using either the graphical or the simplex LP method. Max: 2X1 + 6X2 s.t. 2X1 + 2X2 ? 10 1X1 + 4X2 ? 8 X1, X2 > 0

Explain high quality information, Analysis: categorize the five common char...

Analysis: categorize the five common characteristics of high quality information and rank them in order of importance to carnival cruise.

Describe the biggest organizational managerial mistake, • Determine the big...

• Determine the biggest organizational managerial mistake you have seen or read about and determine how this mistake affected the organization. • Discuss ways to ease the transi

Explain lean relates to an organization being agile, a. Do you think lean r...

a. Do you think lean relates to an organization being agile? b. Would implementing lean into an organization lead to a competitive advantage? if yes, explain, how and what types

Explain homogenous group, In a diverse team, a "fault-line" refers to: a. C...

In a diverse team, a "fault-line" refers to: a. Cases in which a team tends to find fault or blame in the other team members rather than their own behaviour b. Cases in which group

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