Please complete the following requirements for Question 5

5A. What is the amount of activity variance for actors & director wages

5B. What is the amount of activity variance for administrative expenses

5C. What is the total activity variance

5D. What Label appears for this variance F or U?

5E. What Label appears for the administrative activity variance F or U?

5F. What portion of the overall activity variance is due to productions?

5G. What portion of the overall activity variance is due to performances?

Flexible Budget Performance Report For the Year Ended December 31 Actual Results Spending Variances Flexible Budget Activity Variances Planning Budget 5 4 4 Number of productions (91) Number of performances(92) 64 64 60 Actors' and directors' wages Stagehands' wages Ticket booth personnel and ushers' wages Scenery, costumes, and props Theater hall rent Printed programs Publicity Administrative expenses Total Cost Formulas Per Per Production Performance $ 2,400 $ 450 $ 180 $ 8,600 $ 750 $ 175 $ 2,600 $ 1,296 $ 72 $ $ 12,496 $ 4,027 $ Fixed $ 159,200 $ 28,600 $ 12,300 $ 39,300 $ 49,600 $ 10,950 $ 12,000 32,400 $ 41,650 32,400 $ 353,600 $ 153,600 $ 57,400 $ 23,820 $ 73,700 $ 97,600 $ 22,150 $ 22,400 $ 42,192 $ 492,862 $ 144,000 $ 27,000 $ 10,800 $ 43,000 $ 45,000 $ 10,500 $ 13,000 $ 43,200 $ 336,500 Activity Variances: By Cost Driver Portion due to number of productions Portion due to number of performances The Munchkin Theater has asked for your help in preparing a Planning budget at the beginning of the year and evaluating actual expenses at the end of the year. The theater expects to put on five different productions with a total of 60 performances. For example, one of the productions is Peter Rabbit, which had been budgeted for five performances. After interviewing various people affiliated with the theater you have developed the following estimated cost formulas for each of the eight expenses that will be included in your Planning budget: Fixed Cost Formulas Per Per Production Performance $2,400 $ 450 $ $8,600 $ 750 $ 175 $2,600 $1,296 $ 72 Actors' and directors' wages Stagehands' wages Ticket booth personnel and ushers' wages Scenery, costumes, and props Theater hall rent Printed programs Publicity Administrative expenses 180 $32,400 a 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: Actors' and directors' wages Stagehands' wages Ticket booth personal and ushers' wages Scenery, costumes, and props Theater hall rent Printed programs Publicity Administrative expenses Total $159, 200 28,600 12,300 39,300 49,600 10,950 12,000 41,650 $353,600