Business Analytic: Costing and Revenue Behaviour, Correlation, Breakeven Point and Margin of Safety

Verified

Added on  2023/06/18

|16
|3752
|256
AI Summary
This article covers topics related to Business Analytic such as costing and revenue behaviour, correlation, breakeven point and margin of safety. It includes mathematical models, graph projections, and analyses of advertising expenses and sales revenue.

Contribute Materials

Your contribution can guide someone’s learning journey. Share your documents today.
Document Page
Business Analytic

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
TABLE OF CONTENTS
QUESTION 1...................................................................................................................................3
a) Developing a mathematical model by using cost information................................................3
b) Calculating the profit or loss...................................................................................................3
c) Drawing graph with spreadsheet for 5-year projection...........................................................4
d) Analysing costing and revenue behaviour..............................................................................5
QUESTION 2...................................................................................................................................6
a)..................................................................................................................................................6
calculating correlation.................................................................................................................6
b).................................................................................................................................................7
c)..................................................................................................................................................9
QUESTION 3.................................................................................................................................10
a) Determining breakeven point & margin of safety................................................................10
b) Discussing sales volume to achieve target and evaluating sales volume that will neither
cause profit nor loss..................................................................................................................12
c.................................................................................................................................................12
e)................................................................................................................................................12
REFERENCES..............................................................................................................................15
Document Page
QUESTION 1
a) Developing a mathematical model by using cost information
The mathematical model helped in calculating the total cost of production as follows:
Quantity produced = 400000
Unit variable cost = £1.50
Total variable cost = £600000
Fixed cost = £100000
Therefore, Total cost = Fixed cost + variable cost
= £100,000 + £600000
= £700000
b) Calculating the profit or loss
Particulars Amount (£)
Total Cost
£700000
Unit variable
cost
£1.50
Fixed Cost
£100000
Quantity
produced
£400,000
Variable Cost
£600000
Document Page
Annual Output 400000
Fixed cost 100000
Variable cost 600000
Total cost 700000
Selling price 3
Total sales 1200000
Profit 500000
c) Drawing graph with spreadsheet for 5-year projection
Particulars Year 2022 2023 2024 2025 2026
Total output 428000 457960 490017.2 524318.40 561020.69
Fixed cost 100000 100000 100000 100000 100000
Variable cost (in
units) 1.62 1.75 1.89 2.04 2.20
Total variable
cost 693360 801246.82 925920.82 1069994.1 1236485.18
Total cost £793360 £901246.82 £1025920.82 £1169994.1 £1336485.18
Selling price 3.21 3.43 3.68 3.93 4.21
Total sales £1373880 £1572955.21 £1800876.42 £2061823.42 £2360581.63
Profit/Loss £580520 £671708.40 £774955.60 £891829.32 £1024096.45

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
2022 2023 2024 2025 2026
0
500000
1000000
1500000
2000000
2500000
Projection of Cost/Revenue
Total cost
Total Revenue
Profit
Years
Amount
d) Analysing costing and revenue behaviour
Costing behaviour analyses how operational costs are changing with a change in
company's level of output. Costs may include direct labour, materials and overhead costs.
Here, Marko farms limited (MK Ltd.) is using marginal costing where the effect of
varying levels of costs and volume on profit is identified. The costing method bifurcates cost into
two types i.e. Fixed cost and Variable cost. The Fixed cost has remained same with varying
levels of productions whereas variable cost consists of labour and material overheads which is
changing every year with the change in production output. It is assumed that fixed cost remains
constant at all output levels but it is not true because there are certain technological changes
which affects the fixed costs significantly (Yang, 2019). On the other hand, variable costs
increase with increase in output but sometimes, at the time of bulk order quantity, variable cost
decreases.
The change in variable cost is affecting the price of per unit computer soft-wares,
therefore, price of product is also increasing at a certain rate.
The revenue analysis gives a picture about how income is generated from the sales of
products in a particular time. With the change in price, the revenue is also increasing of company
which positively affecting the profit margins. Management utilizes this information to further
frame strategies and policies to enhance the business. Manager uses such data to create annual
budgets so that any rise or fall in future costs can be determined and necessary actions can be
Document Page
taken to solve issues. It is an important planning, forecasting and controlling tool which helps
business to avoid instability in operations.
QUESTION 2
a)
calculating correlation
Year Advertising
expenses Sales revenue
2016 2 80
2017 5 100
2018 4 70
2019 6 120
2020 3 60
Correlatio
n
coefficient
0.78
It is concerned with the value that articulates the strength and degree of relationship
between the different variables. Correlation coefficient can arrive at any value that helps in
assessing that degree of relationship is negative or positive (Senthilnathan, 2019). In addition to
this, it can be identified by paying attention that value derived is from -1 to 1 which largely
contributes in achieving proper interpretation so that accurate relationship can be ascertained.
The above table indicates the relationship between expenditure and sales revenue of
manufacturing fitness equipment, Jump- Well Limited (JWL). The derived outcome is concerned
with assessing relation from the period 2016 to 2020 in order to evaluate these years'
performance. In this case there is relation\ship between advertisement expenses and revenue
generated. On the basis of this it can be identified that sales are dependent variable on the x
independent component which is advertising expense. It can be interpreted that company can
Document Page
assess how effectively its advertising expenditure is assisting in obtaining positive level of
performance in terms of revenue. JWL can pay attention can quantify the linear dependency of
two variables.
On the basis of above computation of model, it can be interpreted that there is positive
relationship among the stated X and Y variable. This can be articulated on the basis of derived
outcome that these both mentioned components have positive directional growth. If the
advertisement expenses will go in upper direction, there is possibility of increasing sales (Tellis,
2019). Once Jump- Well Limited will decline its expenditure relation with independent variable
like advertisement cost, reduced revenue generating capacity will be obtained. The attained
result is more than zero which is positive indicator of relationship between these variable.
This can be articulated that specified organization as per the performance of 2016 to 2020,
when expenses are increasing, outcome in form of revenue will incline. It can be validated that
from 2016 to 2019 it has increased which forced the sales category to uplift the performance. On
the other side, in 2020 as compared to 2019, revenue generating capacity has decreased due to
reduce in stated expenditure. It is highly beneficial for the specified organization to pay attention
measuring the correlation in order to get higher productivity & sustainability in sector. The
obtained outcome will be largely useful in terms of taking decision regarding analysing,
allocating and controlling expenses for the advertising department in order to incline
organizational performance. This will aid firm to concentrate on applying proper actions to attain
greater outcome.
b)

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Above diagram can be taken into consideration for assessing relationship between
advertising & sales revenue. In addition to this, it can be identified that blue plotted dots are
presenting advertising expenses whereas red is showing sales revenue. The degree of relationship
on the basis of specified factors can be understood by looking the scatter form of plotted chart. It
is indicating that organization is incurring cost on advertising department which is having direct
relationship with sales created.
This is reflecting the direct form of increasing & decreasing is shown in chart as both
components are moving in same direction. The pattern of relationship is presenting that firm is
getting accurate form of results as per the efforts contributed in terms of expenses incurred. It
can be clearly seen in that there is favourable performance achieved by specified company via
conducting accurate manner of expenses to have desired level of revenue. It is highly useful in
comparing organizational performance among the years so that gaining accurate knowledge
regarding relationship occurring can be derived. On the basis of obtained evaluation it can be
identified that Jump Well Limited is having proper application of level of expenditure for
achieving desired level of sales.
2015 2016 2017 2018 2019 2020 2021
0
20
40
60
80
100
120
140
Advertising expenses
Sales revenue
Document Page
c)
There are various types of expenditure which are incurred by companies to have proper
level of sustainability. In the current scenario, competition has increased and reached peak stage
which requires firm to be prompt and effectual so that arising barriers can be eliminated (Kim
and Lee, 2021). Advertising is one of the most important factor that allows enterprise to be
spread awareness about its manufactured products to attract larger number of customers.
Market share can be largely covered by the organization through applying appropriate and
trending pattern of marketing strategies. Advertising & promotional activities largely share in
increasing company's ability to lead in industry via gaining competitive edge. There are various
types of firms which has few similar characteristics in their products offered for the targeted
segment. It is essential for marketing management of specified enterprise to understand
importance of advertising and promotional practices in current business environment so that
essential actions required to have smooth functioning can be implemented.
Advertising can affect both positively and negatively on organizational performance. It is
important for the company to have significant analysis regarding its marketing departments
impact on company's position in industry. In the fitness sector, customers majorly pay attention
on having those products that are good in quality & positively impact them in turn objective of
improving health condition can be removed. Understanding customers need & wants so that
appropriate action to solve the prevailing problems. Advertising play important role in
communicating information regarding features and capability of company's product. There are
different kinds of strategies which can be executed according to suitability in turn proper
awareness can be spread (Abdurofi and et.al., 2021). On the basis of understanding of company's
products and services clients make decision of purchase. For influencing purpose enterprise
utilizes various forms of advertising tactics in order to uplift sales volume in greater manner.
On the basis of this it can be interpreted that advertising has direct relationship with sales
generating capacity of firm. If firm is using accurate and ethical manner of advertising actions,
then it will become possible to have higher efficiency in attaining greater extent of clients.
There are several strategies which can be applied by firm for meeting its purpose of
advertising its fitness related equipment’s. It includes viral, paid media, internet, email, direct
selling, point to purchase, conversational marketing, etc. these are the few approaches which can
be utilized by organization to accomplish its objective of spreading awareness regarding its
Document Page
offered products benefits to make buyer positively influenced and take decision in favour of
organization (Ndidi and Etebo, 2021). The targeted audience of the fitness industry is usually
persons who are health conscious & have objective of good physical appearance. This comprises
youngsters, middle age group people, etc. with respect to this, it can be recognized that for
having higher attention of clients, fitness based enterprise can use digital marketing practices,
conducting campaigns, etc. Social media, email, display, etc. are those approaches which can be
largely useful in having distinct competitive advantages in terms of higher transparency, proper
clarity of features, etc. that can permit to building trustworthiness relationship among customers.
It will as well provide assistance in having two-way communication which is useful in solving
queries and issues to positively impact clients and create positive working atmosphere. The
mentioned organization will become positively affected by adopting these marketing practices
through identifying suitable market segment to obtain growth in sector. Marketing strategies is
important to choose wisely so that favourable impact can be implemented by eliminating
irrelevant aspects in order to reach desirable position in industry.
QUESTION 3
a) Determining breakeven point & margin of safety
Break-even analysis is a cost accounting method which identifies a point at which total
cost is equal to total revenue. BEP helps in determining no. of units needed to be sold in order to
cover the total costs. It is very important element for company to decide minimum sales to be
achieved to avoid loss & make profits. This also helps in avoiding any external factors that can
damage business. The present company BAX Plc want to assess Breakeven point to identify
profit or loss for a particular time period which is as follows
Break-even point in terms of units
Particulars Amount (£)
Fixed cost 140000
Variable cost 160000
Total cost 300000
Total sales 384000

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Profit 84000
Computation of BEP
Particulars Formula Amount (£)
Selling price per unit (SPU) 640
Variable cost per unit (VCPU) 250
Contribution per unit (CPU) SPU - VCPU 390
Fixed cost (FC) 140000
Breakeven point FC / CPU 359
Break even sales BEP units * SPU 229743.59
Margin of safety is the gap between anticipated profitability and break-even point. It
identifies risk of loss that business may face because of changes in sales (Nunoo and et.al.,
2020). Using the data just presented, MOS of BAX Plc computed is 40.17% which shows
business is in stable condition, that is, break even point is less than actual sales so that company
will earn a good profit even if there is a shortage of total sales. It means that sales can dropto
40.17% before firm incurrs a loss. BAX plc can still improve it by enhancing sales volume with
an increase in production capacity or by embracing profitable and potential product mix.
Margin of safety
Particulars Formula Figures
Margin of safety Actual sales – BEP sales
384000 - 229743.59
= 154256.41
Margin of safety in % 40.17
Margin of safety is the gap between anticipated profitability and break-even point. It
identifies risk of loss that business may face because of changes in sales (Nunoo and et.al.,
2020). MOS of BAX Plc is 40.17% which shows it is protected from variations in sales.
Document Page
b) Discussing sales volume to achieve target and evaluating sales volume that will neither cause
profit nor loss
i)
Particulars Amount (£)
Desired profit 56000
Contribution margin 390
No. of units to produce desired profit
[(Fixed cost + Desired profit) / CPU)] 502.6
Sales revenue
(Units * SPU) 321641.03
If company's target profit is £56000, it needs to sell only 503 units of computer soft-
wares. BAX Plc total estimated sales are 640 units but to achieve the target of £56000 profit, it is
sufficient for it to sell 503 units which will generate the sales revenue of £321641.03
ii)
The estimated sales volume is of 640 units but the targeted profit of £56000 is achieved by
selling only 503 units. It means the profit will be exceeded if 640 units are sold within that year
because by selling only 503 computer soft-wares, company will be achieving its target profit.
This shows that company will achieve its target profit by selling less no. units than estimates
sales volume. BAX Plc is making good sales because of efficient sales force or by using online
marketing tools.
Document Page
c.
e)
Break even model is widely utilized by several organizations irrespective of their scale of
operation. Using this technique can be affect firm's decision-making in both positive and
negative. This is essential for BAX Plc. To pay attention on the areas that will be benefited &
limited by executing this particular approach of analysing organizational performance. There are
various benefits and drawbacks which need to be emphasized by enterprise which are as follows:
Advantages
There is various manner in which firm can derive favourable outcome through applying
this particular model into company's decision-making process. BAX Plc. can become benefited
by applying this course of action which would help in taking strategic decision.
It becomes possible to analyse and measure profits and losses at different levels of
production & sales. The point where there is no profit and loss can as well ascertained
through applying this particular model which shows the time when firm will recover it is
all cost incurred for conducting operational practices (Disadvantage and advantages of
breakeven point, 2021).
Predicting the effect of change in sales prices can be assessed through implementing
break even model. The effect can be both positive and negative which permits firm to be
taken accurate decision regarding its business actions. It can assist BAX Plc. To make
accurate decision in term of applying pricing strategy.

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Firm can analyse relationship between fixed & variable costs that contribute in deciding
that how effectively firm can cover expenses to reach profit earning stage.
BAX Plc. can predict effect of cost & efficiency changes on profitability that is important
indicator of organizational growth & productivity. Margin of safety (MOS) is concerned with amount of sales that can fall before the
breakeven point is arrived & the business obtains nil profit situation. This is basically
providing assistance to the enterprise to evaluate that how many times sales has to be
made over its BEP. It allows company to get proper information regarding the products
that it is valuable to sell or not.
Disadvantages
Every model has certain limitations which is need to evaluated so that lacking areas can
be ascertained which may hinder organizational performance.
It is important to discover the assumption made by firm which involves assuming that
sales prices are constant at all level of output and production & sales figures are same
which not possible in the actual market. The reason for this is associated that there are
various factors which influences market forces like demand and supply that fluctuates
product prices.
It is time-consuming which is not suitable for enterprise as needs higher resources that as
well increases cost of firm., this is main disadvantage which need to be taken into
consideration for applying corrective measures.
It becomes obsolete very quickly as represents a short run static relationship of costs &
output which might affect decision-making criteria of BAX Plc.
Prevailing competition is ignored in this particular evaluation which is one of the biggest
threat need to be highlighted. It does allow to take external aspects into consideration
which results in improper full disclosure of business circumstances and outcome in
decreased efficiency.
BEP in marginal costing allows firm to get details regarding contribution and profits. The
contribution is estimated by deducting variable cost form sales and eliminating fixed cost from
obtained contribution (Sintha, 2020). It aids in having information related profitability and
Break even analysis contributed in assessing the point which is mainly useful to know that how
many is required to be made to derive the situation where a company is able to reach worth full
Document Page
selling situation or not. With help of breakeven model, margin of safety can be estimated and
information related to risk of a business may obtained for many crucial changes in prevailing
policies and actions. All This provides assistance in having proper evaluation of marginal costing
to take significant decision.
BEP is one of the crucial approach that helps in creating appropriate business strategy for
BAX PLC. By analysing its offered benefits, it can be evaluated that there are several distinct
pros which is highly useful to analyse in order to have organizational growth and productivity.
There are distinct criteria for which need to be involved for having policies and strategies so that
competitive advantages can be derived. It provides certain limitations as well which need to be
overcome for having smooth functioning of firm. On the basis of BEP evaluation it can be
clearly articulate that firm can apply this as business strategy for formulating strategic decision in
order to have smooth functioning.
Document Page
REFERENCES
Books and Journals
Abdurofi, I. And et.al., 2021. Application of Cost-Benefit and Break-Even Analysis for the
Development of Stingless Bees Farming in Malaysia. International Journal of Business
and Society. 22(2). pp.846-861.
Kim, S.Y. and Lee, B.H., 2021. Analysis on Factors Influencing the Achievement of Break-even
Point among the Creativity and Skill-based Sole Proprietors. Asia-Pacific Journal of
Business. 12(1). pp.151-163.
Ndidi, H. and Etebo, Z., 2021. The Effect of Promotion Costs in Increasing Sales in GN Electric
Appliance Business. Journal Dimensie Management and Public Sector. 2(1). pp.15-22.
Nunoo, R. and et.al., 2020. Margin of safety in TMDLs: natural language processing-aided
review of the state of practice. Journal of Hydrologic Engineering. 25(4). p.04020002.
Senthilnathan, S., 2019. Usefulness of correlation Analysis. Available at SSRN 3416918.
Sintha, L., 2020. Importance of Break-Even Analysis for the Micro, Small and Medium
Enterprises. International Journal of Research-Granthaalayah. 8(6).
Sintha, L., 2020. Importance of Break-Even Analysis for the Micro, Small and Medium
Enterprises. International Journal of Research-Granthaalayah. 8(6).
Tellis, G. J., 2019. Modeling the effectiveness of advertising in contemporary markets: Research
findings and opportunities. In Attention, attitude, and affect in response to
advertising (pp. 55-66). Psychology Press.
Yang, Y., 2019. Do accruals earnings management constraints and intellectual capital efficiency
trigger asymmetric cost behaviour? Evidence from Australia. Australian Accounting
Review. 29(1). pp.177-192.
Online
Disadvantage and advantages of break-even point. 2021. [Online]. Available through:
<https://toughnickel.com/business/Breakeven-analysis>
1 out of 16
circle_padding
hide_on_mobile
zoom_out_icon
[object Object]

Your All-in-One AI-Powered Toolkit for Academic Success.

Available 24*7 on WhatsApp / Email

[object Object]