Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show how to solve and setup in EXCEL. A worded response does not help. The Helton Fine Art Gallery is considering installing a video
Please show how to solve and setup in EXCEL. A worded response does not help.
The Helton Fine Art Gallery is considering installing a video camera security system to reduce its insurance premiums. A diagram of Helton's eight exhibition rooms is shown in the figure to the right; the openings between the rooms are numbered 1 to 13 . A security firm proposed that two-way cameras be installed at some room openings. Each camera has the ability to monitor the two rooms between which the camera is located. For example, if a camera were located at opening number 4 , rooms 1 and 4 would be covered; if a camera were located at opening 12, rooms 2 and 6 would be covered; and so on. Management decided not to locate a camera system at the entrance to the display rooms. The objective is to provide security coverage for all eight rooms using the minimum number of two-way cameras. Formulate a binary integer linear programming model that will enable Helton's management to determine the locations for the camera systems. Solve the model to determine how many two-way cameras to purchase and where they should be located. Answer the following questions in the highlighted cells below: a) How many two-way cameras are required in the optimal solution? b) In which openings are they located? c) Suppose that management wants to provide additional security coverage for room 7. Specifically, management wants room 7 to be covered by two cameras. Update your model to account for this additional coverage. What is the minimum number of two-way cameras required to meet these coverage requirements? d) For the updated model in part c), in which openings are the cameras locatedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started