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

Office management, how can we cover and understand the gaps in our company?...

how can we cover and understand the gaps in our company? and what is the slosh-an

Is true or not that demand for product is not a constraint, Which of the fo...

Which of the following is true? Once you complete the five steps, the process is complete. Another constraint will always appear when the original constraint is broken. De

Explain offensive strategies for blockbuster, Will new competition for Redo...

Will new competition for Redox and digital content providers force blockbuster to alter its strategy? If yes, what are the offensive strategies for blockbuster? If not, what are th

Major help Needed STAT, Doc On Call (Q12 – Q14) A company has started a ph...

Doc On Call (Q12 – Q14) A company has started a phone service that uses overseas doctors to provide emergency medical consultations. The responding doctors are based in a country

Least cost methods, At any stage if there is a tie in the minimum cost so t...

At any stage if there is a tie in the minimum cost so that two or more routes have the same least cost of transportation then conceptually either of them may be selected. However a

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.?

Synthesis method, Synthesis In many industries the work done is of...

Synthesis In many industries the work done is of a repetitive nature that is the product is produced in large number or in batches or varying sizes at irregular in

Explain skills associated with effective project manage, Determine which of...

Determine which of the eight traits or skills associated with being an effective project manager would be the most effective when managing a group of newly hired engineers. Justify

Kanban scheduling system for lean and just in time, Kanban Scheduling Syste...

Kanban Scheduling System for Lean and Just in Time The ideal lot size is one - how many can we work on at one time? - usually one. Even in batch production, only one item in t

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