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 members of 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 have come up with the following information that is pertinent to your task: a. Basis for applying factory overhead costs to units produced = Standard machine hours. b. Budgeted fixed overhead (total) = $350,000 per 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 of finished goods = 0 units. g. Budgeted operating costs: Variable = $4.95 per unit sold; fixed = $65,000 per 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 (rounded to the nearest whole dollar) 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. Indicate in each case whether the variance is favorable (F) or unfavorable (U). 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. Round each answer to nearest whole number. 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? Round each answer to nearest whole dollar. 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 (viz., 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?