Business Analytics Report: MKF Ltd. Costing, Marketing, and Sales

This report provides a comprehensive analysis of business analytics, focusing on costing, revenue, and marketing strategies for MKF Ltd. It begins with an introduction to market analytics and business analytics (BA), emphasizing their role in data-driven decision-making. The report then delves into specific tasks, including a mathematical model for costing, profit/loss calculations, and the creation of a spreadsheet chart to visualize these elements. It analyzes costing and revenue behaviors, explaining the use of quantitative analysis methods like linear regression and the relationship between total revenue, average revenue, and marginal revenue. Furthermore, the report examines the correlation between advertising expenditure and sales revenue, including the creation and analysis of a scatter diagram. It concludes by analyzing the impact of advertising on sales and offering marketing strategy recommendations, such as content marketing, to gain a competitive advantage in the fitness industry. The report uses references to support its findings.

Business Analytic

Table of Contents
INTRODUCTION...........................................................................................................................3
TASKS.............................................................................................................................................3
Question 1....................................................................................................................................3
Question 2....................................................................................................................................6
Question 4..................................................................................................................................10
CONCLUSION..............................................................................................................................12
REFERENCES..............................................................................................................................13

INTRODUCTION
Market analytics seems to be the practise of using mathematical methods to derive information
from information in order to identify organisation activities (Ahmed and et. al., 2018). BA is a
compilation of information, resources, and techniques for analysing a company's results and
research in order to produce knowledge and make data-driven errors in dealing with the greatest.
BA's goal is to figure out which resources are not only useful, but also have the potential to
improve revenue, productivity, and success. Whenever it comes to individual businesses and
collecting data from a variety of sources, BA has a host of applications. This approach can also
be used in cloud applications, marketing software solutions, as well as CRM systems. Use both
statistical modelling and statistics to identify patterns in datasets. Others may be able to forecast
future trends using these trends, as well as obtain fresh perspectives into the consumer and their
behaviours. In fact, focusing on KPIs as well as trends helps businesses to never only have most
of the data in one place, but also to make quick and accurate decisions. It should be based on the
most up-to-date information available.
Since BA has a vast amount of data to back up its judgments, they should be sure because
they're well qualified for not only one, but several different scenarios. Three issues are discussed
throughout the report, including costing and income actions, the effect of marketing budgets on
selling, and how a business can achieve a competitive edge throughout the process of
implementing those certain marketing campaigns. In addition, this article discusses central
statistics records for just any 2 major factors that are associated, such as GDP and jobs.
TASKS
Question 1
A) Mathematical model
The following is the mathematical formula because of the above cost data:
Budgeted annual output = 180000 unit
Fixed cost = 60000
Variable cost= 0.75 per unit = (0.75 * 180000) = 135000
Sales price = 2. Per unit = 360000
B) Profit or loss of MKF Ltd.
In the above statistics, the total benefit for the business is estimated as follows:

Profit = Sales – (Fixed cost + variable cost)
= 360000 – (60000+135000)
= 360000 – 195000
= 165000 GBP
C) Draw a graph with a spreadsheet
Sales Fixed cost Variable cost Profit
0
50000
100000
150000
200000
250000
300000
350000
400000
360000
60000
135000
165000
Chart Title
D) Analyse and comment on the costing and revenue behaviour.
Cost behaviour method is an excellent attempt to understand how operating expenses start
changing in response to variations in such a company's type of care. These considerations
include direct materials, machine hours, also running costs incurred during the production of a
product. Management typically conducts product cost analyses using predictive estimation
methods. Cost functions explain how an expense (such as material, labour, or infrastructure
costs) changes as the volume of effort involved with much the same key to pricing (Al Khajeh
and et. al., 2018).
Quantitative Form of Cost Analysis
Management also uses quantitative analysis approaches to describe calculation processes. The
increased approach is probably the most transparent which support in decision making. Just a
few of the pricing program's higher and lower numbers, and also their associated costs, are being
used to quantify the loss function throughout this method. Although this approach has a variety
of flaws, it is a simple first step in describing the connection between pricing strategies and
overall costs. The linear regression is yet another method that uses mathematical methods to

measure the total sum of dependent variable as a function of dependent variable (Al-Mansoori
and et. al., 2019). The regression technique gives a far more detailed view of what's going on.
This really is a simple task that involve in decision making. The net income of a corporation
represents the amount of money received from the sale of the product. As a consequence, the
production cost per product as well as the number of units sold decide the net income. As a
consequence, the following formula is given:
TR = Q x P
Where,
TR – Total Revenue
Q – Quantity of sale (units sold)
P – Price per unit of output
Average sales is the amount of money a business makes per unit of goods sold. As a
consequence, the yearly value is derived by multiplying gross revenue by total sales volume
(Arun and et. al., 2020).
AR =\frac {TR}*{Q}$$
Where,
AR – Average Revenue
TR – Total Revenue
Q – Total units sold
Marginal income is the amount of money earned by a business from the sale of an
additional unit (Chemin, 2021). To put it differently, it's the additional revenue a corporation
makes if it sells a trying to develop.
MR = TRn – TRn-1
In addition to knowing the basics of sales, it's important to remember the relationship
surrounding TR, AR, as well as MR. When the first part is produced, TR, AR, and MR are
indeed identical. As a consequence, each of the three curves starts at the very same point.
Moreover, the TR gradient is forward-curving, and the MR is upbeat. If, but at another level, MR
declines as market volume rises, the TR curve can grow more slowly. As when the MR trend
reaches the X-axis, this same TR diagram reaches its maximum degree.
In addition, as the MR curve reaches the X-axis, each TR curve tends to slant downwards.
Any change in AR causes a significant improvement through MR; as a consequence, if the

combined type does have a considerable rise in AR, the merged form would have a substantial
increase with MR. In addition, as the MR curve reaches the X-axis, each TR curve tends to slant
downwards (Dakasi, 2019). Any change in AR results in a major rise in MR. As a consequence,
if the merged model has a higher coefficient, the MR curves will also have a lower slope and
also be underneath it. If the AR curve has a steep price, the MR curves would have a steeper
acceleration and would be supported from above. If indeed the X-axis was identical, the MR
trend often agrees only with AR chart.
Question 2
A) Correlation coefficient of advertising/sales
year
advertis
e
expense
s
sales
revenu
e
2016 2 60
2017 5 90
2018 4 70
2019 6 100
2020 3 80
Correlation between expenses on advertisement and sales revenue
Colum
n 1
Colum
n 2
Colum
n 1 1
Colum
n 2 0.9 1
Analysis: The much more common error is to assume that a correlation of below or equal to
each other is significant statistically (Elrehail and et. al., 2018). A measurement of +/- 1 indicates
that the result is highly significant, though it's impossible to say without further testing.
Statistical verification of a correlation can become difficult due to a number of factors; which is
far from clear. Among the most critical comparative principles would be that entire parameters
are naturally measured and have a linear relation. In principle, these claims will be called into
question to see whether a correlation calculation is needed. The failure to convert data into a
standard structure seems to be the 2nd most frequent blunder. When calculating an agreement
between different betas, the quantities are already standardised: beta seems to be the component.

They must translate shares to percent gains instead of stock valuation changes if they want to
link stocks. This happens all too frequently even amongst management accountants.
B) Plot a scatter diagram of the data.
2015.5 2016 2016.5 2017 2017.5 2018 2018.5 2019 2019.5 2020 2020.5
0
20
40
60
80
100
120
Chart Title
advertise expenses
Exponential (advertise expenses )
sales revenue
Linear (sales revenue )
Analysis: "Revenue expenses" would be any charges incurred then anyway running and
administration of a corporation that have been fully deducted mostly during current financial
year. These costs are recurrent in the term, i.e., these remain incurred to meet a company's daily
operations requirements, however their impact is mostly transient, i.e., the income is recognised
by the business even during sales recognition period (Gómez Quevedo, 2019). "Expenses or
reduced bills" is a term used to describe these expenses. For instance, merchandise purchased,
wages paid, postage, rent, travel expenses, stationery purchased, and wages given on items
purchased, to name a few. This cost is incurred on products or services that are essential to the
company. This expenditure is produced on services and products that really are important to the
economy but must be used away in far less than one year, temporarily improving the business's
profit-making potential. Revenue investment also reduces the services of manufacturing and
distributing and transporting them throughout order to produce saleable goods, and perhaps even
the expenses fixed properties like machinery, houses, and fixtures in good working order.
If the amount gained is an additional investment by the company president, the shareholders'
equity account, like Common Shares, is paid (Gözcü and et. al., 2019). The amount to be charged
is indeed a sales statement or Subscription Revenue or Payments Earned, in which the revenue

received comes from the a money transfer or for a product that was only finished but have not
yet published. If the payment received is an initial fee for a service that is not being fulfilled or
earned, the amount to be charged is Unearned Income. Whereas if funds raised is a refund by a
customer on a prior sale or product that has already been declared as sales, the balance to be
billed is Accounts receivable. If another money collected is the strength of the company
accepting a credit cards, the payment to be paid is Notes Repayment.
C) Analyse the impact of advertising expenditure on sales and advise the marketing manager
on how the company can gain a competitive advantage in the fitness industry by adopting
other relevant marketing strategies.
Marketers are increasingly aware of the importance of increasing equity capital that necessarily
involves a consideration of the lengthy effect of their actions on consumer opinion and inflation
expectations (Grunberg and et. al., 2019). Even so, previous research has focused on the sales or
benefit result from advertising campaigns, and marketing goals have typically been formulated
again from consumer's perspective. Lately, a few studies of long-term customer response to
marketing behaviour were analysed. The long term relationship between media spending and
business value as well as that is the focus of current research, appears to be a vital familiar with
social media. As per the researchers, advertising would have a powerful effect on profitability, as
compared to retail sales and profit response that would have an adverse effect. The results from
two industries reinforce the hypothesis that advertising spending has a positive, long-term impact
on a business's market valuation while having a negative impact on a competitor of comparable
size. The authors estimate the scale of the shareholder response effect and consider the
implications for future research. The following were among the most common marketing tools
that teachers in the business world can use to achieve a strong market plan:
CONTENT MARKETING is a term that refers to the marketing of content. This
emphasis education over sales to influence buying behaviour. It successful marketing approach
aims to create and sharing information tailored to consumers' needs in order to attract customers
who are much more comfortable with others and likely to buy products or services. Since
communication is continuing, content can be configured to reflect what you've learned about
leadership over time, including diagrams, web pages, animations, photos, journals, scientific
articles, academic teaching, and electronic content, as well as other forms. It's important to
remember that marketing campaign differs from marketing plan (more on inbound). If online

advertising seems to be an important aspect of a holistic inbound strategy, other financial terms
should not be used to maximise the value of content (Jahmani and et. al., 2018).
Simpler guide to the marketing
Making instructional videos is one of the most common ways to get the business up and running.
Whenever tell anyone anything, they can become more important. Take them into the whole
journey for you. Take a hold of the company's offering. These times, process guides are all the
fashion. The better they are doing just that, because the more publicity they generate, the sooner
they would be aim to enhance visibility, and therefore earnings. YouTube is now the second-
fastest web browser and in United States, behind only Google. When they also want to know
something creatively, those who go there. They don't want to be on camera just yet, though
they almost definitely need to be seen if they are favourable. They get used to it with time. They
can't ignore YouTube's success or reach, so get started making real, substantive awesome videos
right now.
SEARCH ENGINE OPTIMIZATION (SEO)
Online advertising, or SEO, is a way of growing awareness of and traffic to a website through
maintaining that it stays among the most paid (or "natural") targeted advertising on sites like
Facebook, Bing!, but Yahoo. However it's a popular myth that SEO is a single marketing
strategy, it's actually a set of tactics that help to generate a strong inbound marketing approach.
While social media, Youtube, digital marketing, and other marketing techniques will all help
push search engine rankings, SEO visibility is particularly crucial because the internet expands
the business in just such a significant sense. Order to allow people to take on the identity of those
interested with the good or service inside a focused manner. The much more popular way for
clients to discover content online is by pages (Kanwal, Lodhi and Kashif, 2019).
RETARGETING AND ACCOUNT BASED MARKETING
Account Based Marketing (ABM) is indeed a B2B strategy that targets a small community of
consumers with highly targeted promotions. It provides business and selling teams with a
number of advantages, including a faster distribution channel, reduced prices, and greater use of
advertising tools. Notwithstanding the most of the advantages of ABM, it's important to
remember that not all promotional contact is aimed at about the same people. It had been a lot
less tactical, with techniques like online retargeting assisting in the personalization of
promotional campaigns. Through software cookie-based technology, users who went to the site

but left without entered into such an arrangement or transition are marked. The cookie allows for
personalised advertisements to appear in subsequent search queries and interactions with specific
customers, even but they are also irrelevant to the website. Develop optimized is an effective
conversion tool since it holds the company in front of customers who already are interested in a
particular good or service.
Create the best affiliate network possible.
The bulk of people are ignorant of associate marketing's power. Affiliates may be a significant
source of expansion. Getting the correct partners, on the other hand, is sometimes not easy. The
corporation must have a good conversion rate because the expect the broader affiliates to trust
what they suggest. Navigating the associate changing landscape has been tough for boss.
Patience, toughness, and resolve are needed to see it through. Most of them get disappointed
after a few loses, but still cannot let feelings control their affiliate marketing. Make an
association channel and start reaching out to potential collaborators that can support others. A
recommendation by a friend, colleague, or co-worker equipped with a new credibility, which will
attract a large number of customers who are looked now for a positive experience with the
company. That the implementation of email system to encourage and push e-commerce sales is
regarded as common instant message marketing, sometimes known as web marketing. Media
networks can also be used to take advantage of brand reach in order to sell services and goods.
These strategies are frequently combined with conventional business formats like radio,
television, and newspapers. There was also a lot to discuss in terms of web reviews and
feedback. Since people talk about each other, word-of-mouth advertising is free, normal, and
very successful (Krishnan and et. al., 2019).
Question 4
A) Research the monthly digest of statistics or the national statistical archives for any two
economic variables which you think may be correlated.
The relationship between GDP and jobs has been debated and that there is a favourable
relationship between the number of workers and sustainable growth.
So, though government expenditure raises GDP growth slightly and tends to eliminate poverty
for a brief amount of time, investing too much on social services can lead to significant cost and
inflation. Although the theory of growth is hard to decipher and explain here, they highly
recommend reading the secondary sources mentioned below to gain a deeper understanding of

how profit functions or how it impact the price. Anyway, only because they have a better grasp
of things, allow everyone to build on certain specifics that have been covered in the answers
above. As a result, the jobs created by production will not be included through GDP, as
previously stated. In simple terms, they have a phenomenon known as "Involuntary Instability"
in financial perspective (Mughal and et. al., 2019). A industrial sector is significant due to skilled
workforce and efficient productivity, resulting in a more accurate GDP growth figure than one
dependent strictly on food security, which takes us back to the argument of whether heavy rain
has an effects on the market. . Then there's the question of whether a person is available to work
at the very same wage rate and is struggling to find work as a result of the labour market's
oversupply. This results in a global disparity that what a "Demand-Supply Curve" could justify.
As a consequence, lawmakers have come up with a number of theories. In the footnotes above,
“Keynes's Specific Sort of Full time work” is mentioned. According to the book "Interest and
also Money," emerging economies would never reach high productivity growth.
B) Critically analyse and present your results in writing to the interview panel.
According to one hypothesis, the essential cofactor are connected: Although the unemployment
rate grew more than anticipated mostly during financial crisis due to the aggregate downturn in
GDP, the rate has decreased more than anticipated mostly during present recovery. This
hypothesis proposes that deviations towards Okun's rule are uniformly spread between two
centuries, and therefore that past empirical data will be used to forecast future events (Oberer and
Erkollar, 2018). The final fight's gravel storyline, on either side, changed the entire message of
regeneration. Also after the rebound, the relationship between changes in job rates and the
population ratio shifted away again from general pattern. During the previous recession, the
same increase in the ratio culminated in a larger decrease in job rates across the board. As per the
history of conflict, if the population ratio remains constant, job rates will remain constant. But
per the convergence arrangement, work growth falls by one fraction of a percent whereas the
percentage stays unchanged. As a consequence, changes in the jobs ratio alone would not be
sufficient to explain the drastic reduction in the budget shortfall, as this was recorded throughout
the past. A really study should be segmented into business fields in order to yield meaningful
results.
The extent to which employment growth is connected to and driven by a productive
transformation is fundamental to business development's medium enterprises to long-term

viability. Real incomes, productivity ratios, labour enrolment, but still most importantly, job
growth intensity as well as market elasticity. This last measure examines how often job growth is
linked to 1% of economic growth among such metrics. Policymakers must be worried about the
decline in construction workers' work performance (Steyn, 2020). Population development
seems to have an influence on the productivity of significant activities mostly because of the
intensity at which something occurs, mostly because of the productivity through which it occurs.
A variety of factors affect the above, such as the nature of the development market and the
capital/labour power of development within specific industries.
There is a common tendency to improve both the number of jobs open as well as the
efficiency and income of all those that serve. An analysis of economic development from the
perspective of employers should indeed be undertaken in order to determine whether consumer
spending has met the need for further work and science. Incorporating employment and decent
work explicitly into community job creation and poverty reduction policies allows individuals
can use all of their income while still ensuring healthy and long-term development. Individuals
in communities with minimal mainstream jobs, where many males and females work difficult
and long hours yet unable to collect money to lift themselves and their families out of poverty,
deserve special attention. People have spent longer evenings that men juggling paid and
volunteer work, and then this period poverty has impacted their opportunity to enforce stable
work.
CONCLUSION
Data analysis seems to be a methodology for scanning through vast datasets to uncover
patterns, and other information about facts which are not instantly obvious, according to the
study's conclusion. Enterprise analysis use artificial learning, algorithms, and database systems,
and analysis of data would be a methodology for looking across large data sets to identify trends,
and other facts about evidence that are just not instantly obvious. BA will use regression,
sequencing, as well as attribute extraction as well as other data mining techniques to improve
performance. This is a crucial feature of different companies since it makes for faster and more
accurate decision-making. Given this trend, consumers will benefit from gaining a deeper
understanding of the same statistics as they advance in their careers and make better choices at
work.