Theory question 105
Departmental AccountsSection B (Financial Accounting Practice; answer three questions only from this section)
5. Mary Oluwa operates the Lagos Departmental Store selling provisions, clothing and hardware. The following details relate to the business for the year ended 31st December, 1998.
Stock at 1st January, 1998: Provisions N10,000; Clothing N30,000; Hardware N45,000
Sales for 1998: Provisions N2,800,000; Clothing N4,800,000; Hardware N4,400,000
Purchases for 1998: Provisions N480,000; Clothing N790,000; Hardware N950,000
Rent and Rates N635,000
Lighting and cooling N1,200,000
Insurance N450,000
Carriage inwards N300,000
Carriage outwards N45,000
Administration expenses N105,000
Wages and Salaries N206,000
Fixed Assets N4,500,000
Additional information
(a) Closing stock was 20% more than the closing stock of 1997
(b) Carriage outwards expenses are to be apportioned ½ to hardware, the remainder equally between provision and clothing (c) Rent and rates, administration expenses and wages and salaries are to be apportioned on the basis of sales (d) All other expenses are to be apportioned equally (e) Fixed assets are depreciated at 10% per annum. You are required to prepare Departmental Trading and Profit and Loss Account to show departmental and total profit.
Show the model answer
Closing stocks (opening × 1.2): provisions 12,000; clothing 36,000; hardware 54,000. Sales ratio 28 : 48 : 44 (7 : 12 : 11).
Trading (provisions / clothing / hardware / total): opening stock 10,000 / 30,000 / 45,000; purchases 480,000 / 790,000 / 950,000; carriage inwards (equal) 100,000 each; less closing stock; cost of sales 578,000 / 884,000 / 1,041,000 / 2,503,000.
Gross profit 2,222,000 / 3,916,000 / 3,359,000 / 9,497,000.
Expenses: rent and rates 148,167 / 254,000 / 232,833; administration 24,500 / 42,000 / 38,500; wages and salaries 48,067 / 82,400 / 75,533 (all by sales); lighting and cooling 400,000 each; insurance 150,000 each; depreciation 10% × 4,500,000 = 450,000, i.e. 150,000 each; carriage outwards 11,250 / 11,250 / 22,500.
Total expenses 931,983 / 1,089,650 / 1,069,367 / 3,091,000.
Net profit 1,290,017 / 2,826,350 / 2,289,633; total 6,406,000.
Apportion each expense on the stated basis, then check that the departmental figures add up to the totals.