Income Statement Effects of Alternative Denominator Activity Levels; Spreadsheet Application
At a recent board meeting of the Grayson Manufacturing Company, several individuals in attendance expressed concern that they could not understand how the choice of an activity level for determining overhead application rates for the company could affect reported operating profits. The controller, Susanna Wu, told members of the board that, in fact, companies have some latitude in how overhead application rates are set. For example, she told the board that companies can spread budgeted fixed overhead for the period over budgeted (forecasted) activity, normal capacity, practical capacity, or even theoretical (maximum) capacity. All of this didn’t resonate well with members of the board, who basically saw the discussion as just another example of how accounting can be used to “manage income” (i.e., “cook the books”). The chair of the finance committee of the board asked Susanna to generate a concise report that would illustrate, in concrete terms, the issues involved. In turn, you have been asked to prepare this report, which will be distributed to attendees at the next meeting of the finance committee. These committee members are adept at using spreadsheets and therefore have requested that your report be distributed to them electronically.
Based on your subsequent discussions with the controller, you come up with the following information that is pertinent to your task:
a. Basis for applying overhead costs to units produced = standard machine hours.
b. Budgeted fixed overhead (total) = $350,000/year.
c. Standard number of machine hours per unit produced = 2.0.
d. Sales data: units sold = 11,500; unit selling price = $100.
e. Standard variable manufacturing cost per unit produced = $60.25.
f. Beginning inventory = $0 (0 units).
g. Budgeted operating costs: variable = $4.95/unit sold; fixed = $65,000/year.
h. Actual number of units produced during the year = 12,250.
i. Capacity levels (in machine hours): theoretical capacity = 30,000 hours; practical capacity = 27,000 hours; normal capacity = 25,000 hours; budgeted (forecasted) usage = 24,000 hours.
Required
1. Develop an Excel spreadsheet to calculate the amount of the fixed overhead production volume variance under each of the following denominator activity levels that can be used to set the fixed overhead allocation rate: (a) theoretical capacity; (b) practical capacity; (c) normal capacity; and (d) budgeted capacity usage.
2. Determine the end-of-year balance in the Finished Goods Inventory account (at standard manufacturing cost) under each of the following denominator activity levels for establishing the fixed overhead allocation rate: (a) theoretical capacity; (b) practical capacity; (c) normal capacity; and, (d) budgeted capacity usage.
3. Assume that the practice of the company at the end of the year is to close any standard cost variances to cost of goods sold (CGS). What is the amount of operating profit that would be reported for each of the following choices for defining the denominator activity level for purposes of calculating the fixed overhead allocation rate: (a) theoretical capacity; (b) practical capacity; (c) normal capacity; and, (d) budgeted capacity usage?
4. What conclusions can be drawn based on the preceding analyses you conducted? That is, what is the bottom-line information you would like to convey to members of the finance committee?
5. How do the provisions of GAAP regarding inventory costing (i.e., FASB ASC 330-10-30, previously SFAS No. 151) affect the decision as to how the fixed overhead production volume variance (also known as the idle capacity variance) is handled at the end of a period?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.