can you help me answer this.ASAP

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: Raw Materials 500,000 Finished Good 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: Raw Materials 130,000 Incomplete production 105,000 Finished Goods 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: Plant and Machinery 150,000 Delivery Vehicles 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 Premises 6,000 4,000 Motor Vehicles 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