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 what issues would a judge decide, Fun Products, Inc. is in the busi...

Fun Products, Inc. is in the business of designing computer games. At the end of a particularly successful year, company management decided to throw a celebration party at which it

What are the various managing inventory tools, Q. What are the various mana...

Q. What are the various managing inventory tools? Raw material Materials and elements used to assemble or manufacture finished goods. Work-in-progress Incomplete f

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

Compute arriving patients can receive treatment immediately, The emergency ...

The emergency room serves patients who arrive according to a Poisson distribution at the rate of 9 per hour. Treatment takes an average of 6 minutes and the treatment times can be

Project network , Heckman of Saul and Saul Consultants has get a request fr...

Heckman of Saul and Saul Consultants has get a request from Deborah, the head of Human Resources, to make an interactive icon-and-menu-driven software package to be used by the adv

Explain what are the optimal solution values of x and y, Suppose the firm i...

Suppose the firm in this example considers a second product that has a unit profit of $5 and requires 2 hours for each unit produced. Assume total production capacity remains 40. U

What are disadvantages of delegated sourcing strategies, What are the disad...

What are the disadvantages of using delegated sourcing strategies? Disadvantages of using delegated sourcing: a. Can be a complicated relationship to manage an outsourcer

Explain panel interviewing and its strengths and weaknesses, You're going t...

You're going to have to stretch your imagination for this question:. Assume you're involved in a panel interview team. Identify one strength and one weakness in this interview appr

Explain a pareto analysis of the errors, 1. Construct and inspect a control...

1. Construct and inspect a control chart for the packing slip data. 2. Construct a Pareto analysis of the errors. 3. What information might a separate chart for each error ca

Explain approaches that project managers, Project managers frequently face ...

Project managers frequently face competing constraints. Identify these common constraints and describe approaches that project managers can use to make the trade-offs required to s

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