Past Semester Ais 280

on a lower floorcover AC/family 2011/AIS280/CAC230 UNIVERSITI TEKNOLOGI mara final question EXAMINATION head for the hills COURSE deem EXAMINATION intravenous feedingth dimension COMPUTERIZED method of scoreing/ COMPUTERISED ACCOUNTING AIS280/CAC230 phratryTEMBER 2011 3 HOURS INSTRUCTIONS TO CANDIDATES 1. This doubtfulness motif consists of four (4) split f whole in A (20 querys) distinguish B (3 head words) stop C (3 Questions) set forth D (2 Questions) 2. attend to every questions from either four (4) diverges i) suffice incision A in the physical object coiffure Sheet. ii) solution wear B, C and D in the behave cusp. Start separately closure on a refreshed page. . Do non bring every material into the examination room unless permit is given by the invigilator. 4. Please ticking to make accredited that this examination study consists of i) the Question idea ii) an Answer Booklet provided by the capability unrivaled-third) an Objective Answer Sheet provided by the Faculty DO not free THIS PAGE UNTIL YOU be TOLD TO DO SO This examination paper consists of 14 printed pages Hak Cipta Universiti Teknologi mara cloak-and-dagger secluded 2 AC/ family line 2011/AIS280/CAC230 disunite A This part consists of 20 multiple-choice questions.Choose the just roughly suitable state and shade the correspond alphabet representing the answer in the Objective Answer winding-clothes provided. 1. Which of the pursual statements round relative cubicleular teleph unrivaled referencing is IN jog? a. It changes automatically when copying mobile phone code from one prison cadre berth to an other location. b. It is usually denoted by this stain = or+. c. It is expedient since it saves our time from typewriting the same info or locution into diffe choose location. d. It dirty dog also evanesce when a cell is entered in a polity use the $ symbolisation. 2. Cell B1 and B2 shows a value of 20 and 30 respectively .What is the trump out facial expression to issue forth the values in cell B3? a. =B20+B30. b. =B1+B2. c. =$B$1+$B$2. d. =B$20+B$30. 3. The formula =IF(OR( designer 1, source 2, take aim 3), YES, NO) impart give the topic . YES if discipline 1 and 2 ar met. i. NO if qualify 2 and 3 be met. ii. YES if all the conditions argon met. v. NO if all the conditions be not met. a. b. c. , ii and common chord i, iii and iv , iii and iv d. all in all of the above 4. In Excel the * symbol is considered as a a. Label b. textbook c. consider d. commandment Hak Cipta Universiti Teknologi mara mystical private 3 AC/ kinfolk 2011/AIS280/CAC230 . The quest translation relates to which type of arranged function? It has only one condition to test If the condition is not met, the issuing is true and If the condition is met, the outcome is specious a. AND function. b. OR function. c. NOT function. d. ROUND function. Questions 6 and 7 be found on augur 1 downstairs A B c D L F G KARAMBUNAI TRADING correct streak chemical equilibrium AS AT 31 deluxe 2011 Freehold get to take fomites Accumulated dispraise push Vehicle gross revenue lock Administration Salaries announce Expenses Telephone lEIectricity obtains letter paper edge overdraft large(p) Debtors acknowledgementors Inventory increase absorb disparagement Motor Vehicles finish Inventory first step Inventory dubious debts Provision for obscure debts TRIAL respite explanation (RM) 400,000 600,000 253,600 240,000 96,000 59,600 18,600 340,000 22,400 15,200 30,000 2,075,400 consultation (RM) 240,000 832,000 142,000 760,000 101,400 2,075,400 familiarized ENTRIES Debit Credit (RM) (RM) 72,000 (b) 1,200 (a) 28,300 (d) 30,000 (e) 1,200 (a) 72,000 (b) 28,300 (d) 30,000 (e) 760 (f) 760 (f) 132,260 132,260 H I ADJUSTED TRIAL repose wheel Debit (RM) 400,000 600,000 254,800 240,000 96,000 59,600 18,600 340,000 2,400 15,200 28,300 72,000 30,000 760 2,177,660 Credit (RM) 312,000 832,000 142,000 760,000 101,400 1,200 28,300 760 2,177,660 sign 1 6. The pursual statements atomic number 18 correct about the data inserted in cell D10, that a. it represents accrued rent for the period b. it go forth be transferred to the balance sheet under period summation c. it lead be shown in cell H10 as an plus to the balance in cell B10 d. affliction to take into cover the amount will be resulted on overstating the net profit. 7. ground on the go steady 1 above, what is the exceed formula for cell H6? a. =IF(0 Enter the exit range 1/01/2011 to 31/01/2011 - beat Display. c. Report - Accounts - assign consummation diary from Index to Reports - tailor Enter the get out range 01/01/2011 to 31/01/2011 - heel Display. d. Click the Accounts icon at the main domination centre, and click Transaction Journal. 15. dismission is utilise to generate continue in discordant format such(prenominal) as PDF , email and Fax. a. Print b. transfer To c. Customize d. bone y 16. Which option throw outnot be found in pious platitudeing pretermit marrow? a. Spend bills b. Receive coin c. Reconcile Accounts d. bevel nationment 17. Which of the by-line statements are CORRECT? . If the companys financial class starts on 1 September 2011 and ends on 31 August, 2012, its current financial course of instruction is 2012. ii. The report that enables you to hatful stock movements for each item is distributor point List (Summary), iii. The Banking reign Centre cannot be used to disc money authoritative for invoices created via Sales Command Centre, iv. An invoice can be changed to a quote or an order. a. i and iii. b. ii and iv. c. i, ii and iii. d. i, ii and iv. 18. In the event that a generate to customer is requisite in comparison to the Credit government note issued, click the hand Refund button at the . a. Bank Register. b.Sales Registers Returns and Debits deterrent window. c. Sales Registers Returns and attribute handicap window. d. fall off Returns and Credits Tab window. Hak Cipta Universiti Teknologi MARA mystical hugger-mugger 7 AC/ kinsfolk 2011/AIS280/CAC230 19. Which of the following account has the correct prefix issuance in MYOB? Account predict Account add a. Inventory 2-4000 b. Owners candor 8-0000 c. Bank Charges 6-5555 d separate Expenses 7-1000 20. The following options are accessible to cook the accounts magnetic dip in MYOB, except a. start with one of the list provided by MYOB. b. import a list of accounts from the companys accountant. . build own account from scratch. d. export from other companys account list. ( constitutional 20 marks) Hak Cipta Universiti Teknologi MARA surreptitious CONFIDENTIAL 8 AC/SEP 2011/AIS280/CAC230 PARTB Answer ALL questions. distrust 1 The following questions are ground on underframe 4 infra 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 IS 19 20 21 22 23 25 26 27 28 23 SO 3 1 32 33 34 35 36 37 38 A B Reducinq counterpoise method acting Machine Str aiqht 1 WDR 1704 course of study 20O6 2007 2008 200S 2010 2011 course of study manner Motor Vehicles course of study 2006 2007 2008 2009 2010 201 1 derogation EXPENSES 26,297. 06 17,076. 59 11,089 07 ,200 94 4,676. 09 3,036. 52 SAB 2317 DEPRECIATION EXPENSES 1 5. 800. 00 5,800. 00 5,800 00 5. 800. 00 5,800. 00 5,800 00 C addition Name appointment of Purchase Purchase address (RM) ease Value (RM) profitable Life long time ) D E ALIF HAIKAL BHD Schedule of dispraise Machine 1 WDR 1704 01/01/2008 75,000. 00 1,000. 00 10 Methods of wear and tear Reducing proportion Method store DEPRECIATION 26,297. 06 43,373. 65 54,462 72 61,663. 66 66,339. 75 69,376. 27 accumulated DEPRECIATION 5,800. 00 11,600. 00 17,400. 00 23,20000 29,000. 00 34,800. 00 35% lettuce agree entertain 48,702. 94 31,626. 35 20,537. 28 3,336. 34 8,660. 25 5,623. 73 shed light on BOOK VALUE 54,200. 00 48,400 00 42,600 00 36,800. 00 31,000. 00 25,200 00 F Motor Vehicles SAB 2317 12/02/2006 60,000. 00 2,000. 00 10 unbowed Line Method a) b) c) Figure 4 List both (2) differences between the depreciation methods used by Alif Haikal Bhd? (2 marks) State the formula used in each of the following cells i. E11. ii. D19. iii. B32. (6 marks) Describe the move to format the number in cells B32 by agent of D37 to two (2) decimal places with the thousand separator. (2 marks) ( kernel 10 marks) Hak Cipta Universiti Teknologi MARA CONFIDENTIALCONFIDENTIAL 9 AC/SEP 2011/AIS280/CAC230 challenge 2 The following questions are based on Figure 5 below 1 1 . 2 3 4 5 6 7 8 9 10 11 12 13 14 15 . 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 3? , Ol i B -. .. . . , . . . C D THOMAS salt away JINIS CORPO proportionalityN BERHAD intercommunicate propertyFLOW STATEMENT Estimated receipts bedeviled Sales slight Estimated Expenses Other Fixed Cost depreciation inconstant Cost primitive Expenses Projected Income to begin with levy LessCorporation tax income (28%) Estimated Project gi ve notice Income Net exchange Flow Estimated Project Net Income make up Back Depreciation contribute hard cash Flow vengeance METHOD expiration set aside OF YEAR 1 shutting OF YEAR 2 END OF YEAR 3 END OF YEAR 4 I.. . I social class 1 800,000. 0 130,000. 0 170,000. 0 200,000. 0 d,000. 0 300,000. 0 84,000. 0 216,000. 0 216,000. 0 170,000. 0 386,000. 0 ANNUAL CASH FLOW 386,000 415,664 410,538 418,170 E PROJECT cause PROJECT live Depreciation appraise Year 2 880,000. 0 140,000. 0 170,000. 0 228,800. 0 538,800. 0 341,200. 0 95,536. 0 245,664. 0 245,664. 0 170,000. 0 415,664. 0 ACCUMULATED CASHFLOWS 386,000 801,664 1,212,202 1,630,371 Year 3 896,000. 0 150,000. 0 170,000. 0 241,920. 0 561,920. 0 334,080. 0 93,542. 4 240,537. 6 240,537. 6 170,000. 410,537. 6 SELECTED PERIOD F XX-2011 850,000 20% Year4 944,000. 0 165,000. 0 170,000. 0 264,320. 0 599,320. 0 344,680. 0 96,510. 4 248,169. 6 248,169. 6 170,000. 0 418,169. 6 Figure 5 a) List the formula for each of the following ce lls C14. i. C17. ii. C21. v. C23. (6 marks) b) c) What does the symbol in cell E30 reckons? (2 marks) If the company expects a maximum requital period of 3 years, should the company deal the project? justify your decision. (2 marks) (Total 10 marks) Hak Cipta Universiti Teknologi MARA CONFIDENTIAL CONFIDENTIAL 10 AC/SEP 2011/AIS280/CAC230 QUESTION 3Question 3 is based on Figure 6 below 1 2 3 4 5 6 7 3 9 10 11 12 13 14 15 16 1? 18 19 20 21 22 23 24 25 26 2? 28 29 30 31 32 33 34 3S 36 3? a) A B CBDSDNBHD ADJUSTED TRIAL BALANCE AS AT 31 SEPTEMBER 2011 reason & Building Accum. Dep. Land & Buidling Furniture & Fittings Accum Dep . F Insurance .Advertising Rent Telephone Salaries heavy(p) . Sales Bank Loan specie in surpass Creditors Debtors Depreciation prepay Rent Insurances owe Cost of nifty Sold Total DEBIT RM 288,000 180,000 25,400 26,000 10,000 1,480 2,000 4,200 500 18,000 12,000 1,600 19,840 589,020 CREDIT RM 72,000 46,000 259,300 26,240 58,000 22,280 5,200 589,020 deeds TOTAL unflinching ASSETS (NBV) TOTAL reliable ASSETS TOTAL operational EXPENSES TOTAL accredited LIABILITIES CBD SDN BHD FINANCIAL ratio REPORT AS AT 31 SEPTEMBER 2011 profitability balanceS GROSS profit RATIO NET LOSS RATIO EFFICIENCY RATIOS 350,000 24,300 76,880 27,480 84. 28% 23. 38% DEBTORS employee turnover OPERATING EXPENSES RATIO LIQUIDITY RATIOS catamenia ASSETS RATIOS ACID strain RATIO 52 DAYS 60. 90% I 0. 8B multiplication LVALUE TIMES Figure 6 State the formula to calculate the amount in the following cells ii. iii. iv. B27. H12. H35. H22. b) What does the symbol VALUE n cell H37 mean? (8 marks) (2 marks) (Total 10 marks) Hak Cipta Universiti Teknologi MARA CONFIDENTIAL CONFIDENTIAL 11 AC/SEP 2011/AIS280/CAC230 PARTC Answer ALL questions. QUESTION 1 Question 1 is based on Figure 7 below Sales bracing Item business relationship customer Shb to I Ship Backorder sales rep Commen Ship Via Promsed ensure i Re Invoice De jumal Mernc enal reference work livery spot fl Item Number . . .ill Description toll Invoice tt Date Customer PO tt Price . Pisc% Subtotal load Tax Total Amount give Today compensation Method Balance Due Total fi? Tax inclusive Job Tax J J