MALec Batch 3
MALec Batch 3
MALec Batch 3
Management Accounting
Lecture Notes
Lecture 12
Topics Covered
207
Risk and Uncertainty in decision making
Investors are risk averse that is, they do not like risk and can only be induced
to accept higher risk if they are offered a higher return.
Aggressive Investor
Conservative Investor
Expected value = Σ n X p
Lecture Illustration
Suppose that a project has the following profile
Required: Calculate the expected profit and sales volume given the
probabilities
Expected Profit
=
208
Lecture Illustration
Demand Probability
(units)
Worst possible outcome 10,000 0·3
Most likely outcome 22,000 0·5
Best possible outcome 35,000 0·2
The selling price per unit is $25. The variable cost per unit is $8 for any
production level up to 25,000 units. If the production level is higher than
25,000 units, then the variable cost per unit will decrease by 10% and this
reduction will apply to all the units produced at that level.
Required:
Calculate the expected budgeted contribution of the product?
(n) (p)
Demand Contribution Total Expected
Unit per Unit Contribution X Prob. Contribution
$ $ $
10,000
22,000
35,000
209
Decision rule using Maximax, Maximin and Regret criteria
Maximax - Choose the alternative with the maximum benefit in the best
situation.
Maximin - Choose the alternative with the maximum benefit in the worst
situation.
1) Maximax Rule
Select Project
2) Maximin Rule
Select Project
210
Nobody likes to regret and hence
Regret Criterion we want to minimise regret
Minimax regret rule aims to minimize the regret from making the wrong
decision. Regret is the opportunity loss through making the wrong decision.
Regret = Profit from best action taken Less Profit from action actually taken
The regret criterion is that option selected which minimizes the maximum
potential regret for any possible outcomes.
Lecture Illustration
Determine which project should be undertaken using the regret criterion rule.
C
Decision: Select Project as minimum regret is
211
OR
Project
Outcome A B C
$ $ $
1
Maximum Regret
Lecture Illustration
The budgeted demand for product X will be 11,500 units if the price is $10.
8,500 units if the price is $12 and 5,000 units if the price is $14. Variable cost
are estimated at either $4,$5 or $6 per unit. A decision needs to be made on
the price to be charged.
Required;
Construct the contribution table showing the budgeted contribution for each of
the nine possible outcomes and determine the price to be charged for the
following decision rules:
a. Maximax
b. Maximin
c. Regret criterion
212
Per Unit Answer
Variable Contribution Total
Unit Price Cost Per Unit Contribution
$ $ $ $
11,500 10
11,500 10
11,500 10
8,500 12
8,500 12
8,500 12
5,000 14
5,000 14
5,000 14
(a) Maximax
10
12
14
Decision: Choose low price of $10m maximum total contribution of
$
213
(b) Maximin
10
12
14
C. Regret Table
Variable Cost
Maximum
Price $4 $5 $6 Regret
$ $ $ $ $
10
12
14
214
Lecture Illustration
Required: For each of the six possible profit outcomes which could arise
for in the coming year.
a) Calculate the expected value of profit for each of the two price options and
recommend, on this basis, which option should be chosen.
$30 $35
Up to 100,000 Units
215
Price of $30
Prodn (n)
Volume Contribution Total Fixed Fixed Total
Unit per Unit Contribution Cost Advertising Profit
$ $’000 $’000 $’000 $’000
120,000 19
110,000 19
140,000 19
Expected Profit = Σn X p
Price of $35
(970 + 450) (n)
Volume Contribution Total Total Total
Unit per Unit Contribution Fixed Cost Profit
$ $’000 $’000 $’000
108,000
100,000
94,000
Expected Profit
Decision:
b) Maximin
Maximum Total Profit in Worst situation (Lowest Profit)
Price Lowest Profit
$ $
216
Exam Tip
Decision Trees Decision tress fairly popular for section B of exam
Decision Trees
Square represents
Decision point
Every decision tree starts from a decision point with the decision options or
choices are shown as branches on the tree.
In the exam, remember to draw the decision tree neatly, using a pen and
ruler. Remember to label the decision points and branches as clearly as
possible.
217
Lecture Illustration
Required:
Draw a decision tree.
Exam Tip: Draw diagram neatly in
exam, using a ruler to draw
straight lines. Its pays to be neat
and professional in the exam.
Decision
218
Lecture Illustration
A company is considering the launch of a new product. It can now either test
the product or abandon it.
If it test,the product, it will cost $100,000 and the market response will either
be positive or negative with probabilities of 0.6 and 0.4 respectively. If the
response is positive, the company could either abandon the product or market
it full scale.
If it markets the product, the demand might be low, medium or high and the
probability of this is 0.2, 0.5, 0.3 respectively with profits of ($200,000),
$200,000, or $1000,000.
If the result of the test market is negative and the company goes ahead and
markets the product, estimated losses would be $600,000. At any point if the
company abandon the product, there would be a net gain of $50,000 from the
sale of scrap.
Required:
Draw a decision tree.
Decsion Tree
219
At Point E
C Decision:
Market =
Abandon =
Decision:
Market =
Abandon =
Decision:
A If Test
Expected Profit =
Abandon =
Decision:
Conclusion:
1) Test Product
2) If Result
Action
Positive:
Negative:
220
University of London
Management Accounting
Lecture Notes
Lecture 13
Topics Covered
It’s a good one to focus on as there is not many ways the examiner can
vary the question as the approach to the solution is very structured so
pay attention to the technique taught in this lecture.
221
Linear programming is an optimization technique used to maximize total
contribution (the objective function) given multiple constraints.
There is a single objective which is to maximise total contribution. (not total profit)
Techniques:
Step1 - Define the two products. Normally using 2 alphabets for example A, B.
Step 2 - Determine the objective function which is to maximise total contribution Not
maximise
Step 3 – Specify the constraints profit
A constraint is a mathematical inequality that must be
satisfied by the variables.
Step 4 – Draw the graph and compute the optimal solution.(required in exam)
Note:
1) In the short-term, total fixed cost is constant, hence as
long as total contribution is maximised, total profit will also
be maximized.
222
Lecture Illustration 1
Each type of project A requires twenty hours of work from qualified researchers
and eight hours of work from junior researchers.
Each type of Project B requires twelve hours of work from qualified researchers
and fifteen hours of work from junior researchers.
Project type:
A B
$ $
Revenue per project 1,700 1,500
Direct project expenses 408 310
Administration 280 270
Administration cost are attributed to projects using a rate per project hour. Total
administration cost are $28,000 per four week period. Judge: Administration is a _____ cost.
During the four-week period ending 30 June of the current year, owing to holidays
and other staffing difficulties, the number of working hours available are:
An agreement has already been made for twenty type A projects with XYZ group.
RAB consulting must start and complete these projects in the four week period
ending 30 June.
RAB consulting is preparing its detailed budget for the four-week period ending 30
June and need to identify the most profitable use of the resources it has available.
223
Required:
Calculate the mix of projects that will maximise profit for RAB consulting for the
four-week period ending 30 June. (Note: projects are not divisible)
Step 1 – Define the 2 products
Labour
Qualified researchers(QR)
A
B
Junior researchers(JR)
A
B
Total contribution
Objective function:
Since A = no. of A project
undertaken, B= no. of B projects
Maximise undertaken, this equation
represents the total contribution
Step 3 -State the constraint
Labour constraint
QR
JR
Demand constraints
A
B
Note that the non-negativity constraint must
Non negativity constraints always be stated in business linear
programming (LP) as the number of units sold
cannot be negative.
In engineering LP, variables such as
temperature can be negative, example -5%
celcius.
224
Exam tip: Graph paper will be provided in the
exam for LP questions
Step 4 – Draw graph
Before drawing the graph, always determine the size of the co-ordinates so
that the graph can be drawn to scale on the graph paper.
B=0 A=
Optimal solution:
Optimal solution will be derived at the extreme of the feasible region at
Points A, B,C, D and E in the graph.
Exam Tip:
Choose only 1 method to use in the exam, as both methods will derive the
same solution.
The feasible region represents all combination of projects that can be done
that will satisfy all the constraints.
For example, doing 40 project A and 20 project B is in the feasible region and
hence these number of projects will meet all constraints but will not give the
maximum total contribution as the maximum total resources will not be used
for this solution.
To derive the highest total contribution and hence the highest total profit, the
solution must be derived at the extreme point of the feasible region to the right
of the graph as this is where the maximum resources available will be utilised.
225
GRAPH
226
Exam tip:
Deriving the optimal solution Method 1- Use need a long ruler to do this method
Method 1 - Draw the OF line and shift it to the extreme point of the feasible
region, without changing the slope of the OF line.
Step 1
Using trial and error, set the first point of the OF line. The OF line should be
clearly visible on the graph and on the left side of the graph.
Step 2
For example, select co-ordinate A = 40, B= 0 (x axis point)
OF = (580 X 40) + 0 = 23,200 (This is now a fixed total, don’t change it)
Hence, the optimal solution is at point C, the intersection of the JR and the QR
line.
227
Method 2
Step 1 -Compute the total contribution at the extreme point of feasible region
ABCDE.
Note:
Method 1 and 2 derive the same solution, so use only 1 method.
228
Slack, Binding Constraint
When the maximum availability of the resources is not used up at the optimal
solution, the resource is said to be slack.
Lecture Illustration 2
Refer to the previous Illustration 1 and identify the binding constraint and the
slack.
This fact could be determined from inspecting the point c in graph. Both
resources are binding, because the optimal solution is on the JR and
the QR line, hence the maximum resources are used at this point.
229
Limiting factors and shadow prices
A shadow price or dual price of a limiting factor is the increase in benfit (total
contribution) which would be created by having one additional unit of the limiting
factor at the original cost.
230
Lecture Illustration 3
Recently, however, a new treatment has been successfully introduced. This is:
• A partial knee replacement requiring one and a half hours of theatre time
and a shorter recuperation period. However, this procedure is only
suitable for younger, more active patients.
The hospital is paid for each treatment based on a national tariff, calculated using
absorption cost.
Facilities are limited. The team has use of an operating theatre for two six-hour
sessions per week (and for 50 weeks per year) and a small dedicated ward of
eight beds (also for 50 weeks per year).
231
Direct Variable Costs in the wards are £60 per patient per day.
Follow-up home visits are charged by the local community trust at £40 per visit.
Ward Fixed Expenses are £160,000 per annum.
General Hospital Overheads allocated to the knees unit are £130,000 per
annum.
Required:
(a) Calculate the contribution per unit of each procedure for each of the limiting
factors.(6 marks)
(b) Are there good financial reasons for dropping one of these procedures? If
so, which? (2 marks)
(c) Calculate the maximum number of each procedure that can be undertaken
given the constraints on operating theatre time and bed-days available.
(4 marks)
Part d is a LP solution
(d) Calculate the maximum contribution that can be earned given the as there are 2
constraints on theatre time and bed-days. (6 marks) constaints.
(e) If the hospital management could be persuaded to make more theatre time
and/or bed-days available, calculate the direct (shadow prices) for a bed day.
(2 marks)
National Tariff
Drugs
Theatre Time
Ward Stay
Home Visit
Contribution
232
We never produce/sell
products with negative
contribution.
(b) Drop Blow out as negative contribution of £200.
T. Time
B. Days
Maximum:
Total Replace = procedures p.a. assume zero partial done.
When you apply both the constraints, you need to select the lower
number of procedures.
233
( d) Linear Programming
Maximise
Step 3 - Constraints
OT Time =
Bed Days =
T, P ≥ 0
Graph: Planning
T = 0 P =
Co-ordinates
P = 0 T =
Maximum
T = 0 P =
Co-ordinates
P = 0 T =
Planning
X Axis = T Y Axis = P
For example:
X = 50 procedures per square
Y = 100 procedures per square
234
Solution:
OF = 1,640T + 660P
(Trial + Error)
If T = 0, P = 200
If P = 0, T = 81
T = 132,000 = 80.49
1,640
Optimal Solution:
1) Optimal solution is derived by shifting the OF Line to
the extreme point of the feasible region ABCO, without changing the
Optimal Solution:
Max Contribution:
235
OR Method 2
Optimal Solution
236
e)
Steps in computing a shadow price
Exam tip:
All this work for 2 marks, may not be worth it!
237
GRAPH
238
This part for section
B of exam only.
Bottleneck Operations & the Theory of Constraints (TOC)
All other cost (including direct labour) are fixed in the short run and that the only
truly variable cost is material cost only.
The TOC concept aims to increase throughput contribution and reduce inventory
and operating expense.
4. Elevate the bottleneck (in other words, solve the problem, for example, by
replacing the machine if it is faulty or using a subcontractor).
239
Example: Bottleneck operations
Process 1 Process 2
Maximum Capacity Maximum Capacity
=100,000 units =80,000 units
Demand in
unlimited, can sell
all production
units
Steps
1) Identify the system’s bottlenecks.
_Answer
2) Decide how to exploit the bottleneck.
Example:
a. Slow down process 2 to 80,000 units, eliminating the long que at
process 2.
4) Elevate the bottleneck (in other words, solve the problem, for example, by
replacing the machine if it is faulty or using a subcontractor).
240
Situations in which it may be more appropriate to use linear programming
approaches as a decision tool rather than “Theory of Constraints”
Linear programming is most relevant where there are several limited resources
and shared by several products. The approach assumes that it is possible to
identify, all variable costs (not only materials), revenues and resource use for all
products involved. The method can respond quickly to changes in prices and
variable costs.
The technique requires good information relating to all the costs, revenues and
constraints. As a powerful mathematical model it can also calculate shadow
prices for all the limited resources.
Summary
241
Lecture 13- Homework Questions
Short answer questions
Q1
Given the following graph, at which the following point will the total profit be maximized?
y
B
C
D
242
Q2
The following graph has been established for a given set of constraints:
The objective function (OF) for the company has also been plotted on the graph
and the feasible region is bounded by the area ABCD.
300
200
A
100 D
OF
Required:
At which point on the graph will profits be maximised?
243
Q3
The following graph relates to a linear programming problem:
(1)
(2)
(3)
The objective is to maximise contribution and the dotted line on the graph
depicts this function. There are three constraints which are all of the ‘less
than or equal to’ type which are depicted on the graph by the three solid
lines labelled (1), (2) and (3).
Required:
At which of the following intersections is contribution maximised?
Q4
Briefly describe what is the shadow price of a resource in linear programming ?
244
Question 1
AZ Ltd makes three products H, Y and C. All three products must be offered for
sale each month in order to be able to provide a complete market service. The
products are fragile and their quality deteriorates rapidly once they are
manufactured.
The products are produced on two types of machine and worked on by a single
grade of direct labour. Five direct employees are paid $8 per hour for a guaranteed
minimum of 160 hours each per month.
All of the products are first moulded on a machine type 1 and then finished and
sealed on a machine type 2.
The machine hour requirements for each of the products are as follows.
The capacity of the available machines type 1 and 2 are 600 hours and 500 hours
per month respectively.
Details of the selling prices, units costs and monthly demand for the three product
are as follows.
Although ABC uses marginal costing and contribution analysis as the basis for its
decision making activities, profits are reported in the monthly management
accounts using the absorption costing basis. Finished goods inventories are
valued in the monthly management accounts at full absorption cost.
245
Required
a)Calculate the machine utilisation rate for each machine each month and explain
which of the machines is bottleneck/limiting factor.
Question 2
Toymaker Ltd makes and sells three products. The forecast costs, use of
production facilities and demand figures are as follows:
For the forthcoming year the total machine time available will be 120,000 hours
and because of a lack of skilled workers, a total of 140,000 hours of assembly
time is available.
Required:
(a) Determine whether the company can meet the total demand from the
machine and assembly time available. (3 marks)
(b) One of the three products has the highest contribution per limiting factor for
both machining and assembly so the company wishes to make sufficient of this
product to meet market demand. Identify this product and indicate the number of
hours remaining in machining and assembly to make the two remaining products.
(4 marks)
246
(c) Incorporating the production and market constraints calculate the optimal
production schedule for the two remaining products. (8 marks)
(d) Calculate the maximum profit which the company would make given the
constraints.
(2 marks)
(e) Calculate the dual (shadow price) for each of the production constraints and
explain how this information would be used by the company. (8 marks)
UOL adapted
Question 3
(a) i. Meeting customers’ expectations is vital for profitability. Explain the term
“customer response time” and describe, with examples, two reasons why delays
in meeting customer expectations occur. (5 marks)
ii. Describe how customer response time could be improved in a student canteen
and how the costs and benefits could be quantified. (4 marks)
iii. Discuss the situations in which it may be more appropriate to use linear
programming approaches as a decision tool rather than “Theory of
Constraints”. (6 marks)
247
Question 4
Superskis Ltd makes and sells three products. The forecast costs, use of
production facilities and demand figures are as follows:
For the forthcoming year the total machine time available will be 120,000 hours
and because of a lack of skilled workers, a total of 144,000 hours of assembly
time is available.
Required:
(a) Determine whether the company can meet the total demand from the
machine and assembly time available. (3 marks)
(b) One of the three products has the highest contribution per limiting factor for
both machining and assembly so the company wishes to make sufficient of this
product to meet market demand. Identify this product and indicate the number of
hours remaining in machining and assembly to make the two remaining products.
(4 marks)
(c) Incorporating the production and market constraints calculate the optimal
production schedule for the two remaining products. (8 marks)
(d) Calculate the maximum profit which the company would make given the
constraints. (2 marks)
(e) Calculate the dual (shadow price) for each of the production constraints and
explain how this information would be used by the company. (8 marks)
248
UOL- Management Accounting
Lecture Notes
Lecture 14
Topic: Capital Investment Decisions and Life cycle costing
Reading : Capital Budgeting :Horngren Chapter 13, pages 387 to 402 only.
Life cycle costing : Horngren Chapter 12, pages 366 to 369 only
Lecture 14
The first part of this lecture is based on long run decision making
involving capital expenditure where the benefits are received over
many years. This part is very frequently tested in Section A of the
exam.
The second part deals with life cycle costing which is also quite often
tested in Section A of the exam.
249
Capital Budgeting
Because of the long-time frame of recovery, the time value of money must be
considered.
The methods essentially are used to determine if the benefit received from the
non-current asset is greater than the cost of the asset.
When the benefit is greater than cost of the asset, the non-current asset should
be acquired.
When the benefit is less than cost of the asset, the non-current asset should not
be acquired.
Techniques of Appraisal:
2) Payback Method
250
Accounting Rate Of Return (ARR )
This the measure which is used when the objective is to maximise reported profits.
The Project’s ARR is defined as ratio of average profit to capital invested. Don’t forget to
deduct
Accounting Rate of Return = Average Profit X 100% depreciation to
==================== derive profit
Average Capital invested
The decision rule is to accept the investment whose ARR exceeds a given target
rate or the highest ARR if a choice exists between mutually exclusive projects.
The higher the ARR
the better.
251
Lecture Illustration 1
Your company plans to buy a new machine to meet expected demand for a new
product, Product T. This machine will cost $250,000 and last for four years, at the
end of which time it will be sold for $5,000. The expected demand for Product T to
be as follows:
When given the selling
price and variable cost,
Year 1 2 3 4 compute contribution per
Demand (units) 40,000 45,000 50,000 25,000 unit as this is faster.
The selling price for Product T is expected to be $12.00 per unit and the variable
cost of production is expected to be $7.80 per unit in year 1. Incremental annual
fixed production overheads of $25,000 per year will be incurred. Both the selling
price and variable cost are expected to increase at a rate of 5% per annum.
Required:
Calculate the Accounting Rate of Return based on the average investment and
comment on your findings.
252
Average Capital invested =
Average Profit
Year
1 2 3 4
$
Total Contribution 719,450
Total Depreciation
Total Profit
Average Profit =
ARR =
Decision:
2) Managers are very familiar with the ARR as it is often used by them for
performance measurement and hence will be comfortable to use it.
253
Disadvantages
For example, the use of different accounting policies may result in different
amount of profit reported.
254
For the other methods such as payback
and NPV, use cash flows instead of profit
2. Payback Method
Payback period refers to the number of years it takes to recover the initial
investment.
The decision rule is to accept the project with the shortest payback. The shorter
the period the better.
Step 1
To calculate the payback period of a project, set up the following table:
Cash Flow
Cash Inflow Cumulative Cash
Year Description (Cash Outflow) Flow
0 Initial Investment (initial investment) (initial investment)
1 Cash Inflow Cash Inflow
2 Cash Inflow Cash Inflow
Step 2
Fill in the cash inflows for the project life until the balance in the cumulative
column (column 4) changes from negative to positive.
Step 3
Determine the Payback Period as = A . a/b years
Step 4
Select the project with the shortest payback.
255
When dealing with the information provided in capital budgeting, it is
important to understand the timing of the cash flows.
1) Cash flows are always assume to occur at the end of the year
concerned, hence all cash flows are one year apart.
2) For example, the cash flows associated with asset A will look as follows
on a time line assume the asset was purchased on 1st January 2020.
(Yr = Year)
Asset A
Note that Year 0 is not a year in itself, it simply represent the start of the
investment.
256
Advantage of Payback Method
1) Simple to use.
2) More objective as it uses cash flow instead of accounting profit. Better than ARR
3) Favours projects with a short payback. This will produce faster growth and
ensure more liquidity especially for smaller companies.
Disadvantage
Central to the use of the NPV method is the principle that a dollar received today
is worth more than a dollar received in the future. (This is termed the “time value
of money)
This method involves discounting all future cash in-flows and out-flows to present
day and compare this to the initial investment at present. The net result is the
NPV of the project.
Decision Criteria:
The discount rate to be used is the cost of capital and this refers to the cost of
funds raised that are used in the investment, for example to pay for the initial
investment.
If you are asked to select between two projects, select the project with the
highest NPV.
When computing the NPV, only relevant cash flows are considered.
257
Assume you invest $100 today in the bank and earn 10% interest. You reinvest
the interest earned at the end of year 1
Today Yr 1 Yr 2
$100 $110 $121
Present Future Future
Value(PV) Value(FV) Value
#
(#%&)!
= Present Value factor (PVF) which is provided in the exam.
Discounting cash flows refer to the process of deriving the present value for a
given future value.
Note that the difference between future value and present value is the interest.
258
Review of POA
When considering the time value of money, we cannot add future value to present value because
their values is not the same.
Hence the same should be for the following below! They cannot be
added.
Time
Currency
$100 Yr 1
$100 Yr 2
$100 Yr 3
259
Lecture Illustration
Duo Co needs to increase production capacity to meet increasing demand for an
existing product, the annex.
A new machine, with a useful life of four years and a maximum output of 600,000
kg of annex per year, could be bought for $500,000, payable immediately. A
feasibility study to determine the viability of the machine was carried out three
months ago costing $10,000 and this amount will be paid for next month.
The scrap value of the machine after four years would be $30,000. Forecast
demand and production of annex over the next four years is as follows:
Year 1 2 3 4
Demand (kg) 1·4 million 1·5 million 1·6 million 1·7 million
Existing production capacity for annex is limited to one million kilograms per year
and the new machine would only be used for demand additional to this.
The current selling price of annex is $8·00 per kilogram and the variable cost of
materials is $5·00 per kilogram. Other current variable costs of production are
$1·90 per kilogram. All revenue and cost are expected to increase at a rate of 4%
per annum.
Fixed costs of production associated with the new machine would be $240,000 in
the first year of production, increasing by $20,000 per year in each subsequent
year of operation.
Exam Tip- Always follow instructions
Duo Co cost of capital is 10% per annum. in the exam
Required:
(a) Calculate the net present value of buying the new machine and advise on the
acceptability of the proposed purchase (work to the nearest $1,000).
260
Steps in answering an NPV question
1) Read the requirement
2) Read the question and determine the life of the project
3) Highlight all relevant cash flows
4) Prepare the NPV table, taking into consideration the life of the project
5) Insert all relevant cash flows in the respective years
6) Add the total cash flows for each year to get net cash flow
7) Multiply the total cash flows by the discount rate to derive the present value for each
year.
8) Add the total present values
9) Derive the NPV = Total present value of cash inflows – present value initial investment
10) Make the decision: NPV+ = Accept, NPV - = Reject
Note:
For the payback period in part b, use the net cash flow from step 6 above to
compute the payback period, not the present values of the cash flows.
261
(a) NPV
Scrap Value
Present Value
NPV
Decision:
1 Cash Inflow
2 Cash Inflow
262
Working
Years
1 2 3 4
X Sale Units
263
Advantage of the NPV
¨ It takes into account all expected cash flow from the project, unlike the
payback method.
¨ It assumes that any cash inflow during the life of the project can be reinvested
at the cost of capital. This is a reasonable assumption.
264
Life Cycle Costing
Product life cycle spans from Research & Development activity until the decline
of the product.
Life cycle costing focuses on revenues and cost for each product over the entire
life cycle so that the total profitability of the product can be determined over the life
cycle, not just over one year.
The traditional accounting systems do not accumulate the cost over a product life
cycle, but instead records the cost over a twelve months in line with the financial
year.
Hence, it may be difficult to assess the product profitability over its entire life, if we
depend on the traditional accounting system.
Life cycle costing is the accumulation of cost over the product’s entire life cycle so
that the right decision can be made to launch only profitable products.
265
Every product goes through a life cycle.
(a) Development. The product has a research and development stage where
costs are incurred but no revenue is generated.
(c) Growth. The product gains a bigger market as demand builds up. Sales
revenues increase and the product begins to make a profit.
(d) Maturity. Eventually, the growth in demand for the product will slow down
and it will enter a period of relative maturity. It will continue to be profitable.
The product may be modified or improved, as a means of sustaining its
demand.
(e) Decline. At some stage, the market will have bought enough of the product
and it will therefore reach “saturation point’. Demand will start to fall.
With life cycle costing, non-production costs such as research and development
are traced to individual products over complete life cycles.
The total of these costs for each individual product can therefore be reported and
compared with revenues generated over the entire life cycle to determine the
product profitability over the entire life cycle.
The visibility of such costs and revenue is increased. The full set of revenues and
costs for each product become visible, particularly research and development,
marketing and customer service and disposal costs.
266
Companies that can benefit from using life cycle costing
2) Have very short lifecycles e.g. mobile phones, cosmetics. The maximum life
cycle should be no more than three years as it becomes very difficult to forecast
cost and revenue beyond three years.
Lecture Illustration
DataExclusive Ltd has been trading for a few years as a software company,
developing high quality software products for industrial applications. Each
product has an estimated life of two years.
The company has noticed that their annual profits are erratic and have decided to
investigate, in detail, the profitability and cost structures of three of their products
which have just completed their economic lives. The details are shown below:
For Product QM, in an effort to reduce costs, the research and product design
was kept to a minimum.
Never a good idea to compromise the quality of the
product
267
Required
(a)Calculate the product life cycle income statement for each software
package.(10 marks)
How would you analyse which of these 2 companies has been better able
to control cost?
Co 1 Co 2
$ Million $ million
Sales 12 106
Expenses (3) (15)
Profit 9 91
Cost structure
268
Product Life cycle Income Statement
Product IM DL QM
£000
Description Yr 1 Yr 2 Total Yr 1 Yr 2 Total Yr 1 Yr 2 Total
Less: Cost
Customer
Support 1,750 1,300 5,280
Profit Margin
(b)
Product QM
1)Product QM is the product with the lowest profit margin(7%) and the highest
cost structure.( 93%)
2) Low profit in year 2 was due to the high customer support cost incurred due to
the poor design.
3) To improve profitability, more effort put into research and design.
Product DL
1)Product DL has the highest profit margin(25%) and hence lowest cost structure.
2)Lowest cost structure due to adequate research undertaken.
269
Product IM
1)Product IM is the product with the highest sales growth in year 2 and also the
highest total profit.
2) Highest sales growth in Year 2 due to the higher marketing cost and adequate
attention to research and design.
Exam Tip
Life cycle costing questions quite popular in Section A of exam.
Its actually easy to do this question as long as you structure the answer well as all
you are actually doing is “cut and paste” for an easy 10 marks.
Life-cycle budgeting
Life-cycle budgeting is the process in which managers estimate revenues and
business function costs of the entire value chain.
These factors make life-cycle budgeting important:
1) The development period for R&D is long and costly. These costs must be
recovered over the life span of the product.
2) Many costs are locked in at the R&D and design stages. Poorly designed
products require higher marketing and customer service costs.
270
Homework Questions- Lecture 14
Question 1
Trecor Co plans to buy a new machine to meet expected demand for a new
product, Product T. This machine will cost $250,000 and last for four years, at the
end of which time it will be sold for $5,000. Trecor Co expects demand for
Product T to be as follows:
Year 1 2 3 4
Demand (units) 35,000 40,000 50,000 25,000
The selling price for Product T is expected to be $12.00 per unit and the variable
cost of production is expected to be $7.80 per unit. Incremental annual fixed
production overheads of $25,000 per year will be incurred. Selling price and costs
are all in current price terms.
Increase
Selling price of Product T: 3% per year
Variable cost of production: 4% per year
Fixed production overheads: 6% per year
Required:
Calculate the Accounting rate of return based on the average investment and
comment on your findings.
271
Question 2
PV Co is evaluating an investment proposal to manufacture Product W33, which
has performed well in test marketing trials conducted recently by the company’s
research and development division. The following information relating to this
investment proposal has now been prepared.
The research and development division has prepared the following demand
forecast as a result of its test marketing trials. The forecast reflects expected
technological change and its effect on the anticipated life-cycle of Product W33.
Year 1 2 3 4
Demand (units) 60,000 70,000 120,000 45,000
It is expected that all units of Product W33 produced will be sold, in line with the
company’s policy of keeping no inventory of finished goods. No terminal value or
machinery scrap value is expected at the end of four years, when production of
Product W33 is planned to end.
For investment appraisal purposes, PV Co uses a cost of capital of 10% per year
and a target return on capital employed of 15% per year. Ignore taxation.
Year Discount
Factor
0 1.000
1 0.909
2 0.826
3 0.751
4 0.683
Required:
Calculate the following values for the investment proposal:
(i) Net present value;
(ii) Accounting rate of return based on average investment.
272
Question 3
East Bromwich Council is an English Local Authority responsible for providing a
range of services to its resident population of 300,000. One such service is
refuse collection. For the past ten years this has been ‘contracted out’ to a
private sector company. However, several councillors feel that this has become
increasingly expensive and there have been numerous complaints regarding the
standard of service provided. The present contract expires in just over a year’s
time.
Accordingly the Council has set up a small working party to investigate the
feasibility of taking the service back ‘in house’. This would involve the purchase
of a fleet of refuse collection vehicles at an initial cost of £3 million and
recruitment and training appropriate staff (costing £0.5m) before the service can
be run ‘in house’. The predicted running costs of the ‘in house’ service are as
shown in the table below. It is estimated that the vehicles would have working
lives of five years and a combined residual value of £0.6 million. The residual
value of the equipment would be realised in the year after the final year of use.
There would be vehicle refurbishment costs in Year 3 of £0.03 million. This
amount is already included in ‘Other Costs’ for Year 3.
The Council would, save the cost of payments to the private contractor which are
estimated to be £4.75 million in the first year, increasing by 3% per annum
thereafter.
* The ‘Other costs’ shown above include depreciation of the vehicles and
amortisation of the initial recruitment and training both calculated using the
straight line method.
273
The Council’s cost of capital is 5% per annum. Discount factors for 5% are as
follows:
Year Discount
Factor
0 1.000
1 0.952
2 0.907
3 0.864
4 0.823
5 0.784
6 0.746
Required:
(a) Prepare a table showing the cash savings to be made by the Council
during the working life of the refuse collection project. (5 marks)
(c) A similar situation exists within the Council in respect of computing facilities
where a similar sized scheme has been evaluated. The computing facilities
scheme has the following projected results:
Payback = 3 years
Accounting rate of return = 25%
Net present value = £1,150,000
However, the Council’s Director of Finance feels that capital funds are limited
and therefore the two projects are mutually exclusive.
274
Question 4
The East Mercia Ambulance Trust serves a resident population of 2 million. It
provides emergency ambulances and patient transport services to elderly and
disabled patients from their homes to hospital and clinic appointments at National
Health Service and Local Authority locations. For the past ten years these patient
transport services have been ‘contracted out’ to a private sector company. The
Trust Board now feel that this has become increasingly expensive. There have
been numerous complaints regarding the standard of service provided. The
present contract expires in just over a year’s time.
Accordingly the Trust has set up a small working party to investigate the
feasibility of taking the service back ‘in house’. This would involve the purchase
of a fleet of patient transport vehicles at an initial cost of £6 million and the
recruitment and training of appropriate staff (costing £1m) before the service can
be run ‘in house’.
The predicted annual running costs of the ‘in house’ service are shown in the
table below. It is estimated that the vehicles would have working lives of five
years and a combined residual value of £0.8 million. The residual value of the
equipment would be realised in the year after the final year of use. There would
be an upgrade of the ambulances in Year 3 of £0.04 million. This amount is
already included in the ‘Other Costs’ shown below.
The Trust would, of course, save the cost of payments to the private contractor,
which are estimated to be £9.5 million in the first year, increasing by 3% per
annum thereafter.
* The ‘Other Costs’ shown above include depreciation of the vehicles and
amortisation of the initial recruitment and training calculated using a straight line
basis.
The Trust’s cost of capital is 5% per annum. Discount factors for 5% are as
follows:
275
Year Discount
Factor
0 1.000
1 0.952
2 0.907
3 0.864
4 0.823
5 0.784
6 0.746
Required:
(a) Prepare a table showing the net cash savings to be made by the Trust during
the working life of the patient transport project. (5 marks)
i. Payback period.
ii. Accounting rate of return (based on average capital invested).
iii. Net present value. (12 marks)
(c) A similar situation exists within the Trust in respect of computing facilities and
a similarly sized scheme has been evaluated. The computer scheme has the
following projected results:
However, the Trust’s Director of Finance feels that capital funds are limited and
therefore the two projects are mutually exclusive.
Question 5
List & briefly describe the five stages in capital budgeting.
276
Question 6
Digital Gadgets, a division of a large group, is developing a new product with a
predicted four year life. To produce this product more building space will be
needed. To provide this space, Digital Gadgets can lease a derelict site for four
years, after which time the site must be cleared. Digital Gadgets plans to hire
prefabricated buildings to be used on the site, so that the buildings can be easily
removed after four years. Maximum production capacity available will be 100,000
units per year.
Digital Gadgets estimates that the price will be £50 per unit from month 5 to
month 24. In month 25 there will be a re-launch of the product with new features.
At this stage, the price will be increased to £55 until month 48. The manager
wishes to see the total impact on profits of this plan.
Required:
(a) Prepare a lifecycle costing statement for this product (ignore the time value of
money). (7 marks)
(b) The manager is disappointed with the sales forecast for the final year (months
37-48) and explores possibilities of reducing the price to £52 and increasing
marketing and promotion by £200,000. Demand forecasts indicate:
277
50% probability that sales units will not increase as the gadget is losing
popularity,
40% probability that sales will increase to 80,000 units,
10% probability that sales will increase to 110,000 units.
(c) Show the profits that would be reported each year. Assume that product
development costs and site dismantling costs are expenses in the income
statement the year they are incurred; the cost of installation of buildings and the
equipment costs are depreciated using the straight line method with no residual
value. (6 marks)
(d) Explain how your forecasts in (a) to (c) would be used by the divisional
manager. (4 marks)
(e) The group operates a divisional managers’ bonus scheme, based on annual
profits. Briefly discuss the effect this may have on the manager’s decision to
adopt this project. (3 marks)
(UOL adapted 2010 Zone B Q3, 25 marks)
278
Question 7- (note this question was partially done in class)
Data Exclusive Ltd has been trading for a few years as a software company,
developing high quality software products for industrial applications. Each
product has an estimated life of two years.
The company has noticed that their annual profits are erratic and have decided to
investigate, in detail, the profitability and cost structures of three of their products
which have just completed their economic lives. The details are shown below:
For Product QM, in an effort to reduce costs, the research and product design
was kept to a minimum.
Required
(a) Calculate the company’s income for Years 1 and 2 and briefly comment on
the profit trend. (5 marks)
(b) Calculate the product life cycle income statement for each software package.
(10 marks)
(c) Comment on the profitability and differences in cost structure of the three
products and advise the company on strategies for improved profitability.
(6 marks)
279
University Of London
Management Accounting
Lecture Notes
Lecture 15
Topics Covered
Budgeting 1
Lecture 15
280
The Planning & Control Cycle
Control- involves measuring and correcting actual performance to ensure that the
strategy that are chosen and the plans for implementing them are carried out.
Planning:
Planning involves:
This involves converting the long-term plans into a series of short-term plans,
usually covering one year, relating to specific functions or departments.
Examples of short plans are the sales budget and production budget.
281
The main purposes and benefits of budgeting are:
Purpose:
Define goals and set targets.
Management are forced to plan for the future and set targets.
Benefits
1) Communication and coordination.
Preparation of budgets encourages coordination and communication between
different parts of the organisation. For example, the production department needs
to know how much the sales department is planning to sell in order to set its
target for production.
2) Motivation
Budgets provide targets and, as such, can motivate staff to achieve them,
especially if staff are rewarded on the basis of meeting budget.
Budgets give managers the authorisation to
spend and responsibility to achieve targets
3) Authorisation and responsibility
Managers know that budgeted expenditure has been authorised and can act
accordingly. Setting individual budget for particular business activities or
departments can be used to assign responsibility to individual managers for
meeting those budgets. Actual performance judged
against budgets
4)Performance evaluation and cost control.
Budgets provide plans against which subsequent performance can be
judged. Management performance can also be assessed and rewarded on
this basis.
Forces management to
plan for the future, define
goals
The master budget expresses management’s operating and financial plans for a
specified period (usually a fiscal year). The master budget is actually a series of
budgets including a set of budgeted financial statements.
283
The Master (Fixed) Budget Preparation Process
Sales Budget
Note the sequence of
budget preparation, start
Ending Stock
from the sales budget,
Budget then to the other budgets
as we only produce in
Production Budget accordance to demand.
Operating
Budget
COST OF GOODS SOLD BUDGET
284
These budgets are similar to the budgets done
in POA.
Formats
a) Sales Budget
Description Budgeted Units Selling Price Total Sales
Per Unit $
Units
Units to Produce
X Direct Material Usage Per Unit
Total Budgeted Usage
Add: target Ending Stock
Total KG Required
Less: Opening Stocks
KG to be purchased
Purchase Price Per KG
Total Purchases $
Units to Produce
Direct Labour Hours per Unit
Total Budgeted Hours
X Cost Per Hour $
Total Direct Labour Cost $
285
Cash Budget
A detailed budget which shows all cash inflows & outflows incorporating both
revenue & capital items.
CASH DISBURSEMENTS
- Payment to creditors
- Cash Purchases
- Wages & Salaries
- Loan Repayments
-Capital Expenditures
-Dividends paid
-taxation paid
-Any other cash disbursements
286
Lecture Illustration
Boris Bikes PLC is a U.K. company manufacturing motor scooters. It has
recently decided to build a factory in Singapore, to serve both the Singaporean
and other markets in the Far East. After the initial period of capital investment,
you have been appointed Financial Director of the Singaporean subsidiary.
The new factory is due to open in January 2015. You are aware that the first four
months of operations will be critical to its long term survival and you wish to
prepare budgets for that period. After consultation with the Boris Head Office you
discover that:
Expected sales are $2.0 million in January, $3.0 million in February, $4.0
million in March and $5.0 million in April.
Required:
Prepare in columnar form, an operating budget for the months of January to April
showing projected income, operating expenses, and the budgeted operating Income is
income. (6 marks)
another word
for profit
You also establish that on 1st January 2015 Head Office will provide you with
an opening cash balance of $1.5million at, and you are concerned as to
whether this will be sufficient. On researching the timing of receipts and
payments relating to the operating budget you discover the following:
Sales Revenue will be 50% within Singapore and 50% from exports.
Singaporean customers will pay in the month following the sale, export
customers two months after the sale.
Direct Materials will be paid for in the month after their usage.
Direct Wages and Variable Production Overheads will be paid for in the month to
which they relate.
287
Fixed Production Overheads relate largely to the manufacturing plant which is
highly automated. They therefore include a monthly depreciation charge of $1.0
million. They also include an annual insurance premium of $2.8 million which
must be paid in January, and property taxes of $1.6 million must be paid twice a
year in March and September (a yearly total of $3.2million). The remaining
costs are due for payment in even monthly amounts throughout the year.
Variable Selling Overheads are payable in the month following the month to
which they relate.
In setting up the Singaporean subsidiary Boris purchased more land than was
needed. A site of 2 hectares is now being sold for its cost price, of $3 million
which will be received in March.
You have established good relations with the local branch of a major bank,
and are aware that short term overdraft facilities are available. Interest will be
paid at 1% per month on the balance outstanding at the previous month end.
Required:
Prepare a cash budget for Boris Bikes (Singapore) for the months of January to
April. (14 marks)
Exam Tip:
Not bad for 14 marks, compared to other topic
UOL Adapted Zone A 2014 Question 3 questions.
288
Exam Tip
Important to structure the answer asap
after you read the question
Sales
Less: Expense
D. Material
D. Wages
Production Overheads
Variable
Fixed
Selling Overheads
Variable
Fixed
289
Cash Sales Working(W1)
£‘000
Jan Feb Mar Apr
$
Monthly Fixed Prodn Overheads
290
Cash Budget
$000
Description Jan Feb Mar Apr
Cash Receipt
Land Sales
Cash Payment
D. Material
D. Wages
Variable Selling
Fixed Selling
Admin Overheads
Plant Cost
Insurance
Property Tax
291
Exam Tip
Budgeting Systems This part popular for Section B of the exam
3) Rolling budgets
This involves adding certain percentage to last year’s budget to allow for growth
and inflation. The starting point is either previous period budget or the previous
period’s actual results.
Appropriate for budgeting for certain cost such as staff salaries which are based
on an estimate of current salaries plus an increment for inflation.
Advantage:
Quick & easy to prepare as only the size of the increase required needs to be
justified.
Disadvantages:
2) Why would the manager spend the maximum amount and what’s wrong
with that?
Problem here is that the manager will just spend for the sake of spending and
use up the existing budget now and hence end up spending inefficiently.-
WRONG BEHAVIOUR!
292
Zero based Budgeting Systems (ZBB)
ZBB treats the preparation of the budget for each new period as an independent
planning exercise.
The initial budget is zero (unlike incremental budgeting) and every item of
expenditure has to be justified to its entirety in order to be included.
ZBB involves a questioning attitude by all those involved in the budgetary process.
Existing activities must be challenged and questions asked about each and every
expenditure, hence non-value added activities can be identified and eliminated.
Each activity is evaluated and ranked on the basis of its benefit to the
organisation. The ranking process requires managers to allocate scarce
resources between activities.
Resources in the budget are then allocated according to the funds available
and the evaluation and ranking of the competing packages.
Advantages of ZBB:
293
Disadvantages of ZBB:
c) Certain activity becomes difficult to quantify and rank as their benefits are
more qualitative than quantitative. For example, spending on employee
welfare and improving working conditions.
One way to overcome that most serious drawback of ZBB is to apply it selectively
on a rolling basis throughout the organisation. For example, apply ZBB to different
departments every year.
Rolling budgets
Rolling budgets (continuous budgets) are budgets which are continuously updated
by adding a further period (month or quarter) and deducting the earliest period.
Rolling budgets are useful for companies facing changing, dynamic conditions in
its operating environment for example new technology, competitors actions.
Changes in the operating environment may make the original budget assumptions
inappropriate or unrealistic and hence changes required.
Advantages
Disadvantages:
a) More time consuming, simpler to update the budget manual once or twice every
year.
294
Example of rolling budgets, assuming rolling monthly.
1/1/20 31/12/20
At end of January 2020, the budget revised to include the next following
month, January 2021 and January 2020 is excluded.
1/2/20 31/1/21
At end of February 2020, the budget revised again to include the next
following month, February 2021 and February 2020 is excluded.
1/3/20 28/2/21
The process is repeated again for the next months.
Main advantage is that when the budgets are revised, changes in
assumptions can be incorporated and new information can be reflected
in the revised budget and the budget reflects the current environment.
• ABB focus on activities and not department cost. Hence, easier to see if
the activities are adding value in the value chain.
295
Participative budgeting
Human Aspects of Budgeting Advantages: Gain commitment, realistic budget and
motivational.
Disadvantages: Time consuming, leads to budgetary slack
1)Participation is crucial
A budget is more effective when the lower-level managers actively engage in the
budget process. This participation adds credibility to the budgeting process and
creates greater commitment toward the budget.
Self Interest preservation, if managers allowed to
2) Budgetary Slack participate in setting targets.
Managers frequently play games with budgets and build in budgetary slack.
This is the practice of underestimating revenues, overestimating costs in order to
make the budget targets more easily achievable. This will dilute the targets set
and hence distort the objectives of budgeting.
Challenges in budgeting
1) Time consuming and managers may resent spending the extra time
It is a time-consuming process that involves all levels of management.
3) Flexibility required
Budgets should not be administered rigidly. Changing conditions may call for
changes in plans. Hence, flexibility in the interpretation of the results as well
the need to make changes to the budgets is important.
Summary: Good budgeting system must: Remember, budgets are target and target
1) Allow Participation meant to be motivational.
2) Fair and Well communicated targets This will only be when the targets are fair,
3) Budgets are realistic, yet challenging realistic and challenging.
4) Flexible in changing plans and interpretation of results
5) Get support of all levels of management
What is budgetary slack?
Managers “game” the budget in order to achieve favourable variances and hence
enhance their performance.
The sales manager if allowed to participate in setting the sales budget will understate
the sales budget so that its easier to achieve.
The production manager will overstate the production cost budget so that its easier to
achieve. 296
Remember, in the real world managers tend to act in “self interest”.
Homework Question Lecture 15
Question 1
For many organisations in both the private and public sectors the annual budget
is the basis of much internal management information.
Required:
a)Briefly discuss four purposes of budgets.
b) Explain the behavioural factors which should be borne in mind and the
difficulties of applying them in the process of budgeting and budgetary control.
Question 2
Question 3
Question 4
Question 5
Explain the relationship between strategy, plans and budgeting.
Question 6
Briefly explain the four steps(elements) of the budgeting cycle.
297