Variance Accounting Case Study - PD PDF
Variance Accounting Case Study - PD PDF
Variance Accounting Case Study - PD PDF
Introduction
This series of financial management case studies will be based around the business of
Coverdrive Ltd, a manufacturer of high quality, hand made cricket bats.
It currently has a budgeted turnover of £2.75m with anticipated profit for the year of
£0.40m.
This first case study focuses on the concept of standard costing, variance analysis and
the reconciliation of budget to actual profit through an analysis of the main cost
variances.
The scenario assumes that you work as an assistant in the SME business services unit
of Dunn and Musgrave a firm of accountants and consultants. You have recently
introduced, at Coverdrive Ltd a system of standard costing and budgetary control.
The objective of the system is to generate a monthly report to show the following:
Rate
Efficiency
Price
Usage
Expenditure
Efficiency
Expenditure
Volume:
Capacity
Efficiency
Sales Variances:
Break-Even Point:
Budget
Actual
“A control technique which compares standard costs and revenues with actual results to
obtain variances which are used to stimulate improve performance.” (CIMA)
Terry Lucy in his excellent text “Management Accounting” outlined these as:
The standard costs are readily available substitutes for actual average unit costs
and can be used for stock and work-in-progress valuations, profit planning and
decision making, and as a basis for pricing where ‘cost-plus’ systems are used.
In addition to the objectives stated by Lucy it can be said that, it can be the basis for
‘good practice’ in establishing not only cost control but cost reduction programmes.
Variance Accounting
Flexible budgetary control uses the same principles but standard costing informs a more
detailed analysis of variances.
Direct action can result in improved efficiency, greater utilisation of resources and in
some cases reduction in cost.
Reporting systems should detail variances in such a way that through the mechanism of
“responsibility accounting” individual managers should be held accountable for the
specific variances.
The objectives and principles outlined above are those which underpin the accounting
methods and techniques visited in this case study.
The purpose of this case study is to illustrate the principles of standard absorption
costing and the reconciliation process of matching budget to actual performance by the
use of variance analysis.
The Situation
Coverdrive Ltd is a company which manufactures high quality cricket bats. The
business was originally formed in the 1980’s by Steve Howe and Steven Ambrose and
for some years operated as a partnership. It is located in Whitby, North Yorkshire.
The company now has a budgeted turnover of £2.75m with an anticipated profit for the
current year of £0.4m.
You work for Dunn and Musgrave a firm of accountants and consultants and Coverdrive
Ltd is one of your clients. Your role is in the business advisory unit and you have
recently installed a monthly management accounting reporting system based on
standard costing techniques.
In early February 2010 you receive the attached memo from Pauline Dunn your firm’s
senior regarding the reporting system.
As you are aware we recently installed a standard costing system at Coverdrive Ltd.
The details attached show the budget for the month of January, together with the
standard specification for each product in the range.
Also shown is the budgeted fixed and variable overheads for the period.
I have arranged a meeting for next Wednesday 12 February, to discuss the figures for
the month of January.
Could you please prepare the following schedules by Tuesday am, so that we can
review these prior to the meeting:
A variance analysis report showing the variances outlined in the model above –
highlighting any areas for concern.
The breakeven point in £ turnover and % capacity for both the budget and actual
positions.
Production and Sales in Units Selling Price Standard Hours per Unit
£
Coverdrive “Special” 1250 70 4
Coverdrive “Super” 1000 60 3.5
Coverdrive “Classic” 1250 55 3
“Special” 1.4
“Super” 1.3
“Classic” 1.2
“Special” 1275
“Super” 1100
“Classic” 1220
“Special” 5228
“Super” 3740
“Classic” 3721
“Special” £31629
“Super” £22814
“Classic” £22512
Cost Usage
Units of Material
“Special” £18160 1798
“Super” £14342 1420
“Classic” £15029 1488
“Special” £12654
“Super” £8857
“Classic” £9489
Memo
In reply to your request of 5 February, I attach the report for January 2010.
I look forward to discussing the results in our review meeting planned for tomorrow.
Coverdrive Ltd
Actual Operating Statement January 2010
£ £ £ £
Sales 89250 66000 67100 222350
Contribution 66864
Fixed costs 34000
Profit / (Loss) £32864
£ £ £ £
Sales 87500 60000 68750 216250
Efficiency Ratio:
Capacity Ratio:
Activity Ratio:
The overall efficiency for the month was almost as planned, although efficiency on
“Special” and ‘Classic” was marginally adverse. This was offset by the favourable
efficiency on “Super”.
Capacity was approximately 4% greater than forecast, with extra capacity allowed on
“Special” and “Super” lines. This resulted in the overall activity on level of production
volume being approximately 3% more favourable than planned.
Standard Cost of
Product Actual Production Actual Cost Variance F (A)
The total direct labour cost variance is adverse, as the actual labour cost for the period
is greater than that allowed for the actual production volume.
F (A)
“Special” (5100 – 5228) £6 (768)
“Super” (3850 – 3740) £6 660
“Classic” (3660 – 3721) £6 (366)
(474)
There is a net adverse efficiency variance, as in the case of “special” and “classic” the
actual hours worked were greater than that allowed for ‘the actual volume of output’.
“Super” however showed higher productivity.
The net variance is adverse, as in all cases the actual labour rate was greater than
specified.
£
Summary: Efficiency (474)
Rate (821)
Total Variance £(1295)
Standard Cost of
Actual Production Actual Cost Variance
The net total material variance is adverse as the actual cost in all cases, is greater than
the cost specified for the volume achieved.
The net usage variance is adverse as in the case of “special” and “classic” the actual
usage of material is greater than that specified for the volume of output achieved.
“Super” showed an efficient use of material.
The net material price variance is adverse as the actual unit price of material is greater
than the predetermined or standard price.
£
Summary: Usage (270)
Price (471)
Total Variance (741)
£30500 = £2.48980
12250 per standard hour
x £2.48980
= £31396
The amount recovered in production achieved is greater than the actual incurred.
*actual overhead
actual hours
The underspend is due to the operating cost per hour being less than standard.
£
Summary: Efficiency (197)
Expenditure 593
Total Variance £396
£
Budgeted fixed overhead 33550
Actual fixed overhead 34000
Adverse, over-spend £(450)
Volume Variance:
The additional volume achieved is the factor which influences this over-recovery.
Capacity and;
Efficiency
Summary:
£ F/(A)
Total variance 536
Expenditure (450)
Volume * 986
536
£
* Efficiency (216)
Capacity 1202
986
£ F/(A)
Budget Profit 33200
Actual Profit 32864
Profit Variance (336)
The adverse variance on direct labour is due to the incidence of overtime worked.
The efficiency of labour and usage of material is well within line with predetermined
levels planned.
These marginal adverse elements are offset by both the variable overhead expenditure
and fixed overhead volume variances.
£ Turnover
Fixed Costs
(Contribution / Sales)
Budget Actual
£33550 £34000
(66750 / 216250) (66864 / 222350)
= £108692 = £113064