Departmental Accounts: © The Institute of Chartered Accountants of India
Departmental Accounts: © The Institute of Chartered Accountants of India
Departmental Accounts: © The Institute of Chartered Accountants of India
BASIC CONCEPTS
Basis of Allocation of Common Expenditure among different
Departments
1. Expenses incurred specially for each department are charged
directly thereto, e.g., insurance charges of stock held by a
department.
2. Common expenses, the benefit of which is shared by all the departments
and which are capable of precise allocation are distributed among the
departments concerned on some equitable basis considered suitable in the
circumstances of the case.
S.No. Expenses Basis
1. Rent, rates and taxes, repairs and Floor area occupied by each
maintenance, insurance of department (if given) other
building wise on time basis
2. Lighting and Heating expenses Consumption of energy by
(eg. energy expenses) each department
3. Selling expenses, e.g., discount, bad Sales of each department
debts, selling commission, freight
outward, travelling sales manager’s
salary and other costs
4. Carriage inward/ Discount Purchases of each department
received
5. Wages/Salaries Time devoted to each
department
6. Depreciation, insurance , repairs Value of assets of each
and maintenance of capital assets department otherwise on time
basis
7. Administrative and other Time basis or equally among
expenses, e.g., salaries of all departments
managers, directors, common
advertisement expenses, etc.
8. Labour welfare expenses Number of employees in each
department
9. PF/ESI contributions Wages and salaries of each
department
Question 1
Department X sells goods to Department Y at a profit of 25% on cost and to Department Z at
10% profit on cost. Department Y sells goods to X and Z at a profit of 15% and 20% on sales,
respectively. Department Z charges 20% and 25% profit on cost to Department X and Y,
respectively.
Department Managers are entitled to 10% commission on net profit subject to unrealised profit
on departmental sales being eliminated. Departmental profits after charging Managers’
commission, but before adjustment of unrealised profit are as under:
`
Department X 36,000
Department Y 27,000
Department Z 18,000
Stock lying at different departments at the end of the year are as under:
Dept. X Dept. Y Dept. Z
` ` `
Transfer from Department X — 15,000 11,000
Transfer from Department Y 14,000 — 12,000
Transfer from Department Z 6,000 5,000 —
Find out the correct departmental Profits after charging Managers’ commission
Answer
Calculation of correct Profit
Department Department Department
X Y Z
` ` `
Profit after charging managers’ commission 36,000 27,000 18,000
Add back : Managers’ commission (1/9) 4,000 3,000 2,000
40,000 30,000 20,000
Answer
Calculation of unrealized profit of each department and total unrealized profit
Dept. A Dept. B Dept. C Total
` ` ` `
Unrealized Profit of:
Department A 45,000 x 50/150 42,000 x 20/120
= 15,000 = 7,000 22,000
Department B 40,000 x .25 = 72,000 x .15=
10,000 10,800 20,800
Department C 39,000 x 30/130 42,000 x 40/140
= 9,000 = 12,000 21,000
63,800
Question 3
FGH Ltd. has three departments I, J and K. The following information is provided for the year
ended 31.3.2012:
I J K
` ` `
Opening stock 5,000 8,000 19,000
Opening reserve for unrealised profit ― 2,000 3,000
Materials consumed 16,000 20,000 ―
Direct labour 9,000 10,000 ―
Closing stock 5,000 20,000 5,000
Sales ― ― 80,000
Area occupied (sq. mtr.) 2,500 1,500 1,000
No. of employees 30 20 10
Stocks of each department are valued at costs to the department concerned. Stocks of I are
transferred to J at cost plus 20% and stocks of J are transferred to K at a gross profit of 20%
on sales. Other common expenses are salaries and staff welfare ` 18,000, rent ` 6,000.
Prepare Departmental Trading, Profit and Loss Account for the year ending 31.3.2012
Answer
FGH Ltd.
Departmental Trading and Profit and Loss Account
for the year ended 31st March, 2012
I J K Total I J K Total
` ` ` ` ` ` ` `
To Opening 5,000 8,000 19,000 32,000 By Sales 80,000 80,000
stock
To Material By Inter-
consumed 16,000 20,000 36,000 departmental
To Direct labour 9,000 10,000 19,000 transfer 30,000 60,000 90,000
To Inter- By Closing
departmental stock 5,000 20,000 5,000 30,000
transfer 30,000 60,000 90,000
To Gross profit 5,000 12,000 6,000 23,000 ______ ______ ______ _______
35,000 80,000 85,000 2,00,000 35,000 80,000 85,000 2,00,000
To Salaries and By Gross profit
staff welfare 9,000 6,000 3,000 18,000 b/d 5,000 12,000 6,000 23,000
By Net loss 7,000 7,000
To Rent 3,000 1,800 1,200 6,000
To Net profit _____ 4,200 1,800 6,000 _____ _____ _____ _____
12,000 12,000 6,000 30,000 12,000 12,000 6,000 30,000
To Net loss (I) 7,000 By Stock
To Stock reserve b/d
reserve (J + K) 5,000
(J+K)
(Refer 3,000 By Net profit (J 6,000
W.N.) + K)
To Balance
transferred
to profit and
loss account 1,000 _____
11,000 11,000
Department X Department Y
` `
Opening stock (at cost) 80,000 48,000
Purchases 3,68,000 2,72,000
Carriage inward 8,000 8,000
Wages 48,000 32,000
Sales 5,60,000 4,48,000
Purchased goods transferred
By department Y to X 40,000 -
By department X to Y - 32,000
Finished goods transferred
By department Y to X 1,40,000 -
By department X to Y - 1,60,000
Return of finished goods
By department Y to X 40,000 -
By department X to Y - 28,000
Closing stock
Purchased goods 18,000 24,000
Finished goods 96,000 56,000
Purchased goods have been transferred mutually at their respective departmental purchase
cost and finished goods at departmental market price and that 25% of the closing finished
stock with each department represents finished goods received from the other department.
Answer
Departmental Trading Account in the books of Siva Ltd.
for the year ended 31st March 2012
Particulars Departmen Department Particulars Department Department
tX Y X Y
` ` ` `
To Opening stock 80,000 48,000 By Sales 5,60,000 4,48,000
To Purchases 3,68,000 2,72,000 By Transfers:
To Carriage inward 8,000 8,000 Purchased goods 32,000 40,000
To Wages 48,000 32,000 Finished goods 1,20,000 1,12,000*
To Transfers: By Closing stock:
Net transfers of finished goods by
Department X to Y = ` 1,60,000 – ` 40,000 = ` 1,20,000
Department Y to X = ` 1,40,000 – ` 28,000= ` 1,12,000
Working Notes:
(1) Profit Margin Ratio
Selling price of unit purchased: `
Department A 6,000 x 40 2,40,000
Department B 12,000 x 45 5,40,000
Department C 14,400 x 50 7,20,000
Total Selling Price 15,00,000
Less: Purchase (Cost) Value (6,00,000)
Gross Profit 9,00,000
9,00,000
Profit Margin Ratio = 100 = 60%
15,00,000
(2) Statement showing department-wise per unit Cost and Purchase Cost
A B C
` ` `
Selling Price (Per unit) (`) 40 45 50
Less: Profit Margin @ 60% (`) Profit (24) (27) (30)
Margin is uniform for all depts at 60%
Purchase price per unit (`) 16 18 20
Number of units purchased 6,000 12,000 14,400
(Purchase cost per unit x Units purchased) 96,000 2,16,000 2,88,000
(3) Statement showing calculation of department-wise Opening Stock (in Units)
A B C
Sales (Units) 6,120 11,520 14,976
Add: Closing Stock (Units) 600 960 36
6,720 12,480 15,012
Less: Purchases (units) (6,000) (12,000) (14,400)
Opening Stock (Units) 720 480 612
(4) Statement showing department-wise cost of Opening Stock and Closing Stock
A B C
Cost of Opening Stock (`) 720 x 16 480 x 18 612 x 20
` 11,520 8,640 12,240
Cost of Closing Stock 600 x 16 960 x 18 36 x 20
` 9,600 17,280 720
Question 6
Goods are transferred from Department P to Department Q at a price 50% above cost. If
closing stock of Department Q is ` 27,000, compute the amount of stock reserve.
Answer
`
Closing Stock of Department Q 27,000
Goods send by Department P to Department Q at a price 50% above
cost
27,000× 50 9,000
Hence profit of Department P included in the stock will be - =
150
Amount of the Stock Reserve will be ` 9,000.
Working Note:
Dept P transfers goods to Dept Q at a profit of 50% of cost. Hence, if cost is ` 100/- the profit
= ` 50 and Transfer Price = ` 150. Therefore, the profit of Dept P included in the stock value
of Dept Q is one – third of the sale value
Question 7
Department R sells goods to Department S at a profit of 25% on cost and Department T at
10% profit on cost. Department S sells goods to R and T at a profit of 15% and 20% on sales
respectively. Department T charges 20% and 25% profit on cost to Department R and S
respectively.
Department managers are entitled to 10% commission on net profit subject to unrealized profit
on departmental sales being eliminated. Departmental profits after charging manager’s
commission, but before adjustment of unrealized profit are as under:
`
Department R 54,000
Department S 40,500
Department T 27,000
Stock lying at different departments at the end of the year are as under:
Deptt. R Deptt. S Deptt. T
` ` `
Transfer from Department R - 22,500 16,500
Transfer from Department S 21,000 - 18,000
Transfer from Department T 9,000 7,500 -
Find out the correct departmental profits after charging manager’s commission.
Answer
Departments
R S T
` ` `
Profit before adjustment of unrealized profits 54,000 40,500 27,000
Add : Managerial commission (1/9) 6,000 4,500 3,000
60,000 45,000 30,000
Less: Unrealised profit on stock (Refer W.N.) (6,000) (6,750) (3,000)
54,000 38,250 27,000
Less: Managers’ commission @ 10% (5,400) (3,825) (2,700)
Profit after adjustment of unrealized profits 48,600 34,425 24,300
Working Notes:
Value of unrealised profit
`
Transfer by department R to
S department (22,500 25/125) = 4,500
T department (16,500 10/110) = 1,500 6,000
Transfer by department S to
R department (21,000 15/100) = 3,150
T department (18,000 20/100) = 3,600 6,750
Transfer by department T to
R department (9,000 20/120) = 1,500
S department (7,500 25/125) = 1,500 3,000
Answer
1. Calculation of Departmental Results (Actual Gross Profit):
A (`) B (`) C (`)
Actual Sales 1,72,500 1,59,400 74,600
Add back: Discount (Refer W.N.) 2,500 600 400
Normal sale 1,75,000 1,60,000 75,000
Gross profit % on normal sales 20% 25% 33.33%
Normal gross profit 35,000 40,000 25,000
Less: Discount (2,500) (600) (400)
Actual gross profit 32,500 39,400 24,600
2. Computation of value of stock as on 31st Dec. 2012
Departments A B C
` ` `
Stock (on 1.1. 2012) 24,000 36,000 12,000
Add: Purchases 1,46,000 1,24,000 48,000
1,70,000 1,60,000 60,000
Add: Actual gross profit 32,500 39,400 24,600
2,02,500 1,99,400 84,600
Less: Actual Sales (1,72,500) (1,59,400) (74,600)
Closing stock as on 31.12.2012 (bal.fig.) 30,000 40,000 10,000
Working Note:
Calculation of discount on sales:
Departments A B C
` ` `
Sales at normal price 10,000 3,000 1,000
Less: Sales at actual price (7,500) (2,400) (600)
2,500 600 400
Question 9
Brahma Limited has three departments and submits the following information for the year
ending on 31st March, 2012:
(2) Statement showing department-wise per unit cost and purchase cost
Particulars A B C
Selling price per unit (`) 40 45 50
Less: Profit margin @ 40% (`) Profit (16) (18) (20)
margin is uniform for all depts.
Purchase price per unit (`) 24 27 30
No. of units purchased 5,000 10,000 15,000
Purchases (purchase cost per unit x 1,20,000 2,70,000 4,50,000
units purchased)
(3) Statement showing calculation of department-wise Opening Stock (in units)
Particulars A B C
Sales (Units) 5,200 9,800 15,300
Add: Closing Stock (Units) 400 600 700
5,600 10,400 16,000
Less: Purchases (Units) (5,000) (10,000) (15,000)
Opening Stock (Units) 600 400 1,000
(4) Statement showing department-wise cost of Opening and Closing Stock
Particulars A B C
Cost of Opening Stock (`) 600 х 24 400 х 27 1,000 х 30
14,400 10,800 30,000
Cost of Closing Stock (`) 400 х 24 600 х 27 700 х 30
9,600 16,200 21,000
Question 10
M/s. AM Enterprise had two departments, Cloth and Readymade Clothes. The readymade clothes
were made by the firm itself out of the cloth supplied by the Cloth Department at its usual selling
price. From the following figures, prepare Departmental Trading and Profit & Loss Account for the
year ended 31st March, 2012:
Cloth Readymade Clothes
Department Department
` `
Opening stock on 1st April, 2011 31,50,000 5,32,000
Purchases 2,10,00,000 1,68,000
Sales 2,31,00,000 47,25,000
Transfer to Readymade Clothes Department 31,50,000 -
Manufacturing expenses - 6,30,000
Working Note:
Calculation of Stock Reserve
Gross Pr ofit
Rate of Gross Profit of Cloth Department, for the year 2011-12 = x 100
Total Sales
` 42,00,000 100
100 = 16%
` 2,31,00,000 31,50,000
Closing Stock of cloth in Readymade Clothes Department = 75%
i.e. ` 6,72,000 x 75% = ` 5,04,000
Stock Reserve required for unrealized profit @ 16% on closing stock
` 5,04,000 x 16% = ` 80,640
Stock reserve for unrealized profit included in opening stock of readymade clothes
@ 15% i.e.
(` 5,32,000 x 75% x 15%) = ` 59,850
Additional Stock Reserve required during the year = ` 80,640 – ` 59,850 = ` 20,790.
Question 11
Martis Ltd. has several departments. Goods supplied to each department are debited to a
Memorandum Departmental Stock Account at cost, plus a fixed percentage (mark-up) to give the
normal selling price. The mark-up is credited to a memorandum departmental 'Mark-up account',
any reduction in selling prices (mark-down) will require adjustment in the stock account and in
mark-up account. The mark up for Department A for the last three years has been 25%. Figures
relevant to Department A for the year ended 31st March, 2013 were as follows:
Opening stock as on 1st April, 2012, at cost ` 65,000
Purchase at cost ` 2,00,000
Sales ` 3,00,000
It is further ascertained that :
(1) Shortage of stock found in the year ending 31.03.2013, costing ` 1,000 were written off.
(2) Opening stock on 01.04.12 including goods costing ` 6,000 had been sold during the year
and bad been marked down in the selling price by ` 600. The remaining stock had been sold
during the year.
(3) Goods purchased during the year were marked down by ` 1,200 from a cost of
` 15,000. Marked-down stock costing ` 5,000 remained unsold on 31.03.13.
(4) The departmental closing stock is to be valued at cost subject to adjustment for mark-up and
mark-down.