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

How many cells must be used to represent each constraint, In excel how many...

In excel how many cells should be used to represent each constraint?

System classification beneficial for operations managers, 1. Referring to t...

1. Referring to the figure, in which category would you place: a chemist shop; Burger King; Direct Line Insurance; Cable Vision; Motorola; a chiropodist; QVC television; Smith-Klin

Operation strategy for globaltel in Asia, write a list of elements that sho...

write a list of elements that should be included in an operations strategy for global tel

Describe how to create a work breakdown structure, Final Paper The final si...

Final Paper The final six to eight page paper must demonstrate understanding of new learning in the field of project management. It is mandatory to have research from the classroom

Explain constant need of trained employees, (EOQ model) Division X is growi...

(EOQ model) Division X is growing and is in constant need of trained employees. The demand rate for trained employees is relatively constant at 5 each month. The division can run a

Operations management, Operations Management refers to those activities whi...

Operations Management refers to those activities which are more or less directly concerned with the creation and delivery of goods and services. The course is intended to give you

Explain use the marketing research, CASE STUDY Jerry Smith is thinking abou...

CASE STUDY Jerry Smith is thinking about opening a bicycle shop in his hometown. Jerry loves to take his own bike on 50-mile trips with his friends, but he believes that any small

Explain what is the negative impact on that stakeholder, Which stakeholders...

Which stakeholders that was affected by the bp spill situation in America. What is the negative impact on that stakeholder?

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