Departmental PEQ
Departmental PEQ
Departmental PEQ
CA Anil Nahata
CA INTERMEDIATE (NEW SYLLABUS)
Departmental Accounting
Question 1
FGH Ltd. has three departments I.J.K. The following information is provided for the year
ended 31.3.2004:
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.2004.
(10 Marks, November 2004) (PE II)
Solution
FGH Ltd.
Departmental Trading and Profit and Loss Account for the year
ended 31st March, 2004
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 9,000 10,000 19,000 transfer 30,000 60,000 90,000
labour Inter- Closing stock
To departmental By 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
staff welfare 9,000 6,000 3,000 18,000 profi 5,000 12,000 6,000 23,000
t b/d 7,000 7,000
To Rent 3,000 1,800 1,200 6,000 By Net loss
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
7,000
To Net loss (I)
To Stock By Stock reserve
5,000
reserve b/d
(J+K) (J + K)
3,000 6,000
(Refer W.N.)
By Net profit
To Balance (J + K)
transferred to
profit and 1,000 _____
loss account 11,000 11,000
Working
Note:
`
Stock reserve of J department
Cost 30,000
Transfer from I department 30,000
60,000
Stock of J department 20,000
30000 = ` 10,000
Proportion of stock of I department = ` 20,000
` 60,000
20
Stock reserve =` 10,000
= ` 1,667 (approx.)
120
`
Stock transferred from J department 5,000
Less: Profit (stock reserve) 5,000 20% (1,000)
Cost to J department 4,000
Proportion of stock of I department = ` 4,000 ` 30,000 ` 2,000
` 60,000
20
Stock reserve 2,000 ` 333 (approx.)
120
Total stock
reserve = ` 1,000
+ ` 333 = `
1,333
Question 2
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.
(2 Marks, November, 2009)(IPCC)
Answer
Calculation of Stock Reserve
`
Closing stock of Department Q 27,000
Goods sent 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
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.
(8 Marks, November, 2010) (IPCC)
Answer
Departments
R S T
` ` `
Profit 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)
48,600 34,425 24,300
Working Notes:
`
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
Question 4
Brahma Limited has three departments and submits the following information for the year
ending on 31st March, 2011:
Particulars A B C Total (`)
Purchases (units) Purchases 5,000 10,000 15,000
(Amount) 8,40,000
Sales (units) 5,200 9,800 15,300
Selling price (` per unit) 40 45 50
Closing Stock (Units) 400 600 700
You are required to prepare departmental trading account of Brahma Limited assuming that
the rate of profit on sales is uniform in each case. (5 Marks, May, 2011) (IPCC)
Answer
Departmental Trading Account for the year ended 31st March, 2011
Particulars A B C Particulars A B C
` ` ` ` ` `
To Opening Stock By Sales 2,08,000 4,41,000 7,65,000
(W.N.4) 14,400 10,800 30,000 By Closing stock 9,600 16,200 21,000
(W.N.4)
To Purchases 1,20,000 2,70,000 4,50,000
(W.N.2)
To Gross profit 83,200 1,76,400 3,06,000
2,17,600 4,57,200 7,86,000 2,17,600 4,57,200 7,86,000
Working Notes:
(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% (`) (16) (18) (20)
Purchase price per unit (`) 24 27 30
No. of units purchased 5,000 10,000 15,000
Purchases (purchase cost per unit x units 1,20,000 2,70,000 4,50,000
purchased)
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, 2011:
Cloth Department Readymade Clothes
Department
` `
Opening stock on 1st April,
2010 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
Selling expenses 2,10,000 73,500
Rent & warehousing 8,40,000 5,60,000
Stock on 31 st March, 2011 21,00,000 6,72,000
In addition to the above, the following information is made available for necessary consideration:
The stock in the Readymade Clothes Department may be considered as consisting of 75%
cloth and 25% other expenses. The Cloth Department earned a gross profit at the rate of 15%
in 2009-10. General expenses of the business as a whole amount to ` 10,85,000.
(8 Marks, November, 2011) (IPCC)
Solution
Departmental Trading and Profit and Loss Account for the year ended 31st March, 2011
To
Manufacturing
- 6,30,000 6,30,000
expenses
To Gross 42,00,000 9,17,000 51,17,000
profit c/d
2,83,50,000 53,97,000 3,37,47,000 2,83,50,000 53,97,000 3,37,47,000
To Selling By Gross
expenses 2,10,000 73,500 2,83,500 profit 42,00,000 9,17,000 51,17,000
b/d
To Rent &
warehousing 8,40,000 5,60,000 14,00,000
To Net profit 31,50,000 2,83,500 34,33,500
42,00,000 9,17,000 51,17,000
42,00,000 9,17,000 51,17,000
Working Note:
Total Sales
` 42,00,000 100
100 = 16%
` 2,31,00,000
31,50,000
Closing Stock of cloth in Readymade Clothes Department = 75%
Stock reserve for unrealized profit included in opening stock of readymade clothes
@ 15% i.e.
Additional Stock Reserve required during the year = ` 80,640 – ` 59,850 = ` 20,790.
Question 6
Department A 36,000
Department B 27,000
Department C 18,000
Stock lying at different departments at the end of the year are as below:
Department A Department B Department C
` ` `
Transfer from Department A - 7,200 5,750
Transfer from Department B 19,000 - 15,000
Transfer from Department C 4,600 3,300 -
Find out correct departmental profits after charging manager's commission.
(8 Marks, November 2012) (IPCC)
Answer
Question 7
and mark-down.
You are required to prepare :
(i) A Departmental Trading Account for Department A for the year ended 31st March,
2013 in the books of Head Office.
(ii) A Memorandum Stock Account for the year.
(iii) A Memorandum Mark-up Account for the year. (12 Marks, November 2013) (IPCC)
Answer
(i) Department Trading
Account For the year ending
on 31.03.2013
In the books of Head Office
Particulars ` Particulars `
To Opening Stock 65,000 By Sales 3,00,000
To Purchases 2,00,000 By Shortage 1,000
To Gross Profit c/d 58,880 By Closing Stock 22,880
3,23,880 3,23,880
(ii) Memorandum stock account (for Department A) (at selling price)
Particulars ` Particulars `
To Balance b/d 81,250 By Profit & Loss A/c 1,000
(` 65,000+25% of ` 65,000) (Cost of Shortage)
To Purchases 2,50,000 By Memorandum Departmental 250
(` 2,00,000 + 25% of Mark up A/c (Load on Shortage)
` 2,00,000) (` 1,000 x 25%)
By Memorandum Departmental 1,200
Mark-up A/c (Mark-down on
Current Purchases)
3,00,000
By Debtors A/c (Sales) 600
By Memorandum Departmental
Mark-up A/c
(Mark Down on Opening 28,200
3,31,250 Stock) By Balance c/d 3,31,250
State the basis on which the following common expenses, the benefit of which is shared by all
the departments is distributed among the departments:
(i) Rent, rates and taxes, insurance of building;
(ii) Selling expenses such as discount, bad debts, selling commission and other such selling
expenses; Carriage Inward;
(iii) Depreciation;
(iv) Interest on loan;
(v) Profit or loss on sale of investment;
(vi) Wages;
(vii) Lighting and Heating Expenses. (4 Marks, November 2013) (IPCC)
Answer
Allocation of Expenses
`
Department P 90,000
Department S 60,000
Department Q 45,000
Stock lying at different Departments at the end of the year are as below:
Figures in `
DEPARTMENTS
P S Q
Transfer from P - 18,000 14,000
Transfer from S 48,000 - 38,000
Transfer from Q 12,000 8,000 -
Find out correct Departmental Profits after charging Managers' Commission.
(8 Marks, May, 2014)
(IPCC)
Answer
Calculation of correct Departmental Profits
Mega Ltd. has two departments, A and B. From the following particulars, prepare departmental
Trading A/c and General Profit & Loss Account for the year ended 31 st March, 2014.
Particulars Amount (`)
Department A Department B
Opening stock as on 01.04.2013 (at cost) 70,000 54,000
Purchases 3,92,000 2,98,000
Carriage Inward 6,000 9,000
Wages 54,000 36,000
Sales 5,72,000 4,60,000
Purchased Goods Transferred:
By Department B to A 50,000
By Department A to B 36,000
Finished Goods Transferred:
By Department B to A 1,50,000
By Department A to B 1,75,000
Return of Finished Goods:
By Department B to A 45,000
By Department A to B 32,000
Closing Stock:
Purchased Goods 24,000 30,000
Finished Goods 1,02,000 62,000
Purchased goods have been transferred mutually at their respective departmental purchase
cost and finished goods at departmental market price and that 30% of the closing finished
stock with each department represents finished goods received from the other department.
(8 Marks, November, 2014) ( IPCC)
Answer
` 8311.00
` 4611.00
Question 12
(a) M/s. Suman Enterprises has two Departments, Finished Leather and Shoes. Shoes are
made by the Firm itself out of leather supplied by Leather Department at its usual selling
price. From the following figures, prepare Departmental Trading and Profit & Loss
Account for the year ended 31st March, 2014:
Solution :- Departmental Trading and Profit and Loss Account for the year ended 31st
March, 2014
Rate of Gross Profit of Finished leather Department, for the year 2013-14
Gross Pr ofit
= x 100 = [(42,00,000)/ (1,80,00,000 + 30,00,000)] x100 = 20%
Total Sales
Stock reserve for unrealized profit included in opening stock of Shoes dept. @ 15% i.e. (`
4,30,000 x 75% x 15%) = ` 48,375
Additional Stock Reserve required during the year = ` 75,000 – ` 48,375 = ` 26,625
Question 13
(a) Sona Ltd. has three departments – P, Q and R. From the following particulars
given below, compute:
(i) The departmental results;
(ii) The value of stock as on 31 st December, 2014:
Particula P Q R
rs
Stock as on 01.01.2014 30,000 45,000 15,000
Purchases 1,60,000 1,30,000 60,000
Actual Sales 1,88,000 1,66,000 93,000
Gross Profit on normal sales price 25% 33⅓% 40%
During the year 2014 some items were sold at discount and these
discounts were reflected in the above sales value. The details are given
below:
Particulars P Q R
Sales at normal price 15,000 8,000 6,000
Sales at actual price 11,000 6,,00 4,000
0
( 4 Marks Nov 15 IPCC)
P ( `) Q ( `) R (`)
Actual Sales 1,88,000 1,66,000 93,000
Add: Discount (Refer W.N.) 4,000 2,000 2,000
Normal sale 1,92,000 1,68,000 95,000
Gross profit % on normal sales 25% 33.33% 40%
Normal gross profit 48,000 56,000 38,000
Less: Discount (4,000) (2,000) (2,000)
Actual gross profit 44,000 54,000 36,000
Computation of value of stock as on 31st Dec. 2014
Departments P Q R
` ` `
Stock (on 1.1. 2014) 30,000 45,000 15,000
Add: Purchases 1,60,000 1,30,000 60,000
1,90,000 1,75,000 75,000
Add: Actual gross profit 44,000 54,000 36,000
2,34,000 2,29,000 1,11,000
Less: Actual Sales (1,88,000) (1,66,000) (93,000)
Closing stock as on 31.12.2014 46,000 63,000 18,000
(bal.fig.)
Working Note:
Question 14
`
Department X 1,80,00
Departmen 0
tY 1,35,00
0
Departmen
tZ 90,00
0
Stocks lying at different Departments at the end of the year are as under:
Solutions :-
Question 15
(a) M/s Shyam Udyog, a retail store, has two departments, Department X and
Department Y for each of which stock account and memorandum 'mark-up'
account are kept. All the goods supplied to each department are debited to
the stock account at cost plus a 'mark - up', which together make up the selling
price of the goods and in the a ccount the sale proceeds of the goods are
credited. The amount of 'mark -up' is credited to the Departmental Mark-up
Account. If the selling price of any goods is reduced below its normal selling
price, the reduction 'marked down' is adjusted both in the Stock Account and
the Departmental Mark-up Account. The rate of 'Mark up' for X Department
is 33-1/3% of the cost and for Y Department it is 50% of the cost.
The following figures have been taken from the books for the year ended
March, 2016 :
X Y
Department Department
Amount (`) Amount (`)
Stock as on April 1st at 3,15,000 5,58,000
cost
Purchases 22,77,000 28,02,000
Sales 28,68,000 37,50,000
(1) The stock of Department X on April 1, 2015 included goods the selling
price of which had been marked down by ` 37,800. These goods were
sold during the year at the reduced prices.
(2) Certain stock of the value of ` 2,07,000 purchased from the Department
X was later in the year transferred to the Department Y and sold for `
3,10,5000. As a result though cost of the goods is included in the
Department X the sale proceeds have been credited to the Department
Y.
(3) During the year 2015-16 to promote the goods, they were marked down
as follows:
Cost (`) Marked down (`)
Department X 1,68,000 10,800
Department Y 3,00,000 60,000
All the goods marked down, were sold except of Department Y of the
(1) ` of marked down by ` 30,000. At the time of stock taking on 31 st
1,50,000
value
March, 2016, it was discovered that cloth of Department X of the cost of
You are required to prepare for both the departments for the year ended 31 st
` 11,700
March, 2016: was missing and it was decided that the amount be written-off.
(a) The Memorandum Stock Account; and
(b) The Memorandum Mark-up Account. (8
Marks)
Marks NOV 16 IPCC)
Solutions
2015- ` ` 2015- ` `
16 16
T Balance By Sales 28,68,00
o b/d 0
(3,15,000 3,82,200 X Deptt. 2,07,00
+ 0
1,05,000 –
37,800)
T Purchases 22,77,000 Mark- 69,000 2,76,000
o up A/c
Markup 7,59,000 30,36,00 By Loss 11,700
0 o
f stock
A/c
Mark- 3,900 15,600
up A/c
By Mark-up 10,800
A/c
By Balance 2,47,800
c/d
34,18,20 34,18,200
0
Department X Memorandum Mark-up Account
2015-16 ` 2015-16 `
T Stock A/c (transfer) 69,000 By Balance b/d
o
T Stock A/c (re-sale) 3,900 (1,05,000-37,800) 67,200
o
T Stock A/c (mark down) 10,800 By Stock A/c 7,59,000
o
T Profit & Loss A/c 6,80,55
o 0
T Balance (1/4 of ` 61,950
o 2,47,800)
8,26,20 8,26,200
0
Working Note:
Verification of Profit `
Sales as per books 28,68,0
00
Add: Mark-down (37,800+10,800) 48,600
29,16,60
0
Gross Profit on fixed selling price @ 25% on ` 7,29,150
29,16,600
Less: Mark down (48,600)
6,80,55
0
Department Y Memorandum Stock
Account
2015-16 ` 2015-16 `
To Balance By Sales A/c 37,50,000
b/d
To Cost 5,58,000 By Mark-up A/c 60,000
Mark-up 2,79,000 8,37,000 By Balance c/d 15,40,500
To Purchases 28,02,000
Mark-up 14,01,000 42,03,000
To X Deptt. 2,07,000
A/c
Mark-up 1,03,500 3,10,500
53,50,500 53,50,500
2015-16 ` 2015-16 `
To Stock A/c 60,000 By Balance b/d 2,79,000
To Profit & Loss A/c 12,30,00 By Stock 14,01,000
0 A/c
(28,02,000 x
50%)
To Balance c/d: 4,93,500 By Stock A/c 1,03,500
[1/3(15,40,500+30,000)- `
30,000]
17,83,50 17,83,500
0
Working Notes:
Verification of Profit `
Sales 37,50,00
0
Add: Mark down in goods sold
30,000
37,80,00
0
Gross Profit 1/3 12,60,00
0
Less: Mark down
(30,000)
Gross profit as per books
12,30,000
Question 16
(a) The following balances were extracted from the books of Beta. You are
required to prepare Departmental Trading Account and general Profit & Loss
Account for the year ended 31st December, 2016:
SOLUTIONS:- Departmental Trading Account for the year ended on 31st December,
2016
Particulars A B Particulars A B
` ` ` `
To Opening Stock 3,00,000 2,40,000 By Sales 60,00,00 90,00,000
0
To Purchases 39,00,00 54,60,000 By Closing 6,00,000 12,00,000
0 Stock
To Gross Profit 24,00,00 45,00,000
0
66,00,00 1,02,00,00 66,00,00 1,02,00,00
0 0 0 0
General profit and loss account of Beta for the year ended on 31 st December,
2016
General expenses have not been allocated to individual department and are charged to
General Profit and Loss Account
Question17 .
Stocks lying at different departments at the end of the year are as under:
Dept. X Dept. Y Dept. Z
` ` `
Transfer from Department X 75,000 48,000
Transfer from Department Y 50,000 82,000
Transfer from Department Z 52,000 56,000
Calculate the unrealized profit of each department and also total unrealized
profit.
(4 Marks NOV 17 IPCC)
Solution
Additional Information:
Amount (`)
Carriage inwards 1,500
Carriage outwards 2,700
Salaries 24,000
Advertisement 2,700
Discount allowed 2,250
Discount received 1,800
Rent, Rates and Taxes 7,500
Depreciation on furniture 1,000
Electricity Expenses 3,000
Labour welfare expenses 2,400
Prepare Departmental Trading ND Profit & Loss Account for the year ended on 31-03-
2018 after providing provision for baddebts @ 5%.
Solutions:-
Departmental Trading and Profit and Loss Account for the year ended 31st March, 2018
Working Note:
(a) Axe Limited has four departments, A, B, C and D. Department A sells goods to
other departments at a profit of 25% on cost. Department B sells goods
to other department at a profit of 30% on sales. Department C sells goods
to other departments at a profit of 10% on cost, Department D sells goods
to other departments at a profit of 15% on sales.
Stock lying at different departments at the year-end was as follows:
`
Department A 2,25,000
Department B 3,37,500
Department C 1,80,000
Department D 4,50,000
Calculate the correct departmental profits after charging Manager's commission.
(5 Marks NOV 18 Inter)
Solutions :-
Question 20
ABC 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 amount of mark-
up is credited to a Memorandum Departmental Markup account. If the selling
price of goods is reduced below its normal selling prices, the reduction (mark-
down) will require adjustment both in the stock account and the mark-up
account. The mark-up for department X for the last three years has been 20%.
Figures relevant to department X for the year ended 31 st March, 2019 were
as follows:
Stock as on 1 st April, 2018, at cost ` 1,50,000
Purchases at cost ` 4,30,000
Sales ` 6,50,000
It is further ascertained that:
(1) Shortage of stock found in the year ending 31.3.2019, costing ` 4,000
were written off.
(2) Opening stock on 1.4.2018 including goods costing ` 12,000 had been
sold during the year and had been marked-down in the selling price by
` 1,600. The remaining stock had been sold during the year.
(3) Goods purchased during the year were marked down by ` 3,600 from a
cost of
` 30,000. Marked-down stock costing ` 10,000 remained unsold on
31.3.2019.
(4) The departmental closing stock is to be valued at cost subject to
adjustment for mark- up and mark-down.
You are required to prepare for the year ended 31 st March, 2019 :
(i) Departmental Trading Account for department X for the year ended 31 st
March, 2019 in the books of head office.
(ii) Memorandum Stock Account for the year ended 31 st March, 2019.
(iii) Memorandum Mark-Up account for the year ended 31 st March, 2019.
(10 Marks NOV 19 INTER)
Solutions :-
Particulars ` Particulars `
To Opening Stock 1,50,000 By Sales 6,50,000
To Purchases 4,30,000 By Shortage 4,000
To Gross Profit 1,05,000 By Closing Stock 31,000
c/d
6,85,000 6,85,000
`
A Sales as per Books 6,50,000
B Add: Mark-down in opening stock (given) 1,600
C Add: mark-down in sales out of current
Purchases (` 3,600 x 20,000 2,400
/30,000)
D Value of sales if there was no mark-down (A+B+C) 6,54,000
E Less: Gross Profit (20/120 of ` 6,54,000) subject to (1,09,000
Mark Down )
F Cost of sales (D-E) 5,45,000
`
A Opening Stock 1,50,000
B Add: Purchases 4,30,000
C Less: Cost of Sales (5,45,000
)
D Less: Shortage (4,000)
E Closing Stock (A+B-C-D) 31,000
Question 21
XYZ Garage consists of 3 departments: Spares, Service and Re pairs, each department
being managed by a departmental manager whose commission was respectively 5%,
10% and 10% of the respective departmental profit subject to a minimum of `5,000
in each case.
Inter departmental transfers take place at a “loaded” price as
follows: From Spares to Service 5% above
cost
From Spares to Repairs 10% above cost
From Spares to Service 10% above cost
In respect of the year ended March 31st 2019 the firm had already prepared
and closed the departmental trading and profit and loss account.
Subsequently it was discovered that the closing stocks of department had
included inter-departmentally transferred goods at “loaded” price instead of
the correct cost price.
From the following information, you are required to prepare a statement re-
computing the departmental profit or loss:
Working Note: