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

Depict a graph of the exponential function, Solve for x: log_10?x=3 5. You'...

Solve for x: log_10?x=3 5. You've earned your degree and have been hired by an established company. You were able to negotiate a beginning salary of $2500 per month with annual 6%

Solution about losing a rental book, I have a question about losing a renta...

I have a question about losing a rental book. One of my rental textbook: legal Management environmental MGMT330 has been lost. I want to ask how I can do for this textbook. Do I ha

ERP, DETAIL THE WORKFLOW OF HRM THAT DEPLOYES ERP

DETAIL THE WORKFLOW OF HRM THAT DEPLOYES ERP

Explain formulate a marketing mix plan, Formulate a marketing mix plan for ...

Formulate a marketing mix plan for a travel agency by constructing a minimum of three marketing objectives and goals for each of the marketing mix components, product, price, distr

Explain all types of worker's participation, Explain all types of worker's ...

Explain all types of worker's participation. Types of Worker's Participation - Worker's participation in management may take several forms, for example:   (a) Formal partici

Explain what types of quality management processes, 1. Compare and contrast...

1. Compare and contrast each of the five organizational structures from your reading (functional, divisional, matrix, team-based, and virtual network). 2. If you were to choose

Describe how channel partners rely on each other, Marketing channels are ju...

Marketing channels are just as important to an organization as pricing and product decisions. •Identify and describe three primary types of channel partners. •Provide an example of

Explain the e-activity, "Big Box" Please respond to the following: •From th...

"Big Box" Please respond to the following: •From the video, determine if it is the responsibility of an organization to pay its workers a "living wage." Explain your rationale. •Fr

Explain obstacles employees faced with pension plan funding, What are four ...

What are four safeguards that the ERISA legislation specified to address the many obstacles employees faced with pension plan funding? How did the Pension Protection Act add additi

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