- 30 Marks
Question
KK Plc. buys small tablet computers which it customizes for the Nigerian market and then resells to electronics retailers. Although a detailed variance analysis is carried out each month, the CEO John, T, has become concerned that no one has a clear responsibility for taking action in response to this analysis or for using it to carry out an ex-post analysis of the outcome of important decisions.
The following is an extract from last month’s budget:
| Model | A | B | C |
|---|---|---|---|
| Selling price/unit (N) | 1,000 | 1,250 | 1,500 |
| Variable cost/unit (N) | 400 | 500 | 600 |
| Sales (units) | 25,000 | 40,000 | 15,000 |
The budgeted fixed costs were N12,500,000 for the month, which were not dependent on the mix or quantities of products sold. When the budget was being prepared, it was estimated that the total size of the market (including sales by the company and the competitors) would be 400,000 units.
Shortly after the beginning of the month, the marketing director, Okon Nelson, decided that a change of pricing strategy was necessary in response to the recessionary economic conditions. The price of Model A was reduced by 10%, and the prices of Models B and C were each reduced by 20%. The company was partly successful in passing on the impact of these price reductions to its suppliers, and as a consequence, the variable cost per unit for all three models was reduced by 5%. Actual fixed costs were 5% higher than budgeted because of the marketing costs associated with publishing the price reductions.
As a result of the recessionary conditions, the actual total market size was just 200,000 units. The actual quantities sold by the company were as follows:
Actual quantities sold by the company were as follows:
| Model | Sales (units) |
|---|---|
| A | 14,800 |
| B | 29,500 |
| C | 11,700 |
Required:
a. Present a comprehensive analysis of variances, reconciling the budgeted and actual profit for last month in as much detail as possible from the information provided. (25 Marks)
b. Evaluate the financial success (or otherwise) of the decision to change the pricing strategy and assess whether the difference between the budgeted and actual performance was attributable mainly to luck or to factors within the company’s control. (5 Marks)
Answer
(a) Budgeted Profit
| ₦’000 | |
|---|---|
| Model A: 25,000 × (1,000 – 400) | 15,000 |
| Model B: 40,000 × (1,250 – 500) | 30,000 |
| Model C: 15,000 × (1,500 – 600) | 13,500 |
| Total Contribution | 58,500 |
| Less Fixed Costs | (12,500) |
| Budgeted Profit | 46,000 |
Actual Profit
| ₦’000 | |
|---|---|
| Model A: (900 – 380) × 14,800 | 7,696 |
| Model B: (1,000 – 475) × 29,500 | 15,487.5 |
| Model C: (1,200 – 570) × 11,700 | 7,371 |
| Total Contribution | 30,554.5 |
| Less Fixed Costs (12,500 × 1.05) | (13,125) |
| Actual Profit | 17,429.5 |
Calculation of Variances
i. Sales Price Variance (SPV)
| Model | Actual Qty (units) | (AP – SP) | Variance (₦’000) |
|---|---|---|---|
| A | 14,800 | 100(A) | 1,480(A) |
| B | 29,500 | 250(A) | 7,375(A) |
| C | 11,700 | 300(A) | 3,510(A) |
| Total Variance | 12,365(A) |
ii. Variable Cost Variance
| Model | Actual Qty (units) | Savings in variable cost/unit | Variance (₦’000) |
|---|---|---|---|
| A | 14,800 | 20(F) | 296(F) |
| B | 29,500 | 25(F) | 737.5(F) |
| C | 11,700 | 30(F) | 351(F) |
| Total Variance | 1,384.5(F) |
iii. Sales Mix Variance (based on actual vs standard mix)
| Model | AQ in AM | AQ in SM | Std Cont./unit | Variance (₦’000) |
|---|---|---|---|---|
| A | 14,800 | 17,500 | 600 | 1,620(A) |
| B | 29,500 | 28,000 | 750 | 1,125(F) |
| C | 11,700 | 10,500 | 900 | 1,080(F) |
| Total | 56,000 | 56,000 | 585(F) |
iv. Sales Quantity Variance (based on budgeted vs actual)
| Model | AQ in SM | BQ in SM | Std Cont./unit | Sales Qty Variance (₦’000) |
|---|---|---|---|---|
| A | 17,500 | 25,000 | 600 | 4,500(A) |
| B | 28,000 | 40,000 | 750 | 9,000(A) |
| C | 10,500 | 15,000 | 900 | 4,050(A) |
| Total | 56,000 | 80,000 | 17,550(A) |
v. Market Size Variance
Budgeted market size = 400,000 units
Actual market size = 200,000 units
Weighted average contribution/unit = ₦731.25
Variance = (200,000 – 400,000) × 20% × ₦731.25 = ₦29,250(A)
vi. Market Share Variance
Standard share of actual market = 20% × 200,000 = 40,000 units
Variance = (56,000 – 40,000) × ₦731.25 = ₦11,700(F)
vii. Fixed Overhead Expenditure Variance (FOEV)
5% × N12,500,000 = N625,000(A)
Profit Reconciliation
| Item | ₦’000 |
|---|---|
| Budgeted Profit | 46,000 |
| Selling Price Variance | 12,365(A) |
| Variable Cost Variance | 1,384.5(F) |
| Sales Mix Variance | 585(F) |
| Market Size Variance | 29,250(A) |
| Market Share Variance | 11,700(F) |
| Sales Quantity Variance | 17,550(A) |
| Fixed Overhead Expenditure Variance | 625(A) |
| Actual Profit | 17,429.5 |
(b) Evaluation of Pricing Strategy
The pricing strategy cost ₦12,990,000, comprising ₦625,000 in additional marketing costs and ₦12,365,000 in price reductions (unfavourable SPV). This was partly offset by the ₦1,384,500 favourable variance from supplier concessions and the ₦585,000 favourable sales mix variance. The net cost was ₦11,007,000.
Despite a decrease in sales volume, the company’s market share increased, contributing an additional ₦11,700,000. This exceeded the strategy’s cost, making the decision financially successful. The only uncontrollable variance was the ₦29,250,000 market size variance due to recessionary conditions, which was outside the company’s control.
Conclusion
Although actual profit was below the budgeted profit, the shortfall was mainly due to an uncontrollable market size variance
- Topic: Standard Costing and Variance Analysis
- Series: MAY 2019
- Uploader: Kwame Aikins