Funberry Amusements is an owner/operator of several amusement parks. Following is a performance report that a Funberry manager built in Excel.

Using the performance report shown, answer the following questions.

1. What formula would be entered in Cell D3 to calculate the difference between the ACTUAL total in Cell B3 and the BUDGET total in Cell C3?
2. How would the formula in Question 1 be modified to make the result in Cell D3 an absolute value?
3. What steps would be performed in Cell E3 to display an “F” if the variance in Cell D3 is favorable and a “U” if the variance is unfavorable?
4. How could the contents of Cells D3 and E3 be copied to the remaining rows containing revenues?
5. How would the steps for calculating the “F” or “U” for expenses differ from the steps for “F” or “U” for revenues?
6. Specify the formula that would be entered in each of the following cells:

a. Cell B9 to calculate ACTUAL total sales revenue
b. Cell C9 to calculate BUDGET total sales revenue
c. Cell D9 to calculate VARIANCE for total sales revenue
d. Cell B23 to calculate ACTUAL operating income
e. Cell C23 to calculate BUDGET operating incomes
f. Cell D23 to calculate the VARIANCE for operating income

7. What steps would be performed in cell E23 to display an “F” if the variance in cell D23 is favorable and a “U” if the variance is unfavorable?

Transcribed Image Text:

1 2 Sales Revenue: Admissions 4 Food service 5 Merchandise Games Parking Locker rental 6789SAWN A 3 9 Total sales revenue 10 Expenses: 11 Park employee wages B ACTUAL C BUDGET D VARIANCE $ 29,718,258 $ 29,500,000 $ 218,258 24,650,000 $ $ 24,557,256 $ 18,875,240 $ 92,744 125,240 $ 18,750,000 $ $ 8,765,848 $ 8,680,000 $ 85,848 $ 2,473,447 $ 2,510,000 $ 36,553 $ 2,013,115 $ 1,950,000 $ 63,115 $ 86,403,164 $ 86,040,000 $ 363,164 $ 10,246,522 $ 10,300,000 $ 53,478 E For U FUFFUFF F U F