Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 Using Conditional Formatting, highlight all spending variances that varied by an absolute value of $1,000 or more. How many of the spending variances are highlighted? Number of spending variances highlighted Number of productions (q1) Number of performances(q) The Munchkin Theater Flexible Budget Performance Report For the Year Ended December 31 Cost Formulas Actual Results Spending Flexible Variances Budget Activity Variances Planning Budget 4 FOR U 4 5 64 64 60 Per Production Per Performance Fixed Actors' and directors' wages $ 2,400 $ 159,200 $ 5,600 $ 153,600 $ 9,600 $ 144,000 $ 5,600 Stagehands' wages $ 450 $ 28,600 $ 200 $ 28,800 $ 1,800 $ 27,000 $ (200) Ticket booth personnel and ushers' wages $ 180 $ 12,300 $ 780 $ 11,520 $ 720 $ 10,800 $ 780 Scenery, costumes, and props $ 8,600 $ 39,300 $ 4,900 $ 34,400 $ 8,600 $ 43,000 $ 4,900 Theater hall rent $ 750 $ 49,600 $ 1,600 $ 48,000 $ 3,000 $ 45,000 $ 1,600 Printed programs $ 175 $ 10,950 $ 250 $ 11,200 $ 700 $ 10,500 $ (250) Publicity $ 2,600 $ Administrative expenses $ 1,296 $ Total $ 12,496 $ 72 $ 4,027 $ 32,400 $ 12,000 $ 41,650 $ 542 32,400 $ 353,600 $13,488 1,600 $ 10,400 $ 2,600 $ 13,000 $ 1,600 $ $ 340,112 $ 42,192 $ 1,008 3,612 $ 43,200 $ (542) $ 336,500 $ 13,488 Activity Variances: By Cost Driver Portion due to number of productions Portion due to number of performances $ 17,100