need help with the empty column!

Check my work The Little Theatre is a nonprofit organization devoted to staging plays for children. The theater has a very small full-time professional administrative statt, Through a special arrangement with the actors' union, actors and directors rehearse without pay and are paid only for actual performances. The Little Theatre had tentatively planned to put on six different productions with a total of 108 performances. For example, one of the productions was Peter Rabbit which had a six-week run with three performances on each weekend The costs from the current year's planning budget appear below. The Little Theatre Cost from the planning Budget For the Year Ended December 31 Hudgeted number of productions Hudgeted number of performance 100 Actors and directen we $ 220,220 stagehan wa 36.720 Ticket booth personnel and inhers wages 20,520 licenery, costumes, and prope 108,240 Theater hall rent 58,320 primod DEAR 31,320 Publioty 12,240 Administrative expenses 42.520 total 0.535,200 es Some of the costs vary with the number of productions, some with the number of performances, and some are fixed and depend on neither the number of productions not the number of performances. The costs of scenery, costumes, props, and publicity vary with the number of productions. It doesn't make any difference how many times Peter Rabbit is performed, the cost of the scenery is the same Likewise, the cost of publicizing a play with posters and radio commercials is the same whether there are 10, 20, or 30 performances of the play. On the other hand, the wages of the actors, directors, stagehands, ticket booth personnel, and ushers vary with the number of performances. The greater the number of performances, the higher the wage costs will be Similarly, the costs of renting the holland printing the programs will vary with the number of performances Administrative expenses are more difficult to analyze, but the best estimate is that approximately 75% of the budgeted costs are fixed, 15% depend on the number of productions staged, and the remaining 10% depend on the number of performances neck my work After the beginning of the year, the board of directors of the theater authorized expanding the theater's program to seven productions and a total of 168 performances. Not surprisingly, actual costs were considerably higher than the costs from the planning budget. (Grants from donors and ticket sales were also correspondingly higher, but are not shown here) Data concerning the actual costs were as follows: The Little Theatre Actual Costa To the Year Ended December 31 Actual number of production Actual number of percormance 160 Actors and director wagen Stagehande wagen Seket booth personel and sheen wagen scenery, contes, and props Theater hall ront Printed program publicity Administrative expenses Total $352,600 56,300 32.900 130,00 B4,200 45,500 15,500 53.500 8.770,300 Required: 1. Prepare a flexible budget performance report for the year that shows both spending variances and activity variances. (Indicate the effect of each variance by selecting "F* for favorable. "U" for unfavorable, and "None" for no effectie, zero variance). Input all amounts as positive values.) The Little Theatre Flexible Budget Performance Report For the Year Ended December 31 Actual Flexible Results Budget Numbenturas Planning Budget Required: 1. Prepare a flexible budget performance report for the year that shows both spending variances and activity variances (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (.e., zero variance). Input all amounts es positive values.) Answer is not complete. The Little Theatre Flexible Budget Performance Report For the Year Ended December 31 Actual Flexible Results Budget 7 100 Number of productions Number of performances Planning Budget 6 108 5 S 352.000 50.300 9,880 U 320F 980 U 3342,720 57.120 31.920 $220.320 36.720 44.620 u 16.0100 Actors and directors' We Stwoshands wagon Ticket booth personnel and users Was Scenery, costumes, and props Theatre hallen Printed program Publicity Administrative expenses Total 32,900 130.000 34,200 44.500 15.500 53,500 S770,300 6,620 4,220 1,2200 2.152U 7,192 OOOOO 126.280 90.720 45.720 14.280 51.B $763,10 CCCCCCCCC 000 20,520 108,240 50,00 31.320 12,210 47,520 55.200 2,040U $ s