By the end of the year, The Munchkin Theater actually put on four productions and a total of 64 performances. The actual expenses incurred during the year were as follows: Click here to download the Excel template that you will use to create the Planning Budget and Flexible Budget A B C D The Munchkin Theater Planning Budget For the Year Ended December 31 Planning Budget Number of productions (q1) Number of performances (q2) 605 A B c D G H Variance Analysis For the Year Ended December 31 Actual Number of productions (q1) Number of performances (q2) \begin{tabular}{l|l} SpendingVariances & FlexibleBudget \\ \hline & 4 \\ \hline & 64 \end{tabular} Cost Formulas Per 10 Actors' and directors' wages Production Performance Fixed 11 Stagehands' wages 12 Ticket booth personnel and ushers' wages 13 Scenery, costumes, and props 14 Theater hall rent 15 Printed programs 16 Publicity 17 Administrative expenses Total 2019 Calculate the amount of the spendikg variances in column F using the following flve-step process (Do not worry about labeling the variances as U or F at this point): (Negative amount should be indicated by a minus sign.) a. Create a formula for the actors' and directors' wages spending variance in cell M10. What is the amount of the spending variance for actors' and directors' wages? b. Copy your formula from cell M10 into cells M11 through M17. What is the amount of the spending variance for administrative expenses (cell M17)? c. Use the AutoSum feature to calculate the total spending variance in cell M18. What is the total spending variance? d. Using the Absolute Value function, input the absolute values of the amounts in cells M10 through M18 into cells F10 through F18. e. Hide column M