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 are the risks and opportunities of the strategy, What are the ...

What are the risks and opportunities of the strategies followed by Pepsi? of Coca Cola?

Explain units of output per dollar of input, A hamburger factory produces 4...

A hamburger factory produces 40,000 hamburgers each week. The equipment used costs $5,000 and will remain productive for 4 years. The labor cost per year is $9,500. a. What is the

Explain how important is the compensation system, How the compensation syst...

How the compensation system influences employees motivation, productivity and satisfaction. How important is the compensation system in an employee's productivity? Are there other

Explain identify the basic control issues at unilever, Identify the basic c...

Identify the basic control issues at Unilever from all three levels? How do you think the control function should be organized and managed at Unilever?

Explain productivity in terms of management, Explain Productivity in terms ...

Explain Productivity in terms of management. Productivity may be defined as the ratio in between output and input. Output implies the amount produced or the no. of items prod

What is an e-r diagram, Conceptual Modeling looks at how the data is struct...

Conceptual Modeling looks at how the data is structured and what the characteristics of the data are. What characteristics of data are represented in an E-R diagram?

Organizational goals, outline major benefits of organizational goals and d...

outline major benefits of organizational goals and describe the situation in which have observe the benefiys

Explain process of designing a database, We are agree that the user should ...

We are agree that the user should be involved in the design of the database. Class, how would you go about the process of designing a database? What processes are involved?

Operational Management, I have a take home exam that I need to be solved 10...

I have a take home exam that I need to be solved 100 % correct , please . I need it within 23 hours EXACTLY from now please . Thank you so much and I am really looking forward to s

Explain external sales and inter-divisional transfers, A company specialisi...

A company specialising in the manufacture and sale of baths. Each bath consists of a main unit plus a set of bath fittings. The company is split into two divisions, A and B. Divisi

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