# Unit 9 Management Accounting Solution

### Unit 9 Management Accounting Solution

 Programme Diploma in Business Unit Number and Title Unit 5 Management Accounting QFC Level Level 4 Unit Code H/508/0489

## Introduction

The Management Accounting Solution discuss about cost information which are incurred by the company at both at the current and future level. It also discuss about the various method which are to be followed to record the inventory. In the assignment various cost variance are calculated by comparing with the actual budget to find its effect on the business. The Management Accounting also includes various budget which are helping in comparing these to actual business result. The assignment also contains different costing and budgeting system and the cause of resulting variance. It also discuss various corrective action which will help the business strategy to improve its process.

#### 2.1 Prepare and analyses routine costs report by carrying out a variance analysis for ABC Ltd.

 Report showing variance Particular actual budgeted variance in £ production unit variance 3000 2000 1000 sales revenue variance 30000 20000 10000 direct material variance 8500 6000 2500 direct labour variance 8500 4000 4500 maintenance variance 1400 1000 400 depreciation variance 2200 2000 200 rent and rates variance 1600 1500 100 insurance 5000 3600 1400 total cost 27200 18100 9100

Comparison, explanation and implication of variance-

Production unit variance- The ABC LTD. Has produced 1000 extra unit in comparison to those which was set in the budget. The per unit cost of manufacturing the 2000 units was 9.05 which increased to 9.06 per unit. There was not much difference in the per unit cost in comparison but the company may have reduced the per unit cost by having effective control over the cost.
Sales revenue - The sales revenue was increased by 10000 which was due to increase in production unit made by the company. There was not much increase in revenue in comparison to the cost which was incurred in manufacturing the extra unit.
Direct material - The budgeted per unit cost of material which was used during the production was 3 per unit. The actual per unit cost of material was 2.83. So the company has made optimum utilization of raw material (Miao, Xu, Qiu, Qing & Tao, 2015).
Direct labour – The budgeted per unit labour cost was 2 per unit and the actual cost was 2.83 which was much higher than the planned budget. So the company needs to make effort to reduce it’s per unit labour cost.
Maintenance cost- The change in the maintenance cost was 400 which was not much higher in comparison to those which was set in the plan.
Depreciation- The change in depreciation cost was 200 which is also not high in comparison to the planned budget.
Rent and rates – The rent and rates also increased by 100 so it also doesn’t have much changes with the cost which was determined in the budget.
Insurance – The insurance cost was increased by 1400 from which was much higher from those which was set in the plan (Pilleboue, Singh, Coeurjolly, Kazhdan & Ostromoukhov, 2015).

#### 2.2 Use performance indicators to identify potential improvements for ABC Ltd.

Production variance –The production variance was unfavorable as there was not much benefit for the company to manufacture the extra unit.
Sales revenue- There was neutral effect as the revenue per unit was 10 in the budget and actual.
Direct material- There was favorable variance as there was reduction in the per unit cost in comparison to set budget.
Direct labour- Direct labour cost was unfavorable as there was much increase in the cost from the set budget which reduces the revenue of the budget.
Maintenance cost- The variance in the maintenance cost is favorable as there is not much increase from the planned budget.
Depreciation- The variance in the depreciation cost was also favorable as there was not much changes from the planned budget (Ray & Jenamani, 2015).
Rent and rates – there was not much changes in the rent and rates from the planned budget so it is favorable variance.
Insurance- There was unfavorable variance in the insurance cost as the actual cost was much higher from the set budget.

#### 2.3 Suggest improvements to reduce costs; enhance value and quality to the ABC Ltd management accounting information.

Added value – The added value is defined as the difference between the particular product selling price and the direct and indirect input used in making that particular product. The budgeted profit of the ABC ltd. was 1900 and the actual profit was 6800 so the company is earning the higher profit in comparison to those which was set in the budget. To reduce the cost of manufacturing the company needs to make the effort to reduce the labour cost and the cost which is incurred on the insurance (Jena, 2016).
Total quality management- Total quality management requires use of strategy, data and communication to improve the quality of outcome. In TQM all the members of the organization participate in improving the existing process of the company to improve the quality of outcome. The key principle of TQM are

#### 4.1 Calculate variances for month 2, identify possible causes and recommend corrective action.

From the data given in the question following variances can be calculated
Material variance

• Material variance: standard cost – actual cost

672000-660000 = £12000 (favorable)

• Material price variance: standard cost of actual quantity-actual cost

720000-660000=£60000 (favorable)

• Material usage variance: Standard cost of standard quantity for actual production- standard cost of actual quantity

(11200-12000) X 60= £48000 (unfavorable)

Causes and recommendation:Favorable material variance shows that the material is used efficiently in the organization. It is shown that the material can be more efficiently used by reducing wastage.
Labour variance

• Laborvariance : standard cost – actual cost

288000-303360 = £15360 (unfavorable)

• Labor rate variance: standard cost of actual time – actual cost

284400-303360 = 18960 (unfavorable)

• Labor efficiency variance: standard cost of standard time for actual production – standard cost of actual time

288000-270000= 18000 (favorable)

• Labor idle time variance: difference between actual hours paid and actual hours worked at standard rate

284400-270000= 14400 (unfavorable)

Causes and recommendation:Labor variance is unfavorable which can be because of costly labor availability it can be resolved by proper training and efficient use of labor (Roper & Ruckes, 2012).

480000-480000= 0

• Variable overhead expenditure variance:actual hours X ( standard rate- actual rate)

15800 X (30-30.38) = 6000 (unfavorable)

• Variable overhead efficiency variance:Standard rate X (standard hours – actual hours)

30 X (16000-15800) = 6000 (favorable)

Causes and recommendation:Variable expenses can be controlled by efficiently using the resources.

210000-200000= 10000 (favorable)

207375-210000= 2625 (unfavorable)

Causes and recommendation
As fixed overhead variance is favorable it can be said that overhead are incurred efficiently
Sales variance

• Sales price variance: actual sales – standard sales

1800000- (8000X240) = 120000 (unfavorable)

• Sales volume variance: standard sales- budgeted sales

1920000- (8400X240) =96000 (unfavorable)

Causes and recommendation:Unfavorable variance of sales volume depicts that sales target are not achieved from the budgeted sales. It can be improved by proper training of the sales persons and by proper marketing schemes (Jamaludin, Shariffah, Mohammad & Ahmad, 2014).
Sales margin variance:

• Sales margin price variance: Actual margin – Standard margin

356640-448000=91360 (unfavorable)

• Sales margin volume variance: Standard margin – budgeted margin

448000-504000= 56000 (unfavorable)

Causes and recommendation:Company is not able to cover its margin so it is recommended that the company should try to reduce its direct cost so that margin can be improved.

#### 4.2 Prepare an operating statement reconciling budgeted and actual results.

 Budgeted sales 2016000 less: Budgeted material 705600 less: Budgeted labor 302400 less: Budgeted variable overhead 504000 less: Budgeted fixed overhead 210000 Budgeted Profit 294000
 Budgeted Profit 294000 add: Material Price variance 60000 Less: Material usage variance 48000 add: labor efficiency variance 18000 Less: labor rate variance 18960 Less: labor idle time variance 14400 add: variable overhead efficiency variance 6000 Less: labor overhead expenditure variance 6000 add: fixed overhead expenditure variance 10000 Less: Fixed overhead volume variance 2625 Less: Sales margin price variance 91360 Less: sales margin volume variance 56000 actual Profit 150655

#### 4.3 Report findings to management in accordance with identified responsibility centers

From the above calculation it can be concluded that the company is not able to match the budgeted figure with the actual results so it is recommended that they should employ efficient methods to improve their cost structure. Company should employ methods such as efficient labor utilization, efficient material usage by improved machinery for production, removing wastage of time, training of sales personnel (Archibald, Jacobs, Saad, Jevsevar  & Shea, 2015).

#### Conclusion

So it may be concluded from the above study that the cost analyze helps the management accounting to build control over various cost.  The budget used by the company help the management to build control over the various cost. It may also be concluded from the above study that the variance analyze helps in identifying the problem and helps in framing the budget for the future year.

#### References

Archibald-Seiffer, N., Jacobs, J.C., Saad, C., Jevsevar, D.S. & Shea, K.G. 2015, "Review of Anterior Cruciate Ligament Reconstruction Cost Variance Within a Regional Health Care System", The American Journal of Sports Medicine, vol. 43, no. 6, pp. 1408-1412.
Cottrell, T. 2014, "Transferring and teaching budgeting", The Bottom Line: Managing library finances, vol. 27, no. 1, pp. 6-10.
Diaz-Ordaz, K., Gomes, M., Grieve, R. & Kenward, M. 2013, "A comparison of multiple imputation methods for bivariate hierarchical data: an application to cost-effectiveness
analyse", Trials, vol. 14 Suppl 1, pp. O98-O98.
Gansemer?Topf, A.M. & Englin, P.D. 2015, "Contemporary Challenges in Student Affairs Budgeting and Finance", New Directions for Student Services, vol. 2015, no. 151, pp. 63-78.
Goldfeld, K.S. 2014, "Twice?weighted multiple interval
estimationof a marginal structural model to analyze cost?effectiveness", Statistics in Medicine, vol. 33, no. 7, pp. 1222-1241.
Jamaludin, Shariffah Zatil Hidayah Syed, Mohammad, M.F. & Ahmad, K. 2014, "Enhancing the Quality of Construction Environment by Minimizing the Cost Variance", Procedia - Social and Behavioral Sciences, vol. 153, pp. 70-78.
Jena, P.R. 2016, "Reform Initiatives in the Budgeting System in India: Budgeting System and Reforms in India", Public Budgeting & Finance, vol. 36, no. 1, pp. 106-124.
Li, X., Liu, H., Zhang, S., Mei, J., Xie, G., Yu, Y., Li, J. & Lakshmanan, G.T. 2014, "Automatic variance analysis of multistage care pathways", Studies in health technology and informatics, vol. 205, pp. 715.
Liang, Y. 2013, "Applying the generalized autoregressive conditional Heteroskedastic model to analyze and forecast the field failure data of repairable systems", International Journal of Quality & Reliability Management, vol. 30, no. 7, pp. 737-750.
Marie Hedlund, O. & Copeland, A. 2013, "Collection management and the budget crunch: are we adequately preparing library students for current practices?", Collection Building, vol. 32, no. 4, pp. 128-132.
Martinez-Sanchez, V., Hulgaard, T., Hindsgaul, C., Riber, C., Kamuk, B. & Astrup, T.F. 2016, "Estimation of marginal costs at existing waste treatment facilities", Waste Management, vol. 50, pp. 364-375.
Miao, J., Xu, X., Qiu, S., Qing, C. & Tao, D. 2015, "Temporal Variance Analysis for Action Recognition", IEEE transactions on image processing : a publication of the IEEE Signal Processing Society, vol. 24, no. 12, pp. 5904-5915.
Oikawa, S.M., Moala, F.A., Achcar, J.A., Baba, M.Y. &
Piratelli, C.L. 2013, "A useful empirical Bayesian method toanalyseindustrial data from saturated factorial designs", International Journal of Industrial Engineering Computations, vol. 4, no. 3, pp. 337-344.
Pan, J., Liu, J. & Zhu, C. 2015, "Budgeting carbon for urbanization in China: Budgeting carbon for urbanization", Wiley Interdisciplinary Reviews: Energy and Environment, vol. 4, no. 5, pp. 406-409.
Pilleboue, A., Singh, G., Coeurjolly, D., Kazhdan, M. & Ostromoukhov, V. 2015, "Variance analysis for Monte Carlo integration", ACM Transactions on Graphics (TOG), vol. 34, no. 4, pp. 1-14.
Ray, P. & Jenamani, M. 2015;2016;, "Mean-variance analysis of sourcing decision under disruption risk", European Journal of Operational Research, vol. 250, no. 2, pp. 679.
REKA, C.I., STEFAN, P. & DANIEL, C.V. 2014, "TRADITIONAL BUDGETING VERSUS BEYOND BUDGETING: A LITERATURE REVIEW", Annals of the University of Oradea: Economic Science, vol. 23, no. 1, pp. 573-581.
Roper, A.H. &
Ruckes, M.E. 2012, "Intertemporal capital budgeting", Journal of Banking & Finance, vol. 36, no. 9, pp. 2543.
Shea, K.G., Archibald-
Seiffer, N.M., Jacobs, J., Saad, C., Hooft, L. & Humphreys, B. 2014, "Variation in Health Care Cost: Quality, Utilization, and Efficiency Review for ACL Surgery Cost Variance Within a Health Care System", Orthopaedic Journal of Sports Medicine, vol. 2, no. 2_suppl.

For complete copy of this solution, order now from Assignment Help