Knowee
Questions
Features
Study Tools

From the following information, prepare a manufacturing account and income statement for the year ending 31 December 2022 and a balance sheet as at 31 December 2022 for Getachew’s business: Sh Sh Purchase of raw materials 258,000 Fuel and light 21,000 Administration salaries 17,000 Factory wages 59,000 Carriage outwards 4,000 Rent and business rates 21,000 Sales 482,000 Returns inward 7,000 General office expenses 9,000 Repairs to plant and machinery 9,000 Inventory at 1 January 2022: Raw materials 21,000 Work-in-progress 14,000 Finished goods 23,000 Sundry accounts payable 37,000 Capital account 457,000 Freehold premises 410,000 Plant and machinery 80,000 Accounts receivable 20,000 Accumulated depreciation on plant and machinery 8,000 Cash in hand 11,000 984,000 984,000 Make provision for the following: (i) Inventory in hand at 31 December 2022: Raw materials Sh 25,000 Work-in-progress Sh 11,000 Finished goods Sh 26,000. (ii) Depreciation of 10% on plant and machinery using the straight line method. (iii) 80% of fuel and light and 75% of rent and rates to be charged to manufacturing. (iv) Allowance for doubtful debts: 5% of accounts receivable. (v) Sh 4,000 outstanding for fuel and light. (vi) Rent and business rates paid in advance: Sh 5,000 Manufacturing Trading and Income Statement for the year ending 31 December 2022 Sh Sh Sh Net sales Cost of raw materials used Factory wages Prime cost Fuel and light Rent and business rates Repairs to plant and machinery Depreciation for plant and machinery Manufacturing costs Add opening work in progress Total work in progress Less closing work in progress Cost of goods manufactured Add opening finished goods stock Total cost of goods available Less closing finished goods stock Cost of goods sold Gross profit Expenses; Fuel and light Salaries Rent and business rates Office expenses Selling and distribution expenses Financial charges (increase in provisions for doubtful debts) Net profit Balance Sheet as at 31 December 2022 Non-current assets Premises Plant and machinery (net book value) Total non-current assets Current assets; Raw material inventory Work in progress inventory Finished goods inventory Accounts receivable Prepayments Bank Total assets Current liabilities Accounts payable Accruals Net assets Financed by Closing capital Jump to...

Question

From the following information, prepare a manufacturing account and income statement for the year ending 31 December 2022 and a balance sheet as at 31 December 2022 for Getachew’s business:

Sh

Sh

Purchase of raw materials

258,000

Fuel and light

21,000

Administration salaries

17,000

Factory wages

59,000

Carriage outwards

4,000

Rent and business rates

21,000

Sales

482,000

Returns inward

7,000

General office expenses

9,000

Repairs to plant and machinery

9,000

Inventory at 1 January 2022:

Raw materials

21,000

Work-in-progress

14,000

Finished goods

23,000

Sundry accounts payable

37,000

Capital account

457,000

Freehold premises

410,000

Plant and machinery

80,000

Accounts receivable

20,000

Accumulated depreciation on plant and machinery

8,000

Cash in hand

11,000

984,000

984,000

Make provision for the following:

(i) Inventory in hand at 31 December 2022: Raw materials Sh 25,000 Work-in-progress Sh 11,000 Finished goods Sh 26,000.

(ii) Depreciation of 10% on plant and machinery using the straight line method.

(iii) 80% of fuel and light and 75% of rent and rates to be charged to manufacturing.

(iv) Allowance for doubtful debts: 5% of accounts receivable.

(v) Sh 4,000 outstanding for fuel and light.

(vi) Rent and business rates paid in advance: Sh 5,000

Manufacturing Trading and Income Statement for the year ending 31 December 2022 Sh Sh Sh Net sales Cost of raw materials used

Factory wages

Prime cost

Fuel and light

Rent and business rates

Repairs to plant and machinery

Depreciation for plant and machinery

Manufacturing costs

Add opening work in progress

Total work in progress

Less closing work in progress

Cost of goods manufactured

Add opening finished goods stock

Total cost of goods available

Less closing finished goods stock

Cost of goods sold Gross profit Expenses; Fuel and light

Salaries

Rent and business rates

Office expenses

Selling and distribution expenses

Financial charges (increase in provisions for doubtful debts) Net profit

Balance Sheet as at 31 December 2022 Non-current assets Premises Plant and machinery (net book value) Total non-current assets Current assets; Raw material inventory

Work in progress inventory

Finished goods inventory

Accounts receivable

Prepayments

Bank Total assets Current liabilities Accounts payable

Accruals Net assets Financed by Closing capital

Jump to...

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution 1

Sure, let's prepare the Manufacturing Trading and Income Statement and the Balance Sheet for Getachew's business.

First, let's calculate the Manufacturing Trading and Income Statement:

  1. Net Sales: Sales - Returns inward = 482,000 - 7,000 = 475,000
  2. Cost of raw materials used: Opening raw materials + Purchase of raw materials - Closing raw materials = 21,000 + 258,000 - 25,000 = 254,000
  3. Factory wages: 59,000
  4. Prime cost: Cost of raw materials used + Factory wages = 254,000 + 59,000 = 313,000
  5. Fuel and light: 80% of 21,000 = 16,800
  6. Rent and business rates: 75% of 21,000 = 15,750
  7. Repairs to plant and machinery: 9,000
  8. Depreciation for plant and machinery: 10% of 80,000 = 8,000
  9. Manufacturing costs: Fuel and light + Rent and business rates + Repairs to plant and machinery + Depreciation for plant and machinery = 16,800 + 15,750 + 9,000 + 8,000 = 49,550
  10. Add opening work in progress: 14,000
  11. Total work in progress: Prime cost + Manufacturing costs + Opening work in progress = 313,000 + 49,550 + 14,000 = 376,550
  12. Less closing work in progress: 11,000
  13. Cost of goods manufactured: Total work in progress - Closing work in progress = 376,550 - 11,000 = 365,550
  14. Add opening finished goods stock: 23,000
  15. Total cost of goods available: Cost of goods manufactured + Opening finished goods stock = 365,550 + 23,000 = 388,550
  16. Less closing finished goods stock: 26,000
  17. Cost of goods sold: Total cost of goods available - Closing finished goods stock = 388,550 - 26,000 = 362,550
  18. Gross profit: Net Sales - Cost of goods sold = 475,000 - 362,550 = 112,450
  19. Expenses: Fuel and light (20% of 21,000) + Salaries + Rent and business rates (25% of 21,000) + Office expenses + Selling and distribution expenses (Carriage outwards) + Financial charges (5% of Accounts receivable) = 4,200 + 17,000 + 5,250 + 9,000 + 4,000 + 1,000 = 40,450
  20. Net profit: Gross profit - Expenses = 112,450 - 40,450 = 72,000

Now, let's calculate the Balance Sheet:

  1. Non-current assets: Premises + Plant and machinery (net book value) = 410,000 + (80,000 - 8,000 - 8,000) = 474,000
  2. Current assets: Raw material inventory + Work in progress inventory + Finished goods inventory + Accounts receivable - Allowance for doubtful debts + Prepayments + Bank = 25,000 + 11,000 + 26,000 + 20,000 - 1,000 + 5,000 + 11,000 = 97,000
  3. Total assets: Non-current assets + Current assets = 474,000 + 97,000 = 571,000
  4. Current liabilities: Accounts payable + Accruals = 37,000 + 4,000 = 41,000
  5. Net assets: Total assets - Current liabilities = 571,000 - 41,000 = 530,000
  6. Financed by: Closing capital = Net assets = 530,000

Please note that the calculations are based on the provided data and assumptions.

This problem has been solved

Solution 2

Sure, let's prepare the Manufacturing Account, Income Statement and Balance Sheet for Getachew's business.

Step 1: Manufacturing Account

Opening stock of raw materials: 21,000 Add: Purchase of raw materials: 258,000 Less: Closing stock of raw materials: 25,000 Cost of raw materials used: 254,000

Add: Factory wages: 59,000 Prime cost: 313,000

Add: Fuel and light (80% of 21,000): 16,800 Add: Rent and business rates (75% of 21,000): 15,750 Add: Repairs to plant and machinery: 9,000 Add: Depreciation for plant and machinery (10% of 80,000): 8,000 Manufacturing costs: 49,550

Add: Opening work in progress: 14,000 Total work in progress: 376,550 Less: Closing work in progress: 11,000 Cost of goods manufactured: 365,550

Step 2: Income Statement

Sales: 482,000 Less: Returns inward: 7,000 Net sales: 475,000

Add: Opening finished goods stock: 23,000 Total cost of goods available: 388,550 Less: Closing finished goods stock: 26,000 Cost of goods sold: 362,550

Gross profit: 112,450

Less: Expenses Fuel and light (20% of 21,000): 4,200 Salaries: 17,000 Rent and business rates (25% of 21,000): 5,250 Office expenses: 9,000 Selling and distribution expenses (Carriage outwards): 4,000 Financial charges (increase in provisions for doubtful debts, 5% of 20,000): 1,000 Total expenses: 40,450

Net profit: 72,000

Step 3: Balance Sheet

Non-current assets: Premises: 410,000 Plant and machinery (net book value, 80,000 - 8,000 - 8,000): 64,000 Total non-current assets: 474,000

Current assets: Raw material inventory: 25,000 Work in progress inventory: 11,000 Finished goods inventory: 26,000 Accounts receivable (20,000 - 1,000): 19,000 Prepayments (Rent and business rates paid in advance): 5,000 Bank (Cash in hand): 11,000 Total current assets: 97,000

Total assets: 571,000

Current liabilities: Accounts payable: 37,000 Accruals (Outstanding for fuel and light): 4,000 Total current liabilities: 41,000

Net assets: 530,000

Financed by: Opening capital: 457,000 Add: Net profit: 72,000 Less: Drawings (to balance): -1,000 Closing capital: 528,000

Please note that the figures are in Sh (presumably Shillings).

This problem has been solved

Similar Questions

Tshiawelo Pty Limited has provided you with the following extract from the financial records for the financial year ended 31 December 2023 RCost of sales2 400 000Gross profit40%Operating expenses800 000Interest expense200 000Income tax expense30%Inventories 800 000Issued capital2 000 000Trade payables500 000Trade receivables600 000Cash and other equivalents200 000Short-term borrowings500 000Long-term borrowings2 000 000Property Plant and equipment1 000 000Required:Calculate the following ratios by choosing the correct answer from the options provided:Revenue from sales Blank 1 Net profit margin Blank 2Current ratio Blank 3Quick ratio Blank 4Debtors’ collection period Blank 5 Return on assets (ROA) Blank 6Days’ sales inventory held Blank 7Times interest earned ratio Blank 8

You are given the following information for the year ended 31 October 2019: Cost item Amount (Sh) Purchase of raw materials 112,000 Returns inwards 8,000 Decrease in stock of raw materials 8,000 Direct wages 42,000 Carriage outwards 4,000 Carriage inwards 3,000 Production overheads 27,000 Increase in work-in-progress 10,000 The value of factory cost of goods completed is Select one: a. Sh 202,000 b. Sh 174,000 c. Sh 183,000 d. Sh 182,000

The following information was available for the year ended December 31, 2022:Earnings before interest and taxes (operating income) $ 50,000Interest expense 10,000Income tax expense 12,000Net income 28,000Total assets at year-end 200,000Total liabilities at year-end 120,000The debt ratio at December 31, 2022 was:

Required informationSkip to question[The following information applies to the questions displayed below.]Summary information from the financial statements of two companies competing in the same industry follows.  Barco Company Kyan Company   Barco Company Kyan CompanyData from the current year-end balance sheets     Data from the current year’s income statement    Assets     Sales $ 780,000 $ 907,200Cash $ 19,500 $ 33,000 Cost of goods sold 590,100 630,500Accounts receivable, net 36,400 59,400 Interest expense 8,000 13,000Merchandise inventory 84,240 130,500 Income tax expense 14,992 25,045Prepaid expenses 5,600 7,500 Net income 166,908 238,655Plant assets, net 320,000 305,400 Basic earnings per share 4.17 5.79Total assets $ 465,740 $ 535,800 Cash dividends per share 3.74 4.03Liabilities and Equity     Beginning-of-year balance sheet data    Current liabilities $ 71,340 $ 103,300 Accounts receivable, net $ 30,800 $ 55,200Long-term notes payable 78,800 105,000 Merchandise inventory 63,600 105,400Common stock, $5 par value 200,000 206,000 Total assets 448,000 392,500Retained earnings 115,600 121,500 Common stock, $5 par value 200,000 206,000Total liabilities and equity $ 465,740 $ 535,800 Retained earnings 98,292 48,8812a. For both companies compute the (a) profit margin ratio, (b) total asset turnover, (c) return on total assets, and (d) return on equity. Assuming that each company’s stock can be purchased at $90 per share, compute their (e) price-earnings ratios and (f) dividend yields.2b. Identify which company’s stock you would recommend as the better investment.

Purchases Rs. 7,20,000; Office expenses Rs. 30,000; Selling expenses Rs. 90,000; Opening inventory Rs. 1,40,000; Closing inventory Rs. 80,000; Revenue from operations Rs. 12,00,000. Calculate Operating Ratio

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.