solve it by excel solver

Q1. 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 Tablet (Q1.xlsx). 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 (relationship nonlinear), how can the theater maximize profits? Demand for foods is the fraction of patrons who purchase the given food. (Paste solver screen shots with all constraints) [10] B D E F G H 2. 3 elasticity current price demand cost ticket percentage 4 keep 45% ticket 8 3000 0.45 5 popcorn 3.5 0.5 0.4 6. soda 1.5 3 0.6 0.6 7 candy 2.5 2.5 0.2 1 8 3 1.3