Unit Three Flexible Budget and Standards
Unit Three Flexible Budget and Standards
Unit Three Flexible Budget and Standards
The technique of using standard costs for the purposes of cost control is known as
standard costing. It is a system of cost accounting which is designed to find out how
much should be the cost of a product under the existing conditions. The actual cost can
be ascertained only when production is undertaken. The predetermined cost is
compared to the actual cost and a variance between the two enables the management to
take necessary corrective measures.
Setting material, labor and overhead standards: There are several basic principles
which ought to be appreciated in setting standards for direct materials. This involves
Quality of material and Price of the material. When you want to purchase material, the
quality and size should be determined. The standard quality to be maintained should
be decided. The quantity is determined by the production department.
Page 1 of 17
The second step in determining direct material cost will be a decision about the
standard price. Material’s cost will be decided in consultation with the purchase
department. The cost of purchasing and store keeping of materials should also be taken
into consideration.
For setting a standard time for labor force, we normally take in to account previous
experience, past performance records, test run result, work-study etc. The labor rate
standard refers to the expected wage rates to be paid for different categories of workers.
Past wage rates and demand and supply principle may not be a safe guide for
determining standard labor rates. The anticipation of expected changes in labor rates
will be an essential factor.
Final task of setting standards is setting of standard for overhead costs. The very
purpose of setting standard for overheads is to minimize the total cost. Standard
overhead rates are computed by dividing overhead expenses to direct labor hours or
units produced. The standard overhead cost is obtained by multiplying standard
overhead rate by the labor hours spent or number of units produced. The determination
of overhead rate involves three things:
Determination of overheads
Determination of labor hours or units manufactured
Dividing total overheads to the allocation base (total labor hours or total
manufactured units).
The overheads are classified into fixed overheads, variable overheads and semi-variable
overheads. The fixed overheads remain the same irrespective of level of production,
while variable overheads change in the proportion of production. The expenses increase
or decrease with the increase or decrease in output. Semi-variable overheads are neither
fixed nor variable. These overheads increase with the increase in production but the rate
of increase will be less than the rate of increase in production.
Data from the standard cost card are then used to assign costs to inventory accounts.
Both actual and standard costs are recorded in a standard cost system, although it is the
standard (rather than actual) costs of production that are debited to Work in Process
Inventory. Any difference between an actual and a standard cost is called a variance.
Page 2 of 17
start of the period. In other words, the static budget is the “original” budget.
Evaluating performance based upon the master budget which fixed and prepared at
single level of activity may not provide accurate picture of performance. This because
usually the planned and actual output or activities levels may not be equal, as a result
the comparison is performed at two different level of activity which hides the variance
attribute to the actual performance units as well as overall organization. For example, if
a company budgeted to produce and sell 12,000 units, but the actual performance
showed only 10,000 units, the comparison of revenue, cost and profit at the budget and
actual level of output do revels only the variance resulted from the difference in the
level of output. Therefore unless the analysis is re done by adjusting the budgeted level
of output towards the actual units produced and sold, the variance is not helpful to the
management as performance evaluation tool.
A static budget is based on the level of output planned at the start of the budget period.
The static-budget variance is the difference between the actual result and the
corresponding budgeted amount in the static budget.
Flexible Budget
A flexible budget is budget prepared to show how actual results compare to budgeted
numbers. It has columns for the actual and budgeted amounts and differences, or
variances, between these amounts. The difference might be either favorable or
unfavorable. Set, regardless of ensuing changes in actual output (or actual revenue and
cost drivers)
Flexible budget is adjusted in accordance with ensuing changes in actual output (or
actual revenue and cost drivers). A flexible budget is calculated at the end of the period
when the actual output is known. A static budget is developed at the start of the budget
period based on the planned output level for the period. A flexible budget helps
managers to calculate a richer set of variances than does static budget. Flexible budgets
are important for giving management an indication of what questions need to be asked.
The flexible budget is a performance evaluation tool. It cannot be prepared before the
end of the period. A flexible budget adjusts the static budget for the actual level of
output so as to avoid the inherent limitation of using static budget for performance
evaluation. The flexible budget asks the question: “If I had known at the beginning of
the period what my output volume (units produced or units sold) would be, what
would my budget have looked like?” The motivation for the flexible budget is to
compare apples to apples. If the factory actually produced 10,000 units, then
management should compare actual factory costs for 10,000 units to what the factory
Page 3 of 17
should have spent to make 10,000 units, not to what the factory should have spent to
make 9,000 units or 12,000 units or any other production level.
3.3. Controllability and variance analysis
A variance is the difference between an actual result and an expected result. The
process by which the total difference between standard and actual results is analyzed is
known as variance analysis. When actual results are better than the expected results, we
have a favorable variance (F). If, on the other hand, actual results are worse than
expected results, we have an adverse or unfavorable variance (U).
Now let see the preparation of flexible budget as well as analysis of variance using the
following:
Illustration 3.1: Jimma Garment Co. manufactures and sells a jacket. Sales are made to
distributors who sell to independent clothing stores. Jimma Garment’s only costs are
manufacturing costs. All units manufactured in April 2003 are sold in April 2003. There
is no beginning or ending inventory. Jimma Garment has variable cost categories. The
budgeted data for April 2003 are:
Cost category Variable cost / jacket.
DM costs………………………………… Br. 60
DL costs…………………………………. 16
Variable MOH costs…………………… 12
Total variable costs ……………… Br. 88
The number of units manufactured is the cost driver for all variable-manufacturing
costs. The relevant range for the cost driver is 12,000 jackets. Budgeted manufacturing
fixed costs are Br. 276,000 for production12, 000 jackets. Budgeted selling price is
Br.120/jacket. The static budget for April 2003 is based on selling 12,000 jackets.
The actual data for April 2003 are as follows:
Units sold ………………… 10,000 jackets
Revenues …………………. Br. 1,250,000
Variable costs:
Page 4 of 17
DM …………………….. 621,600
DL……………………… 198,000
Variable MOH……….. 130,500
Fixed costs …………….. 285,000
OPI=14900
The static budget variance is the difference between any line-item in this original
budget and the corresponding line-item from the statement of actual results. Often, the
line-item of most interest is the “bottom line”: total cost of production for the factory
and other cost centers; net income for profit centers.
Static Budget Variance [SBV] is the difference between an actual result
and the corresponding budgeted amount in a static budget.
Level zero variance analysis the least detail analysis which simply compares the
operating income at static budget income statement with the operating income at the
actual income statement. The level zero variance for Jimma Garment from the above
given data is determined as;
The analysis revealed unfavorable variance as the actual operating income is lower than
the budgeted operating income by Birr 93,100. The result here couldn’t provide the
management useful information as it couldn’t show the contribution revenue and each
cost element to operating income variance.
2. Static Budget Variance (SBV)
Level one variance can offer management a better insight about their organizational
performance than level zero analysis. At this level, operating income variance will be
decomposed into revenue and cost component as a result the management will identify
the responsibility center that demands attention.
Static Budget Variance
Actual Static Budget Static Budget
Results (1) Variance(SBV) Result (3)
Items (2) = (1) – (3)
Unit sales 10,000 2,000U 12,000 .
Page 5 of 17
Variable costs:
Br. 93,100U______________
SBV
The static budget variance shows an unfavorable variance for revenue, fixed costs
whereas favorable variance of total variable cost. These variances are due primarily to
the fact that the static budget was built on an output level of 12,000 units, while the
company actually made and sold 10,000 units. The revenue variance might also be due
to an average unit sales price that differed from budget. The variable cost variances
might also be due to input prices that differed from budget (e.g., the price of fabric), or
input quantities that differed from the per-unit budgeted amounts (e.g., yards of fabric
per jackets) that may be identified at the later stages of the variance analysis.
Level 2-variance analysis [Flexible Budget Variance (FBV) & Sales-Volume Variance
(SVV)]
To identify the amount of variance attributed the difference in the level of output as
well as to real performance of the company, at this level the static budget variance will
be decomposed into the flexible budget variance and sales volume variance.
Flexible Budget Variance (FBV) is a better measure of operating performance because
they compare actual revenues to budgeted revenues and actual costs to budgeted costs
for the same output level.
The flexible budget variance is the difference between any line-item in the flexible
budget and the corresponding line-item from the statement of actual results.
Page 6 of 17
Sales-Volume Variance (SVV) is the difference between the flexible budget amounts and
static budget amounts. It represents the variance caused solely by the difference in the
actual output volume and budgeted quantity of output expected to be produced and
sold in the static budget.
To determine the flexible budget variance and sales volume variance, first you need to
develop a flexible budget. The flexible budget, for the example given above is prepared
at the end of the period after the actual output level of 10,000 jackets is known. The
flexible budget is that Jimma Garment would have prepared at the start of the budget
period had it correctly forecasted the actual level of 10,000 jackets.
In preparing the flexible budget,
(1) The budgeted selling price is the same Br. 120/ jacket.
(2) The budgeted variable costs per unit are the same Br. 88/ jacket.
(3) The budgeted fixed costs are the same Br. 276, 000, are used.
The only difference between the static budget and the flexible budget is that the static
budget is prepared for the planned output level of 12,000 jackets, whereas the flexible
budget is based on the actual output of 10,000jackets.
The following stapes are used to prepare a flexible budget:
Step 1.Identify the Actual Quantity of Output produced and sold.
10,000 jackets.
Step 2. Calculate the flexible budget for revenues based on Budgeted Selling Price and
Actual Quantity of Output.
Flexible B for Revenues = Br. 120/jacket X 10,000 jacket
= Br. 1,200,000
Step 3. Calculate the Flexible Budget for Costs based on Budgeted Variable Costs per
Unit, Actual Quantity of Output and Fixed Costs.
Flexible Budget for Variable Costs:
DM: Br. 60/j X 10,000j Br. 600,000
DL: Br. 16/j X 10,000j 160,000
MOH: Br. 12/j X 10,000j 120,000
FB for TVC Br. 880,000
FB for FC 276,000
FB for Costs Br. 1,156,000
Step 4: Building the flexible budget based on the information from steps 1 and 2, and
step 3 results a flexible budget presented on column 3 of the following table.
After the flexible budget is developed it is possible to determine the flexible budget
variance by comparing the flexible budget and the actual operational results, and sales
volume variance by comparing the flexible budget results and the static budget as
shown on the following table.
Actual Flexible Flexible Sales Static
Page 7 of 17
Results Budget Budget Volume Budget
Variance Variance
(1) (2) = (1) – (3) (3) (4) = (3)-(5) (5)
Unit sales 10,000 0 10,000 2,000 12,000
Revenues 1,250,000 50,000F 1,200,000 240,000U 1,440,000
Variable costs:
DM 621,600 21,600U 600,000 120,000F 720,000
DL 198,000 38,000U 160,000 32,000F 192,000
MOH 130,500 10,500U 120,000 24,000F 144,000
Total variable costs 950,100 70,100U 880,000 176,000F 1,056,000
Contribution Margin 299,900 20,100U 320,000 64,000U 384,000
Fixed Costs 285,000 9,000U 276,000 0 276,000
Operating Income Br. 14,900 Br. 29,100U Br. 44,000 Br. 64,000U Br. 108,000
Br. 29,100U. Br. 64,000U________
FBV SVV
Br. 93,100U .
SBV
Interpreting flexible budget variances
For performance evaluation, management compares actual results to a flexible budget
based on the actual volume of activity. Because the actual results and the flexible budget
reflect the same volume of activity, any variances in revenues and variable costs result
from differences between standard and actual per unit amounts.
From this table, Jimma Garment sees that after adjusting for sales volume, revenue was
higher than would have been expected. The favorable Birr 50,000 variance must be due
entirely to an average sales price that was higher than planned which was Birr 125 per
jacket compared to the original budget of Birr 120 per jacket.
Materials costs were higher than would have been expected for a sales volume of 2,000
units. This unfavorable variance is due to higher material prices, or to inefficient
utilization of fabric (more waste than expected), or a combination of these two factors.
Labor and overhead were higher than expected, even after adjusting for the sales
volume of 2,000 units. This unfavorable flexible budget variance implies that either
wage rates were higher than planned, or labor was not as efficient as planned, or both.
Similarly, the components of variable overhead were either more expensive than
budgeted, or were used more intensively than budgeted. For example, electric rates
might have been higher than planned, or more electricity was used than planned per
unit of output.
Page 8 of 17
The fixed cost variances are identical in this table to the previous table. In other words,
the flexible budget and flexible budget variance provide no additional information
about fixed costs beyond what can be learned from the static budget variance.
Interpreting the Sales and Variable Cost Volume Variances
Because the static and flexible budgets are based on the same standard sales price and per-unit
variable costs, the variances are solely attributable to the difference between the planned and
actual volume of activity. Marketing managers are usually responsible for the volume
variances. Because the sales volume drives production levels, production managers have little
control over volume. Exceptions occur; for example, if poor production quality control leads to
inferior goods that are difficult to sell, the production manager is responsible. The production
manager is responsible for production delays that affect product availability, which may restrict
sales volume. Under normal circumstances, however, the marketing campaign determines the
volume of sales. Upper-level marketing managers develop the promotional
program and create the sales plan; they are in the best position to explain why sales goals are or
are not met. When marketing managers refer to making the numbers, they usually mean
reaching the sales volume in the static (master) budget.
Fixed Cost Considerations
At this point, it is important to note that the reason the fixed cost variance shown in the above
table it is zero because we are comparing two budgets (static versus flexible). Variances occur
only because the budgets are created using different volumes of activity. Since total fixed cost is
not affected by the level of activity, there will be no fixed cost variances associated with static
versus flexible budgets.
3.4. Classification of variances
Budget Variances indicate the total deviation of actual costs from expected costs.
However, they do not give the complete story about deviations between budgeted and
actual results; i.e. it is not yet clear what contributed to the variances unless further
investigations are made.
Hence, a total flexible budget variance (FBV) is the difference between total actual costs
incurred and total standard cost applied to the output produced during the period. This
variance can be diagrammed as follows:
Actual Cost of Actual Production Input Standard Cost of Actual Production
Output
Total Variance (FBV)
Since total variances do not provide useful information for determining why cost
differences occurred; to help managers in their control objectives, total variances are
subdivided into price and usage components. Hence, the total variance diagram can be
expanded to provide a general model indicating the two sub-variances as follows:
Page 9 of 17
Price/Rate Variance Quantity/Efficiency variance
Page 10 of 17
i) Material Price Variance(MPV)
A material price variance is the difference between the actual price of material/unit and
the standard price of material per unit multiplied by the actual quantity of material
purchased. In other words, the material price variance (MPV) indicates whether the
amount paid for material was below or above the standard price.
Most companies compute the materials price variance when materials are purchased
rather than when they are used in production. There are two reasons for this practice.
First, delaying the computation of the price variance until the materials are used would
result in less timely variance reports. The more timely the information, the more likely that
proper managerial action can be taken. Old information is often useless information. Second,
computing the price variance when the materials are purchased allows materials to be
carried in the inventory accounts at their standard cost.
Material price variance can be calculated as:
Page 11 of 17
MQV = (SQ-AQ) x SP
If the actual quantity amounts are larger than the standard quantity amounts, this
variance is unfavorable (U); if the standards are larger than the actual; the variance is
favorable (F)
Example 5.1 In August 2001, East Publishing Company’s costs and quantities of paper
consumed in manufacturing its 2002 Executive Planner and Calendar were as follow:
Actual unit purchase price Br 0.16 per page
Standard quantity allowed for good production 195,800 pages
Actual quantity purchased during August 230,000 pages
Actual quantity used in August 200,000 pages
Standard unit price Br 0.15 per page
Required:
a) Calculate the total cost of purchases for August.
b) Compute the material price variance on the bases of purchase
c) Calculate the material quantity variance.
d) Total FBV
Solution:
a) Total cost of purchases for August would be:
Actual unit purchase price (a) -------------------------------- Br 0.16 per page
Actual quantity purchased during August (b) ---------------- 230,000 pages
Total cost (a x b) ------------------------------------ Br.36, 800
b) MPV = (SP – AP) AQ
= (Br 0.15 per page - Br 0.16 per page) 230,000 pages= Br. 2,300 (U)
c) MQV = (SQ-AQ) x SP
= (195,800 pages - 200,000 pages) Br 0.15 per page= Br. 630(U)
d) Total FBV═ Br 2,300U + Br. 630U═ Br.2,930 U
Activity
Iron Eagle makes wrought iron table and chair sets. During April 2001, the purchasing agent
bought 12,800 pounds of scrap iron at Br. 0.89 per pound. Each set requires a standard quantity
of 35 pounds at a standard cost of Br 0.85 per pound. During April, the company used 10,700
pounds and produced 300 sets. For April, compute the direct material price variance and the
direct material quantity variance.
Page 12 of 17
B. Labor Cost Variances: (Level 3 Variance Analysis)
Just like we have done for material inputs, we will do the same meaningful analysis for
labor inputs. Hence, the variance investigation to flexible budget variance for labor
resulted in: (i) labor rate variance that identifies the effect of differences in the rates paid
to workers, and (ii) labor efficiently or usage variance that identifies the effect of
differences in the quantities of labor used.
i) Labor Rate Variance (LRV) or Direct labor spending variance
The labor rate variance (LRV) shows the difference between the actual wages paid to
labor for the period and the standard wages for all hours worked. Thus, Labor rate
variance is the difference between the actual rate of labor per hour and the standard
rate of labor per hour, multiplied by the actual hours of labor worked.
LRV= (SR-AR) x AH
Where: SR is standard rate of labor per hour
AR is actual rate of labor per hour, AH is a total actual hour of labor
worked
Page 13 of 17
b) Direct material usage variance
c) Direct material cost variance
d) Direct labor rate variance
e) Direct labor efficiency variance
f) Direct labor cost variance
Solution
Material Variances
i). SQ = Standard Quantity of Direct material for Actual Output would be:
1 dart board = 8.5 pounds Direct material
19,000 dart boards = ?
So, SQ = 8.5 pounds Direct material x 19,000 = 161,500 pounds
ii). SP = Standard price of Direct material = Br. 1.80/pounds.
iii). AP = Actual Price of Direct material = Total cost of Direct material purchased
Total units of direct material purchased
= Br. 304,000 = Br.1.90/ pounds
160,000 pounds
iv). AQ=Actual Quantity of Direct material purchased or used = 142,500 pounds
a) MPV= (SP – AP) AQ
= (Br.1.80/pds - Br.1.90/ pds) 142,500 pounds = Br. 14,250(U)
b) MQV = (SQ-AQ) x SP
= (161,500 pounds - 142,500 pounds) Br. 1.80/pounds= Br. 34,200(F)
c) Material cost variance = MPV + MQV
= Br. 14,250 (U) + Br. 34,200 (F) = Br. 19,950 (F)
Labor Variances
i) SR= Standard Rate of DL per hour= Br.8.00/Hr
ii) SH=Standard Hours of DL for Actual Output would be:
0.25Hrs=1dart board
? = 19,000 dart boards
SH = 0.25x19, 000=4,750Hrs
iii) AH=Actual hrs of DL used = 5,000 hrs
iv) AR= 0.9 x 42,000 = 37,800 = Br.7.56/Hr
5,000 5,000
d) LRV= (SR-AR) x AH
= (Br.8.00/Hr - Br.7.56/Hr) 5,000 hrs = Br. 2,200 (F)
e) LEV = (SH – AH) x SR
= (4,750Hrs - 5,000 hrs) Br.8.00/Hr = Br.2, 000(U)
f) labor cost variance = LRV + LEV= Br. 2,200 (F) + Br.2, 000(U) = Br. 200 (F)
Page 14 of 17
and fixed overhead application rates and accounts allows separate price and usage
variances to be computed for each type of overhead.
a. Variable Overhead Cost Variance (VOHV)
This is the difference between standard variable overheads for actual production and
the actual variable overheads.
Symbolically,
FBV of VOHV =SC-AC
Where: SC= standard variable overheads for actual production OR AQ*SR per unit
AC= actual variable overheads
It can be sub –divided into Variable overhead expenditure (spending) variance, and
Variable overhead efficiency variance.
i) VOH expenditure variance is the difference between the standard variable
overheads for the actual hours worked, and the actual variable overheads
incurred. The formula for computing it is as follows:
It measures the effect of differences in the actual variable overhead rate and the
standard variable overhead rate.
VOH Exp. Variance = AVOH –SVOH.
Where: AVOH is actual variable overheads incurred
SVOH is standard variable overheads for the actual hours worked,
ii) VOH efficiency variance arises when the actual output produced differs from
the standard output for actual hours worked. It is a measure of extra overhead
(for saving) incurred solely because of the efficiency shown during the actual
hours worked.
It measures the change in the variable overhead consumption that occurs because of
efficient or inefficient use of the cost allocation base, such as direct labor hours. The
formula to compute it is as follows:
VOH efficiency variance = (SHOV for actual hours worked)- (SHOV for actual output)
Example 4.5 From the following information, calculate VOH cost variances assuming
labor hours as cost driver for variable manufacturing overhead.
Budget output 5000 units
Budgeted hours 10,000
Budgeted variable overheads Br. 2,000
Actual variable overheads Br. 3,000
Actual output 4,000 units
Actual hours 12,000 hours
Solution
Page 15 of 17
i) VOH cost variance =AVOH –SVOH for actual production
= Br.3, 000 - (4000 x Br 0.40*)
= Br...3,000 - Br. 1600= Br.1400 (U)
ii) VOH expenditure variance = AVOH – SVOH for actual hours worked
= Br.3000 - (12000 x 0.20**) =Br. 600 (U)
iii) VOH efficiency variance = SVOH for actual Hrs - SVOH for actual output
=Br. 2400 – Br. 1600=Br. 800 (U)
Workings:
*SVOH per unit of output –Br.2000/5000 = Br.0.40 per unit
** SVOH pre hours = Br.2000/10,000 = Br.0.20 per hour
Page 16 of 17
= Br.3600 - (0.60* x4800)
= Br. 3600 - Br. 2880 =. Br.720 (U)
B. FOHEV= AFOH – BFOH
= Br.3600 – Br.3000 =. Br.600 (U)
C. FOHVV = BFOH – SFOH on actual output
= Br.3000 - (0.60 x 4800)
= Br.3000 – 2880 =. Br.120 (U)
Workings:
*SFOH per unit = Br. 3000/5000= Br.0.60 per unit
Page 17 of 17