3. Work on question 5 from the problems and exercises section at the end of chapter 14 of Evans. Excel file Gardner Theater is attached (20 pts). Hint: Go through the attached pdf file "Make-or-Buy decisions" and the Worked example 14.1 from Chapter 14 of the textbook. * 5. The Gardner Theater, a community playhouse, needs to determine the lowest-cost production budget for an upcoming show. Specifically, they have to determine which set pieces to construct and which, if any, set pieces to rent from another local theater at a predetermined fee. However, the organization has only two weeks to fully construct the set before the play goes into technical rehearsals. The theater has two part-time carpenters who work up to 12 hours a week, each at $10 an hour. Additionally, the theater has a part-time scenic artist who can work 15 hours per week to paint the set and props as needed at a rate of $15 per hour. The set design requires 20 flats (walls), two hanging drops with painted scenery, and three large wooden tables (props). The number of hours required for each piece for carpentry and painting is shown below: Flats, hanging drops, and props can also be rented at a cost of $75,$500, and $350 each, respectively. How many of each unit should be built by the theater and how many should be rented to minimize total costs? \begin{tabular}{|l|r|r|r|} \hline \multicolumn{2}{|c|}{A1} & \multicolumn{1}{|c|}{ A } & Gardner Theater \\ \hline & \multicolumn{2}{|c|}{ B } & \multicolumn{1}{|c|}{C} \\ \hline 1 & Gardner Theater \\ \hline 2 & & & \\ \hline 3 & Hours Required/Piece & Carpentry & Painting \\ \hline 4 & Flats & 0.5 & 2.0 \\ \hline 5 & Hanging Drops & 2.0 & 12.0 \\ \hline 6 & Props & 3.0 & 4.0 \\ \hline 7 & Hours Available & 48.0 & 30.0 \\ \hline 8 & Labor Rate/hour & $10.00 & $15.00 \\ \hline 9 & & & \\ \hline \end{tabular}