Computerised Financial Systems N5 — Document
November 2018 — N5 — Computerised Financial Systems
N5
2018
Nated Business
Preparing document
📋 Document Analysis
See full analysis
Questions — A Preview of What to Expect in the Document
52
This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1— Section header —
Q2— Section header —
Q3— Section header —
Q4— Section header —
Q5— Section header —
21.67TAX TAX METHOD Average TAX OFFICE Sandton NATURE OF PERSON Normal employee with ID TYPE OF EMPLOYMENT Permanent employee
Q1— Section header —
1.1PAYROLL INSTRUCTIONS Before you start answering the question paper, the following ins tructions should be carried out: The c ompany Dinamix was created for you. Open the compa ny Dinamix , click on
1.2Create the following employees
1.2.1Mrs Crook
1.2.2Mrs Ngini EMPLOYEE INFORMATION CODE 02 ROFILE SURNAME Crook
21.67TAX TAX METHOD Average TAX OFFICE SANDTON NATURE OF PERSON Normal employee with ID TYPE OF EMPL OYMENT
21.67TAX TAX METHOD Average TAX OFFICE SANDTON NATURE OF PERSON Normal employee with ID TYPE OF EMPLOYMENT Permanent employee
1.53 hrs hrs None COMMISSION R2 000 None None
1.6INSTRUCTIONS THE FOLLOWING PRINTOUTS MUST BE HANDED IN
1.6.1Print the payslips for: MARCH: Mr Paulse (20\ Mrs Crook (20\ APRIL: Mr Paulse (7\
1.6.2Print employee master files for Mrs Crook and Mrs Ngini . S elect personal details. (5\
1.6.3Print the leave history of Mr Paulse. (2\
1.6.4Print the note for Mr Paulse. (2\ QUESTIONS 2A TO 5 MUST BE ANSWERED ON A SPREADSHEET.
Q2— Section header —
Q2— Section header —
2.1Mrs Langa is an employee at Dinamix Manufacturers. She is paid weekly. The following information is made available to you as the accountant: Normal weekly hours: 8 hours per day 5 days per week (Mon day to Friday\
2.1.1Calculate the net wage for Mrs Langa for the week ending 25 March 2017. Use the following example: Retype exactly as it is. (Do NOT type the rows and columns
2.1.2Adjust colu mns to the right width.
2.1.3Display all amounts in currency with no decimals.
2.1.4Insert a header with EXAMINATION NUMBER left and PRINTOUT 1 right.
2.1.5Enhance the spreadsheet and insert horizontal and vertical lines exactly as in the example provided.
2.1.6Print the spreadsheet on one portrait page. 25
Q2— Section header —
2.2.1Retrieve PRINTOUT 1 and change the header to PRINTOUT 2.
2.2.2Print the formulae with row and column headings and use landscape (do n ot use fit to page\
2.2Save as PRINTOUT 2. 10 6030
Q3— Section header —
3.1Provide the stock sheet with all the formulae to do automatic calculations.
3.2Main heading: STOCK SHEET FOR MARCH 2017 FOR DINAMIX RETAIL STORE. Merge and c entre heading across the width of the spreadsheet.
3.3Use wrap text to fit column headings in one cell.
3.4Calculate the s elling price: Mark up for each Apple iPhone 6 10% Mark up for eac
3.5Insert vertical and horizontal lines to enhance your work.
3.6Display amount columns in currency (R\ith two decimals
3.7Insert a header with EXAMINATION NUMBER left and PRINTOUT 3 right.
3.8Print the spread heet on one landscape page. 6030
Q4— Section header —
4.1Draw up a Production Cost s tatement for Dinamix Manufacturers for March 2017. All cost is calculated as follows: 20% admin and 80% factory overhead and format all amounts to no currency and decimals.
4.2Dinamix Manufacturers would like the cost per unit to be indicated if they produce 500 units for March 2017. In sert this at the bottom of the Production
4.3Enhance your statement and insert horisontal and vertical lines.
4.4Insert your EXAMINATION NUM BER left and PRINTOUT 4 right in the footer.
4.5Save the spreadsheet as Printout 4 and print the spreadsheet on one portrait page 6030
Q5— Section header —
5.1Draw up a Income statement for Dinamix Manufacturers.
5.2Enhance your work with horisontal and vertical lines.
5.3Format the amounts to c urrency and no decimals.
5.4Insert a header with EXAMINATION NUMBER left and PRINTOUT 5 right Save the spreadsheet as PRINTOUT 5 and print the spreadsheet on one portrait page. TOTAL: 200
Topics Identified
3
Forms of OwnershipBusiness FunctionsBusiness Plan
Mark Allocation
Total200 marks
Sections30 = 30 marks
Key Information
Contact Number0322547008 · 0614101808
Paper information
TitleDocument
SubjectComputerised Financial Systems
LevelN5
Document typeQuestion paper
Year2018
MonthNovember
Pages15
Downloads4
Examination context
Decade2010s
Years ago8y
SeasonSpring (SH)
Start dayThursday
Exam periodNovember 2018
Days since exam2,900
About Computerised Financial Systems examination preparation
This TVET examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.
How to use this resource for revision
A TVET past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?
For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.
understanding question requirements
applying subject knowledge
working under time constraints
checking answers
identifying revision priorities
A practical revision approach
Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.
File details
File size404.5 KB
Pages15
Archived on8 September 2026
File age46d
ContributorFreeMode
FingerprintCD1FFDA385A7
Questions and learner discussion
Log in to ask a question or leave a review.
No questions or discussions have been posted yet.