I need the answers and the formulas for these problems. I posted the excel I already did above. Please help!

! Required Information [The following information applies to the questions displayed below. The Munchkin Theater is a nonprofit organization devoted to staging plays for children. The theater has a very small full- time professional administrative staff. Through a special arrangement with the actors' union, actors and directors rehearse without pay and are paid only for actual 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 Actors and directors' wages Stagehands' wages Ticket booth personnel and ushers' wages Scenery, costumes, and props Theater hall rent Printed programs Publicity Administrative expenses Cost Formulas Per Per Production Performance $2,400 $ 450 $ 180 $8,600 $ 750 $ 175 $2,600 $1,296 $ 72 $32,400 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 Click here to download the Fyceltemnlate that you will use to create the plannina Budoet and Fleyible Budet AutoSave CH AS Quynh Nguyen QN Ga ExcelAnalytics_FlexibleBudgetPerformanceAnalysis_Template - Excel View Help Search File Home Insert Page Layout Formulas Data Review Share Comments X Calibri 11 A A 3 ab. Wrap Text Custom TIX 47 Paste BIU . Insert Delete Format Ideas ve Merge & Center Conditional Format as Cell Formatting Table Styles Styles Sort & Find & & Filter Select Clipboard Font Alignment Number Cells Editing Ideas 121 f A B D E F G H K L M N O R 1 Actual Results Spending Variances Flexible Budget Activity Variances Planning Budget 5 60 1 5 6 Number of productions (9.) 7 Number of performances(quz) 8 4 61 61 10 Actors' and directors' wages 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 18 Total 19 20 21 27 Cost Formulas Per Per Production Performance S 2,400 S 450 S 180 $ 8,600 S 750 S 175 S 2,600 $ 1,296 $ 72 $ $ 12.496 $ 4,027 $ Fixed $ 159,200 $ 5,600 US 153,600 $ $ s 28,600 $ 200 FS 28,800 $ $ $ 12,300 $ 780 US 11,520 S S 39,300 $ 4,900 US 34,400 S S 49.600 $ 1,600 US 48,000 $ $ 10,950 $ 250 F FS 11,200 $ $ 12,000 $ 1,600 US 10,400 $ 32,400 $ 41,650 $ 542 FS 42,192 $ 32.400 $ 353,600 $ 13,488 v 340,112 $ 9,600 US 144.000 1,800 US 27,000 720 US 10,800 8,600 ES 43,000 3,000 US US 45,000 700 US 10,500 2,600 F $ 13,000 1,008 F $ 43,200 3,612 U$ 336,500 Activity Variances: By Cost Driver Portion due to number of productions Portion due to number of performances 23 24 25 ... Conditional Formatting EA 9-1, Planning Budget Performance Report Ready LEI + 100% Required information Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req3 Req 4 Req 5 Req 6 Req 7 Req 8 The activity variances in column I are influenced by two cost drivers-number of productions and number of performances. Therefore: a. In cell 121 create a formula that quantifies the portion of the overall activity variance that is caused solely by the fact that The Munchkin Theatre actually put on four productions instead of the planned number of five productions. What is the amount Ein cell 121? b. In cell 122 create a formula that quantifies the portion of the overall activity variance that is caused solely by the fact that The Munchkin Theatre actually put on 64 performances instead of the planned number of 60 performances. What is the amount in cell 122? C. Create IF-THEN statements in cells 221 and 322 that properly label your variances in cells 121 and 122 as favorable (6) or unfavorable (U). Show less 7-a. The portion of the overall activity variance due to productions The portion of the overall activity variance due to performances 7-b. 9. Using Conditional Formatting, highlight all spending variances that vary from the flexible budget by an absolute value of 5% or more. (Hint: Within the conditional formatting drop down menu look for the appropriate formula in the More rules" section. Also, make sure your formula does not include any absolute references.) Which spending variances deviate from the flexible budget by at least 5%? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) ? Actors' and directors' wages ? Stagehands' wages ? Ticket booth personnel and ushers' wages 1 Scenery, costumes, and props ? Theater hall rent ? Printed programs ? Publicity ? Administrative expenses ! Required Information [The following information applies to the questions displayed below. The Munchkin Theater is a nonprofit organization devoted to staging plays for children. The theater has a very small full- time professional administrative staff. Through a special arrangement with the actors' union, actors and directors rehearse without pay and are paid only for actual 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 Actors and directors' wages Stagehands' wages Ticket booth personnel and ushers' wages Scenery, costumes, and props Theater hall rent Printed programs Publicity Administrative expenses Cost Formulas Per Per Production Performance $2,400 $ 450 $ 180 $8,600 $ 750 $ 175 $2,600 $1,296 $ 72 $32,400 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 Click here to download the Fyceltemnlate that you will use to create the plannina Budoet and Fleyible Budet AutoSave CH AS Quynh Nguyen QN Ga ExcelAnalytics_FlexibleBudgetPerformanceAnalysis_Template - Excel View Help Search File Home Insert Page Layout Formulas Data Review Share Comments X Calibri 11 A A 3 ab. Wrap Text Custom TIX 47 Paste BIU . Insert Delete Format Ideas ve Merge & Center Conditional Format as Cell Formatting Table Styles Styles Sort & Find & & Filter Select Clipboard Font Alignment Number Cells Editing Ideas 121 f A B D E F G H K L M N O R 1 Actual Results Spending Variances Flexible Budget Activity Variances Planning Budget 5 60 1 5 6 Number of productions (9.) 7 Number of performances(quz) 8 4 61 61 10 Actors' and directors' wages 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 18 Total 19 20 21 27 Cost Formulas Per Per Production Performance S 2,400 S 450 S 180 $ 8,600 S 750 S 175 S 2,600 $ 1,296 $ 72 $ $ 12.496 $ 4,027 $ Fixed $ 159,200 $ 5,600 US 153,600 $ $ s 28,600 $ 200 FS 28,800 $ $ $ 12,300 $ 780 US 11,520 S S 39,300 $ 4,900 US 34,400 S S 49.600 $ 1,600 US 48,000 $ $ 10,950 $ 250 F FS 11,200 $ $ 12,000 $ 1,600 US 10,400 $ 32,400 $ 41,650 $ 542 FS 42,192 $ 32.400 $ 353,600 $ 13,488 v 340,112 $ 9,600 US 144.000 1,800 US 27,000 720 US 10,800 8,600 ES 43,000 3,000 US US 45,000 700 US 10,500 2,600 F $ 13,000 1,008 F $ 43,200 3,612 U$ 336,500 Activity Variances: By Cost Driver Portion due to number of productions Portion due to number of performances 23 24 25 ... Conditional Formatting EA 9-1, Planning Budget Performance Report Ready LEI + 100% Required information Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req3 Req 4 Req 5 Req 6 Req 7 Req 8 The activity variances in column I are influenced by two cost drivers-number of productions and number of performances. Therefore: a. In cell 121 create a formula that quantifies the portion of the overall activity variance that is caused solely by the fact that The Munchkin Theatre actually put on four productions instead of the planned number of five productions. What is the amount Ein cell 121? b. In cell 122 create a formula that quantifies the portion of the overall activity variance that is caused solely by the fact that The Munchkin Theatre actually put on 64 performances instead of the planned number of 60 performances. What is the amount in cell 122? C. Create IF-THEN statements in cells 221 and 322 that properly label your variances in cells 121 and 122 as favorable (6) or unfavorable (U). Show less 7-a. The portion of the overall activity variance due to productions The portion of the overall activity variance due to performances 7-b. 9. Using Conditional Formatting, highlight all spending variances that vary from the flexible budget by an absolute value of 5% or more. (Hint: Within the conditional formatting drop down menu look for the appropriate formula in the More rules" section. Also, make sure your formula does not include any absolute references.) Which spending variances deviate from the flexible budget by at least 5%? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) ? Actors' and directors' wages ? Stagehands' wages ? Ticket booth personnel and ushers' wages 1 Scenery, costumes, and props ? Theater hall rent ? Printed programs ? Publicity ? Administrative expenses