Qualification - Higher National Diploma in Business (RQF)

Unit Name - Management Accounting

Unit Number - Unit 5

Unit Level - Level 5

Assignment Title - Management Accounting

Learning Outcome 1: Demonstrating and understanding of management accounting system.
Learning Outcome 2: Appling a range of management accounting techniques.
Learning Outcome 3: Explaining the use of planning tools used in management accounting.
Learning Outcome 4: Comparing ways in which organisations could use management accounting to respond to financial problems.

Scenario

ABC Co. Ltd. specialises in manufacturing electronic products. The range comprises of 2 products, Personal Computers (‘PC') and Video Players (‘VP'). The company's products have the data shown below.

Get Unit 5 Management Accounting - Higher National Diploma in Business (RQF) Assignment Help By Miracleskills.Com

1. You need to advise the manager the following issues:

• Explain the meaning of management accounting, various management accounting tools and role of management accountants

Solution:

The proposal is explained the analyzing the points in following sub parts:-

Definition Analysis
Management accounting is a process which helps in assisting the managers of all departments in a correct manner which may lead to assist in better planning, controlling and analysis of organizational goals. It helps in justifying the factor which may lead to focusing of the fixation of responsibility and help in justifying the important area.

Role of Management accounting helps in the budget formation along with the deviation analysis along with helping of the reasons which may lead to assist the Variance analysis as well as assuring that the corrective actions is being taken on right time to avoid any future problems. Various management accounting tools can be as follows:- financial planning, financial statement analysis, cost accounting methods, fund flow analysis along with cash flow analysis. It includes the budgetary control concepts as well (Weetman, 2019).

• Explain the classification of costs that would help the management decision-making

Classification of cost which will help decision making can be done on a border basis as follows:-

The Cost Classification by Nature, the Cost Classification by Relation to Cost Centre, the Cost Classification by Functions and the Cost Classification by Behavior and then the Cost Classification by Management Accounting Decision Making , the other is the Cost Classification by Production Process and the last by the Cost Classification by Time (Weetman, 2019).

Also read: Contrast different organisational structure and culture Assignment - Rest assured, we uphold uncompromising quality standards, ensuring top-notch work delivery.

• Calculate the unit costs of PC and VP based on absorption costing and marginal costing methods

Computing the unit costs

Absorption Costing PER UNIT

Particulars

PC

VP

Direct material Cost

 $ 600

 $ 800

Direct labor Cost

 $ 200

 $ 400

Other variable overhead Cost

 $ 200

 $ 200

Absorbed factory overhead Cost

 = $ 2400000 / $ 30000 * 2

 = $ 160

 $ 320

Unit cost expense

 $ 1160

 $ 1720

Marginal costing per unit

Particulars

PC

VP

Direct material expense

$ 600

 $  800

Direct labor expense

 $ 200

 $ 400

Other variable overhead expense

 $ 200

 $ 200

Unit cost per product

 $ 1000

 $ 1400

• There is a special order for 10,000 units of PC at $1050 per unit:
o which costing method should be used for the accept or reject decision;
o calculate the costs using the costing method recommended above
In case of the special order where the special order for 10,000 units of PC at $1050 per unit
The unit cost will be determined as follows:-
No of units * Unit cost per product of PC marginal Costs per unit
= $ 1000 * 10000 = $ 10000000
( $ 1000 will be taken as the per unit cost of PC under the marginal costs method as only as per
this method the special order will help us earning revenue by $ 50 per unit - $ 1050 -$ 1000).

• given that direct labour available is limited to 60,000 hours per month, advise the optimum production mix of PC and VP to maximise profit

Optimum product mix when the direct labor hours is maximum Restricted by 60000 Hours

Particulars

PC

VP

Selling price per unit 

$ 1200

$ 1600

Costing of the product less value

$ 1000

$ 1400

Contribution price per unit ( Selling Price - Costing Price)

$ 200

$ 200

Labor cost per hour per unit = 

2

4

Contribution based on the direct labor cost  - Contribution / Labor cost 

 $ 100

$ 50

Preference Ranking

1st Preference

2nd Preference

Monthly  maximum demand in units which can be achieved

10000 units

20000 units

Number of labor hours used for PC production - as First preference is given to PC units the labor hours will be used accordingly. 

20000 Hours  ( 10000 Units * 2 per hour)

 

Labours

= 60000 Hours - 20000 Hours used in PC UNITS

= 40000 Hours

 

No of units which can be produced by 40000 Hours

 

= 40000 Hours /2

= 20000  Units

Optimal Mix will be maximum 1ST 10000 Units of PC and the 2nd 20000 Units OF VP is the best option to attain maximum profits.

Also read: Boarding luggage related rules and regulation - Trust in our flawless assignment assistance to complete your tasks effortlessly, free from stress!

• calculate the break-even units of IP and if the manager is confident that a target profit of $1,200,000 is achievable, what would be the corresponding target units sold

Compute the Break even Units of IP and compute the target unit sold when profit to be achieved is $ 1200000.

Particulars Amount

 Value

Fixed cost as stated for the product

$2400000

Contribution per unit Of IP ( Given)

$600

Break-even point in units = Fixed Cost  / Contribution Per Unit

 4000 units

( $ 240000 /    $  600)  = 

 To attain the desirable profits the target can be achieved as follows :-

 

Target profit

$1200000

Desired contribution can be achieved

 

 (Fixed Expense + Desired Profit ) /   Contribution Per Unit  = Desired number of units required for the particular profits

  $  1200000+ $ 2400000

= $ 3600000 / 600 =

 6000 Units

• evaluate the proposal to spend an additional $600,000 to promote the IP so that selling price can be increased by $60 per unit to sell 6,300 units per month and discuss the corresponding pricing decisions

Evaluation of Proposal when the selling price can be increased by $60 per unit to sell 6,300 units per month

Particulars

Value

Number of units of IP to estimated in Proposal per month

 6300 units

Total units to be given for an 3 months = 6300 units  * 3 months 

  18900 units

Revised contribution as the selling price is increased by $ 60 per unit

= $ (600+60) = $ 660 * 18900 units

IP contribution

= $ 12474000

 Less :  Additional fixed cost incurred

   $  600000

Net profit after new proposal as per 3 months

$11274000

Prepare a proposal to advise the manager who has no management accounting knowledge and background.

In terms with the estimation explained above the proposal must be approved and the following aspect must be assured which must be accepted in terms with the due consideration that are listed as following factors as explained below:-
1. It is necessary to understand that when the proposal is accepted it must not harm or effect the capacity of the current or the running capacity in any given manner. Also it may not affect the production capacity in near future as well.
2. The other point which must be clear is that the market demand of the current and the existing products must not be hampered or disturbed.
3. The last effect which must be kept in mind is that the working conditions must not result in an adverse manner or condition.

Need Business Assignment Help!! Miracleskills.Com Ready For You!!

Question 2:

In nut shell all the elements must be achieved however, the existing and the current situation must not be hampered and the current working must be successfully run without any disturbance and problems.

Part A:
Analyse and evaluating ABC's financial performances by using the various management accounting technique, and make the possible recommendations in dealing with the financial problems and the price strategies in revising its price

Solution:

The financial performance of the company is explained as below in a mathematical explanation :

Particulars

Personal Computer Product

Video Players

Direct material cost per unit

$ 600

$ 800

 Add: Direct labor cost  per unit

$ 200

$ 400

 Add: Other variable overheadcost per unit

$ 200

$ 200

 Total Per Unit cost of the Product 

$ 1000

$ 1400

Selling Price of per unit

 $ 1200

 $ 1600

Contribution per unit ( Selling Price  - Unit Cost per product computed as above )

$ 200 ( $ 1200 - $ 1000 )

 $ 200 ( $ 1600 - $ 1400)

Total contribution = Total Unit * Contribution per unit. 

 ( $ 200 * 10000 Units )

   =  $  2000000

 ( $ 200 * 20000 Units )  = $ 4000000

Total contribution of both products of PC + VP

$ 6000000  =

   ( $ 2000000 + $ 4000000)

 

Less: Fixed cost is calculated as follows : -

    $  200000

 

Net profit computed  =  

  Contribution - less Fixed Costs

$  58, 00,000

 = $ 6000000 - $  200000

 

In connection with the management accounting of the marginal costing

On Basis of the Absorption Costing

Particulars

Personal Computer Product

Video Players

Direct material cost per unit

$ 600

$ 800

 Add: Direct labor cost  per unit

$ 200

$ 400

 Add: Other variable overhead cost per unit

$ 200

$ 200

Add:  Absorbed factory overhead cost per unit

 $ 2400000 / 30000 *2 

   = $ 160

   = $ 320

 Total Per Unit cost of the Product 

$ 1160

$ 1720

Selling Price of per unit

 $ 1200

 $ 1600

Contribution per unit ( Selling Price  - Unit Cost per product computed as above )

$ 40 ( $ 1200 - $ 1160 )

-          $ 120 ( $ 1600 - $ 1720)

Total contribution = Total Unit * Contribution per unit. 

 ( $ 40 * 10000 Units )

   =  $ 400000

 ( $ -120 * 20000 Units )

  = ($ 2400000)

Total contribution of both products of PC + VP

$ - 2000000  =

   ( $ - 2400000 + $ 400000)

 

Add back : Fixed cost is calculated as follows which balanced of the factory cost : - as extra cost is absorbed

    $  78000000  =

 = ( 160* 10000 + 320 * 20000) - 200000

 

Net profit computed  =  

  Contribution - less Fixed Costs

$  58, 00,000

 

(Kaplan, and Atkinson, 2015)

As per analysis the same results is achieved therefore, any strategies can be opted to achieve the desirable results.

Part B: Budgeting Process:

• the major functions of budgeting process (3.1)
• the advantages and disadvantages in operating a budgetary control system (3.1);

The Major Functions of the process are listed as follows:-
Firstly it helps in proper and rightful planning, and the other is that the level of coordination which being that the business must be right perspective. The other is that the communication which must be aimed in terms with the objectives of the company. On the more, it will help in evaluating performances as well as the business management process.
Advantages Include the following: -
- The objective is properly defined and managed.
- Controlling activities in connection with the proper evaluation.
- It assist in elimination of waste and abnormal costing (Weetman, 2019).

Disadvantages Include the following: -
- It Involves the high cost.
- It is difficult not to manage time period in time of inflation.
- Lack of support in connection with the management as well as failure lead analysis.

Also read: Procedures to resolve the different conflicts - Miracleskills stands as the premier destination for diploma assignment help.

Part C: Budgetary Planning:

• whether fixed or flexible budgets should be prepared for the coming January to March (3.1)
• based on information provided in question, prepare the monthly budgets as follows: (3.1, M3)
o sales budget
o cash collection budget from sales (assuming 40% of current month sales being paid within the same month with the remaining 60% payable in the following month)
o production budget (assuming monthly production units equals to monthly sales units)
o raw material purchase budget (assuming the company purchases the exact quantity of raw material in each month to meet the monthly production requirement)
o cash payment budget for raw material purchases (assuming payment being made in the month following the month of purchase)
• prepare the monthly cash budget (assuming that the only other item is cash payment of $300,000 in January for the purchase of production equipment and that the projected cash and bank balance as at 1 January is $20,000) (3.1, M3)

Solution:

The flexible budgets must be prepared as the same can be bifurcated and computed with the difference of the productions and the price variation. The monthly budgets are stated as below:-

Particulars

January

February

March

Cash balance at the beginning

$ 20000

$ (16,20,000)

$ 3,60,000

 Add : Collected total value

 $  21,60,000

 $  24,00,000

 $ 27,20,000

Less :  Purchase Pricing

$  35,00,000

$ 42,00,000

$ 42,00,000

Less Cost of Equipment purchase

$ 300,000

 

 

Balance at the end of the Year

-          $ (16,20,000)

$ 3,60,000

$ 26,60,000

Budgets for Selling price

Month

 January

 February

 March

Units produced in numbers

$  3000

$ 3000

$ 4000

Sale Value per unit

 $ 800

 $ 800

 $  800

Total Sale Price = Units * Selling Price

$ 2400000

= ( $ 3000 * 800 )

$2400000

  = ( $ 3000 * 800 )

$3200000

  = ( $ 4000 * 800)

Budget for Cash Collection Pricing

Month

 January

 February

 March





Total Sale Price as computed Above

 $ 2400000

 $ 2400000

 $ 3200000

  ADD : A Collection of Cash in the same month

$  960000

$  960000

$  1280000

 ADD: B Collection of Cash in the next Month - 60 %

( $ 2500 * 800 * 60 %)

= $ 1200000

  $  1440000

( $ 2500 * 800 * 60 %)

 $  1440000

( $ 2500 * 800 * 60 %)

Collection of Total Cash  (A+ B)

   $ 21,60,000

  $   24,00,000

  $ 27,20,000

Budget for Production

Month

January

February

March

Production in  Units

3000

3000

4000

Budget for Purchase of Raw material

Month

January

February

March

Production in units

3000

3000

4000

Per unit of Raw material per product

 $ 2

  $ 2

 $  2

 Raw material total value

$  6000 =

( 3000 *2 )

$ 6000 = (3000 * 2)

$ 8000 =

( 3000 * 2)

 Final Value of material

$420000

$420000

$560000

Get Unit 4 Research Project assignment solution - Collaborate with a tutor to achieve excellence through our Unit 4 Research Project assignment help service, tailored for Level 4 in business studies!

Part D: Budgetary Control:
• if the actual purchase and usage of raw material amounted to $435,600 in January, calculate the raw material variance (4.1)
• it is found that the actual purchase price of raw material is $66 per unit and the actual purchase and usage quantity is 6,600 units to produce 3,000 units of IP in January. Compute the raw material price and usage variances to analyse the raw material variance in question (4.1)
• prepare a cost reconciliation statement reconciling budgeted and actual raw material costs for the month of January (4.1)
• it is discovered that raw material was purchased in January from a new supplier not on the company's approved vendor list. Report your findings to the manager in accordance with the responsibilities of the relevant departments and recommend possible corrective actions for the identified variances (4.1, 4.2, M3 and M4).

Solution:

Raw Material Variance = $ 4, 35,600 - $ 4, 20,000(Actual Price - Budgeted Price) = $ 15600 Adverse.

Basis

Value

Price - Actual (AP)

 $ 66

Price  - Budget (SP)

  $ 70

 Price variance for the Raw Material

  (SP - AP) AQ 

 =( $ 70 - $ 66 )*6600

=  $ 26,400 F

 

 Usage variance for the Raw Material

( SQ - AQ ) SP

= (6000 Units -6600 Units )* $ 70

= 42000 Units A

Reconciliation analysis of the actual and the budget cost

Basis

Value

Cost Budgeted

$ 4,20,000

Less : price variance of material

$ 26,400

Less: Usage variance of Material

$ 42,000

Cost Achieved in actual terms

$4,35,600

Recommendations for corrective actions and responsibilities of manager
In the above conditions it is expressed that the manager must purchase the material from the standard and a given authorized supplier which checked and properly attained. Further, excess level of raw material regular check must be made on the operations. On the more, wastage and losses must be completely avoided. On the more, all the operations must be implied in a effective manner and the same time the comparison level of the actual along with expected performance should be done on a regularly basis so that the financial loss can be avoided to the maximum.

Part E: Compare ways in using management accounting tools
• In addition to the budgeting and variance analysis methods stated above, discuss other possible ways in using management tools to respond to financial problems. (4.3)

Solution:

Management tools to respond to the financial problems can be listed as below:-

It is very necessary that the budgets must be listed and the improvements are based by studying financial positioning. Further, the evaluation analysis must be based on the factor that the corrective action must be monitored and progressed in a right manner. The tools which are best accustomed can be based on the matter which may be the profitability tools along with the pricing tools as well as the costing tools and various operational tools (Schroeder, Clark, and Cathey, 2019). The financial problems can be well managed and accustomed to ensure that the variance analysis method must be used and applied in a right direction so that the problems can be solved and processed in a right manner.

RELATED COURSES & ASSIGNMENT SERVICE!!


COMMENTS(0)

LEAVE A COMMENT


Captcha

 

 

Are You Looking for Management Accounting Assignment Help?


You Should Choose Miracleskills.Com For Unit 5 Management Accounting - BTEC Higher National Diploma in Business (RQF) Assignment Help!!

Learning Outcomes and Assessment Criteria:

Learning Outcome

Pass

Merit

Distinction

LO1 Demonstrating and understanding of management accounting system

P1 Explain management accounting and give the essential requirements of different types of management accounting systems.

 

P2 Explain different methods used for management accounting reporting.

M1: Evaluate the benefits of management accounting systems and their applications within an organisational context.

 

D1: Critically evaluate how management accounting systems and accounting reporting is integrated within

organisation process.

LO2 Appling a range of management accounting techniques

P3 Calculate costs using appropriate techniques of cost analysis to prepare an income statement using marginal and absorption costs

M2: Accurately apply a range of management accounting techniques and produce appropriate financial reporting documents.

D2: Produce financial reports that accurately apply and interpret data for a range of business activities.

LO3 Explaining the use of planning tools used in management accounting.

 

P4 Explain the advantages and disadvantages of different types of planning tools used for budgetary control.

M3: Analyse the use of different planning tolls and their application for preparing and forecasting budgets.

 

D3: Evaluate how planning

tools for accounting

respond appropriately to

solving financial problems

to lead organisations to sustainable success.

LO4 Comparing ways in which organisations could use management accounting to respond to financial problems.

P5 Compare how organisations are adapting management accounting systems to respond to financial problems

P5 Compare how organisations are adapting management accounting systems to respond to financial problems

Avail Services for its related units and courses such as:-

  • Unit 13 Financial Reporting Assignment Help
  • Unit 9 Entrepreneurship and Small Business Management Assignment Help
  • Unit 2 Marketing Essentials Assignment Help
  • Unit 11 Research Project Assignment Help
  • Unit 3 Human Resource Management Assignment Help
  • Unit 15 Financial Management Assignment Help
  • Unit 1 Business and the Business Environment Assignment Help
  • Unit 5 Management Accounting Assignment Help
  • Unit 10 Financial Accounting Assignment Help
  • Unit 6 Managing a Successful Business Project Assignment Help
  • Unit 12 Organisational Behaviour Assignment Help