My File
My File
CONTENT PROVIDER
Interactive Text
ACCA Approved
Interactive Text
Contact us
Foundations in Accountancy
BPP House MA2
March 2016
£20.00
1 / 113
FI22ST16 (POL).indd 1-3 09/03/2016 10:41
Contents
Chapter
2 / 113
Chapter (1)
Introduction to Cost Accounting
1. Definition of Cost Accounting
The establishment of budgets, standard costs and actual costs of operations, processes,
activities or product and the analysis of variances, profitability or the social use of funds.
3 / 113
1 Cost classifications in a cost accounting system
The total cost of making a product or providing a service consists of material costs, labour costs and
other expenses such as rent and rates.
The total cost of making a product or providing a service consists of the following.
(a) Cost of materials
(b) Cost of the wages and salaries (labour costs)
(c) Cost of other expenses
Rent and rates
Electricity and gas bills
Depreciation
A direct cost is a cost that can be traced in full to the product or service being costed.
An indirect cost (or overhead) is a cost that is incurred in the course of making a product or
providing a service, but which cannot be traced directly and in full to the product or service.
Prime cost = direct material cost + direct labour cost + direct expenses
Materials, labour costs and other expenses can be classified as either direct costs or indirect costs.
total expenditure may therefore be analysed as follows.
4 / 113
1.2.1 Production overhead
Production (or factory) overhead includes all indirect material cost, indirect wages and indirect expenses
incurred in the factory from receipt of an order for a product until the product’s completion, including:
(a) Indirect materials which cannot be traced in the finished product.
Consumable stores, eg material used in negligible amounts
(b) Indirect wages, meaning all wages not charged directly to a product.
Salaries of non-productive personnel in the production department, eg supervisor
(c) Indirect expenses (other than material and labour) not charged directly to production
(i) Rent, rates and insurance of a factory
(ii) Depreciation, fuel, power and maintenance of plant and buildings
2 Classification by function
Production costs
Direct materials A
Direct wages B
Direct expenses C
Prime cost A+B+C
Production overheads D
Full production cost A+B+C+D
Administration costs E
Selling and distribution costs F
Full cost of sales A+B+C+D+E+F
5 / 113
QUESTION Cost classification
Within the costing system of a manufacturing company the following types of expense are incurred.
Reference number
1 Cost of oils used to lubricate production machinery
2 Motor vehicle licences for lorries
3 Depreciation of factory plant and equipment
4 Cost of chemicals used in the laboratory
5 Commission paid to sales representatives
6 Salary of the secretary to the finance director
7 Trade discount given to customers
8 Holiday pay of machine operatives
9 Salary of security guard in raw material warehouse
10 Fees to advertising agency
11 Rent of finished goods warehouse
12 Salary of scientist in laboratory
13 Insurance of the company's premises
14 Salary of supervisor working in the factory
15 Cost of typewriter ribbons in the general office
16 Protective clothing for machine operatives
Required
Complete each expense in the correct cost classification.
4 Classification by behaviour
A different way of analysing and classifying costs is into fixed costs and variable costs. Many items of
expenditure are part-fixed and part-variable and hence are termed semi-fixed or semi-variable. This is
also known as classification by behaviour.
Costs can be classified according to how they vary in relation to the level of activity. This is known as
classification by behaviour.
A fixed cost is a cost which is incurred for a particular period of time and which, within certain
activity levels, is unaffected by changes in the level of activity.
A variable cost is a cost which tends to vary with the level of activity.
Examples of fixed and variable costs are as follows.
(a) Direct material costs are variable costs because they rise as more units of a product are
manufactured.
(b) Sales commission is often a fixed percentage of sales turnover, and so is a variable cost that
varies with the level of sales.
(c) Telephone call charges are likely to increase if the volume of business expands, and so they are a
variable overhead cost.
(d) The rental cost of business premises is a constant amount, at least within a stated time period,
and so it is a fixed cost.
Some items of expenditure are part-fixed and part-variable. In cost accounting, semi-fixed or semi-
variable costs may be divided into their fixed and variable elements.
6 / 113
Question (1)
Willis Ltd manufactures and distributes 2 products XL4 and DP2. The company has existed for 3 years, and
sales have risen steadily. Financial accounts have been produced at the end of each year. However it has now
been decided that a cost accounting system is also needed. This is a plan of the company:
supplier -> RM Purchase
RM -- 52 - a
Required packing
- 82
List the cost centres in Willis Ltd, giving reasons for your choice. P
packing
service
p
Question (2)
Prod
State which cost unit would be applicable to each of the following:
1. Goldmining costper grom/ounce
2. Restaurants cost per meal/curry/ table / person
3. Heavy goods transport cost perton/mile
4. Oil refining cost per litter/gallon
5. Nursing wards of a hospital cost per hr/night/day
6. Supply of gas costper litter/Lb/viss
7. Manufacture of ready mixed concrete costper cube metre
8. Consultant management accountant cost per hrl
contract
9. Sales invoicing costper invoice
10. Personnel and welfare cost per person
-
Question (3) v
Required
State suitable cost units to be used in the following business activities:
1 per
A college student / subject / course.
2 A house builder Lost per house room, building, squire feet.
3 A carpet manufacturer costper carpet/yard / feet.
-
7 / 113
Question (4)
Cathcart Limited, is a company which makes wooden toys.
Required
Classify each of the following costs into (a) direct / indirect (b) prime cost / overhead (c) function.
1. Wood, purchased to make toys. --
2. Paint and varnish, purchased for finishing the assembled toys.
3. Salary paid to the manager of the wood cutting department.
4. Petrol for a delivery lorry belonging to the company and used to deliver finished toys to cus-
tomers.
5. Power for operating wood-cutting machinery
6. Bank charges.
-
Question (5)
Aruwithit Ltd makes knitted garments for a variety of customers. Although the output level of the knitting
department changes frequently, it is the policy of the company to employ a constant number of knitters and
mechanics at all output levels.
The following expenses occur:
Reference No. Item
1. Depreciation of knitting machine used on a straight-line basis
2. Yarns and threads
3. Accountant's salary
-
8 / 113
Chapter (2)
Cost Behaviour
1. Introduction
The cost can be classified according to its behavioural characteristic as follows:
(i) Fixed Cost
(ii) Variable Cost
(iii) Semi Variable cost
(iv) Step fixed cost
2. Fixed Cost
- A cost which remain unchanged regardless of the level of activity within the relevant range.
- More in relation to time; Period cost.
- Example; Rent, Insurances, time based Depreciation etc.
- Chart showing total Fixed Cost (Factory Rent per month $2,000)
Cost($)
2000
* * * * * * *
Activity Level (Production Unit)
0 100 200 300 400 500 600
3. Variable Cost
- A cost which varies in direct proportion to the level of activity,
- Incurred per unit.
- Example; Direct material cost, Direct Labour cost, Direct expense etc.
- Chart showing total variable cost (direct material cost per unit $5)
Cost($)
2500
*
2000
*
1500
*
1000
*
500
* Activity Level (Production Unit)
0 100 200 300 400 500
9 / 113
4. Semi Variable Cost
- Semi-fixed cost, semi-variable cost, mixed cost
- Combination of fixed and variable cost
- Example; Internet charges, Electricity charges
- Chart showing Mixed Costs
1000
* * * *
500
*
100
*
Activity Level (Production Unit)
0 100 200 300 400 500
(c) Cost per service $5 per unit maximum $1000 per year.
Cost($)
1000
* * * *
500
*
Activity Level (Production Unit)
0 100 200 300 400 500
10 / 113
(d) Car Hire Charges $500 up to 300 mile. Additional charges $2 per mile over 300 miles.
Cost($)
1000
900
800
700
*
600
500
* Activity Level (Mile)
0 100 200 300 400 500
4000
3000
2000
1000
Activity Level
0 1000 2000 3000 4000 (Production Unit)
11 / 113
Question (1)
Required
(a) Analyse the six cost elements above into the following Four categories:
Variable
Fixed
Semi-variable
Step-Fixed
(b) Using the high-low method, analyse the semi-variable costs into variable and fixed components.
(c) Forecast the total manufacturing costs that would be incurred at an output of 2950 units.
Question (2)
Representative manufacturing costs for a company, for four different levels of output in a period, are as follows:
Required
(a) Analyse the seven cost elements above into the following Four categories:
Variable
Fixed
Semi-variable
Step-Fixed
(b) Using the high-low method, analyse the semi-variable costs into variable and fixed components.
(c) Forecast the total manufacturing costs that would be incurred at an output of 13,800 units.
12 / 113
Question (3)
Company A, which makes a single product, has the following data for the past four operating periods.
Period 6 Period 7 Period 8 Period 9
Production and sales (units) 14,500 12,400 16,800 15,250
Total operating costs $196,350 $187,500 $241,500 $251,850
General price-level index 110 125 138 146
Required
(a) Use the high-low method to:
(i) Analyse the total operating costs into a variable cost per unit and total fixed costs per period at
the Period 6 general price-level index. (5 marks)
(ii) Estimate the total operating costs expected in Period 10 if 18,120 units are produced and sold
the general price-level index is 155. (3 marks)
Question (4)
Alpha Limited has the following data for the maintenance of its plant for the past four operating periods:
Period 3 Period 4 Period 5 Period 6
Plant operation (hours) 8,500 7,750 10,250 9,800
Total plant maintenance costs $131,560 $127,050 $163,680 $160,440
Average price-level index 115 121 132 140
Required
(a) Use the high-low method to:
(i) analyse the total plant maintenance costs into a variable cost per hour and total fixed costs per
period at the Period 3 average price-level index. (5 marks)
(ii) estimate the total plant maintenance costs in Period 7, if the plant is operated for 10500 hours
and the average price-level index is 148. (3 marks)
13 / 113
Question (5)
Bosingwa Limited manufactures a single product, and has prepared the following budget for the next period:
14 / 113
Chapter (3)
Costing for Materials
The basic aim of inventory control is to minimise the cost associated with a firm’s investment in
inventory. These cost are as follows. -
BC D
(a)
(b)
Space cost
Personal cost
eye: .
E#
(c) Equipment cost
951494
(d) Interest charges
(e) Clerical cost
(f) Insurance & Security cost
(g) Evaporation & damage etc.
15 / 113
1 Types of material
Materials can be classified according to the substances that make them up, how they are measured, or
their physical properties.
Raw materials is a term which you are likely to come across often, both in your studies and your
workplace. But what are raw materials?
Examples of raw materials are as follows:
Clay for making terracotta garden pots
Timber for making dining room tables
Paper for making books
Raw materials are a direct cost of production as they are easily identifiable with a unit of production.
Work in progress means that some work has been done on the materials purchased as part of the
process of producing the finished product, but the production process is not complete. Examples of
work in progress are as follows.
(a) Terracotta pots which have been shaped, but which have not been fired, and are therefore
unfinished.
(b) Dining room tables which have been assembled, but have not been polished, and are therefore
not ready for sale.
(c) Paper which has been used to print books, but which has not yet been bound. The books are
therefore not yet assembled, and not yet ready for sale.
16 / 113
2 Buying materials
17 / 113
3 Valuing materials issues and inventories
Materials issued from inventory can be valued using FIFO, LIFO and weighted average methods.
18 / 113
4 Inventory control levels
Inventory control levels can be calculated in order to maintain inventories at the optimum level. The
three critical control levels are reorder level, minimum level and maximum level.
Maximum level = reorder level + reorder quantity – (minimum usage minimum lead time)
2C D
EOQ = 0
CH
where CH = cost of holding one unit of inventory for one time period
C0 = cost of ordering a consignment from a supplier
D = demand during the time period
Material account
20 / 113
Question (4)
prie?a obsess
Cost of material $5.00 per kg
demonsare
Order quantity (R&) 1,000 kgs
Annual inventory holding costs 12% of average inventory holding value
Required
~
Calculate for material P15:
(i) the reorder level in kg to ensure no inventory-outs occur
-
21 / 113
Question (5) ( April 2019 )
The supplier of Material TX47 has offered a 5% discount if Halimede Ltd increases the
size of its orders to 18 000 kg per order.
(d) Complete the table showing the costs of ordering in quantities of 3 000 kg and
18 000 kg.
(7)
$ $
Purchasing costs
Ordering costs
Holding costs
Total costs
22 / 113
Question (6)
A company has budgeted to use 2,400 units of component C10 in its production department during the
forthcoming year. Production will be distributed uniformly throughout the year.
The following information is available regarding component C10:
Cost of component P $25 each (before discount)
Ordering costs Co $100 per order
Inventory holding costs 29% 12% of the component cost per annum
-
The component can be purchased in order sizes of 200, 400, 800, 1,200 or 2,400 and it can be assumed that
the company carries no buffer (safety) inventory. ⑳
Required
(a) Produce a table showing the total annual ordering costs and the total annual inventory holding costs of the
component for each order size assuming no discount is received from the basic price. Identify the optimum
order size.
(b) Use the EOQ formula to verify your answer.
Assume that the supplier has offered the following quantity discounts:
Order size Discount from the basic $25 unit price
0 – 799 No discount
800 - 2,399 5% discount
2,400 and over 7% discount
Required
(c) Advise the company on the order size that minimise the total annual cost if the quantity discounts are
available. Support your advice with calculations.
(2008 Series 2)
23 / 113
Question(7)
D
Mbokani Ltd is budgeting to use 6 000 units of material LM55 during the year.
Order sizes available POS 500, 1 000, 1 500, 2 000 and 3 000 units
(a) (i) Complete the table to show the total annual ordering and inventory holding costs of material LM55
for each order size.
(6,000 = 12 )
500) (500x xil 500/2
+ =
(250x60] x 8%
500 12 times $6,000 250 unit $1200 $7200
1000 stimes $3,000 500 unit $2400 $5400
(ii) Identify the optimum order size that would minimise total cost. (1)
The supplier is now proposing to supply material LM55 only in quantities of 1 000, 2 000 or 3 000 units,
and is willing to offer the following quantity discounts.
Order size Discount
1 000 2.5% 97.5%
2 000 - 5% 95%
3 000 - 7.5% 92.5%
(b) (i) Complete the following table to show the annual costs for Mbokani Ltd if the above quantity
discounts are available.
Order quantity 1000 2000
600X 60x97.5;3,000x50x 95%)
3000
6,000x 60x92.5%
Purchase cost$(DXPrice) 351,000 342000333,000 S
Total $ 353,340348060340,360
24 / 113
Question (8)
Metis uses Material GX10 in its production processes.
The following information is available.
Monthly Current Order Current Minimum
Usage (B) Quantity RI Price P Inventory
Material GX10 12X10 000 kg 20 000 kg $7.00 kg 5 000 kg
12,000 kg
-
The holding costs are estimated to be $0.70 per kg. per unit
The ordering costs are estimated to be $500 per order. Co
-
(a) Calculate the current ordering costs for Material GX10 for one year.
-
(b) Calculate the current holding costs for Material GX10 for one year.
The current supplier of Material GX10 has offered a 2.5% discount if Metis increases the size of its orders to
60 000 kg.
(c) Complete the table to show the costs if Metis were to order in quantities of 20 000 kg and 60 000 kg.
(d) Advise Metis as to which order size it should use. Give one
- -
reason for your answer.
(e) Calculate the Economic
--
Order Quantity, showing clearly the formula used.
The accountant is concerned that if inventory is ordered in quantities of 60 000 kg, the insurance policy (which
only covers an average inventory holding of $250 000) might not provide enough cover.
(f ) (i) Calculate the average inventory values if orders are in quantities of:
• 20 000 kg
• 60 000 kg.
Pg(19)/8(4)
25 / 113
Chapter (4)
Costing for Labours
1 Labour costs
Labour costs can be determined according to some prior agreement, the amount of time worked or the
quantity or quality of work done.
Labour attendance time is recorded on an attendance record or a clockcard. Job time may be recorded
on daily time sheets, weekly time sheets, jobcards or route cards depending on the circumstances.
Human Resources
Timekeeping Production
department department
Hours Work
Basic pay
worked performed
Amount Amount
due to Payroll Costing chargeable
employee department department to
PAYE, NI product
etc
26 / 113
2.1 Basic pay
Levels of basic pay are ultimately decided by senior management who will take into account what other
employers are paying for similar work, what they consider the work to be worth, how easy it is to recruit
labour and any agreements with trade unions.
The basic pay due to an individual worker will be mentioned in his or her letter of appointment and
included in his or her contract of employment. The main on-going record, however, will probably be
kept on an employee record card held in the personnel department. This will also show subsequent
increases in the wage rate or salary level and much other information. An example of an employee
record card is shown below.
27 / 113
Much of the information on the employee record card is confidential and there is no need for staff in the
payroll department or the costing department to know about it.
Ideally, therefore, details of basic pay for all employees are compiled on separate lists which are given to
payroll and costing. A fresh list should be issued whenever the pay rates are revised.
In a computerised wage system, the basic rates are usually part of a database, and payroll and costing
are only able to access information that is relevant to their tasks. Costing, for example, does not need to
know the names of individual employees: in fact it is more efficient for workers to be coded according to
the department they work in and the type of work that they do.
28 / 113
If an employee is paid on the basis of the amount of time spent working, as opposed to the amount of
work done or the quality of that work, the attendance time information will be used by the payroll
department to work out how much to pay the employee.
29 / 113
(c) Job cards. Cards are prepared for each job or batch. When an employee works on a job he or she
records on the job card the time spent on that job. Job cards are therefore likely to contain
entries relating to numerous employees. On completion of the job it will contain a full record of
the times and quantities involved in the job or batch. A typical job card is shown as follows.
A job card will be given to the employee, showing the work to be done and the expected time it
should take. The employee will record the time started and time finished for each job. Breaks for
tea and lunch may be noted on the card, as standard times, by the production planning
department. The hours actually worked on each job and the cost of those hours will be calculated
by the accounting department.
(d) Piecework ticket/operation card. The wages of pieceworkers and the labour cost of work done by
them is determined from what is known as a piecework ticket or an operation card. The card
records the total number of items (or 'pieces') produced and the number of rejects. Because
workers are only paid for each item of ‘good’ production, independent of the number of hours
they have worked, it is crucial that they complete an operations card in order to get paid.
30 / 113
The attendance record of a pieceworker is required for calculations of holidays, sick pay and so
on.
(e) Route cards. These are similar to job cards, except that they follow the product through the
works and carry details of all operations to be carried out. They thus carry the cost of all
operations involved in a job and are very useful for control purposes.
The manual recording of times on time sheets or job cards is, however, liable to error or even deliberate
deception, and may be unreliable. A time clock or automated time recording system is more accurate.
Time sheets and job or route cards can take many different forms, some of which involve computerised
systems of time recording.
31 / 113
Service firms are chiefly in the business of selling the time and expertise of their employees to clients.
This means that if an employee spends an hour working for a particular client, the client will be billed
for one hour of the employee's time. A time sheet is necessary so that clients will be charged for the
correct amount of time that has been spent doing their work.
32 / 113
QUESTION-1 Labour costs of jobs
Below are shown some extracts from the files of Penny Lane Co. You are required to calculate the labour
cost of jobs 249 and 250.
Personnel files
George Paul Ringo John
Grade A B C D
Payroll - Master file
Grade Basic rate per hour
A $8.20
B $7.40
C $6.50
D $5.30
Production report - labour
Job Employee Hours
249 George 14
249 Paul 49
250 George 2
250 John 107
250 Ringo 74
2.5 Overtime
If an employee works for more hours than the basic daily requirement many organisations pay an extra
amount.
The overtime payment may simply be at the basic rate.
Usually, however, overtime is paid at a premium rate.
Solution
The most obvious way of calculating the amount earned is as follows.
$
Basic time (7 $5) 35.00
Overtime (11/4 $5) 6.25
Total pay 41.25
It is wrong, however, to say that the overtime premium is $6.25. For costing purposes all of the hours
worked, whether in basic time or outside it, are costed at the basic rate. The premium is the extra
amount paid on top of the basic rate for the hours worked over and above the basic hours.
$
Basic pay (8 $5) 40.00
Overtime premium (1/4 $5) 1.25
41.25
33 / 113
2.6 Incentives and bonuses
There are five main types of incentive scheme, piecework, time-saved bonus, discretionary bonus, group
bonus scheme and profit-sharing scheme.
Overtime premiums are paid to encourage staff to work longer hours than normal (or at least to
recognise and reward the personal sacrifice of doing so). Incentives and bonuses are paid to encourage
staff to work harder whatever the time of day.
Incentive schemes include the following:
Piecework
Time-saved bonus
Discretionary bonus
Group bonus scheme
Profit-sharing scheme
Piecework
Pieceworking can be seen as an incentive scheme since the more output you produce the more you are
paid.
Example: Piecework
An employee is paid $5 per piecework hour produced. In a 35 hour week he produces the following
output.
Piecework time allowed
per unit
3 units of product A 2.5 hours
5 units of product B 8.0 hours
Required
Calculate the employee's pay for the week.
Time-saved bonus
Example: time-saved bonus
In the garage example above, the bonus is 50c for every minute saved. During one afternoon the
engineer completes three MOTs in 48 minutes, 35 minutes, and 40 minutes respectively.
Required
Calculate the engineer's time-saved bonus.
34 / 113
3 Direct and indirect labour
Direct labour costs are the specific costs of the workforce used to make a unit of product or provide a
service. Indirect labour costs are all other labour costs: these are not directly attributable to the product
or service.
Remember that direct labour costs are the specific costs of the workforce used to make a unit of product
or provide a service. Indirect labour costs are all other labour costs that are not directly attributable to
the product or service.
4 Labour turnover
Labour turnover is the rate at which employees leave a company and this rate should be kept as low as
possible. The cost of labour turnover can be divided into preventative and replacement costs.
35 / 113
5 Measuring labour efficiency and utilisation
Idle time
We considered idle time earlier. A useful ratio for the control of idle time is the idle time ratio.
Idle hours
Idle time ratio = × 100
Total hours
Labour account
36 / 113
Chapter (5)
Costing for Overhead PC S.C
I
I 2 3
Ol products
Absorption costing is a method of sharing overheads between a number of different or
100 50 services
on a fair basis. It involves allocation, apportionment and absorption.. 30 20
Re:app. 18 2 (20)
1. Fig – Overview of costing treatment on overhead
Production Overhead
Incurred
- -
I A
Indirect : Allocation & Apportion Production Absorption Cost
Material Department OAR Unit
Labour
Expenses Service S P
-
Department Re-apportion I
agood on days
be is mys lis
-8 $0 -
ins 2. Allocation – is the charging of a whole item of cost to one cost center.
·Good mom mje
unbr3. Apportionment – is the sharing of overhead cost between two or more cost center.
6. Overhead Absorption
The means of attributing overhead to a product or services (cost unit) using appropriate absorption rate.
37 / 113
(b) Direct labour cost % OAR
38 / 113
Question (1)
CK Ltd is a manufacturing company. It has the following cost centres and manufacturing overhead costs.
Decide whether each overhead cost can be allocated or needs to be apportioned by ticking appropriate box.
Cost centres are: assembly, finishing, internal transport; machining; production scheduling, supervision.
Manufacturing Overhead Costs Allocated Apportioned
Depreciation of transport equipment
Factory rates
Coolant for machining lathes
Salary of production supervisor
Salaries of cost centre manager I 23
Cleaning materials eg. 8H
100 -
40 40 20
Protective clothings
20 30
50
Question (2) Basic of apportionment
OHCost Basis of Apportionment
Rent, rates Floor area / space occupied
Light, heat Floor area / space occupied
Power Kilowatt hours / capacity of machinery
Employee relate costs Number of employees / wages cost
Depreciation of plant and machineryNCA
-
NCA / age of machinery
Value of machinery
-
Question (3)
The following information is given related to overhead costs:
$
Machining Dept. 2,900
Finishing Dept. 4,800
Power 4,000
Rent 8,000
Canteen meal 4,000
The following additional information are given:
Area occupied Machining Dept. 2,500
-
sq.m
~yesemgu53no: Finishing Dept. 1,000
-
sq.m x
Canteen 500
-
sq.m -> S
Horsepower of machinery Machining Dept. 3,000
-
-
kh
&mins5sen: Finishing Dept. 1,000
-
- kh
Number of employees Machining Dept. 50
-
I. Reapportion.
39 / 113
Question (4)
The following information relates to QD Ltd:
Production Cost Centres
-
Services Cost Centres
Preparation
-
Finishing
-
Maintenance
Floor area (square meter) 30,000 112,500 7,500
No. of employees 10 35 5
Value of machinery ($'000) 200 1,800 -
The company wishes to allocates and apportion the following manufacturing overhead costs to its three cost
centres:
$'000 Allocated Apportioned
Maintenance manager's salary 16 M
Insurance
-
of:
Factory premises 5 M
-
Machinery 2 -
-
Required:
(i) To determine which costs can be allocated to cost centres and which need to be apportioned.
(ii) To prepare an overhead analysis statement in order to determined departmental overhead costs.
Question (5)
OS Ltd has four cost centres. The company wishes to allocate and apportion its manufacturing overhead costs
to these cost centres. The following information is available:
Grinding Polishing Stores Purchasing
Material requisitions raised 1,105 510 -- 85
No. of employees 40 50 7 3
Kg material transported 10,000 15,000 - -
Floor area (square meters) 4,500 3,000 2,000 500
Original cost of assets ($'000) 500 420 50 30
The following are the overhead costs which need to be allocated and apportioned:
$'000
Internal transport 50
Heat and light 20
General production management costs 40
Rent, rates and insurance 90
Supervisory salaries:
grinding department 20
polishing department 24
store 14
purchasing 17
Depreciation 45
Using appropriate apportionment bases (where relevant), prepare overhead analysis sheet for OS Ltd show-
ing the allocation and apportionment of overhead costs to cost centres.
40 / 113
Question (6)
$
Direct wages-related costs 150,000
Production manager's salary 30,000
Machine power costs 60,000
Machine cleaning costs 40,000
Set-up costs of knitting machinery 52,000
Heating and lighting 44,000
Supervisory salaries:
Knitting 20,000
stitching 23,000
finishing 22,000
maintenance 24,000
stores 20,000
Required
1. Prepare an overhead analysis sheet which allocates and apportions the above overheads to the various
cost centres, using appropriate apportionment bases where relevant.
Re-apportion the service department overhead costs to the production departments
2.
using the repeated distribution method, again using appropriate bases. Start your
reapportionment with the maintenance department.
41 / 113
Question (7)
Barlow & Dickinson Limited has 4 production departments (P1,P2,P3 and P4) and 2 service departments (S1
and S2).
An overhead distribution sheet has been started for the year ended 31 December Year 12 and after all
overhead has been allocated and apportioned, the results are:
P1 P2 P3 P4 S1 S2 Total
$ $ $ $ $ $ $
Alloc. & App. 183,146 94,025 72,334 210,496 40,000 30,000 630,000
The benefit given by each service department during the year has been analysed and found to be:
P1 P2 P3 P4 S1 S2
By S1 35% 10% 40% 10% - ↓ 5%
By S2 40% 5% 25% 15% 15% -
S
Required
Reapportionment on service department overhead to production departments using repeated distribution method.
Question (8)
Archer Limited makes a range of products in its machine shop.
A budget has been prepared for Year 12 like this:
$
Direct material DL rete 70,000
Direct labour at $5 per hour 80,000 C
Production overhead 112,000
Total Production cost 262,000
Budgeted direct labour hours 16,000
Budgeted machine hours 17,500
Budgeted Production units 675 unit
Required
(a) Calculate 6 different budgeted absorption rates for production overhead for Year 12.
-
(b) Calculate the production cost of job A & B which will be made in Year 12, using each of the absorption
rates.
The job details are: per unit Job A Job B
Materials $105 $200
Direct labour $120 $300
Direct labour hours 24 50
Machine hours 26.25 40
42 / 113
Question (9)
Rickaby Limited makes only 2 products, P and Q. The company has one production cost centre, X. Budgeted
production for Year 15 is to make 800 units of P and 1,200 units of Q. The following product information is
available:
P Q
Material cost per unit $250 $616.5
Direct labour hours per unit in cost centre X - Grade A 2 2
Grade B 8 16
Machine hours per unit in cost centre X -
8 14.25
The direct labour rates per hour in cost centre X will be $8.00 for Grade A labour and $10.50 for Grade B
labour.
Budgeted production overhead for Year 15 is $375,920 for cost centre X.
Required
(a) Calculate production overhead absorptions rates for Year 15 using the following alternative methods of
absorption:
1 Percentage on material cost
2 Percentage on direct labour cost
3 Percentage on prime cost
4 Direct labour hour rate
5 Machine hour rate
6 Production unit rate
43 / 113
Question (12) ( Jan 2020 )
Ferdinand Ltd has two production departments (Manufacturing and Packing) and
two service departments (Stores and Administration). Information for December 2019
is available.
$
Rent and rates 8 000
Machine depreciation 12 600
Stores salaries 4 700
Administration salaries 3 500
Heat, light and power 2 900
Other overheads 11 100
Information for each of the departments is available.
Manufacturing Packing Stores Administration
Floor area (square metres) 400 200 300 100
Machine value ($000) 775 185 40 -
Electricity usage (%) 45 20 10 25
Stores requisitions (number) 240 160 - -
Machine hours 1 500 300 - -
Direct labour hours 900 1 600 - -
Other overheads (allocated) 4 420 2 780 1 785 2 115
The company policy is to reapportion service department overheads to the
production departments, using the direct method, on the following bases.
Stores – number of stores requisitions.
Administration – 50% to each production department.
All calculations should be rounded to the nearest $.
(a) Complete the Overhead Distribution Table for Ferdinand Ltd.
44 / 113
Overhead Distribution Table
Departments
Total $
Expense Basis
$
Manufacturing Packing Stores Administration
45 / 113
Heat, light and power 2 900
Sub-total
Reapportionment
Stores overheads
Administration overheads
Total
(b) Calculate the overhead absorption rates for each of the Manufacturing and
Packing departments using an appropriate basis, giving each answer to the
(2)
The actual overheads and the number of machine and direct labour hours worked in
December 2019 were:
Manufacturing Packing
Actual overheads $30 300 $14 630
Machine hours 1 685 412
Labour hours 970 1 643
(c) Calculate the over absorption or under absorption of overheads for Ferdinand Ltd
for each of the Manufacturing and Packing departments.
(4)
Question (13)
Yewtree had already apportioned and allocated its overheads for March 2017 to its two production and two
service departments.
The following information is available for the four departments.
46 / 113
Human
Cutting Finishing Stores
Basis Resources
$ $ $
$
The actual overheads and the number of machine and direct labour hours worked during March 2017 were as
follows:
Cutting Finishing
Actual overheads $147 600 $105 200
Machine hours 2 610 195
Labour hours 1 645 3 420
(b) Calculate the over or under absorption of overheads for each of the Cutting and Finishing departments.
(Round your answers to the nearest $.) (4)
47 / 113
Non-production overheads
For internal reporting purposes and for organisations which base the selling prices of their products on
estimates of total cost, a total cost per unit of output may be required.
For external reporting (eg statutory accounts) it is not necessary to allocate non-production overheads to
products.
For internal reporting purposes and for organisations which base the selling price of their product on
estimates of total cost or even actual cost (such industries usually use a job costing system), a total cost
per unit of output may be required. Builders, law firms and garages often charge for their services by
adding a percentage profit margin to actual cost. For product pricing purposes and for internal
management reports it may therefore be appropriate to allocate non-production overheads to units of
output.
Research and development Consumer cost (= production cost minus cost of direct materials) or
added value (= sales value of product minus cost of bought in
materials and services)
Distribution Sales value
Triple Products Ltd manufactures three products Hay, Bee and Cee. At present the company uses a traditional
absorption costing system to establish the costs of production. Budgeted production data for the next period is
as follows:
Variable production overheads are budgeted to be absorbed at $3.50 per labour hour.
Fixed production overheads for the period are budgeted to be $66,000, absorbed on a machine hour basis.
Required
(a) Calculate the production cost of one unit of each product using:
(i) Traditional absorption costing
(ii) Activity based costing.
(b) Explain the meaning of the term cost driver. Your explanation should include two examples to illustrate
your answer.
49 / 113
Question (2)
Campbell and Martin Ltd makes three products.
At present, the company uses a traditional absorption costing system to establish the
costs of production.
The budget for the three products for Period 10 is shown below.
The company is now considering using activity based costing (ABC) to calculate
the production overhead costs of each product.
The following information for the production overhead costs for Period 10 is
shown below.
Activity Cost ($)
Machine set up 150 000
Product inspection 80 000
Machine maintenance 58 800
Product packaging 42 000
Material handling 40 000
You are given the following additional information for the period.
• Machine set up costs will be based on the number of orders:
Alpha 12 orders Beta 8 orders Delta 5 orders.
• Product inspection costs will be based on the number of production runs:
Alpha 24 Beta 16 Delta 10
• Machine maintenance will be based on the number of machine hours used.
• The packaging costs will be based on the number of crates per product.
Each product is packed in crates containing the following number of products
per crate:
Alpha 40 units Beta 50 units Delta 25 units.
• Material handling costs will be based on the total quantity of materials used.
(b) Calculate the production overhead cost (to two decimal places) for one unit of
each product, using activity based costing (ABC). (13)
(c) Explain two advantages of using activity based costing (ABC). (4)
50 / 113
Chapter (7)
Question (1)
Ash owns a business that manufactures dresses. The information relating to production in October
2018 was as follows.
Inventory on 1 October 2018 was 1 300 dresses.
The value of the inventory on 1 October 2018 was $8.00 per dress (marginal cost)
or $15.00 per dress (absorption cost).
• Direct materials were $8.40 per dress.
• There were 24 workers who were contracted to work 175 hours per month.
• The wage rate paid to these workers is $6.00 per hour.
• Bonuses were paid to workers at a rate of $1.25 per dress.
• Production overheads were $42 400
• Dresses were sold for $20.00 each.
• During October 2018, 8 000 dresses were produced and 7 600 were sold.
• The business uses the First In First Out (FIFO) method of inventory valuation.
(a) Define the following terms:
(i) marginal cost
(ii) absorption cost.
(b) Calculate the cost of producing one dress in October 2018 using:
(i) marginal costing
(ii) absorption costing.
(c) (i) Prepare a statement showing the profit for October 2018, in columnar format,using:
• marginal costing
(d) Explain why there is a difference between the marginal costing and absorption costing profit or loss
calculated in (c).
51 / 113
Question (2)
Sao Ltd owns a business that manufactures hats.
The information relating to production in March was as follows.
• Inventory on 1 March was 16 400 hats that were valued at:
$5.95 each using absorption costing or
$2.30 each using marginal costing.
• Direct materials were $2.25 per hat.
• Labourers are employed on a permanent basis.
• There were 32 labourers who each worked 175 hours in the month at a rate of
$10.00 per hour.
• Bonuses were also paid to labourers at $0.20 for every hat produced in the
factory.
• Production overheads were $84 000 in March.
• Hats were sold for $7.50 each.
• During March, 35 000 hats were produced and 31 800 were sold.
• The business uses the First In First Out (FIFO) method of inventory valuation.
(a) Define the following terms.
(i) Marginal cost
(c) Prepare a statement, for March, of profit or loss, in columnar format, using:
• marginal costing
• absorption costing.
(d) Explain why the profit using marginal costing is different from the profit using
absorption costing.
52 / 113
Question (3)
Tafazolli manufactures a single product.
The budgeted information for Period 4, based on producing and selling 24 000 units,
is shown below.
$
Direct materials 216 000
Direct labour 96 000
Production overheads – variable 38 400
Production overheads – fixed 182 400
Selling and administrative overheads – variable 14 400
Selling and administrative overheads – fixed 57 600
During Period 4 the actual production was 25 000 units and 22 000 units were sold at
$27 per unit.
Production overheads are absorbed using predetermined rates per unit.
The opening inventory was 3 250 units and the closing inventory was 6 250 units.
Actual variable costs per unit and fixed costs are as budget, both valued at the
budgeted unit cost for Period 4
(a) Prepare a profit statement for Period 4 based on:
(i) marginal costing
(ii) absorption costing.
(b) Explain why the profit figure using marginal costing is different to the profit figure
using absorption costing.
(c) Prepare a statement reconsiting the profit Calculated using absorption costing with
the profit Calculated using marginal costing.
53 / 113
Question (4)
Bowen and Pugh manufactures a single product that is sold for $180 per unit.
Details of the costs and revenues for Period 4 are shown below.
Variable costs (per unit) $
Direct material 40
Direct labour 30
Production overhead 18
Selling and distribution overhead 6
These variable costs have been the same for the previous two periods.
Fixed costs (per period) $
Production overheads 48 000
Selling and distribution overheads 30 000
Fixed production overheads are absorbed on the basis of 2 000 budgeted units of
production per period.
The actual activity for Period 4 was as follows:
Sales 2 000 units
Production 2 200 units
The opening inventory was 500 units.
(c) Explain the reason for the difference in the reported profit figure calculated using
absorption costing and the reported profit figure calculated using marginal
costing.
54 / 113
Chapter (8)
Cost Accounting System
55 / 113
4. Non-Integrated System (Inter Locking)
Financial Ledger Cost Ledger
Cash CLC A/c Cost Control Mat Inventory
x Pur: x Mat: Inventory x x
Wages x
OH x
Wages
Revenue x Wages x x
OH
OH x x
Costing Prft x
Revenue
x
56 / 113
Question (1)
The trial balance taken from the integrated ledger of Hillerest Limited on 1 April Year 7 showed:
$000 $000
Non Current Assets at cost 240
Accumulated depreciation 54
Raw material inventory 58
Work-in-progress inventory 17
Finished inventory 19
Trade Receivable and Trade Payable 130 65
Bank 8
Called up share capital 300
Profit and loss account 53
472 472
$000
At the end of the month:
1 Depreciation of Non Current Assets should be provided 2
(50% production, 50% administration, selling and distribution)
2 Inventory, valued at cost were
Work-in-progress 13
Finished inventory 16
Required
Open the accounts listed in the trial balance of Hillerest Limited at 1 April Year 7, insert the balance at that date,
post the transactions for the month of April and take out a trial balance at 30 April.
57 / 113
Question (2) ( Jan 2019 )
Irvine Hector Manufacturing Ltd operates an integrated accounting system and the
following information is available for Period 6.
Opening inventories
Work-in-progress 52 020
58 / 113
(a) Prepare the following for Period 6:
(i) raw materials account
(3)
Details $ Details $
Details $ Details $
Details $ Details $
59 / 113
(iv) production overheads account
(4)
Details $ Details $
Details $ Details $
(b) Explain two reasons for using control accounts when operating a non-integrated
accounting system.
(4)
60 / 113
Question (3) ( June 2019 )
$
Raw materials control 86 500
Work-in-progress 50 800
Finished goods control 58 520
Production overhead control (under absorbed) 5 360
Financial ledger control 201 180
The following transactions occurred during Period 3:
$
Purchases of raw materials 367 800
Direct materials issued 341 180
Indirect materials issued 19 540
Direct wages incurred 74 720
Indirect factory wages and salaries incurred 37 600
Other indirect manufacturing expenses 25 430
Production overheads absorbed 86 450
Finished goods completed 512 300
Production cost of sales 516 640
Sales 674 200
61 / 113
(a) Prepare the following cost ledger control accounts, balancing all accounts at the
end of Period 3.
(Use the space on page 5 for your workings.)
(i) Raw Materials Control Account
(2)
Details $ Details $
Details $ Details $
Details $ Details $
62 / 113
(iv) Work-in-progress Control Account.
(3)
Details $ Details $
Details $ Details $
Details $ Details $
63 / 113
Chapter (9)
Process Costing, Joint and by product costing
1. Definition (CIMA)
The costing method applicable where goods or services result from a sequence of continuous or
repetitive operations or process.
2. Examplec uban
Raw Material Output (FG)
Process 1 Process 2 Process 3
1,000 kg
Raw (1000kg) 5,000 Input (P1) 10,000 Input(P2) 20,000
Lab + OH Added Mat 5,000 Added Mat 10,000
(Conversion Conversion 5,000 Conversion 10,000
Cost) 5,000
10,000 20,000 40,000 -1,000 s
=$40 per kg
Cost Per Output 1 kg = $40,000 = $40 per kg
1,000 kg
3. Losses (Normal Loss, Abnormal Loss, Abnormal Gain)
Normal Loss - Expected Loss base input
Abnormal Loss - Actual Loss > Normal Loss
Abnormal Gain " - Actual Loss < Normal Loss
4. Equivalent Unit
Notional whole units representing uncompleted work. Used to apportion cost between work in pro-
cess and completed output, and in performance assessment.
Input. Expectedtoupt
Question (1) Normal (99 15% 85%
100
A limited manufactures a product whereby the initial raw material passes through two processes (Process One
and Process Two).
The output of Process One is passed to Process Two, where further raw material is added.
Direct costs and output for the month just ended were:
Process One
Initial raw material 3,800 kgs costing $200,000
Direct labour $ 145,210
Normal/Expected
Expected output 85% of input loss 15%an
Transfer to Process Two coutput) 3,150 kgs
impot
Process Two
Transfer from Process One - 3,150 kgs
Raw materials added -
2,850 kgs costing $287,500
Expected loss
Direct labour $ 89,690
inan
-
Pa
Overheads for the month totalled $ 420,800.
64 / 113
The overheads are apportioned between the two processes as follows:
Process One 55%
Process Two 45%
Losses that arise from the processes are sold for scrap. Losses that occur from Process One are sold for $ 20
per kg, whilst the losses that occur from Process Two are sold for $ 18 per kg.
Required
Prepare for the month just ended:
(a) Process One Account (6 marks)
(b) Process Two Account (6 marks)
(c) Normal Loss Account (4 marks)
(d) Abnormal Loss/Gain Account (4 marks)
(Specimen Paper)
(a) Prepare the process account for Caliban Ltd for December 2019
(b) Prepare the following ledger accounts:
is Normal loss aK (ii)
(c) Explain two differences between joint products and by-products.
Abnomelgaip All
65 / 113
Question (3) 2. 19.22 video
Larch manufactures chemicals and uses process costing. Information relating to the
inputs used in March 2017 was as follows:
Material A 1 300 litres costing X $8.00 per litre
Material B 700 litres costing $6.40 per litre
Material C 1 000 litres costing $7.50 per litre
ormal
10%
Direct labour 400 hours costing $9.30 per hour
Overheads Absorbed at a rate of $15.00 per direct labour [Link] expected output is 90% of material inputs.
Any losses can be sold at a value of $3.50 per litre. During March 2017, the amount of good output obtained
- -
(a) Calculate the cost per litre of the good output of chemicals.
-
A by-product is a product incidentally produced in the process of producing main products. It has a relatively
low sale value compared with main products.
2. Joint Product
Joint products are two or more products separated in processing, each having a sufficiently high
saleable value to merit recognition as a main product.
66 / 113
Question(4)
Prometheus Ltd manufactures three products – Aye, Bee and Cee – using a process costing system. A by-
product, Dee, is also produced by this process.
The inputs used in production in February 2019 were as follows:
Material Wye 9 000 kg at $7.50 per kg
Material Zed 7 000 kg at $5.75 per kg
Direct labour product)
(Main 1 250 hours at $8.00 per hour
Overheads are absorbed at a rate of $15.20 per labour hour.
The outputs from production in February 2019 were as follows:
Quantity Selling price
Product Aye 6 500 kg $40.00
Product Bee 3 200 kg $35.00
Product Cee 4 700 kg $20.00
Product Dee 1 000 kg $6.50
All waste material has no value but does need to be disposed of at a cost of $3.00 per kg.
Joint costs are apportioned between the main products on the basis of sales revenue.
(a) Prepare the Process Account for February 2019
(b) State two methods, other than sales revenue, that could have been used to apportion joint costs.
! " in
-
-
-
"I ->
C C 3
67 / 113
Question (5)
Triple Products Ltd uses a process system to jointly produce its three main products, (Product A,B and C)
Byproduct D is also produced during the process.
Information regarding the joint process for the last period is as follows:
Output
(a) Prepare the joint process account for the last period.
(b) Prepare the profit statement for the last period.
(c) Explain the meaning of:
(i) joint products
(ii) by-product.
68 / 113
Question (6)
A company uses a process system to jointly produce its three main products, Product A, B and C. By-product
D is also produced during the process. Each product contains two materials P and Q which are processed
together in the weight ratio of 3:2 respectfully.
Information regarding the joint process for the month of May is as follows:
-
Input
&
(ii) Assuming that all production was sold, prepare a profit statement for each of the main products, for the
month of May.
(b) Explain the difference between abnormal loss and abnormal gain.
69 / 113
Question (7)
Ingram and Bowler Ltd uses a process costing system to produce three main
products: Aye, Bee and Cee.
As a result of this process, a by-product Dee is also produced.
The production inputs for Month 6 are shown below.
Direct materials 4 500 kg at $8.50 per kg
Direct labour 4 125 hours at $7.60 per hour
Overheads are absorbed at a rate of $11.40 per direct labour hour.
Normal process losses (scrap) are 10% of inputs and are disposed of at a cost to the
company of $1.00 per kg.
The outputs arising from production in Month 6 are shown below.
70 / 113
Chapter (10)
Cost-Volume-Profit (CVP) Analysis
Cost-volume-profit (CVP) analysis is the study of the interrelationships between costs, volume and profit
at various levels of activity.
1.1 Introduction
The management of an organisation usually wishes to know the profit likely to be made if the aimed-for
production and sales for the year are achieved. Management may also be interested to know the
following.
(a) The breakeven point which is the activity level at which there is neither profit nor loss.
(b) The amount by which actual sales can fall below anticipated sales, without a loss being
incurred.
Fixed costs
Sales revenue at breakeven point =
C / S ratio
The C/S ratio is a measure of how much contribution is earned from each $1 of sales.
The margin of safety is the difference in units between the expected sales volume and the breakeven
sales volume and it is sometimes expressed as a percentage of the expected sales volume.
The margin of safety may also be expressed as the difference between the expected/actual sales revenue
and breakeven sales revenue, expressed as a percentage of the expected/actual sales revenue.
At the breakeven point, sales revenue = total costs and there is no profit. At the breakeven point, total
contribution = fixed costs.
71 / 113
Question (1)
Budgeted Profit Statement for a Period $
Revenue ($5 × 20,000 units) 100,000
Less: Total variable cost ($ 3 × 20,000 units) 60,000
Contribution per period 40,000
Less: Total fixed cost per period (20,000)
Profit per period 20,000
Required: Calculate
(1) Contribution per unit (CPU) (4) To get Target Profit $ 40, 000
(2) Contribution to sales ratio (C/S ratio) (a) Sale unit @ $5
(3) Break even point in (b) Sale value ($) @ $5
(a) Sale unit @ $5 (c) Selling price (at 20,000 unit sold)
(b) Sale value ($) @ $5 (5) Margin of safety
(c) Selling price (at 20,000 unit sold) (a) in unit
(b) in value ($)
(c) as a percentage of sales
Question (2)
72 / 113
↑
Question (3)
S. P
Sole Ltd manufactures and distributes a single product. The product sells for $ 160 per unit and the company
([Link])
expects total sales revenue in this current year of $ 800,000.
-
Required
(a) Calculate for the current year the :
(i) break-even point in units
(ii) contribution/sales ratio
(iii) margin of safety as a percentage of sales
(iv) expected profit
-
profl 144,000 -
73 / 113
Question (4)
Makit, a Family-owned business, manufactures and sells its single product at $16 per unit .The company ,
which currently has a monthly production capacity of 19,000 units, has orders for , and plans to sell,18,000
units in the next month .
The following information is a available:
Monthly costs for 16,000 units are estimated at $136,000
Monthly costs for 18,000 units are estimated at $148,000
The company only manufactures to sales orders received and keeps no inventory.
(a) Calculate for next month ,showing your workings, the estimated :
(i) variable cost per unit
(ii) contribution sales ratio
(iii) break-even revenue
(iv) net profit for the planned sales of 18000 units.
A mail-order company has approached Makit with the following two options:
1. 1,000 units at a price of $15 each. (or)
2. 2,000 units at a price of $14 each.
This order would be in additional to the sales orders already received by Makit and must be completed
during next month’s production.
S.P
Makit can increase its monthly manufacturing capacity to 2200 units by hirin;g additional equipment at a cost
of $ 10 000 per [Link] changes in variable costs are expected.
Semi-x)
(b) Explain ,showing supporting calculations for each option should be accepted. BSU
CUS↓ peramit
(c) One assumption in cost-volume-profit (CVP) analysis is that the variable cost per unit constant unit
3. isa per
$8.5
period
-
across the range of activity . Explain why this may not always apply.
-> $8.22
4.9C per
74 / 113
Question (5)
Lupus Ltd had reported its results for product Exe for August 2019.
$ $
Sales 502 200
Material costs (172 800)
Labour costs (212 400)
Overhead costs (148 200) (533 400)
Loss (31 200)
The company has been approached by a new overseas customer who is willing to
purchase 6 000 units per month at a price of $9.95 per unit.
This would be in addition to the 36 000 units currently being produced and sold.
(b) Calculate the total profit or loss that Lupus Ltd would make if the offer from the
new overseas customer to buy 6 000 units per month was accepted.
(c) Explain, giving one reason, whether Lupus Ltd should accept the offer from the
overseas customer.
All costs are expected to remain unchanged for the foreseeable future.
(d) Evaluate whether Lupus Ltd should continue producing product Exe.
75 / 113
Question (6)
$
Revenue (5000 x $10) 50,000
(-) Variable Cost (5000 x $5) 25,000
Contribution 25,000
Less: Fixed Cost (15,000)
Net Profit 10,000
Required: Prepare : (a) Traditional / conventional Break even chart
(b) Contribution Break even chart
(c) Profit Volume chart
Question ( 7)
$
Revenue (1000 x $5) 5,000
(-) Variable Cost (1000 x $2) (2,000)
Contribution 3,000
Less: Fixed Cost (1,000)
Net Profit 2,000
Required: Prepare : (a) Traditional / conventional Break even chart
(b) Contribution Break even chart
(c) Profit Volume chart
3 -
-
-
a
BPU/BS
.
X
76 / 113
Question (8) ( Jan 2020 )
Prospero Ltd produces a range of products including the JT44. Two budgets had been
produced for December 2019.
Budget 1 Budget 2
Units produced and sold 65 000 80 000
$ $
Revenue 611 000 752 000
Costs
Materials 182 000 224 000
Labour (note 1) 74 250 75 000
Heat, light and power (note 2) 22 500 24 000
Machine hire (note 3) 14 400 14 400
Production overheads (note 4) 162 600 166 350
Non-production overheads 223 450 223 450
Total costs 679 200 727 200
Net profit/(loss) (68 200) 24 800
Notes
1. Labour is a semi-variable cost. Employees are paid an output-related bonus of
$0.05 per unit and the rest is a fixed cost.
2. Heat, light and power is a semi-variable cost where the fixed element is $16 000
3. The company hires machines, each of which has a capacity of 30 000 units per
month.
4. Production overheads is a semi-variable cost.
(a) Calculate the:
(i) labour fixed cost
(ii) heat, light and power variable cost per unit
(iii) cost of hiring one machine
(iv) fixed and variable elements of the production overheads.
In December 2019, Prospero Ltd produced and sold 80 000 units of JT44
(b) Calculate, for December 2019, the break-even point in units and $.
(c) Calculate, for December 2019, the margin of safety in units and as a percentage
of sales. (2)
The directors of Prospero Ltd are considering replacing the JT44 with the FL26
Information about the FL26 is available.
110 000 units will be sold for $13.50 per unit.
Variable costs will be $5.30 per unit.
Fixed costs will be $767 520 per month.
77 / 113
(d) Prepare a break-even chart for the FL26 (on the graph paper provided) that shows:
• output from 0 to 110 000 units (6)
-
- YY
$20
78 / 113
Chapter (11)
Short-term Decision Making
1 Relevant costs
Relevant costs are future cash flows arising as a direct consequence of a decision.
Relevant costs are future costs, cashflows and incremental costs.
An opportunity cost The value of the benefit sacrificed when one course of action is chosen, in
preference to an alternative.
Costs that have been incurred include not only costs that have already been paid, but also costs
that have been committed. A committed cost is a future cash flow that will be incurred anyway,
regardless of the decision taken now.
Costs that have been incurred in the past are totally irrelevant to any decision that is being
made 'now'. Such costs are past costs or sunk costs.
Suppose for example that there are three options, A, B and C, only one of which can be chosen. The net
profit from each would be $80, $100 and $70 respectively.
Since only one option can be selected option B would be chosen because it offers the biggest benefit.
$
Profit from option B 100
Less opportunity cost (ie the benefit from the most
profitable alternative, A) 80
Differential benefit of option B 20
The decision to choose option B would not be taken simply because it offers a profit of $100, but
because it offers a differential profit of $20 in excess of the next best alternative.
Unless you are given an indication to the contrary, you should assume the following.
Variable costs will be relevant costs
Fixed costs are irrelevant to a decision
This need not be the case, however, and you should analyse variable and fixed cost data carefully. Do
not forget that 'fixed' costs may only be fixed in the short term.
80 / 113
1.6 The relevant cost of labour
The relevant cost of labour, in different situations, is best explained by means of an example.
(a) What is the relevant cost of labour if the labour must be hired from outside the organisation?
(b) What is the relevant cost of labour if LW Co expects to have 5 hours spare capacity?
(c) What is the relevant cost of labour if labour is in short supply?
2 Limiting factors
A limiting factor is a factor which limits the organisation's activities. In a limiting factor situation,
contribution will be maximised by earning the biggest possible contribution per unit of limiting factor.
One of the more common decision-making problems is a situation where there are not enough resources
to meet the potential sales demand, and so a decision has to be made about what mix of products to
produce, using what resources there are as effectively as possible.
A limiting factor is a factor which limits the organisation's activities.
Demand for next period will be 20,000 units. No inventories are held and only 75,000 kg of material
and 190,000 hours of labour will be available. What will be the limiting factor next period?
A Material only
B Labour only
C Material and labour
D There will be no limiting factor next period
81 / 113
Question (3)
A company has three products (Product A, Product B and Product C). Selling price and variable costs of the
products are as follows :
Product A Product B Product C
$ per unit $ per unit $ per unit
Selling price 6.00 9.00 4.60
Direct materials :
Material X 1.20 2.40 0.48
Other materials 0.60 1.00 0.52
Direct labour 1.50 2.40 1.20
Total fixed cost perperiod $ 12000
Maximum available supplies of Material X (costing $ 6.40 per kg) and hours of direct labour (paid at $ 8.00 per
hour) are expected to be 4,500 kg and 3,780 hours respectively in the following period. Other materials are freely
available.
Sales demand in the following period is expected to be :
Product A 8,000 units
Product B 6,000 units
Product C 5,400 units
Required
For the following period :
(a) Determine the limiting factor. Show calculations clearly and fully justify your conclusion. (7 marks)
(b) Prepare a production schedule with the objective of maximising profit. (9 marks)
(c) Calculate the each product, the total contribution and profit if the production schedule in your answer to
part (b) above is followed.
Henrikson Kingsley manufactures and sells four products that all use
raw material XYZ.
The company is currently preparing its production schedule for the next period.
The details for these four products are as follows:
82 / 113
Fixed overhead is $35 per unit and is calculated on the basis of the total sales
demand.
The sales demand, in units, for the forthcoming period is expected to be:
The raw material is in short supply and will be limited to 8 100 kg for the next period.
For the next period:
(a) (i) calculate the order of priority for production with the objective of
maximising contribution
(ii) prepare the optimum production schedule that will enable the company to
maximise profit
(iii) calculate the profit resulting from the production schedule you prepared
in a(ii)
(iv) calculate the break even in sales revenue assuming the product mix calculated
in part a(ii) above.
Qustion (5)
Maloney Weir Ltd manufactures and sells four products: Q , R , S , and T. The company is preparation its
production schedule for the next [Link] availability of direct labour will be limited to 32,000 hours for the
period.
The details for the four product are as follows:
Product Q Product R Product S Product T
Per unit $ $ $ $
Selling price 128 74 240 192
Direct material 24 18 42 30
Direct labour ($10 per hour) 40 20 80 60
Variable overheads 32 16 30 48
Fixed overheads 20 10 40 30
Sales demand ( units) 1500 2250 1875 1750
The fixed overhead per unit has been calculated on the basis of the sales demand for each product.
( a ) Calculate the order of priority for production in the period with the objective of maximising
contribution.
( b ) Prepare the optimum production schedule that will enable the company to maximise profit.
( c ) Calculate the profit resulting from the production schedule in ( b )
( d ) Explain the meaning of the following terms, giving an example of each
( i ) sunk cost
( ii ) differential / incremental costs.
83 / 113
3 Make/buy-in problems
In a make/buy-in problem with no limiting factors, the relevant costs for the decision are the differential
costs between the two options.
3.1 Introduction
A make/buy-in problem involves a decision by an organisation about whether it should make a
product/carry out an activity with its own internal resources, or whether it should pay another
organisation to make the product/carry out the activity. Examples of make/buy-in problems would be as
follows.
(a) Whether a company should manufacture its own components, or buy the components from an
outside supplier.
(b) Whether a construction company should do some work with its own employees, or whether it
should subcontract the work to another company.
Directly attributable fixed costs per annum and committed fixed costs are as follows.
$
Incurred as a direct consequence of making W 1,000
Incurred as a direct consequence of making X 5,000
Incurred as a direct consequence of making Y 6,000
Incurred as a direct consequence of making Z 8,000
Other fixed costs (committed) 30,000
50,000
A subcontractor has offered to supply units of W, X, Y and Z for $12, $21, $10 and $14 respectively.
Required
Decide whether Buster Co should make or buy-in the components.
84 / 113
Chapter (12)
Long-term Decision Making: Investment Appraisal
85 / 113
1 Introduction to capital investment appraisal
Long term investments include the purchase of buildings, machinery and equipment. Management will
need to have estimates of the initial investment and future costs and revenues of a project in order to
make any long term decisions.
Long term decisions generally involve looking at the options available when a company (or an
individual) puts money into an investment.
If a company invests in a project, it will expect some sort of financial return (or more money) at some
point in the future. If the project runs for a number of years then whether or not to invest in the project
will involve taking a long term decision.
One of the things companies will need to consider when investing in long term projects is the time value
of money.
Think about the following question.
'If I have $5 in my pocket now, how much will it be worth in four years' time?'
This is a difficult question to answer, but we will be looking at ways in which companies use the
concept of the time value of money when they are appraising projects and making long term decisions.
2 Interest
Interest is the amount of money which an investment earns over time. Simple interest is interest which
is earned in equal amounts every year assuming no change in the interest rate. If interest earned also
earns interest itself in later periods, this is known as compound interest.
If a sum of money is invested for a period of time, then the amount of simple interest which accrues is
equal to the number of periods the interest rate the amount invested. We can write this as a
formula.
The formula for simple interest is as follows.
S = P + nrP
where P = the original sum invested
r = the interest rate (expressed as a proportion, so 10% = 0.1)
n = the number of periods (normally years)
S = the sum invested after n periods, consisting of the original capital (P) plus interest
earned (future value)
86 / 113
2.2 Compound interest
Interest is normally calculated by means of compounding.
If a sum of money is invested and the interest earned each period is added to the investment, then the
interest earned in earlier periods will also earn interest in later periods.
The second year interest of $220 represents 10% of the original investment, and 10% of the
interest earned in the first year.
(b) Similarly, after three years, the total investment will be $2,662.
$
Investment at the end of two years 2,420
Interest in the third year (10%) 242
Total investment at the end of three years 2,662
Instead of performing the calculations shown above, we could have used the following formula.
n
The basic formula for compound interest is S = P(1 + r)
where P = the original sum invested
r = the interest rate, expressed as a proportion (so 5% = 0.05)
n = the number of periods (normally years)
S = the sum invested after n periods (future value)
You will need a scientific calculator with a power button ( x , y x or x y )
n
Using the formula for compound interest, S = P(1 + r)
where P = $2,000
r = 10% = 0.1
n = 3 3
S = $2,000 1.10
= $2,000 1.331
= $2,662
The interest earned over three years is $662, which is the same answer that was calculated in the
example above.
If today's date is 31 May 20X3, note the following timings of cash flows.
Time 0 = now (31 May 20X3)
Time 1 = one year's time (31 May 20X4)
Time 2 = two year's time (31 May 20X5)
87 / 113
Question (1) ( January 2019 )
Evandro Toral is considering whether to invest in one of two capital projects for a
period of four years.
The net cash flows for the two projects are as follows:
(a) Calculate for each of Project Exe and Project Whye the:
(i) Payback period
(ii) net present value
(iii) internal rate of return.
(iv) Discounted payback period
88 / 113
Question (2)
A Company is considering investing in a new machine to increase its capacity in order to manufacture a new
product. The machine would cost $1,600,000 with a residual value of $120,000 after its expected useful life
of five years.
The forecast for net operating cash inflows, for the product is as follows:
Year $000
1 600
2 840
3 1,220
4 900
5 330
The operation of the new machine will require an immediate additional investment in working capital of $360,000.
The working capital will be released at the end of the useful life of the machine.
If the new product is manufactured, the company will have to discontinue an existing product which makes an
annual contribution of $250,000.
The company’s cost of capital is 12% per annum.
Discount factors: Year 10% 12% 15% 18% 20%
1 0.909 0.893 0.870 0.847 0.833
2 0.826 0.797 0.756 0.718 0.694
3 0.751 0.712 0.658 0.609 0.579
4 0.683 0.636 0.572 0.516 0.482
5 0.621 0.567 0.497 0.437 0.402
Required
(a) Calculate in relation to the investment in the new machine, the:
(i) net present value (10 marks)
(ii) internal rate of return (3 marks)
(iii) discounted payback period. (4 marks)
(iv) Accounting rate of return (2011 Series 4)
89 / 113
Question (3)
A company is evaluating an investment project requiring an outlay of $1.4million on new machines (Year 0). The
machines would be expected to have a useful working life of six years, with a residual value of $80,000 (Year 6),
and would be depreciated on a straight line basis.
Estimates of cost savings (net of depreciation of the new machines) arising from the investment are:
Year $’000
1 20
2 50
3 to 6 80 per annum
The company’s cost of capital 5% per annum.
Required
(a) Calculate in relation to the investment project the:
(i) annual accounting rate of return;
(ii) payback period
(iii) net present value
(iv) discounted cash flow internal rate of return.
Discount factors:
Year 5% 10% 15%
1 0.952 0.909 0.870
2 0.907 0.826 0.756
3 0.864 0.751 0.658
4 0.823 0.683 0.572
5 0.784 0.621 0.497
6 0.746 0.564 0.432
(V) Profitability Index
90 / 113
Question (4)
A company is considering investing in new plant and equipment to introduce a new product with an estimated
lifespan of 5 years. The plant and equipment is expected to cost $2,150,000 with a residual value of $250,000
after five years.
The product is expected to have a constant contribution/sales ratio of 37.5% and budgeted annual incremental
fixed costs of $160,000 (excluding straight-line depreciation of new plant and equipment).
Assume that net cash inflows occur at the end of the years to which they relate.
Required
(a) Calculate in relation to the investment in new plant and equipment, the:
(i) accounting rate of return (using the average investment value); (8 marks)
(ii) net present value; (6 marks)
(iii) internal rate of return. (3 marks)
(iv) Discounted Paybak Period.
(b) Advise the company on whether the investment in new plant and equipment is worthwhile, on the
basis of the net present value and internal rate of return in part (a). (3 marks)
(2010 Series 4)
91 / 113
Chapter (13)
Budgeting
Purpose of Preparing Budget
- It is vital that business develop plans for the future.
- Whatever a business is trying to achieve, it is unlikely to come about unless its managemers are clear
what the future direction of the business is going to be.
- The development of plans involves five key steps.
- products or services.
-
-
w - Sale
v - Skilled labour
v - Production / Machine capacity
v - Working capital
92 / 113
Material Usage Material
Budget Purchase
Production Budget
Sales Budget Budget
Labour hour Labour
Budget Employment
Budget
1. Production Budget
(Unit)
Budgeted Sales Unit xx
(+) Closing Inventory of finished goods xx
(-) Opening Inventory of finished goods xx
Budgeted Production Unit xx
Production Cost Budget
( Budgeted prodn unit x Prodn cost per $x unit ) $xxx
93 / 113
Question (1)
A company manufactures and sells two products (Product P1 and Product P2). Budgeted costs for the next
period are:
Product P1 Product P2
$ per unit $ per unit
Raw materials
Material X 3.00 3.00 (at $ 6.00 per kg)
Material Y 2.72 4.76 (at $ 13.60 per kg)
---
Direct labour:
Grade 1 1.05 1.05 (at $ 10.50 per hour)
Grade 2 1.64 2.05 (at $ 8.20 per hour)
Production overheads 4.49 5.94
wat
Total production cost 12.90 16.80 Inventor
I ↑
The sales and inventory budgets for the next period have been agreed as follows:
Product P1 Product P2
Sales BSU 16,400 units 27,500 units
Required
Prepare the following budgets for the next period:
(a) Production (units of each product); (5 marks)
(b) Direct labour (hours and cost of each grade); (5 marks)
(c) Raw material usage (kgs of each material); (5 marks)
(d) Raw material purchases (kgs and cost of each material) (5 marks)
(2007 Series 4)
94 / 113
Question (2)
Dual Products Ltd manufactures and sells two products (Product Tee and Product Pee). The standard production
costs and selling prices, for the two products for Year 9, are as follows:
Budgeted production output for Year 9 is 15,000 units and 12,000 units for products Tee and Pee respectively.
Budgeted inventory of production units (valued at standard production cost) and inventory of direct materials
(kg) for Year 9 are as follows:
Direct operatives are on holiday for 4 out of the 52 weeks in the year. The basic normal working week is 40
hours but overtime is regularly worked by each operative. 20% of the total hours worked are budgeted as
overtime and paid for at a premium of 25% over the basic rate. Holiday pay and overtime premium costs are
included in production overheads.
Required
(d) Holiday pay and overtime premium (relating to direct labour) (4 marks)
(Total 20 marks)
( 2008 series 3 )
95 / 113
Question (3) ( September 2017 )
Tymon McGuire Ltd manufactures and sells three products, using two types of raw
material and two grades of labour.
The company is preparing its budgets for Period 3 and has provided the following
information.
Product Aye Product Bee Product Cee
Sales (units) 3 000 2 000 3 600
Direct materials per unit
Material Exe ($16.50 per kg) 2.5 kg 2.0 kg 3.0 kg
Material Whye ($24.50 per kg) 1.5 kg 2.1 kg 1.4 kg
Direct labour per unit
Skilled ($17.25 per hour) 1.2 hours 3.5 hours 2.5 hours
Unskilled ($12.50 per hour) 0.8 hours 1.5 hours 0.8 hours
Inventory holding Product Aye Product Bee Product Cee
Start of Period 575 units 550 units 680 units
End of Period 725 units 360 units 480 units
Inventory holding – materials Material Exe Material Whye
Start of period 3 400 kg 4 000 kg
End of period 4 450 kg 4 575 kg
(a) Prepare the following budgets for Period 3:
(i) production (units of each product)
(b) Explain two benefits, apart from dealing with overdrafts or cash surpluses, that a
company might obtain from preparing budgets.
(c) Identify two factors that might influence the company’s choice of budget period. (2)
96 / 113
Question (4)
Dual Products Ltd manufactures and sells two products (Product Tee and Pee). The sales budget for the next
period as follows :
Tee Pee
BSC 10,000 units 24,000 units
Inventory of finished goods, for both products, at the beginning of the budgeted period are expected to be
25% of the budgeted sales. Production is to be budgeted to increase the finished products, inventory by 10%
over the period.
Three raw materials (Material X, Y and Z) are used by the company in the manufacture of the two products,
in the following combinations:
unit ->JG.
Tee Pee DM usage per
Material X 0.20 kg 0.12 kg
Material Y 0.16 kg 0.18 kg
Material Z 0.24 kg 0.25 kg
A 20% weight loss of Material Y is expected during the manufacturing process. No weight loss is expected
with Material X or Z.
Inventory of raw materials at the beginning of the period are expected to be :
Material X 1,022 kg
Material Y 585 kg
Material Z 610 kg
Purchases of Material X are budgeted so that the inventory at the end of the period is expected to be sufficient
to manufacture 2,500 units of Product Tee and 6,000 units of Product Pee. No changes in the level of inventory
of Material Y or Z are to be budgeted.
Standard product costs are budgeted to be :
Raw material :
Material X $ 4 per kg
Material Y $ 3 per kg
Material Z $ 2 per kg
Direct labour :
Product Tee 0.50 hrs per unit at $ 8.00 per hour
Product Pee 0.25 hrs per unit at $ 8.00 per hour
Variable production overheads $ 2 per direct labour hour
Fixed production overheads for the period $ 25,000
Required
Prepare the following budgets for the next period:
(a) Production (units of each product) (4 marks)
(b) Material purchases of each material (kg) (11 marks)
(c) Production cost by cost element and in total (5 marks)
(Total 20 marks)
( 2009 series 4 )
97 / 113
Cash Budget
Question(1)
Ganymede Ltd is planning its cash flow for the three months April to June 2018, and the following budgeted
information is available.
• The company will have a bank overdraft of $14 360 on 1 April 2018.
• Sales and purchases will be as follows:
February March April May June
($) ($) ($) ($) ($)
Sales 27 100 29 400 30 300 28 600 26 200
Purchases 15 310 16 230 17 190 15 870 14 420
• 35% of the sales income will be received in the month following the sale and 62% will be received two
months after the sale. The remainder will be written off as an irrecoverable debt.
• Purchases will be on one month’s credit.
• Wages and salaries will be $2 720 per month, payable in the month in which they are incurred.
• Drawings of $1 800 will be taken out by the owner each month.
• Heat, light and power will be $390 per month and will be paid quarterly in February, May, August and
November.
• Other costs will be $1 200 per month plus a commission of 5% of sales. These will be payable in the
month in which they are incurred. Other costs do not include any depreciation.
• The company has non-current assets that cost $180 000 in August 2014, and are expected to have a
residual value of $30 000 at the end of their five-year useful life.
• Bank charges are 2.5% per month on any overdraft. These are applied to any overdrawn balance and
are charged in the following month.
(a) Prepare the cash budget for each of the three months April to June 2018. The budget should be in
columnar format and all figures should be calculated to the nearest $. (12)
(b) Explain two reasons why it is important for Ganymede Ltd to manage its cash flow efficiently. (4)
98 / 113
Question (2)
Sole Products Ltd, which buys and sells a single product, has prepared the following summarised budgeted
statement of profit & loss for the period January to April, Year 11.
January February March April
$’s $’s $’s $’s
Revenue 160,000 170,000 180,000 190,000
Cost of sales 96,000 102,000 108,000 114,000
Gross profit 64,000 68,000 72,000 76,000
Wages 17,600 19,800 22,000 24,200
Depreciation 6,000 6,000 6,000 6,000
Other overheads 22,000 22,500 23,000 24,000
Net Profit 18,400 19,700 21,000 21,800
The following additional information for the period is available:
(i) 10% of the sales are for cash; credit sales are paid in month after sales
(ii) Product purchases are paid for in the month following purchase
(iii) Inventory of product (at cost) is expected to be:
End of January $21,000
End of February $24,000
End of March $26,000
End of April $27,000
(iv) Wages are made up of a basic piece rate plus a 10% bonus. The basic piece rate wage is paid in the
month incurred and the bonus is paid the following month
(v) 60% of the other overheads are paid in the month they are incurred the remainder being paid
the following month
(vi) Capital expenditure of $35,000 and $20,000 is forecast for January and April
(vii) The following balances are expected at the beginning of January year 11.
Inventory of products $19,000
Trade Receivable $140,000
Trade Payable $80,000
Wages accrued $1,000
Overheads accrued $8,000
Bank $10,000 overdrawn
Required:
(a) Prepare the cash budget for each of the four months January to April, year 11. (16 marks)
(b) State two advantages of having a cash budget. (4 marks)
(Total 20 marks)
(2011/Series2)
99 / 113
Question (3) ( Dec 2020 )
Haisheng is planning his cash flow for the three months January to March 2021.
Information about his revenues and costs is available.
• Haisheng will have a bank balance of $5 284 on 1 January 2021.
• Sales and purchases will be as follows:
November December January February March
2020 2020 2021 2021 2021
$ $ $ $ $
Sales 51 200 58 300 56 100 48 700 46 300
Purchases 23 040 26 235 25 245 21 915 20 835
• 40% of the sales income will be received in the month following the sale and
58% will be received two months after the sale. The remainder will be written off
as an irrecoverable debt.
• Purchases will be made on one month’s credit.
• Inventory on 1 January 2021 will be $30 180 and on 31 March 2021 $32 630
• Wages and salaries will be $11 340 per month and other costs will be $1 875 per
month, both payable in the month in which they are incurred.
• Drawings of $4 500 will be taken each month.
• Heat, light and power will be $720 per month and will be paid quarterly in
February, May, August and November.
• Haisheng will buy a delivery van for $40 000 in January 2021 and will pay for it
immediately.
• Haisheng has non-current assets that were bought in October 2018 at a cost of
$57 000. These have a useful life of 5 years. Haisheng uses the straight line
method of depreciation.
• Bank charges are 2% per month when the business is overdrawn and are
calculated on the balance at the end of the previous month.
(a) Prepare the cash budget for each of the three months January to March 2021.
The budget should be in columnar format and all figures should be calculated to
the nearest $.
(b) State two internal actions that Haisheng could take to improve his cash flow
during the three months January to March 2021.
If a business does not manage its cash flow efficiently, it may have a bank balance
that is overdrawn.
(c) Explain two reasons why it is important for a business to manage its cash flow
efficiently.
100 / 113
Question (4)
Solar Products Ltd manufactures and sells a single product. The following information is also available for the
next 6 month period:
Revenue:
The budgeted sales, in units, are as follows:
Month July Aug Sept Oct Nov Dec
Sales (units) 240 260 270 280 280 270
The standard selling price is $50 per unit. 40% are expected to be cash sales with the remaining customers
allowed one month’s credit. It is estimated that 5% of credit customers will be bad debts.
Production:
The company manufactures 60% of the budgeted sales during the month before the sales and the remaining
40% in the month of sales.
Costs:
(i) Direct material will be $20 per unit of the finished product. Material will be purchased in the month
prior to their use in production and paid for in the following month.
(ii) Wages will be paid at the rate of $8 per unit of finished product, payable in the month of production.
A bonus payment of $4 per unit will be paid on all additional monthly production in excess of 250 units,
paid in the month following production.
(iii) Fixed production overheads of $18,000, including depreciation of $6,000, are budgeted for the year
ahead. These are budgeted to be the same each month and, apart from depreciation are payable in the
month they are incurred.
(iv) Variable selling expenses are expected to be $3 per unit payable in month they are incurred.
(v) Fixed administration overheads of $6,000 for the year ahead are budgeted to be same per month and
payable in the month they are incurred.
Cash:
The company expects to have a bank overdraft of $3,500 at the start of August.
Required:
Prepare the following budgets for each of the months August to October:
(a) Production (units) (3 marks)
(b) Material purchases ($’s) (2 marks)
(c) Labour cost (3 marks)
(d) Cash. (12 marks)
(Total 20 marks)
(2010/Series3)
101 / 113
Question (5)
A company has prepared the following summarised budgeted statement of profit & loss (by month) for a four
month period.
No inventory of finished goods is held. Budgeted beginning of month balances for current assets/liabilities
(excluding bank / cash) are:
Overheads include depreciation of $22,000 per month. Capital expenditure of $105,000 is budgeted in
Month 2.
Required
(a) Prepare a cash budget for each of the four months (1, 2, 3 and 4)
(b) Describe any actions that you would recommend in response to the cash budget.
(2003 Series 2)
102 / 113
Flexible Budget
Question (1)
Singular Ltd, which manufactures a single product, has prepared the following budget for the next period:
$ $
Sales revenue 172,800
Direct materials 43,200
Labour semi 39,000
Senni-v.C
Production overheads 44,500
Selling and distribution overhead 8,500
Administration overheads 10,000
Total costs 145,200
Profit 27,600
10800 und
90%
The following points have been revealed concerning the budget:
(1) The budget is based on 90% utilisation of maximum capacity. 100s??
(2) Direct material costs vary directly with output.
(3) Labour includes a fixed and a variable cost. The variable cost is $2.50 per unit.
(4) Production overheads include a fixed and variable cost. The variable cost varies directly with output
and the total overhead cost, at maximum capacity, is $46,900 unit
, (Iow
(5) Selling and distribution overheads include a fixed and variable cost. The variable cost varies direct with
output and the fixed element is $3,100. .
C?
(6) Administration overheads are fixed.
-
Required:
(a) Prepare flexed budgets for the period at:
(i) 100% utilisation of maximum capacity
(b)
(ii) 80% utilisation of maximum capacity.
cosso, 12,000 (15 marks)
Calculate for each of the three levels of output (i.e. 80%, 90% and 100% utilisation of maximum
capacity):
-
103 / 113
Question (2) HW
Mono Products maufactures a single product for the motoring industry and has prepared the following budget
for the next period:
Production / sale units 11,700
$ $
Sales revenue 187,200
Direct materials 46,800
Direct Labour 41,250
Production overheads 45,400
Selling and distribution overheads 8,600
Administration overheads 10,000
Total Costs 152,050
Profit 35,150
(a) Prepare a flexible budget for the period based on an 80% untilisation of maximum capcity . (13).
(b) State three benefits that a business would expect to gain from the use of budgetary planning. (3)
(c) Explain one difference between a fixed budget and a flexible budget. (2)
(2015 November)
104 / 113
Question (3) ( December 2019 )
Direct material
Direct labour
Production overhead
Administration overhead
(b) Explain one difference between a fixed budget and a flexible budget.
(2)
(c) Describe one benefit of using a flexible budget.
(2)
105 / 113
Question (4) ( June 2019 )
Irvine Mazuch Ltd manufactures a single product.
The company produced an original budget for a period based on sales and
production being 7 500 units.
The original budget was revised as the company expected to increase the sales
volume by lowering the selling price.
The supplier of direct material agreed to offer a discount based on increased
purchase volumes.
The original budget, the revised budget and the actual results for the period were as
follows.
Original Revised Actual
budget budget results
Sales and production (units) 7 500 8 250 8 700
$ $ $
Sales revenue 712 500 763 125 780 825
Cost elements
Direct material 234 000 251 550 272 000
Direct labour 97 500 107 250 115 900
Production overheads 83 000 86 750 89 950
Administration overheads 80 500 87 250 89 450
Selling overheads 58 710 63 135 63 590
Total costs 553 710 595 935 630 890
The following budgeted information is also provided.
• Each unit requires 10 kg of direct material.
• A 25% quantity discount was received on purchases of direct material over
75 000 kg for the period.
• The direct labour cost per unit increased by 40% for each unit over 8 500 units for
the period.
• The production overhead is a semi-variable cost, which at the maximum capacity
of 9 000 units is $90 500
• Administration overheads include a variable element of $9 per unit.
• Selling overheads include a fixed element of $14 460 for the period.
106 / 113
(a) Prepare the table showing the flexed budget for the actual output of 8 700 units,
and the relevant variances. You must state if the variance is favourable or adverse.
(Use the space below the table for your workings.)
(17)
$ $ $
Sales revenue
Direct material
Direct labour
Production overheads
Administration
overheads
Selling overheads
Total costs
(b) Explain the main difference between a fixed budget and a flexible budget. (2)
107 / 113
Chapter (14)
Standard Costing (Variances Analysis)
Question (1)
Messi Ltd operates a standard absorption costing system for its single product.
Budgeted data relating to the product for the period just ended was;
Question (2)
Folan Ltd operates a standard absorption costing system for the single product it manufactures.
The standard selling price of this product is $132 per unit
production and sales of 6000 units are budgeted for period 10.
The total manufacturing cost standards set for period 10 are as follows.
$ per unit
Direct materials (2.5 kilos x $ 16.90 per killo) 42.25
Direct labour (1.25 hours x $ 18.80 per hour) 23.50
Fixed production overhead (1.25 direct labour hours x $ 13.40 per hour) 16.75
The fixed production overheads are absorbed on the basis of direct labour hours.
Actual results for Period 10 were as follows:
Production 6,380units
Revenue (5,640 units) $810,750
Direct material, purchased and used (14,730 kilos) $279,870
Direct labour (8,535 hours) $153,630
Fixed production overhead $89,740
Opening and closing inventory of finishied goods are valued at the standard total manufacturing cost per unit for
period 10.
Required
(a) Calculate all variances as detail as possible.
(b) Prepare three reconciliation statement using the above variances in part (a).
108 / 113
Question (3)
Oak Ltd manufactures a single product using a standard absorption costing [Link] budgeted information
for June 2017 was as follows:
Bud/stal deter
7
Budgeted output 12 000 units BOU
Direct 45 000 kg at $3.80 per kg
Direct labour 16 800 hours at $9.00 per hour
Fixed production overheads $6.25 per unit
The actual results were as follows:
Actual output
Direct materials
Direct labour
-
-
10 760 units Pu -
Additional information
Oak Ltd was unable to obtain the usual grade of material because the supplier went out of business in June
2017. Oak Ltd was forced to buy materials from an alternative supplier.
(a) Explain the:
(i) term ideal standard (2)
(ii) possible implications of using ideal standards when calculating variances.(2)
(b) Calculate the following variances for June 2017:
(i) material price (2)
(c) Suggest one possible reason for each of thefollowingvariances, as calculated in (b):
July/2017
109 / 113
Question (4) ( September 2019 )
Oberon Ltd had the following information relating to the production of the CX22 for
August 2019.
Budget Actual
Direct labour 22 050 hours $264 600 22 540 hours $272 734
110 / 113
Question (5)
Sole Products produces a single product and uses a standard absorption costing system. The production
department budgets for the next period include the following:
Production output 800 units BOU
Direct labour per unit 4 hours @ $12 per hour
- -
(i) Expenditure
(ii) Volume
(iii) Volume capacity
(iv) Volume efficiency.
Management sets a production target for its 28 production-line staff of 40 units per
labour hour. Each worker is contracted to work 175 hours per month. per unil
-
-
4900 nu
During March 2019, 221 280 units of TZ25 were produced and a total of 4 760 labour
talud Aclud DL h
-
hours were worked. APU
hr per perica 4900
(c) Calculate, for March, the: Badgeleit
(i) standard hours for actual production Stax Chr x BP4
unit
-
0.025hr ??
-
111 / 113
Question (6)
A company had budgeted to produce and sell 3,000 units of its single product at a selling
price of $210 per unit in a period. Details of the standard cost per unit are as follows:
The following is a reconciliation of the budgeted gross profit with the actual gross profit for
the period:
$
Budgeted gross profit 189,000
Sales and cost variances: Favourable Adverse
$ $
Sales price 17,504
Sales volume profit 16,695
Direct material price 11,253
Direct material usage 7,232
Direct labour rate 4,707
Direct labour efficiency 4,536
Fixed overhead expenditure
Fixed overhead volume
2,503 Fav
Actual gross profit
Repuired
(b) Prepare a profit statement showing the actual sales, cost of sales and gross profit
for the period. (3 marks)
112 / 113
Question (7)
Retro Ltd makes a single product, using only one material. Standard costing is in operation and
the input to material stock records is at standard price as a result of calculating the material price
variance at the time of purchase.
The following production cost variances have been calculated for last month during which
7,500 units were produced and sold. Closing stock of raw material at the end of the month
was 50% up on the opening level.
$ $
Direct material -Price 2,355 Fav 875 Adv
Direct Labour -Rate 2,450 Adv E 3,200 Fav
Variable overhead -Expenditure 1,960 Adv E 960 Fav
Fixed overhead -Expenditure 1,350 Fav E 1,600 Fav
capacity 11,600 Adv
Required
Prepare the detailed standard production cost of a unit of product made of Retro Ltd.
113 / 113