Calculate operational variances -planning variances, Basic Statistics

Assignment Help:

You have recently joined XYZ, an international company that produces a wide range of office supplies and stationary goods. In your new role as Group Management Accountant your first focus of attention is the performance of a recently acquired division – Ecover - that designs and manufactures travel cases for electronic equipment. This acquisition was part of the group’s strategic decision to diversify and increase its product range. You are currently reviewing the first quarter results for the divisions newly launched e-reader cover which is referred to as product RG13. The profitability of this product is well below expectations, and the performance of the division as a whole is under scrutiny.

 From an initial review of the internal budgeting and performance reporting processes of the division you have gathered the following information.

 The budget process starts 4 months before the year end.

  • Draft budgets are prepared by the finance department and are sent out to operational managers for comment.
  • Standard cost information, which is reviewed annually, is used to calculate production costs while current year actuals are used as a basis for determining non production costs.
  • Senior management are responsible for setting budget targets.
  • Budget targets are the basis for determining performance related incentives.
  • Excel spreadsheets are used for all areas of the budget process.

Although the master budget is fixed once finalised, the division do undertake some basic variance analysis and compare actual operational results to a flexed budget. The level of variance analysis conducted is limited to total material, labour and production overhead variances. The quarterly variance statement is given in Appendix 1.

When managers have been asked to explain these variances they have blamed poor decisions at the planning stage or the use of incorrect standard cost data. Understandably, senior management are not satisfied with this situation and have asked you to investigate the variances further by quantifying the impact of both planning errors and operational variances. In addition to this, you also intend to raise some other issues at the next management meeting regarding the quality of quarterly reporting and the division’s approach to preparing budgets and variance analysis.

For this purpose you have gathered information on the actual costs for the period, the original standard costs used to prepare the budget and have calculated more accurate, up to date revised standard costs. This information is contained in Appendix 1.

Required:

 a)   Calculate the following operational variances and planning variances (where applicable):

 ·         Direct material cost

·         Direct material usage

·         Direct labour rate

·         Direct labour efficiency

·         Variable overhead efficiency

·         Variable overhead expenditure

 b)   Prepare a commentary on the findings of the operational variances calculated above.

c)   Prepare a revised budget profit statement (supported by relevant budget schedules) for the second quarter using the revised standard cost information and forecast sales information given in appendix 1.

 

 Ecover – product RG13

Reconciled actual profit to budget profit for the first quarter:

 


           £

Flexed budget operating profit

 

108,355

Total direct material variance

31,059A

 

Total direct labour variance

 

36,874A

 

Total variable overhead variance

 

9,024A

 

Fixed overhead variance

 

12,000A

 

Actual operating profit

 

19,398

 

Supporting information:

 Budgeted sales volume for first quarter was 40,000 units but only production and sales of 36,800 were actually achieved. The selling price remained the same as budget at £20.50 per unit.

 

Actual Costs for the first quarter

Material

Cost

Quantity per unit

Leather

£9.15 per metre

0.09 metres

Plastic

£2.35 per metre

0.14 metres

Magnetic fastening

£2.45 per metre

0.10 metres

 

 

 

Labour

Rate

Hours per unit

Skilled

£15.85 per hour

0.17 hours

General

£10.25 per hour

0.28 hours

 

 

 

Variable manufacturing overhead

Total £76,000 for the quarter

 

Standard Cost Card

Material

Cost

Quantity per unit

Leather

£7.10 per metre

0.04 metres

Plastic

£1.85 per metre

0.11metres

Magnetic fastening

£2.20 per metre

0.03 metres

 

 

 

Labour

Rate

Hours per unit

Skilled

£15.50 per hour

0.20 hours

General

£9.75 per hour

0.15 hours

 

 

 

Variable manufacturing overhead

£5.20 per labour hour

 

Revised Standard Cost Card

Material

 

Cost

Quantity per unit

Leather

£8.20 per metre

0.07 metres

Plastic

£2.10 per metre

0.16 metres

Magnetic fastening

£2.60 per metre

0.08 metres

 

 

 

Labour

Rate

Hours per unit

Skilled

£15.50 per hour

0.18 hours

General

£9.75 per hour

0.12 hours

 

 

 

Variable manufacturing overhead

£5.90 per labour hour

 

Information required for revised second quarter budget:

 Sales forecast for the second quarter is 50,000 units

  • Forecast selling price is £13.50 per unit
  • No opening stock of finished goods
  • Target closing stock of finished goods is 5,500 units
  • Closing stock of raw materials is estimated to be equivalent to one week’s production
  • Opening stock of raw materials is given below
  • Fixed overheads are forecast to be £178,000 for the quarter.

   


Stock held at beginning of second quarter

Leather

2,850 metres

Plastic

3,150 metres

Magnetic Fastening

8,260 metres

 


Related Discussions:- Calculate operational variances -planning variances

Probable, how do you interpret the correlation on the basis of probable err...

how do you interpret the correlation on the basis of probable error

The number of degrees of freedom, Use the given information to find the num...

Use the given information to find the number of degrees of? freedom, the critical values chi Subscript Upper L Superscript 2?2L and chi Subscript Upper R Superscript 2?2R?, and the

Explain the attribute accounting, Explain the Attribute Accounting Plann...

Explain the Attribute Accounting Planning the accounting on foundation Producing, Explanation and outlining for customers is an art and if we consider as per technology, the sig

Sample space of an experiment, 1.The resumés of 2 males applicants for a co...

1.The resumés of 2 males applicants for a college teaching position in chemistry are places in the same file as the resumés of 2 female applicants. Two positions become available a

Explain what is signal reliability ration, A. If CD players are able to use...

A. If CD players are able to use the LDD strategy better than pure chance then explain what happens to the signal reliability ration as a CD player detects more cautiously B. As

Application of statistics, Mention the characteristics of Statistics. Expla...

Mention the characteristics of Statistics. Explain any two applications of Statistics

Define why equipment show up on a profit and loss statement, Define why Equ...

Define why Equipment show up on a profit and loss statement? The buy of devices that will be used in a business is not revealed on the revenue and reduction declaration. Howeve

Budgeting, What is the basis for factory overhead absorption

What is the basis for factory overhead absorption

Cost accounting question, LO.1 (Activity analysis) The Raleigh plant manage...

LO.1 (Activity analysis) The Raleigh plant manager of Allentown Corp. has noticed the plant frequently changes the schedule on its production line. He has gathered the following in

Depreciation, X purchased a machinery on instalment system for rs.27300 to ...

X purchased a machinery on instalment system for rs.27300 to be paid as follows. on delivery rs.8000, at the end of first year rs.7600, at the end of second years.6000, at the end

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd