Question 4 OR

Branch Accounts (Stock & Debtors System) with list and invoice prices

18 marks

Time to write
About 36 minutes
Topic
Branch accounts
Notes
Crux notes

Question

Question 4 OR · 18 marks

Meghdoot Enterprises Ltd, whose Head Office is in Ahmedabad, invoices goods to its Branches at Pune and Indore at 20% below the list price, which is cost plus 50%, and instructs that cash sales be made at invoice price and credit sales at list price. The branch manager is instructed to give a discount at 15% on prompt payments. The Head Office pays all branch expenses, and all branch collections are remitted to the Head Office daily. Details of the branch balances and transactions for the year 2022-23 are given here:

SNDetailsAmount (Rs.)
1Opening Stock At the Branch at its cost24,000
2Opening Branch Debtors.20,000
3Goods Sent to branch (at cost to H.O.)2,20,000
4Goods received by Branch till close of the year2,54,000
5Transfer from Indore branch to Pune branch at catalogue price1,50,000
6Transfer to Indore branch from Pune branch at catalogue price60,000
7Goods purchased by Pune branch from local suppliers (cost) (Out of this, stock of Rs. 12,000 is left unsold at the end.60,000
8Cash Sales1,49,600
9Credit Sales2,90,000
10Goods returned by Credit Customers: to branch60,000
: directly to H.O.30,000
11Goods returned by Branch to H.O.48,000
12Cash remitted by Credit Customers: to Branch91,270
: directly to H.O.80,000
13Discount Allowed to Debtors26,730
14Loss of Goods by fire (Rs. 6,000 at invoice price), against which 80% of the cost was recovered from the insurance Company concerned.
15Loss of goods at the Branch through normal pilferage (at catalogue price).6,000
16Branch Expenses: Paid19,000
: Outstanding482
17The Branch Manager is entitled to a commission @ 6% of the net profits after charging such commission.

Required: Assuming that, at year end, provision is to be made for the discount to be allowed to debtors on the basis of the year's trend of prompt payments, prepare the Pune Branch Stock Account, Pune Branch adjustment A/c, Pune Branch Expenses A/c and Pune Branch Profit & Loss A/c and the Pune Branch Debtors A/c under the Stock & Debtors Method.

Reworded from the university paper: names and figures differ, the task is the same. The original paper belongs to the University of Delhi. See DU's question bank.

Before you write

Read off the question and its marks

36 minfor 18 marks

Read from the question

  • Assuming that, at year end, provision…The paper fixes this: use it as given, and say so in your answer.
  • prepare the Pune Branch Stock AccountProper formats (heading, date, both sides): post the plain items, then each adjustment, and balance last.

What the paper leaves open

  1. "Opening Stock At the Branch at its cost" is read as the branch's own cost, which is invoice price, so it is not grossed up.
  2. The paper gives one cash-sales figure although the branch also sells goods it bought locally; the local goods sold (₹48,000 at cost in our version) are read as sold for cash at their invoice-price equivalent, cost plus 20% (₹57,600), since the paper says cash sales are made at invoice price; the rest of the cash sales are head-office goods at invoice price.
  3. Goods received and the branch's returns to the H.O. are at invoice price; customer returns are at list price, since they reverse credit sales made at that price.
  4. The difference between the goods sent (at invoice price) and the goods received is goods in transit at the year end.
  5. The transfers, given at catalogue price, are converted to invoice price.
  6. The provision for discount applies the year's share of prompt settlements, worked out from the discount allowed, to the closing debtors at 15%.
  7. The pilferage is normal and the fire loss abnormal.

Write it in this order

Workings as you go: each statement feeds the next.

  1. Read the data; tick every adjustment as you plan it 2 min
  2. 1 Price structure; cash-sales split; opening stock at invoice price 2 marks 4 min
  3. 2 Branch Debtors A/c and the prompt-payment trend WN1–WN2 3 marks 5 min
  4. 3 Branch Stock A/c 4 marks 7 min
  5. 4 Branch Adjustment A/c with stock reserve 4 marks 7 min
  6. 5 Branch Expenses A/c 1 mark 2 min
  7. 6 Branch P&L A/c discount, provision, fire loss, commission 4 marks 7 min
  8. Check: every adjustment used, both sides agree, dates in 2 min

Final answer

Check your own figures against these.

Closing debtors
₹22,000
Provision for discount
₹2,970
Closing stock
₹27,200
H.O. goods ₹15,200 at IP plus local goods ₹12,000
Goods in transit
₹10,000
Gross Profit
₹87,600
Commission
₹2,118
Net Profit
₹35,300

Try it first. About 36 minutes for 18 marks. Write it out, then open the solution and check your figures against the final answer.

Solution

Hover or tap a marked figure, like 72,000, to see how it is made and where else it appears.

Price structure: cost 100 → list (catalogue) 150 → invoice 120. So invoice price (IP) = 1.2 × cost, list = 1.5 × cost, loading = ⅙ of IP, IP = 0.8 × list, and cost = two-thirds of list. Cash sales of ₹1,49,600 = local goods sold (60,000 − 12,000 = ₹48,000 at cost, × 1.2) ₹57,600 + head-office goods at invoice price ₹92,000 (paper note).

One committed convention (net-sales basis)

  1. The Branch Stock Account is kept at invoice price, and every sale is credited to it at the value actually realised. The excess of realisation over invoice price is carried to the Branch Adjustment Account as additional gross profit, the account in which the DU prescribed text strikes the branch's profit: the loading on opening and closing stock passes through the Stock Reserve and the gross profit is transferred from Branch Adjustment to Branch P&L (entries 14–16).
  2. Customer returns to the branch re-enter branch stock at list price, so the invoice value and the surplus reverse together. Customer returns sent direct to the head office never come back into branch stock: the Goods Sent to Branch Account is debited at invoice price and the unearned surplus of ₹6,000 is withdrawn from the Adjustment Account. The surplus is therefore struck on net credit sales.
  3. Locally bought goods carry no loading. They enter Branch Stock at cost, are sold for cash at cost plus 20%, and their entire margin is credited to the Adjustment Account.
  4. Inter-branch transfers are recorded at invoice price both ways, and the loading on the net inward transfer is neutralised: goods received from another branch are treated like goods received from the head office, and goods sent to another branch like goods returned to it.
  5. Normal and abnormal losses are treated differently. Normal pilferage is charged at its full invoice price to the Branch Adjustment Account (the DU text's entry 11 for a normal loss of stock), so it is absorbed in gross profit. The abnormal fire loss is split: loading to Adjustment, cost less the insurance claim to Branch P&L.
  6. Because closing stock is carried at invoice price, the loading in it is removed through a stock reserve (WN7): Branch Adjustment is debited and Stock Reserve credited (entry 14).

Working notes

WN1Branch Debtors Account (list price)
Dr₹Cr₹
To Balance b/d20,000By Bank: cash remitted by customers to the branch91,270
To Branch Stock A/c (credit sales, list)2,90,000By Bank: cash remitted by customers direct to the H.O.80,000
By Discount Allowed A/c26,730
By Branch Stock A/c (returns to the branch, list)60,000
By Goods Sent to Branch A/c (returns direct to the H.O., list)30,000
By Balance c/d (closing debtors)22,000
3,10,0003,10,000
Dr₹
To Balance b/d20,000
To Branch Stock A/c (credit sales, list)2,90,000
3,10,000
Cr₹
By Bank: cash remitted by customers to the branch91,270
By Bank: cash remitted by customers direct to the H.O.80,000
By Discount Allowed A/c26,730
By Branch Stock A/c (returns to the branch, list)60,000
By Goods Sent to Branch A/c (returns direct to the H.O., list)30,000
By Balance c/d (closing debtors)22,000
3,10,000
WN2The year's trend of prompt payments

The discount is allowed only on accounts paid promptly, so the discount itself shows how much of the year's settlements were prompt, and that share is what the closing provision is based on.

Step₹
Discount allowed during the year, at 15% of the accounts paid promptly26,730
⇒ gross value of the accounts paid promptly (26,730 ÷ 15%)1,78,200
Cash actually received from those customers (1,78,200 − 26,730)1,51,470
Total cash from credit customers (91,270 + 80,000)1,71,270
⇒ cash from customers who did not pay promptly (1,71,270 − 1,51,470)19,800
Total accounts settled during the year (1,78,200 + 19,800)1,98,000

Prompt settlements were 1,78,200 of 1,98,000 = 90%. Applying that trend to closing debtors at the same rate: provision for discount on debtors = 22,000 × 90% × 15% = ₹2,970.

WN3Branch Stock Account (invoice price)
Dr₹Cr₹
To Balance b/d (opening stock, at its cost = IP)24,000By Bank (cash sales of H.O. goods, IP)92,000
To Goods Sent to Branch A/c (goods received)2,54,000By Bank (cash sales of locally bought goods, cost + 20%)57,600
To Indore Branch A/c (transfer in, IP = 1,50,000 × 0.8)1,20,000By Branch Debtors A/c (credit sales, list)2,90,000
To Branch Debtors A/c (returns to the branch, list)60,000By Goods Sent to Branch A/c (returns to the H.O., IP)48,000
To Local Suppliers (goods bought locally, at cost)60,000By Indore Branch A/c (transfer out, IP = 60,000 × 0.8)48,000
To Branch Adjustment A/c (surplus on net credit sales 46,000 + margin on locally bought goods 9,600)55,600By Branch Adjustment A/c (normal pilferage, at IP)4,800
By Branch Adjustment A/c (loading on the fire loss)1,000
By Branch P&L A/c (fire loss, at cost)5,000
By Balance c/d (closing stock)27,200
5,73,6005,73,600
Dr₹
To Balance b/d (opening stock, at its cost = IP)24,000
To Goods Sent to Branch A/c (goods received)2,54,000
To Indore Branch A/c (transfer in, IP = 1,50,000 × 0.8)1,20,000
To Branch Debtors A/c (returns to the branch, list)60,000
To Local Suppliers (goods bought locally, at cost)60,000
To Branch Adjustment A/c (surplus on net credit sales 46,000 + margin on locally bought goods 9,600)55,600
5,73,600
Cr₹
By Bank (cash sales of H.O. goods, IP)92,000
By Bank (cash sales of locally bought goods, cost + 20%)57,600
By Branch Debtors A/c (credit sales, list)2,90,000
By Goods Sent to Branch A/c (returns to the H.O., IP)48,000
By Indore Branch A/c (transfer out, IP = 60,000 × 0.8)48,000
By Branch Adjustment A/c (normal pilferage, at IP)4,800
By Branch Adjustment A/c (loading on the fire loss)1,000
By Branch P&L A/c (fire loss, at cost)5,000
By Balance c/d (closing stock)27,200
5,73,600

Reading the closing balance. ₹27,200 = head-office goods ₹15,200 at invoice price (₹12,666.67 at cost) + locally bought goods ₹12,000 at cost, which carry no loading. Goods still in transit (₹10,000 at IP) have not reached the branch, so they sit in the Goods Sent to Branch Account. Normal pilferage at list 6,000 = ₹4,800 at IP; the fire loss of ₹6,000 at IP = loading 1,000 + cost 5,000.

WN4Branch Adjustment Account (loading = ⅙ of IP)
Dr₹Cr₹
To Stock Reserve A/c (loading on closing branch stock, 15,200 ÷ 6)2,533.33By Stock Reserve A/c (loading on opening stock, 24,000 ÷ 6)4,000
To Stock Reserve A/c (loading on goods in transit, 10,000 ÷ 6)1,666.67By Goods Sent to Branch A/c (loading on net goods sent, 1,92,000 ÷ 6)32,000
To Branch Stock A/c (normal pilferage, at IP)4,800By Indore Branch A/c (loading on the net inward transfer, (1,20,000 − 48,000) ÷ 6)12,000
To Branch Stock A/c (loading on the fire loss)1,000By Branch Stock A/c (surplus of list over invoice price, on net credit sales)46,000
To Branch Debtors A/c (surplus withdrawn: customer returns sent direct to the H.O.)6,000By Branch Stock A/c (margin on locally bought goods)9,600
To Gross Profit c/d → Branch P&L A/c87,600
1,03,6001,03,600
Dr₹
To Stock Reserve A/c (loading on closing branch stock, 15,200 ÷ 6)2,533.33
To Stock Reserve A/c (loading on goods in transit, 10,000 ÷ 6)1,666.67
To Branch Stock A/c (normal pilferage, at IP)4,800
To Branch Stock A/c (loading on the fire loss)1,000
To Branch Debtors A/c (surplus withdrawn: customer returns sent direct to the H.O.)6,000
To Gross Profit c/d → Branch P&L A/c87,600
1,03,600
Cr₹
By Stock Reserve A/c (loading on opening stock, 24,000 ÷ 6)4,000
By Goods Sent to Branch A/c (loading on net goods sent, 1,92,000 ÷ 6)32,000
By Indore Branch A/c (loading on the net inward transfer, (1,20,000 − 48,000) ÷ 6)12,000
By Branch Stock A/c (surplus of list over invoice price, on net credit sales)46,000
By Branch Stock A/c (margin on locally bought goods)9,600
1,03,600

The surplus, stated once. Customers are billed at list but stock is relieved at invoice price. On credit sales that stayed sold the difference is earned: (2,90,000 − 60,000) × 20% = ₹46,000. On the ₹30,000 of goods the customers sent straight back to Ahmedabad it was never earned, so ₹6,000 is withdrawn. Net surplus ₹40,000 = 20% of net credit sales of ₹2,00,000.

WN5Branch Expenses Account
Dr₹Cr₹
To Bank (paid by the head office)19,000By Branch P&L A/c (transferred)19,482
To Balance c/d (outstanding at the year end)482
19,48219,482
Dr₹
To Bank (paid by the head office)19,000
To Balance c/d (outstanding at the year end)482
19,482
Cr₹
By Branch P&L A/c (transferred)19,482
19,482
WN6Goods Sent to Branch Account (invoice price)
Dr₹Cr₹
To Branch Stock A/c (goods returned by the branch, IP)48,000By Branch Stock A/c (goods received by the branch)2,54,000
To Branch Debtors A/c (customer returns direct to the H.O., IP = 30,000 × 0.8)24,000By Balance c/d (goods in transit at the year end)10,000
To Branch Adjustment A/c (loading on net goods sent)32,000
To H.O. Trading A/c (cost of net goods sent)1,60,000
2,64,0002,64,000
Dr₹
To Branch Stock A/c (goods returned by the branch, IP)48,000
To Branch Debtors A/c (customer returns direct to the H.O., IP = 30,000 × 0.8)24,000
To Branch Adjustment A/c (loading on net goods sent)32,000
To H.O. Trading A/c (cost of net goods sent)1,60,000
2,64,000
Cr₹
By Branch Stock A/c (goods received by the branch)2,54,000
By Balance c/d (goods in transit at the year end)10,000
2,64,000

Goods sent at IP = 2,20,000 × 1.2 = ₹2,64,000; received ₹2,54,000, so ₹10,000 is in transit. Net goods sent = 2,64,000 − 48,000 − 24,000 = ₹1,92,000 (IP) = ₹1,60,000 at cost.

WN7Stock Reserve Account
Dr₹Cr₹
To Balance c/d (closing reserve: 2,533.33 on branch stock + 1,666.67 on goods in transit)4,200By Balance b/d (opening reserve)4,000
By Branch Adjustment A/c (additional reserve for the year)200
4,2004,200
Dr₹
To Balance c/d (closing reserve: 2,533.33 on branch stock + 1,666.67 on goods in transit)4,200
4,200
Cr₹
By Balance b/d (opening reserve)4,000
By Branch Adjustment A/c (additional reserve for the year)200
4,200

The reserve is raised only on head-office goods; the locally bought closing stock carries no loading.

Pune Branch Profit & Loss Account for the year 2022-23

Dr₹Cr₹
To Branch Expenses A/c19,482By Gross Profit b/d (Branch Adjustment A/c)87,600
To Discount allowed to debtors26,730
To Provision for Discount on Debtors (WN2)2,970
To Loss by Fire (cost 5,000 less insurance claim 4,000)1,000
To Branch Manager's Commission2,118
To Net Profit → H.O. General P&L A/c35,300
87,60087,600
Dr₹
To Branch Expenses A/c19,482
To Discount allowed to debtors26,730
To Provision for Discount on Debtors (WN2)2,970
To Loss by Fire (cost 5,000 less insurance claim 4,000)1,000
To Branch Manager's Commission2,118
To Net Profit → H.O. General P&L A/c35,300
87,600
Cr₹
By Gross Profit b/d (Branch Adjustment A/c)87,600
87,600

Manager's commission = 37,418 × 6/106 = ₹2,118, and 6% of ₹35,300 is ₹2,118 ✓.

Proof: independent cost-basis Branch Trading Account

Every figure restated at cost. Net sales = 92,000 + 57,600 + 2,90,000 − 60,000 − 30,000 = ₹3,49,600.

Dr₹Cr₹
To Opening Stock (at cost, 24,000 ÷ 1.2)20,000By Net Sales3,49,600
To Goods sent by the H.O. (cost of net goods)1,60,000By Goods transferred to Indore (at cost)40,000
To Goods received from Indore (at cost)1,00,000By Loss by Fire (at cost)5,000
To Goods bought locally (at cost)60,000By Closing Stock at cost (12,666.67 branch + 8,333.33 in transit + 12,000 local)33,000
To Gross Profit c/d87,600
4,27,6004,27,600
Dr₹
To Opening Stock (at cost, 24,000 ÷ 1.2)20,000
To Goods sent by the H.O. (cost of net goods)1,60,000
To Goods received from Indore (at cost)1,00,000
To Goods bought locally (at cost)60,000
To Gross Profit c/d87,600
4,27,600
Cr₹
By Net Sales3,49,600
By Goods transferred to Indore (at cost)40,000
By Loss by Fire (at cost)5,000
By Closing Stock at cost (12,666.67 branch + 8,333.33 in transit + 12,000 local)33,000
4,27,600

The normal pilferage is not credited here: as a normal loss it is part of the cost of the goods sold. Gross profit also checks a third way as a realised-margin build-up: cash sales of H.O. goods at invoice price 92,000 × ⅙ = ₹15,333.33, plus net credit sales at list 2,00,000 × ⅓ = ₹66,666.67, plus the local margin ₹9,600 = ₹91,600, less the ₹4,000 cost of the normal pilferage = ₹87,600, with zero residual.

The other reading of "at its cost". If "its cost" meant the head office's cost, the opening stock would be grossed up to ₹28,800 (reserve ₹4,800); closing stock is the balancing figure, so the head-office goods in it would rise to ₹20,000 at IP (reserve ₹3,333.33). Gross profit (₹87,600), commission and net profit are the same under both readings.

The other reading: local goods sold at list price

The paper gives one cash-sales figure and says only that cash sales are made at invoice price, so this answer sells the locally bought goods at their invoice-price equivalent, cost plus 20%. If they were sold at list price instead, cost plus 50%, the ₹48,000 of local goods sold would bring in ₹72,000 of the ₹1,49,600, head-office goods would account for only ₹77,600 of the cash sales, and more head-office goods would remain in closing stock.

FigureThis answer (local goods at invoice price)Local goods at list price
Cash sales of locally bought goods57,60072,000
Cash sales of head-office goods (IP)92,00077,600
Margin on locally bought goods9,60024,000
Closing branch stock27,20041,600
Head-office goods in closing stock (IP)15,20029,600
Stock reserve on closing branch stock2,533.334,933.33
Gross profit87,60099,600
Manager's commission2,1182,797.25
Net profit35,30046,620.75

Closing debtors, the provision for discount, goods in transit and every other account are the same under both readings.

Result: closing debtors ₹22,000 · provision for discount ₹2,970 · closing stock ₹27,200 (H.O. goods ₹15,200 at IP plus local goods ₹12,000) · goods in transit ₹10,000 · Gross Profit ₹87,600 · commission ₹2,118 · Net Profit ₹35,300.

Where the 18 marks sit

#ComponentMarks
1Price structure; cash-sales split; opening stock at invoice price2
2Branch Debtors A/c and the prompt-payment trend (WN1–WN2)3
3Branch Stock A/c (→ closing stock 27,200)4
4Branch Adjustment A/c with stock reserve (→ gross profit 87,600)4
5Branch Expenses A/c1
6Branch P&L A/c (discount, provision, fire loss, commission → NP 35,300)4
Total18
Keyboard: ← → previous and next question, / search

Report a problemopens an email to admin@getkunji.com with the question ID1406-Q4ORalready filled in.