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

What is cost accounting, I borrowed the book of cost accounting and brought...

I borrowed the book of cost accounting and brought the answer of the questions about three months ago. You charge me $15.94 for the answers per month. Now, I have returned the book

Describe benefits of free international trade, What are the benefits and di...

What are the benefits and disadvantages of free international trade for the United States?

Fraction defective p chart - control charts for attributes, Fraction Defect...

Fraction Defective P Chart - Control Charts for Attributes This type of chart is used when it is impractical or inconvenient to maintain a constant sample size. Instead of pl

Discuss whether a company must have balance set of managers, Discuss whethe...

Discuss whether a company should have a balance set of managers of equal diversity background as employees. Support your answer.

Define what should hr do about the older workers, What do companies have to...

What do companies have to do about their workforce force that has gotten older and there are not of younger to replace the aging workers? What will be the company best course of ac

Explain how much should the father deposit, On the day his son was born, a ...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

Explain what is the risk premium for the payoff, A decision maker has the f...

A decision maker has the following utility function. Payoff Indifference Probability 250 1.00 200 .90 100 .80 50 .50 -50 0 What is the risk premium for

Describe what you would/could do as a manager, Discuss what you would/could...

Discuss what you would/could do as a manager, or what you have experienced, to create 3 different "orange splats" or emotional episodes at work that are low cost with high emotion

Explain tool like this one help identify the target market, Complete the fo...

Complete the following steps for this assignment: 1. Select the following link to visit a Web site that is an online demographic tool used to help establish demographics about c

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