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 $159,200 28,600 12,300 UULILIL Required information 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,wee 41,650 $353,600 Click here to download the Excel template that you will use to create the Planning Budget and Flexible Budget Performance Report. Once you complete the Planning Budget and Flexible Budget Performance Report, refer to your work to answer the forthcoming questions. You will upload your final file in Part 2 Click here for a brief tutorial on IF Statements in Excel. Click here for a brief tutorial on Conditional Formatting in Excel. Required: 1. Go to the "Planning Budget" tab within your template. Prepare the planning budget in column E of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell E10. Make sure your formula is designed so that you can copy and paste it into cells E11 through E17. What is the total amount of actors' and directors' wages in your planning budget? b. Copy your formula from cell E10 into cells E11 through E17. What is the total amount of administrative expenses in your planning budget (cell E17)? . I len the listnim faaturn to calculate the total amount of avnanenc in vnur nlanninn hurlant Iroll C101 What is the total amount? 3 Required information of 2 Required: 1. Go to the "Planning Budget" tab within your template. Prepare the planning budget in column E of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell E10. Make sure your formula is designed so that you can copy and paste it into cells E11 through E17. What is the total amount of actors' and directors' wages in your planning budget? b. Copy your formula from cell E10 into cells E11 through E17. What is the total amount of administrative expenses in your planning budget (cell E17)? c. Use the AutoSum feature to calculate the total amount of expenses in your planning budget (cell E18). What is the total amount? 2. Go to the "Performance Report" tab within the Excel template for the remainder of the requirements. Prepare a flexible budget in column H of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell H10. Make sure your formula is designed so that you can copy and paste it into cells H11 through H17. What is the total amount of actors' and directors' wages in your flexible budget? b. Copy your formula from cell H10 into cells H11 through H17. What is the total amount of administrative expenses in your flexible budget (cell H17)? c. Use the AutoSum feature to calculate the total amount of expenses in your flexible budget (cell H18). What is this total amount? :31:16 ped at 3. Calculate the amount of the spending variances in column Fusing the following five-step process (Do not worry about labeling the variances as U or Fat this point): 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. nces 4. Insert a favorable (F) or unfavorable (U) label in column G for each spending variance shown in column F using the following two- step process: a. Create an IF-THEN statement in cell G10 that properly labels the actors' and directors' wages spending variance 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 variance, For U? b. Copy your IF-THEN statement from cell G10 into cells G11 through G18. What label appears for the administrative expense Check my w variance Forur 3 Required information f 2 5. Calculate the amount of the activity variances in column I using the following five-step process (Do not worry about labeling the variances as U or Fat this point): a. Create a formula for the actors' and directors' wages activity variance in cell N10. What is the amount of the activity variance for actors' and directors' wages? b. Copy your formula from cell N10 into cells N11 through N17. What is the amount of the activity variance for administrative expenses (cell N17)? c. Use the AutoSum feature to calculate the total activity variance in cell N18. What is the total activity variance? d. Using the Absolute Value function, input the absolute values of the amounts in cells N10 through N18 into cells 110 through 118. e. Hide column N. 30:46 wed 6. Insert a favorable (F) or unfavorable (U) label in column J for each activity variance shown in column I using the following two-step process: a. Create an IF-THEN statement in cell J10 that properly labels the actors' and directors' wages activity variance as favorable or unfavorable. (Hint: Your If-Then statement should be focused on the amounts in cells K10 and H10.) What label appears for this variance, For U? b. Copy your IF-THEN statement from cell J10 into cells J11 through J18. What label appears for the administrative expense activity variance. For U? k It ] nces 7. 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 in 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 J21 and J22 that properly label your variances in cells 121 and 122 as favorable (F) or unfavorable (U). 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? B Required information Complete this question by entering your answers in the tabs below. f2 Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 30:21 Go to the "Planning Budget" tab within your template. Prepare the planning budget in column E of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell E10. Make sure your formula is designed so that you can copy and paste it into cells E11 through E17. What is the total amount of actors' and directors' wages in your planning budget? b. Copy your formula from cell E10 into cells E11 through E17. What is the total amount of administrative expenses in your planning budget (cell E17)? C. Use the AutoSum feature to calculate the total amount of expenses in your planning budget (cell E18). What is the total amount? ed Show less ok 1-a. 1-b. Total amount of actors' and directors' wages Total amount of administrative expenses Total amount of expenses t 1-c. 1 nces ! Required information Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 Go to the "Performance Report tab within the Excel template for the remainder of the requirements. Prepare a flexible budget in column H of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell H10. Make sure your formula is designed so that you can copy and paste it into cells H11 through H17. What is the total amount of actors' and directors' wages in your flexible budget? b. Copy your formula from cell H10 into cells H11 through H17. What is the total amount of administrative expenses in your flexible budget (cell H17)? c. Use the AutoSum feature to calculate the total amount of expenses in your flexible budget (cell H18). What is this total amount? Show less 2-a. Total amount of actors' and directors' wages 2-b. Total amount of administrative expenses Total amount of all expenses 2-c. Required information Complete this question by entering your answers in the tabs below. -f 2 Reg 1 Reg 2 Reg 3 Req 4 Req 5 Reg 6 Req 7 Req 8 29:30 ped Calculate the amount of the spending variances in column F using the following five-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. Show less . 3-a. ht 3-b. Amount of the spending variance for actors' and directors' wages Amount of the spending variance for administrative expenses Total spending variance | 3-c. ] nces 13 Required information Complete this question by entering your answers in the tabs below. Part 1 of 2 Req 1 Reg 2 Reg 3 Req 4 Req 5 Req 6 Req 7 Req 8 20 points 8 02:29:06 Insert a favorable (F) or unfavorable (U) label in column G for each spending variance shown in column Fusing the following two-step process: a. Create an IF-THEN statement in cell G10 that properly labels the actors' and directors' wages spending variance 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, F or U? b. Copy your IF-THEN statement from cell G10 into cells G11 through G18. What label appears for the administrative expense spending variance, For U? Skipped Show less eBook 4-a. 4-b. What label appears for this variance, For U? What label appears for the administrative expense spending variance, For U? Print References 13 ! Required information Complete this question by entering your answers in the tabs below. - 1 of 2 Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 S 02:28:35 kipped Calculate the amount of the activity variances in column I using the following five-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 activity variance in cell N10. What is the amount of the activity variance for actors' and directors' wages? b. Copy your formula from cell N10 into cells N11 through N17. What is the amount of the activity variance for administrative expenses (cell N17)? c. Use the AutoSum feature to calculate the total activity variance in cell N18. What is the total activity variance? d. Using the Absolute Value function, input the absolute values of the amounts in cells N10 through N18 into cells 110 through 118. e. Hide column N. eBook Show less 5-a. Print 5-b. Amount of the activity variance for actors' and directors' wages Amount of the activity variance for administrative expenses Total activity variance 5-c. Ferences Required information Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 Insert a favorable (F) or unfavorable (U) label in column J for each activity variance shown in column I using the following two-step process: a. Create an IF-THEN statement in cell J10 that properly labels the actors' and directors' wages activity variance as favorable or unfavorable. (Hint: Your If-Then statement should be focused on the amounts in cells K10 and H10.) What label appears for this variance, F or U? b. Copy your IF-THEN statement from cell J10 into cells J11 through J18. What label appears for the administrative expense activity variance, F or U? Show less A 6-a. What label appears for this variance, F or U? What label appears for the administrative expense activity variance, F or U? 6-b. Required information Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Reg 8 3 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 in 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 J21 and 122 that properly label your variances in cells 121 and 122 as favorable (F) or unfavorable (U). Show less A 7-a. The portion of the overall activity variance due to productions The portion of the overall activity variance due to performances 7-b. Check in Tlcina Conditional Lormattina biahliaht allenandina variancac that variod hu anhcoluto value of (1000 or more Dow manat the ! Required information Complete this question by entering your answers in the tabs below. -f2 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? 27:13 Number of spending variances highlighted ped ok nt Required information 1 of 2 s 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.) 02:26:43 Eipped ? Actors' and directors' wages Book ? Stagehands' wages ? Ticket booth personnel and ushers' wages Print ? Scenery, costumes, and props O erences ? Theater hall rent ? Printed programs ? Publicity ? Administrative expenses CP 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 $159,200 28,600 12,300 UULILIL Required information 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,wee 41,650 $353,600 Click here to download the Excel template that you will use to create the Planning Budget and Flexible Budget Performance Report. Once you complete the Planning Budget and Flexible Budget Performance Report, refer to your work to answer the forthcoming questions. You will upload your final file in Part 2 Click here for a brief tutorial on IF Statements in Excel. Click here for a brief tutorial on Conditional Formatting in Excel. Required: 1. Go to the "Planning Budget" tab within your template. Prepare the planning budget in column E of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell E10. Make sure your formula is designed so that you can copy and paste it into cells E11 through E17. What is the total amount of actors' and directors' wages in your planning budget? b. Copy your formula from cell E10 into cells E11 through E17. What is the total amount of administrative expenses in your planning budget (cell E17)? . I len the listnim faaturn to calculate the total amount of avnanenc in vnur nlanninn hurlant Iroll C101 What is the total amount? 3 Required information of 2 Required: 1. Go to the "Planning Budget" tab within your template. Prepare the planning budget in column E of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell E10. Make sure your formula is designed so that you can copy and paste it into cells E11 through E17. What is the total amount of actors' and directors' wages in your planning budget? b. Copy your formula from cell E10 into cells E11 through E17. What is the total amount of administrative expenses in your planning budget (cell E17)? c. Use the AutoSum feature to calculate the total amount of expenses in your planning budget (cell E18). What is the total amount? 2. Go to the "Performance Report" tab within the Excel template for the remainder of the requirements. Prepare a flexible budget in column H of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell H10. Make sure your formula is designed so that you can copy and paste it into cells H11 through H17. What is the total amount of actors' and directors' wages in your flexible budget? b. Copy your formula from cell H10 into cells H11 through H17. What is the total amount of administrative expenses in your flexible budget (cell H17)? c. Use the AutoSum feature to calculate the total amount of expenses in your flexible budget (cell H18). What is this total amount? :31:16 ped at 3. Calculate the amount of the spending variances in column Fusing the following five-step process (Do not worry about labeling the variances as U or Fat this point): 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. nces 4. Insert a favorable (F) or unfavorable (U) label in column G for each spending variance shown in column F using the following two- step process: a. Create an IF-THEN statement in cell G10 that properly labels the actors' and directors' wages spending variance 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 variance, For U? b. Copy your IF-THEN statement from cell G10 into cells G11 through G18. What label appears for the administrative expense Check my w variance Forur 3 Required information f 2 5. Calculate the amount of the activity variances in column I using the following five-step process (Do not worry about labeling the variances as U or Fat this point): a. Create a formula for the actors' and directors' wages activity variance in cell N10. What is the amount of the activity variance for actors' and directors' wages? b. Copy your formula from cell N10 into cells N11 through N17. What is the amount of the activity variance for administrative expenses (cell N17)? c. Use the AutoSum feature to calculate the total activity variance in cell N18. What is the total activity variance? d. Using the Absolute Value function, input the absolute values of the amounts in cells N10 through N18 into cells 110 through 118. e. Hide column N. 30:46 wed 6. Insert a favorable (F) or unfavorable (U) label in column J for each activity variance shown in column I using the following two-step process: a. Create an IF-THEN statement in cell J10 that properly labels the actors' and directors' wages activity variance as favorable or unfavorable. (Hint: Your If-Then statement should be focused on the amounts in cells K10 and H10.) What label appears for this variance, For U? b. Copy your IF-THEN statement from cell J10 into cells J11 through J18. What label appears for the administrative expense activity variance. For U? k It ] nces 7. 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 in 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 J21 and J22 that properly label your variances in cells 121 and 122 as favorable (F) or unfavorable (U). 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? B Required information Complete this question by entering your answers in the tabs below. f2 Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 30:21 Go to the "Planning Budget" tab within your template. Prepare the planning budget in column E of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell E10. Make sure your formula is designed so that you can copy and paste it into cells E11 through E17. What is the total amount of actors' and directors' wages in your planning budget? b. Copy your formula from cell E10 into cells E11 through E17. What is the total amount of administrative expenses in your planning budget (cell E17)? C. Use the AutoSum feature to calculate the total amount of expenses in your planning budget (cell E18). What is the total amount? ed Show less ok 1-a. 1-b. Total amount of actors' and directors' wages Total amount of administrative expenses Total amount of expenses t 1-c. 1 nces ! Required information Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 Go to the "Performance Report tab within the Excel template for the remainder of the requirements. Prepare a flexible budget in column H of the spreadsheet using the following three-step process. a. Create a formula for actors' and directors' wages in cell H10. Make sure your formula is designed so that you can copy and paste it into cells H11 through H17. What is the total amount of actors' and directors' wages in your flexible budget? b. Copy your formula from cell H10 into cells H11 through H17. What is the total amount of administrative expenses in your flexible budget (cell H17)? c. Use the AutoSum feature to calculate the total amount of expenses in your flexible budget (cell H18). What is this total amount? Show less 2-a. Total amount of actors' and directors' wages 2-b. Total amount of administrative expenses Total amount of all expenses 2-c. Required information Complete this question by entering your answers in the tabs below. -f 2 Reg 1 Reg 2 Reg 3 Req 4 Req 5 Reg 6 Req 7 Req 8 29:30 ped Calculate the amount of the spending variances in column F using the following five-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. Show less . 3-a. ht 3-b. Amount of the spending variance for actors' and directors' wages Amount of the spending variance for administrative expenses Total spending variance | 3-c. ] nces 13 Required information Complete this question by entering your answers in the tabs below. Part 1 of 2 Req 1 Reg 2 Reg 3 Req 4 Req 5 Req 6 Req 7 Req 8 20 points 8 02:29:06 Insert a favorable (F) or unfavorable (U) label in column G for each spending variance shown in column Fusing the following two-step process: a. Create an IF-THEN statement in cell G10 that properly labels the actors' and directors' wages spending variance 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, F or U? b. Copy your IF-THEN statement from cell G10 into cells G11 through G18. What label appears for the administrative expense spending variance, For U? Skipped Show less eBook 4-a. 4-b. What label appears for this variance, For U? What label appears for the administrative expense spending variance, For U? Print References 13 ! Required information Complete this question by entering your answers in the tabs below. - 1 of 2 Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 S 02:28:35 kipped Calculate the amount of the activity variances in column I using the following five-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 activity variance in cell N10. What is the amount of the activity variance for actors' and directors' wages? b. Copy your formula from cell N10 into cells N11 through N17. What is the amount of the activity variance for administrative expenses (cell N17)? c. Use the AutoSum feature to calculate the total activity variance in cell N18. What is the total activity variance? d. Using the Absolute Value function, input the absolute values of the amounts in cells N10 through N18 into cells 110 through 118. e. Hide column N. eBook Show less 5-a. Print 5-b. Amount of the activity variance for actors' and directors' wages Amount of the activity variance for administrative expenses Total activity variance 5-c. Ferences Required information Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Req 8 Insert a favorable (F) or unfavorable (U) label in column J for each activity variance shown in column I using the following two-step process: a. Create an IF-THEN statement in cell J10 that properly labels the actors' and directors' wages activity variance as favorable or unfavorable. (Hint: Your If-Then statement should be focused on the amounts in cells K10 and H10.) What label appears for this variance, F or U? b. Copy your IF-THEN statement from cell J10 into cells J11 through J18. What label appears for the administrative expense activity variance, F or U? Show less A 6-a. What label appears for this variance, F or U? What label appears for the administrative expense activity variance, F or U? 6-b. Required information Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Req 5 Req 6 Req 7 Reg 8 3 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 in 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 J21 and 122 that properly label your variances in cells 121 and 122 as favorable (F) or unfavorable (U). Show less A 7-a. The portion of the overall activity variance due to productions The portion of the overall activity variance due to performances 7-b. Check in Tlcina Conditional Lormattina biahliaht allenandina variancac that variod hu anhcoluto value of (1000 or more Dow manat the ! Required information Complete this question by entering your answers in the tabs below. -f2 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? 27:13 Number of spending variances highlighted ped ok nt Required information 1 of 2 s 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.) 02:26:43 Eipped ? Actors' and directors' wages Book ? Stagehands' wages ? Ticket booth personnel and ushers' wages Print ? Scenery, costumes, and props O erences ? Theater hall rent ? Printed programs ? Publicity ? Administrative expenses CP