Although Richard Haney did not implement either of the suggestions Oliver Douglas made in Rainier Fastener (A & B), he did agree with Oliver's comment that it is important to find ways to improve profitability. From the basic CVP model, Haney understood that there are three fundamental ways to improve profitability - increase selling price, decrease cost, or increase volume. Rainier operates in a highly competitive market where market share is determined primarily by selling prices. It is difficult to increase selling prices without losing market share because customers shift quickly to lower cost providers. At the same time, it is difficult to increase market share by lowering price because competitors quickly match lowered prices. Therefore, to improve profitability, Haney decided to concentrate on lowering costs.
Exhibit 4 shows profit or loss by product line for 2017, where direct costs were traced to product lines and indirect costs were allocated as described in Rainier Fastener (B). Overall profit for 2017 is $95,000, an improvement from the $418,000 loss reported in 2016.
Exhibit 5 presents a flexible budget for 2017 developed by the accounting department. This budget was constructed by multiplying the actual volume of feus sold in 2017 for each of Rainier's three product lines by the cost per feu from 2016, based on the assumption that costs per feu in 2017 should be the same as the costs per feu in 2016 (as shown in Exhibit 3). The next-to-last column of Exhibit 5 shows the actual total costs for 2017 (as also shown in Exhibit 4), and the last column shows variances for each cost, where favorable variances are labelled with F and unfavorable variances with U.
Oliver Douglas and Richard Haney reviewed the actual and budgeted results in Exhibits 4 and 5. Oliver found several reasons for optimism: "First, we seem to be doing a really good job of running our operations. For many of the categories where our costs are large, such as rent, property taxes, selling expense, general administrative expense, and depreciation, our actual costs were much lower than budgeted costs, resulting in large favorable variances. Second, it looks like we have turned the corner on profitability. In 2016, we lost $418,000 but in 2017 we made $95,000 so profitability was $513,000 higher in 2017 than in 2016. Third, not only did we improve relative to last year's loss, we also did substantially better than the budget. Our actual profit of $95,000 is $576,000 better than the projected loss of $481,000 in Exhibit 5."
Richard Haney found less reason for optimism in the 2017 results. "Now that I have seen the budget and results, I realize that we made a fundamental error in the way we constructed the budget in Exhibit 5. As a result, those favorable variances do not mean what you think they mean. Second, while it is true that our profit in 2017 increased relative to 2016, we also had a substantial shift in product mix, selling more units of our more expensive alloy grade fasteners that sell for $22.93 per feu, and fewer units of common fasteners that sell for only $15.80 per feu. The way we constructed our budget suggests that with the changed product mix, we should have expected a loss of $481,000 (as shown in Exhibit 5). However, because of our fundamental error in constructing the budget, this was not a reasonable expectation. If we corrected the error in our budget construction, we would see that we should have made far more than our actual profit of $95,000."
Questions:
For each product line, sum together all the variable costs per unit shown in Exhibit 5 and then multiply the sum of the variable costs per unit by the number of units (fastener equivalent units, or feus) produced to get total variable cost for the product line. For example, combine all the variable costs per unit for common (CN) grade fasteners into a total variable cost per unit for CN and then multiply by the number of common grade feus produced to get total variable cost for CN, denoted below as VCost(CN).
The top three lines will reflect the familiar formula: Revenue-Variable Cost = Contribution Margin. Total fixed costs (totaled across all three product lines) are subtracted from CM(Total) to find net income:
Common(CN) Alloy(AG) Stainless(SS) Total
Revenue Rev(CN) Rev(AG) Rev(SS) Rev(Total)
Less: Variable Costs VCost(CN) VCost(AG) VCost(SS) VCost(Total)
Contribution Margin CM(CN) CM(AG) CM(SS) CM(Total)
Less: Fixed Costs Total Fixed
Net Income Net Income
a) show a flexible budget for 2017 using the assumptions and format above.
b) Compute variances that compare the actual totals for 2017 in Exhibits 4 or 5 to your budgeted total revenue, total variable cost, and total fixed cost. Use these variances to evaluate Oliver's conclusion "...we seem to be doing a really good job of running our operations." What do the variances relative to your corrected flexible budget imply about whether Rainier Fastener is achieving Haney's goal of lowering costs?
c) Explain Haney's conclusion that "... we should have made far more than our actual profit of $95,000."
For Direct Labor (a variable cost), how was the $14,381 budgeted amount computed? Explain the $672 unfavorable variance relative to the $14,381 budgeted amount for Direct Labor?
In this case Direct Labor varies directly with production volume. Labor is continuously adjusted to match production volume by hiring temporary workers.
The Variable cost was computed as under:
Common Alloy Grade Stainless Steel Total
(In $) (In $) (In $) (In $)
Budgeted 4125 5699 4557 14381
Actual 4389 6046 4618 15053
-------- ------- -------- --------
Variances 264 U 347 U 61 U 672 U
===== ===== ===== =====
For Rent (a fixed cost), how was the $7,335 budgeted amount computed? Explain the $235 favorable variance relative to the $7,335 budgeted amount for Rent?
In this case the details are as under:
Common Alloy Grade Stainless Steel Total
(In $) (In $) (In $) (In $)
Budgeted 2104 2907 2324 7335
Actual 2070 2852 2178 7100
-------- ------- -------- --------
Variances 34 F 55 U 146 U 235 U
===== ===== ===== =====
Exhibit 5, are the favorable variances that Oliver pointed out usually associated with fixed costs or with variable costs? Are the unfavorable variances usually associated with fixed costs or with variable costs? Do you agree with Oliver's statement that the favorable variances mean that Rainier is "... doing a really good job of running our operations."? Explain.
As per Oliver statement and if we considered in Exhibit 5, are the favorable variances with Variable cost and unfavorable variances with Fixed Cost
Provide a flexible budget for 2017 that corrects the fundamental budgeting error identified by Haney. Following the description in Exhibit 2, assume each cost is either fixed or variable with respect to volume. Compensation Insurance represents a combination of a fixed cost and a variable cost because it is 5% of Direct Labor, a variable cost, plus 5% of Indirect Labor, a fixed cost. In 2017, the amounts for each cost are expected to be the same as in 2016. That is, for each fixed cost, the expected total cost in 2017 is the same as the actual total fixed cost in 2016 and for each variable cost, the expected variable cost per unit produced is the same as the actual cost per unit in 2016.
Flexible Budget for 2017
Particulars |
Common |
Alloy |
Stainless |
Variances |
Sales |
26070 |
32652 |
24403 |
83125 |
Variable Cost |
||||
Material |
5076 |
5051 |
3705 |
13832 |
Direct Labor |
4125 |
5699 |
4557 |
14381 |
Indirect Labor |
2306 |
3185 |
2547 |
8038 |
To simplify the calculations and presentation, compute budget using the following summary format:
Although Richard Haney did not implement either of the suggestions Oliver Douglas made in Rainier Fastener...
The Haney Batting Company manufactures wood baseball bats. Haney's two primary products are a youth bat, designed for children and young teens, and an adult bat, designed for high school and college-aged players. Haney sells the bats to sporting goods stores and all sales are on account. The youth bat sells for $20; the adult bat sells for $45. Haney's highest sales volume is in the first three months of the year as retailers prepare for the spring baseball season....
haney company has provided the following budget information for the first quarter of 2018: Haney Company has provided the following budget information for the first quarter of 2018 (Click the loon to view the budget information.) Additional data related to the first quarter of 2018 for Haney Company (Click the icon to view the data.) Read the requirements Requirement 1. Prepare Haney Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018...
Paynesville Corporation manufactures and sells a preservative used in food and drug manufacturing. The company carries no inventories. The master budget calls for the company to manufacture and sell 108,000 liters at a budgeted price of $135 per liter this year. The standard direct cost sheet for one liter of the preservative follows. Direct materials Direct labor (2 pounds @ $8) (0.5 hours $32) $16 16 Variable overhead is applied based on direct labor hours. The variable overhead rate is...
Oakly Variance Case manufactures a single product, XR2. Oakly uses budgets and standards and control functions. Oakly makes use of its standards in order to budgeted cost per unit. For example, Exhibit A provides information on the budgeted variable costs per unit. When determining direct material costs for the planning (master) budget income statement, the $11.48 budgeted material cost per unit of XR2 would be used in the calculation. Exhibit A Budgeted (Standard) Variable Costs Per Unit of XR2 Raw...
Oakly Variance Case manufactures a single product, XR2. Oakly uses budgets and standards and control functions. Oakly makes use of its standards in order to budgeted cost per unit. For example, Exhibit A provides information on the budgeted variable costs per unit. When determining direct material costs for the planning (master) budget income statement, the $11.48 budgeted material cost per unit of XR2 would be used in the calculation. Exhibit A Budgeted (Standard) Variable Costs Per Unit of XR2 Raw...
"I just don't understand these financial statements at all!” exclaimed Mr. Elmo Knapp. Mr. Knapp explained that he had turned over management of Racketeer, Inc., a division of American Recreation Equipment, Inc., to his son, Otto, the previous month. Racketeer, Inc., manufactures tennis rackets. "I was really proud of Otto,” he beamed. “He was showing us all the tricks he learned in business school, and if I do say so myself, I think he was doing a rather good job...
Exercise 16-36 (Static) Variable Cost Variances (LO 16-5) Paynesville Corporation manufactures and sells a preservative used in food and drug manufacturing. The company carries no inventories. The master budget calls for the company to manufacture and sell 100,000 liters at a budgeted price of $75 per liter this year. The standard direct cost sheet for one liter of the preservative follows. Direct materials (2 pounds @ $4) $ 8 Direct labor (0.5 hours @ $24) 12 Variable overhead is applied...
Paynesville Corporation manufactures and sells a preservative used in food and drug manufacturing. The company carries no inventories. The master budget calls for the company to manufacture and sell 118,000 liters at a budgeted price of $210 per liter this year. The standard direct cost sheet for one liter of the preservative follows. Direct materials (2 pounds @ $13) $ 26 Direct labor (0.5 hours @ $42) 21 Variable overhead is applied based on direct labor hours. The variable overhead...
Paynesville Corporation manufactures and sells a preservative used in food and drug manufacturing. The company carries no inventories. The master budget calls for the company to manufacture and sell 100,000 liters at a budgeted price of $75 per liter this vear. The standard direct cost sheet for one liter of the preservative follows. Direct materials Direct labor (2 pounds $4) (0.5 hours $24) $ 8 12 Variable overhead is applied based on direct labor hours. The variable overhead rate is...
2 Paynesville Corporation manufactures and sells a preservative used in food and drug manufacturing. The company carries no inventories. The master budget calls for the company to manufacture and sell 140,000 liters at a budgeted price of $375 per liter this year. The standard direct cost sheet for one liter of the preservative follows. 4 points Direct (2 pounds @ $24) (0.5 hours @ $64) $48 materials Direct labor 32 eBook Variable overhead is applied based on direct labor hours....