|
a) Prepare a work sheet showing the fixed and flexible budgets, actual results and variances for March
|
|
Fixed |
|
Flexible |
|
Actual |
Variances |
|
|
|
|
|
|
|
|
|
Sales |
units |
3000 |
|
3500 |
|
3,500 |
|
|
Selling price |
5 |
|
5 |
|
5.2 |
|
|
|
€ |
€ |
€ |
€ |
|
€ |
€ |
|
Sales |
|
15000 |
|
17500 |
|
18,200 |
700 |
F |
Less cost of sales |
|
|
|
|
|
|
|
Mat A |
2.50 |
7,500 |
2.5 |
8750 |
(1400 x 5.5) |
7,700 |
1,050 |
F |
Mat B |
0.75 |
2250 |
0.75 |
2625 |
(925 x 3.5) |
3,237.50 |
-612.50 |
A |
Mat C |
1.00 |
3000 |
1 |
3500 |
(1500 x 2.4) |
3,600 |
-100 |
A |
|
|
12,750 |
|
14,875 |
|
14,537.5 |
|
|
Gross profit |
2,250 |
|
2,625 |
|
3,662.5 |
375 |
F |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
b) Calculate the materials price and usage variances
Materials price and usage variances |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price |
|
|
Usage |
|
|
Total |
|
(std price - act price) x act usage |
(Std usage -act usage) std price |
|
|
|
|
|
|
|
|
|
Ingredient A |
(5.00 - 5.5) x 1400 |
|
(1750 - 1400) 5.00 |
|
|
|
|
(700) A |
|
|
1750 F |
|
|
1050F |
|
|
|
|
|
|
|
|
|
Ingredient B |
(3.0 - 3.5) x 925 |
|
|
(875 - 925) x 3 |
|
|
|
|
(462.5) A |
|
|
(150 )A |
|
|
(612.5) A |
|
|
|
|
|
|
|
|
|
Ingredient C |
(2.5 - 2.4) x 1500 |
|
(1400 - 1500)x 2.5 |
|
|
|
|
150F |
|
|
(250)A |
|
|
(100)A |
|
|
(1012.5) A |
|
|
1350 F |
|
|
337.5 |
|
|
|
|
|
|
|
|
|
|
|
Note the standard usage is calculated as 3,500 units x 0.5 (ingredient A); 0.25 (ingredient B) and 0.4 (ingredient C)
c) Prepare a statement reconciling the budgeted gross profit to actual
|
|
|
|
|
|
€ |
€ |
|
|
Budget gross profit |
|
|
|
|
2250.00 |
|
|
Sales price variance |
|
|
|
700.00 |
|
|
|
Sales margin volume variance |
|
|
375.00 |
|
|
|
Materials price variance |
(700 + 462.5 - 150) |
|
-1012.50 |
|
|
|
Materials usage variance (1750 - 150 - 250) |
|
1350.00 |
1412.50 |
|
|
|
|
|
|
|
|
|
|
|
Actual gross profit |
|
|
|
|
3662.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
d) Briefly comment on the significance of the variances calculated
Overall actual gross profit is €1412.5 or 62.7%greater than budgeted. The main reasons for this are as follows
Sales price variance: The business has achieved a higher average price than budgeted. It budgeted on an average price of €5.00 but achieved €5.2 and increase of 4%. This ensures a positive price variance of €700 and thus actual profit was 31% (700/2250) greater due to this price variance. Management should assess the reasons for this including questioning the budgeted target set.
Sales margin volume variance: Despite achieving a higher price the business managed to increase sales volume by 500 units or 16.67% (500/3000). This created a positive variance of €375 and thus actual profit was 16.67% higher due to the increase in sales. Again management must question the budget figure. Was it too easily achievable? Were there random events that influenced the sales level.
Materials variances: The overall materials cost variance is a positive variance of €337.5. This can be further analysed and can be broken into its two components parts as follows
- Materials price variance: This is an adverse variance of €1012.5. The business paid more for their materials than they expected. This is a significant variance as it amounts to 45% of budgeted profit. In particular Materials A and B had adverse price variances whereas Materials C had a small positive variance. Management must investigate reasons for these variances. Did the purchasing manager seek competitive pricing to ensure the best value is obtained in purchasing? Did the company avail of quantity discounts. How often are the standards reviewed to reflect reality? Was there simply a general increase in the price of materials
- Materials usage variance: This is a positive variance of €1350 and is very significant as it amounts to 60% of budgeted profit. Possible reasons for this variance are
- The standard of quality of the materials purchased. Good quality materials can lead to less materials wastage. This could be in conjunction with an adverse materials price variance.
- The quality and age of the equipment used. If the company is using more up to date equipment this can lead to greater levels of efficiency.
- Maybe the standard for materials usage needs to be revised.
|