Case 4 (Show your solutions in Excel and attached) You are the Promotions Head of Pixar Pixels Productions, and you were tasked to run a 1 whole operating day of the sneak preview of the movie "Guardians of the Inter-galactic". The owner of the company has chosen New York Cinema to run the screening and they would like to know the number of seats/patrons for the following: 4.1 Design capacity of the movie theater to accommodate viewers with use of the space for PWDs; and 4.2 Normal capacity at 90% seating capacity excluding the use of the provision for PWDs. Below are the details of the cinema operation and movie's running time: Cinema house operates from 10:00 a.m.-10:00 p.m. 5 hours running time per screening 15 minutes break every after screening 2 seats allotted for PWDs 990 seats available