Provide answers to each problem in their corresponding worksheet. Once finished, make sure you have saved your works and they are closed, then submit your Excel file to the Canvas. Please note that your Excel file should contain all the formulas that you used to get the answer. 1. The Children's Theater Company is a nonprofit corporation managed by Shannon Board. The theater performs in two venues: Kristin Marie Hall and the Lauren Elizabeth Theater. For the upcoming season, seven shows have been chosen. The question Shannon faces is how many performances of each of the seven shows should be scheduled. A financial analysis has estimated revenues for each performance of the seven shows, and Shannon has set the minimum number of performances of each show based on union agreements with Actor's Equity Association and the popularity of the shows in other markets. These data are shown in the table at the right. Kristin Marie Hall is available for 60 performances during the season, whereas Lauren Elizabeth Theater is available for 150 performances. Shows 3 and 7 must be performed in Lauren Elizabeth Theater, and the other shows are performed in either venue. The company wants to achieve revenues of at least $550,000 while minimizing its production costs. Develop and solve a linear optimization model to determine the best way to schedule the shows. (30 points)