Management Accounting Report: Budgeting, Costing, and Analysis
VerifiedAdded on 2020/02/17
|22
|5782
|85
Report
AI Summary
This report delves into various aspects of management accounting, starting with the importance of budgets for organizations and the administrative procedures involved in the budgeting process. It explores cost classification, including fixed, variable, and semi-variable costs, along with the high-low method for cost calculation and its limitations. The report differentiates between job costing, batch costing, process costing, and service costing, and analyzes profit and loss statements using absorption costing and marginal costing. It provides advice on production decisions, calculation of profit maximization, and the impact of increased labor hours. Furthermore, it examines different types of budgets, the preparation of a cash budget, and the management of cash flows. The report also covers flexible budgets, variance analysis, and financial performance improvement strategies, including break-even analysis and margin of safety. Finally, the report provides recommendations for enhancing the financial performance of a company.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.

Management Accounting
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.

Table of Contents
INTRODUCTION...........................................................................................................................4
TASK 1............................................................................................................................................4
A. Importance of budgets for an organisation.............................................................................4
B. Administrative procedure used in budgeting process.............................................................4
C. Stages included in budgeting process.....................................................................................5
TASK 2............................................................................................................................................5
a) Classification of costs on various basis...................................................................................5
b) calculation of fixed and variable cost by high low method....................................................6
c) limitations of high low method and other method that can be used.......................................6
TASK 3............................................................................................................................................7
a) difference between job costing, batch costing, process costing and service costing..............7
b) Profit and loss statement on the basis of absorption costing..................................................8
c) calculation of profit or loss by marginal costing for west area.............................................10
TASK 4..........................................................................................................................................11
a) Advise regarding whether to cease production of A and D..................................................11
b) Calculation of various figures on the basis of marginal cost statement provided................11
c) combination of products to maximise profits.......................................................................12
d) calculation of profit if labour hours increased by 80000......................................................13
TASK 5..........................................................................................................................................13
a) Different types of budgets and their importance...................................................................13
b) preparation of cash budget and management of cash flows.................................................14
TASK 6.........................................................................................................................................15
(I) preparation of flexible budget and calculation of total variances........................................15
(II) analysis of various cost variances.......................................................................................16
(III) Reporting of the findings to board.....................................................................................16
TASK 7..........................................................................................................................................17
INTRODUCTION...........................................................................................................................4
TASK 1............................................................................................................................................4
A. Importance of budgets for an organisation.............................................................................4
B. Administrative procedure used in budgeting process.............................................................4
C. Stages included in budgeting process.....................................................................................5
TASK 2............................................................................................................................................5
a) Classification of costs on various basis...................................................................................5
b) calculation of fixed and variable cost by high low method....................................................6
c) limitations of high low method and other method that can be used.......................................6
TASK 3............................................................................................................................................7
a) difference between job costing, batch costing, process costing and service costing..............7
b) Profit and loss statement on the basis of absorption costing..................................................8
c) calculation of profit or loss by marginal costing for west area.............................................10
TASK 4..........................................................................................................................................11
a) Advise regarding whether to cease production of A and D..................................................11
b) Calculation of various figures on the basis of marginal cost statement provided................11
c) combination of products to maximise profits.......................................................................12
d) calculation of profit if labour hours increased by 80000......................................................13
TASK 5..........................................................................................................................................13
a) Different types of budgets and their importance...................................................................13
b) preparation of cash budget and management of cash flows.................................................14
TASK 6.........................................................................................................................................15
(I) preparation of flexible budget and calculation of total variances........................................15
(II) analysis of various cost variances.......................................................................................16
(III) Reporting of the findings to board.....................................................................................16
TASK 7..........................................................................................................................................17

a) calculation of break even point and margin of safety...........................................................17
b) Calculation of profit and loss of the shop.............................................................................17
c) Calculation of desired sales to earn profit of 300000...........................................................18
d) calculation of number of shoes to be sold at break even......................................................18
e) Recommendation for the improvement of financial performance of INK Ltd.....................18
CONCLUSION..............................................................................................................................19
REFERENCES..............................................................................................................................19
b) Calculation of profit and loss of the shop.............................................................................17
c) Calculation of desired sales to earn profit of 300000...........................................................18
d) calculation of number of shoes to be sold at break even......................................................18
e) Recommendation for the improvement of financial performance of INK Ltd.....................18
CONCLUSION..............................................................................................................................19
REFERENCES..............................................................................................................................19

INTRODUCTION
Management accounting is the process in which it is required that various accounts and
reports are required to be prepared on the basis of this decisions will be taken by the managers.
For the preparation of these reports information will be required which should be collected on
the timely basis (Bromwich and Bhimani, 2005). There are various techniques that can be used
for the purpose of preparation of better reports such as budgets, ratios, different methods of
costing, etc. In this assignment all these will be used to create an understanding of how budgets
can be used for the purpose of taking decisions and maximise the profits of the company.
TASK 1
A. Importance of budgets for an organisation.
Budgets are estimates that are made in relation to cost, revenues and resources by which
it can be ascertained what is to be achieved and what will be the growth in the future ( Chapman
and et.al. 2006). Budgeting is important for an organisation as with the help of this it will be
possible to achieve the set targets and also wasteful expenditure that is incurring can be
controlled. With the help of budgets it will be easy to adapt to the changes that will be occurring.
It will tell that how the available finance should be spend so that maximum profit can be earned
from it. As by budgets the objectives are set so the work will be carried out in the most effective
manner in order to achieve those targets.
B. Administrative procedure used in budgeting process.
Administrative procedure is the set of rules or process that are required to be undertaken
in order to prepare a budget. For the preparation of budgets firstly it will be required that budget
centres are established which will be the units that will have the responsibility of preparation of
budgets. In this there can various cost centres that will be included in it (Ezzamel and et.al.
2003). Than a committee will be established which will consist of the senior members. In this
representative from every department will be present. Committee will work in order to maintain
Management accounting is the process in which it is required that various accounts and
reports are required to be prepared on the basis of this decisions will be taken by the managers.
For the preparation of these reports information will be required which should be collected on
the timely basis (Bromwich and Bhimani, 2005). There are various techniques that can be used
for the purpose of preparation of better reports such as budgets, ratios, different methods of
costing, etc. In this assignment all these will be used to create an understanding of how budgets
can be used for the purpose of taking decisions and maximise the profits of the company.
TASK 1
A. Importance of budgets for an organisation.
Budgets are estimates that are made in relation to cost, revenues and resources by which
it can be ascertained what is to be achieved and what will be the growth in the future ( Chapman
and et.al. 2006). Budgeting is important for an organisation as with the help of this it will be
possible to achieve the set targets and also wasteful expenditure that is incurring can be
controlled. With the help of budgets it will be easy to adapt to the changes that will be occurring.
It will tell that how the available finance should be spend so that maximum profit can be earned
from it. As by budgets the objectives are set so the work will be carried out in the most effective
manner in order to achieve those targets.
B. Administrative procedure used in budgeting process.
Administrative procedure is the set of rules or process that are required to be undertaken
in order to prepare a budget. For the preparation of budgets firstly it will be required that budget
centres are established which will be the units that will have the responsibility of preparation of
budgets. In this there can various cost centres that will be included in it (Ezzamel and et.al.
2003). Than a committee will be established which will consist of the senior members. In this
representative from every department will be present. Committee will work in order to maintain
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.

the coordination, decide about the time when the budgets will be required to be prepared, will
provide the information that will be required in order to prepare a budget and lastly actual and
budgeted figures will be compared by it so that deviations if any will be identified and
investigation can be carried out in relation to such deviations.
C. Stages included in budgeting process.
In the preparation of budget various stages will be required to be completed. Firstly it will
needed that relevant information should be collected which will be required for making a budget
and for this sources from where information can be obtained will be identified (Hansen, Mowen
and Guan, 2007). After this plan will be made in which it will be decided that in what aspect is
the budget required to be prepared. will it me made by the help of historical data or on the basis
of projections and than it is required that approval is obtained for the preparation of budgets. It
will be needed to identify the reason for which budget is required to be prepared. After all this
completed budget will be prepared which will describe the future projections that are required to
be achieved by the company. It will specify the break evens by which it will be ascertained that
what is the level that is necessary to be achieved so that company can survive in the market. It is
needed that once the budget is prepared it should be reviewed in order to deal with the loop holes
if any that are present in the budget.
TASK 2
a) Classification of costs on various basis.
In the production of a product or in provision of a service there are various costs that are
included and those are described below :
Direct cost : these are those cost that are directly related to the producing of product or
service (Nixon and Burns, 2012). It can be related to material, labour or other expense
and can be ascertained in an easy and accurate manner. Example of it can be material that
will be used in manufacturing a machine.
Indirect cost : the cost that cannot be ascertained easily and is not related in a direct
manner for the production of goods or service will be indirect cost. The example of it can
be any expenditure such as power which is made on combined basis and difficult to be
calculated on individual basis,
provide the information that will be required in order to prepare a budget and lastly actual and
budgeted figures will be compared by it so that deviations if any will be identified and
investigation can be carried out in relation to such deviations.
C. Stages included in budgeting process.
In the preparation of budget various stages will be required to be completed. Firstly it will
needed that relevant information should be collected which will be required for making a budget
and for this sources from where information can be obtained will be identified (Hansen, Mowen
and Guan, 2007). After this plan will be made in which it will be decided that in what aspect is
the budget required to be prepared. will it me made by the help of historical data or on the basis
of projections and than it is required that approval is obtained for the preparation of budgets. It
will be needed to identify the reason for which budget is required to be prepared. After all this
completed budget will be prepared which will describe the future projections that are required to
be achieved by the company. It will specify the break evens by which it will be ascertained that
what is the level that is necessary to be achieved so that company can survive in the market. It is
needed that once the budget is prepared it should be reviewed in order to deal with the loop holes
if any that are present in the budget.
TASK 2
a) Classification of costs on various basis.
In the production of a product or in provision of a service there are various costs that are
included and those are described below :
Direct cost : these are those cost that are directly related to the producing of product or
service (Nixon and Burns, 2012). It can be related to material, labour or other expense
and can be ascertained in an easy and accurate manner. Example of it can be material that
will be used in manufacturing a machine.
Indirect cost : the cost that cannot be ascertained easily and is not related in a direct
manner for the production of goods or service will be indirect cost. The example of it can
be any expenditure such as power which is made on combined basis and difficult to be
calculated on individual basis,

Fixed cost :the cost that does not change with the change in level of production is fixed
cost. Such as rent paid for the premise that will be paid irrespective of the fact that how
many units are produced.
Stepped Fixed cost : the expense that remains fixed upto a level and will change after
that level is passed and the activity is shifted (DRURY, 2013). An example of this can be
that a new machinery will be purchased after a fixed level of production is achieved.
variable cost :the cost that is dependent on the units produced and changes with change
in each unit produced such as material used to produce a single unit.
Semi variable cost : the cost that remain fixed for a particular level of production and
after that changes with every unit produced. An example of it can be wages which will be
fixed till a level and after that more workers will be required to be hired.
b) calculation of fixed and variable cost by high low method.
1. Calculation of variable expense per unit
variable cost per unit = Change in cost at highest and lowest level
Change in units
= 92000 - 42000
8100 - 3100
= 50000
5000
= £ 10 per unit
2. Calculation of Fixed cost
Total cost - ( variable cost per unit * no. of units)
92000 - ( 10 * 8100)
92000 - 81000
fixed cost = 11000
this method is used as electricity expenses consist of fixed and variable portion which can be
differentiated by this method and moreover this is simple and easy to use and provide correct
answers.
cost. Such as rent paid for the premise that will be paid irrespective of the fact that how
many units are produced.
Stepped Fixed cost : the expense that remains fixed upto a level and will change after
that level is passed and the activity is shifted (DRURY, 2013). An example of this can be
that a new machinery will be purchased after a fixed level of production is achieved.
variable cost :the cost that is dependent on the units produced and changes with change
in each unit produced such as material used to produce a single unit.
Semi variable cost : the cost that remain fixed for a particular level of production and
after that changes with every unit produced. An example of it can be wages which will be
fixed till a level and after that more workers will be required to be hired.
b) calculation of fixed and variable cost by high low method.
1. Calculation of variable expense per unit
variable cost per unit = Change in cost at highest and lowest level
Change in units
= 92000 - 42000
8100 - 3100
= 50000
5000
= £ 10 per unit
2. Calculation of Fixed cost
Total cost - ( variable cost per unit * no. of units)
92000 - ( 10 * 8100)
92000 - 81000
fixed cost = 11000
this method is used as electricity expenses consist of fixed and variable portion which can be
differentiated by this method and moreover this is simple and easy to use and provide correct
answers.

c) limitations of high low method and other method that can be used.
Together with the advantages there are certain disadvantages also which are there in high low
method (Lambert and Sponem, 2012). The results that are obtained by this method are estimates
and not the exact numbers and this proves to be a disadvantage. Another disadvantage will be
that as only two set of data is used so the variation that takes place in the cost on the monthly
basis is not considered.
Due to the disadvantages present in high low method there is another method which can be used
in place of it which will overcome the faults present in high low method. The method that can be
used is least squares method (Kotas, 2014). This method uses different values which are plotted
on the graph. And then line is drawn on the basis of all the points and wherever the line will
intersect the Y axis it will show the level of fixed cost. The slope of line can be used to calculate
the variable cost. By using this method the disadvantage of high low method in relation to using
limited data will get removed.
TASK 3
a) difference between job costing, batch costing, process costing and service costing.
Job costing : when the goods are produced and services are provided on the basis of the
orders placed by customers than in that situation job costing is used (Hoque, 2002). In
this method the goods are produced according to the specifications of the customers and
cost is calculated when the job is completed and it will be based on each job performed
on different basis.
Batch Costing : when the goods are produced in batches or groups than in that case batch
costing is required to be used. It is applied when production is done on mass basis and not
on customers specification. In this the cost will be calculated for the whole batch that has
been produced and than it will be divided on per unit basis.
Process costing : this type of costing is used when the production of any good requires
performance of various processes and cost is calculated for each process differently.
After this the cost is allocated to all the units that are produced (Herzig and et.al. 2012).
This method is best for those who are involved in large scale production.
Service costing : this costing is for those organisation who are involved in providing
services and not in production of goods. In this cost is calculated by adding all the
Together with the advantages there are certain disadvantages also which are there in high low
method (Lambert and Sponem, 2012). The results that are obtained by this method are estimates
and not the exact numbers and this proves to be a disadvantage. Another disadvantage will be
that as only two set of data is used so the variation that takes place in the cost on the monthly
basis is not considered.
Due to the disadvantages present in high low method there is another method which can be used
in place of it which will overcome the faults present in high low method. The method that can be
used is least squares method (Kotas, 2014). This method uses different values which are plotted
on the graph. And then line is drawn on the basis of all the points and wherever the line will
intersect the Y axis it will show the level of fixed cost. The slope of line can be used to calculate
the variable cost. By using this method the disadvantage of high low method in relation to using
limited data will get removed.
TASK 3
a) difference between job costing, batch costing, process costing and service costing.
Job costing : when the goods are produced and services are provided on the basis of the
orders placed by customers than in that situation job costing is used (Hoque, 2002). In
this method the goods are produced according to the specifications of the customers and
cost is calculated when the job is completed and it will be based on each job performed
on different basis.
Batch Costing : when the goods are produced in batches or groups than in that case batch
costing is required to be used. It is applied when production is done on mass basis and not
on customers specification. In this the cost will be calculated for the whole batch that has
been produced and than it will be divided on per unit basis.
Process costing : this type of costing is used when the production of any good requires
performance of various processes and cost is calculated for each process differently.
After this the cost is allocated to all the units that are produced (Herzig and et.al. 2012).
This method is best for those who are involved in large scale production.
Service costing : this costing is for those organisation who are involved in providing
services and not in production of goods. In this cost is calculated by adding all the
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

expenses that have been incurred in providing the particular service. The cost are
collected on the timely basis and than on the basis of that cost sheet is made which will
show all the expenses that are done in relation to that particular service.
b) Profit and loss statement on the basis of absorption costing.
Beta Ltd is the subsidiary of Cotswolds CO. Ltd. And is involved in distribution of three
products in two areas (Horngren and et.al. 2005). Below given are profit and loss statements for
each area and in total by absorption costing.
Profit and loss statement for both areas in total :
Particulars Standard Super De-luxe Total
A Sales value 4880000 3840000 4080000 12800000
B Purchase cost 3904000 2880000 2992000 9776000
C Transportation cost
(Variable)
122000 96000 102000 320000
D Transportation cost (fixed) 97600 76800 81600 256000
E Gross profit (A-B-C-D) 756400 787200 904400 2448000
F Advertisement cost
(variable)
122000 80000 68000 270000
G Advertisement cost (Fixed) 244000 160000 136000 540000
H Packaging cost (variable) 92000 60000 36000 188000
I Packaging cost (Fixed) 184000 120000 72000 376000
J Profit (E-F-G-H-I) 114400 367200 592400 1074000
Working notes :
1. allocation of transportation cost :
it will be allocated on the basis of sales value so cost per rupee of sales will be calculated and it
will be multiplied by sales value of each product to get the transportation cost of that product.
Transportation cost per rupee of sales = total cost
total sales value
collected on the timely basis and than on the basis of that cost sheet is made which will
show all the expenses that are done in relation to that particular service.
b) Profit and loss statement on the basis of absorption costing.
Beta Ltd is the subsidiary of Cotswolds CO. Ltd. And is involved in distribution of three
products in two areas (Horngren and et.al. 2005). Below given are profit and loss statements for
each area and in total by absorption costing.
Profit and loss statement for both areas in total :
Particulars Standard Super De-luxe Total
A Sales value 4880000 3840000 4080000 12800000
B Purchase cost 3904000 2880000 2992000 9776000
C Transportation cost
(Variable)
122000 96000 102000 320000
D Transportation cost (fixed) 97600 76800 81600 256000
E Gross profit (A-B-C-D) 756400 787200 904400 2448000
F Advertisement cost
(variable)
122000 80000 68000 270000
G Advertisement cost (Fixed) 244000 160000 136000 540000
H Packaging cost (variable) 92000 60000 36000 188000
I Packaging cost (Fixed) 184000 120000 72000 376000
J Profit (E-F-G-H-I) 114400 367200 592400 1074000
Working notes :
1. allocation of transportation cost :
it will be allocated on the basis of sales value so cost per rupee of sales will be calculated and it
will be multiplied by sales value of each product to get the transportation cost of that product.
Transportation cost per rupee of sales = total cost
total sales value

For variable transportation cost = £320000
£ 12800000
= £0.025
For fixed transportation cost = £ 256000
£ 12800000
= £0.02
2. Allocation of advertisement cost :
It will be allocated on the basis of units sold so cost per unit sold will be calculated and than the
total cost will be allocated to different products by multiplying per unit sold cost with the number
of units sold.
Advertisement cost per rupee of sales = total cost
total units sold
For variable advertisement cost = £ 270000
270000
= £ 1 per unit
For fixed advertisement cost = £ 540000
270000
= £ 2 per unit
3. Allocation of packaging cost :
It will be allocated on the basis of no. of orders. So cost per order will be calculated and than that
will be multiplied by orders received for each product.
Packaging cost per rupee of sales = total cost
total no. of orders
For variable packaging cost = £ 188000
94000
= £ 2 per order
For fixed packaging cost = £ 376000
94000
= £ 4 per unit
Profit and loss statement for north areas :
£ 12800000
= £0.025
For fixed transportation cost = £ 256000
£ 12800000
= £0.02
2. Allocation of advertisement cost :
It will be allocated on the basis of units sold so cost per unit sold will be calculated and than the
total cost will be allocated to different products by multiplying per unit sold cost with the number
of units sold.
Advertisement cost per rupee of sales = total cost
total units sold
For variable advertisement cost = £ 270000
270000
= £ 1 per unit
For fixed advertisement cost = £ 540000
270000
= £ 2 per unit
3. Allocation of packaging cost :
It will be allocated on the basis of no. of orders. So cost per order will be calculated and than that
will be multiplied by orders received for each product.
Packaging cost per rupee of sales = total cost
total no. of orders
For variable packaging cost = £ 188000
94000
= £ 2 per order
For fixed packaging cost = £ 376000
94000
= £ 4 per unit
Profit and loss statement for north areas :

Particulars Standard Super De-luxe Total
A Sales value 3680000 1920000 1680000 7280000
B Purchase cost 2944000 1440000 1232000 5616000
C Transportation cost
(Variable)
92000 48000 42000 182000
D Transportation cost (fixed) 73600 38400 33600 145600
E Gross profit (A-B-C-D) 570400 393600 372400 1336400
F Advertisement cost
(variable)
92000 40000 28000 160000
G Advertisement cost (Fixed) 184000 80000 56000 320000
H Packaging cost (variable) 80000 40000 20000 140000
I Packaging cost (Fixed) 160000 80000 40000 280000
J Profit (E-F-G-H-I) 54400 153600 228400 436400
Profit and loss statement for west areas :
Particulars Standard Super De-luxe Total
A Sales value 1200000 1920000 2400000 5520000
B Purchase cost 960000 1440000 1760000 4160000
C Transportation cost
(Variable)
30000 48000 60000 138000
D Transportation cost (fixed) 24000 38400 48000 110400
E Gross profit (A-B-C-D) 186000 393600 532000 4656800
F Advertisement cost
(variable)
30000 40000 40000 110000
G Advertisement cost (Fixed) 60000 80000 80000 220000
A Sales value 3680000 1920000 1680000 7280000
B Purchase cost 2944000 1440000 1232000 5616000
C Transportation cost
(Variable)
92000 48000 42000 182000
D Transportation cost (fixed) 73600 38400 33600 145600
E Gross profit (A-B-C-D) 570400 393600 372400 1336400
F Advertisement cost
(variable)
92000 40000 28000 160000
G Advertisement cost (Fixed) 184000 80000 56000 320000
H Packaging cost (variable) 80000 40000 20000 140000
I Packaging cost (Fixed) 160000 80000 40000 280000
J Profit (E-F-G-H-I) 54400 153600 228400 436400
Profit and loss statement for west areas :
Particulars Standard Super De-luxe Total
A Sales value 1200000 1920000 2400000 5520000
B Purchase cost 960000 1440000 1760000 4160000
C Transportation cost
(Variable)
30000 48000 60000 138000
D Transportation cost (fixed) 24000 38400 48000 110400
E Gross profit (A-B-C-D) 186000 393600 532000 4656800
F Advertisement cost
(variable)
30000 40000 40000 110000
G Advertisement cost (Fixed) 60000 80000 80000 220000
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.

H Packaging cost (variable) 12000 20000 16000 48000
I Packaging cost (Fixed) 24000 40000 32000 96000
J Profit (E-F-G-H-I) 60000 213600 364000 637600
c) calculation of profit or loss by marginal costing for west area.
Particulars Standard Super De-luxe Total
A Sales value 1200000 1920000 2400000 5520000
B Purchase cost 960000 1440000 1760000 4160000
C Transportation cost
(Variable)
30000 48000 60000 138000
D Advertisement cost
(variable)
30000 40000 40000 110000
E Packaging cost (variable) 12000 20000 16000 48000
F Contribution (A-B-C-D-E) 168000 372000 524000 1064000
G Transportation cost (fixed) 24000 38400 48000 110400
H Advertisement cost (Fixed) 60000 80000 80000 220000
I Packaging cost (Fixed) 24000 40000 32000 96000
J Profit (F-G-H-I) 60000 213600 364000 637600
TASK 4
a) Advise regarding whether to cease production of A and D.
There are total four products that are manufactured by HER CO. Ltd. From the given
profitability statement it can be understood that A & D are loss making products (Horngren and
et.al. 2002). From the product A company is having loss of 250 and from D loss is 1300. as they
are not contributing to the profitability of the company so there production should be ceased and
I Packaging cost (Fixed) 24000 40000 32000 96000
J Profit (E-F-G-H-I) 60000 213600 364000 637600
c) calculation of profit or loss by marginal costing for west area.
Particulars Standard Super De-luxe Total
A Sales value 1200000 1920000 2400000 5520000
B Purchase cost 960000 1440000 1760000 4160000
C Transportation cost
(Variable)
30000 48000 60000 138000
D Advertisement cost
(variable)
30000 40000 40000 110000
E Packaging cost (variable) 12000 20000 16000 48000
F Contribution (A-B-C-D-E) 168000 372000 524000 1064000
G Transportation cost (fixed) 24000 38400 48000 110400
H Advertisement cost (Fixed) 60000 80000 80000 220000
I Packaging cost (Fixed) 24000 40000 32000 96000
J Profit (F-G-H-I) 60000 213600 364000 637600
TASK 4
a) Advise regarding whether to cease production of A and D.
There are total four products that are manufactured by HER CO. Ltd. From the given
profitability statement it can be understood that A & D are loss making products (Horngren and
et.al. 2002). From the product A company is having loss of 250 and from D loss is 1300. as they
are not contributing to the profitability of the company so there production should be ceased and

the cost that will be saved due to their non production will be applied to the production of
product B & E. by doing so the contribution of the products will increase thereby increasing the
total profitability of the company.
b) Calculation of various figures on the basis of marginal cost statement provided.
(I) calculation of contribution to sales ratio on sales mix basis of four products.
There will be two cases according to which contribution to sales ratio will be calculated and
those are if company manufactures all four products and if company manufactures only profit
making products (Ferreira and Merchant, 1992).
Calculation if all products are manufactured :
Particular A B D E TOTAL
A Sales 7600 11000 9000 12000 39600
B Material cost 1850 2900 2900 2900 10550
C Labour cost 2400 2800 2800 2800 10800
D Variable overheads 2100 2500 3100 2800 10500
E Contribution(A-B-C-D) 1250 2800 200 3500 7750
F Contribution to sales
ratio(E/A*100)
16.45% 25.45% 2.22% 29.17% 19.57%
Calculation if B and E are manufactured :
Particular B E TOTAL
A Sales 11000 12000 23000
B Material cost 2900 2900 5800
C Labour cost 2800 2800 5600
D Variable overheads 2500 2800 5300
E Contribution(A-B-C-D) 2800 3500 6300
F Contribution to sales ratio(E/A*100) 25.45% 29.17% 27.39%
product B & E. by doing so the contribution of the products will increase thereby increasing the
total profitability of the company.
b) Calculation of various figures on the basis of marginal cost statement provided.
(I) calculation of contribution to sales ratio on sales mix basis of four products.
There will be two cases according to which contribution to sales ratio will be calculated and
those are if company manufactures all four products and if company manufactures only profit
making products (Ferreira and Merchant, 1992).
Calculation if all products are manufactured :
Particular A B D E TOTAL
A Sales 7600 11000 9000 12000 39600
B Material cost 1850 2900 2900 2900 10550
C Labour cost 2400 2800 2800 2800 10800
D Variable overheads 2100 2500 3100 2800 10500
E Contribution(A-B-C-D) 1250 2800 200 3500 7750
F Contribution to sales
ratio(E/A*100)
16.45% 25.45% 2.22% 29.17% 19.57%
Calculation if B and E are manufactured :
Particular B E TOTAL
A Sales 11000 12000 23000
B Material cost 2900 2900 5800
C Labour cost 2800 2800 5600
D Variable overheads 2500 2800 5300
E Contribution(A-B-C-D) 2800 3500 6300
F Contribution to sales ratio(E/A*100) 25.45% 29.17% 27.39%

(II)Calculation of break even point in £000.
Particulars If all products are
manufactured
If only B and E are
manufactured
A Contribution 7750 6300
B PV Ratio (contribution/sales*100) 19.57% 27.39%
C Break-even point (A*B) 1516.68 1725.57
(III) Sales to earn profit of £ 200000
Particulars If all products are
manufactured
If only B and E are
manufactured
A Total fixed cost £ 6000000 £ 6000000
B Profit desired £200000 £200000
C PV ratio 19.57% 27.39%
D Sales (A+B)/C £31681144.61 £22635998.54
c) combination of products to maximise profits
Working note
Allocation of labour hours on the basis of ranks
Particulars A B D E
A Contribution 1250000 2800000 200000 3500000
B Total labour cost 2400000 2800000 2800000 2800000
C Labour hours (B/10) 240000 280000 280000 280000
D Contribution per labour
hour (A/C)
5.21 10 0.71 12.5
E Ranking 3 2 4 1
F Allocated labour hours 240000 280000 180000 280000
Particulars If all products are
manufactured
If only B and E are
manufactured
A Contribution 7750 6300
B PV Ratio (contribution/sales*100) 19.57% 27.39%
C Break-even point (A*B) 1516.68 1725.57
(III) Sales to earn profit of £ 200000
Particulars If all products are
manufactured
If only B and E are
manufactured
A Total fixed cost £ 6000000 £ 6000000
B Profit desired £200000 £200000
C PV ratio 19.57% 27.39%
D Sales (A+B)/C £31681144.61 £22635998.54
c) combination of products to maximise profits
Working note
Allocation of labour hours on the basis of ranks
Particulars A B D E
A Contribution 1250000 2800000 200000 3500000
B Total labour cost 2400000 2800000 2800000 2800000
C Labour hours (B/10) 240000 280000 280000 280000
D Contribution per labour
hour (A/C)
5.21 10 0.71 12.5
E Ranking 3 2 4 1
F Allocated labour hours 240000 280000 180000 280000
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

(total 980000 hours)
Combination of products on allocated labour hours basis.
Particulars A B D E
A Original sales 7600000 11000000 9000000 12000000
B Original labour hours 240000 280000 280000 280000
C Sales per labour
hour(A/B)
31.67 39.29 32.14 42.86
D Allocated labour hour 240000 280000 180000 280000
E New sales combination 7600000 11000000 5785714.29 12000000
d) calculation of profit if labour hours increased by 80000.
Particulars A B D E
A Ranking 3 2 4 1
B Allocated labour hours
(total 1060000 hours)
240000 280000 260000 280000
C Contribution per labour
hour
5.21 10 0.71 12.5
D Total contribution (B*C) 1250400 2800000 184600 3500000
E Fixed cost 1500000 1500000 1500000 1500000
F New profits (D-E) -249600 1300000 -1315400 2000000
Combination of products on allocated labour hours basis.
Particulars A B D E
A Original sales 7600000 11000000 9000000 12000000
B Original labour hours 240000 280000 280000 280000
C Sales per labour
hour(A/B)
31.67 39.29 32.14 42.86
D Allocated labour hour 240000 280000 180000 280000
E New sales combination 7600000 11000000 5785714.29 12000000
d) calculation of profit if labour hours increased by 80000.
Particulars A B D E
A Ranking 3 2 4 1
B Allocated labour hours
(total 1060000 hours)
240000 280000 260000 280000
C Contribution per labour
hour
5.21 10 0.71 12.5
D Total contribution (B*C) 1250400 2800000 184600 3500000
E Fixed cost 1500000 1500000 1500000 1500000
F New profits (D-E) -249600 1300000 -1315400 2000000

TASK 5
a) Different types of budgets and their importance.
The different budgeting methods are described below :
Incremental : in this method the current budget is taken as the base and than increments that
take place are added in preparation of new budget (Qian, Burritt and Monroe, 2011). The
increments that will be added will be the results of increase in cost or inflation effect. This can be
used in schools where some increments are done on yearly basis.
Zero base budgeting : in this all the expenses are allocated taking the base as zero which means
that historical data is not considered and the allocation is required to be justified in relation to
each action performed. This system is generally used in service level enterprise.
Fixed budgets : these are does budgets which are not affected with the change in level of sales
that is they remains fixed. This will be used in those companies where there are minimal chances
of changes.
Flexible budgets : these budgets are those which keep on changing with the change in level of
outputs. This will be used where it is difficult to estimate the sales level.
b) preparation of cash budget and management of cash flows.
(I) Calculation of direct material purchased :
Particulars July August September
A Closing stock 115000 160000 130000
B Material consumption 220000 280000 320000
C Opening stock 160000 115000 160000
D Material purchased (A+B-C) 175000 325000 290000
(II)Preparation of cash budget.
Particulars July August September
A Opening balance 150000 470000 535000
B Cash sales (30%) 435000 480000 570000
C Credit sales (70%) 600000 1015000 1120000
a) Different types of budgets and their importance.
The different budgeting methods are described below :
Incremental : in this method the current budget is taken as the base and than increments that
take place are added in preparation of new budget (Qian, Burritt and Monroe, 2011). The
increments that will be added will be the results of increase in cost or inflation effect. This can be
used in schools where some increments are done on yearly basis.
Zero base budgeting : in this all the expenses are allocated taking the base as zero which means
that historical data is not considered and the allocation is required to be justified in relation to
each action performed. This system is generally used in service level enterprise.
Fixed budgets : these are does budgets which are not affected with the change in level of sales
that is they remains fixed. This will be used in those companies where there are minimal chances
of changes.
Flexible budgets : these budgets are those which keep on changing with the change in level of
outputs. This will be used where it is difficult to estimate the sales level.
b) preparation of cash budget and management of cash flows.
(I) Calculation of direct material purchased :
Particulars July August September
A Closing stock 115000 160000 130000
B Material consumption 220000 280000 320000
C Opening stock 160000 115000 160000
D Material purchased (A+B-C) 175000 325000 290000
(II)Preparation of cash budget.
Particulars July August September
A Opening balance 150000 470000 535000
B Cash sales (30%) 435000 480000 570000
C Credit sales (70%) 600000 1015000 1120000

D Total inflows (B+C) 1035000 1495000 1690000
E Material purchased 175000 325000 290000
F Wages paid 380000 420000 470500
G Overheads paid 160000 205000 245000
H Tax bill paid 0 0 780000
I Total outflows 715000 950000 1785500
J Closing balance (A+D-I) 470000 535000 439500
(III) Advantages of preparing cash budgets
There are various advantages of preparation of cash budgets as with the help of them it can be
known that whether there are sufficient balance of cash required to meet the daily obligations
and will also be helpful in knowing if too much of cash is retained and if it is than it is required
to be invested in some profitable activities (Otley and Emmanuel, 2013). With there help it can
be identified if cash is required to be borrowed. The creditors will be paid on time and the budget
will also help in receiving cad discount and reduction of bad debts.
(IV) Recommendation for improvement of cash flow variances.
There are various reasons for the variances in cash flows such as the sales is increasing in every
month and it is a good sign but together with it the amount of overheads and wages is also
increasing in each month so it will be required by the management to control them and make
some reduction in these costs (Macintosh and Quattrone, 2010). It can also be noticed that in the
month of September total expenses are more that total inflows so this should not happen and
expenses should be evenly distributed among whole period and the burden should not be made in
single month.
TASK 6
(I) preparation of flexible budget and calculation of total variances.
Particulars Original
budget
Actual
figures
Flexed
budget
Total
variances
Sales units 8200 8400 8400
E Material purchased 175000 325000 290000
F Wages paid 380000 420000 470500
G Overheads paid 160000 205000 245000
H Tax bill paid 0 0 780000
I Total outflows 715000 950000 1785500
J Closing balance (A+D-I) 470000 535000 439500
(III) Advantages of preparing cash budgets
There are various advantages of preparation of cash budgets as with the help of them it can be
known that whether there are sufficient balance of cash required to meet the daily obligations
and will also be helpful in knowing if too much of cash is retained and if it is than it is required
to be invested in some profitable activities (Otley and Emmanuel, 2013). With there help it can
be identified if cash is required to be borrowed. The creditors will be paid on time and the budget
will also help in receiving cad discount and reduction of bad debts.
(IV) Recommendation for improvement of cash flow variances.
There are various reasons for the variances in cash flows such as the sales is increasing in every
month and it is a good sign but together with it the amount of overheads and wages is also
increasing in each month so it will be required by the management to control them and make
some reduction in these costs (Macintosh and Quattrone, 2010). It can also be noticed that in the
month of September total expenses are more that total inflows so this should not happen and
expenses should be evenly distributed among whole period and the burden should not be made in
single month.
TASK 6
(I) preparation of flexible budget and calculation of total variances.
Particulars Original
budget
Actual
figures
Flexed
budget
Total
variances
Sales units 8200 8400 8400
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.

Production units 8900 9100 9100
A Sales value 713400 705600 730800 -25200
B Material cost 195800 170455 200200 29745
C Labour cost 267000 244515 273000 28485
D Variable overheads 106800 89348 109200 19852
E Fixed overheads 160200 136074 163800 27726
F Total production
cost(B+C+D+E)
729800 640392 746200
G Closing inventory 57400 57400 57400
H Total cost of sales(F+G) 787200 697792 803600
I Profit (A-H) -73800 7808 -72800
(II) analysis of various cost variances.
Analysis of various variances is provided below :
(a) Material variances : form the above calculation it can be analysed that material variance is
favourable (Ward, 2012). This is because of the reason that the price of the material has
decreased.
(b) Labour variances : the labour variance is also favourable which is beneficial for the
company and this has happened because of decrease in labour cost.
(c) Variable overheads : the actual cost that has been incurred on the variable overheads is less
than the budgeted amount which will have favourable impact.
(d) Fixed overheads : there is a change in the amount of fixed expenditure which can only
happen when there is a requirement of new machinery in the company so it will be required to be
installed.
(e) preparation of reconciliation statement :
Particulars Amount
Budgeted profit -72800
A Sales value 713400 705600 730800 -25200
B Material cost 195800 170455 200200 29745
C Labour cost 267000 244515 273000 28485
D Variable overheads 106800 89348 109200 19852
E Fixed overheads 160200 136074 163800 27726
F Total production
cost(B+C+D+E)
729800 640392 746200
G Closing inventory 57400 57400 57400
H Total cost of sales(F+G) 787200 697792 803600
I Profit (A-H) -73800 7808 -72800
(II) analysis of various cost variances.
Analysis of various variances is provided below :
(a) Material variances : form the above calculation it can be analysed that material variance is
favourable (Ward, 2012). This is because of the reason that the price of the material has
decreased.
(b) Labour variances : the labour variance is also favourable which is beneficial for the
company and this has happened because of decrease in labour cost.
(c) Variable overheads : the actual cost that has been incurred on the variable overheads is less
than the budgeted amount which will have favourable impact.
(d) Fixed overheads : there is a change in the amount of fixed expenditure which can only
happen when there is a requirement of new machinery in the company so it will be required to be
installed.
(e) preparation of reconciliation statement :
Particulars Amount
Budgeted profit -72800

Sales variance -25200
Material variance 29745
Labour variance 28485
Variable overhead variance 19852
Fixed overhead variance 27726
Actual profit 7808
(III) Reporting of the findings to board
The findings that are obtained by this analysis will have to be reported to the board in the
manner given below :
To
The Board of Directors
Cotswolds Co.
From the analysis of the results that have been obtained it has been noticed that it is required by
the company to make the evaluation of the budget and than changes should be made according to
that. This is required to be done as the resources of the company are not being utilised in an
efficient manner.
TASK 7
a) calculation of break even point and margin of safety.
Calculation of break even points :
Particulars Amount
A Total fixed cost 800000
B Contribution per unit 40
C Break even point (in units)(A/B) 20000
D Selling price per unit 100
E Break even point (in value)(C*D) 2000000
Material variance 29745
Labour variance 28485
Variable overhead variance 19852
Fixed overhead variance 27726
Actual profit 7808
(III) Reporting of the findings to board
The findings that are obtained by this analysis will have to be reported to the board in the
manner given below :
To
The Board of Directors
Cotswolds Co.
From the analysis of the results that have been obtained it has been noticed that it is required by
the company to make the evaluation of the budget and than changes should be made according to
that. This is required to be done as the resources of the company are not being utilised in an
efficient manner.
TASK 7
a) calculation of break even point and margin of safety.
Calculation of break even points :
Particulars Amount
A Total fixed cost 800000
B Contribution per unit 40
C Break even point (in units)(A/B) 20000
D Selling price per unit 100
E Break even point (in value)(C*D) 2000000

Calculation of margin of safety :
Particulars Margin of safety (in units) Margin of safety (in
value)
Formula for calculation Actual sales – BEP Sales Actual sales – BEP Sales
Calculation 30000-10000 3000000-1000000
Margin of safety 20000 2000000
Working note :
calculation of contribution per unit :
Contribution = selling price – variable cost
= 100-60
= 40 per unit
Calculation of total fixed cost :
Total fixed cost = 285000+100000+415000
= 800000
b) Calculation of profit and loss of the shop.
Particulars i ii
A No. of units sold 19500 20500
B Contribution per unit 40 40
C Total contribution (A*B) 780000 820000
D Fixed cost 800000 800000
E Profit / Loss (C-D) -20000 20000
c) Calculation of desired sales to earn profit of 300000.
Particulars Amount
A Fixed cost 800000
B Desired profit 300000
Particulars Margin of safety (in units) Margin of safety (in
value)
Formula for calculation Actual sales – BEP Sales Actual sales – BEP Sales
Calculation 30000-10000 3000000-1000000
Margin of safety 20000 2000000
Working note :
calculation of contribution per unit :
Contribution = selling price – variable cost
= 100-60
= 40 per unit
Calculation of total fixed cost :
Total fixed cost = 285000+100000+415000
= 800000
b) Calculation of profit and loss of the shop.
Particulars i ii
A No. of units sold 19500 20500
B Contribution per unit 40 40
C Total contribution (A*B) 780000 820000
D Fixed cost 800000 800000
E Profit / Loss (C-D) -20000 20000
c) Calculation of desired sales to earn profit of 300000.
Particulars Amount
A Fixed cost 800000
B Desired profit 300000
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

C Desired contribution (A+B) 1100000
D Contribution per unit 20
E Desired sales (in units)(C/D) 55000
Working note :
calculation of contribution per unit :
contribution per unit = selling price – purchase price – sales commission
= 100 – 60 – 20
= 20 per unit
d) calculation of number of shoes to be sold at break even.
Particulars Calculations Amount
Fixed cost 800000+40000 840000
New Selling price 100 + 10% 110
Purchase price 60
Contribution per unit 50
Break even sales (in units) 840000/50 16800
e) Recommendation for the improvement of financial performance of INK Ltd.
It can be noticed that as INK Ltd. Has increased the expenditure on advertising its profits
are increased as the break even point has reached to lower level due to which it will start earning
profits at earlier stage of sales only (Renz, 2016). So it is recommended that in order to increase
the profits even further company will be required to increase its fixed expenditure on advertising.
CONCLUSION
From the above presented report it can be concluded that in order to achieve the targets
and increase the profitability budgets play a very important role as they will set the targets that
D Contribution per unit 20
E Desired sales (in units)(C/D) 55000
Working note :
calculation of contribution per unit :
contribution per unit = selling price – purchase price – sales commission
= 100 – 60 – 20
= 20 per unit
d) calculation of number of shoes to be sold at break even.
Particulars Calculations Amount
Fixed cost 800000+40000 840000
New Selling price 100 + 10% 110
Purchase price 60
Contribution per unit 50
Break even sales (in units) 840000/50 16800
e) Recommendation for the improvement of financial performance of INK Ltd.
It can be noticed that as INK Ltd. Has increased the expenditure on advertising its profits
are increased as the break even point has reached to lower level due to which it will start earning
profits at earlier stage of sales only (Renz, 2016). So it is recommended that in order to increase
the profits even further company will be required to increase its fixed expenditure on advertising.
CONCLUSION
From the above presented report it can be concluded that in order to achieve the targets
and increase the profitability budgets play a very important role as they will set the targets that

will be required to be achieved and than company will work in order to achieve them. Also
variances can be calculated and measures can be taken to remove them. Various cost that are
associated with the production of a product have also been discussed. The manner in which
marginal costing is applied in order to calculate various aspects and the impact the it casts on the
financial attainability of the company has also been provided together with the recommendation
for the improvement of financial performance.
variances can be calculated and measures can be taken to remove them. Various cost that are
associated with the production of a product have also been discussed. The manner in which
marginal costing is applied in order to calculate various aspects and the impact the it casts on the
financial attainability of the company has also been provided together with the recommendation
for the improvement of financial performance.

REFERENCES
Books and journals
Bromwich, M and Bhimani, A., 2005. Management accounting: Pathways to progress. Cima
publishing.
Chapman and et.al. 2006. Handbook of management accounting research (Vol. 1). Elsevier.
Ezzamel and et.al. 2003. The future direction of UK management accounting practice. Cima
Publishing.
Hansen, D., Mowen, M and Guan, L., 2007. Cost management: accounting and control. Cengage
Learning.
Nixon, B and Burns, J., 2012. The paradox of strategic management accounting. Management
Accounting Research. 23(4). pp.229-244.
Lambert, C and Sponem, S., 2012. Roles, authority and involvement of the management
accounting function: a multiple case-study perspective. European Accounting
Review. 21(3). pp.565-589.
Hoque, Z., 2002. Strategic management accounting. Spiro Press.
Horngren and et.al. 2005. Introduction to management accounting. Upper Saddle River, New
Jersey: Prentice Hall.
Horngren and et.al. 2002. Management and cost accounting. Harlow: Financial Times/Prentice
Hall.
Ferreira, L. D and Merchant, K.A., 1992. Field research in management accounting and control:
a review and evaluation. Accounting, Auditing & Accountability Journal. 5(4).
Qian, W., Burritt, R and Monroe, G., 2011. Environmental management accounting in local
government: A case of waste management. Accounting, Auditing & Accountability
Journal. 24(1). pp.93-128.
Macintosh, N .B and Quattrone, P., 2010. Management accounting and control systems: An
organizational and sociological approach. John Wiley & Sons.
Ward, K., 2012. Strategic management accounting. Routledge.
Renz, D.O., 2016. The Jossey-Bass handbook of nonprofit leadership and management. John
Wiley & Sons.
Otley, D and Emmanuel, K.M.C., 2013. Readings in accounting for management control.
Springer.
Books and journals
Bromwich, M and Bhimani, A., 2005. Management accounting: Pathways to progress. Cima
publishing.
Chapman and et.al. 2006. Handbook of management accounting research (Vol. 1). Elsevier.
Ezzamel and et.al. 2003. The future direction of UK management accounting practice. Cima
Publishing.
Hansen, D., Mowen, M and Guan, L., 2007. Cost management: accounting and control. Cengage
Learning.
Nixon, B and Burns, J., 2012. The paradox of strategic management accounting. Management
Accounting Research. 23(4). pp.229-244.
Lambert, C and Sponem, S., 2012. Roles, authority and involvement of the management
accounting function: a multiple case-study perspective. European Accounting
Review. 21(3). pp.565-589.
Hoque, Z., 2002. Strategic management accounting. Spiro Press.
Horngren and et.al. 2005. Introduction to management accounting. Upper Saddle River, New
Jersey: Prentice Hall.
Horngren and et.al. 2002. Management and cost accounting. Harlow: Financial Times/Prentice
Hall.
Ferreira, L. D and Merchant, K.A., 1992. Field research in management accounting and control:
a review and evaluation. Accounting, Auditing & Accountability Journal. 5(4).
Qian, W., Burritt, R and Monroe, G., 2011. Environmental management accounting in local
government: A case of waste management. Accounting, Auditing & Accountability
Journal. 24(1). pp.93-128.
Macintosh, N .B and Quattrone, P., 2010. Management accounting and control systems: An
organizational and sociological approach. John Wiley & Sons.
Ward, K., 2012. Strategic management accounting. Routledge.
Renz, D.O., 2016. The Jossey-Bass handbook of nonprofit leadership and management. John
Wiley & Sons.
Otley, D and Emmanuel, K.M.C., 2013. Readings in accounting for management control.
Springer.
1 out of 22
Related Documents

Your All-in-One AI-Powered Toolkit for Academic Success.
+13062052269
info@desklib.com
Available 24*7 on WhatsApp / Email
Unlock your academic potential
© 2024 | Zucol Services PVT LTD | All rights reserved.