Computerised Financial Systems N6 — Document
November 2020 — N6 — Computerised Financial Systems
N6
2020
Nated Business
Preparing document
📋 Document Analysis
See full analysis
Questions — A Preview of What to Expect in the Document
92
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.
1.1TRIAL BALANCE
1.1.1Create a new set of accounts named MAMA. o not use the etup ssistant. Select
1.1.2Use the following account numbers to create the given eneral ed ger accounts. Link each account to the correct financial and report writer category
1.1.3Use the eneral ournal to capture the balances given in QUESTION
1.1.2on 1 March 2019 . Use GJ1 as reference and Balance as description. Note that the ank account had a positive balance
1.1.4Do not print the eneral ournal batch listing.
1.1.5Post (update\e eneral ournal to the eneral edger.
1.1.6Make ONE PRINTOUT of the pre closing transfers trial balance for
1.4are posted to the eneral edger
1.2REPORT WRITER
1.2.1Create the following sset egister by using Report Writer . (
1.2.2Use the Report Writer Assistant to print the ssets egister (created
1.3PASTEL BUDGET MAMA would like to know what the current assets would be on the first day of the next year if the business sh
1.3.1Use the Budget Assistant to draw up a budget for urrent assets only.
1.3.2Copy this year's actual amounts to next year's budget.
1.3.3Increase urrent assets by 8% and round to the nearest R10.
1.3.4Do not make any other changes to this budget.
1.3.5Make a PRINTOUT of this budget for March 2020. Print Zero I tems es
1.4GENERAL JOURNAL OF CLOSING TRANSFERS
1.4.1Use the eneral ournal to journalise the closing transfers of the net loss, drawings and opening stock on 1 March 201
1.4.2Print the eneral ournal batch listing of the closing transfers, with contras , on
1.4.3Post (update\e eneral ournal to the eneral edger.
1.5BUDGET PRINTED TO MS EXCEL
1.5.1Use the Budget Assistant to d isplay next year's budget for urrent assets (created in QUESTION
1.3\n the screen in MS Excel.
1.5.2Do not print the budget yet.
1.5.3Do the following in MS Excel before print ing the budget: (a\ Delete the columns showing the months of the year, so that only the columns showing current assets and
1.5.4Do not make any other changes to this document.
1.5.5Save this budget as PASTEL.
1.5.6Print this budget on ONE portrait page. 14 [71] 603018671
2.1ADVANCED EXCEL You are an employee in the finance department of the Kwa Zulu Game Park.
2.1.1Type the following spreadsheet exactly as shown . Do not key in the shaded areas. These are only shown as an indication of the correct columns and rows to be used.
2.1.2Display the main heading in row 1 in bold and centred over the width of the spreadsheet.
2.1.3Display the cost per night per person in cell D3 as an integer with the rand currency sign.
2.1.4Wrap the column headings in row 4 and centre horizontally and vertically.
2.1.5Ensure that the dates under Date in and ate out appear in exactly the same format as in the example, but that
2.1.6Use formulae and cell references to calculate ights stayed and otal cost in the relevant columns. Be sure to use absolute cell references correctly where required, and to enter the formulae in
2.1.7Calculate otal cost as ost per person per night multiplied by the number of guests multiplied by the number of nights stayed.
2.1.8Sort the guests in the visitors log alphabetically.
2.1.9Hide column F (Total cost\ 6030186 10 Copyright reserved Please turn over
2.1.10Insert any neat horizontal and vertical lines.
2.1.11Insert your EXAMINATION NUMBER s left header and PRINTOUT 6 as right header.
2.1.12Save the visitors log as LOG.
2.1.13Print the visitors log on ONE landscape page. (22\
2.2FORMULA PAGE
2.2.1Change the visitors
Q2— Section header —
2.2.2Unhide column F (Total cost\
2.2.3Hide row 3 ( ost per person per night\
2.2.4Change the right header to PRINTOUT 7.
2.2.5Insert the following left footer: 5 April 2020
2.2.6Add the following text in cell A12 and A13 respectively: 12 Shortest stay 13 Longest stay
2.2.7Insert MS Excel formulae in cell E12 and E13 to determine the shortest and longest stay respectively.
2.2.8Display the row (1, 2, 3...\and column (A, B, C...\ headings. Do not type these headings.
2.2.9Adjust the column widths to fit the spreadsheet on ONE landscape page. Ensure that all information is clearly visible.
2.2.10o not use the it to 1 page option. Printing smaller than 100% Arial or Calibri 10 to 12 is not acceptable.
2.2.11Save the changed visitors log as FORMULAE
2.2.12Print the spreadsheet (with row and column headings\ on ONE landscape pa ge. (19\
3.1LABOUR COST Mandela Producers provided the following information: Normal working hours 40 hours per week Normal wage rate R180 per hour Overtime wage rate Double the normal wage rate Production bonus
3.1.1Use the following example ( exactly as shown\ to do the wage analysis of P. Shabalala who was recently married but ha no children yet. Do not change, leave out or add anything to the example.
3.1.2isplay the main heading in bold in TWO rows.
3.1.3Use formulae and cell references to complete the wage analysis, including the additional calculations and the employer's contributions.
3.1.4Be sure to complete the appropriate item(s\ under Additional calculations before you calculate Overtime, Production bonus and Income tax so that these additional items may be used in your calculations.
3.1.5Use an MS Excel function to round the umber of batches completed correctly and display as an integer, before you calculate the
3.1.6Display all amounts as and currency with TWO decimals.
3.1.7Display vertime hours and umber of batches completed as integers.
3.1.8Insert any neat horizontal and vertical lines.
3.1.9Insert your EXAMINATION NUMBER as a left header and PRINTOUT 8 as a right header.
3.1.10Save the wage analysis as WAGE.
3.1.11Print the wage analysis on ONE portrait page. (22\ 6030186 13
3.2FORMULA PAGE
3.2.1Change
Q3— Section header —
3.2.2Change the right header to PRINTOUT 9.
3.2.3Display the row (1, 2, 3 ...\and column (A, B, C ...\headings. Do not type these headings.
3.2.4Adjust the column widths to fit the spreadsheet on ONE landscape page. Ensure that all information is clearly visible.
3.2.5o not use the it to 1 page option. Printing smaller than 100% Arial or Calibri 10 to 12 is not acceptable.
3.2.6Save the changed wage analysis as FORMULAE
3.2.7Print (with row and column headings\ on ONE landscape pa ge. (18\ [40]40
4.1CONTRACT COST Muvhango Builders supplied the following information on 30 April 2020, the end of their financial year: Contract: Rose Contract: Budd Contract price R 1 720 000 R 870 000 Cash received
4.1.1Use the following example ( exactly as shown\ to draw up the ontract cost statement for the TWO contracts in the books of Muvhango Builders: Contract cost statement for the year end
4.1.2Insert your EXAMINATION NUMBER as a left header and PRINTOUT 10 as a right header.
4.1.3Insert horizontal and vertical lines exactly as shown in the example.
4.1.4Display all amounts as integers with no currency sign.
4.1.5Save the ontract cost statement as CONTRACTS.
4.1.6Print the ontract cost statement on ONE portrait page. (33\
4.2PRODUCTION BUDGET Muvhango Builders have a subsidiary department that makes Vibacrete slabs and poles for the erection of Vibacrete walls. They supplied the following information: Slabs Poles Required to erect 1
4.2.1Use the following example to draw up the production budget for Muvhango Builders' subsidiary department for May 2020: Type your EXAMINATION NUMBER here
Q4— Section header —
4.2.2Be sure to clearly indicate whether the pening stock and losing stock should be added or subtracted by adding the words ADD or LESS in the correct places to the example given
4.2.3Save the production budget as BUDGET.
4.2.448
Topics Identified
3
Forms of OwnershipBusiness FunctionsBusiness Plan
Mark Allocation
Total200 marks
Sections71 + 41 + 40 + 48 = 200 marks
Paper information
TitleDocument
SubjectComputerised Financial Systems
LevelN6
Document typeQuestion paper
Year2020
MonthNovember
Pages15
Downloads5
Examination context
Decade2020s
Years ago6y
SeasonSpring (SH)
Start daySunday
Exam periodNovember 2020
Days since exam2,171
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 size447.4 KB
Pages15
Archived on8 September 2026
File age47d
ContributorFreeMode
FingerprintF0AD001447D3
Questions and learner discussion
Log in to ask a question or leave a review.
No questions or discussions have been posted yet.