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 monthly penalty is the company incurring, A food processor use...

A food processor uses approximately 29,730 glass jars a month for its fruit juice product. Because of storage limitations, a lot size of 4,000 jars has been used. Monthly holding c

What are advantage regarding problem-solving, Cultural diversity can provid...

Cultural diversity can provide a company competitive advantage regarding problem-solving. True False

Find annual sales is thousands of bottles, Problem 3-5 A cosmetics manufact...

Problem 3-5 A cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream. Ft = 80

Service sector - financial services, Service Sector - Financial Services ...

Service Sector - Financial Services 1. Explosion of customer choice  2. Globalisation of financial services - extensive use of computer technology  3. Innovation on bot

Supply chain management, explain the extend to which SCM is applicable to a...

explain the extend to which SCM is applicable to a service operation like Cruise int.

Explain why do some people gravitate toward management jobs, Why do some pe...

Why do some people gravitate toward management jobs as opposed to technical, labour jobs etc.?

Explain differentiate between validity and reliability, Differentiate betwe...

Differentiate between validity and reliability of a selection test. In other words, provide definitions of (1) validity and (2) reliability of a test.

Facility layout - process design, Facility Layout - Process Design In ...

Facility Layout - Process Design In addition to the sequence of the processes, consideration must also be given to their physical layout in relation to each other. This is an

Describe when stakeholder identification occurs, Explain when stakeholder i...

Explain when stakeholder identification occurs and explain the importance of stakeholder analysis

Explain what do you think are the most important forces, What do you think ...

What do you think are the most important forces in the external environment creating uncertainty for organizations today? Do the forces you identified typically arise in the task e

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