Photo AI

Final Accounts of a Manufacturing Company The following balances were extracted from the books of Stewart Ltd as at 31/12/2019: Share capital         Authorised - 900,000 ordinary shares at €1 each         Issued - 620,000 ordinary shares at €1 each         Delivery vans (cost €82,000)         Factory equipment (cost €450,000)         Factory buildings         Patent Stock 01/01/2019:         Raw materials         Work in progress         Finished goods Purchase of raw materials Sales Returns inwards (sales returns) Factory light and heat Sale of scrap materials Stationery Factory wages Direct expenses Advertising 10% Debentures (issued 01/04/2019) Creditors Debtors Provision for bad debts VAT Factory insurance Bank Profit and loss balance 01/01/2019 You are given the following additional information: (i) Stock at 31/12/2019:         raw materials €45,000         work in progress €20,000         finished goods €50,000 (ii) Stock of stationery at 31/12/2019 €600 - Leaving Cert Accounting - Question 1 - 2020

Question icon

Question 1

Final-Accounts-of-a-Manufacturing-Company--The-following-balances-were-extracted-from-the-books-of-Stewart-Ltd-as-at-31/12/2019:--Share-capital-- - - - -Authorised---900,000-ordinary-shares-at-€1-each-- - - - -Issued---620,000-ordinary-shares-at-€1-each-- - - - -Delivery-vans-(cost-€82,000)-- - - - -Factory-equipment-(cost-€450,000)-- - - - -Factory-buildings-- - - - -Patent--Stock-01/01/2019:-- - - - -Raw-materials-- - - - -Work-in-progress-- - - - -Finished-goods--Purchase-of-raw-materials--Sales--Returns-inwards-(sales-returns)--Factory-light-and-heat--Sale-of-scrap-materials--Stationery--Factory-wages--Direct-expenses--Advertising--10%-Debentures-(issued-01/04/2019)--Creditors--Debtors--Provision-for-bad-debts--VAT--Factory-insurance--Bank--Profit-and-loss-balance-01/01/2019--You-are-given-the-following-additional-information:--(i)-Stock-at-31/12/2019:---- - - - -raw-materials-€45,000---- - - - -work-in-progress-€20,000---- - - - -finished-goods-€50,000-(ii)-Stock-of-stationery-at-31/12/2019-€600-Leaving Cert Accounting-Question 1-2020.png

Final Accounts of a Manufacturing Company The following balances were extracted from the books of Stewart Ltd as at 31/12/2019: Share capital      ... show full transcript

Worked Solution & Example Answer:Final Accounts of a Manufacturing Company The following balances were extracted from the books of Stewart Ltd as at 31/12/2019: Share capital         Authorised - 900,000 ordinary shares at €1 each         Issued - 620,000 ordinary shares at €1 each         Delivery vans (cost €82,000)         Factory equipment (cost €450,000)         Factory buildings         Patent Stock 01/01/2019:         Raw materials         Work in progress         Finished goods Purchase of raw materials Sales Returns inwards (sales returns) Factory light and heat Sale of scrap materials Stationery Factory wages Direct expenses Advertising 10% Debentures (issued 01/04/2019) Creditors Debtors Provision for bad debts VAT Factory insurance Bank Profit and loss balance 01/01/2019 You are given the following additional information: (i) Stock at 31/12/2019:         raw materials €45,000         work in progress €20,000         finished goods €50,000 (ii) Stock of stationery at 31/12/2019 €600 - Leaving Cert Accounting - Question 1 - 2020

Step 1

Prepare a manufacturing account for the year ended 31/12/2019

96%

114 rated

Answer

To prepare the manufacturing account, start with the opening stock of raw materials:

  • Stock of Raw Materials (01/01/2019): €50,000
  • Add: Purchase of Raw Materials: €380,500
  • Less: Closing stock of Raw Materials (31/12/2019): €45,000

The cost of raw materials consumed is calculated as follows:

extCostofRawMaterialsConsumed=extOpeningStock+extPurchasesextClosingStock ext{Cost of Raw Materials Consumed} = ext{Opening Stock} + ext{Purchases} - ext{Closing Stock}

extCostofRawMaterialsConsumed=50,000+380,50045,000=385,500 ext{Cost of Raw Materials Consumed} = 50,000 + 380,500 - 45,000 = 385,500

  • Add: Factory Wages: €130,000
  • Add: Direct Expenses: €17,000

Add factory overheads:

  • Factory Supervisors' Wages (20% of Factory Wages): €26,000
  • Factory Insurance: €15,000
  • Factory Light and Heat: €12,400

Total expenses are summed up:

extTotalExpenses=385,500+130,000+17,000+26,000+15,000+12,400=586,900 ext{Total Expenses} = 385,500 + 130,000 + 17,000 + 26,000 + 15,000 + 12,400 = 586,900

  • Less: Closing Work in Progress (31/12/2019): €20,000
  • Less: Closing Finished Goods (31/12/2019): €50,000

Thus, the cost of manufacture can be summarized by:

extCostofManufacture=extTotalExpensesextClosingStockofWIPextClosingStockofFinishedGoods ext{Cost of Manufacture} = ext{Total Expenses} - ext{Closing Stock of WIP} - ext{Closing Stock of Finished Goods}

extCostofManufacture=586,90020,00050,000=516,900 ext{Cost of Manufacture} = 586,900 - 20,000 - 50,000 = 516,900

Step 2

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

99%

104 rated

Answer

To prepare the trading and profit and loss account, start by calculating the sales:

  • Sales: €876,900
  • Less: Sales Returns: €13,000

The net sales would be:

extNetSales=extSalesextSalesReturns=876,90013,000=863,900 ext{Net Sales} = ext{Sales} - ext{Sales Returns} = 876,900 - 13,000 = 863,900

Next, calculate the cost of sales:

  • Opening Stock of Finished Goods: €50,000
  • Add: Cost of Manufacture: €516,900
  • Less: Closing Stock of Finished Goods: €50,000

The cost of sales is:

extCostofSales=extOpeningStock+extCostofManufactureextClosingStock ext{Cost of Sales} = ext{Opening Stock} + ext{Cost of Manufacture} - ext{Closing Stock}

extCostofSales=50,000+516,90050,000=516,900 ext{Cost of Sales} = 50,000 + 516,900 - 50,000 = 516,900

  • Gross Profit: Net Sales - Cost of Sales

extGrossProfit=863,900516,900=347,000 ext{Gross Profit} = 863,900 - 516,900 = 347,000

Next, record the expenses:

  • Less Expenses:
    • Administrative Expenses (Stationery): €7,400
    • Advertising: €6,000
    • Selling and Distribution: €14,500

Total expenses are summed:

extTotalExpenses=7,400+6,000+14,500=27,900 ext{Total Expenses} = 7,400 + 6,000 + 14,500 = 27,900

Finally, calculate the net profit:

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

extNetProfit=347,00027,900=319,100 ext{Net Profit} = 347,000 - 27,900 = 319,100

Step 3

Prepare a balance sheet as at 31/12/2019

96%

101 rated

Answer

To prepare the balance sheet:

Intangible Assets

  • Patents: €80,000

Fixed Assets

  • Factory Buildings: €672,600
  • Factory Equipment: €232,500
  • Delivery Vans: €27,000

Total Fixed Assets:

extTotalFixedAssets=672,600+232,500+27,000=932,100 ext{Total Fixed Assets} = 672,600 + 232,500 + 27,000 = 932,100

Current Assets

  • Closing Stocks:
    • Raw Materials: €45,000
    • Work in Progress: €20,000
    • Finished Goods: €50,000
  • Stock of Stationery: €600
  • Debtors: €72,000
  • Less Bad Debt Provision: €3,800
  • Advertising Prepaid: €1,500
  • Bank: €48,200

Total Current Assets:

extTotalCurrentAssets=45,000+20,000+50,000+600+72,0003,800+1,500+48,200=234,200 ext{Total Current Assets} = 45,000 + 20,000 + 50,000 + 600 + 72,000 - 3,800 + 1,500 + 48,200 = 234,200

Total Assets

  • Total Assets:

extTotalAssets=extTotalFixedAssets+extTotalCurrentAssets ext{Total Assets} = ext{Total Fixed Assets} + ext{Total Current Assets}

extTotalAssets=932,100+234,200=1,166,300 ext{Total Assets} = 932,100 + 234,200 = 1,166,300

Liabilities

  • Creditors: €93,000
  • Corporation Tax: €24,000
  • VAT: €15,000

Total Liabilities:

extTotalLiabilities=93,000+24,000+15,000=132,000 ext{Total Liabilities} = 93,000 + 24,000 + 15,000 = 132,000

Financed By

  • 10% Debentures: €150,000
  • Ordinary Share Capital: €620,000
  • Profit and Loss Account: €235,550

Total Capital Employed:

extTotalCapital=150,000+620,000+235,550=1,005,550 ext{Total Capital} = 150,000 + 620,000 + 235,550 = 1,005,550

Finally, ensure that Total Assets = Total Liabilities + Capital.

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

;