You manage a movie theater that can handle up to 8,000 patrons per week. The current demand, price, and elasticity for ticket sales, popcorn, soda, and candy are given in Figure 4.16. The theater keeps 45 percent of ticket revenues. Unit cost per ticket, popcorn sales, candy sales, and soda sales are also given. Assuming linear demand curves, how can the theater maximize profits? Demand for foods is the fraction of patrons who purchase the given food. Please should excel work, solver inputs and linear graph.

B C D E F G H N elasticity current price demand cost ticket percentage 4 keep 45% ticket 3 8 3000 0 0.45 5 popcorn 1.3 3.5 0.5 0.4 soda 1.5 3 0.6 0.6 7 candy 2.5 2.5 0.2 1 Figure 4-16: Data for Exercise 5