Instructions Use Excel formulas and links to cells in order to answer the following questions Using the data in the table above, create a flexible budget for the quarter Calculate the activity variances and indicate whether they are unfavorable or favorable Calculate the revenue and spending varian...

Budget Variance Activity Variance is measured as difference between Planning S ...

Instructions: Use Excel formulas and links to cells in order to answer the following questions. Using the

Fantastic news! We've Found the answer you've been seeking!

DEFGHKA?.C1 Insert formulas and cell references into the gold cells below.23Quarter Total4(April, May, June)

Instructions:

Use Excel formulas and links to cells in order to answer the following questions.

Using the data in the table above, create a flexible budget for the quarter.
Calculate the activity variances and indicate whether they are unfavorable or favorable.
Calculate the revenue and spending variances and indicate whether they are unfavorable or
favorable.
Is the Sales manager justified in stating that they did ?just fine? last quarter? Why or why not?
Is the Purchasing manager justified in bragging about the cost of materials for the quarter? Why or why not?
Hypothesize as to the possible cause(s) of each of the variances.
What should be the management team?s response to the variance analysis of the flexible budget? Which variances should be investigated further and why?