QUESTION 1: Graphical Method & Excel Solver Solutions (36 points) An Architect wishes to design the safety deposit room for a bank safe. He plans to place safety deposit boxes approximately 6 feet high by the approximate length of the room's walls, 40 feet (i.e., 240 square feet total space available). The bank has asked him to plan for two sizes of box: large and small. Large boxes consume 1 square foot and will rent for $90 per year. Small boxes consume 0.6 square feet and will rent for $60 per year. The bank has asked for at least 80 large boxes and at least 120 small boxes. The bank hopes to maximize its revenue from safety deposit boxes. A correct formulation for this problem is provided below: Let L and S denote the number of units of large and small boxes that the architect's design will provide MAX Z = 90L + 60S ($) subject to, 1) Available Space L + 0.68