Drury A
Drury A
Drury A
a) (£) (£)
Photography: 64 pages at £150 per page 9 600
Set-up:
Labour – 64 plates × 4 hours per plate
= 256 hours at £7 per hour 1 792
Materials – 64 plates at £35 per plate 2 240
Overhead – 256 labour hours at £9.50 per hour 2 432
––––
6 464
Printing:
Materials (paper): £12 100
100 000 catalogues × 32 sheets × × 39 184
1000 98
Materials (other):
100 000
× £7 1 400
500
Labour and Overheads
100 000
m/c hours at £62 per hour 6 200
1000 ––––
46 784
Binding:
Labour and Overheads
100 000
m/c hours at £43 per hour 1 720
2500 ––––––
Total costs 64 568
––––––
100
Selling price – £64 568 × 71 742
90 ––––––
(b) Estimated hours = 256
100
Actual hours = 256 ×
90
= 284.4
Additional costs = (284.4 – 256) × £16.50 (£7 labour rate + £9.50 overhead rate)
= £469.3
(a) The service department cost should be reallocated using the following bases:
Canteen: Number of employees
Engineering shop: Number of service hours
Stores: Number of stores orders
The canteen does not receive any services from the other service departments. Therefore the canteen should be
reallocated first. The Engineering Shop receives services from the other two service departments and should be
reallocated last.
1
Overhead allocation
Dept. Basis M/C Assemb Paint Eng Stores Canteen
shop shop
(£) (£) (£) (£) (£) (£)
Allocation 180 000 160 000 130 000 84 000 52 000 75 000
Canteen Employees 27 000 17 000 13 000 10 000 8 000 (75 000)
Stores Orders 24 000 18 000 12 000 6 000 (60 000)
Eng. shop Service hrs 45 000 30 000 25 000 (100 000)
–––––– –––––– –––––– ––––––– –––––– ––––––
Total overhead 276 000 225 000 180 000
Machine hours 9 200
Direct labour hours 11 250
Labour cost £45 000
Machine hour rate £30
Direct labour hour rate £20
Direct labour cost rate 400% of direct labour cost
Notes
a
10 000 machine hours £30 per hour.
a
7800 Direct labour hours at £20 per hour.
a
400% of direct labour cost of £35 000.
(c) See ‘Budgeted overhead rates’ in Chapter 3 for an explanation of why overheads should be absorbed using
predetermined bases. The second part of the question relates to whether or not volume allocation base (i.e. machine
hours and direct labour hours or cost) are appropriate, particularly when direct labour is a small proportion of total
cost. The answers should discuss the need for developing non-volume-based cost driver rates using activity-based
costing systems.
Personnel and
Administration Maintenance Stores Moulding Extrusion Finishing
(£000) (£000) (£000) (£000) (£000) (£000)
Materials 36 23 330 170 20
Labour 155 25 18.72 168.75 115.2 81
Variable
overhead 71.25 151.8 30
Fixed overhead 15 15 17.28 449.30 371.7 67
––– ––– ––––– –––––– ––––– ––––
206 63 36 1019.3 808.7 198
Personnela (206) 100.98 64.63 40.39
Maintenance
reallocationb (63) 18 36 9
Stores
reallocationc (36) 8 12 16
––– ––– ––––– –––––– ––––– ––––
Total cost £1146.28 £921.33 £263.39
––– ––– ––––– –––––– ––––– ––––
Notes
a
Personnel costs are reapportioned on the basis of the number of employees in each production department. For exam-
ple, 25/51 of the personnel department costs of £206 000 are apportioned to the moulding department.
b
Maintenance costs are reapportioned in proportion to the total maintenance hours worked in each department.
c
Stores costs are reapportioned in proportion to stores floorspace.
(b) This method is the specified order of closing described in Appendix 3.1. There the service department that provided
the largest proportion of services for other service departments was closed first. In this answer the service department
providing the largest value of cost input to other service departments (namely the personnel department) is closed
first, and the department providing the second largest value of cost input to other service departments is closed next.
Return charges are not made.
2
Personnel and
Administration Maintenance Stores Moulding Extrusion Finishing
(£000) (£000) (£000) (£000) (£000) (£000)
Original
allocation 206 63 36 1019.3 808.7 198
Personnel
reallocation (206) 14.21(4/58) 10.65(3/58) 88.79(25/58) 56.83(16/58) 35.52(10/58)
–––––––––
Maintenance
reallocation (77.21) 13.63(15/85) 18.17(20/85) 36.33(40/85) 9.08(10/85)
––––––––––
Stores
reallocation (60.28) 13.4(20/90) 20.09(30/90) 26.79(40/90)
Total cost £1139.66 £921.95 £269.39
Workings
(W1) M coefficient 5/90 (W8) S coefficient 20/100
(W2) P coefficient 4/58 (W9) P coefficient 16/58
(W3) S coefficient 10/100 (W10) P coefficient 40/90
(W4) M coefficient 15/90 (W11) S coefficient 30/100
(W5) P coefficient 3/58 (W12) P coefficient 10/58
(W6) P coefficient 25/58 (W13) M coefficient 10/90
(W7) M coefficient 20/90 (W14) S coefficient 40/100
(d) The direct method is the simplest, but ignores inter-service department apportionments. If there is a significant pro-
portion of inter-servicing apportionments, this method is likely to result in inaccurate calculations.
The step-down method gives partial recognition to inter-department servicing, and does not involve time-
consuming apportionments. The reciprocal method takes full account of inter-department servicing, and is the only
method that will yield accurate results.
The choice of method will depend on cost behaviour. If a significant proportion of costs are variable then service
department reallocations will be important for decision-making and cost control. In this situation the reciprocal
method should be used. However, if the vast majority of costs are fixed, the cost allocations should not be used for cost
control and decision-making, and here is a case for using the direct or step-down method.
(e) The answer to this question should include a discussion of cost-plus pricing. See ‘Limitations of cost-plus pricing’ and
‘Reasons for using cost-plus pricing’ in Chapter 11 for the answer to this question.
Answers to extra questions for Chapter 4 Accounting entries for a job costing system
(£) (£)
Balance 800
3
Plant account
(£) (£)
Balance 480
(£) (£)
Balance c/fwd 108 Balance b/fwd 100
Production overhead control 8
(96/12 months)
––– –––
108 108
––– –––
Balance b/fwd 108
(£) (£)
Balance b/fwd 400 Creditors 10
Creditors 210 Work in progress 1 136
Work in progress 2 44
Balance c/fwd 420
––– –––
610 610
––– –––
Balance b/fwd 420
Debtors account
(£) (£)
Balance b/fwd 1120 Bank 1140
Sales 1100 Balance c/fwd 1080
–––– ––––
2220 2220
–––– ––––
Balance b/fwd 1080
4
Capital account
(£) (£)
Balance b/fwd 2200
Creditors account
(£) (£)
Raw material stocks 10 Balance b/fwd 300
Bank 330 Raw material stocks 210
Balance c/fwd 170
––– –––
510 510
––– –––
Balance c/fwd 170
Bank account
(£) (£)
Debtors 1140 Balance b/fwd 464
Balance c/fwd 466 Direct wages 200
Production overhead control 170
Production overhead control 250
Creditors 330
Administration overhead 108
Selling/distribution overhead 84
–––– ––––
1606 1606
–––– ––––
Balance b/fwd 466
Sales account
(£) (£)
Balance c/fwd 2300 Balance b/fwd 1200
Debtors 1100
–––– ––––
2300 2300
–––– ––––
Balance c/fwd 2300
(£) (£)
Balance b/fwd 888 Balance c/fwd 1732
Finished goods 844
–––– ––––
1732 1732
–––– ––––
Balance b/fwd 1732
(£) (£)
Balance b/fwd 9 Balance c/fwd 62
Work in progress 1a 20
Work in progress 2a 33
–– ––
62 62
–– ––
Balance b/fwd 62
(£) (£)
Bank 170
Bank 250 Work in progress 1 210
Provision for depreciation 8 Work in progress 2 195
Production overhead
under/over-absorbed (Balance) 23
––– –––
428 428
––– –––
5
Production overhead over/under absorbed account
(£) (£)
Production overhead control 23 Balance b/fwd 21
Balance c/fwd 2
–– ––
23 23
–– ––
Balance b/fwd 2
Wages account
(£) (£)
Bank 200 Work in progress 1 84
Balance c/fwd 14 Work in progress 2 130
––– –––
214 214
––– –––
Balance b/fwd 14
Notes
a
The total cost of the abnormal losses are:
Process 1 Process 2
(£) (£)
Direct materials 6 18
Direct wages 4 6
Production overhead 10 (250% £4) 9 (150% £6)
–– ––
20 33
–– ––
WIP transfers are:
b
6
(ii) Work in progress account
(£) (£)
Opening stock (25 3) 28 Finished goods a/c (difference) 984
Raw materials a/c 578 Closing stock (27 – 5) 22
Direct labour (220 20) 240
Production overhead absorbed
(240 at 66%) 160
–––– ––––
1006 1006
––––
–––– ––––
––––
The reconciliation statement indicates that discounts, selling expenses and debenture interest are not included in the
cost accounts. Therefore these items are not included in the costing profit and loss account.
(b) Interest on capital tied up in stocks should be taken into account for decision-making and cost control purposes. This is
because the interest on capital tied up in stocks represents an opportunity cost (in terms of the lost interest) which
would have been earned if the money tied up in stocks had been invested.
Interest on capital tied up in stocks should not be included in product costs for stock valuation purposes per SSAP 9.
Therefore the cost accumulation system will not include notional costs for stock valuation purposes. Nevertheless it is
essential that all relevant costs (including opportunity costs) are included in cost statements for the purpose of decision-
making and cost control.
Process account
Units (£) Units (£)
Opening WIP 1000 27 400 Process B 8200 344 400
Materials 8000 162 600 Closing WIP c/d 800 19 520
7
Conversion cost 173 920
––––––– –––––––
363 920 363 920
––––––– –––––––
Performance report
Standard cost Actual cost Difference
(£) (£) (£)
Materials 160 000 (8000 £20) 162 600 2600 A
Conversion cost 183 080 (7960 £23) 173 920 9160 F
––––
6560 F
––––
Workings
(W1)
cost of production (£7840) scrap value of normal loss (£280)
Cost per unit
expected output (6300 kg)
£1.20 per kg
(W2) Normal loss is 10% of total output, which in this case is equivalent to total input [therefore normal loss (10%
(6430 570))].
(W3) Abnormal gain actual output (6430) expected output (6300)
Process 2 account
(kg) (£) (kg) (£)
Previous process By-product net
cost 6430 7 716 income 430 645
Labour and Output to be
overhead 12 129 account for 19 200
E 2000
F 4000
–––– –––––– –––– ––––––
6430 19 845 6430 19 845
–––– –––––– –––– ––––––
The allocation of £19 200 to E and F depends on the apportionment method used.
(i) Physical output method
E F
(£) (£)
8
冢 冣 冢 冣
2000 4000
1. Total output cost 6400 £19 200 12 800 £19 200
6000 6000
冢 冣 冢 冣
2000 1100 4000 3200
2. Closing stock 2880 £6400 2 560 £12 800
2000 4000
冢 冣 冢 冣
1100 3200
3. Cost of sales 3520 £6400 10 240 £12 800
2000 4000
冢 冣 冢 冣
14 10
2. Cost of output 11 200 £19 200 8 000 £19 200
24 24
冢 冣 冢 冣
[900] [800]
3. Closing stock 5 040 £11 200 1 600 £8 000
2000 4000
冢 冣 冢 冣
1100 3200
4. Cost of sales 6 160 £11 200 6 400 £8 000
2000 4000
(c) See Chapter 6 for the answer to this question. In particular, the answer should stress that joint cost apportionments are
necessary for stock valuation, but such apportionments are inappropriate for decision-making. For decision-making
relevant costs should be used. It can be seen from the answer to part (b) that one method of apportionment implies
that F makes a loss whereas the other indicates that F makes a profit. Product F should only be deleted if the costs
saved from deleting it exceed the revenues lost.
Therefore profit will increase by £6000 if B is sold at split off point and the revised profit statements will be:
Note
a
B 3500/8000 £40 000; K 2500/8000 £40 000; C 2000/8000 £40 000.
9
Answers to extra questions for Chapter 7 Income effects of alternative cost
accumulation systems
(iii) (£)
Absorption costing profit 146 000
Fixed overhead included in stock increase (30 000 £0.60) 18 000
––––––––
Marginal costing profit £128 000
––––––––
(iv) The profit figure will be the same with both systems whenever production equals sales and therefore opening
stock equals closing stock.
10
Answer to question 7.2
(a) WIP Total Cost
Cost Total Completed equivalent equivalent per
element cost units units units unit WIP
(£) (£) (£)
Materials 714 000 98 000 4000 102 000 7.00 28 000
Labour 400 000 98 000 2000 100 000 4.00 8000
Variable overhead 100 000 98 000 2000 100 000 1.00 2000
Fixed overhead 350 000 98 000 2000 100 000 3.50 7000
–––––––– ––––– –––––
1 564 000 15.50 45 000
–––––––– ––––– –––––
(d) The absorption costing statement shows a profit of £11 000 whereas the marginal costing statement shows a net loss of
£24 000. The difference of £35 000 is due to the fact that the closing stock valuation includes £35 000 fixed overhead
(£7000 WIP and £28 000 finished goods) whereas the fixed overheads are not included in the stock valuation when the
marginal costing approach is used. Instead, all the fixed overheads are charged as a period cost. With the absorption
costing system, the fixed overheads of £35 000 that are included in the stock valuation will be recorded as an expense
when the stocks are sold. Consequently, the absorption costing method shows £35 000 greater profits than the
marginal costing method. For a detailed discussion of a comparison of the impact on profits of the two methods see
Chapter 7.
For internal profit measurement purposes both methods are acceptable, but for external reporting SSAP 9 requires
that stocks should be valued on an absorption costing basis.
Low High
(£) (£)
Sales at £30 000 per unit 480 000 (16 £30 000) 900 000 (30 £30 000)
Profit 40 000 250 000
–––––– ––––––
Total costs (difference) 440 000 650 000
–––––– ––––––
An increase in output of 14 units results in an increase in total costs of £210 000. Assuming that fixed costs are constant
for all activity levels the variable cost per unit is £15 000 (£210 000/14 units). At 30 units activity the variable costs will be
£450 000 and monthly fixed costs are £200 000 (£650 000 £450 000). Over a
six-month period total fixed costs are £1 200 000.
11
Break-even point Fixed costs (£1 200 000)/unit contribution (£15 000)
80 units
£000s
Break-even chart
3900
ue
Margin ven
of safety re
costs tal
To st
a l co
Break-even point Tot
2400
Revenue
ost
iab le c
Var
Fixed costs
1200
Margin of safety
Figure Q8.14
12
(b) The following items are plotted on the graph:
Variable cost Total cost
Zero sales Nil £25 000 fixed cost
£80 000 sales £48 000 (60%) £73 000
£90 000 sales £54 000 (60%) £79 000
£50 000 sales £30 000 (60%) £55 000
£100 000 sales £60 000 £85 000
A
Sales
Total
£000s costs
Break-even point (£62 500)
90
B Variable
costs
60
30
0 50 80 90 100 Monthly
sales (£000s)
(c) (£)
Actual sales = 1.3 Break-even sales (£62 500) = 81 250
Contribution (40% of sales) = 32 500
Fixed costs = 25 000
Monthly profit = 7 500
Annual profit = 90 000
(d) (£)
Annual contribution from single outlet (£32 500 12) = 390 000
Contribution to cover lost sales (10%) = 39 000
Specific fixed costs = 100 000
–––––––
Total contribution required 529 000
–––––––
Required sales = £529 000/0.4 = £1 322 500
(e) The answer should draw attention to the need for establishing a sound system of budgeting and performance report-
ing for each of the different outlets working in close conjunction with central office. The budgets should be merged
together to establish a master budget for the whole company.
13
(b) Required contribution £17 496 (£12 096 £5400 fixed costs)
Required sales volume in units 24 994 (£17 496/£0.70 unit contribution)
Required weekly sales volume 6249 units (24 994/4 weeks)
Sales multiplier required 2.6 (6249/2400)
Break-even point fixed costs (£1 710 000) total sales (£5 350 000)
(sales revenue basis) total contribution (2 140 000)
£4 275 000
It is worthwhile incurring the expenditure on advertising and sales promotion at a selling price of £2.75.
(c) Required contribution existing contribution (£828 000)
+ additional fixed costs (£60 000)
£888 000
The required sales volume at a selling price of £2.75 that will generate a total contribution of £888 000 is 572 903 units
(£888 000/£1.55 unit contribution).
(d) See ‘Margin of safety’ in Chapter 8 for the answer to this question. At the existing selling price for product A, the
margin of safety for Z Ltd is £1 075 000 (£5 350 000 sales revenue £4 275 000 break-even point) of sales revenue. This
is 20.1% of the current level of sales. If Z Ltd incurs the advertising and promotion expenditure and reduces the selling
price to £2.75 for product A, the break-even point will increase to £4 446 000 and total sales revenue will increase to
£5 593 000. This will result in a margin of safety of £1 147 000 or 20.5% of sales.
The sum of the product break-even points is less than the break-even point for the company as a whole. It is incorrect to
add the product break-even points because the sales mix will be different from the planned sales mix. The sum of the
product break-even points assumes a sales mix of 50% to X and 50% to Y. The break-even point for the company as a whole
assumes a planned sales mix of 70% to X and 30% to Y. CVP analysis will yield correct results only if the planned sales mix
is equal to the actual sales mix.
15
Answer to question 8.7
(a) Budgeted ROCE
Sales Gross profit
(£000) (£000)
Accommodation 1350 (45%) 945 (70%)
Restaurant 1050 (35%) 210 (20%)
Bar 600 (20%) 180 (30%)
–––– ––––
3000 1335
––––
Less fixed costs 565
––––
Profit before tax 770
––––
ROCE 770/7000 100 11%
(b) (i) Required additional profits £280 000 (4% £7 million)
Contribution per two-night holiday:
Sales Gross profit % margin Contribution
(£) (£) (£)
Accommodation (2 £25) 50 70 35
Restaurant (40% £50) 20 20 4
Bar (20% £50) 10 30 3
––
42
––
Number of holidays required to provide a contribution of £280 000 6667
(£280 000/42)
Number of holidays per week in three off-peak quarters 171 (6667/39)
(£000)
(ii) Required additional contribution 280
Contribution arising from increases in selling prices from:
Restaurant (10% £1 050 000) 105
Bar (5% £600 000) 30 135
––– –––
Required additional contribution from accommodation 145
–––
Recommendation
The assumptions in (a) regarding the percentage reduction in variable costs and no increase in fixed costs are
questionable. Also, a large number of holidays would need to be sold in order to achieve the target ROCE. In contrast,
a modest price increase of 10% seems possible without adversely affecting demand. On
the basis of the information given, it is recommended that the second alternative be chosen.
16
Answers to questions for Chapter 9 Measuring relevant costs and revenues for
decision-making
Notes
a
52 weeks × 6 days × 5 journeys per day × number of passengers × return fare × 2 vehicles
b
52 weeks × 6 days × 5 journeys per day × return travel distance × £0.1875 × 2 vehicles
c
52 weeks × 6 days × £120 × 2 vehicles
(b) (i) The relevant (differential) items are the return fares and the average number of passengers per journey:
Adult (£) Child (£)
Existing revenue per journey 45 (15 × £3.00) 15 (10 × £1.50)
Revised revenue per journey 45 (12 × £3.75) 12 (8 × £1.50)
–– ––
Net gain/(loss) nil (3)
–– ––
The contribution per return journey will decrease by £3.
17
(b) (ii) The above analysis suggests that the fare should not be amended on route W. The only justification is that the cur-
rent prices result in the average number of passengers being 25 per journey so it is possible that occasionally
demand may exceed full capacity of 30 passengers resulting in some passengers not being able to be carried. With
the price increase the average number of passengers will be 20 and it is less likely that some passengers will not be
able to be carried.
(c) (i) Annual cost of existing maintenance function
(£) (£)
Staffing
Fitters (£15 808 × 2) 31 616
Supervisor 24 000 55 616
–––––
Material costs
Bus servicing (499 200 kma/4000) × £100 12 480
Bus safety checks (48 per year at £75) 3 600
Taxi servicing (128 000 km/4000 × 6 vehicles) × £100 19 200
Taxi safety checks (36 per year at £75) 2 700 37 980
––––– ––––––
Total cost 93 596
––––––
Note
a
160 km per journey × 5 journeys × 52 weeks × 6 days × 2 vehicles
(c) (ii)
(£) (£)
Annual cost of keeping own maintenance
Annual operating costs 93 596
Cost of new employee 20 000 113 596
––––––
Annual cost of buying in maintenance
Contract cost 90 000
Redundancy costs for fitters 15 808 105 808
–––––– ––––––
Savings in the first year from buying in maintenance 7 788
––––––
There will be a saving after the first year from buying in maintenance of £23 596 because the redundancy cost
will be incurred for one year only.
(c) (iii) AZ will lose control of the operations if the service is carried out externally. It will be more difficult to ensure
quality of work and schedule the servicing as required. Once the skills have been lost from outsourcing it may
be difficult to re-establish them. Also AZ will be at the mercy of the supplier when the contract is re-negoti-
ated. The extent to which AZ will be dependent on the supplier will be influenced by how competitive the
market is for providing a maintenance service.
AZ could also consider making vehicle servicing a profit centre which competes with external competitors
for the work of the group.
Note that the labour hours per unit = installation labour cost/£8.
Therefore, since the maximum profit would be reduced the firm should not implement the proposal.
19
Materials used Balance unused
Chairs (4000 units 2.5) 10 000 10 000
Tables (1500 units 5) 7 500 2 500
Benches (2500/7.5 = 333 units) 2 500 —
The above production plan is sufficient to meet the order that has already been accepted. The profit arising from the
above production plan is calculated as follows:
(£)
Chairs (4000 units £8 contribution) 32 000
Tables (1500 units £16 contribution) 24 000
Benches (333 units £17.50 contribution) 5 827
––––––
Total contribution 61 827
Fixed overheads (4000 £4.50) + (2000 £11.25) + (1500 £9) 54 000
––––––
Profit 7 827
––––––
(b) The above production plan indicates that maximum sales demand for chairs and tables has been met but there is
unutilized demand for benches. Therefore any additional materials purchased will be used to make benches yielding a
contribution per unit sold of £17.50 and contribution per metre of material used of £2.33 (see part (a) for calculation).
The company should not pay above £2.33 in excess of the acquisition cost of materials. The maximum purchase price is
£4.33 (£2 + £2.33).
(c) See Chapter 2 for an explanation of each of the items listed in the question.
20
Payment for unused
machine hoursa £70 020 £120 000
–––––––– ––––––––
Revised contribution £153 345 £189 062
–––––––– ––––––––
Note
The payment for unused machine hours is calculated as follows:
a
Part A
(£)
Line S at £60 per hour — (Fully used)
Line T at £60 per hour 70 020 (4500 [6666 0.5 hrs])
––––––
70 020
––––––
Part B
(£)
Line S at £60 per hour 118 125 (4000 [8125 0.25 hrs])
Line T at £60 per hour 1 875 (4500 [8125 0.55 hrs])
–––––––
120 000
–––––––
With the alternative pricing arrangement the company should produce Part B.
Assuming that only one of the products can be sold the maximum contribution from the sales of each product is:
Traditional £188 700 (6800 £27.75)
Modern £208 250 (8500 £24.50)
The company should therefore sell 8500 units of the ‘Modern’ lampstand.
(b) The spare machine capacity assuming that 6800 units of the ‘Traditional’ lamp-stand or 8500 of the ‘Modern’
lampstand are produced is as follows:
Machine X Machine Y
(Hours) (Hours)
Production of 6800
of Traditional Nil [1700 (6800 0.25)] 560 [1920 (6800 0.20)]
Production of 8500
of Modern 425 [1700 (8500 0.15)] 7.5 [1920 (8500 0.225)]
The revised contributions are:
Traditional Modern
(£) (£)
Original contribution 188 700 208 250
Sales from unused capacity of
machine X Nil 8 500 (425 £20)
21
Sales from unused capacity of
machine Y 16 800 (560 £30) 225 (7.5 £30)
––––––– –––––––
205 500 216 975
––––––– –––––––
The above figures indicate that the ‘Modern’ lampstands should still be sold when an alternative sales outlet exists.
(d) In order to overcome the capacity constraints the following alternative courses of action should be considered:
(i) Hire additional machinery to meet short-term demand and evaluate purchase of additional machinery if the
shortage of capacity is expected to continue in the long term.
(ii) Increase output per machine hour by more efficient operating or increasing machine speeds. However, additional
costs and lost output might arise from machine breakdowns.
(iii) Increase machine capacity by introducing additional shifts. This will lead to increased shift and overtime pay-
ments and may also result in machine breakdowns arising from more intensive use of machinery.
(iv) Sub-contract production but this will lead to increased costs and possibly lost sales arising from inferior quality
products, late delivery etc.
(v) Seek alternative supplies of timber since this is a limiting factor. Care should be taken to ensure that any addi-
tional purchase and delivery costs do not exceed the contribution from increased sales.
(£)
Additional contribution from P (1973 kg at £6.88) 13 574
Loss of contribution from Q (2000 kg at £3.536a) 7 072
––––––
Additional contribution 6 502
––––––
EF should subcontract 2000 kg of Q and produce an extra 1973 kg of P.
Note
a
Contribution selling price (0.9 £11.64) variable cost (£6.94) £3.536
(b) P Q R S
(£) (£) (£) (£)
Proposed subcontract price (90% of selling price) 14.58 10.476 8.928 12.312
Variable cost 9.32 6.94 5.65 7.82
––––– ––––– ––––– –––––
Loss of contribution 5.26 3.536 3.278 4.492
––––– ––––– ––––– –––––
22
Direct labour released from subcontracting 2000 kg Additional production (kg) from
releasing direct labour
P Q R S
£3920 from Pa — 3015e 3959f 2305g
£2600 from Qb 1326h — 2626 1529
£1980 from Rc 1010 1523 — 1164
£3400 from Sd 1734 2615 3434 —
Extra 5% of capacity (£1267) 646i 974 1280 745
Notes
2000 £1.96; b 2000 £1.30; c 2000 £0.99; d 2000 £1.70; e £3920/£1.30 per kg; f 3920/£0.99; g £3920/£1.70; h £2600/£1.96; i
a
£1267/£1.96.
Recommendations:
The most profitable combination is to subcontract 2000 kg of P and replace this with 5239 kg (3959 1280) of R, thus
increasing contribution by £11 850.
Answers to extra questions for Chapter 11 Pricing decisions and profitability analysis
23
Equipment: General purpose (£16 400 £12 600) 3 800
Equipment: Specialized (£9000 £5800) 3 200
Administrative expenses 5 000
––––––
Contract price 75 400
––––––
It is assumed that the specialized equipment would be purchased new for £9000.
(b) (£)
Expected sales value (0.7 £100 000) (0.3 £120 000) 106 000)
Expected building costs (0.4 £60 000) (0.4 £80 000)
(0.2 £95 000) (75 000)
Building plot (20 000)
––––––––
Expected profit 11 000)
––––––––
Using expected profit as a measure of the alternative use of the capacity, the minimum price using the relevant cost
approach would be £86 400 (£75 400 £11 000). In other words, Wright would wish to ensure that the contract price
is in excess of the profit available from the alternative use of the facilities, and this would depend on his assessment of
the ‘utility value’ of project B. Note that the expected value approach is covered in Chapter 12.
(c) This question requires a discussion of cost-plus pricing and the relevant cost (that is, opportunity cost) approach to
pricing. For a discussion of the limitations and merits of cost-plus pricing see ‘Limitations of cost-plus pricing’ and
‘Reasons for using cost-based pricing formulae’ in Chapter 11. The advantages of basing selling prices on relevant costs
include:
(i) The alternative uses of resources are incorporated into the analysis.
(ii) It distinguishes between relevant and irrelevant costs and indicates the incremental cash flows incurred in manu-
facturing and selling a product.
(iii) It provides the information to enable tenders to be made at more competitive prices.
The limitations include:
(i) It is a cost-based pricing method that ignores demand.
(ii) It may provide an incentive to sell at low prices, resulting in total sales revenue being insufficient to cover total
fixed costs.
(iii) There is difficulty in determining the opportunity cost of resources because information on available opportuni-
ties may not be known.
(iv) Where special contracts are negotiated that are in excess of relevant (incremental) costs but less than full costs,
there is a danger that customers will expect repeat business at this selling price. Care must be taken to ensure that
negotiating ‘special one-off ’ contracts does not affect the demand for other products.
Relevant cost pricing is more appropriate for ‘one-off ’ pricing decisions. It is also appropriate in situations where
a firm has unutilized capacity or can sell in differentiated markets at different prices. Relevant cost pricing may
also be appropriate where the policy is to sell certain products as ‘loss leaders’. It is important that cost information
be used in a flexible manner and that product costs not be seen as the only factor that should determine the final
selling price.
(b) At a selling price of 20% above the market leader for the replacement filter sales of the complete units will not be
affected. Therefore the maximum price of £96 (£80 1.20) should be charged for replacement filters.
At a selling price of £280 demand is expected to be 800 units (40% 2000). Each increase in price of £1 causes
demand to fall by 5 units. Therefore at a selling price of £440 demand will be zero. To increase demand by one unit the
selling price must be reduced by £0.20. Thus the maximum selling price for an output of x units is:
24
SP £440 £0.20x
Total revenue for an output of x units £440x £0.20x2
Marginal revenue dTR/dx £440 £0.40x
Total cost 305x 60x £5000 £7000
Marginal cost £365
The sale of one complete unit results in the sale of four replacement filters during its life at a marginal revenue of £96
and a marginal cost of £60 per unit.
Variable costs:
Complete units
548 @ £305 167 140 167 140 167 140
Replacement
elements @
£60a 92 880 110 760 128 640
––––––– –––––––– ––––––––
(260 020.00) (277 900.00) (295 780.00)
––––––––––– ––––––––––– –––––––––––
17 039.20 27 767.20 38 495.20
Fixed costs (12 000.00) (12 000.00) (12 000.00)
––––––––––– ––––––––––– –––––––––––
Profit 5 039.20 15 767.20 26 495.20
––––––––––– ––––––––––– –––––––––––
Change in profits (4210.80) 6 517.20 17 245.20
Note
a
The number of replacement filters will increase over the next four years because they are replaced at the end of each
year (four times during their lifetime). Therefore sales of replacement filters are related to sales in previous periods.
The question also states that production of replacement filters must be sufficient to meet annual sales demand plus the
production of a filter to be included in the sale of one completed unit. Thus production of filters will exceed sales by
548 filters per year. The sales and production volumes of replacement filters is calculated as follows:
25
2003 Sales ( 1000) ( [548 4]) 1298
Production (1298 548) 1846
Figure Q12.18 Decision tree and expected value calculation for site A.
(b) (i) It is assumed that the decision to abandon the project can be taken at the end of year 1. At this point in time, the
cash flows for year 2 will be receivable in one year’s time, whereas the sale proceeds will be receivable at the point
when the decision is taken at the end of year 1. Therefore the decision should be to abandon the project if the PV
of the cash flows receivable in one year’s time is less than the £150 000 selling price. If the cash inflows in year 1 are
£100 000 then the expected PV of the cash flows in year 2 will be:
26
The site should therefore be sold for £150 000. If the cash flow for year 1 is £200 000, the expected PV of the cash
inflows in year 2 will be:
The expected NPV is in excess of the sale proceeds, and therefore the project should not be abandoned.
(ii) If the cash flow in year 1 is £100 000 then the project will be abandoned and sold for £150 000 at the end of year 1.
Therefore there is a probability of 0.25 that £250 000 will be received at the end of year 1. Hence the expected NPV
will be £56 819. Therefore the entries in the expected value column of the decision tree in (a) for the first three
branches (£5628, £21 694 and £16 012, totalling £43 334) will be replaced with an expected value of £56 819. Hence
the total expected value will increase by £13 485 to £57 972 (£13 485 £44 487).
(c) At time zero the financial effect is that the NPV of the project is increased by £13 485.
(ii) The cash flows are based on the assumption that the reinvestment in R is not made at the end of year 3.
The decision should be to invest in Project T because it has the higher NPV.
Notes
a
Yearly profits plus (£70 000 £10 000)/5 years depreciation.
b
£18 000 profits £12 000 depreciation £10 000 sale proceeds.
c
Profits plus £60 000/3 years depreciation.
d
£75 000 investment outlay £50 000 Annual profit (£25 000). Cash flow £25 000 profit £20 000
depreciation.
(c) For an explanation of the meaning of the term ‘discount rate’ see ‘The opportunity cost of an investment’ in Chapter 13.
27
The discount rate can be derived from observations of the returns shareholders require in financial markets. Where a
project is to be financed fully by borrowing, the cost of borrowing could be used as a basis for determining the
discount rate.
Assuming that the contribution per hour is constant the contribution per hour
is £666.67 (£1 600 000/2400 hrs). Over a 5-year period the present value per hour is £2527 (£666.67 3.791 discount
factor for 5 years at 10%). Thus the annual flying hours to break even are 1120 (£2 829 850/£2527).
If the aircraft is rented the PV of the fixed rental charges is £1 042 500 (£250 000 [1 3.170 discount factor]). The
revised net contribution per hour is £305.67 (£666.67 £361) giving a present value of £1 158.80 (£305.67 3.791
discount factor). Thus the annual hours to break even are 900 (£1 042 500/£1158.80).
To determine the indifference point between renting and buying let x Annual flying hours. The indifference point
is where:
£2527x £2 829 850 £1158.80x £1 042 500
1368.2x £1 787 350
x 1306
Thus, at an activity level of 1306 flying hours per annum, the two options are equally financially viable. At activity
levels of less than 1306 hours renting is preferable, whereas buying is preferable at activity levels in excess of 1306
hours.
(b) Profits are maximized when the aircraft are operated at full capacity of 2400 hours per year. Thus two aircraft should be
purchased utilizing 4800 hours. A third aircraft will be required for the remaining 950 hours. At this activity level it is
more profitable to rent the third aircraft.
It is assumed that the apportioned rental cost of £2500 per annum will still continue if the project is not undertaken.
28
Present value of net cash inflows £132 440
Investment outlay
(£120 000 sale of containers at £18 000) £102 000
––––––––
Net present value £ 30 440
––––––––
29
Answer to question 13.5
(a) Incremental operating costs
Output Machine X Machine Y
(000 units) (£000) (£000)
10 53 43
20 80 57
30 96 66
40 122 139
Minimum cost table
Machine X Machine Y Total
Output Output Cost Output Cost cost
(000 units) (000 units) (£000) (000 units) (£000) (£000)
10 — — 10 43 43
20 — — 20 57 57
30 — — 30 66 66
40 10 53 30 66 119
50 20 80 30 66 146
60 30 96 30 66 162
70 40 122 30 66 188
80 40 122 40 139 261
30
Answer to question 13.6
(a) The present values of the capital costs are as follows:
Discount Present
Year Staff Expenses Contingency Total factor value
(£000) (£)
1 20 5 2.5 27.5 0.8772 24 123
2 22 5 2.5 29.5 0.7695 22 700
3 24 5 2.5 31.5 0.675 21 262
4 26 5 2.5 33.5 0.5921 19 835
5 28 5 2.5 35.5 0.5194 18 439
–––––––
106 359
Initial outlay 60 000
–––––––
166 359
–––––––
If net income is 50% of sales then food sales would need to be £128 310 (£64 155 2) in years 3–5. Therefore annual
sales required are:
(£)
Year 1 44 908 (0.35 £128 310)
2 83 401 (0.65 £128 310)
3 128 310
4 128 310
5 128 310
(b) Aspects of the proposal that might merit further consideration include:
(i) Is the 14% discount rate equivalent to the opportunity cost of funds allocated by the Management Board?
(ii) Prices, potential demand and product range need to be considered. What is the probability that total income will
be sufficient to generate the sales revenue specified in (a)?
(iii) How does the proposed product range, service and price structure compare with other catering facilities available
within the locality?
(iv) Is there sufficient expertise and time available for existing staff to operate the new facilities?
(v) What alternative uses are available for the surplus accommodation?
31
Note:
The tax computation is as follows:
Year 1 2 3
(£) (£) (£)
Net cash inflows before tax 80 000 75 000 69 750
Writing down allowances 37 500 28 125 84 375
Taxable profit 42 500 46 875 (14 625)
Tax at 33% 14 025 15 469 (4 826)
Writing down allowances:
Opening WDV 150 000 112 500 84 375
Writing down allowances (25%) 37 500 28 125
Closing WDV 112 500 84 375 Nil
Balancing allowance 84 375
(b) Because corporation taxes are payable on taxable profits and not accounting profits depreciation has been replaced by
the Inland Revenue’s allowable depreciation (known as written-down allowances). The net cost of the asset is £150 000
and written-down allowances received amounted to £65 625 (£37 500 + £28 125). Therefore a balancing allowance is
available at the end of the asset’s life of £84 375 (£150 000 £65 625). The Inland Revenue allows the net cost of the
asset to be claimed over its life with a balancing adjustment in the final year. Because taxation is normally payable 9
months after the company’s accounting year end the taxation cash flows are shown to be delayed by one year. This is a
simplification of the actual situation but is normally sufficiently accurate for appraising investments.
(c) Other factors to be considered include:
(i) The probability of obtaining a subsequent contract. There would be no need to purchase a further machine and
the project would therefore yield a positive NPV.
(ii) The negative NPV is very small and if the company has other profitable activities it may be worthwhile accepting
in order to have the chance of obtaining a second contract and establishing long-term relationships with a large
multinational customer.
(iii) Capacity that is available. If other profitable opportunities have to be forgone to undertake the contract because of
shortage of capacity then the opportunity cost should be included in the financial analysis.
(£)
Purchase price (£52 000 4) 208 000)
PV of annual operating costs for 7 years (£15 000 4 4.564) 273 840)
Salvage value (4 £4000 0.4523) (7 237)
––––––––
PV of costs over 7-year life 474 603)
––––––––
––––––––
The new machines have the lowest equivalent annual cost. Therefore they should be replaced now. This decision is based
on the assumption that no superior or cheaper machines will be available in three years’ time. If other opportunities are
likely to be available in three years’ time then the combination of operating the old machines and replacing with more effi-
cient or cheaper machines should be considered.
The costs of modifying the factory building should be compared with the savings that result from the installation of the
new machines. Equivalent annual savings from purchasing the new machines are £16 828 (£120 816 £103 988) for three
years. The PV of these savings is £40 421 (£16 828 2.402). It is assumed that if the factory is not modified now, it will have
to be modified in three years’ time when the current machines reach the end of their life. Assuming the cost of modifica-
tion will still be £60 000 in three years’ time, the relevant cost of the modification is:
32
(£)
PV of modification now 60 000
Less PV of modification in 3 years’ time (£60 000 0.712) 42 720
––––––
Relevant cost of modification now 17 280
––––––
It is therefore worthwhile to incur a cost of £17 280 now in order to achieve savings with a PV of £40 421.
The machines have unequal lives, and to compensate for this the equivalent annual cost method should be used:
Exe equivalent annual cost £4922 (£33 538/6.814)
Wye equivalent annual cost £5510 (£23 995/4.355)
Exe should be purchased, since it has the lowest equivalent annual cost. It is assumed that both machines have the
same performance reliability, quality and output and that there is no inflation.
(b) The answer should describe one of the three approaches outlined in Chapter 14. For a description of these approaches
see ‘The evaluation of mutually exclusive investments with unequal lives’.
(c) See ‘Life cycle costing’ in Chapter 22 for the answer to this question.
Proposal two
Time 0 1 2 3 4
(31.12.00) (31.12.01) (31.12.02) (31.12.03) (31.12.04)
(£) (£) (£) (£) (£)
Opportunity cost of
disposal proceeds
foregoned (60 000)
Balancing charge
avoidedd 30 000)
Net cash inflowse 68 000) 67 840)
33
Tax on inflows (34 000) (33 920)
Working capital (7 000) 7 000)
–––––––––––––––––––––––––––––––––––––––––––––––––
Net cash flow (7 000) 8 000) 40 840) (3 920)
Discount factorc 1) 0 826) 0 696) 0 597)
–––––––––––––––––––––––––––––––––––––––––––––––––
Present values (7 000) 6 608) 28 425) (2 340)
–––––––––––––––––––––––––––––––––––––––––––––––––
Net present value £25 693
Proposal two should be chosen because it has the highest NPV.
Notes
a
The writing down allowances are calculated as follows:
A/c Period
ended (£) (£) Time
31.12.00 Investment 62 500)
WDA at 20% (12 500) Tax saved at 50% 6 250 1
–––––––
50 000)
31.12.01 WDA at 20% (10 000) Tax saved at 50% 5 000 2
–––––––
40 000)
31.12.02 WDA at 20% (8 000) Tax saved at 50% 4 000 3
–––––––
32 000)
31.12.03 Scrap proceeds (5 000)
–––––––
Balancing
allowance 27 000 Tax saved at 50% 13 500 4
–––––––
b
Working capital requirements are 10% of net cash inflows (i.e. £4000 at Time 0, £5500 at Time 1 and £7000 at Time 2).
Only incremental changes in working capital are included in the cash flow analysis.
c
Because the cash flows have been expressed in nominal terms the discount rates should also be expressed in nominal
terms. Nominal discount rate (1 Real discount rate) (1 Anticipated inflation rate) 1.
2001 (1.10) (1.10) 1 0.21 (21%)
2002 (1.10) (1.08) 1 0.188 (18.8%)
2003 (1.10) (1.06) 1 0.166 (16.6%)
2004 (1.10) (1.05) 1 0.155 (15.5%)
The discount factors are:
Time 1 1/1.21 0.826
Time 2 1/1.21 1/1.188 0.696
Time 3 1/1.21 1/1.188 1/1.166 0.597
Time 4 1/1.21 1/1.188 1/1.166 1/1.155 0.517
The above calculations reflect the fact that different discount rates are used each year. For example, cash flows in Time
4 have to be discounted back to Time 3 at 15.5%, Time 3 back to Time 2 at 16.6%, Time 2 back to Time 1 at 18.8% and
Time 1 back to Time 0 at 21%.
d
Proposal 2 utilizes existing machinery which would otherwise be sold. Therefore the opportunity cost should be
included as a cash flow. If Proposal 2 is not undertaken the company has the choice of either selling the machine at 31
December 2000 for £50 000 or selling it at 1 January 2002 for £60 000.
The PV calculations are:
Therefore the company should sell the machine at January 2002 if Proposal 2 is not accepted and the latter cash flows
therefore represent the relevant cash flows to be included in the analysis.
e
The incremental labour cash flows arising from the project are £22 000 for 2001 and £23 760 for 2002, but £20 000 and
£21 600 have been included in the operating cash inflows given in the question. Therefore cash inflows must be
reduced by £2000 in 2001 and £2160 in 2002.
34
(b) Reservations relating to the figures used in (a) include:
1. The accuracy of the estimated cash flows, inflation rates and discount rates.
2. It is assumed that all cash flows are received at the year end whereas they are likely to occur throughout the year.
3. The projects may entail different levels of risk but this has been ignored in the analysis.
Cash costs
Direct labourb 354 553) 608) 668)
Material Zc 102 161) 174) 188)
Components P and Qd 250 382) 413) 445)
Other variable costse 25 39) 42) 45)
Management salariesf 67 72) 77) 82)
Selling expensesg 166 174) 183) 192)
Rentalh 120 126) 132) 139)
Other fixed overheadi 50 53) 55) 58)
––––– ––––– ––––– –––––
1134 1560) 1684) 1817)
––––– ––––– ––––– –––––
Sales less cash costs 186 461) 499) 538)
Taxj 9 (87) (100) (114)
Initial investment (864)
Residual value 12)
–––– ––––– ––––– ––––– –––––
(864) 195 374) 399) 436)
–––– ––––– ––––– ––––– –––––
Notes
a
Sales revenue: year 1 12 000 £110
2 17 500 £110 (1.05)
3 18 000 £110 (1.05)2
4 18 500 £110 (1.05)3
b
Labour costs: year 1 12 000 £29.50, year 2 17 500 £29.50 (1.07),
year 3 18 000 £29.50 (1.07)2, year 4 18 500 £29.50 (1.07)3.
c
72 000 kg are required in year 1. The relevant cost for the 70 000 kg in stock is £99 000 opportunity cost. The acquisition
cost for the remaining 2000 kg is £2920 (2000 £1.46). For the remaining years the relevant costs are:
year 2 17 500 6 kg £1.46 (1.05), year 3 18 000 6 kg £1.46 (1.05)2, year 4 18 500 6 kg £1.46
(1.05)3.
d
Components P and Q (£20.80 per unit): year 1 12 000 £20.80, year 2 17 500 £20.80 (1.05), year 3 18 000
£20.80 (1.05)2, year 4 18 500 £20.80 (1.05)3.
e
Year 1 12 000 £2.10, year 2 17 500 £2.10 (1.05), year 3 18 000 £2.10 (1.05)2, year 4 18 500 £2.10
(1.05)3.
f
Relevant cash outflows for year 1 are (£25 000 2) £17 000 £67 000, year 2 £67 000 (1.07), year 3 £67 000
(1.07)2, year 4 £67 000 (1.07)3.
g
Selling expenses £166 000 per annum adjusted at 5% for inflation.
h
Rental opportunity cost £120 000 per annum adjusted at 5% for inflation.
i
Relevant cash flows for other fixed overheads £70 000 £20 000 apportioned costs. The cash flows are adjusted at a
5% compound inflation rate for years 2–4.
j
The tax cash flows are calculated as follows:
Year 1 2 3 4
(£000) (£000) (£000) (£000)
Sales less cash costs 186 461 499 538
Capital allowances 213 213 213 213
–––––––––––––––––––––––––––––––––––––––
Taxable profits (27) 248 286 325
Tax at 35% (9) 87 100 114
It is assumed in year 1 that the company has sufficient taxable profits to set-off the negative table profits from the
project.
Apportionment of head office costs are not relevant cash flows.
Interest payments are not included, because the cost of finance is already reflected in the discount rate.
The IRR can be found by using the interpolation method. The objective is to find the discount rate where the sum of
the present values for years 1–4 equals £864 000 initial outlay. At 15% and 25% the NPVs are respectively £101 000
and £86 000. Using the interpolation method:
35
101
IRR 15% 10% approximately 20%
101 (86)
(b) An asset beta reflects the beta of the company, assuming all equity financing.
In contrast, the equity beta reflects the beta for a particular mixture of debt and equity. Equity betas include the
additional financial risk from gearing, and will therefore be higher than asset beta because of the additional risk.
Assuming that Amble plc is all equity-financed, the asset beta can be used to estimate the required rate of return
(discount rate for the project):
RRR
risk-free
rate (8%)
冤
market
risk-free
return (15%) rate (8%) 冥
beta (1.2)
16.4%
The IRR of 20% is in excess of the required rate of return (16.4%). On a purely financial evaluation the project should
be accepted.
(c) Using a discount rate of 17%, the expected NPV is:
The product will not be financially viable when the present value of the additional taxation exceeds £58 000.
The taxable cash flows calculated in (a) are:
Therefore taxation rates can increase by 11% from 35% to 46% before NPV becomes negative.
36
t2 t3 t4
£50 600 £50 600 1.10 £50 600 1.10 …
––––––– ––––––––––––– –––––––––––––
(1.21)2 (1.21)3 (1.21)4
For a 3-year life the net cash flows from t2 to t4 are discounted, for a 5-year life those from t2 to t6 are discounted and for
a 10-year life those from t2 to t11 are discounted. It should be noted that the required rate of return of 1.21 can be
expressed as 1.10 1.10, and 1.10 also appears in the numerator as the inflation compounding factor. We can therefore
take an alternative short-cut approach by initially discounting the cash flows back to t2 and then discounting the cash
flows from t2 back to t0. The cash flows can be expressed as follows:
It can be seen that the above expression is equivalent to discounting £50 600 by 10%. This approach enables the
cumulative discount tables to be used.
The above cash flows are expressed in terms of t2. They are now discounted at 21% back to t0.
The NPV can now be calculated by combining the above cash flows:
(0.4 £65 414) (0.4 £16 414) (0.2 £57 944) £8011
(b) If the survey is commissioned, the company will avoid the negative NPVs resulting from formation types B and C by
cancelling the project. The value of the survey can be found by comparing the expected NPVs with and without the
survey:
(£)
Expected NPV with survey: Rock type A (£65 414 0.4) 26 166
Rock type B (cancel) 0
Rock type C (cancel) 0
––––––
26 166
Expected NPV without survey 8 011
––––––
Benefit from survey 18 155
Cost of survey 10 000
––––––
Net benefit from survey 8 155
––––––
The company should commission the survey based on the expected value decision rule. The major weakness of the
expected value approach is that it ignores risk. However, if the range of possible outcomes from the two alternatives is
compared, it can be seen that the geological survey substantially reduces the range of outcomes. Without the survey, the
outcomes range from £57 944 to £65 414, whereas with it the range is from £10 000 (cost of the survey) to £55 414
(£65 414 £10 000 cost of the survey). This substantial reduction in risk provides a further justification for commissioning
the survey.
37
Answers to extra questions for Chapter 15 The budgeting process
a) Corporate planning can be defined as ‘The systematic study of long-term objectives and the strategies required to achieve
them’. Budgeting is the preparation of detailed financial and/or quantitative statements that are drawn up and approved
prior to a defined period of time (normally one year). For a comparison of the aims and main features of corporate
planning and budgeting systems see ‘Stages in the planning process’ and ‘Multiple functions of budgets’ in Chapter 15.
(b) See ‘Zero-base budgeting’ in Chapter 15 for the main items that should be included in answering this question.
38
(iv) Purchases budget
Purchases (units): Frame D E F
Closing stock 900 3 600 9 000 3 600
Add used in production 3 240 8 800 16 180 8 370
–––––– –––––– –––––– ––––––
4 140 12 400 25 180 11 970
Less opening stock 1 000 4 000 10 000 4 000
–––––– –––––– –––––– ––––––
Purchases (units) 3 140 8 400 15 180 7 970
–––––– –––––– –––––– ––––––
Cost (£) 62 800 67 200 75 900 23 910
Frames D E F
End of
period 1 900 3600 9000 3600
Requirements
for 1 week 810 (3240/4) 2200 (8800/4) 4045 (16 180/4) 2092 (8370/4)
–––––––––––––––––––––––––––––––––––––––––––––––––––––––
Stock
reduction 90 1400 4955 1508
–––––––––––––––––––––––––––––––––––––––––––––––––––––––
39
Normal hours (50 employees × 35 hours × 12 weeks) 21 000
––––––
Overtime hours 2 475
––––––
(e) Normal hours (50 employees × 12 weeks × £210) £126 000
Overtime (2475 hours × £9) £22 275
––––––––
Cost of labour £148 275
––––––––
Notes Alphas Betas
a
Sales this quarter 2000 2400
Add 20% seasonal variation 400 480
–––––– ––––––
Budgeted sales next quarter 2400 2880
–––––– ––––––
Closing stock (5/60 × 2400 = 200) (10/60 × 2880 = 480) 200 480
Closing stock of materials
b
Task 2
(a) Some of the following limitations should be included in the report:
(i) Past data are normally used as a basis for determining the linear regression formula. If only a small number of
past observations are available the resulting regression formula is not likely to be very accurate.
(ii) The technique assumes that a linear relationship exists whereas in practice a curvilinear relationship may exist.
(iii) If past data are used to make future predictions it is assumed that the past trend will continue into the future.
However, past trends may suddenly change for a variety of reasons.
(iv) If abnormal observations are included in past data the regression equation will not be typical of future normal
relationships.
Task 2
(b) The report should identify the following alternative methods of forecasting:
(i) Market research involving customer surveys of likely future demand.
(ii) Obtaining estimates from salespersons who deal with the customers and who have the knowledge to predict
future demand.
Note that linear regression is dealt with in Chapter 24.
Cash outflows:
Business purchase 315.0 — — —
Delivery van — 15.0 — —
Raw materials (W2) — 44.375 29.375 30.625
Direct labour (W2) 27.0 17.25 18.0 18.75
Production overhead (W3) 10.5 10.5 10.5 10.5
Selling and administration
overhead (W4) 39.875 14.875 14.875 14.875
–––––––– –––––––– –––––––– ––––––––
392.375 102.0 72.75 74.75
Surplus/(deficit) for month (368.375) (8.4) 19.85 15.95
Opening balance — (368.375) (376.775) (356.925)
Closing balance (368.375) (376.775) (356.925) (340.975)
Workings
40
Month 1 Month 2 Month 3 Month 4
(W1) Cash inflow from sales 24 24 23 24
––– –––– –––– ––––
Cash inflow from credit sales — 72 72 69
Less discount — (2.4) (2.4) (2.3)
––– –––– –––– ––––
— 69.6 69.6 66.7
––– –––– –––– ––––
Total cash inflow 24 93.6 92.6 90.7
––– –––– –––– ––––
(W2) Selling price at a mark-up of 60% on production cost is £8 per unit
(£5.00 1.60).
(b) (£)
Finished goods stock (12 500 units £5 per unit) 62 500
Raw materials stock (6500 units £2.50 per unit) 16 250
Debtors 69 600
–––––––
148 350
–––––––
Creditors 31 875
Apart from the purchase of the business, the cash budget suggests that there will be sufficient cash inflows to meet the
cash outflows. The current assets and debtors provide sufficient funds to cover the creditors. However, this does not
take into account possible funding by bank overdraft to finance the business purchase.
41
Variable overhead (W5) — 960 4 600 7 080
Fixed overhead (W6) 1 000 3 000 3 000 3 000
–––––– –––––– –––––– ––––––
1 000 20 310 51 900 59 230
Balance c/d 9 000 3 890 9 090 29 860
–––––– –––––– –––––– ––––––
Workings
(W1) Sales
Amount 20% Discount Net 50% 20% 8% Total
5% cash
receipts
January — — — — — — —
February 80 000 16 000 800 15 200 15 200
March 90 000 18 000 900 17 100 40 000 57 100
April 100 000 20 000 1000 19 000 45 000 16 000 80 000
May 100 000 20 000 1000 19 000 50 000 18 000 6400 93 400
(W2) Production:
Total
January 800 800
February 2400 900 3300
March 2700 1000 3700
April 3000 1000 4000
May 3000
–––– –––– –––– ––––
3200 3600 4000 4000
–––– –––– –––– ––––
(ii) It is assumed that the question relates to the amount received from customers in May and not the amount due. The
answer is £93 400 (see W1).
(b) A software package would eliminate the tedious arithmetical calculations that are necessary to produce cash budgets.
Furthermore, it would enable alternative scenarios to be considered, such as what the outcome would be if any of the
parameters were changed.
42
Answers to extra questions for Chapter 16 Management control systems
43
(b) The answer to this question should include a discussion of the following points:
(i) Timely reporting and frequent feedback.
(ii) Variances should be suitably analysed in order to help pinpoint where corrective action is necessary.
(iii) For control purposes actual results should be compared against ex-post standards.
(iv) Actual results should be compared with flexed budgets.
(v) Not all variances should be investigated. Clear rules should be established as to the criteria that should be used to
establish whether a variance investigation is justified (see Chapter 19).
(vi) The behavioural considerations specified in Chapters 16 and 17 should be taken into account when operating a
system of budgetary control.
Answers to extra questions for Chapter 18 Standard costing and variance analysis 1
44
Soap pack usage variance = (Standard quantity Actual quantity) Standard price
= (8400 8580) £1.20
= £216A
Cleaning labour rate variance = (Standard rate Actual rate) Actual hours
= (£3.60 £3) 1850 = £1 110F
= (£3.60 £4.50) 700= £630A
–––––––
£480F
–––––––
(b) (i) The soap price variance could be due to inflation and a general increase in the market price. In such circum-
stances the standard price should be altered to reflect the current standard price.
(ii) The adverse soap usage variance could be due to theft or excess issues. Managers should check that stocks are
securely locked away and that only the standard quantity is issued each day.
(iii) The labour rate variance may have arisen because proportionately less weekend work was undertaken than that
allowed for in the standard. It may be appropriate to maintain separate standards for weekend and non-weekend
work and separate records so that variances can be reported for both categories of labour.
(iv) The standard time may represent an inappropriate standard that must be changed. Alternatively, excessive idle
time may have occurred because of rooms not being vacated when the cleaners are being paid. Working practices
and vacation procedures should be investigated to ensure that vacation is synchronized with when the cleaners
are employed for cleaning the rooms.
(b) £ £
Standard cost of production (9500 £184) 1 748 000
Add adverse variances: Material price 39 000
Material usage 40 000
Wage rate 15 600
Labour efficiency 6000 100 600
–––––– –––––––––
Actual cost 1 848 600
–––––––––
Task 2
(a) Material used in standard quantities
(1500 100/80 8 litres) = 15 000
Standard usage for special order (1500 8) = 12 000
Material usage variance arising from special order
(3000 kg £20) = £60 000A
Material price variance arising from special order
(15 000 kg (£22 £20)) = £18 000A
Wage rate variance arising from special order
(1500 4 hrs £6 50%) = £18 000A
45
(b) Revised standard price (247.2/240 £20) £20.60
Increase over original standard £0.60
Material used excluding special order (78 000 15 000) 63 000 litres
Price variance arising from price increase (63 000 £0.60) £37 800A
(c) £ £
Standard cost of production 1 748 000
Add non-controllable variances
Special order material usage variance 60 000A
Special order material price variance 30 000A
Special order wage rate variance 18 000A
Material price variance due to increase in
market price 37 800A 145 800A
–––––––
Add controllable variances:
Material price (£39 000 £30 000 £37 800) 28 800F
Material usage (£40 000 £60 000) 20 000F
Wage rate (£15 600 £18 000) 2 400F
Labour efficiency 6 000A 45 200F
––––––– –––––––––
Actual cost 1 848 600
–––––––––
(d) The answer should draw attention to the fact that the divisional total variance was £100 600 but £145 800 was not
controllable by the manager. This consisted of £37 800 arising from an increase in market prices and £108 000 arising
from the special order. The manager should be congratulated on the favourable controllable variances.
If the index of material prices was applicable to the type of materials used by the division then the standard should
be altered to reflect the price change. The profitability of the special order should be recalculated after taking into
account the extra cost arising from the adverse variances and the sales director informed. The sales director should also
be requested to provide details of special orders to the relevant managers so that steps can be taken to ensure that the
materials can be obtained from the normal supplier.
46
Sales volume variance = (Actual volume – Budgeted volume)
× Standard margin
= (860 – 750) × £4.50 = 495F
Reconciliation of budgeted and actual profit
(£)
Budgeted profit 3375
Sales volume variance 495
––––
Budgeted profit on actual sales 3870
Sales price variance 430
––––
3440
Price Usage
Ingredients: (£) (£)
Mushrooms 30A 12A 42A
Cream, etc. n/a n/a 12F
Beef 98A 240F 142F
Potatoes 5F 2A 3F
Vegetables 7A 11A 18A
Other n/a n/a 2A
Fresh fruit 30A 33A 63A
––––
Actual profit 3472
––––
(d) The sales volume and sales price are the two most significant variances. The adverse sales price variance is due to a
reduction in selling price which may have been implemented to stimulate demand. The reduction in the selling price
would appear to be the reason for the increase in sales volume and the favourable variance. Overall the selling price
reduction has been beneficial with the favourable volume variance exceeding the adverse price variance.
47
Wage rate variance = (Standard price Actual price) Actual hours
= (£8.40 £8.65) £612 766/£8.65 = £17 710A
Labour efficiency variance = (Standard hours Actual hours) Standard price
= (15 400 4.5 hrs = 69 300 70 840a) £8.40 = £12 936A
Fixed overhead expenditure = Budgeted cost Actual cost
= £86 400 £96 840 = £10 440A
Sales margin price = (Actual price Budgeted price) Actual volume
= (£138.25 £140) 15 400 = £26 950A
Sales margin volume = (Actual volume – Budgeted volume) Standard margin
= (15 400 16 000) £19.10b £11 460A
Notes:
a
Actual hours = £612 766/£8.65 = 70 840
(£)
b
Budgeted contribution margin = Selling price 140.00
Less Direct materials (6 £12.25) + (3 £3.20) 83.10
Direct labour (4.5 £8.40) 37.80
–––––––
19.10
–––––––
Reconciliation statement: (£)
Budgeted profit 219 200
Add favourable variances (£2541 + £12 320) 14 861
–––––––
234 061
Less adverse variances (£49 280 + £75 460 + £17 710 + £12 936)
(+ £10 440 + £26 950 + £11 460) 204 236
–––––––
Actual profit 29 825
–––––––
(c) The purchase of cheap, poor quality materials below standard price will result in a favourable price variance but may
be the cause of an adverse material usage and labour efficiency variance. Similarly, the use of unskilled instead of
skilled labour will result in a favourable wage rate variance and may be the cause of an adverse material usage vari-
ance arising from spoilt work and excessive usage of materials. The use of less skilled labour may also result in an
adverse labour efficiency variance if the workers are not as efficient as skilled workers.
48
Fixed overhead expenditure: (Budgeted cost Actual cost)
Fixed overhead expenditure: (£1 521 600 £1 501 240) £20 360F
(b) The variable overhead machine-related efficiency variance arises because machine hours exceeded target (standard)
hours that should have been used for the actual output. Because it is assumed that some variable overheads vary with
machine hours the excess usage has resulted in additional spending on variable overheads. Failure to maintain
machinery may have resulted in the use of hours in excess of standard.
The variable overhead labour-related variance arises because actual direct labour hours were less than the hours that
should have been used for the actual output. This has resulted in reduced expenditure on those variable overheads
that vary with direct labour hours. An improvement in the efficiency of direct labour has resulted in the favourable
variance.
The variable overhead labour-related expenditure variance arises because actual spending was less than budgeted
spending flexed to the actual level of activity. Prices paid for variable overhead items (e.g. indirect materials) may have
been lower than the figures used to derive the budgeted expenditure. For a more detailed answer see the section on
variable overhead expenditure variance in Chapter 18.
(c) See the comparison of ABC and traditional product costing systems in Chapter 10 for the answer to this question. In
particular, the answer should demonstrate how the use of multiple cost drivers should result in the reporting of more
accurate product costs than when a single cost driver is used. In order to understand and manage costs more
effectively there is a need to measure overhead resource consumption using cost drivers that are the causes of
overhead expenditure. Different cost drivers, rather than a single cost driver, provide a better explanation of cost
behaviour. Thus multiple cost drivers should also result in better cost management (see the section on activity-cost
management in Chapter 22 for a more detailed explanation of this point).
49
Answer to question 18.7
(a) (i) Material price variance (SP AP)AQ (SP AQ) (AQ AP)
(£1.20 142 000) £171 820
£1420A
(ii) Material usage variance (SQ AQ)SP
(1790 9 16 110 16 270) £1.20
£192A
(iii) Actual price per kg in period 1 £1.21 (£171 820/142 000 kg)
The actual price per kg for period 2 is not given and must be calculated from the data given in the question.
(b) The variances have been calculated using a variable costing approach.
Sales margin volume:
(actual sales volume budgeted sales volume)
standard contribution margin
(4500 5000) £25 (W1) £12 500A
Sales margin price:
(actual price budgeted price) actual sales volume
(£550 000/4500 £120) 4500 £10 000F
Direct material cost:
(as per statement in (a)) £5 000F
Wage rate:
(SR AR) actual hours
(£4 £189 000/47 500) 47 500 £1 000F
Labour efficiency:
(Standard hours actual hours) standard rate
[(90% 50 000 45 000) 47 500] £4 £10 000A
50
Variable overhead efficiency:
(SH AH) variable overhead rate
(45 000 47 500) £1 £2 500A
Variable overhead expenditure:
DLH’s flexed budget actual cost
(47 500 £1 £46 000) £1 500F
Variable selling overhead:
flexed budget (£67 500 £72 000) £4 500A
Fixed overhead expenditure variances (budgeted cost actual cost):
Production overhead (£25 000 £29 000) £4 000A
Fixed selling overhead (£50 000 £46 000) £4 000F
–––––––––
Total variances £12 000A
–––––––––
Working
(W1) Standard contribution per unit
budgeted contribution (£125 000)/budgeted volume (5000 units)
(c) The report is based on a variable costing approach and shows the lost contribution arising from a decline in sales
volume. With a variable costing system, fixed overheads are not allocated to products, and therefore the volume
variance is not applicable. The report compares actual costs with a flexible budget in order to derive the cost variances.
(For a description of flexible budgets see ‘Flexible budgeting’ in Chapter 16.) In addition, the original budget is
compared with the flexible budget in order to highlight the decline in profits arising from a failure to achieve the
budgeted sales volume.
The report for this period shows that the total cost variances were £500 favourable, but the major problem relates to
the decline in sales volume, which accounted for a reduction in profits of £12 500.
Answers to extra questions for Chapter 19 Standard costing and variance analysis 2:
further aspects
(£) (£)
Opening balance 2/11 WIP (2000 £1.04) 2 080
(9000 kg at £1.04) 9 360 7/11 WIP (4500 £1.04) 4 680
4/11 Purchases
4/11 (10 000 £1.04) 10 400 20/11 WIP (4000 £1.04) 4 160
23/11 Purchases
4/11 (8000 £1.04) 8 320 27/11 WIP (6000 £1.04) 6 240
Closing balance
(10 500 £1.04) 10 920
–––––– ––––––
28 080 28 080
–––––– ––––––
Creditors account
51
(ii) Material price variance identified at time of issue of material
Using the weighted average basis, the actual issue prices are calculated as follows:
(£)
Opening balance (9000 £1.07) 9 630)
2 November issue (2000 £1.07) (2 140)
–––––––
Balance 7000 at £1.07 (£7490/7000) 7 490)
4 November purchase (10 000 kg) 10 530)
–––––––
Balance (17 000 kg at £1.06) 18 020)
7 November issue (4500 £1.06) (4 770)
20 November issue (4000 £1.06) (4 240)
–––––––
Balance (8500 £1.06) 9 010)
23 November purchase (8000 kg) 8 480)
–––––––
Balance (16 500 kg at £1.06) 17 490)
27 November issue (6000 kg £1.06) 6 360)
Variance (SP AP) actual issues
2 November: (£1.04 £1.07) 2000 £60A
7 November: (£1.04 £1.06) 4500 £90A
20 November: (£1.04 £1.06) 4000 £80A
27 November: (£1.04 £1.06) 6000 £120A
Note that the entries in the stock account in (a) (i) are based on the approach described in Chapter 19 whereby the
stock account is debited at the standard cost and the variances are extracted at the time of purchase. Where vari-
ances are extracted at the time of issue, it is preferable to use an alternative approach when preparing the stock
account. With this approach, the stock account is debited at actual cost, and issues are recorded at standard cost
and the price variances are recorded within the stock account.
(iii) Material Z
(£) (£)
2/11 Material Z 60 30/11 Profit and loss 350
7/11 Material Z 90
20/11 Material Z 80
27/11 Material Z 120
––– –––
350 350
––– –––
(b) The method by which variances are extracted at the time of purchase is preferred because variances are reported at the
earliest opportunity. In addition, the stock recording system is simplified.
(c) Workings:
Equivalent units
Materials Labour and overhead
Completed production 9 970 9 970
Add closing WIP 8 000 6 000
–––––– ––––––
17 970 15 970
Less opening WIP 6 000 3 000
–––––– ––––––
Equivalent production 11 970 12 970
–––––– ––––––
Overhead variance
actual cost standard cost
6680 (12 970 units 0.1 £5.00)
£195A
Process 1
(£) (£)
Opening balance: Finished goods:
Materials: 9970 units £1.50 14 955.5
6000 units £0.52 Closing balance:
Direct labour and overhead: Materials:
3000 units £0.98 6 060 8000 units £0.52
Materials: Direct labour and overhead:
6000 kilos £1.04 6 240 6000 units £0.98 10 040.5
Direct labour: Material usage variance 15.6
1340 hours £4.80 6 432 Labour efficiency variance 206.4
Overheads 6 680 Overhead variance 195.5
–––––– –––––––
25 412 25 412.5
–––––– –––––––
53
(b) (i) Team composition variance
(Actual hours at standard mix actual hours at actual mix) standard rate
(1920 0.083 159.36 170) £8 £85.12A
(1920 0.417 800.64 820) £6 £116.16A
(1920 0.25 480 420) £6 £360.00A
(1920 0.083 159.36 230) £7 £494.48A
(1920 0.167 320.64 280) £4 £162.56A
–––––––––
£173.20A
–––––––––
(ii) Team productivity variance
(actual output standard output) standard cost per unit of output
[1650 standard hours (0.9 1920 standard hours)]
£6.5722 per standard hour £512.62A
(iii) Labour efficiency variance
(actual output standard cost per unit of output)
(actual hours standard rate)
(1650 standard hours £6.5722 £10 844.16) £11 530 £685.82
Alternatively, the labour efficiency variance can be computed by adding the productivity and composition vari-
ances (£512.62 £173.20 £685.82)
(c) The team composition and the team productivity variances are similar to the material mix and yield variances. For a
discussion of the meaning of these variances and their limitations see ‘Mix and yield variances’ in Chapter 19.
54
2. Influence of activity level in calculating predetermined overhead rates. Overhead will only be recovered in sales
revenue if demand is equivalent to the activity level that was used to calculate the overhead rate.
3. Limitations that apply when common costs are apportioned to products and an example of how this can lead to
incorrect decisions.
4. Limitations of cost-plus pricing.
5. Arguments in support of cost-plus pricing.
6. An indication that full costs including overhead apportionments might provide an indication of the long-run
production cost.
Most of the above points are included in Chapters 9–11.
(ii) Overhead cost absorption procedures for control of costs
The answer should state that costs should be analysed into controllable and non-controllable elements.
Apportioned costs should be separately shown in a section headed ‘Uncontrollable costs’ in the performance
report. The answer should stress accountability and responsibility when costs are attributed to individuals for con-
trol purposes. Overhead absorption should be used for product costing purposes, but not for cost control pur-
poses.
(£)
Fruit extract (400 428) £0.19 5.32A0
Glucose syrup (700 742) £0.12 5.04A0
Pectin (99 125) £0.332 8.632A
Citric acid nil0
–––––––
18.992A
–––––––
(c) The advantages of distinguishing between planning and operation variances are:
(i) Comparisons are made against targets that take into account the changing conditions from when the targets were
originally set. The revised ex post standard thus compares actual results with an adjusted standard that reflects
these changed conditions.
(ii) Variances reflect only factors under control of managers, and managers will be more highly motivated if their per-
formance is compared against more realistic targets.
(iii) Planning variances provide useful feedback information on the accuracy of predicting standards and budgets.
The disadvantages are:
(i) Difficulty in establishing revised standards.
(ii) Managers accountable for variances might try and influence the allocation of the variances to the planning/uncon-
trollable category.
55
(d) Mixture variance
(£)
Ingredients planning variances 26.00A
Ingredients operating variances 13.162A
Labour operating variance (£58.50 £60) 1.50A
––––––––
40.662
––––––––
Reconciliation statement
(£) (£)
Budgeted sales revenue 87 500)
Budgeted standard variable cost 48 000)
–––––––
Budgeted contribution 39 500)
–––––––
56
Variable cost variances
Materials
usage (180)
price (270) (450)
–––––––
Labour
efficiency (200)
rate 1 100) 900)
–––––––
Variable overhead
efficiency (600)
expenditure (750) (1 350)
––––––– –––––––
(b) The revised presentation differs from the original because it takes into account changes in the production volume by
flexing the budget. The original presentation adopts a fixed budgeting approach and compares the budgeted costs for
the original budget of 500 units with the actual costs for an actual output of 450 units. Thus, like is not being compared
with like and favourable variances are likely to be incorrectly recorded for variable costs whenever actual production is
less than the original fixed budget.
Variance reporting should be based on flexing the budget, as shown in the revised presentation. The revised
presentation supports the comments of the managers because it shows adverse production variances, and that sales
have been made at above standard prices, but volume is down on budget.
(c) A number of writers have questioned the usefulness of standard costing in a modern manufacturing environment.
They question whether variance analysis is meaningful in those situations where costs are not variable in the short
run. Where costs are fixed and sunk within the performance reporting operating period the reported variances may be
of little use for short-term operational cost control. In a modern manufacturing environment a large proportion of
costs may be unrelated to short-term changes in production volume and efficiencies/ inefficiencies.
The value of reporting of traditional material price variances has been questioned in those firms that have adopted
JIT purchasing techniques. If purchasing price variances are used to evaluate the performance of purchasing
management, it is likely that the purchasing manager will be motivated to focus entirely on obtaining materials at the
lowest possible price even if this results in:
(i) The use of many suppliers (all of them selected on the basis of price);
(ii) Large quantity purchases thus resulting in higher inventories;
(iii) Delivery of lower quality goods;
(iv) Indifference to attaining on-time delivery.
JIT companies will want to focus on performance measures which emphasize quality and reliability, rather than
material price variances, which draw attention away from the key factors.
It is also claimed that the setting of standards is not consistent with today’s climate of continuous improvement.
When standards are set, a climate is created whereby they represent a target to be achieved and maintained, rather
than a philosophy of continuous improvement.
Standard costing systems have also been criticized because they emphasize cost control rather than reporting on
areas such as quality, reliability, lead times, flexibility in responding to customer requirements and customer
satisfaction. These variables represent the critical areas where firms must be successful to compete in today’s
competitive environment.
Nevertheless, despite these criticisms, standard costing systems continue to be widely used because they provide
cost data for many different purposes. For example, they provide data for setting budgets, simplifying the task of
inventory valuation, predicting future costs for use in decision-making, and providing data for cost control and
performance appraisal. Standard costs and variance analysis would still be required for other purposes even if
variance analysis were abandoned for cost control and performance appraisal.
57
(ii) Transfer prices are imposed, resulting in divisional autonomy being undermined.
(iii) Ignores market prices.
(iv) Inefficiencies will be passed on to the receiving division if actual cost is used.
(v) Zero profits will be earned by the supplying division. Therefore this measure will not be a reasonable measure of
the economic performance of the division.
(b) Advantages of marginal cost
Will motivate sound decisions if set at the marginal cost of supplying division for the output at which marginal cost
equals the sum of the receiving division’s net marginal revenue from using the intermediate product and the marginal
revenue from the sale of the intermediate product.
Disadvantages of marginal cost
(i) Imposed transfer prices.
(ii) May not provide a meaningful performance measure. If variable cost is constant then the supplying division will
make a loss equal to the total amount of the fixed costs.
(iii Inefficiencies will be passed on to the receiving division if actual cost is used.
(c) Advantages of cost-plus
Provides an indication of the long-run production costs of the company and may provide a reasonable measure of eco-
nomic performance of the supplying and receiving divisions since transfer prices might approximate a fair market
price when no external market exists.
Disadvantages of cost-plus
See absorption cost disadvantages.
(d) Advantages of standard cost
Ensures that inefficiencies are charged to the supplying division and are not passed on to the receiving division.
Disadvantages of standard cost
Depends on whether standard absorption, marginal or absorption-plus is used. See (a) – (c) above for their respective
disadvantages.
58
£81.60, additional costs of £81.60 are incurred, but this will enable additional revenue of £81.60 to be obtained from
sales by L Ltd. The transfer price should therefore be set at £81.60. If K Ltd can purchase product on the external
market at a price below £81.60, it should do so, since this would be in the best interests of the group as a whole.
The above recommendation assumes that L Ltd will not save any selling costs if the product is transferred internally.
If, for example, variable selling overheads of £3 per unit could be saved then the transfer price should be reduced by
£3 60% to reflect the variable cost savings. Without further information, the potential transfer price range would be
between £76.80 (£81.60 £4.80) and £81.60.
(b) The question specifies that K Ltd is working at full capacity. If additional units of product could be produced by
working overtime and this output could not be sold on the external market then the incremental cost per unit of the
additional output would represent the appropriate transfer price.
Alternatively, if product is in short supply, L Ltd should be instructed to supply 2000 kg to K Ltd and use the bal-
ance of its capacity for sales on the external market.
(£000)
L Ltd: Sales (10 000 drumsa at £20 per drum) 200
Costs: Raw materials (£9 per drum) (90)
Other costs (30)
––––
Contribution 80
Fixed costs 40
––––
Profit 40
––––
M Ltd: Sales (750 000 kilolitres at £9 per 25 litres) 270
Costs: Variable (150)
Fixed (60)
––––
Profit 60
––––
Note
a
Sales of L Ltd 250 000 kilolitres internal transfers/25 000 litres per drum.
59
price on the extra output of 8000 drums is reduced by more than £1 (£8000 loss in profits/ 8000 drums) per drum.
The variable cost per kilolitre of M Ltd is £200. Thus the variable cost per 25 kilolitres (i.e. the raw materials required for
1 drum) is £5. If the transfer price for output in excess of 10 000 drums is set at above £5 and less than £8 per drum then
both divisions will gain if the selling price of the final product is reduced by 20% and volume is increased by 80%.
60
The optimal output level is where the MC of £20 is equal to MR
i.e. 20 = 99.44 – 0.0444x
x = 1788 units and Division A will therefore select a selling price of £99.44 – 0.0222(1788) = £59.77 per unit).
At this price Division B will determine its optimum output where:
£200 – 0.2x = £25 + SPA
so that 0.2x = 200 – 25 – 59.77
and x = 576 units
and SP = £200 – 0.1(576) = £142.40 per unit.
(c) See ‘Difficulties in applying economic theory’ in Chapter 11 for the answer to this question.
Because there is no intermediate market, both divisions must agree on the output level. Therefore QC QD Q,
and so
0.0076Q 28.50
Q 3750 (i.e. optimum monthly output is 3750 units)
(ii) The optimum transfer price is the marginal cost of Chem for that output at which the marginal cost equals Drink’s
net marginal revenue from processing the intermediate product (i.e. at an output level of 3750 units as calculated
in (i)). The marginal cost of Chem at an output level of 3750 units is:
At 3750 units the price that Drink would charge for selling the final product is:
Chem Drink
(£) (£)
Revenues (3750 £20.50 TP) 76 875 Revenues (3750 £42) 157 500
Costs (W1) (58 750) Conversion costs (W2) (70 312)
Profit 18 125 Transferred costs (76 875)
Profit 10 313
Workings
(W1) TCC £10 000 £5.50 3750 £0.002 (3750)2 £58 750
(W2) TCD £15 000 £11 3750 £0.001 (3750)2 £70 312
61
(b) (i) In (a) the marginal cost for Chem at different output levels was equated to the NMR of Drink. It is assumed that
the question implies that Chem would quote transfer prices based on its marginal cost at given output levels, so
that Drink would regard these transfer prices (5.5 + 0.0004QC) to be constant per unit for all output levels. Drink’s
net profit (NP) will be as follows:
28.5 0.0116Q 0
Q 2457 units
An alternative approach is to equate the net marginal revenue with the marginal cost of the transfers. Chem will
transfer out at a marginal cost of 5.5 0.0004QC, and Drink will treat this price at a constant sum per unit.
Therefore the total cost of transfers to Drink will be:
5.5 0.008QC
The transfer price for Drink that maximizes its profits is where NMR MC, i.e. where
At 2457 units the price that Drink would charge for selling the final product is:
Chem Drink
(£) (£)
Revenues (2457 £15.33) 37 666 Revenues (2457 £43.034) 105 735
Cost (W1) (35 587) Conversion costs (W2) (48 064)
Transferred costs (37 666)
––––––– –––––––
Profit 2 079 Profit 20 005
–––––––
––––––– –––––––
–––––––
Workings
(W1) TCC £10 000 (£5.50 2457) [£0.002 (2457)2]
(W2) TCD £15 000 (£11 2457) [£0.001 (2457)2]
(c) A sound transfer pricing system should accomplish the following objectives:
(i) It should motivate divisional managers to make sound decisions that will lead to maximization of group profits.
(ii) It should enable a report to be made of divisional profits that is a reasonable measure of the management per-
formance of the division.
(iii) It should ensure that divisional autonomy is not undermined.
When there is a perfect market for the intermediate product, the correct transfer price is the market price, and it will be
possible to achieve all the above objectives. However, when there is no market price, it is unlikely that all the above
objectives can be achieved. The result in (a) achieves the first objective and possibly the second, depending upon the
managers’ attitudes to the relative profits. However, to achieve the first objective, it has been necessary to set the
transfer price centrally, and this means that the prices of internal inputs and outputs are not set by the divisional
managers. Therefore divisional autonomy is undermined.
In (b) the output and transfer pricing decision has been delegated to the divisions. Drink determines its own opti-
mum output level based on Chem’s marginal cost, and thus sets the transfer price. This approach does not result in
maximizing group profits and fails to provide a reasonable measure of each divisions contribution to total group profit.
Central management is likely to regard the solution as unacceptable, because of the loss of profits, and the manage-
ment of Chem will have to accept the transfer price determined by Drink and the resulting low profitability and spare
capacity. The end result is likely to be intervention by central management. The implications for Megacorp are that, in
order to achieve goal congruence, transfer pricing decisions cannot be made independently by either division.
62
(d) The answer should include a discussion of market-based transfer prices, cost-plus transfer prices, transfer prices based
on linear programming methods and negotiated transfer prices. See Chapter 20 for a discussion of these
methods.
63
Subtracting equation (3) from equation (2) gives:
3400b 3440
b = 1.012
Substituting for b in equation (1):
778 4a 760 1.012
a = 2.22
At the planned output level of 260 000 units the contribution is:
2.22 1.012 260 265.34 £265 340
(b) The 95% confidence limit is:
265.34 4.303 14.5 265.34 62.39
Upper limit £327 730
Lower limit £202 950
These are the limits within which we can be 95% certain the actual value of the contribution will be, given the assump-
tions made.
(c) The advantages of using linear regression are:
(i) It takes into account all available observations and yields more accurate results than the high–low method.
(ii) It determines the line of best fit mathematically, and is more accurate than visually determining the line of best fit
using graphical or scattergraph method.
(iii) It is a statistically valid method, and is preferable to subjective methods based on guesswork from past observa-
tions.
For a discussion of the limitations of the technique see pages 964–68 in Chapter 24.
Note
a
(9000 £12.80) £10 000
The regression equation can be derived from the following two equations (see formulae (24.1) and (24.2) in Chapter 24)
and solving for a and b:
Σy Na bΣx
Σxy aΣx bΣx2
Substituting the value for b in one of the above equations gives a value of 4.024 for a.
Alternatively, the formula outlined in the question can be used:
64
180
160
140
120
100
Total
cost
(£000)
80
60
40
20
6 8 9 11 12 14
Output (000)
Figure Q24.12
nΣxy ΣxΣy
b
nΣx2 (Σx)2
6 7655 60 717
b = 11 5476
6 642 (60)2
y- a bx-
a y- bx- (717/6) 11.5476 (60/6) 4.024
(b) The question implies that unit variable cost changes at a particular output level. Figure Q24.12 suggests that the
change takes place at approximately 11 000 units of output.
The linear cost relationships for the two sections of the graph can be estimated using the high–low method,
regression analysis or reading directly from the graph. Using the high–low method, the cost equations are:
The cost function for activity in excess of 11 000 units implies that fixed costs are negative. An examination of the graph
suggests that fixed costs are approximately £21 000 and unit variable costs increase at 11 000 units. Assuming estimated
fixed costs of £21 120 for output levels in excess of 11 000 units, the estimated unit variable cost (VC) at an output level
of 12 000 units can be derived from the following equation:
total cost (£140 400) fixed costs (£21 120) (11 000 £9.48) 1000VC
VC £15
In other words, the cost equation is:
65
(c) Observed Estimated
Output costs Costsa difference
(000) (£000) (£000) (£000)
January 9 105.2 106.44 (1.24)
February 14 172.0 170.40 1.6
March 11 125.4 125.40 0
April 8 96.0 96.96 (0.96)
May 6 78.0 78.00 0
June 12 140.4 140.40 0
Note
Based on cost equation 21 120 9.48x1 15x2
a
(d) For the answer to this question see Chapter 24 (pages 964–68).
The average time taken to produce 1 unit is 0.7768 hours. Therefore 3884 hours (5000 0.7768) will be required to
produce 5000 units. It is assumed that 3884 hours per annum will be available for years 2 and 3. Hence the cumulative
hours for years 1 and 2 will be 7768 (3884 2). It is therefore necessary to determine the number of units of output that
will require 7768 hours.
Let yt total number of hours. Then the average time (y) required to produce 1 unit of output is yt/x, where x
represents the number of units of output. Applying the learning-curve formula:
y axb
yt/x axb
yt axb 1
7768 10x0.7
x0.7 776.8
x 776.81/0.7
776.81.428 57
13 460
Thus the output for year 2 will be 8460 units (13 460 5000). For years 1–3 there are 11 652 hours (3884 3) available.
Applying the above approach:
11 652 l0x0.7
x0.7 1165.2
x 1165.21.428 57
24 020
Thus the output for year 3 will be 10 560 units (24 020 13 460).
Instead of applying the above method, we can use a trial-and-error approach to determine the output for years 2
and 3. For year 2:
By trial and error, the learning-curve formula is applied to output levels between 13 000 and 14 000 units until the time
required is equal to 7768 hours.
NPV calculations
Years 1 2 3
Output 5 000 8 460 10 560
––––– ––––– ––––––
(£) (£) (£)
Sales ( £42) 210 000 355 320 443 520
––––––– ––––––– –––––––
Less costs:
Labour (3884 £6) 23 304 23 304 23 304
Material ( £30) 150 000 253 800 316 800
Overheads 25 000 25 000 25 000
––––––– ––––––– –––––––
Total costs 198 304 302 104 365 104
–––––––– –––––––– ––––––––
Net cash flows 11 696 53 216 78 416
66
–––––––– –––––––– ––––––––
Discount factor 0.8696 0.7561 0.6575
Present values 10 171 40 237 51 559
NPV £101 967 £50 000 £51 967
The contract should be undertaken on the basis of the NPV decision rule.
(b) The answer should include a discussion of the following points:
(i) A discussion of the assumptions relating to the learning curve. The learning rate based on past experience may
not apply to this product. The learning effect may not continue over the whole range of the curve, and the
‘steady state’ may occur at a different point from that implied by the learning-curve formula.
(ii) The impact of inflation has been ignored.
(iii) The company cost of capital has been used. This rate is appropriate only if this project has the same risk as the
average risk of the firm’s existing assets.
(iv) Presumably all of the skilled labour capacity is used to meet the requirements of a single customer. It may be
unwise to be committed to a single customer. The financial position of the customer should be investigated before
acceptance of the order.
(v) The alternative use of the scarce labour should be explored and the present values from the alternative uses com-
pared with the NPV calculated in (a).
(vi) The impact on customer goodwill if the demand from existing customers cannot be met.
80 000
40 000
Figure Q24.17
67
where y = average selling price for x units
a = the selling price for the first unit of output
x = the number of units of output under consideration
n = exponent function
£327.80 = £10 000 × 500n
£327.80/£10 000 = 500n
0.03278 = 500n
n
= log 0.03278 / log 500 = 3.1479 / 6.2146 = 0.55
y100 = £10 000 × 100 0.55 = £10 000 × 0.07943 = £794.30 selling price giving £79 430 for 100 units
y200 = £10 000 × 200 0.55 = £10 000 × 0.05425 = £542.50 selling price giving £108 500 for 200 units
y300 = £10 000 × 300 0.55 = £10 000 × 0.04341 = £434.10 selling price giving £130 233 for 300 units
y400 = £10 000 × 400 0.55 = £10 000 × 0.03706 = £370.60 selling price giving £148 240 for 400 units
y500 = £10 000 × 500 0.55 = £10 000 × 0.03278 = £327.80 selling price giving £163 900 for 500 units
Answers to questions for Chapter 25 Quantitative models for the planning and control of
stocks
68
Answer to question 25.2
(a) Item A32: storage and ordering cost schedule
No. of orders per year 4 5 6 7 8 9 10 11 12
Order size (boxes) 1250 1000 833 714 625 556 500 455 417
Average stock (boxes) 625 500 417 357 313 278 250 228 208
(b) The number of orders which should be placed in a year to minimize costs is 10.
(c)
EOQ 冪 冢2DO
H 冣
where D = total demand for period, O ordering cost per order, H holding cost per unit.
(d)
EOQ 冪 冢2 5000
0.5
12.5
冣
500 units
(e) The maximum saving that could be made if the authority process four orders per year would be:
£362.50 £250
31%
£362.50
(f) (i) Reducing the number of stock items by eliminating slow moving and obsolete stocks.
(ii) Standardization of stock items thus reducing the total number of items in stock.
where D annual demand, O ordering cost per order, H holding cost per unit. Therefore:
EOQ 冪 冢2 10%
48 000 £0.60
£10 冣
240
(ii) Number of orders required per year is:
annual requirements 48 000
200 orders per year
EOQ 240
69
Answer to question 25.4
(a) (i) The cost of sales expressed as a percentage of total sales is 100 Gross Margin %. Product A 58% (100 42%),
Product B 54%, Product C 63%.
(b) 1. Excessive stocks of item 14/363 are being held since stock exceeds the maximum stock level;
2. Stock is below the re-order level for item 11/175 and there are no outstanding orders. An order should have been
raised;
3. The order for item 14/243 has been placed too early since stock exceeds the re-order level.
EOQ 冪 冢 冣
2 50 000 100
0.40
5000
(b) (£)
Savings in purchase price (50 000 £0.02) 1000
Saving in ordering costa
DO DO 50 000 100 50 000 100
––– ––– = ––––––––––– ––––––––––– 500
Qd Q 10 000 5000
––––
Total savings 1500
––––
Note
a
Qd represents quantity ordered to obtain discount and Q represents EOQ. The additional holding cost if the larger
quantity is purchased is calculated as
follows:
As the total savings exceed the total cost increase, the company should take advantage of the quantity discount.
70
Answer to question 25.6
(a) Annual material costs are £9m (30% 3 £30m) and conversion costs are £7.5m (25% 3 £30m).
Current stock levels are: (£)
Raw materials (10% £9m) 900 000
Work in progress:
Materials element £1 350 000 (15% £9m)
Conversion cost 675 000 (15% £7.5 m 60%) 2 025 000
–––––––––
Finished goods:
Materials element £1 080 000 (12% £900 000)
Conversion cost 900 000 (12% £7.5m) 1 980 000
–––––––––
The stockholding costs for each category of stocks are as follows:
Existing Revised
Raw material stock: (£) (£)
Fixed holding and
acquisition costs 100 000 20 000
Variable holding and
acquisition costs 90 000 (10%) 12 600 (20% £900 000 £0.07)
Financial charges 180 000 (20%) 36 000 [20% (20% £900 000)]
––––––– ––––––
370 000 68 600
––––––– ––––––
Work in progress:
Fixed movement and
control costs 140 000 56 000 (40% £140 000)
Variable movement
and control costs 67 500 (5% £1.35 m) 8 100 [£0.03 (20% £1.35m)]
Financial charges 405 000 (20% £2025 m) 81 000 [20% (20% £2.025m)]
––––––– ––––––
612 500 145 100
––––––– ––––––
Finished goods:
Fixed holding and
control costs 180 000 72 000 (40% £180 000)
Variable holding
and control costs 39 600 (2% £1.98m) 4 950 [0.01 (25% £1.98m)]
Financial charges 396 000 (20% £1.98m) 99 000 [20% (25% £1.98m)]
––––––– ––––––
615 600 175 950
––––––– ––––––
(b) Possible reasons for the reduction in costs for each item of stock are as follows:
Raw material stock
(i) Reduction in insurance and clerical costs
(ii) Reduction in number of staff required
(iii) Savings arising from reduction in warehouse space
(iv) Reduction in materials handling cost
(v) Reduced financing costs
Work in progress
(i) Reduction in losses arising from moving WIP from one department to another
(ii) Reduction in materials handling equipment and staff
(iii) Savings or additional cash flows arising from reduced storage space
(iv) Reduced financing costs
Finished goods stock
(i) Reduction in insurance costs
(ii) Savings arising from reduction in warehouse space and staff
(iii) Reduction in finished goods handling costs
(iv) Reduced financing costs
(c) For just-in-time purchasing it is essential that reliable suppliers can be found who will deliver to match the company’s
production demands. Any later deliveries may result in stockout costs. Suppliers may increase purchase costs to
compensate for synchronizing their delivery and production schedules to the JIT production requirements of Prodco.
71
Alternatively, savings might arise from negotiating large long-term contracts with fewer suppliers. Dealing with fewer
suppliers should result in a significant reduction in administrative costs. The reduction in stocks should create excess
storage space which might be used to increase production capacity. Alternatively, it may be possible to sub-let the
space.
The move to a cell layout should enable the company to respond quickly to changes in sales demand or to meet
special orders. Thus additional sales might be generated. Additional training costs will be necessary to train the
workers to operate different types of machines and carry out routine maintenance. Set-up costs may increase as the
company moves from producing large batches using batch production techniques to producing small or single unit
batches using flow production techniques.
JIT manufacturing should reduce finished goods stocks since the aim is to produce the required quantities at the
precise time they are required. This should result in improved customer goodwill if production is more sensitive to
meeting customer delivery requirements. The reduction in finished goods stock requirements will create additional
storage space which might generate additional rental income from sub-letting.
With a re-order level of 150 000 units, the safety stock (buffer stock) is 27 000 units (150 000 – 123 000).
(b) The probability of a stockout (i.e. demand in excess of 150 000 units) is 0.15.
(c)
EOQ 冪 冤2 (6000 0.15 冥
240) 1000 138 564 units
Note that the expected daily demand of 6000 units is calculated as follows:
6000 240
10.39
138 564
(d) The additional annual holding cost if the re-order level is increased to 175 000 units is £3750 (25 000 £0.15).
At a re-order level of 150 000 units, the expected value of the stockouts per annum is 38 962 units.
Therefore the increase in stock is justified where the stockout cost per unit is greater than 9.6 pence (£3750/38 962
units).
(e) Many companies are now giving increasing attention to reducing stocks to a minimum by adopting just-in-time (JIT
purchasing and production techniques. For a description of JIT techniques you should refer to Chapter 22. The main
disadvantage of JIT purchasing is that a successful JIT philosophy depends on finding suppliers who can provide a
reliable delivery service at frequent intervals. With the absence of stocks, the system is dependent on a reliable service
being maintained with no delay in deliveries. JIT companies therefore become very dependent upon the reliability of
the supplier, and any failure by the latter to meet delivery schedules could have a serious impact on a whole
production process.
72
Answers to questions for Chapter 26 The application of linear programming to
management accounting
The above constraints are plotted on the graph shown in Figure Q26.2 as follows:
Processing hours: Line from W 300, B 0 to B 400, W 0
Materials: Line from W 500, B 0 to B 281, W 0
Labour hours: Line from W 275, B 0 to B 800, W 0
The feasible region is area ABCD. The objective function line drawn on the graph is based on an arbitrary selected con-
tribution of £6848 (the contribution if only 200 units of Product W is produced). This contribution can also be obtained
if just 242 units (£6848/£28.25 per unit) of Product B are produced.
If the contribution line is extended outwards the optimum point is B on the graph. At this point the output is 155
units of Product W and 194 units of Product B. The optimum point can be determined mathematically by solving the
simultaneous equations for the constraints that intersect at point B:
8W 14.25B 4000
4W 3B 1200
5
Units of Product B
1
C
D
0 1 2 3 4 5
Units of Product W
Objective junction
Z = 34.24W + 28.25B
Figure Q26.2
73
The values of W and B when the above equations are solved are 155 for W and 194 for B. This will yield a total contri-
bution of £10 788.
(b) The answer should also include the following points:
(i) Few production resources are entirely fixed in the short term apart from machine capacity. Steps can often be
taken to remove the constraints, such as obtaining materials from alternative sources or increasing machine
capacity by working longer hours;
(ii) A narrow focus has been adopted. Consideration should be given to increasing selling prices to the point where
demand is equal to maximum output arising from the current production considerations;
(iii) The approach ignores marketing considerations. Long-term profits might be maximized by concentrating pro-
duction on one of the products to capture a large market share so that market dominance can be established and
more substantial profits obtained;
(iv) Linear programming tends to focus on the short term whereas the emphasis should be on maximizing long-run
profits.
Note
a
The contribution should reflect the additional cash flow contribution from selling an extra roll. The material costs
given in the question represent sunk costs and are not relevant costs to be included in the contribution calculation. The
relevant cost of materials is the lost sales value of £1 per lb of wool or nylon (that is, 200 lb at £1 for private use and 250
£1 for commercial use).
The above constraints are plotted on the graph in Figure Q26.6 as follows:
Nylo
200
M
n 16
ac
hi
ne
0X +
Commercial (Y)
ry
30
150
X
50Y
+
36
Y
25 0
66
00
100
00
B
Woo
80 l4 0X +
C 200Y
24
000
50
0 D
Objective function line Z = £186 000 100 150 200 300
(arbitrarily chosen contribution figure) Private (X)
Figure Q26.6
74
Wool constraint: line from X 600, Y 0 to Y 120, X 0
Nylon constraint: line from X 156.25, Y 0 to Y 500, X 0
Capacity constraint: line from X 220, Y 0 to Y 183.33, X 0
At the optimum point (B in the graph) the output mix is 100 rolls for private use and 100 rolls for business use. The
optimum point can be determined mathematically by solving the simultaneous equations for the constraints that
intersect at point B:
30X 36Y 6 600
40X 200Y 24 000
The values of X and Y when the above equations are solved are 100 for and 100 for Y. The optimum output
requires 24 000 lb of wool to be used but only 21 000 lb of nylon. Therefore 4000 lb of nylon will be sold off at £1 per lb.
The total contribution for the quarter is:
(£)
Rolls for private use (100 £1600) 160 000
Rolls for commercial use (100 £1980) 198 000
Loss on sale of nylon [4000 (£2 £1)] (4 000)
–––––––
354 000
–––––––
The above calculation reflects the contribution that would be shown in the accounting statements using accrual
accounting. Alternatively, the contribution can be calculated using the relevant cost approach. This alternative contri-
bution calculation reflects the additional contribution over and above that which would be obtained from the alterna-
tive use of materials.
(b) If the variable costs increase then the contribution will decline by £110 for private sales and £40 for commercial sales.
The revised contribution will be:
Z 1750X 2490Y
You will find that the gradient of the revised objective function line is such that the optimal point remains unchanged,
and therefore the optimal output remains the same.
(c) The scarce resources are machine hours and wool. This is because these two constraints intersect at the optimum point
B. If an additional machine hour were obtained, the binding constraints would become:
The value of X and Y when the above equations are solved are 100.04 for X and 99.99 for Y. Therefore X increases by
0.04 rolls and Y decreases by 0.01 rolls, and the change in contribution will be as follows:
(£)
Increase in contribution of X (0.04 £1860) 74.40
Decrease in contribution of Y (0.01 £2530) 25.30
–––––
Increase in contribution 49.10
–––––
If an additional lb of wool were obtained, the optimal solution would change such that X should be decreased by 0.01
rolls and Y increased by 0.01 rolls. Contribution would increase by £6.70.
(d) The answer should stress the advantages of valuing variances at opportunity cost (i.e. relevant cost) rather than
acquisition cost. For a detailed explanation of the opportunity cost approach see ‘Variance analysis and the
opportunity cost of scarce resources’ in Chapter 19. The answer should also include a discussion of the limitation
placed on opportunity costs because of the limitations of linear programming. The limitations include:
(i) Linearity is assumed. In practice, stepped fixed costs might exist or resources might not be used at a constant rate
throughout the entire output range. Selling prices might have to be reduced to increase volume.
(ii) The output of the model is dependent on the accuracy of the estimates used. In practice, it is difficult to segregate
costs into their fixed and variable elements.
(iii) The objective function must be quantifiable and not of a qualitative nature.
(iv) Constraints are unlikely to be as completely fixed and precise as implied in the mathematical model. Some con-
straints can be removed at an additional cost.
75
Answer to question 26.3
(a) It is assumed that sales demand for Alpha is restricted to 200 units.
Maximize 400x1 200x2 300x3
Subject to: 2x1 3x2 2.5x3 1920 (Process 1)
3x1 2x2 2x3 2200 (Process 2)
x1 200 (Alpha sales)
x1, x2, x3
0 (Minimum sales constraint)
(b) x1 x2 x3
x4 1920 2 3 2.5
x5 2200 3 2 2
x6 200 1 0 0
Z 0 400 200 300
x3 x4 x6
x2 506.7 0.83 0.33 0.67
x5 586.7 0.33 0.67 1.67
x1 200 0 0 1
Z 181 333.3 66.67 66.67 266.7
In Chapter 26 the approach adopted was to formulate the first tableau with positive contribution signs and negative
signs for the slack variable equations. The optimal solution occurs when the signs in the contribution row are all
negative. The opposite procedure has been applied with the tableau presented in the question. Therefore the signs
have been reversed in the above tableau in order to ensure that it is in the same format as that presented in Chapter 26.
Note that an entry of 1 in the tableau presented in the question signifies the product or slack variable that is to be
entered in each row of the above tableau.
The total contribution is £181 333.3, consisting of 200 units of Alpha and 506.7 units of Beta. Process 1 (x4) is fully
utilized, but 586.7 hours (x5) of Process 2 are unused. There is no unused sales demand for Alpha. The Z row
(contribution row) indicates the shadow prices. The shadow price of £66.67 for Gamma (x3) indicates that contribution
will decline by £66.67 for each unit of Gamma produced. The shadow price of £66.67 for Process 1 (x4) indicates that for
each additional hour of Process 1 contribution would increase by £66.67. This would be achieved by increasing output
of Beta by 0.33 units, and the effect of this would be to reduce Process 2 capacity by 0.67 hrs. The shadow price of
£266.7 for Alpha (i.e. the slack variable) implies that for every Alpha sale above 200 units contribution would increase
by £266.7. In order to produce one unit of Alpha, output of Beta will be reduced by 0.67 units, thus releasing the 2 hrs
(0.67 3 hrs) required for Alpha in Process 1. This substitution process will result in a decline of 1.67 hrs in Process 2.
(d) The optimal responses are indicated in the final tableau:
(i) Increase output of Beta by 6.66 units (20 0.33) at a contribution of £200 per unit. Therefore total contribution
will increase by £1332 to £182 665.7. Alternatively, the change in contribution can be obtained by multiplying the
20 additional hours by the shadow price of £66.67.
(ii) This will increase total contribution by £2667 (10 units £266.7 shadow price). In order to produce an additional
unit of Alpha, the output of Beta must be reduced by 6.7 units (10 0.67). This will release 20 hours (6.7 units 3
hrs for Beta) in Process 1, which are required to produce the 10 units of Alpha (10 2 hrs). This substitution
process requires 16.7 Process 2 hours, and results in a £2667 increase in total contribution (10 units of Alpha at £400
per unit less 6.7 units of Beta at £200 per unit).
(iii) Total contribution will be reduced by £666.7 (10 units £66.7 shadow price). In order to obtain the hours required
to produce Gamma in Process 1, the output of Beta must be reduced by 8.3 units (0.83 10 units required for
Gamma). This will release 25 hrs (8.3 3 hrs) in Process 1, which is required to produce 10 units (10 2.5 hrs) of
Gamma. This substitution process will reduce Process 2 unused capacity by 3.3 hrs and reduce total contribution
by £666.7 (10 units of Gamma at £100 per unit less 8.3 units of Beta at £200 per unit).
76
The linear programming model is as follows:
Maximize x1 0.8x2 – 0.6x3 3x4 0.7x5
subject to
7x1 6x2 2x3 12 (time 0 cash available)
–1.5x1 – 2x2 – 4x3 8x4 x6 2 (time 1 cash available)a
–2x1 – x2 0.5x3 2x4 3x5 x7 1.08x6 (time 2 cash
available) b
–2x1 – x2 + 2x3 + x4 – x5 1.08x7 (time 3 cash
available)c
0.6x1 0.8x2 – 0.1x3 10
11 (year 1 profit constraint)d
0.6x1 0.3x2 – 0.2x3 – 0.3x4 12
(0.6x1 0.8x2 – 0.1x3 10)
1.1 (year 2 profit
constraint: year 1 profit
plus 10%)
1.4x1 0.8x2 – 0.3x3 – 0.2x4 1.5x5 11
(0.6x1 0.3x2 – 0.2x3 – 0.3x4
12) 1.1 (year 3 profit
constraint: year 2 profit
10%)
x1, x2, x3, x4, x5, x6, x7
0 (non-negativity
constraint)
x1, x2, x3, x4, x5 1 (maximum investment
constraint)
An alternative presentation is to transfer the negative items that are listed to the left of the sign to the right of the
sign. These variables will now be entered as positive items.
Notes (£m)
Time 1 cash available New equity
a
7.5
Less loan repayment 5.5
–––
2.0
–––
b
Time 2 cash available unused cash at time 1 plus interest.
c
Time 3 cash available unused cash at time 2 plus interest.
d
Minimum profit target £10m 10% £11m.
(b) It may be rational in the following circumstances to undertake a project with a negative NPV:
(i) Where the qualitative factors outweigh the negative NPV. For example, the building of a works canteen or the
provision of recreational facilities for employees.
(ii) A project with a negative NPV that provides large cash inflows in the early years, thus enabling an additional
project to be accepted with an NPV in excess of the negative NPV of the first project.
(c) Merits of mathematical programming
(i) Ability to solve complex problems incorporating the effects of complex interactions.
(ii) Speed in solving the problem using computer facilities.
(iii) The output from the model can highlight the key constraints to which attention should be directed.
(iv) Sensitivity analysis can be applied. The effects of changes in the variables can be speedily tested.
Limitations of mathematical programming
(i) Divisibility of projects may not be realistic and integer programming may have to be used.
(ii) Constraints are unlikely to be completely fixed and as precise as implied in the mathematical models.
(iii) Not all the relevant information can be quantified.
(iv) All the information for the model may not be available. For example, it may not be possible precisely to specify
the constraints of future periods.
(v) All the relationships contained within the formulation may not be linear.
(vi) All the potential investment opportunities may not be identified and included in the analysis.
(vii) The linear programming formulation assumes that all the project’s cash flows are certain and therefore it cannot
incorporate uncertainty. The solution produced can only be considered optimal given this restrictive as-
sumption.
77