Get premium membership and access revision papers, questions with answers as well as video lessons.
Got a question or eager to learn? Discover limitless learning on WhatsApp now -
Start Now!
Finance Computer Packages (Saturday) Question Paper
Finance Computer Packages (Saturday)
Course:Bachelor Of Commerce
Institution: Kca University question papers
Exam Year:2010
1
UNIVERSITY EXAMINATIONS: 2009/2010
SECOND YEAR STAGE 2 EXAMINATION FOR THE DEGREE OF
BACHELOR OF COMMERCE
CMS 205: FINANCE COMPUTER PACKAGES (SATURDAY)
DATE: APRIL 2010 TIME: 2 HOURS
INSTRUCTIONS: Answer Question ONE and Any other TWO Questions
QUESTION ONE
(a) What is the importance of Banking Navigator and Company Navigator in QuickBooks.
(4 Marks)
(b) Briefly describe any three quantitative techniques that can be used to make financial forecasts.
(3 Marks)
(c) Explain two techniques that can be used to examine financial variables. (4 Marks)
(d) Suggest five reasons why a company should automate its financial information system.
(5 Marks)
(e) Describe three types of mathematical models. (6 Marks)
(f) Design a Purchase order data entry form with the following information :
Invoice To, Order No, Date, Supplier Name, Mode of payment ,Description of Goods, Ref. Qty.,
rate, unit & amt, Amount chargeable, Terms of delivery ,VAT. (8 Marks)
QUESTION TWO
A computer based information system requires methods and devices that will ensure
accuracy and validity of information system activities.
(a) Explain any two common tests used to validate data input in a computer based
information system. (4 Marks)
(b) Describe how access to financial statements and reports generated by a computer
2
based accounting information system should be controlled. (4 Marks)
(c) Suggest four reasons that would lead to maintenance of a finance computer software. (4 Marks)
(d) Explain Four security features available in a spreadsheet software such as Excel. (8 Marks)
QUESTION THREE
A manufacturing firm has discontinued production of a certain unprofitable product line. Considerable
excess production capacity was created as a result. The Management is considering devoting this
excess capacity to one or more of three products: A1, A2 and A3.
Machine hours required per unit are:
PRODUCT
MACHINE TYPE A1 A2 A3
Milling Machine 9 1 4
Lathe 5 2 0
Grinder 3 0 2
The available time in machine hours per week is:
MACHINE HOURS PER WEEK
Milling Machine 600
Lathes 500
Grinder 400
The sales people estimate that they can sell all the units of A1 and A2 that can be made, but the sales
potential of A3 is 100 units per week maximum.
Unit profits for the three products are:
UNIT PROFITS
A1 $30
A2 5
A3 7
Required:
(a) Set up the equations and inequalities that can be solved to maximize the profit per week.
(6 Marks)
(b) Design the spreadsheet solver model for this problem. (7 Marks)
(c) Identify the following:
(i) The target cell. (2 Marks)
(ii) The cells whose contents are to change. (2 Marks)
(iii) The constraints functions. (3 Marks)
3
QUESTION FOUR
You work for a Management Consultancy firm that offers professional training in the use of
accounting computer packages. A client is keen on using QuickBooks to quickly set up an accounting
system and requires a brief session on the key concepts in Quick Books.
(a) Describe to the client:
(i) Record a cash sale (2 Marks)
(ii) The meaning of Audit Trail. (2 Marks)
(iii) How to create the Chart of Accounts in QuickBooks (4 Marks)
(b) Explain to the client the commands for viewing the following reports and statements:
i. Customer statement
ii. Inventory stock status by item
iii. Audit trail
iv. Income statement
v. Balance Sheet
vi. Trial Balance (6 Marks)
(c) Describe to the client any two methods that can used to set up a company in QuickBooks and how
to correct an error made while entering data in QuickBooks. (6 Marks)
QUESTION FIVE
Information systems have to be developed through a series of steps known as the systems development
life cycle (SDLC).
(a) Define an information system. (1 Mark)
(b) Describe any four components of an information system. (4 Marks)
(c) Highlight the main phases in the systems development life cycle. (5 Marks)
(d) What is the difference between systems analysis and systems Investigation? (4 Marks)
(e) Explain three conversion approaches that can be used to implement a finance computer
software. (6 Marks)
More Question Papers
Popular Exams
Return to Question Papers