Please help with both Question 3.3 and 3.4.

Textbook problem 3.4.

o Formulate the problem by hand.

o Use Excel to solve and include all reports.

o The gallery now plans to reorganize their displays and needs only 7 rooms. One room will be emptied and doesn't need surveillance. Which choice of room will result in a decrease in the total number of cameras needed? List all possibilities and explain your method.

Textbook problem 3.3.

o Formulate the problem by hand.

o Use Excel to solve and include all reports. o What is the minimum profit Store 3 needs to produce to not be shut down? Explain your method

3.3 The regional food store chain, Grocery Glant, has bought up a competing chain. The amalgamated chain now has 12 stores, some of them located very close to each other. The stores are numbered 1 to 12. Rings indicate those stores that are located too close to each other. Within each ring in the figure there must be exactly one store. Grocery Glint wants to maximise its monthly profit, which is shown In 10OD's for each store in the table below. Express this problem with an objective function with constraints and solve it using Excel's Solver. Store Profit Profit 356 7 13 215 587 412 489 10 523 5 11 118 6 198 12 213 3.4 The Markus Gallery has 8 rooms that need camera surveillance. Cameras can be installed in all doorways as shown in the figure. One camera can monitor two rooms. Find the minimum number of cameras necessary to monitor the entire gallery. - C11 C3 C6 Room 6 C9 Room 3 -CB Room B Room 1 -C4 Room S C 10 C2 Room 2 C7 C1 Room 7 Room 4 CS 40