In: Accounting
The following information relates to a company ABC Ltd for the year ended 30 June 2020:
Transaction totals for the year ended 30 June 2020 |
R |
Credit purchases of raw materials |
503750 |
Freight on raw materiasl purchased (on credit) |
99833 |
Sales of finished producgts |
11440000 |
Direct Labour: |
|
Factory wages |
828600 |
Pension fund contributions paid by employer |
172500 |
Medical aid paid by employer |
227200 |
UIF Contributions paid by employer |
8144 |
Indirect Labour |
500250 |
Electricity |
|
Factory |
211450 |
Administration offices |
127900 |
Rent Expenses |
|
Factory |
82700 |
Administration offices |
105900 |
Telephone and fax |
|
Facotry |
111166 |
Administrative offices |
145438 |
Insurance |
|
Factory |
205894 |
Administration offices |
132716 |
Selling and administration costs |
327195 |
Stationary |
60445 |
Salaries and administration staff |
488250 |
Sales returns of finished products |
49361 |
Consumabiles stores (indirect materials issued to the factory) |
144710 |
Depreciation on factory machinery |
180211 |
Balances on 1 July 2019 |
R |
Raw Materials inventory |
127894 |
Work in progress inventory |
43394 |
Finished goods inventory |
216450 |
Balances on 30 June 2020 |
R |
Work in process goods on hand |
617450 |
Raw material on hand |
99000 |
Finished products on hand |
477716 |
Required:
Prepare the production cost statement, trading statement and the relevant notes for the year ended 30 June 2020.
Please find below the required solution for above given question:
In the books of ABC Ltd. | ||
Production Cost Statement | ||
For the year ended 30 June, 2020 | Amt. (in R) | Amt. (in R) |
Direct Materials: | ||
Beginning Raw Materials Inventory | 127,894 | |
Add: Purchases of Raw Materials | 503,750 | |
Add: Freight on Raw Materials purchased | 99,833 | |
Less: Ending Raw Materials Inventory | 99,000 | |
Direct Materials used in production - [A] | 632,477 | |
Direct Labour: | ||
Factory wages | 828,600 | |
Pension fund contributions paid by employer | 172,500 | |
Medical aid paid by employer | 227,200 | |
UIF Contributions paid by employer | 8,144 | |
Direct Labour cost used in production - [B] | 1,236,444 | |
Manufacturing Overheads: | ||
Indirect Labour | 500,250 | |
Electricity - Factory | 211,450 | |
Rent Expenses - Factory | 82,700 | |
Telephone and fax - Factory | 111,166 | |
Insurance - Factory | 205,894 | |
Indirect Materials issued to the Factory | 144,710 | |
Depreciation on Factory Machinery | 180,211 | |
Manufacturing Overheads used in production - [C] | 1,436,381 | |
Total Manufacturing Costs = [A] + [B] + [C] | 3,305,302 | |
Add: Beginning WIP Inventory | 43,394 | |
Less: Ending WIP Inventory | 617,450 | |
Cost of Goods Manufactured for the year | 2,731,246 | |
Add: Beginning Finished Goods Inventory | 216,450 | |
Less: Ending Finished Goods Inventory | 477,716 | |
Cost of Goods Sold | 2,469,980 |
Trading and Profit/Loss Statement for the year ended 30 June, 2020 | |||||
Particulars | Amt. (in R) | Amt. (in R) | Particulars | Amt. (in R) | Amt. (in R) |
Beginning Inventory: | Sales of finished products | 11,440,000 | |||
Raw Materials | 127,894 | Less: Sales returns of finished products | 49,361 | 11,390,639 | |
WIP | 43,394 | ||||
Finished Goods | 216,450 | 387,738 | Ending Inventory: | ||
Raw Materials | 99,000 | ||||
Purchases of Raw Materials | 503,750 | WIP | 617,450 | ||
Add: Freight on purchases | 99,833 | 603,583 | Finished Goods | 477,716 | 1,194,166 |
Direct Labour Cost | 1,236,444 | ||||
Manufacturing Overheads | 1,436,381 | ||||
Gross Income or Profit c/f | 8,920,659 | ||||
12,584,805 | 12,584,805 | ||||
Electricity - Administration offices | 127,900 | Gross Income or Profit c/d | 8,920,659 | ||
Rent Expenses - Administration offices | 105,900 | ||||
Telephone and fax - Administration offices | 145,438 | ||||
Insurance - Administration offices | 132,716 | ||||
Selling and administration costs | 327,195 | ||||
Stationary | 60,445 | ||||
Salaries and administration staff | 488,250 | ||||
Net Income or Profit c/f | 7,532,815 | ||||
8,920,659 | 8,920,659 |