Comprehensive Cost and Revenue Analysis for Marks and Spencer

Verified

Added on  2020/12/24

|19
|4300
|341
Report
AI Summary
This report provides a detailed analysis of cost and revenue management within Marks & Spencer (M&S), a major UK-based retail enterprise. It examines internal reporting purposes, different costing systems, and the relationships between responsibility, cost, and investment centers. The report explores various cost classifications, including manufacturing, non-manufacturing, direct, and indirect costs, and differentiates between marginal and absorption costing methods. It covers costing procedures for materials, labor, and expenses, along with inventory stages and valuation using FIFO. The report delves into cost behavior, overhead allocation, and the calculation of overhead absorption rates based on machine and labor hours. Furthermore, it addresses variance analysis, budgeting, and provides insights into future income and cost estimations, including the effects of changing activity levels on unit costs and factors affecting short-term and long-term decision-making within M&S.
Document Page
Costs and revenues
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Table of Contents
INTRODUCTION...........................................................................................................................1
MAIN BODY...................................................................................................................................1
1.1 Purpose of internal reporting and giving accurate information.............................................1
1.2 Relationship among various costing systems within M&S..................................................1
1.3 Responsibility centres, cost centres and investment centres within organisation..................2
1.4 Characteristics of different cost classifications and their usage............................................2
1.5 Difference between marginal and absorption costing............................................................3
2.1 Record Cost information for material, labour and expenses in accordance with the costing
procedures of M&S......................................................................................................................3
2.2 Analyse cost information for material, labour and expenses in accordance with the costing
procedures of M&S......................................................................................................................3
2.3 Different stages of inventory.................................................................................................4
2.4 Value inventory using............................................................................................................4
2.5 Behaviour of costs..................................................................................................................7
2.6 Recording cost information....................................................................................................8
3.1 Attribute overhead costs to service and production costs......................................................8
3.2 Overhead absorption rate.......................................................................................................8
3.3 ................................................................................................................................................9
3.4 Reviewing allocation, apportionment and absorption methods...........................................10
3.5 Resolving queries in overhead cost......................................................................................10
4.1 comparison of actual costs with budget costs......................................................................10
4.2 Analyzing the variances.......................................................................................................10
4.3 Providing information to budget holders of any variances and remedial actions................11
4.4 Management report..............................................................................................................12
5.1 Future income and costs estimates.......................................................................................13
5.2 Effects of changing activity levels on unit costs..................................................................14
5.3 calculating the effects of changing activity levels on unit cost...........................................14
5.4 Factors affecting long-term and short-term decision making..............................................14
CONCLUSION..............................................................................................................................15
REFERENCES .............................................................................................................................16
Document Page
INTRODUCTION
Costing and revenue generation are two major and key aspects within an organisation that
will support the effective management of financial conditions within a firm. It helps the
organisations to monitor and manage their monetary based operations and handling different
inventories. It is also important to control the expenses that are been carried out within a firm.
The report is based on inventory and cost management of UK based retail enterprise, Marks and
Spencer. It is one of the largest retail enterprise in world with an effective management of large
number of inventories.
The assessment carries the assessment of internal reporting and providing accurate
information with different costing systems. The responsibility centre, profit centre with
evaluation of investment centres and classification of different costs. Also, the costing
procedures and expense management is been performed with various stages of an inventory and
management of different behaviours also the cost information is been evaluated. The overhead
costs will be analysed and measures of allocation, appointment and absorption is taken with
resolving of queries art cost data. Budgeting and management reports are presented with
assessment of various information for decision making and effects of changing activity levels.
MAIN BODY
1.1 Purpose of internal reporting and giving accurate information
Within an organisation, in order to have a good accessibility and management of their
cost operations and inventories, the internal reporting of various operations is very essential. This
process is carried out by almost all the organisation in order to have a significant control over
their operations and management of all sort of expenses.
It helps to monitor data redundancy, predicting future trends, identifying the resource
values and reduce chances of errors. This is vital for suitable decision making and carrying out of
different inventory management operations (Yang and Chen, 2018). The delivery of accurate
information helps to improve decision making and increase efficiency of an organisation's
management to deliver their services.
1.2 Relationship among various costing systems within M&S
Different costing systems are taken within the organisation that helps the firm to improve
the quality of services and improve the quality of services and maintain their expenses within an
organisation. The Unit costing measures the production of an individual unit of a commodity,
Document Page
using it the batch costing is been estimated. Job and Contract costing will be analyses with
process costing in order to identify the expense of producing a product or services. Other than
this, the service costing and composite costing will help in improving the qualities and services
related top the production or manufacturing and helping to evaluate the proper inventory
maintaining of the firm.
1.3 Responsibility centres, cost centres and investment centres within organisation
The responsibility centres are the section of an organisation which are looked after to
handle any sort of responsibilities within organisation and thus facilitates an effective decision
making authorities and individual managers (Weisbach, Hemel and Nou, 2018). In Cost centres,
the financial operations are undertaken by managers and are responsible for the cost management
but not the revenue generation of the firm.
Investment centres, on the other hand, are responsible for both profit or revenue
generation and resources that are invested as an asset within an organisation. It also helps in
management of different inventories and facilitates buying, selling and using divisional assets
within an organisation.
1.4 Characteristics of different cost classifications and their usage
Various costs are been classified as per the significance and functionality and their charge
against revenue. Some major cost classifications with their usage and characteristics are:
Cost Characteristics Usage
Manufacturing cost It includes the cost of raw materials,
labour and factory overhead cost.
It is used to identify the cost of
converting raw material within
finished goods.
Non manufacturing
cost
It involves the expenses of advertising,
salaries and various commissions of
sellers.
It helps the management to
identify the additional
expenses that are required to
be managed within a firm
(Nguyen, 2018).
Direct cost It can be induced or identified directly
for a product, batch or department.
It assists in identifying the
inevitable expenses for a
particular product.
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Indirect cost It cannot be traced for a particular
object of costing. They are also known
as common or joint cost.
They assist in identifying the
overhead cost and operating
expenses.
1.5 Difference between marginal and absorption costing
Marginal Costing Absorption Costing
It is a technique to access the variable cost as
product cost.
It is a technique assuming fixed cost and
variable cost as products cost.
It is considered as the variable cost and fixed
cost is assumed as cost of period.
Over the period, fixed and variable costs are
considered as product cost.
The profit is calculated using profit volume
ratio.
The profit count is reduced as fixed cost is
considered as product cost.
It indicates the contribution or share per unit. It represents net profit per unit.
2.1 Record Cost information for material, labour and expenses in accordance with the costing
procedures of M&S
Material cost is the expense that is undertaken for the assessment of the cost involved for
the purchasing and utilising the raw material, used for the production purpose. It can be termed
as the direct cost or expense and is involved in planning of inventory.
Labour cost is the expense of the work force or employees wages that are been pain by an
organisation over the conversion of a raw material to finished goods. Its main motive is to
provide suitable charges to the workers within an enterprise.
Expenses are the overhead costs that are undertaken within the organisation and can be
termed as indirect costs or payrolls. This will help in proper amassment of the business activities
and thus, will encourage the suitable pricing within M&S. The form will undertake suitable
costing or pricing measures within the organisation that will enhance the firm's revenue
generation (Shepherd, 2015).
All these are costs will be recorded or stored by the means of journals or ledgers with
entries of day to day transactions carried out at M&S.
Document Page
2.2 Analyse cost information for material, labour and expenses in accordance with the costing
procedures of M&S
The labour cost, material expense and other expenses that are been carried around within
the organisation that will help in identifying the suitable part of the operations and thus will
encourage the overall operations of the organisation that will help ion placing of the operations
and thus, will encourage the management of the organisation to enhance the quality of services
and thus will meet the operational needs of the organisation. The journals or ledgers that are
created for the recording and analysis purpose that will help in suitable planning of the business
operations and meeting the evaluation of cost or expenses within the firm.
2.3 Different stages of inventory
Different stages of inventory are been placed within the organisation that help in proper
assessment of the business expenses of M&S and thus will help in proper assessment of the
expenses carried within the organisation. The four major stages of inventory are:
ď‚· Raw material: It involves all the resources and raw material that is been required to
produce a good and consists of the basic material such as cotton, wood, grains, milk etc.
ď‚· Work in process: this involves the proper assesses of the manufacturing and production
process that is been carried out within the organisation. It also involves the assessment of
the inventory and material cost, including the overhead and also include the resource
allocation process (Ghiyasi, 2017).
ď‚· Finished goods: it is the final product or service that is been taken in consideration by
the firm like M&S. This stage involves the stocking or storing process that is carried out
by firm. This stage is susceptible to theft, falling down of prices and decrease in market
demands.
ď‚· Cost of sold goods: This is the represented as the income statement of the firm and
involves the cost of good s or products that is been sold by M&S to the customer.
2.4 Value inventory using
First in First out (FIFO):
units for sale = 68+ 140+40+78 =326
Sold units= 94+ 116 + 62= 272
Ending inventory= 326- 272= 54
Document Page
Sold goods Cost Units Unit cost Total
Sales from march 1 68 $15 $1020
Sales from march 5 140 $15.50 $2170
Sales from march 11 40 $16 $640
Sales from march 16 24 $16.50 $396
Total 272 $4226
Ending inventory
Ending inventory units Unit cost Total
Inventory from purchase on mar 16 54 $16.50 $891
Perpetual
date Purchase Sales balance
March units Unit
cost
Total units Unit
cost
Total units Unit
cost
Total
1 140 $15.50 $2170 68 $15.50 $1020
9 68
26
$15.50
$15.50
$1020
$403
114 $15.50 $1767
11 40 $16 $640 114
40
$15.50
$16.00
$1767
$640
16 78 $16.50 $1287 114
40
78
$15.50
$16.00
$16.50
$1767
$640
$1287
20 114
2
$15.50
$16
$1767
$32
38
78
$16
$16.50
$608
$1287
29 38
24
$16
$16.50
$608
$396
54 $16.50 $891
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Last in first out (LIFO):
units for sale= 60+140+70= 270
Sold units= 190+30= 220
Ending inventory= 270-220=50
Sold goods Cost Units Unit cost Total
Sales on mar 27 70 $16 $1220
Sales on mar 5 140 $15.50 $2170
Sales on mar 1 10 $15 $150
220 $3440
Ending Inventory unit Unit cost total
Inventory on purchase on 27 50 $15 $750
Perpetual
Date Purchase Sales balance
March units Unit
cost
Total units Unit
cost
Total units Unit
cost
Total
1 60 $15 $900
5 140 $15.50 $2170 60
140
$15
$15.50
$900
$2170
14 140
50
$15.50
$15
$2170
$750
10 $15 $150
27 70 $16 $1190 10
70
$15
$16
$150
$1120
29 30 $16 $480 10 $15 $150
Document Page
40 $16 $640
31 10
40
$15
$16
$150
$640
Weighted Average
units for sale= 60+140+70= 270
Sold units= 190+30= 220
Ending inventory= 270-220=50
Weighted Average Unit Cost Unit Unit cost Total
Mar 1 Inventory 60 $15 $900
Mar 5 140 $15.50 $2170
Mar 27 70 $16 $1220
270 $15.52 $4190
Cost of Sold goods 220 $15.52 $3414
Ending Inventory 50 $15.52 $776
Perpetual
Date Purchase Sales Balance
march units Unit
cost
Total units Unit
cost
Total units Unit
cost
Total
1 60 $15 $900
5 140 $15.50 $2170 60
140
200
$15
$15.50
$15.35
$900
$2170
$3070
14 190 $15.35 $2196 10 $15.35 $154
Document Page
27 70 $16 $1220 10
70
80
$15.35
$16
$15.92
$154
$1120
$1274
29 30 $15.92 $478 50 $15.92 $796
31 50 $15.92 $796
2.5 Behaviour of costs
Fixed: this are the permanent and decided costs and thus changes rarely. This includes the direct
expense and operational charges that remains constant while developing an inventory.
Variable: This are the costs that changes as per the functionality and operations. It includes the
costs and expenses including cost of raw material, machinery, transportation etc. that alters with
time.
Semi variable costs: also known as mixed cost, it is set as fixed on the various level of
production and consumption and becomes variable as production exceeds.
Stepped: It is a type of fixed cost with certain boundaries or constraints, after which it becomes
variable.
2.6 Recording cost information
Job: Job costing provides the helpful information to M&S which is related to cost of overheads,
material cost and cost of labour within a project.
Batch: Batch costing proved the information to M&S related to costs involved in making of
products in batches and compares the costs of different batches in different conditions.
Unit: Unit cost provides the information related to total expenditure which company incurs to
produce, sell and store single unit of product.
Process: It provides the information of the costs of similar units which are produced in bulk.
Service: It provides the information related to delivering a service.
3.1 Attribute overhead costs to service and production costs
Direct allocation methods: It is one of the techniques used to reallocate service departments. In
this technique no portion of overhead of a service department is reallocated to another service
department in M&S.
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Step Down cost allocation method: It is opposite to direct method which allocates cost of
service departments to another service departments and even to operation departments.
3.2 Overhead absorption rate
Overhead absorption rate= Estimated FOH / Estimated Machine Hours * 100
Estimated factory overhead
Estimated raw material
Estimated direct labour cost
Estimated labour hours
Estimated machine hours
Estimated units of output
$150000
$110000
$90000
30000 hours
25000 hours
5000 units
Details of 10 units
Estimated raw material cost
Estimated direct labour cost
Estimated direct labour hours
Estimated machine hours
$240
$200
63 hours
44 hours
Machine hours
Overhead absorption rate= Estimated FOH / Estimated Machine Hours * 100
= $150000/25000*100
= $6 per machine hours
Overhead absorption rate on the basis of machine hours:
Actual machine hours x overhead absorption rate = Total absorbed OH
44 x $6 = $264
Labour Hours
Overhead absorption rate= Estimated FOH / Estimated Machine Hours * 100
= $150000/30000 Hours * 100
Document Page
= $5 per labour hour
Overhead absorption rate on the basis of Labour hours:
Actual labour hour for job x Overhead absorption rate = Total absorbed OH
63 hours x $5 = $315
3.3
(a) Normal working hours
(No. of machine * hours per week * No. of week p.a.)
(28*42*48) 56448 hours
Normal loss of hours on maintenance 6720 hours
Effective working hours p.a. 49728 hours
Machine hour rate
= $124320/49728 $2.50
(b )Over absorption of wages and overhead
Overhead absorbed= 4200 hours @ $2.50 $10500
Over head incurred
Over absorption
$10200
$300
Wages absorbed= (28*42*4) hours @ $15 $7056
Wages incurred
Under absorbed
$7400
$344
3.4 Reviewing allocation, apportionment and absorption methods
Allocation, apportionment and absorption methods can be helpful for M&S in various
ways it will help M&S in making the proper judgments for measuring the departmental
efficiency. By reviewing these methods M&S can fix the price of their products. It will help in
controlling of wastage and reduction of defective pieces within the company (Coffin and
Document Page
Cooper, 2017). Reviewing these methods M&S can determine the costs of a product, can supply
the information of the cost to the management.
3.5 Resolving queries in overhead cost
M&S needs to communicate with the different departments within the organization and
try to resolve the issues and queries related to the overheads costs. M&S have to set proper
communication with production managers, project leaders, project managers, service managers
other departmental heads to resolve queries related to overhead costs.
4.1 comparison of actual costs with budget costs
At the end of the financial period, budgeting technique assists M&S in measuring the
performance of the organization against the plan so that it can improve its future performance.
Within the organization budget costs are compared with the actual costs to determine the
variances of the budget (Lalonde, 2015). At the beginning of the financial budget is a plan and at
the end of a financial budget is a instrument for controlling performance against the plan in order
to improve the performance of M&S. Budgeted costs are compared to actual costs to determine
the variances of budget in M&S and by determining the variances M&S can whether the
variances are controllable or not. If the variances are controllable actions must be taken in order
to correct the problem.
4.2 Analyzing the variances
Main objective of analyzing the variances in M&S is to control the costs and also to
reduce the costs. By analyzing the variances M&S can determine the overall variances and can
take the remedial actions as to prevent the future variances. Analyzing the variances M&S can
fix the responsibility of department or individual or even a section to fix the variances separately.
With the help of variances analysis M&S can highlight the inefficient performances within the
organization. Variance analysis results in the cost reduction and controlling of the costs and also
creates cost consciousness in the minds of the employees in M&S (Azzimonti Battaglini and
Coate, 2016). During variance analysis M&S takes controllable variances into consideration for
actions and profit planning work is carried out by the top management of M&S.
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Illustration 1: Variance Analysis
(Source: Variance Analysis, 2018)
4.3 Providing information to budget holders of any variances and remedial actions
Budget holders should be provided with a regular information monthly or quarterly which
should be accurate and transparent information. Finance managers should provide the
information related to material yield variance, labour rate variances, overhead spending variance,
purchase price variance.
Remedial Action: In order to fix the variances M&S's remedial actions should be
ď‚· M&S should analyze the reasons of variances properly by asking the questions
ď‚· M&S should try to find out the variances and try to fix them as soon as possible.
ď‚· Variance can be used to improve the results in the manufacturing process related to
material, labor and overheads.
ď‚· M&S should formulate better budgeting plans in order to minimize the variations.
4.4 Management report
Sales budget: Sales budget is also called as principal budget as all other budgets are prepared on
the basis of sales budget (Basu, Cready and Paek, 2016). Sales budget is the financial plan that
shows how the resources should be allocated in order to achieve the foretasted sales for the
organization. It is the management's sales estimates for future financial year. A proper sales
budget should be prepared in order to achieve the objectives of sales department. An objective of
Document Page
sales budget is to plan and to have control on expenditure of resources which is important for
achieving the desired sales objective.
Illustration 2: Sales Budget
(Source: Sales Report, 2019)
Cash-budget: It is the written estimate of the organization's future cash point. It is the
presentation of expected circular of cash within the business. Cash budgets depicts the movement
of cash and depicts whether the company has sufficient funds to hold regular business options. It
is very important as it helps to avoid shortage of funds during a period in which a company is
encountering high number of expenses.
Document Page
Illustration 3: Cash Budget
(Source: Cash Budget, 2019)
5.1 Future income and costs estimates
Relevant cost: It refers to the incremental and avoidable cost of implementing business. It helps
in determining the cost of a business decisions and relates to the specific management decision.
It will help the M&S in eliminating unnecessary data that would complicate the decision-making
process in M&S.
Break-even analysis: It is calculation of the point at which company's revenue is equal to
expenses. It categories the production costs between those which are variable and those cost
which are fixed (Butler and MacGuineas, 2017). It will the M&S to know the number of units to
be sold in order to get break-even point where there is no profit and no loss.
Margin of safety: Margin of safety is the difference between the break-even sales and actual
sales or in other words it can be defined as total sales revenue above the break-even points is the
margin of safety (Grönroos and Ojasalo, 2015). It tells the management of M&S to which level
revenue is reduced to achieve break-even.
Target profit: Target profit help in determining the estimate the business activities which M&S
has to perform in order to earn target profit in a given period of time.
Profit-volume analysis: Profit-volume analysis help M&S to analyse whether new products
produce by M&S are like to be profitable or not. It also helps in determining total sales volume
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
to avoid losses and total sales volume at which the organization can achieve its profit goal in
future.
Limiting factors: Limiting factor restricts the organizations activities. It can be related to raw
materials, labour hours, machine, space etc.
Payback: It helps in determining the to length of time required to recover initial cash which an
organization outlays in a project. It helps M&S to analyse the risk such as how long an
investment will be at risk.
Discounted cash flow: Discounted cash flow helps M&S in valuing a project or asset by using
the concepts of time value of money. With the help of DCF M&S can calculate present value of
an investment's future cash flows in order to attain the current fair value estimates for the
investment.
5.2 Effects of changing activity levels on unit costs
Following will be the effects of changing the levels on unit cost:
1. If the level of activity increases, variable and fixed costs per unit will also increase.
2. Total variable cost and fixed cost will also increase
3. variable cost per unit and total cost will increase
4. fixed cost per unit will decrease and total cost will increase.
5.3 calculating the effects of changing activity levels on unit cost
5.4 Factors affecting long-term and short-term decision making
Factors affecting long-term and short-term decision making are as follows:
Illustration 4: Changing Activity levels on unit cost
Source: (Effects on changing Activity levels on unit cost, 2019)
Document Page
Short-term decision making: Rate of interest, cash flows and rate of return.
Long-term decision-making: Sources of capital,cash flow budget, risk on long-term
investments, rate of return on investments, outlook of the management, technological changes
(McKeough, 2018).
CONCLUSION
It can be concluded from the report that costs and revenues have an important role within
an organization. It is important for the organization to record various types of cost and the
information achieved is helpful in framing a budget for the organization for future financial
period. It can also be concluded that are some variations in actual and cost budget and these
variances should be minimized by the organization in order to make budgeting more efficient.
Document Page
REFERENCES
Books and journals
Azzimonti, M., Battaglini, M. and Coate, S., 2016. The costs and benefits of balanced budget
rules: Lessons from a political economy model of fiscal policy. Journal of Public
Economics. 136. pp.45-61.
Basu, S., Cready, W. M. and Paek, W., 2016. Measuring Matching Using Reported Revenues
and Expenses.
Butler, S. and MacGuineas, M., 2017. A long-term budget for entitlements and required
revenues. Brookings Economic Studies, Re-Imagining the Federal Budget Process
Discussion Paper Series. (5).
Coffin, S. and Cooper, B. S., 2017. Budgeting and Managing for Local Revenues. Sound School
Finance for Educational Excellence. p.89.
Farnsworth, D. and et.al., 2017. Economic analysis of revenue losses and control costs
associated with the spotted wing drosophila, Drosophila suzukii (Matsumura), in
the California raspberry industry. Pest management science. 73(6). pp.1083-1090.
Ghiyasi, M., 2017. Inverse DEA based on cost and revenue efficiency. Computers & Industrial
Engineering. 114. pp.258-263.
Grönroos, C. and Ojasalo, K., 2015. Service productivity as mutual learning. International
Journal of Quality and Service Sciences. 7(2/3). pp.296-311.
Lalonde, D. H., 2015. Revenues Increase and Costs Decrease With WALANT. Wide Awake
Hand Surgery. p.11.
Nguyen, T.P.T., 2018. Comparison of efficiency and technology across the banking systems of
Vietnam, China and India: a stochastic cost and revenue meta-frontier
approach. Benchmarking: An International Journal. 25(9). pp.3809-3830.
Shepherd, R.W., 2015. Theory of cost and production functions (Vol. 2951). Princeton
University Press.
Wang, Y., Meng, Q. and Du, Y., 2015. Liner container seasonal shipping revenue
management. Transportation Research Part B: Methodological. 82. pp.141-161.
Wei, Q. and et.al., 2018. Joint optimal decision of the shared distribution system through
revenue-sharing and cooperative investment contracts. Industrial Management &
Data Systems.
chevron_up_icon
1 out of 19
circle_padding
hide_on_mobile
zoom_out_icon
logo.png

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

Available 24*7 on WhatsApp / Email

[object Object]