Photo AI

Final Accounts of a Manufacturing Company The following balances were extracted from the books of Kelly Ltd as at 31/12/2016: Share capital Authorised - 800,000 ordinary shares at €1 each Issued - 600,000 ordinary shares at €1 each €600,000 Delivery vans (cost €72,000) €50,000 Factory buildings €705,000 Factory equipment (cost €350,000) €250,000 Patent €60,000 Stock 01/01/2016 Raw materials €45,000 Work in progress €13,500 Finished goods €63,500 Purchase of raw materials €360,500 Sales €857,000 Returns inwards (sales returns) €11,000 Creditors €85,000 Debtors €82,000 Sale of scrap materials €7,400 Factory wages €140,000 Direct expenses €15,000 Stationery €9,000 10% Debentures (issued 01/04/2016) €160,000 VAT €14,500 Provision for bad debts €3,500 Advertising €8,000 Factory insurance €19,000 Bank €55,200 Factory light and heat €14,200 Profit and loss balance 01/01/2016 €65,000 You are given the following additional information: (i) Stock at 31/12/2016: - raw materials: €35,000 - work in progress: €22,000 - finished goods: €60,000 (ii) Stock of stationery at 31/12/2016 was €700 - Leaving Cert Accounting - Question 1 - 2017

Question icon

Question 1

Final-Accounts-of-a-Manufacturing-Company-The-following-balances-were-extracted-from-the-books-of-Kelly-Ltd-as-at-31/12/2016:--Share-capital-----Authorised---800,000-ordinary-shares-at-€1-each-----Issued---600,000-ordinary-shares-at-€1-each----€600,000--Delivery-vans-(cost-€72,000)----€50,000-Factory-buildings----€705,000-Factory-equipment-(cost-€350,000)----€250,000-Patent----€60,000--Stock-01/01/2016-----Raw-materials----€45,000-Work-in-progress----€13,500-Finished-goods----€63,500--Purchase-of-raw-materials----€360,500--Sales----€857,000-Returns-inwards-(sales-returns)----€11,000--Creditors----€85,000-Debtors----€82,000--Sale-of-scrap-materials----€7,400--Factory-wages----€140,000-Direct-expenses----€15,000-Stationery----€9,000-10%-Debentures-(issued-01/04/2016)----€160,000-VAT----€14,500-Provision-for-bad-debts----€3,500--Advertising----€8,000-Factory-insurance----€19,000-Bank----€55,200-Factory-light-and-heat----€14,200-Profit-and-loss-balance-01/01/2016----€65,000--You-are-given-the-following-additional-information:--(i)-Stock-at-31/12/2016:----------raw-materials:-€35,000----------work-in-progress:-€22,000----------finished-goods:-€60,000--(ii)-Stock-of-stationery-at-31/12/2016-was-€700-Leaving Cert Accounting-Question 1-2017.png

Final Accounts of a Manufacturing Company The following balances were extracted from the books of Kelly Ltd as at 31/12/2016: Share capital Authorised - 800,000... show full transcript

Worked Solution & Example Answer:Final Accounts of a Manufacturing Company The following balances were extracted from the books of Kelly Ltd as at 31/12/2016: Share capital Authorised - 800,000 ordinary shares at €1 each Issued - 600,000 ordinary shares at €1 each €600,000 Delivery vans (cost €72,000) €50,000 Factory buildings €705,000 Factory equipment (cost €350,000) €250,000 Patent €60,000 Stock 01/01/2016 Raw materials €45,000 Work in progress €13,500 Finished goods €63,500 Purchase of raw materials €360,500 Sales €857,000 Returns inwards (sales returns) €11,000 Creditors €85,000 Debtors €82,000 Sale of scrap materials €7,400 Factory wages €140,000 Direct expenses €15,000 Stationery €9,000 10% Debentures (issued 01/04/2016) €160,000 VAT €14,500 Provision for bad debts €3,500 Advertising €8,000 Factory insurance €19,000 Bank €55,200 Factory light and heat €14,200 Profit and loss balance 01/01/2016 €65,000 You are given the following additional information: (i) Stock at 31/12/2016: - raw materials: €35,000 - work in progress: €22,000 - finished goods: €60,000 (ii) Stock of stationery at 31/12/2016 was €700 - Leaving Cert Accounting - Question 1 - 2017

Step 1

Prepare a manufacturing account for the year ended 31/12/2016.

96%

114 rated

Answer

To prepare the manufacturing account, we will follow these steps:

  1. Calculate the Cost of Raw Materials Consumed:

    • Initial stock of raw materials (01/01/2016): €45,000
    • Add: Purchase of raw materials: €360,500
    • Less: Closing stock of raw materials (31/12/2016): €35,000
    • Cost of raw materials consumed:

    extCostofrawmaterialsconsumed=45,000+360,50035,000=370,500 ext{Cost of raw materials consumed} = 45,000 + 360,500 - 35,000 = 370,500

  2. Add Direct Expenses:

    • Direct expenses: €15,000.
    • Total cost of raw materials consumed and direct expenses:

    extTotalcost=370,500+15,000=385,500 ext{Total cost} = 370,500 + 15,000 = 385,500

  3. Add Factory Wages:

    • Factory wages: €140,000.
    • Prime Cost:

    extPrimeCost=385,500+140,000=525,500 ext{Prime Cost} = 385,500 + 140,000 = 525,500

  4. Add Factory Overhead Expenses:

    • Factory supervisor's wages (80% of direct wages):

      140,000imes0.80=112,000140,000 imes 0.80 = 112,000

    • Factory insurance: €19,000.

    • Factory light and heat: €14,200.

    • Depreciation of factory equipment (15% of cost):

      250,000imes0.15=37,500250,000 imes 0.15 = 37,500

    • Depreciation of factory buildings (4% of cost):

      705,000imes0.04=28,200705,000 imes 0.04 = 28,200

    • Total Factory Overhead Expenses:

    extTotalOverhead=112,000+19,000+14,200+37,500+28,200=210,900 ext{Total Overhead} = 112,000 + 19,000 + 14,200 + 37,500 + 28,200 = 210,900

  5. Total Expenses:

    • Total expenses now become:

    extTotalExpenses=525,500+210,900=736,400 ext{Total Expenses} = 525,500 + 210,900 = 736,400

  6. Adjust for Work in Progress and Closing Stock:

    • Add Opening Work in Progress: €13,500
    • Less Closing Work in Progress: €22,000
    • Add Sale of Scrap Materials: €7,400
    • **Final Factory Cost:

    extCostofManufacture=736,400+13,50022,000+7,400=735,300 ext{Cost of Manufacture} = 736,400 + 13,500 - 22,000 + 7,400 = 735,300**

  7. **Final Manufacturing Account Completion:

    Manufacturing Account

    DescriptionAmount (€)
    Cost of raw materials370,500
    Direct expenses15,000
    Factory wages140,000
    Supervisor’s wages112,000
    Factory insurance19,000
    Factory light and heat14,200
    Depreciation - equipment37,500
    Depreciation - buildings28,200
    Total Factory Cost735,300

Step 2

Prepare a trading, profit and loss account for the year ended 31/12/2016.

99%

104 rated

Answer

To complete the trading, profit and loss account:

  1. Sales Calculation:

    • Sales: €857,000
    • Less: Sales returns: €11,000
    • Net Sales:

    extNetSales=857,00011,000=846,000 ext{Net Sales} = 857,000 - 11,000 = 846,000

  2. Cost of Sales Calculation:

    • Opening stock: €60,000
    • Cost of manufacture: €735,300
    • Closing stock: €60,000
    • Cost of Sales:

    extCostofSales=60,000+735,30060,000=735,300 ext{Cost of Sales} = 60,000 + 735,300 - 60,000 = 735,300

  3. Calculate Gross Profit:

    • Gross Profit:

    extGrossProfit=846,000735,300=110,700 ext{Gross Profit} = 846,000 - 735,300 = 110,700

  4. Less Expenses:

    • Administration (Stationery): €8,300
    • Advertising: €6,000
    • Depreciation motor vehicles: €5,000
    • Operating profit: €197,800
    • Less: Interest on debentures: €12,000
    • Taxation (corporation tax): €16,000
    • Net Profit:

    extNetProfit=extGrossProfitextTotalExpenses ext{Net Profit} = ext{Gross Profit} - ext{Total Expenses}

  5. Final Trading, Profit and Loss Account:

    DescriptionAmount (€)
    Net sales846,000
    Cost of sales735,300
    Gross Profit110,700
    Less: Administration expenses8,300
    Selling and Distribution expenses19,300
    Less: Taxation16,000
    Profit for the Year234,800

Step 3

Prepare a balance sheet as at 31/12/2016.

96%

101 rated

Answer

To prepare the balance sheet:

  1. List of Assets:
  • Intangible Assets: Patents, net value: €60,000

  • Fixed Assets:

    • Factory buildings: €676,800
    • Factory equipment: €177,500
    • Delivery vans: €919,300
  • Current Assets:

    • Raw materials: €35,000
    • Work in progress: €22,000
    • Finished goods: €60,000
  • Total Assets Calculation:

    extTotalAssets=60,000+676,800+177,500+919,300+35,000+22,000+60,000 ext{Total Assets} = 60,000 + 676,800 + 177,500 + 919,300 + 35,000 + 22,000 + 60,000

  1. List of Liabilities:
  • Creditors:

    • Amounts falling due within 1 year: €85,000
    • Corporation tax: €14,500
    • VAT: €14,500
    • Bank: €55,200
    • Debenture interest due: €12,000
  • Long-term Liabilities (Debentures): €160,000

  • Total Liabilities Calculation:

    extTotalLiabilities=85,000+14,500+14,500+55,200+12,000+160,000 ext{Total Liabilities} = 85,000 + 14,500 + 14,500 + 55,200 + 12,000 + 160,000

  1. Balance Sheet Representation:
    DescriptionAmount (€)
    Total Assets979,300
    Total Liabilities994,800
    Capital Employed834,800
    Share capital600,000
    Profit and loss234,800

Join the Leaving Cert students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;