can you help me answer this.ASAP
CONFIDENTIAL FINALASSIGNMENT/FEB2020.DIA
DIPLOMA IN ACCOUNTING
FAC300
FINANCIAL ACCOUNTING AND REPORTING 111
INSTRUCTIONS TO STUDENTS: |
This assignment contains FIVE (5) question/s.
Students are required to submit this assignment only in Microsoft Word format. Please refrain from converting text/phrases into picture format such as .gif/ .jpeg/print screen / etc.
Your assignment should be typed using 12-point Times New Roman font and 1.5 line spacing.
Your assignment must be between 1500 to 3000 words excluding references.
Do not copy the assignment question and instructions to your answer. Only assignment answer developed within the approximate word limit will be assessed. Please write the word count at the right end of your assignment.
You can submit your assignment ONCE only in a SINGLE file.
Please download your assignment template under Announcement from Sqayy. You must submit using the template prepared.
Your assignment must be submitted between 9th April 2020 until 13th April 2020. Submission after 13th April 2020 will NOT be accepted.
Your assignment should be prepared individually. You should not copy another person’s assignment. You should also not plagiarise another person’s work as your own.
Any actions shown that you are not following instructions, marks deduction will be applied.
FINAL ASSIGNMENT: FEBRUARY 2020
INSTRUCTION: Answer ALL of the following questions in the answer sheet provided.
QUESTION 1
The wood-based industry in Malaysia comprises four major sectors which are sawn timber, veneer and panel products that include plywood and other reconstituted panel products such as particleboard, chipboard, fireboard, mouldings and builders’ joinery and carpentry (BJC). The industry is predominantly owned by Malaysian and it is estimated that 80 to 90% of the companies comprise small and medium size establishments.
Syarikat Kayu Kayan Sdn Bhd is one of small and medium size company that operates a wood based business located in Raub, Pahang. The company was founded by En Ali and En Ahmad and the company main activity is the manufacturing of wood based product and produce a wide range of furniture from offices, kitchen, bedroom, dining room, occasional, living room, upholstered furniture or sofa, outdoor and garden furniture.
You are currently on an internship training programme for six (6) months in the above company and as an accounting student you have been placed in the Accounting & Finance Department to provide experiential knowledge and exposure in manufacturing company. The Department’s Manager has requested you to prepare the Manufacturing account, Statement of Profit and Loss and wish to know the factory profit for the year ended 30 June 2019
You have been provided with the following Company’s Trial balance for year ended 30 June 2019:
DR (RM) | CR (RM) | |
Purchases: | ||
| 500,000 | |
| 200,000 | |
Direct Labour | 200,000 | |
Direct Factory expenses | 161,800 | |
Indirect Factory Labour | 32,000 | |
Factory Maintenance | 19,400 | |
Machine repairs | 23,000 | |
Sales of Finished Goods | 1,506,200 | |
Stocks at 1 July 2018: | ||
| 130,000 | |
| 105,000 | |
| 96,000 | |
Other Factory Overhead | 29,000 | |
Factory Heating & Lighting | 38,000 | |
Factory Rent | 23,000 | |
Return Inwards | 50,000 | |
Administrative Expenses | 44,000 | |
Selling & Distribution Expenses | 72,900 | |
Debtors | 178,000 | |
Creditors | 202,000 | |
Bad Debts | 700 | |
Plant and Machinery, at Cost | 500,000 | |
Delivery Vehicles, at Cost | 200,000 | |
Accumulated Depreciation, 1 July 2018: | ||
| 150,000 | |
| 80,000 | |
Allowance for Doubtful Debts, 1 July 2018 | 5,400 | |
Ordinary Share Capital | 659,200 | |
2,602,800 | 2,602,800 |
In addition, you are also being supply with the additional information pertaining to stock account and relevant accounts that requires you to further review the accounts as follows:
Stocks as at 30 June 2019:
| RM |
Raw Materials | 102,800 |
Incomplete Productions | 82,000 |
Finished Goods | 107,600 |
Note: Raw materials are valued at cost, Incomplete Production and Finished Goods are valued at factory cost.
The Raw Materials purchases figure for the year includes a charge for carriage inwards. On 30 June 2019, a credit notes of RM3,100 was received in respect of a carriage inwards overcharged. No adjustment has been made for this amount.
An allowance for doubtful debts is to be adjusted to 2.5% per annum of the outstanding debtors balance.
Accrued expenses at 30 June 2019 are:
| RM |
Direct Labour | 13,200 |
Machine Repairs | 3,400 |
Administrative Expenses | 6,000 |
One quarter of the administration expenses are to be allocated to the factory.
The company depreciates its plant and machinery and delivery vehicles at 10% per annum on net book value and 20% per annum on cost respectively.
An analysis of the sales of finished goods revealed the following:
| RM |
Goods sold on cash terms | 210,000 |
Goods sold on credit terms | 1,246,200 |
Required:
Prepare the Manufacturing Account and Statement Profit and Loss Account for the year ended 30 June 2019.
marks)
Based on the result in (i) above, show the factory profit and the provision for unrealized profit account based on the assumption that all finished goods manufactured are transferred to trading account at cost of production plus 10%.
(3 marks)
(Total: 20 Marks)
QUESTION 2
You are working as a Hire Purchase loan executive in HP Department of EON Finance. Your main task is to process HP loans application for customer and to obtain the necessary approval for HP loan. You have process a HP loan application by BABA Enterprise. On 1 April 2017, the HP loans applied by BABA Enterprise who bought a car from EON finance on hire purchase agreement was approved with the following terms:
a) Cash Price of the car was RM30,000 (Cost price to EON finance was RM26,000)
b) BABA was required to pay a deposit of RM7,000 and the balance will be settled by 28 equal quarterly instalments of RM1,161 each.
c) First instalment was due on 30 June 2017.
d) Interest charged was at 5.9% per annum, flat rate.
Upon review of the HP loan ledger indicates that all payments were made on due dates.
On 3 March 2019, the car involved in an accident and BABA Enterprise decided to terminate the hire purchase agreement. EON finance agreed to give a rebate of 30% on total finance charge.
EON finance closes its books on 31 March each year and spread the gross profit made on motor car sold to customers over the agreement period.
As the HP Manager wish to know the status of the above account, you are required to provide the following information to the HP Manager;
Required:
You are to calculate the final payment BABA Enterprise had to pay for early settlement of the hire purchase agreement.
marks)
You are to prepare the following ledger accounts in the books of EON Finance for the year ended 31 March 2018 and 31 March 2019 with detail transactions for each ledger.
Hire Purchase Debtors account - BABA Enterprise account.
(4.5 marks)
Hire Purchase Interest Received Account.
(3 marks)
The Allowance for Unrealized Profit Account.
(3 marks)
Hire Purchase Statement of Profit and Loss account (Extract).
(3.5 marks)
(Show all workings and calculate to the nearest RM).
If the sum-of- digits method is to be used, calculate hire purchase interest revenue for the year ended 30 March 2018.
(3 marks)
(Total: 20 Marks)
QUESTION 3
Techno Enterprise was recently formed on 1 Jan 2019. The sole proprietor, Ms Mawar has seek your assistance to prepare the relevant financial statement for the year ended 2019 based on the available records. Ms Mawar did not have any accounting knowledge and did not know how to prepare a complete financial statement. The company also did not maintain proper accounts and some of the records are incomplete.
Your lecturer has just completed delivered a topic on ‘Incomplete records’ in your class for an accounting subject. In order to practice of what has been taught in class, you have undertaken the assigned task by Ms Mawar to prepare the relevant financial statement based on incomplete records.
You have discussed the above matter with Ms Mawar and she was able to provide the following information for the year ended 2019.
Bank Account
RM | RM |
Balance 1/1/2019 5,600 | Creditors 50,600 |
Debtors 78,950 | Cash account 11,250 |
Loan – Bank Islam 7,500 | Wages 4,890 |
Rent 6,000 | |
Miscellaneous expenses 3,670 | |
Insurance 2,400 | |
Balance 31/12/2019 13,240 | |
92,050 | 92,050 |
Cash received during the year | Cash paid during the year |
RM | RM |
Sales 3,780 | Purchases 2,670 |
Miscellaneous Expenses 500 |
In addition, from the available records you are able to obtain the following information:
31/12/18 | 31/12/19 | |
RM | RM | |
Debtors | 10,900 | 13,600 |
Creditors | 8,450 | 9,200 |
Cash account | 700 | ? |
Accrued Rental | - | 500 |
Prepaid Insurance | 200 | 400 |
Delivery Van (net book value) | 5,600 | 4,800 |
Stocks | 25,600 | ? |
Note:
A uniform gross profit was determined at 30% on cost of goods sold
All calculations are to be rounded off to the nearest RM
In order to prepare the relevant financial statement for Ms Mawar, you are required to perform the following tasks:
Required:
Calculate the total sales for the year ended 31 December 2019. Show all workings.
(3 marks)
Calculate total purchases for the year ended 31 December 2019. Show all workings.
(3 marks)
Prepare the Statement of Profit and Loss for the year ended 31 December 2019.
(8 marks)
Prepare the Statement of Financial Position as at 31 December 2019.
(6 marks)
(Total: 20 Marks)
QUESTION 4
New Bridge Alumni Club was form by student of New Bridge College for the purpose to support a network of former graduates who will, in turn, help to raise the profile of the university. Besides, the alumni club exist is to support the College’s goals, and to strengthen the ties between alumni, the community, and the College.
You have just recently appointed as the Treasurer for New Bridge Alumni Club to replace the existing Treasurer who has left the Club after graduating from the College.
Your main task after taking over the Club treasurer is to prepare the complete sets of accounts for the coming Annual General Meeting of the Club to be held in October 2019.
In order to prepare the Club’s accounts, he has to understand the Club rules & regulations set forth in the By-Laws. New Bridge Alumni Club financial year ended 30 September every year. From the review of available records, the following information were obtained that relates to New Bridge Alumni Club for the year ended 30 September 2019.
The Club charges an annual ordinary subscription of RM400 per annum to its members. Currently, there are fifty (50) members. Besides annual ordinary subscription, the club also allows its members to pay a life membership fees of RM2,500.
As at 1st October 2018, five (5) members did not pay their annual ordinary subscription for the year ended 30 September 2018. Two (2) members paid in advance annual ordinary subscription fees for the year ended 30 September 2019.
As at 30 September 2019, four (4) members have not paid their annual ordinary subscription for the year ended 30 September 2019.
Ordinary subscription received during the year included subscription paid in advance by 3 members for the year ended 30 September 2020.
The bank statement of New Bridge Alumni Club’s current account as at 30 September 2019 were as follows:
RECEIPTS | RM |
Sale of refreshment | 5,600 |
Futsal Tournament Fees | 31,200 |
Ordinary subscription | 20,800 |
Life membership | 5,000 |
PAYMENTS | RM |
Rent | 6,100 |
Water & Electricity | 500 |
Purchases of refreshment | 4,200 |
Court rental for futsal tournament | 7,000 |
Prizes for futsal tournament | 20,000 |
Sport equipment | ? |
On 1 Aug 2019, New Bridge Alumni Club traded in its sport equipment with a new sport equipment valued at RM25,000. The old sport equipment which was purchased on 1 April 2014 had a net book value of RM15,400. Its trade in value is RM10,000. The Club paid the remaining balance immediately. It is the New Bridge Alumni Club’s policy to depreciate its sport equipment at a rate of 10% per annum on cost, yearly basis.
Other balances:
30 Sept 2018 | 30 Sept 2019 | |
RM | RM | |
Rent expense accrued | 500 | 450 |
Cash at Bank | 850 | ? |
Water & Electricity | 100 | 150 |
Inventories & refreshment | 160 | 240 |
Life membership fees | 7,500 | 10,500 |
Required:
You are to prepare the ordinary subscription account and Life Membership account of New Bridge Alumni Club.
(5 marks)
For the year ended 30 September 2019, you are to prepare the following accounts
Income and Expenditure
(6 marks)
Statement of Affairs as at 30 September 2018.
(4 marks)
Statement of Financial Position as at 30 September 2019.
(5 marks)
(Total: 20 Marks)
QUESTION 5
FELLA Design has been known in Malaysia for its custom made sofas for over 30 years and has a wide range of unmatched variety of sofa designs, sofa slipcovers and sofa cushions with unlimited fabric. You have been promoted to an Accounts executive position after graduating with a Diploma in Accounting from NB College. FELLA Design’s Head Office was located in Kuala Lumpur and a branch in Melaka.
You have been requested by your Account Manager to prepare the various financial statement for the year ended 31 May 2019 to be table to the Management Board with regards to the financial position of Kuala Lumpur and Melaka offices.
You have obtained the company’s Trial Balance as at 31 May 2019 that shows the following information.
KUALA LUMPUR RM | MELAKA RM | |
Capital | 300,000 | |
Accumulated Depreciation as at 1 June 2018 | ||
| 6,000 | 4,000 |
| 2,000 | 1,000 |
Goods sent to MIRI | 40,000 | |
Kuching Current Account | - | 79,000 |
Sales | 200,000 | 90,000 |
Investment income | 15,333 | - |
Allowances for Unrealised Profit at 1 June 2018 | 1,667 | |
Accounts Payable | 50,000 | 25,000 |
615,000 | 199,000 | |
Premises at cost | 120,000 | 80,000 |
Motor vehicles at cost | 20,000 | 10,000 |
Investments | 60,000 | |
Inventories on 1 June 2018 | 20,000 | 10,000 |
Account Receivables | 50,000 | 25,000 |
Bank | 40,000 | 10,000 |
Purchases | 150,000 | - |
Goods from Kuching | - | 36,000 |
Salaries | 45,000 | 20,000 |
Selling & distribution expenses | 5,000 | 1,000 |
General expenses | 20,000 | 7,000 |
Miri Current Account | 85,000 | - |
615,000 | 199,000 |
From the other accounts records you have obtained the additional Information:
The branch purchased all goods from Head Office at cost plus 20%.
On 31 May 2019, the Head Office sent some goods amounting to RM4,000 (invoiced price) which did not reach Melaka until 10 June 2019.
At 31 May 2019, there was cash in transit amounting to RM2,000 from Branch to Head Office.
The branch paid RM1,500 as general expenses for Head Office. This transaction was not recorded in both books of accounts.
The branch manager is entitled for annual bonus of 10% on gross profit of Melaka Branch and will be paid on 1 July every year.
Inventory losses at Head Office and Branch amounted to RM1,500 and RM600 respectively.
The inventories as at 31 May 2019 were as follows:
Kuala Lumpur | RM50,000 |
Melaka | RM32,000 |
It is the company’s policy to depreciates its assets as follows:
Premises 5% per annum on costs
Motor vehicles 10% per annum on net book value
Required:
You are to prepare the income statement for the Head Office, Branch and the Company as a whole for the year ended 31 May 2019.
marks)
ii) You are to reconcile the current account in the book of the Head Office with the current account in the book of the Branch to determine the transactions that affect the current account.
(5 marks)
You are to prepare the combine Statement of Financial Position as at 31 May 2019.
(5 marks)
(Total: 20 Marks)
(TOTAL MARKS: 100)
----END OF QUESTIONS----
FAC300/FA/AZS/FEB2020