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 the quality control implications of the major change, in a 3-4 page...

in a 3-4 page paper answer the following: Q1. Describe the quality control implications of the major changes that have taken place in food chains today compared to the past. Q2. Wh

Explain licensing contract manufacturing exporting, 1, Meridian sells sand ...

1, Meridian sells sand to customers in saudi arabia. 2, McDonald's in Germany. 3, Campbell's soup company contract with Nakano Vinegar form Campbell Nakano. 4, Flextronic

Explain the current organizational culture, Using the competing values fram...

Using the competing values framework as a point of reference, how would you describe the current organizational culture? Provide examples to support your conclusions.

Explain an in-n-out pay strategy, An In-N-Out Pay Strategy: Costa Vida's De...

An In-N-Out Pay Strategy: Costa Vida's Decision to Boost Pay

Calculate the proposed capital budgeting project, Tommy Tinker Toys Inc. is...

Tommy Tinker Toys Inc. is considering a capital budgeting project that is unrelated to their current investments. The proposed project will be 40% debt financed at rd = 11.25%. The

Describe the ethics of continuing to do business, Assume you are a manager ...

Assume you are a manager of a large heavy equipment manufacturing company. Your company currently outsources the manufacturing of a specialized piece of equipment to a firm in anot

Explain processing time per claim, Medical Solutions, Inc. has the followin...

Medical Solutions, Inc. has the following claims it must complete in the next week (40 hours). The jobs are as follows: Claim Type Number of Claims to Process Setup (Changeover) Ti

Explain close the gap between management and employees, Identify what HR m...

Identify what HR mechanisms can be introduced in the international firm today to build a strategic business partnership, close the gap between management and employees while bui

Performance prism - performance and productivity measures, Performance Pris...

Performance Prism - Performance and Productivity Measures Neely and Adams (2000) argue that in their recent research managers and academics highlight the need for a fresh pers

Scrutinise the process sequences and calculate annual cost, Scrutinise the ...

Scrutinise the Process Sequences and Calculate Annual Cost A company produces a range of product, but the dominant demand is for three of them, A, B and C. The table shows the

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