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

Approaches for handling customer complaints and listening to, explain appro...

explain approaches for handling customer complaints and listening to customers

Describe what is the workstation cycle time, Some tasks and the order in wh...

Some tasks and the order in which they must be performed according to their assembly requirements are shown in the following table. These re to be combined into workstations to cre

Explain role of the small business administration, Analyze funding opportun...

Analyze funding opportunities for small businesses, including the role of the Small Business Administration (SBA). Then, evaluate the effectiveness of these funding opportunities i

Define financial institutions in the recent financial crisis, Consider whet...

Consider whether the implementation of the Sarbanes-Oxley Act supports ethical behaviour. Specifically, address Title 3 of SOX and whether you think SOX worked for financial instit

Discuss characteristics of a successful entrepreneur, Analyze the character...

Analyze the characteristics of a successful entrepreneur and determine if you have what it takes to start your own business. Provide specific examples to support your response.

Different approaches to innovation discussed organizations, Analyze the dif...

Analyze the different approaches to innovation discussed in this chapter to determine which approach you think would be the greatest value to the greatest number of organizations.

Explain hierarchy of managers, 1. What are the common characteristics of al...

1. What are the common characteristics of all companies? Can a manager have operation responsibilities? Explain. What are three characteristics that a manager must have to be succe

Explain what should the pay structure look like, What should the pay struct...

What should the pay structure look like? What pay mix would you recommend? 5. How should Nathan communicate a new compensation strategy to his franchisee owners and managers? 6. Wh

Define the term productivity, Define the term productivity (a) Product...

Define the term productivity (a) Productivity implies more number of goods (output) from the same amount resources (input)  (b) Management can play an important role in pro

Explain what is customer relationship management, What is Customer Relation...

What is Customer Relationship Management - CRM? Describe the four-step framework for one-to-one marketing that can be adapted to CRM marketing? Provide at least one or two examples

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