Chapter 9, Problem 1AE

The Excel worksheet form on the next page is to be used to recreate the Review Problem relating to Harrald’s Fish House. The workbook, and instructions on how to complete the file, can be found in Connect.

You should proceed to the requirements below only after completing your worksheet.

Required:

1. Check your worksheet by changing the revenue in cell D4 to $16.00; the cost of ingredients in cell D5 to $6.50; and the wages and salaries in cell B6 to $10,000. The activity variance for net operating income should now be $850 U, and the spending variance for total expenses should be $410 U. If you do not get these answers, find the errors in your worksheet and correct them.
1. What is the activity variance for revenue? Explain this variance.
2. What is the spending variance for the cost of ingredients? Explain this variance.
   
   
3. Revise the data in your worksheet to reflect the results for the following year:
   
   

Using the flexible budget performance report, briefly evaluate the company’s performance for the year and indicate where attention should be focused.