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

Statistical Process Control (SPC), I have an excel assignment for the SPC, ...

I have an excel assignment for the SPC, so I want to know if you could do it and how much will it cost?

Explain what are these other agency relationships, As a top executive, the ...

As a top executive, the only agency relationship I am concerned about is the one between myself and the firms owners. I think that it would be a waste of my time and energy to worr

Natural extrinsic reward comparises all the following except, Natural extri...

Natural extrinsic reward include all the following except/1.compliment/2.special Jon/3.asking advice/4.recognition/5. Merit pay increase/ which of these-answer is correct

Explain negotiated a non-deliverable forward contract, Johnson, Inc., a U.S...

Johnson, Inc., a U.S.-based MNC, will need 10 million Thai baht on August 1. It is now May 1. Johnson has negotiated a non-deliverable forward contract with its bank. The reference

Cisco systems NPI, 1. Using an appropriate operations framework outline the...

1. Using an appropriate operations framework outline the challenges / risks faced by Cisco in introducing a new product. 2. What are the general operational / supply chain issues i

Explain what is the annual ordering cost, If annual demand is 24,000 units,...

If annual demand is 24,000 units, orders are placed every 0.5 months, and the cost to place an order is $50, what is the annual ordering cost?

Explain what is the coefficient of determination, A large school district i...

A large school district is revaluating its teachers' salaries. They have decided to use regression analysis to predict mean teacher salaries at each elementary school. The research

International merketing, . Define international marketing and furnish its f...

. Define international marketing and furnish its features

Discuss regarding the interval estimate, Increasing the size of the samples...

Increasing the size of the samples in a study to estimate the difference between two population means will increase the level of confidence that a decision maker can have regarding

Explain advantages of budgets, Explain advantages of budgets. Advantag...

Explain advantages of budgets. Advantages of Budgets: (i) Actions plans and policy taken are all reflected into the budgetary control system. Now here is a formal recognit

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