both questions please

Use the table below to create a nonlinear model based on the table to answer the following question(s). The Atlas Movies Theater is planning to reprice their ticket rates to maximize revenues. They have three classes of tickets: Classic, Silver, and Gold. The table below provides information on the average ticket sales, revenue and price elasticity on demand. They have a total seating capacity of 300. The table also provides the price range within which they plan to reduce their ticket rates. Atlas Movie Theater Ticketing Ticket Class Current Rate Average Daily Sold Elasticity Price Range 150 Classic Silver Gold 8.45 13.25 17.5 80 -1.3 -2.25 -1.1 6.5 11.5 15.5 7.5 12.5 16.5 30 Total Capacity 300 According to the nonlinear model, which of the following is the projected sales figure for Classic tickets at the new price? 175 0 178 172 181 13 15 Use the table below to answer the following question(s) by invoking the binary constraints on the variables using the standard Solver. Below is the spreadsheet for a project selection model: B Project Selection Model B Data 4 Project 1 Project 2 Project 3 Project 4 Project 5 Available Resources $160,000 $250,000 $175,000 $150,000 $225,000 $45,000 $70,000 $28,000 $52,000 $55,000 $175,000 4 11 Expected Return b NPV) Cash requirements Personnel 2 requirements B Model 110 Project selection 111 decisions 12 Cash Used 13 Personnel Used 14 Return What is the amount of personnel used for Project 22 11 6 13