3. Calculate the amount of the spending vartances in column Fusing the following five-step process (Do not worry about labeling the a. Create a formula for the actors and directors' wages spending vartance in cell Mio. What is the amount of the spending variance b. Copy your formula from cell M10 into cells Mil through 17. What is the amount of the spending variance for administrative expenses (cell M17? 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 Fio through F18, e. Hide column M Insert a favorable (F) or unfavorable (L) label in column G for each spending vartance shown in column Fusing the following two- a. Create an IF-THEN statement in cell G10 that properly labels the actors and directors' wagen spending vartance as favorable or unfavorable. (Hint: Your If. Then statement should be focused on the amounts in cells H10 and E10) What label appears for this varlance. For U? b. Copy your IF-THEN statement from cell G10 into cels G11 through G18. What label appears for the administrative expense spending Vallance. For U? 020 Flexible Budget Performance Report For the Year Ended December 31 Actual Results Spending Variances Flexible Budget Activity Variances Planning Budget 5 60 6 Number of productions() 7 Number of performances 4 64 60 Cost Formulas Per Per Production Performance 2.400 S 450 S 180 $ 8,600 $ 750 10 Actors and directors' wages 1 Stagehands' wages 12 Ticket booth personnel and users' was 11 Scenery, costumes, and props 14 Theater hallrent 15 Printed programs 16 Publicity 17 Administrative pentes 10. Total 19 - Fixed S 159,2005,600 153,60059,600 US 144,000 $28,6001S 200 S28.800 1,800 5 27,000 $ 12.300S 70 US 11.520 S 720 5 10,800 $ 39,300S 4.900.000 8,600 43,000 19,000 1,600 S 48,000S 3,000 45.000 10.950S 250 11.2005 700 10.500 S 12.000 1,600 s 10,400 2.600 5 13,000 12.400 41.650S 542 S 12.192 1008 S 40.200 12400 15.000 SM0.12 3612 16,500 125 5 5 $ 2.600 1,2365 12,496 72 1,027S 21 22 Activity Valanceslly Cost Driver Portion due to number of production Portion due to number of performances 3. Calculate the amount of the spending vartances in column Fusing the following five-step process (Do not worry about labeling the a. Create a formula for the actors and directors' wages spending vartance in cell Mio. What is the amount of the spending variance b. Copy your formula from cell M10 into cells Mil through 17. What is the amount of the spending variance for administrative expenses (cell M17? 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 Fio through F18, e. Hide column M Insert a favorable (F) or unfavorable (L) label in column G for each spending vartance shown in column Fusing the following two- a. Create an IF-THEN statement in cell G10 that properly labels the actors and directors' wagen spending vartance as favorable or unfavorable. (Hint: Your If. Then statement should be focused on the amounts in cells H10 and E10) What label appears for this varlance. For U? b. Copy your IF-THEN statement from cell G10 into cels G11 through G18. What label appears for the administrative expense spending Vallance. For U? 020 Flexible Budget Performance Report For the Year Ended December 31 Actual Results Spending Variances Flexible Budget Activity Variances Planning Budget 5 60 6 Number of productions() 7 Number of performances 4 64 60 Cost Formulas Per Per Production Performance 2.400 S 450 S 180 $ 8,600 $ 750 10 Actors and directors' wages 1 Stagehands' wages 12 Ticket booth personnel and users' was 11 Scenery, costumes, and props 14 Theater hallrent 15 Printed programs 16 Publicity 17 Administrative pentes 10. Total 19 - Fixed S 159,2005,600 153,60059,600 US 144,000 $28,6001S 200 S28.800 1,800 5 27,000 $ 12.300S 70 US 11.520 S 720 5 10,800 $ 39,300S 4.900.000 8,600 43,000 19,000 1,600 S 48,000S 3,000 45.000 10.950S 250 11.2005 700 10.500 S 12.000 1,600 s 10,400 2.600 5 13,000 12.400 41.650S 542 S 12.192 1008 S 40.200 12400 15.000 SM0.12 3612 16,500 125 5 5 $ 2.600 1,2365 12,496 72 1,027S 21 22 Activity Valanceslly Cost Driver Portion due to number of production Portion due to number of performances