a. In cell I21, create a formula that quantifies the portion of the overall sales volume 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 I21?

b. In cell I22, create a formula that quantifies the portion of the overall sales volume 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 I22?

c. Create IF-THEN statements in cells J21 and J22 that properly label your variances in cells I21 and I22 as favorable (F) or unfavorable (U).
a. In cell I21, the formula to quantify the portion of the overall sales volume variance caused solely by the change in number of productions is: =((Actual Productions - Planned Productions) * Sales Price per Unit)
The amount in cell I21 is the result of the formula calculation.
b. In cell I22, the formula to quantify the portion of the overall sales volume variance caused solely by the change in number of performances is: =((Actual Performances - Planned Performances) * Sales Price per Unit)
The amount in cell I22 is the result of the formula calculation.
c. Create an IF-THEN statement in cell J21 to label the variance in cell I21 as favorable (F) if the actual productions are higher than planned, and as unfavorable (U) if the actual productions are lower than planned.
d. Create an IF-THEN statement in cell J22 to label the variance in cell I22 as favorable (F) if the actual performances are higher than planned, and as unfavorable (U) if the actual performances are lower than planned.