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: 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. What is the activity variance for revenue? Explain this variance. What is the spending variance for the cost of ingredients? Explain this variance. 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.

MANAGERIAL ACCOUNTING FOR MANAGERS EBOOK

6th Edition

ISBN: 9781264445615

Author: Noreen

Publisher: MCG

See similar textbooks

Videos

Textbook Question

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:

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.

What is the activity variance for revenue? Explain this variance.
What is the spending variance for the cost of ingredients? Explain this variance.
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.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 9, Problem 9.10Q

Chapter 9, Problem 1TF15

Students have asked these similar questions

Consider a four-year project with the following information: Initial fixed asset investment = $555,000; straight-line depreciation to zero over the four-year life; zero salvage value; price = $37; variable costs = $25; fixed costs = $230,000; quantity sold = 79,000 units; tax rate = 24 percent. How sensitive is OCF to changes in quantity sold?

Light emitting diodes (LED) light bulbs have become required in recent years, but do they make financial sense? Suppose a typical 60-watt incandescent light bulb costs $.39 and lasts 1,000 hours. A 15-watt LED, which provides the same light, costs $3.10 and lasts for 12,000 hours. A kilowatt-hour of electricity costs $.115. A kilowatt-hour is 1,000 watts for 1 hour. If you require a return of 11 percent and use a light fixture 500 hours per year, what is the equivalent annual cost of each light bulb? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.

Recently, Abercrombie & Fitch has been implementing a turnaround strategy since its sales had been falling for the past few years (11% decrease in 2014, 8% in 2015, and just 3% in 2016.) One part of Abercrombie's new strategy has been to abandon its logo-adorned merchandise, replacing it with a subtler look. Abercrombie wrote down $20.6 million of inventory, including logo-adorned merchandise, during the year ending January 30, 2016. Some of this inventory dated back to late 2013. The write-down was net of the amount it would be able to recover selling the inventory at a discount. The write-down is significant; Abercrombie's reported net income after this write-down was $35.6 million. Interestingly, Abercrombie excluded the inventory write-down from its non-GAAP income measures presented to investors; GAAP earnings were also included in the same report. Question: From an investor standpoint, do you think that the effect of the inventory write-down should be considered when…

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Solution Summary: The author explains the difference between planned and actual activity levels which represent the overall positive or negative output or performance of the company.

Videos

Want to see the full answer?

Chapter 9 Solutions