Unit 5 Management Accounting Sample Assignment

Unit 5 Management Accounting Sample Assignment

Unit 5 Management Accounting Sample Assignment

Task 1

1a) Calculation of Prime Cost

Prime cost is the sum of the direct material cost and direct labour cost

 

Therefore, Prime Cost

 

In £

 

Direct Material cost

 

314.865*

 

Direct labour Cost(Given)

 

142.16

 

 

Prime cost

457.025

 

Direct Material Cost

 

 

 

 

Quantity (in Kgs)

Rate/kg ( in £)

Total (in

Material J

21.4

 

304.69*

Material Q

3.7

2.75

10.175

Direct Labour Cost

 

 

 

 

Number of hours worked

Rate per Hour (In £

Total cost

Grade IV labour

16

4.78

76.48

Grade VIII labour

8

8.21

65.68

           
 

*Note: Please Refer WN1

WN1

Calculation of cost of Material J transferred to Job Code X423

Date

Activity

Quantity

Rate

Total

1-Sep

Opening balance

28.7

14.3

410.41

8-Sep

Purchase

30

14.2

426.00

18-Sep

Transfer to production job code X431

-20.6

14.3

-294.58

21-Sep

Transfer to production job code X423

8.1

14.3

115.83

21-Sep

Transfer to production job code X423

13.3

14.2

188.86

 

1.b) Prime cost per component

Calculation of prime cost per component

Material

69%

Labour

31%

 
1.c) Inflationary element in the figures

i) Conversion of cost per kilogram to Index number

 

March

August

Cost per kilogram

£8.90

£11.80

Base rate ( January 2014)

£9.20

£9.20

Index

97

128

 

ii) Calculation of expected cost for December 2014

Index number for Dec-14

142

Base Cost (January 2014)

9.2

Expected cost

13.1

 

iii) Calculation of Percentage increase in the cost per kilogram of Material J from January 2014 to December 2014

Month

Cost per kilogram

Jan-14

£9.20

Dec-14

£13.06

 

The formula for calculating the percentage increase in the cost is as follows

((B-A)/A*100)

Where A is the starting year a 'B' is the ending year. January 2014 being the starting year and December 2014 is the ending year.

We have ((13.06-9.20)/9.20*100)

Therefore, percentage increase by 42%

1.d) Brief Notes on Different costing Methods

We have discussed the different types of costing. now it’s time to apply them to practicality. Let’s know the applications of all the categories of costings.

The main applications can be described as: FIFO and AVCO.

Talking of a conventional approach toward the process of costing, it is believed that the period that a good might sustain staying at a warehouse tags its priority to move out of the warehouse. It is also said that after the process of manufacturing, it must be sent to the end user i.e. customer.

But, why such a restless method is preferred?

It is believed according to FIFO that the manufactured product should not be kept idle at the warehouse as a certain level of depreciation is involved with it and erosion of the product is also possible.

What is AVCO?

Talking about AVCO, it is stated that a product can be weighted as the rough average of the available products that are kept in warehouse. Hence, if a product exceeds or precedes the level of weightage, it is to exit the warehouse prior to others.

What is Activity Costing Process?

As per the activity costing process, the cost that is involved in each stage of the process should form an inclusion in the whole process and in per unit cost. This takes into account the activities that are included in the process of production and management. (Izhar and Hontoir, 2001)

Task 2

2. A) Techniques could be used by AA (Ace Accountant)

As the 3D Game AA is about to be launch during the peal selling season, the merits and demerits of the gaming program can be analyzed by using the Life Cycle Costing technique in the following way.

The fixed costs and variable costs of product manufacturing are involved in the Life Cycle Costing. It is necessary to have a competitive edge over the rivals to survive in the competitive market. The overall revenue and costs throughout the estimated life of the product needs to be calculated so as to determine the feasibility of the product which depends upon the profitability of the product during the life span of the product. In case of the Life Cycle Costing following techniques can be used:

  1. To uphold the uniqueness and to attract a particular group of people, proper survey should be done to installation, upgrade and modify the AA 3D Game because it needs a higher cost and a high level of data charges cost is involved.
  2. To deliver a user friendly gaming program, proper R&D team should be there to upgrade the game and also to ensure that the present and future expenses are not more than the revenue.
  3. The future supplies of game in every part of the targeted region and also the customer satisfaction should be properly analyzed.

The characteristics of target costing are summarized as:

  1. Target Costing signifies that when a new product is launched in the market there should be minimum recovery of the costs to ensure profitability.
  2. To ensure the smooth formulation of the next step of management planning, there is concentration on a target customer for a certain period of time to cover targeted revenue amount.
  3. The primary objective is to cover the total installment cost not at a glance but gradually with the increase in the market share over a period of time. (Dhillon, 2013)

2. B) Target costing for the new game LL

To calculate the target costing for the new game LL includes following:

=Target Selling Price per customer x lifetime sales volume

= 200000x55

= 1100000

To reach the target BEP, the firm has achieved the target of 1100000. The disadvantages of live dream are as following:

  1. If the 3D game has been launched already and it has become a popular game, so the customers would expect high from the next game LL. The popularity of 3D game provides a chance of a good opening of the new game launch LL, but at the same time creates the chances of its comparison with the 3D game. Thus if the new game fails to impress the customers, its sales might drop as a consequence.
  2. Hardcore advertising is needed to promote the second game if the first game is a failure.
  3. Thus there are high costs of developing and advertising in the gaming business.

2. C) TQM and Kaizen used by Live Dream

TQM is a management technique that involves all the employees from labor to management of the company to deliver quality products. It is a participative technique that makes the employees to associate themselves with a common project of the company. Kaizen approach is a part of TQM technique that mainly supports the existence of all class of employees in the company. This technique can be used by LIVEDREAM that will lead the company in the following manner:

  1. With the proper co-ordination of the R&D team with the sales team the product can be sold in the market with greater efficiency.
  2. There should be proper co-ordination in the after sales service team, sales team and the R&D team to ensure proper feedback and maintenance of the game.
  3. The policy formulation and SWOT analysis should be conducted with the respective teams by the management.

2. D) Quality Performance indicators to monitor cost

LIVEDREAM manufacturing process is inclusive of constant development of the product. Few of the methods to reduce the cost are as following:

  1. There should be contractual hiring of the R&D team and their research work should be applied on the periodical basis on the game.
  2. There should be direct or indirect revenue generation in the form of money spending from the buyer side or installation cost from the game up gradation. (Braggs, 2010)

    Contact us

    Get assignment help from full time dedicated experts of Locus assignments.

    Call us: +44 – 7497 786 317
    Email: support@locusassignments.com

    BTEC HND Assignment Experts

Task 3

3.a) Cash flow statement and Budgeted Income and Expenditure statement for the first Quarters

Cash flow statement for the period April-June'14 for Alpine Tours

 

April

May

June

Receipts

£

£

£

Opening balance

 

11221.25

16963.75

Sales revenue per trip

26520

26520

 

 

 

 

 

Total receipts

26520

37741.25

16963.75

Payments

 

 

 

Hotel cost

8478.75

16957.5

8478.75

Coach cost

3600

3600

 

Insurance bond cost

3000

 

 

Telephone cost

 

 

380

Sundry office expense

220

220

220

Total payments

15298.75

20777.5

9078.75

Net balance

11221.25

16963.75

7885

 
Budget Income statement for the period April -June'14

REVENUE

£

Sales Revenue

53040

Total (A)

53040

EXPENSES

 

Hotel cost

33915

Coach travel cost

7200

Insurance bond

3000

Telephone

380

Sundry office cost

660

Depreciation

100

Advertisement Expenses

3000

Total (B)

48255

 

 

Net profit (A-B)

4785

 

Below summed up is the justification for using overdraft facility of a bank:

What is the necessity of inflow and outflow form of cash?

In a business, it is nothing to say that cash is an important criterion in any of its stage; and here, we will take the concept of inflow and outflow for of cash flows. The inflow form refers to the source whereas, outflow form of cash flow refers to the point of implication. It is utmost importance to the bank manager when he should be keeping records of both the forms of cash flows.

What more should the bank consider when it comes to keeping record of the payment?

The bank should be in a position to understand the parties that are involved in the process of transaction, the amount of the money and also, the exact time when the transaction came into effect. Through this, they can exactly estimate the ratio of customer-organization relationship.

What do you mean by Consistency In Revenue?

This is quite essential in the field of business. This gives the trend of the revenue; for example, if there is an uptrend in the revenues, this implies an increase in the level of revenues that is earned by the business.

What are the importance of Costs or Expenditure?

These are integral elements in the process of a business and are useful components of a income statement. This gives us an estimation of the fixed and the costs that are still recurring and is therefore, examined by the bank.

What is the concept of Determination of Limit?

The bank is able to sum up a certain amount that is to be expended and hence, can determine its utility in the business activities and also consider the need for credit for the overall business. This is determined by the bank itself.

What does the available cash balance study imply?

This refers to the cash that is available when the operating cash and investing cash are incurred on the activities. At a certain moment, this needs to be determined for running the business activities of an organization. (Mahadevan, 2010)

3.b) Purpose and nature of Budgeting.

The purpose and nature of budgeting will be described in this section. This will give you a fair idea of how the process is implemented and then, driven for the sake of the business.

Budget can be simply defined as the process that is able to allocate the available assets to the departments of a business. In response, the management of an organization is considered to bring them into effect. Now moving to the next step, it is worth considering that proper planning and implementation is required for achieving the set objectives in a business. This eliminates any kind of difference in the organization and establishes a harmonious environment within the company.

Apart from this, Budget is often associated with finance in any organization, Its aim is to allocate the funds of a company to the respective departments of the company and this is performed before the financial year begins. Now, even if any alteration takes place in a team, it’ the sheer duty of the management of the organization to modify and amend changes in the budget plan of the company or that particular department. Before the stage of execution, budget centre is set up which decides its formulation and an in-depth study is conducted regarding the flow of cash within and out of the organization.

There should be proper coordination in every department and the whole company as well. A manager leads the team who needs to step up during crisis moments and might have to hold the responsibility of controlling other teams as well in crucial situations. The allocation of funds is further done on the basis of priority. Moreover, the budget can prove to be extremely helpful in determining the overall capability of different units of departments. The thing that is the most needed is a coordinating approach among the members of the organization. (Wildavsky, 1986)

Task 4

4.i) Flex budget

 

 

Original budget -800units

Standard cost

Flexed budget 900units

Actual cost -900units

Total variance

 

£

£

£

£

£

Materials

 

 

 

 

 

2kg x£6.60 x 800units

        10560

        13.2

         11880

       14580

5400U

Labour

 

 

 

 

 

1hr x £8.25 x 800units

 

6600

8.25

        7,425

       8550

1950U

Fixed overheads

        12,800

4

        12,960

     19,400

6600U

 Variable overheads

       4800

1.5

5400

7400

2600U 

Selling and administration overhead variance

3000

 

300

2800

   200F

Sales

 

 

 

 

 

800units x £68.5

       54800

68.50

61650

     61650

6850F

 

4.ii) Calculation of Variances

a.Sales Profit volume Variance

b.Sale Price Variance

c.Direct Material Variances

  1. The material price variance is expressed as;

             (Actual price x Actual quantity purchased) – (Standard price x Actual quantity purchased)

                        £14580– (£6.60 x 1,800kg) = £2700 U

ii. The material usage variance is expressed as;

            (Actual quantity x Standard price) – (Standard quantity x Standard price)

                        £11880– ((2kg x 800) x £6.60) = £1320 Unfavorable

  1. Direct Labour Variance

 i.   The labour rate variance is expressed as;

            (Actual wage rate x Actual hours) – (Standard wage rate x Actual hours)

£8550 – (£8.25 x 900hrs) = £1125 Unfavorable

      ii. The labour efficiency variance is expressed as;

            (Actual hours x Standard wage rate) – (Standard hours x Standard wage rate)

            (£8.25 x 900) – ((1hr x 800) x £8.25) = £825 Unfavorable

  1. Variance Production overhead variance

      i. Variable Overhead variances

                The Variable spending overhead variance is expressed as:

               (Actual hours worked x (Actual Overhead rate-standard overhead rate)

               3600(2.05-1.5) = £2000 Unfavorable

            ii. The Variable Efficiency overhead variance is expressed as:

                 Standard Overhead rate (Actual hours-standard hours)

                 1.5(3600-3200) = £600 Unfavorable

       f. Fixed Production overhead variance

       i. The fixed overhead expenditure variance is expressed as;

          (Budget fixed overhead cost - Actual fixed overhead expenditure in the period).

          £12800 - £19400 = £6600 Unfavorable

      g. Selling and administrative overhead variance

      i. The sales price variance is expressed as;

  (Actual selling price x Actual sales volume) – (Standard selling price x Actual sales volume)

 £61650 – (£68.50 x 900) = 0

    ii. The sales margin volume variance is expressed as;

(Actual sales – Budgeted sales) x standard profit margin

  (900 – 800) x £68.50 = £6850Favourable.

4.iii) Standard cost operating statement

Operating Statement

 
 

 

Favourable

Unfavourable

£

 

Budgeted profit 8,00units x £21.3)

 

 

17040

 

Sales price variance

 

 

 

 

Sales margin volume variance

6850

 

 

 

Material price variance

 

2700

 

 

Material usage variance

 

1320

 

 

Labour rate variance

 

1125

 

 

Labour Efficiency Variance

 

825

 

 
 

Variable Efficiency Overhead Variance

 

2000

 

 

Variable Overhead Spending Variance

 

600

 

 

Fixed overhead expenditure variance

 

6600

 

 

Selling and administration overhead

200

 

 

 

Total variances

7050

-15170

-8120

 

Actual profit

 

 

8920

 

4.iv) indifferentist among Statements

Aim:

The objective is to introspect the reasons that result in variance.

Findings:

In order to accomplish the mentioned objective, we need to find out the costs that are incurred on each department and unit of production in the organization. This can be best reflected through budget statement. Now, the problem is that there have been slight differences between the estimated and the actual results. 

Estimated Result: Profit of 17040

Actual Result: Profit of 8920

Below given is the reason for such a variance:

Sales Manager is responsible for Sales Margin volume variance. Actual sales exceeded estimated sales by 100 units.

Buying Manager is responsible for Material price Variance. Procurement took place at higher rates than it was budgeted.

Production Manager is responsible for Material Usage Variance. An exceeding level of sales were observed.

Labour rate Variance is looked after by HR Manager. It showed negative variance with a higher per hour procurement rate.

Labour efficiency variance witnessed no variance with an increase in actual sales by 100 units.

Variable overhead Efficiency variance is supervised by Operations Manager. Total Overhead showed negative variance.

Fixed overhead expenditure variance is looked over by a number of managers. Overhead was more than estimated.

Selling and distribution overhead variance is overlooked by a Sales Manager. It witnessed better Total Overhead.

Conclusion

Through this, we come to know the factors that resulted into such a variation.

Conclusion

An organization needs to focus on the costing patterns for a relatively smooth working. This can turn out to be a matter of concern if not taken into serious consideration. This can be quite decisive for any organization, if decision making is associated with it. Standard costing methods are used by the organizations to get the actual results and also get to know the reasons behind certain variances in the estimated results.

References

Dhillon, B.(2013). Life Cycle Costing: Techniques, Models and Applications. Gordon and Breach Science Publishers.
Bragg, S. (2010). Cost reduction analysis. Hoboken, N.J.: John wiley & Sons.
Izhar, Riad and Hontoir, Janet (2001). Accounting, Costing and Management. Oxford University Press.