Home

USER GUIDE - Seagull

1. HE 85 CORREC RING DATA C 54 100 45 95 COST CATEGORY ai p aaie 136 COST CATEGORY MAINT ENAN GE netter tbe te id Ra RE 123 COSTOP TON tse ud dde 180 183 COST TO COMPLE lE mE E d 204 COST BY JOB sic Em 161 COSTING PARAME TERS 15 CREATE INVOICE IN SP i erra rx Qt ctc eet e Rr 56 CREATE OPERATIONS WHEN POSTING esses 21 CREATING tatnen denied ete fe eile anne 129 CREATING WORK CENTRE essent ener te treten 135 CREDITINOTE e 72 CROSS REFERENCE 210 CURRENCY CODE zc 64 E E 58 CUSTOMER Tc 77 86 104 CUSTOMER CREDIT NOTE ENTRY terere vig te edt yv eee uo 75 CUSTOMER INVOICE ENTRY zii cnin ente etica e e t bae 75 CUSTOMER ORDER intret donne ERR SEE E EE RES 104 CUSTOMER ORDER ENTRY onte E
2. 205 211 ADDING NEW 0 103 hospita m 200 ADDRESS 2 200 ADDRESS 3 m 200 ALL TRANSACTIONS oie 120 ALLOW BLANK CATEGORY rte error ka rese ites 20 ALLOW BLANK CATEGORY IN amp JGTS icr rent rore te oe err esr e ei ten 22 ALLOW BLANK CUSTOMER ORDER IN JO 3 essent 22 ALLOW BLANK CUSTOMER 17 ALLOW BLANK PRODUCT GR ONLDP deine ceeds treten a etree nne tcn 20 ALLOW BLANK PRODUCT GROUP IN JC13 sessi NER 22 ALLOW BEANK SALESMAN in enia den et eec o tel Red 20 ALLOW BLANK SALESMAN nennen enne nnne nennen inneren trennen nnne 22 ALLOW MANUAL POSTINGS 20 ettet reete tiene cete ettet enc bt egt aires gto 130 BIMBI 121 ALTERNATE FILE EEE E E 118 ALTERNATE SEQ 2 X L ovine eves 33 ALTERNATE SE
3. IE 34 YEAR END DATE 12 YEAR END SEQUENGE 3 reete Rte e Line etl air ec dete ue dare NR 27 Index 224 TITAN 2000 Address this reply to your Dealer YOUR COMMENTS PLEASE On a copy of this page Information from our users is important to the ongoing improvement of this product Please take the time to tell us what enhancements would be of benefit to yourselves and they will be carefully reviewed and if applicable incorporated in future releases Program Details Number Company Address Contact
4. 35 PROCEED WITH PRINT 106 150 153 156 161 164 166 168 171 174 175 183 PROCESSING AND BACKUP CYCLES isciani 25 ais 66 70 74 PRODUCT erret ett n e er on nre nen 47 80 81 89 97 109 PRODUC T BR C ceeds 131 PRODUC ECOS 131 PRODUCT DEFAYET WE 131 PRODUCT GROUP panie a eem a a i a ted derer nid ia 109 gisiougpe 199 Index 221 PROFIT PERCENTAGE eee ah Eee lesen fee ane ee ee ee 199 56 76 85 103 197 PROJEGT DESCRIP ON spressione anren tv retten ev reet cvv engine x dere ever eodd 197 PROJECT FROM metet cem tern eee tpe n gue eee 35 36 37 41 PRO RATA ACCORDING Qs i acide bcne rennen et tiet arae en ette Rede 38 PRO RATA FORMULA 23 PRO RATA PERGENTAGE rine tero 79 88 108 206 PURCHASE ORDER ENTRY 59 Q olnd 50 100 165 ee 97 REQUIRED m des 89 QU
5. m 114 LEAD TIME 124 Mc 121 EINER necesite cu LU Lu M LI M C ELE 46 96 tinte oim treten Ert 150 LONG TERMINOLOGY 14 16 19 129 M MAINTENANCE MODULE MENU tetti t reete teer t een tdt c role unu 101 MARGIN m 124 MONTH END 28 MONTEEENBDATE 525 Gere oreet ent s Dd den des entente 30 33 MONTEFEENB SEQUENGE reor or ere eret errante t open 27 Index 220 TITAN 2000 N NARRATIVE 50 52 209 NEW PAGE tient icti meinte ii tvi Priest cn 150 153 156 NEW FAGE PERPPOS ett ates rettet ates fut cas ces eens Pd feeit 156 NUMBERING M AJS 4 etate thee reete t tet Rete petite E Ee REFER EE I 65 69 73 M 66 70 73 OPERATION si Mm 78 87 107 146 OPERATION S decente sac teat feces aan tag aee istoc e eee st cet cen ott ee 47 96
6. MI T 82 91 113 203 RON TIME OUTSTANDING eases cated ta rae 207 RUN Esc 113 RUN TIME USED M 207 5 SALES VALUE 3 055 tente odi ee e neha ie hee ae ee 50 52 SALESMAN 57 109 SGANNINGIEBATUBES MEL EE 117 SCHEDULED 202 SCHEDULED EE 79 88 107 Nen PM 163 51 53 205 211 SCRAP QTY EE 51 53 SCRAP QUAN TITY rteniu a a a d aida asad a aie 205 211 SELECT GURRENGCY TO BE USED tre rere ttt agaaa edd Feet 64 SELECTIVE ARCHIVE DELETION 5555 41 SELECTIVE TRANSACTION DELE MON rissin E tenente trennen AN nnne 36 Ni2EBCRJI e cR 58 Nini 113 MME 113 SET UR cm 82 90 203 aes 82 90 203 SETTING UP THE SYSTEM irren te eee tiec etre
7. 57 DELETING COST GATEG ORIES trea ert etre eni ede era cea pt i dda ede epa Ea aed 126 DELETING TRANSACTION TYPES sss esent 134 DELETING WORK GENTRBES ttr rre rrr rte te peii iri P rro trn rr se fo reed neat 139 DEMAND PURCHASE ORDER i aint ee iced Ue Ee Ee eo Ege aii mines 61 DESCRIP TON 52 58 76 79 85 88 103 107 119 124 138 195 asi ct seis cesta etree eens pce dds sedan ea ped datas cea aN 121 DESCRIPTIONS airera anaia Heat athe eed ects ee at eee eee 136 DIRECT du RN Cr 62 DIVERSIONS Pos 49 99 bis ientcebz 124 DRM FUA 171 173 174 bleeuxi age aX 49 99 DOCUMENT DATE E 209 DOGUMENT TY PE ei esas 56 DUPLICATE REQUIRED synken terere eer Eee tene e ve reu pee exu dose uen ee ene 63 68 72 E EMPLOYEE f uiii pH ERIPUIT A E einen Ginna 48 81 89 90 109 EMPLOYEE STOCK elated allan desi avin asin tiene ei eet eee 202 EMPLOYEE STOCK NUMBER 3 3 2 chain is eter ie chal alan oda cial ainn chan
8. sre patte en tetendit seti tat a edits 19 OPERATION CODE DEFAULT tret mtr fete ei steer io ee er aea da 19 OPERATION DESCRIPTION etie tet trt tere ene a ret eo Rr rx de Erud 201 OPERATION END DATE inerte tt tc ecce ened ahah etre tta retra N O Oh rene a ko ve ais 201 OPERATION NUMBE ce 201 OPERATION START DATE 2 5 entr tnn eere ra nete re ena nd n rei an i rede 201 exu 62 63 ORDE RFORMTY PE rpm Pr rrr arti 63 OVERIIBAD oc ettet a r teca eerie ine te c nra 82 91 111 114 OVERHEAD COST vss m 204 OVERRIDABLE 22 tiec raha in nition Mita cnin e er tee Ee nav Erde be ette een wh stain nade 124 P TTC 119 124 135 136 PERCENTAGE COMPBLETE ree rrt teet et ode tesi ide tiere tegis 199 PERCENTAGE OF ESTIMATE EXCEEDED cfs treten 168 PERIOD distinte nte tne eerte hi bc 49 99 209 PERIODE nnn teen ns a ke Debe reet eee 12 28 PERIOD END CYCLES rtr ttim cta ner te HL eaa ad 25 PERIOD END MODULE MENU et te hr re denar dnd 26 PERIODS
9. REPORT TYPE PRINT DIVERSIONS DIVERSIONS ONLY FROM JOB TO JOB PERIODS JC Print 1 digit Enter 2 in the report type field to print category totals for those jobs assigned to analyse level 1 job level in program JC30 Job Operation Maintenance The analysis level may be amended using program JC32 Cost Category Maintenance Y N Y to include categories set up as diversions in program JC32 Cost Category Maintenance N to exclude diversions Y N Y to exclude categories not set up as diversions in program JC32 Cost Category Maintenance N to print all categories The default is all jobs or enter the starting and ending job range 1 Current period 2 Periods 1 through 6 the default 3 Periods 7 through 12 Enter the appropriate selection JULY 2006 6 173 PROCEED WITH PRINT REPORT TYPE 3 JOB COSTING COST CATEGORY REPORT TITAN 2000 Y N Press Enter to accept the selections or enter N to enable changes to be made The Esc key will end the program GEE OOL 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN REPORT TYPE PRINT DIVERSIONS Y N DIVERSIONS ONLY Y N JOB OP FROM TO PERIODS PROCEED WITH PRINT PERIOR 10 E CATEGORY LEVEL JOB DEVEL SSEUOES OP LEVEL Lil Ll INST OP SCAN CURRENT PERIODS 1 TO 6 PERIODS T TO 12 PRINTING 01 01 5111 INST
10. 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 JOB 01 GAME PARK Al DETAIL OP SCAN ACTIVE wo dm FINI FINISHING START DATE 27 02 98 2 LABOUR CLASS LABOUR END DATE QOS fe 00010 RICHARDSON PRO RATA Aayi s 01 BASIC PAY FINI FINISHING START DATE 27 02 98 2 LABOUR CLASS LABOUR END DATE 27 03 98 00011 KING PRO RATA 2 90 5 01 BASIC INST INSTALLATION START DATE 27 02 98 i INVENTORY CLASS MATERIAL USAGE END DATE 27 03 98 001 1WB WIT 46 WHITE CASCADE HANDSHOWER SPIRA PRO RATA 1 10 ACTIVATE F5 TOGGLE FIO PREVIOUS JC Set up and Run JULY 2006 2 39 TITAN 2000 2 12 JOB TO SP SUMMARY INVOICE CREATION JC97 This program allows you to mark jobs as complete and to automatically create a summary order in the Sales Order Processing System The summary is by job costing transaction type You may also enter a status code indicating that the job is complete The system will insert the JC32 Cost Category Maintenance category description as a narrative on the order header Enter JC97 to select the program JOB 4 characters Enter a job number or use the F1 key to scan all jobs on file If you use the F5 key you may toggle the scan between job number and project number JOB COSTING JOB TO SP SUMMARY INVOICE CREATION uicem ONE CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 13 JOB wes ENTER COMPLETED STATUS CODE 6 JOB PROJ DESCRIPTION
11. nnne en 194 TITAN 2000 1 GETTING STARTED 1 1 HOW TO USE THIS MANUAL Each chapter in this manual leads logically through the important steps to install and maintain your system Chapter 1 Getting Started describes the hard software requirements and special features of the TITAN systems Chapter 2 Set up and Run will take you through the sequential steps required to run the program effectively As each program has a System Parameter File Program 5000 APOO etc and usually a Period End Module 509 AP9 etc these are combined in this chapter to ensure all the set up data is understood The following chapters are the same for most systems They start with the Input Module then the Maintenance Module which helps you set up and maintain your file requirements Then the Enquiry Module which helps you search for data in your files After that specific modules such as Report Management Interface to Other Systems will follow If there are specific examples required these are entered in the Appendix The Index provides a reference to the actual screen prompts as well as key words Each screen and Report is also listed in the Index Screens are provided as a guide to the fields to be entered Each screen prompt will be indented and bold with the field length and further information on that field for example BATCH 6 digits When entering a new batch press Enter for the next sequential batch number When i
12. E 195 FORM TAY BE ait Ail lin nl etd ties E che A Ran li 106 158 FORM WIDTH Columns lias viene 195 FORMULA DETAILS 23 5 Com ree 208 M 150 152 FROM JOB svat tes rte rcr eir e ro cr n Ra E ee RR YR EE Eg vu nes Ea 149 152 155 161 173 FROM JOB OPERATIQN anre rte me t ne t n Pe e er perta Par 168 174 FROM WORK GENTRE e er ht or eI e ay aa i dre 166 177 FROM TO JOB EE 42 Index 218 G E 125 cl 58 H HEADER ttt iret tree trie se etit Ure eres te ie e ELE E ELIO e RE Ee E E Ec e LR Eae 196 HIERARCHY OF OPTIONS FOR ALTERNATE 119 HOURS BOOKED ie cdi edt O 52 99 INPURMODEHEETIENU peter eer errs 43 INTERFACE TO ACCOUNTS RECEIVABLE s sisien ari iaeia aaa aeiaai 55 INTERFACE WITH IV rnanan ia i aiia 130 INTERIM BILLING WITH AUTO ALLOCATION ennemi trennt nnne nennen 188 us eliduccram e 132 INVENTORY TOTAL steered deities vied asi
13. dictated pe tot cert eti oU TS LE EE 171 173 175 EE 208 PO UPDATES TOJOB COSTING 3 tnit tete tenete ra tre ire rete tres Dres 31 POST AP VIA 4692 etm pte dept Pe es 22 POST CODE EUER 200 POST TO ACCOUNTS RECEIVABLE 5 55 POSTING DETAILS atin veh n nnper eer 21 POSTING 44 94 PRINT DIVERSIONS 171 173 174 RRINTINDICATOR LE 58 PRINT TEMS ON INVOIGE ire etre trien entre nte eere etre tete ende reden 56 PRINT MODULE MENU err tere tinere rte ie o tede rei eod sti dee 148 PRINT PRODUCT ISO DOG 3E 24 tte terret erri ree eterne teens 33 PRINT SUBTOTAL Y N iicet itt tat natin eter trt eec etre rette enter e tee daha 180 183 PRINT TEST REQUIBEJ DY oo iicet roce ient Meanie 64 68 72 PRINT TRANSAGTIONGS creta et tct ret atn nr etre e eurn tb RR CY HE RN HAE gna ee RE Rn etg 164 PAU Ti VP sec testa etta ene molt cest tedio 161 PROCEED WITH 202202 28 34 PROCEED WITH DELET QN xt tenete tert te tr
14. 202 END DATE 77 79 86 88 104 107 END DATE FROM 35 41 END OF 1e DA A 195 ENQUIRY MODULE MENJJ e erc e ae ir o 140 ENTER COMPLETED STATUS CODE 2z 40 ENTER FILE FOR ALTERNATE 118 ENTERING COST CATEGORIES ien che creen ecran Dor koc enr kae eren ete te edo rires 124 ENTERING NEW WORK CENTHRES ts htec fter d ie ald ined a a idees 138 83 92 115 ESTIMATED PLANNED COSTS He dL recien 111 ESTIMATED COST COMPLETE erint ener retener re the ett du c sad nre aac scele 83 92 115 ESTIMATED SABES nete at esti tended ete rese el fetta erc eet re vette der ee 204 ESTIMATING LEVEL rre Et Pero Ra ERR RE edness eee 78 87 105 EXP PROFIT LEVEL e as 78 87 105 EXPECTED PROF T7 tint aul cac die ar tied ies asin Cee EE IR e cela ae a 84 93 116 206 EXPECTED PROFIT x 84 93 112 114 116 EXPEGTED PROFIT PERGENTAQGE ettet tetra ie ceperat re eere yere teretes 206 F FOR WARBELQOUSES EMINUS 30 FORM JEENGTH Liries 3 ret
15. e 49 58 USE INTERIM BILLING AUTO 23 USE JC10 TO ISSUE JC13 4424 1 0000000000 0 nnetnetr eren enne nnenn 22 USE OPERA TIONS Z 17 USE SPIARTIEND BATES EE 16 20 USE UNIT 131 V VALIDATE GCUSTOMER teinte eee EXER LP RESP 16 VALIDATION ONLY YIN is traut cruci retreat eer nea c tr reputare tet 33 VARIANCE 83 92 115 Ww WAREHOUSE arte tein t Re Eaa 64 69 73 WORK CENTRE 49 58 79 88 98 107 138 202 209 WORK 5 ile 166 WORK CENTRE DESCRIP QN 2 Gains aiea oi aaas 202 WORK CENTRE MAINTENANCE EIER RERO 135 WORK CENTRE PRODUCTIVITY 176 WP BR cavededestvstetes 132 WP vi 132 WIP CODE c 48 90 98 Y YEAR END CLEARDOWN
16. ker adenine 9 SETUP IME OUTSTANDING 5 eti m m re tod tede tetris 207 SETUP TIME USEDC E 207 Index 222 TITAN 2000 SHORT TERMINGOLQOQY eiie tnnc ee lie iene Seas ER Ee ieee 14 16 19 129 210 215 SP UPDATES TO JOB COSTING er vete tigre en geni 29 SPECIFY OPERATIONS deiner entered ened convene v eere uev deer 77 86 105 SPECIFY OPERATIONS atienden nine eats eens 17 5 det diene deed Neen 124 STARI DATE d rarer ere 77 79 86 88 104 107 STARI OEBODY e UE 195 START POSITION ih icona eerie ig ivi abana ane 121 START END JOB ic nett en etica ee ae dee igo 159 START END OP c ete trier eaten eae cenit ited tn Wie Padre Wai Deena ie 159 tice 159 START END TRANSACTION vw cos ics citet trennt eae d eg rt 159 STATUS 77 79 86 88 104 108 202 SID HOURS
17. lt gt FIRST FLOOR PRIVATE BATHROOMS FL2 HOT1 FLOOR 2 PRIVATE BATHROOMS FL3 HOT1 FLOOR 3 PRIVATE BATHROOMS FL4 HOT1 STAFF BATHROOMS TOILETS TEMPLATE FOR HOTEL FLOORS 1 4 GAO1 GAME GAME PARK A1 02 GAME STAFF QUARTERS PRIVATE 0 GAME VIP GUEST SUITE EM HOT GE MERAH Hult OOR SCAN FILE COMPLI F5 TOGGLE INVOICE FS UNFLAG Once your cursor is positioned on the correct job you have a few options Press F3 to mark a job as being complete As soon as you do this you will have to enter the status code your organisation uses to indicate that a job is complete ENTER STATUS CODE 1 character The system displays the current status code of the job and allows you to change it Be careful as no validation is performed to ensure that you enter a correct code If you have marked a job as complete by mistake you may press F8 to unset this flag You will however need a supervisor password to perform this function If you wish to create a summary invoice use the F6 key This will create a summary order in the Sales Order Processing system and prevent any further action to this job until it is unflagged with the F8 key as explained above 1 40 JULY 2006 Job Costing User Guide TITAN 2000 2 13 SELECTIVE ARCHIVE DELETION JC98 This program allows you to selectively delete records from the archive file
18. 118 123 CSB 128 JOS tees 135 dep 141 Je p 146 deri J 149 dep 152 155 158 E 161 ete ee ee eee 163 dero M S 166 e 168 do lnerS 170 do 176 de 179 Mele 182 de 28 JCO tesa 29 JO92 31 de cR 34 de MH 35 Index
19. A transaction record is then written to the History File JCHIST System totals are then updated on the System File FCODET Appendix 187 TITAN 2000 A 2 INTERIM BILLING WITH AUTO ALLOCATION This facility becomes operative when the options 4 Customer invoice entry and 5 Customer credit note entry HAVE been selected in program JC19 Contract Input Effectively these two options call program SP15 SP16 and program SP17 SP18 respectively which in turn call program SP10 Order Entry After a specific job has been selected in program SP10 Order Entry the indicator stored on the Job Costing system record is checked to see whether automatic allocation applies If it does then you are given the opportunity to perform auto allocation or enter selective line items If you have selected auto allocation then you are forced to enter a non stock item line At this stage you enter the total quantity to order the quantity to supply which will be distributed pro rata the selling price discount and cost price The system will check all valid operations that exist for the selected job Only operations with transaction classes of material usage or other and that are in an active status will be considered Effectively each item line is created for each operation that is selected under the above mentioned criteria Once this auto allocation is complete the created item lines are displayed on the screen You may now change them
20. JC Print JULY 2006 6 159 TITAN 2000 01 TECHNOLOGIES INCORPORATED 98 05 12 01 CAPE TOWN H24 HOUSING ESTATE J101DRAWING OF PLAN A JONES GENERAL CONTRACTING OPERATION START END DATES 89 04 14 89 05 14 OPERATION STRT DAT TRANSACTION WORK CENTRE CATEGORY COSTS CALC OHD OP11 CONSULTATION WITH ARCHITECT 89 04 21 INVENTORY WC 200X2 LABOUR COSTS HOUSING 675 00 00 OP11 CONSULTATION WITH ARCHITECT 89 04 14 LABOUR SUNDRY JOB COST CATEGORY 0 00 00 OP11 CONSULTATION WITH ARCHITECT 89 04 21 LABOUR WC 200X2 LABOUR COSTS MALLS 60 00 00 OP11 CONSULTATION WITH ARCHITECT 89 04 21 LABOUR WC 200X1 LABOUR COSTS MALLS 525 00 00 0010 HAND TOOLS 89 04 14 INVENTORY SUNDRY JOB COST CATEGORY 915 00 00 OP11 DRAWING UP PLANS 89 04 14 INVENTORY SUNDRY JOB COST CATEGORY 0 00 00 OP11 LABOUR 89 04 14 LABOUR LABOUR COSTS MALLS 49 43 00 OP12 OTHER 89 04 14 OTHER LABOUR COSTS ROAD BUIL 00 00 0010 HAND TOOLS 89 04 19 INVENTORY SUNDRY JOB COST CATEGORY 00 25 0040 LAYING FOUNDATIONS 89 04 19 LABOUR SUNDRY JOB COST CATEGORY 00 00 0040 LAYING FOUNDATIONS 89 04 19 LABOUR SUNDRY JOB COST CATEGORY 00 00 OP12 INVENTORY 89 04 19 INVENTORY LABOUR COSTS HOUSING 00 00 110 0000 260 0000 14 0000 2015 0000 109 4300 975 0000 JC73 Requisition Notes 6 160 JULY 2006 Job Costing User Guide TITAN 2000 6 6 COST TYPE BY JOB JC74 The program also prints job costs but in a different format from the previous reports In this case it
21. The layout of the data capture screens is soft and must be set up in program 00 System Record Maintenance It is essential that the REQUEST be specified in that program as this allows you to enter a Job Number JC Input JULY 2006 3 59 TITAN 2000 JOB COSTING CONTRACT INPUT PURCHASE ORDER wey SUL T CO 01 TECHNOLOGIES INCORPORATED BR CAPE TOWN WH 01 CENTRAL PO 000187 VENDOR 1000 RICHARDS CONCRETE CORP ITEM STOCK UGE DISCI DISC2 NET AMT SUB SERL EXT DESCRP ADD DESCRP 10 0 00 0 0000 0 00 0 00 moss INTO END ES DEL EID BEAD The layout and definitions of line items are set up in POOO System Record Maintenance and will differ for each user The above example shows a likely display It is advisable to include both the category codes for Accounts Payable and Job Costing in the jump table as these are important to such reports as JC78 Cost Category Report which may be used as a posting summary for the General Ledger 3 60 JULY 2006 Job Costing User Guide TITAN 2000 3 6 DEMAND PURCHASE ORDER JC18 This program is the same as program JC17 Contract Input Purchase Order except that it will print a Purchase Order document immediately JC Input JULY 2006 3 61 TITAN 2000 3 7 CONTRACT INPUT JC19 This program is designed to serve as a link between the Job Costing system and the Sales Order and Purchase Order
22. 10 FORM ESC EXIT OPERATION DETAILS JOB NUMBER OPERATION NUMBER OPERATION DESCRIPTION OPERATION START DATE OPERATION END DATE 4 characters digits 4 characters digits 30 characters This will be read from the job masterfile DD MM CCYY The start date as entered in program JC30 Job Operation Maintenance This will be read from the job masterfile DD MM CCYY The end date as entered in program JC30 Job Operation Maintenance This will be read from the job masterfile Appendix 201 TRANSACTION TYPE TRANSACTION DESCRIPTION WORK CENTRE WORK CENTRE DESCRIPTION STATUS SCHEDULED ACTIVE CATEGORY CATEGORY DESCRIPTION EMPLOYEE STOCK NUMBER EMPLOYEE STOCK DESCRIPTION Appendix 202 TITAN 2000 1 character The transaction type relating to the operation 10 characters The description associated with the type above 8 characters The work centre where the specific operation takes place 30 characters The description associated with the code above 1 character This is the job status as defined in SU31 Descriptions File Maintenance type JS and entered in program JC30 Job Operation Maintenance Y N This will print the relevant indicator from the job masterfile Y N This will print the relevant indicator from the job masterfile 4 characters The cost category as set up and maintained in program JC32 Cost Category Maintenance 30 characters The d
23. Appendix 209 CROSS REFERENCE SIV Appendix 210 TITAN 2000 8 characters GRV number from PO update or Invoice reference from SP update 6 digits SIV number per batch as defined by SU32 NUMBERS FILE MAINTENANCE type S TITAN 2000 BODY 6 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE Sus 11 001 BODY 6 JOB COSTING SOFT FORMS FONT COLMN DGT DEC TRANSACTION DETAILS QUANTITY ACTUAL RATE ACTUAL COST ACTUAL SALES ACTUAL CALCULATED OVERHEADS SCRAP QUANTITY SCRAP COST SQ METER USAGE UNIT QUANTITY UNIT LENGTH UNIT WIDTH IS THE ABOVE INFORMATION CORRECT Y N 1 F2 PREVIOUS F3 SAVE F8 DELETE F9 PRINT 10 FORM ESC EXIT TRANSACTION DETAILS Complete the following details if you wish them to print QUANTITY 7 4 digits The transaction quantity ACTUAL RATE 7 4 digits The transaction rate ACTUAL COST 7 4 digits The cost of the transaction ACTUAL SALES 7 4 digits The selling price as entered in SP ACTUAL CALCULATED OVERHEADS 7 4 digits Overheads as calculated for the transaction SCRAP QUANTITY 7 4 digits Scrap quantity entered for the transaction SCRAP COST 7 4 digits Cost of the scrap as entered for the transaction Appendix 211 TITAN 2000 SQ METER USAGE If you wish to print the square meter dimensions enter details for the fields below UNIT QTY 7 4 digits UN
24. CAPE PERIOD 10 REPORT TYPE CATEGORY LEVEL LEVEL JOB OP LEVEL PRINT DIVERSIONS Y N DIVERSIONS ONLY Y N CATEGORY FROM TO PERIODS CURRENT PERIOD PERIODS 1 YO 5 PERIODS 7 70 12 PROCEED WITH PRINT PRINTING 010 REPORT TYPE 1 Category total level 2 Job level 3 Job operation level Each report type will be explained in more detail as follows 6 170 JULY 2006 Job Costing User Guide REPORT TYPE 1 JOB COSTING COST CATEGORY REPORT 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN REPORT TYPE PRINT DIVERSIONS Y N DIVERSIONS ONLY Y N JOB FROM PERIODS PROCEED WITH PRINT TITAN 2000 JC78 11 001 PERIOD 10 1 CATEGORY LEVEL 2 JOB LEVEL LEVEL JOB SCAN 1 CURRENT 2 PERIODS TO 6 3 PERIODS 7 70 12 HOR SPEIBNIAOBISUONS SSESIIONC REPORT TYPE PRINT DIVERSIONS DIVERSIONS ONLY FROM CATEGORY TO CATEGORY PERIODS PROCEED WITH PRINT JC Print 1 digit Enter 1 in the report type field to print totals per category code for selected periods Y N Y to include categories set up as diversions in program JC32 Cost Category Maintenance N to exclude diversions Y N Y to exclude categories not set up as diversions in program JC32 Cost Category Maintenance N to print all categories Enter the start and end of the range or p
25. CUSTOMER STATUS START DATE END DATE CATG ANALYSIS LEVEL SPECIFY OPERATIONS FS 1 01 01 92 02 27 1227 0 X 2 1 M 01 01 TMP1 1 wiles AP 0 NONE TEMPLATE FOR HOTEL FLOORS 1 4 oper JULY 2006 FERIOD 10 3 BRANCH Il JOB ae 2 TRANS OB 3 TERM Come qm el 6 characters Accept the default or enter a new customer number This number will be validated against the customer masterfile if validation has been selected in program JCO00 System Record Maintenance 1 character Accept the default or enter a valid status code as defined in program 6031 Descriptions File Maintenance type JS or leave this field blank DD MM CCYY The default from the template is displayed but it may be altered DD MM CCYY The current date plus one month is displayed but it may be altered 1 costs for this job will be analysed in detail of job and ation 2 costs analysed at job level 3 costs analysed at branch level Y N If a job consists of one or more than one operation s you must enter Y in this field Job Costing User Guide ESTIMATING LEVEL EXP PROFIT LEVEL REFERENCE REFERENCE QTY DETAILS OK Level 3 TITAN 2000 1 digit A 8 is mandatory for this program No other entries may be made Enter the level at which profits are to be monitored 1 at job level 2 at operation level 8 characters Accept
26. DELETE JOB FROM TO Variable length Enter or scan for the alternate sequence number using F1 to scan in the selected alternate scan sequence and F5 to toggle the scan between alternate sequence and order number sequence All the records selected will be linked to the newly defined alternate sequence 122 JULY 2006 Job Costing User Guide TITAN 2000 4 4 COST CATEGORY MAINTENANCE JC32 This program is used for adding amending and deleting cost category codes and updating job cost analysis codes Cost categories are used to allocate and analyse the job costing transaction input into user defined categories labour costs set up costs etc The cost categories may also be linked to the General Ledger system The categories file maintains twelve monthly totals per category Enter JC32 to select the program These codes are also used in the Estimating system and if they have been set up there do not need to be repeated in Job Costing The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 UPDATE 1 Job Cost Category codes 2 Job Cost analysis Select the required code to be maintained JC Maintenance JULY 2006 4 123 TITAN 2000 4 4 1 ENTERING COST CATEGORIES After selecting 1 JOB COST CATEGORY CODES the program prompts for the cost category code CATEGORY 4 charac
27. CAPE TOWN J104 0040 2 LABOUR CATG LAYING CLASS SUNDRY SALESMAN PRODUCT GROUP 1 SET TIME RATE RUN TIME RATE OVERHEAD 25 00 I 0000 1 HOUR TOTAL SUGGESTED SALES EXPECTED PROFIT 9 E2 OP DETAILS UPDATE ESTIMATED PLANNED COSTS SET TIME SET RATE TOGGLE PERIOD 10 CONSTRUCTION PROJECT INTER CIT FOUNDATIONS LABOUR JOB COST CATEGORY LABOUR TOTAL 535 0000 CALCULATED OP OHD 0 0000 JOB TOTAL OUS S00 EID SCAN 9 4 digits Enter the number of time units required to set up this job operation combination 9 4 digits This rate is duplicated from the cost category or WP code specified previously A calculated set up cost field is displayed but not available for entry RUN TIME RUN TIME RATE 9 4 digits Enter the number of time units required to set up this job operation combination 9 4 digits This rate is duplicated from the cost category or WP code specified previously JULY 2006 4 113 JC Maintenance TITAN 2000 OVERHEAD f 9 4 digits This represents a contingency overhead to be added to the costs of the specific operation TOTAL 9 4 digits This is a calculated field and is not available for entry The formula is setup time x rate run time x rate overhead cost CALCULATED COSTS LABOUR TOTAL 9 4 digits This is a calculated field and displays the total estimated labour cost CAL
28. CUSTOMERS CO BR yi 021 CUSTOMER 1000 JANES ELECTRICAL SUPPLIES STATUS 6 IN PRODUCTION START DATE 92 02 27 END DATE ANALYSIS LEVEL 1 1 woe Ole 2 JOB 3 BRANCH SPECIFY OPERATIONS ESTIMATING LEVEL 3 D NONE 1 JOB 2 TRANS 3 ITEM EXP PROFIT LEVEL 2 iL ROS 2 UP REFERENCE REFERENCE QTY FID JOB ESC EXIT HOW TO SCAN FOR A JOB CODE Press F1 for a job number scan Enter a starting job number followed by F1 and a partial scan will start from that job number will be given Press F5 for a scan of the project codes Enter a starting project code followed by F5 and a partial project code scan will start from that point After entering or scanning for a job code press Enter to access the enquiry detail When you have looked at the details you may press F10 This will allow you to return to the previous level and scan for further jobs However if you press Enter you will be able to scan for operations pertaining to the current job OPERATION 4 characters Use the F1 key to scan for the operation you need of enter the number if you know it 5 146 JULY 2006 Job Costing User Guide TITAN 2000 Once you have accepted the code a screen will display as below showing operation header details JOB COSTING JOB OPERATION HEADER ENQUIRY JSS 1 00 01 TECHNOLOGIES INCORPORATED BR Dl CAPE TOWN PERIOD 12 OP HEADER DETAILS JOB FL1 FIRST FLOO
29. DIU 136 135 SETUP dl eee eects s 136 M 214 E a EAEE 213 SUGGESTED SALES ctr tte ne tv d vie eap eed p agendo 83 91 112 114 SUPERSESSIONS A 190 SYSTEM BETAILS DER e rab rete nore ais a a eee ed RE RR 12 SYSTEM PARAMETER FILE 11 T TEMPLATE COMPLETE INVOICED STATUS esses tne trennen tenni 200 ausser aid 106 e TITAN SYSTEM dselc CATEGORY anaa aE aaa ai aai e m 177 LU MD 149 152 155 161 173 E 168 174 0 166 177 TODAY S DATE ite nitent iet ite idee EUER CE dv n EHI aoe at DR 197 HIER 82 91 112 114 TOTAL AGTUAL SALES corretti rti E ertet doe 200
30. E 50 52 99 100 204 215 TOTAL ESTIMATED s rictus eat eae es 199 TOTAL ESTIMATED SALES 200 TOTAL QUANTITY eicere etn ree ete EY ELE ve RU navy dv dad evened eR te HER Ee eR Re 215 TOTAL UNIT nri entere e tn cte eere tr icr coa ni cd ea e de eoe 89 97 TOTALS HY 125 TRAILER 196 TRANG 66 70 73 80 88 108 TRANSAC HON DATE rinde eerte tnr rr der 156 166 TRANSACTION 2 a oet em re madre rene ean rende 180 183 TRANSACTION DATES eret nerit t ett tonio ins DEL IE 177 TRANSACTION DESCRIPTIQN 22 ied ie tetuer et evened cient tL iae Da De dene alee 202 TRANSACTION DETAILS ceste oa siete at th tena ath ach evi ated 155 TRANSAGTION LEV EL eint eere eer er trea t ie ended dated 185 TRANSACTION ettet tet ertet eene tr tein tide dene 45 47 94 96 128 155 166 202 TRANSACTION TYPE 4 TO 9 iet nteger tree eret tnde Pg itte e Petr Uri wai puteus Lr 214 TRANSACTION TYPES TO 9 QTY ict Git eatin had tette it rt pneter estere tege ceterae eu aes 213 TRANSACTIO
31. If the transaction type selected on the batch header was 2 Transaction Capture the following will be presented for entry SCRAP QTY 7 2 digits If a record of scrap quantities is to be kept enter the scrap quantity pertaining to this transaction here SCRAP COST 7 4 digits Enter the value relating to the scrap quantity if applicable This field represents the total cost of scrap for this transaction Accept the entries or correct any of the fields The status line displays all the options available JC Input JULY 2006 TITAN 2000 JOB COSTING JOB COST INPUT JC10 11 008 01 TECHNOLOGIES INCORPORATED Be Dl CAPE TOWN PERTOD 10 BATCH 1 LINE 1 NOT ON FILE JOB pacai FIRST FLOOR PRIVATE BATHROOMS OPERATION PLAN PLANNING WITH PROJECT MANAGER TRANSACTION TYPE 2 LABOUR CLASS LABOUR CATEGORY 1000 LABOUR COSTS EMPLOYEE 00010 RICHARDSON WP CODE 1 BASIC PAY WORK CENTRE MANUF 1 USAGE 0 00 PERIOD 10 DOC DATE 92702721 REFERENCE WED 18 3 DIVERSION 1 HOURS BOOKED 0 0000 TYPE R R RUN i 12 RATE 12 0000 1 SCRAP ORO Om TOTAL COST 0 0000 ACTUAL SCRAP COST 0 0000 NARRATIVE TO DECIDE WHETHER WHITE BLUE DETAILS OK Y FACTORY PLANNING COSTING ACCEPT 4 REVIEW BATCH HEADER ESC EXIT Level 4 a For all LABOUR transaction types the following entries apply HOURS BOOKED 7 4 digits This represents the number of units pertaining
32. JOB COSTING JOB TEMPLATE INPUT TITAN 2000 JELO 11 003 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN JOB HEADER DETAILS JOB DESCRIPTION PROJECT CUSTOMERS CO BR CUSTOMER STATUS START DATE END DATE CATG ANALYSIS LEVEL SPECIFY OPERATIONS ESTIMATING LEVEL EXP PROFIT LEVEL REFERENCE REFERENCE QTY DETAILS OK Y N UPDATE JOB CUSTOMER STATUS START DATE END DATE CATG ANALYSIS LEVEL SPECIFY OPERATIONS JC Input TMP 1 FERIOD 10 TEMPLATE FOR HOTEL FLOORS 1 4 HOT1 01 01 9004 RAILWAY HOTEL PRIVATE BATHS HOTELS INCORPORATED IN PRODUCTION 1 OP 2 3 BRANCH 0 NONE 3 LITEM 900 M NOH 2 TRANS 2 e DP ESC EXIT 6 characters This number will be validated against the customer masterfile if validation has been selected in program JC00 System Record Maintenance 1 character Enter a valid status code as defined in program SU31 Descriptions File Maintenance type JS or leave this field blank DD MM CCYY The current date is displayed in this field which is not available for entry DD MM CCYY The current date is displayed in this field which is not available for entry 1 Costs for this job will be analysed in detail of job and operation This is important if you wish to use JC78 Cost Category Report as a summary posting to General Ledger 2 Costs analysed at job level 3 Costs an
33. System and if they have been set up there do not need to be repeated This program is used to enter and maintain the description codes and descriptions for each description type Description file codes and their corresponding descriptions can be entered for the following Most of the description types created by the system are optional JP Job costing project codes Mandatory Jobs may be allocated to project codes for various reporting and analysis purposes Enter and define the range of project codes and project descriptions JS Job status codes Mandatory Jobs may be allocated to status codes for various reporting and analysis purposes Enter and define the range of status codes and status descriptions in i iti JC Set up and Run JULY 2006 2 9 TITAN 2000 STEP PROGRAM FUNCTION AND PROCEDURE 4 SU32 The Numbers File Maintenance program will set up and maintain Mandator the Job Costing audit number in the system J For the next Job Costing audit number i For the next Job Costing Invoice number For the next job costing Credit note number 5035 The Customised Forms Maintenance program will set up and Mandatory maintain the requisition print layout which is used by program JC73 Requisition Notes Set up the requisition layout form type JC Refer to Appendix B for further information The Descriptions File Print program prints the details entered into the Descriptions file Check the report against the data
34. TOTALS JC74 Cost Type by Job 6 162 JULY 2006 Job Costing User Guide TITAN 2000 6 7 SCRAP ANALYSIS JC75 The program prints an analysis of scrap quantities and costs It gives the option to print by job operation or by transaction If the option to print by job operation only is selected those operations that have a non zero scrap quantity or cost will be printed Enter JC75 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide JOB COSTING SCRAP ANALYSIS wens 11 001 01 TECHNOLOGIES INCORPORATED BR DI PERIOD 10 ANALYSIS BY E 1 TRANSACTIONS 2 OPERATION FROM DATE 1998 08 23 TO PROCEED WITH PRINT 3 HOR EERTE ONS ii eoyisis Level 1 ANALYSIS BY 1 Transactions 2 Operations If Option 1 is selected the following information must be entered DATE RANGE SELECTION Enter the required from and to dates or accept the default on the screen These are always the current date less one month as start date and the current date as end date JC Print JULY 2006 6 163 TITAN 2000 If Option 2 is selected the following information must be entered JOB OPERATION RANGE Enter the appropriate range It is possible to scan all the jobs on the file using the F1 key The F5 key will toggle the scan between
35. USE UNIT COST UOM UPDATE INVENTORY FILES Y N INVENTORY TRANSACTIONS 1 2 PRODUCT UOM CODES P UNIT OF PURCHASE gt UPDATE Fo DELETE DEFAULT COST CATEGORY PRODUCT CO PRODUCT BR PRODUCT DEFAULT WH USE UNIT COST UOM JC Maintenance i Y 0 0 0 7 yY 1 H UNIT OFE KOLD F10 TRANSACTION TYPE PERIOD 10 1 INVENTORY INV 1 1 MATERIAL USAGE 2 LABOUR 3 COMPUTED OVERHEADS OTHER SUNDRY JOB COST CATEGORY AVERAGE COST UNIT OF HOLD 1 TSS IERI 2 INV CRN IL NEST OR S S UTER ESC gt EXIT 4 characters Enter the default cost category for this transaction type These categories are set up in program JC32 Cost Category Maintenance 2 digits 2 digits 2 digits An entry will only be required if the Inventory System Parameter Record indicates that warehouses are used 1 digit The various values held on the stock file are displayed Enter the one you wish to use as the unit cost for your jobs This will be used as the default value for the RATE used when capturing operations P unit of purchase H unit of hold I unit of issue JULY 2006 4 131 INVENTORY FILES INVENTORY TRANSACTIONS Level 3b INTERFACE TO WAGES TITAN 2000 Y N If this is Y and you specified in JC33 Transaction Type Maintenance that you wish to interface to stock then JC10 Job Cost Input will update your inventory issu
36. batch total total amount entered the computed values and the difference To correct an imbalance situation either input the correct batch total or review the entries and correct the data as required For extreme circumstances the selection of F8 will cancel the batch and return to the header screen or terminate the program with the Esc option BATCH COMPLETED When the balanced batch is complete press F3 the files are updated The program will then prompt for further batches to be entered End the program by pressing F10 to return to the previous menu 3 100 JULY 2006 Job Costing User Guide TITAN 2000 4 MAINTENANCE MODULE 4 1 THE MAINTENANCE MODULE MENU This module consists of the following programs JC30 JOB OPERATION MAINTENANCE JC31 ALTERNATE FILE MAINTENANCE JC32 COST CATEGORY MAINTENANCE JC33 TRANSACTION TYPE MAINTENANCE JC35 WORK CENTRE MAINTENANCE The Job Operation Maintenance program is a multi purpose program which is used for adding and amending jobs and their associated operations The Cost Category Maintenance program is used for adding amending and deleting cost category codes and may be used Transaction types up to 9 may be user defined This program provides both long and short descriptions for each transaction type as well as its class and other attributes used for interfacing to other modules Standard data for each work centre may be captured using the work centre mainte
37. calls program SP91 Interface to AR and SA picks up all invoiced orders from the SP module C JC10 Job Cost Input post actual costs Billed Costs These reflect billed amounts updates Accounts Receivable via Sales Order Processing and are posted to Job Costing in a batch via program JC91 SP Updates to Job calls program SP91 Interface to AR and SA NOTE If you run program JC10 Job Cost Input to perform these postings then you may now select whether to post directly to a specific job or to do postings in batch mode POSTING AND UPDATING OF COSTS 1 Committed Costs o The Job Masterfile JCMAST is read and the posted amount is added to the committed cost for the job o The Job Operations File JCOPRN is read at the level specified on the Job Masterfile If an operation record is not found and the program CREATE OPERATIONS option is set then an operation record is created with zero estimates and the posted amount added to the committed cost for the operation If the operation existed then the posted amount is added to the committed cost for the operation 9 Ifthe 9 00 CREATE TRANSACTIONS FOR COMMITTED COSTS option is set then a transaction record will be written to the History File JCHIST 2 Actual Costs o The Job Masterfile JCMAST is read to obtain job details o The Job Categories File JCANAL amp DESCRIP is read to obtain category details and standard costs for the specific catego
38. 00 System Record Maintenance The options are e default to zero e default to Job Op template costs e default to current JC33 Transaction Type Maintenance default unit cost TOTAL COST 9 4 digits This field is not available for entry It is a calculated field using the two values entered above This entry will display COMMITTED ACTUAL or BILLED depending on the transaction type selected on the batch header SALES VALUE 7 4 digits This field is only available when entering billed amounts NARRATIVE 30 characters Enter a meaningful narrative This will be printed on JC80 Audit Trail 3 50 JULY 2006 Job Costing User Guide JOB COSTING JOB COST INPUT TITAN 2000 JC10 11 008 01 TECHNOLOGIES INCORPORATED Be Dl CAPE TOWN BATCH 1 JOB OPERATION TRANSACTION TYPE CATEGORY PRODUCT WORK CENTRE PERIOD DOC DATE REFERENCE DIVERSION OTY RATE TOTAL COST NARRATIVE DETAILS OK PERIOD 10 LINE 1 pact INST NOT ON FILE FIRST FLOOR PRIVATE BATHROOMS INSTALLATION a INVENTORY CLASS MATERIAL USAGE 7000 MATERIAL COSTS INSTALLATIONS 001 1WB WIT 46 1 WHITE CASCADE HANDSHOWER SPIRA MANUF2 1 USAGE 0 00 HOUR 10 92 7 92 72 11 WED 18 3 10 0000 20 0000 200 0000 ACTUAL TO DECIDE WHETHER WHITE BLUE Y EACH SCRAP SCRAP COST 30 1 6 0000 1 4 REVIEW 10 BATCH HEADER ESC EXIT
39. 5 PER HOUR T oe OF TOTAL PER HOUR PER HOUR AREA MAINT TRANSACTION TYPES 1 INVENTORY OTHER SNOW SED 2 LABOUR LAB NOT WP 8 NOT USED 3 CALCD OHD NOT USED NOT USED UPD FS DEL WORK CENTRE ESC EXIT 3 138 JULY 2006 Job Costing User Guide TITAN 2000 4 6 2 UPDATING WORK CENTRES Proceed through the steps required for entering 4 6 2 but now enter the work centre to be updated Scan or partially scan using F1 for the required work centre Any or all of the fields may be altered On completion of the update press F3 to update the file or press F10 to end the program at this point and leave the data unchanged JOB COSTING WORK CENTRE MAINTENANCE Jess 11 001 01 TECHNOLOGIES INCORPORATED BR Dl CAPE PERIOD 10 WORK CENTRE MANUF WORK CENTRE DESCRIPTION STD LABOUR STD SET UP MANUF lt gt FACTORY PLANNING COSTING 8 MANUF 1 PURCHASING MANUF 2 STOCK CONTROL MANUF 3 ORDER ASSEMBLY MANUF 4 TRANSPORT SITE HOT SPRING SITEI J J MARTIN SCHOOL s INTO ICES Bl SCAN FILE DEFAULTS 10 CO BR ESC EXIT 4 6 3 DELETING WORK CENTRES Proceed through the steps required for entering 4 6 2 but now enter the work centre to be deleted Scan or partially scan using F1 for the required work centre Press F8 to initiate deletion or Esc to end the pr
40. 7000 MATERIAL COSTS INSTALLATIONS PRODUCT BIN UOM OTY 001 1WB WIT 46 0000 EACH WHITE CASCADE HANDSHOWER SPIRA EXISTING OP SCAN FREE TOTAL REQD OTY ISS OTY OUTST UNIT PRICE 6 00 0 00 0 00 99959899 25 600 0000 CAG PRODUCT EMP COD QTY idm OTY scs QTY OUT RR UNIT PR SR 1 7000 lt gt 001 1WB WIT 46 0 00 99959999 INVENTORY WHITE CASCADE SPIRA B 25 2 TOE DETAILS UPDATE ESTIMATED PLANNED COSTS EMPLOYEE WP CODE SET UP TIME SET UP RATE TOGGLE Fo DELETE EID SCAN If the transaction type entered was labour the employees as entered on the template in program JC20 Job Template Input will be displayed The F5 key may be used to toggle in the following sequences employee number sequence or existing operation sequence Lines may be added or deleted as required 4 characters Accept the default code or entered the required one The labour rate will be read from this code and used as a default 9 4 digits Enter the number of time units required to set up this job operation combination 9 4 digits This rate is duplicated from the cost category or WP code specified previously A calculated set up cost field is displayed but not available for entry JULY 2006 Job Costing User Guide TITAN 2000 RUN TIME 9 4 digits Enter the number of time units required to set up this job operation combination RATE 9 4 digits This rate is duplicated from t
41. COMPLETE INVOICED STATUS LINE COLMN DGT DEC IS THE ABOVE INFORMATION CORRECT Y N 1 F2 PREVIOUS F3 SAVE F8 DELETE F9 PRINT 10 FORM ESC EXIT QUANTITY REQUIRED JOB STATUS COST OF BILLED AMOUNT PROFIT PROFIT PERCENTAGE PERCENTAGE COMPLETE TOTAL ESTIMATED COST 7 2 digits The number of jobs of the same nature to be done This will be read from the masterfile record 1 character The current status will be read from the job masterfile 9 2 digits The cost of the amount that has been billed 9 2 digits This is calculated as the difference between the estimated cost and the price quoted 3 4 digits This is the same as the above but expressed as a percentage 3 2 digits This is the total cost to date expressed as a percentage of the estimated cost 9 4 digits This is the total estimated cost of all the transaction types This will be read from the job masterfile Appendix 199 TOTAL ESTIMATED SALES TOTAL ACTUAL SALES DEBTORS ADDRESS ADDRESS 1 ADDRESS 2 ADDRESS 3 POST CODE REFERENCE REFERENCE VALUE TEMPLATE COMPLETE INVOICED STATUS Appendix 200 TITAN 2000 9 2 digits This is the total estimated sales of all the transaction types This will be read from the job masterfile 9 2 digits This is the total actual sales of all the transaction types 25 characters This will be read from the debtors masterfile 20 character
42. Costing User Guide DESCRIPTION WORK CENTRE START DATE END DATE SCHEDULED Y N ACTIVE YIN STATUS PRO RATA PERCENTAGE DETAILS OK Y N JC Input TITAN 2000 30 characters Enter a description for this operation 8 characters scan is available as aid but this field may be left blank DD MM CCYY DD MM CCYY Entry of these two dates will only be requested if this option has been selected in program JC00 System Record Maintenance Y N This field is for memorandum purposes only Y N This field is for memorandum purposes only 1 character A scan on this field is available but this field may be left blank 3 2 digits This percentage is used by program JC96 Operations Activate See also 9 00 System Record Maintenance for more information Y N Enter Y to proceed to the next level JULY 2006 3 79 TITAN 2000 Level 4 JOB COSTING JOB TEMPLATE INPUT Jee Oey 005 01 TECHNOLOGIES INCORPORATED Be 001 CAPE TOWN PERIOD 10 JOB OP TMP1 INST TEMPLATE FOR HOTEL FLOORS 1 INSTALLATION TRANS 1 INVENTORY CLASS SET CLASS JC33 CATG 7000 MATERIAL COSTS INSTALLATIONS FREE TOTAL PRODUCT BIN UOM QTY REQD OTY ISS OTY OUTST UNIT PRICE 001 1WB WIT 46 BR SITK SEQ PRODUCT DESCRIPTION AVERAGE COST 001 1WB WIT 46 WHITE CASCADE HANDSHOWER SPIRA OO1WIT46 WHITE CASCADE HANDSHOWER ADJ 005 5WIT 46 WHITE SPIRAFLEX TUBE BLACK CON 006S 20 WIT 0070 SELECT
43. EE 75 CUSTOMERS eA LEE 76 85 103 D DAILY amp WEEKLY CYCLES tete itd eas ed d 25 Bm 57 DATE RANGE SELEG IQN 2 ctr iter eie nre rear eee pr ED Pr RUE cere e RE aai 163 DEBTORS BRANCH 198 DEBTORS BBANGH DESCRIPTION icut rr ete Petre dea mereri Og mene nian 198 DEBTORS COMPANY critt terere dece anre 198 DEBTORS COMPANY DESCRIPTION recette andi ain athe tea dee ee Eee n deoa 198 DEBTORS H 198 DEFAULT CATG ANALYSIS LEVEL etri ite ttn et eed ett ead etin 17 DEFAULT FROM XOB asciende dte te ree nete erepto ERE Td 17 DEFAULT COST CATEGORY i i titer ettet tette ter eter utet ete cnn eiae 130 131 132 DEFAULTESTIMATINGEEVEL rrr eed ar oen dip n ied 17 DEFABLTEXP PROEITIEEVEDS tud HERD 17 DEFAULT FORM FOR JG 30 eerte ecce Peter t scie eue NR te aS de ec a ORA Leve a 18 Index 217 DEFAULT FROM IV Ee ee ae a 22 DEFAULT UNIT COST ol LL 15 DEFAULT WPJ CODE 133 DEFINITION OF FORM TYPE errem reet deni eee eer 194 B Lc C
44. EXP PROFIT LEVEL REFERENCE REFERENCE QTY DETAILS OK Y N UPDATE 10 CUSTOMER CUSTOMER ORDER STATUS START DATE END DATE CATG ANALYSIS LEVEL 3 104 FLI PERIOE 10 FIRST FLOOR PRIVATE BATHROOMS HOT1 01 01 9004 RAILWAY HOTEL PRIVATE BATHS HOTELS INCORPORATED IN PRODUCTION i gos Ae 2 OB 3 BRANCH NONE 1 405 2 TRANS 3 ITEM iL aos 2 ESC EXIT 6 characters This number will be validated against the customer masterfile if validation has been selected in program JC00 System Record Maintenance 15 Characters Enter a customer order number if required 1 character Enter a valid status code as defined in program SU31 Descriptions File Maintenance type JS or leave this field blank You can use the scan facility DD MM CCYY The format of the date will be as specified in program 5030 Installation Maintenance DD MM CCYY The format of the date will be as specified in program 5030 Installation Maintenance Entry of these two dates will only be requested if this option has been selected in program JC00 System Record Maintenance 1 Costs for this job will be analysed in detail by job and operation 2 Costs analysed at job level 3 Costs analysed at branch level JULY 2006 Job Costing User Guide SPECIFY OPERATIONS ESTIMATING LEVEL EXP PROFIT LEVEL REFERENCE REFERENCE QTY DETAILS OK
45. FL4 STAFF BATHROOMS TOILETS 01 01 FL5 01019004 FL5 TEMPLATE FOR HOTEL FLOORS 01 01 TMP1 01019004 TMP1 TEMPLATE FOR HOTEL FLOORS mo INTO MORER TEMSES Fl SCAN ES SEO Fb CODES EDU ALT SEO HOW TO SCAN FOR A JOB CODE Press F1 for a job number scan Enter a starting job number followed by F1 and a partial scan will start from that job number will be given Press F5 for a scan of the project codes Enter a starting project code followed by F5 and a partial project code scan will start from that point After entering or scanning for a job code press Enter to access the enquiry detail JC Enquiry JULY2006 5 14 TITAN 2000 Level 1 JOB COSTING JOB OPERATION ENQUIRY SO LOO CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN 10 JOB FL1 FIRST FLOOR PRIVATE BATHROOMS JOB LEVEL ACTUAL COST DETAILS CUMULATIVE INVENTORY 560 0000 LABOUR 0000 CALCD OHD o 8000 5 5 0000 LAB NOT WP 0000 NOT USED o o 0000 NOT USED o 0000 NOT USED 5 0000 NOT USED TOTAL Fl SCAN FILE FS TOGGLE FID JOB ESG c EXILE The initial job enquiry screen is displayed showing the month to date year to date and cumulative costs to date for each of the nine transaction types FUNCTION KEY FACILITIES F1 FORWD View the cumulative standard or actual costs the original estimates the variance and the cost to complete the job F7 ALT to chan
46. JC Maintenance TITAN 2000 Y N If a job consists of one or more than one operations Y should be entered in this field 0 none If no estimating is to be done no screens will be presented for entry of estimated costs 1 at job level If this option is selected level 6 will be presented for entry of estimates 2 at transaction level If this option is selected estimates may be entered at transaction level within operation for instance labour and material costs may be estimated separately 3 at item level The selection of this option will allow estimates to be made at employee and employee code level as well at product or costing code level Options 2 and 3 will only be present if Operations were specified Once entered these options cannot be changed Enter the level at which profits are to be monitored 1 at job level 2 at operation level only appears if operations have been specified 8 digits Memorandum fields 7 2 digits Memorandum fields Y N Accept the details entered to proceed to the next screen or amend any incorrect details JULY 2006 4 105 TITAN 2000 If your cursor is positioned on this screen and you have specified a default form for program JC30 Job Operation Maintenance in 00 System Record Maintenance you will be able to press F9 and print job card according to specifications set up in program 5035 Customised Form Maintenance FORM TYPE TEST
47. JOBS OPERATIONS Enter data into the following job masterfile fields Level 1 JOB 4 characters digits depending on the definition in program System Record Maintenance End each input by pressing Enter or by filling the field with data If an error is made use the arrow keys to move back to the field and re enter the data Use the backspace key if an incorrect character or digit is entered Not all the fields displayed on the screen are mandatory Enter data only into those fields that are applicable Press F3 at any point in the data entry to end data input and update the file Level 2 DESCRIPTION 30 characters PROJECT 4 characters digits depending the definition in program System Record Maintenance A scan of project codes is available as an aid If a code is entered which has not been created using program 6031 Descriptions File Maintenance type JP then this code will be rejected for entry CUSTOMERS CO BR 1 2 digits 2 digits Enter the specific company and branch against which customer numbers are to be validated or use the scan facility JC Maintenance JULY 2006 4 103 TITAN 2000 JOB COSTING JOB OPERATION MAINTENANCE 11 003 01 TECHNOLOGIES INCORPORATED BR CAPE TOWN JOB HEADER DETAILS JOB DESCRIPTION PROJECT CUSTOMERS CO BR CUSTOMER CUSTOMER ORDER STATUS START DATE END DATE CATG ANALYSIS LEVEL SPECIFY OPERATIONS ESTIMATING LEVEL
48. Labour Calculated OHD Transaction Transaction Transaction Transaction Transaction Transaction type type type type type type COLMN DGT DEC IS THE ABOVE INFORMATION CORRECT Y N FI NEXI F2 PREVIQUS FS DELETE F9 PRINT 10 FORM ESC EXIT The following refer to total costs for all transactions on this requisition STOCK LABOUR CALCULATED OHD TRANSACTION TYPE 4TO9 Appendix 214 9 4 digits This is the total planned cost for the job for transaction type 1 9 4 digits This is the total planned cost for the job for transaction type 2 9 4 digits This is the total planned cost for the job for transaction type 3 9 4 digits These are the total planned costs for the job for transaction types 4 to 9 TITAN 2000 TRAILER 3 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE Sus 11 001 TRAILER 3 JOB COSTING SOFT FORMS FONT LINE COLMN DGT DEC TRANSACTION DETAILS TOTAL QUANTITY I d at TOTAL COST te J SIV 1 IS THE ABOVE INFORMATION CORRECT Y N 1 F2 PREVIOUS F3 SAVE F8 DELETE F9 PRINT 10 FORM ESC EXIT TRANSACTION DETAILS These details print transaction details on the trailer TOTAL QUANTITY 9 4 digits The total of all transaction quantities for the job TOTAL COST 9 4 digits The total of all transaction costs for the job SIV 6 digits
49. REPORT TYPE PRINT DIVERSIONS DIVERSIONS ONLY FROM JOB OPERATION TO JOB OPERATION 6 174 1 digit Enter 3 in the report type field to print category totals for those jobs assigned to analyse level 2 job level in program JC30 Job Operation Maintenance The analysis level may be amended using program JC32 Cost Category Maintenance Y N Y to include categories set up as diversions in program JC32 Cost Category Maintenance N to exclude diversions Y N Y to exclude categories not set up as diversions in program JC32 Cost Category Maintenance N to print all categories The default is all jobs and operations or enter the starting and ending job operation range JULY 2006 Job Costing User Guide PERIODS PROCEED WITH PRINT JC Print TITAN 2000 1 Current period 2 Periods 1 through 6 the default 3 Periods 7 through 12 Y N Press Enter to accept the selections or enter N to enable changes to be made The Esc key will end the program JULY 2006 6 175 TITAN 2000 6 11 WORK CENTRE PRODUCTIVITY JC79 This is a specialised report which details employees productivity levels In order to use this you must enter employee numbers for work centres in JC35 Work Centre Maintenance and their names in the description field The STD HOURS field must also be completed for each employee The report will print details as below Work Centre Standard Actual hours O
50. Range of project Update a range of project analysis codes Select the type of item for which analysis codes are to be updated The program then prompts for a range of job or project numbers Press F1 to scan the file On a range selection the program pre loads the beginning of the range FROM field To enter the end of the range TO field press Enter and re scan the file or enter the end of range code Level 3 The job project details and analysis code are displayed for the first selected job project within the range ITEM ANALYSIS AT 1 Job Operation level 2 Job level 3 Branch level Amend the analysis code as required and press Enter to update When updating a range of jobs projects each following job project is automatically displayed until the end of the range is reached JC Maintenance JULY 2006 4 127 TITAN 2000 4 5 TRANSACTION TYPE MAINTENANCE JC33 The program enables up to nine different transaction types to be selected These types may be linked to various classes of transactions material usage labour etc They may also be optionally linked to other systems such as Inventory or Payroll These codes are also used in the Estimating System and if they have been set up there do not need to be repeated in Job Costing Enter JC33 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the
51. These records are written to the archive file by program JC90 Month End Cleardown provided the option is set JC00 System record Maintenance Enter JC98 to select the program COSTING SELECTIVE ARCHIVE DELETION mee 01 TECHNOLOGIES INCORPORATED BR DI CAPE TOWN PERIOD 06 PROJECT FROM SEQ TO 1 END DATE FROM LO MOC 992 08 25 DETAILS OK Y N Y SCAN ES gt TOGGLE DIO CO BRY ESC EXIT PROJECT FROM TO 4 characters The default is all projects or enter the start and ending range You may use the F1 key to scan for projects on file If you use the F5 key you may toggle the scan between the job number and project number sequence END DATE FROM TO DD MM CCYY Enter the date range for which you want to delete jobs DETAILS OK Y N Y N Accept the details for the specified jobs to be deleted or press Esc to exit the program without any deletions taking place JC SetupandRun JULY2006 2 4 00 TITAN 2000 2 14 UPDATE TEMPLATE SUPERSESSIONS JC99 This program allows you to update all superseded items on your templates with their relevant supersessions Where a supersession already exists as a line item on the template a warning will be given on the resulting audit trail and you will have to update the template manually You will have to delete the superseded item s and update the supersession with the re
52. beginning of this user guide JOB COSTING TRANSACTION TYPE MAINTENANCE ess MOOL 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 TRANSACTION TYPE 1 CODE DESCRIPTION 0001 gt INVENTORY 0002 LABOUR 0003 CALCD OHD 0004 OTHER 0005 LAB NOT WP 0006 NOT USED 0007 NOT USED 0008 NOT USED 0009 NOT USED imdL SOAN D10 CO BSC Level 1 TRANSACTION TYPE E 1 digit Enter a code or press F1 to scan the file The following pages describe how to set up transaction types 3 128 JULY 2006 Job Costing User Guide TITAN 2000 4 5 1 CREATING TRANSACTION TYPES JOB COSTING TRANSACTION TYPE MAINTENANCE Jesa Lil Ooi CO DI TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN TRANSACTION TYPE LONG TERMINOLOGY SHORT TERMINOLOGY CLASS INTERFACE WITH IV UPDATE FS DELETE Enter the following fields LONG TERMINOLOGY SHORT TERMINOLOGY CLASS JC Maintenance PERIODO 10 1 INVENTORY MATERIAL USAGE LABOUR COMPUTED OVERHEADS OTHER 1 2 E 4 FIO TRANSACTION TYPE ESC EXIT 10 characters This is the description which the system will use from now on to describe this transaction type 4 characters Sometimes an abbreviation will be used by the system Enter this here 1 Material usage 2 Labour 3 Computed overheads 4 Other JULY 2006 4 129 TITAN 2000 JOB COSTING TRA
53. combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide JOB COSTING SELECTIVE TRANSACTION DELETION BeOS LLO 01 TECHNOLOGIES INCORPORATED BRE O01 CAPE TOWN PERIOD 10 PROJECT FL1 FIRST FLOOR PRIVATE BATHROOMS DOC DATE DP IQDUASD TYPE 1 INVENTORY REFERENCE QUANTITY 17 000 COST 320 0000 ES DELETE BIN NEAT JOB ESC EXIT Level 1 PROJECT FROM TO 4 characters Enter the project for which transactions are to be deleted The first transaction and its details will be displayed Press Enter until the required transaction is displayed and then press F8 The transaction will be deleted Only the transaction is deleted no costs on the category file or job files are affected 1 36 JULY 2006 Job Costing User Guide TITAN 2000 2 11 ACTIVATE OPERATIONS JC96 The program performs the following functions e It will optionally activate all or selected operations for a specific job e It will calculate the pro rata percentage cost or sales of operations in relation to total costs or sales per the job as a whole Enter JC96 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide JOB COSTING OPERATIONS ACTIVATE Vee 11 001 01 TECHNOLOGIES INCORPORATED BR Dl CAPE T
54. digits This refers to the cost categories set up in program JC32 Cost Category Maintenance Scan the cost categories or enter the required one 3 108 JULY 2006 Job Costing User Guide PRODUCT SALESMAN PRODUCT GROUP EMPLOYEE TITAN 2000 If the transaction type entered was material usage and if it was indicated in program JC33 Transaction Type Maintenance that an interface to the Inventory Module is required the operator will have to enter a valid product in this position If this item has been superseded and it is a date type supersession and that date has been reached and you have not specified an automatic action to be taken in program 1 00 System Record Maintenance you will now have to select the appropriate option Depending on the IVOO option a supervisor password may be required If the supersession is a zero quantity type action will only be taken after you have entered the quantity Please refer to Appendix A3 for more information 4 Characters Enter or scan for a sales person This may be left blank 4 Characters Enter or scan for a product group This may be left blank If the transaction type entered was labour and if it was indicated in program JC33 Transaction Type Maintenance that an interface to the Wages module is required the operator will have to enter a valid employee number in this position Press F3 to accept the entry and display the next screen SCAN FACILITIE
55. if you need to but you may NOT add any new lines You may also reject an automatically created line and change back to selectively keying in item lines The quantity per item is calculated according to a dedicated formula entered in the System Utilities module program SU37 Formula Maintenance NOTE If no formula exists then the system defaults to using the pro rata percentages stored per operation These percentages are automatically calculated in program JC96 Operations Activate by using the dedicated formula If the formula does not exist then the pro rata percentage is calculated as the total operation estimate as a percentage of the total job estimate Each item line created on a pro rata basis will have a non print indicator Rounding caused by pro rata calculation will be put into the last operation item line record Appendix 188 TITAN 2000 EXAMPLE oe stock Operation 1 Operation 2 Operation 3 Appendix 189 TITAN 2000 SUPERSESSIONS Supersessions are treated in a uniform manner across all Titan applications Titan deals with two types of supersessions The first is a Date type This will mean that from a certain date a product should no longer be used but its supersession should be used The second type is a Zero quantity type This means that the supersession will come into play once the quantity of the superseded item is zero and is date independent Superseded items and their super
56. is accurate and press Enter or F1 to proceed to the next level HEADER Line 999 to 999 BODY Line 999 to 999 TRAILER Line 999 to 999 HEADER DETAILS Header detail screens will be presented until all header information has been specified Only then will the detail screens be presented In each case below we give you the maximum length of the field to be printed We display this immediately after the prompt You will notice that there are two fields next to each numeric field namely DGT and DEC depicted for instance as 07 02 The first figure represents the size of the whole number and the second the size of its decimal These indicate the default field size the program will use when printing the forms You may change these if you wish Remember that if you specify the size as 7 2 this field will use 11 characters when it is printed as it includes a decimal and a sign The DGT field is also used on alpha fields where you wish to print less than the maximum number of characters of a field The default is zero 0 which indicates the maximum should be printed if you wish to print fewer characters enter the number in his field Where you do not have enough space on your stationery for the total size of the field decrease this to the maximum you will hold on file Appendix 196 TITAN 2000 HEADER 1 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE Suss 11 001 HEADER 1 JOB COSTING SOFT
57. line as defined in the Job Costing System JC Input JULY 2006 3 73 TITAN 2000 CATEGORY 4 characters Enter the sales category to which this transaction line refers OR PROD f If the transaction type is linked to the Inventory Module Level 8 The credit note details entry is exactly as described for program SP17 Credit Note Entry or program SP18 Demand Credit Note Entry in the Sales Order Processing system Please refer to that User Guide for further information The program will now switch from Level 7 to Level 8 until all items have been entered If the direct printing option was selected the credit note will be printed automatically according to the parameters set up in program SU35 Customised Form Maintenance These invoices are not posted to the customers or sales analysis They merely update the actual cost and sales values on the job record in the Job Costing system 3 74 JULY 2006 Job Costing User Guide TITAN 2000 3 7 4 CUSTOMER INVOICE ENTRY This option simulates either program SP15 Batch Invoice Entry or program SP16 Demand Invoice Entry in the Sales Order Processing modules It allows the capture of invoices relating to specific jobs on the Job Costing system It optionally produces a user defined invoice This option differs from option 2 section 3 6 in that it does update the customer and sales analysis records as well as the billed amount on the associated job record You may also select t
58. of ACUCORP Inc Other brand and product names are trademarks or registered trademarks of their holders TITAN 2000 CONTENTS THE JOB COSTING SYSTEM 1 GETTING STARTED un aan ik tu kd gu cia LS d o an aw n a o id 1 1 1 HOW TO USE THIS eese ren rennen eren trn nter 1 1 2 THE TITAN SYSTEM PROFILE icc eee rcr eene eee trie ence eat 2 1 3 JOB COSTING SYSTEM eere nnt tenente et eta eee aede e nea Ett Fee 3 14 CONCEPTS AND FUNCTIONS seen nennen 7 1 5 THE JOB COSTING SYSTEM MENU eee eens cere 8 2 SET UP AND 9 2 4 SETTING UP THE 5 5 9 2 2 THE SYSTEM PARAMETER FILE MAINTENANCE 11 2 3 PROCESSING AND BACKUP 2 25 2 4 THE PERIOD END MODULE 26 241 MONTH END SEQUENCE seen nennen nnne nennen 27 2 4 2 YEAR END 27 25 MONTH END CLEARDOWN 90 7 28 2 6 SP UPDATES TO JOB 90 29 2 7 PO UPDATES TO JOB COSTING 692 31 2 8 YEAR END 693 7 nennen rennen 34 29 JOB DELETION 41G94 reete det erteilen 35 2 10 SELECTIVE TRANSACTION DELETION JC95 see 3
59. over all current contracts allowing them to react timeously to unfavourable trends e The information held by the system enables worthwhile undertakings to be identified based on past performance e The system is designed to be tailored to the company s unique requirements The following profile shows the scope and flexibility of the Job Costing system e Multiple companies An unlimited number of companies can be processed at any one time e Password protection Access to the system is fully password protected to ensure complete security over confidential information e Soft terminology The user may define the descriptive details of any project as well as the transaction type terminology to be used This information can be uniquely assigned to each company and branch within a system e Cost control values Actual or standard and committed costs are held for each transaction type e Cost category Every cost posted to a job must be categorised thus providing the information to produce detailed cost analysis across the board e Work centre control Standard set up and run costs with multiple associated overhead costs are stored for each work centre or process e Comparison to estimates Actual costs or standard costs may be compared to the original estimates at any time in the project JC Getting Started JULY 2006 1 3 TITAN 2000 e Scrap analysis Quantities and costs of scrap are stored permitting analysis by
60. program SP19 Demand Order Entry in the Sales Order Processing system Please refer to that User Guide for further information JOB COSTING CONTRACT INPUT SP19 11 029 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN WH 01 CENTRAL ORDER 000066 JOB 4 FL1 ACCOUNT 4 9004 HOTELS INCORPORATED ORD 000066 REF CUS ORD DATE 92 02 27 lt QUANTITY gt EXCLUSIVE PRODUCT ORDERED TO SUPPLY PRICE DISC SUR AMT T NET AMT 0065 20 46 S700 S700 i eS 0 Bie qe Xe TRANS 1 PROD EXISTING OP SCAN Pl SCAN FILE 2 END FLO PREVIOUS Level 7 OP 4 characters Optional This entry is only requested if the specific job has associated operations Enter the operation to which this transaction line refers TRANS 1 digit Enter the transaction type of this transaction line as defined in the Job Costing system CATEGORY 4 characters Enter the sales category to which this transaction line refers OR PROD If the transaction type is linked to the Inventory Module 3 66 JULY 2006 Job Costing User Guide TITAN 2000 Level 8 The order details entry is exactly as described for program SP19 Demand Order Entry in the Sales Order Processing system Please refer to that User Guide for further information The program will now switch from Level 7 to Level 8 until all items have been entered If the direct printing option was selected the delivery note picking slip will be printed automatica
61. quantities and prices for the line items on the invoices 4 characters Enter a salesman code if required This may be mandatory depending on the entry JCO0O System Record Maintenance JULY 2006 3 57 TITAN 2000 CUST ORDER 15 characters Enter a customer order number if required This may be mandatory depending on the entry in JCOO System Record Maintenance The last invoice number and date for this job will also display if applicable Press F6 if you wish to add any header comments DETAIL LINES You may enter or change the following details WORK CENTRE 4 characters Scan the file or enter a work centre if required You may leave this blank USAGE 5 2 digits QUANTITY 7 2 digits UNIT COST 7 4 digits SELLING PRICE 7 2 digits DESCRIPTION 30 characters CAT 3 characters Enter or scan for a sales category This may be mandatory depending on the entry in JCO0 System Record Maintenance REP 4 characters Enter or scan for a representative This may be mandatory depending on the entry JCOO System Record Maintenance GRP 4 characters Enter or scan for a product group This may be mandatory depending on the entry in JCOO System Record Maintenance PRINT INDICATOR Y N The default is the entry you made at Level 1 on the previous screen Press F9 after the end of every detail line to add narrative lines These allow you to enter 30 characters or narrative Press F3 to
62. represents the percentage by which actual costs exceed estimated cost PROCEED WITH PRINT Y N Accept the information or alter any incorrect entries Press F10 to return to the company branch selection screen The Esc key will end the program 6 168 JULY 2006 Job Costing User Guide TECHNOLOGIES INCORPORATED JOB COSTING ACTION REPORT DATE 98 05 11 11 19 PAGE CAPE TOWN JC77 11 002 PERIOD OPTIONS FROM ALL ALL TO JOB OP MORE THAN JOB DESCRIPTION J101 DRAWING OF PLAN A 23469 589 0829 OP11 CONSULTATION WITH ARCHITECT 14800 OP11 CONSULTATION WITH ARCHITECT 9377 OP11 CONSULTATION WITH ARCHITECT 11 CONSULTATION WITH ARCHITECT 240 11 CONSULTATION WITH ARCHITECT 210 OP12 PRESENTING PLANS FOR 825 OP12 PRESENTING PLANS FOR ACCEP 2770 12 PRESENTING PLANS FOR 250 J103 DRAWING PLAN FOR TYPE 8405 542 1143 11 LABOUR 49 OP12 OTHER 450 JC77 Action Report JC Print JULY 2006 6 169 TITAN 2000 6 10 CATEGORY REPORT JC78 The program prints the job cost category report with a number of option levels Enter JC78 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING COST CATEGORY REPORT JC78 11 001 CO 01 TECHNOLOGIES INCORPORATED BR 01
63. required when action is specified at transaction capture stage This will be used by the individual Titan applications as follows Appendix 190 TITAN 2000 JOB COSTING The following programs will check the options set in program 00 System Record Maintenance for Issue parameters and will take suitable action or prompt for operator and or supervisor intervention JC10 JOB COST INPUT JC19 CONTRACT INPUT JC20 JOB TEMPLATE INPUT JC21 JOB MAINTENANCE FAST MATERIALS INPUT JC22 JOB COST INPUT FAST MATERIALS INPUT JC30 JOB OPERATION MAINTENANCE The following programs will check the options set in program 00 System Record Maintenance for Receipt parameters and will take suitable action or prompt for operator and or supervisor intervention JC17 CONTRACT INPUT PURCHASE ORDER JC18 CONTRACT INPUT DEMAND PURCHASE ORDER Program JC99 Update Template Supersessions allows you to update all superseded items on your templates with the relevant supersessions Where the supersession already exists as a line item on the template a warning will be given on the resulting audit trail and you will have to update the template manually deleting the superseded item and updating the required qty of the supersession SALES ORDER PROCESSING The following programs will check the options set in program 00 System Record Maintenance for Issue parameters and will take suitable action or prompt for operator and or s
64. sequence of procedures that must be followed for setting up the Job Costing system Some of the programs are contained in this system while others which are common to most modules will be found in the System Utilities Module Job Costing system program numbers are preceded by JC System Utilities programs are preceded by SU Should any difficulty be encountered during this set up procedure please contact the Dealer or Distributor immediately After installing the system and setting up the Systems Utilities proceed with the following SET UP sequence STEP PROGRAM FUNCTION AND PROCEDURE The System Record Maintenance program maintains various Mandatory essential system parameters that are used by the Job Costing system refer to section 2 1 2 of this Guide for details The program also creates empty versions of all the required Job Costing system s files if they do not exist A further facility creates description type entries for example JB for job cost estimating transaction types JP for job costing project codes etc SU30 Select Option 4 and JC You must specify your own Mandatory terminology for SETUP Do this in the first position of the soft terminology You must make an entry 5031 Descriptions File Maintenance program Mandatory Descriptions file types for example JS for job status codes are set up automatically by program JCOO System Record Maintenance however the codes are also used by the Estimating
65. the materials input is faster with fewer fields to enter The following pages will describe in detail what is required at each level of entry for the different transaction types Enter JC22 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING JOB COST INPUT FAST MATERIALS INPUT JC22 11 008 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 POSTING MODE BATCH INPUT TRANSACTION CAPTURE TRANSACTION TYPE POST COMMITTED COSTS POST ACTUAL COSTS DETAILS OK Y N HON OPTTONS EROR COIR ING jcc POSTING MODE 1 This indicates that a number of transactions will be batched and that the quantity and costs entered will be balanced against hash totals before update can take place 2 This indicate that transactions will be posted as they are completed TRANSACTION TYPE 1 Committed costs The capture of transaction type will update committed costs 2 Actual costs All transactions captured under this type will update actual costs and in addition subtract from committed costs if the option is set in program JCOO System Record Maintenance 3 94 JULY 2006 Job Costing User Guide TITAN 2000 DETAILS OK Y N Accept the details or make the required amendments and continue to the next level Level 2 JOB COSTING JOB C
66. the template in program JC20 Job Template Input will be displayed The F5 key may be used to toggle in the following sequences employee number sequence or existing operation sequence Lines may be added or deleted as required 4 characters Accept the default code or enter the required one The labour rate will be read from this code and used as a default 8 characters If the specific job operation is linked to a work centre this code will be filled in as the default but may be altered Job operation combinations not linked to a specific work centre may still be allocated to a valid work centre at this stage This code may be left blank JULY 2006 Job Costing User Guide PERIOD DOC DATE REFERENCE DIVERSION HOURS BOOKED TYPE RATE TOTAL COST JC Input TITAN 2000 2 digits The current period is the default but may be changed This refers to the period in which the cost was incurred DD MM CCYY The current date is the default but may be changed 8 characters The reference is duplicated from the previous screen but may be altered 4 characters Scan for a diversion code as entered in program JC32 Cost Category Maintenance or enter one if the costs of this specific transaction should not be posted to the job entered Press Enter if a diversion code does not apply 7 4 digits This represents the number of units pertaining to this labour transaction R S Type R refers to normal run
67. time units of labour Type S refers to set up units of labour 7 4 digits This is the Rand value rate per labour unit as set up in program JC30 Job Operation Maintenance It defaults to that rate but may be altered This field is not available for entry It is a calculated field using the two values entered above This entry will display COMMITTED or ACTUAL depending on the transaction type selected on the batch header JULY 2006 3 99 TITAN 2000 FOR ALL TRANSACTION TYPES THE FOLLOWING ENTRIES APPLY See Level 4 a for labour type transactions Level 4 QTY 7 4 digits This quantity refers to usage for example 5 kg of a specific product The unit of measure as set up in program JC30 Job Operation Maintenance is displayed RATE 7 4 digits This is the Rand value rate per unit of measure as set up in program JC30 Job Operation Maintenance It defaults to that rate but may be altered TOTAL COST 9 4 digits This field is not available for entry It is a calculated field using the two values entered above This entry will display COMMITTED or ACTUAL depending on the transaction type selected on the batch header Press F3 to post the batch A balanced batch will be posted immediately updating all the relevant files The system will not allow the posting of an unbalanced batch CORRECTING DATA If the batch is out of balance the system will display for the batch quantity and cost the
68. whole Y N Enter the appropriate selection Sometimes filing might be easier if each job is printed on a separate page Y N Accept the information or alter any incorrect entries Press F10 to return to the company branch selection screen The Esc key will end the program 6 150 JULY 2006 Job Costing User Guide TITAN 2000 COMPANY 01 TECHNOLOGIES INCORPORATED JOB COSTING JOB LISTING DATE 18 06 98 12 00 PAGE BRANCH 01 CAPE TOWN JC7011 025 PERIOD 05 OPTIONS FROM JOB ALL TO JOB END JOBS WITH STATUS CODE ALL FROM 00 TO 100 COMPLETE LIST OPERATIONS Y NEW PAGE PER JOB N DESCRIPTION STATUS DESCRIPTION TRANS CATG STK EMP B ROOM TABLE CLASSIC 50 00 I IN PROGRESS 30 09 88 ASSEMBLY E 2 Al CUTTING TOPS 1 Al 2 Al CUTTING OF LEGS Al MATERIAL GATHERING STOCK Al 2 MATERIAL GATHERING 4 PLANNING OF PRODUCTION 4 A3 QUALITY CONTROL 2 Al JC70 Job Listing JC Print JULY 2006 6 151 TITAN 2000 6 3 JOB COST SUMMARY JC71 The program prints a report of summarised estimates and actual by transaction type for all or only a specified range of jobs Enter JC71 to select the program Level 1 JOB COSTING JOB COST SUMMARY went LLO 01 TECHNOLOGIES INCORPORATED BRE 01 CAPE TOWN PERIOD 10 FROM PROJ JOB ESTA FL1 TO PROJ JOB SPR1 TMP1 JOB WITH STATUS CODE 0 ALL FROM 0 0000 TO 999 9999 COMPLETE TRANSACTION TYPE BREAKDOWN N
69. 00 11215 5296 11211325299 0000 1459 0000 1459 0000 8000 8000 0000 0 0000 0 0000 0 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 BILLED COST BILLED SALES EIU PREV SCREEN ESC EXIT This screen displays the following information ESTIMATE ACTUAL CUMULATIVE VARIANCE ESTIMATED COST TO COMPLETE QUOTE JC Maintenance 9 4 digits This represents the total cost estimate for all operations for a single job It is broken down in the 9 transaction types 9 4 digits This represents costs incurred to date The F7 key will toggle the display between actual and standard costs 9 4 digits The variance is a calculated figure representing the difference between the two previous fields 9 4 digits This is a calculated field representing the estimated costs to complete the job 9 4 digits This represents the total of all the Suggested Selling Price fields held on the individual operations relating to this job JULY 2006 4 115 TITAN 2000 EXPECTED PROFIT 9 4 digits This field represents the difference between the total value of the estimate and the value quoted EXPECTED PROFIT 3 4 digits This field is calculated using the estimated cost and selling values BILLED COSTS 9 4 digits BILLED SALES 9 4 digits The above two fields are updated by the system and are not available for entry Press F3 to end entry for the operation 3 1
70. 000 0 0000 COMMITTED TO DECIDE WHETHER WHITE BLUE Y SEL ACCEPT EJ REVIEW ESC EXIT 6 characters Enter a valid employee number if required This field will only be available for entry if the transaction type is Labour 4 characters Enter a valid earning deduction code if required This field will only be available for entry if the transaction type is Labour JC10 11 008 CO 01 TECHNOLOGIES INCORPORATED BR Ol TOWN BATCH 6 JOB OPERATION TRANSACTION TYPE CATEGORY EMPLOYEE WP CODE WORK CENTRE PERIOD DOC DATE REFERENCE DIVERSION HOURS BOOKED RATE TOTAL COST NARRATIVE DETAILS OK ACCHE 12 LINE 1 NOT FILE FIRST FLOOR PRIVATE BATHROOMS INSTALLATION LABOUR CLASS LABOUR COSTS SCOTT BASIC PAY LABOUR MANUF USAGE 151 92 03 24 6 0 00 0 0000 252100010 1 0 0000 TO DECIDE WHETHER WHITE BLUE Y FACTORY PLANNING COSTING UR o del Jeu COMMITTED F4 REVIEW F10 BATCH HEADER ESC EXIT JULY 2006 Job Costing User Guide TITAN 2000 WORK CENTRE 8 characters If the specific job operation is linked to a work centre this code will be filled in as the default but may be altered Job operation combinations not linked to a specific work centre may still be allocated to a valid work centre at this stage This code ma
71. 03 00009 LEAN 15 0000 5 32 1311 OTHER TRANSACTIONS DATE REFERENCE JOB CATEGORY QUANTITY 2 CALCULATED OHD 89 05 11 2 J103 3000 LABOUR COSTS 18 0000 y 13 5000 INVENTORY TRANSACTIONS DATE REFERENCE JOB CATEGORY PRODUCT QUANTITY CALCULATED OHD 89 05 11 2 0104 1200 CLAW HAMMER 17 0000 0000 89 05 11 2 1101 1200 CLAW HAMMER 12 0000 1000 89 04 23 2 1102 1230 STEEL BOLTS 100 5 0000 JC76 Work Centre Analysis JC Print JULY 2006 6 167 TITAN 2000 6 9 ACTION REPORT JC77 The program prints a list of all jobs and operations whose actual costs exceed an entered percentage of estimated costs Enter JC77 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING ACTION REPORT JEVY 11 70 01 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 FROM JOB OP FL1 PREP TO JOB OP TMP1 INST OP SCAN FOR JOB OP WITH MORE THAN 10 0000 OF ESTIMATE PROCEED WITH PRINT Y N S PRINTING END FILEPI FROM JOB OPERATION TO JOB OPERATION The default is all jobs and operations or enter the starting and ending job operation range It is possible to scan all the jobs on the file using the F1 key The F5 key will toggle the scan between job and project sequence PERCENTAGE OF ESTIMATE EXCEEDED 2 The default is 0 This
72. 06 4 133 TITAN 2000 4 5 2 UPDATING TRANSACTION TYPES Proceed through the steps required for entering 4 5 1 but now enter the transaction type to be updated Scan or partially scan using F1 for the required transaction type Any or all fields may be altered On completion of the update press F3 to update the file or press F10 to end the program at this point and leave the data unchanged 4 5 3 DELETING TRANSACTION TYPES Proceed through the steps required for entering 4 5 1 but now enter the transaction type to be deleted Scan or partially scan using F1 for the required transaction type Press F8 to initiate deletion or Esc to end the program at this point After deletion the program returns to the transaction type input field 3 134 JULY 2006 Job Costing User Guide TITAN 2000 4 6 WORK CENTRE MAINTENANCE JC35 The program enables the set up of work centre information which will later be used when costing certain operations and jobs Enter JC35 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user manual Level 1 If no work centre records have been created the system will display the following NO DEFAULT RECORD F4 CREATE DEFAULT Press F4 to enter the work centre defaults These are entries which might relate to most work centre records The system will fill in
73. 16 JULY 2006 Job Costing User Guide TITAN 2000 4 2 2 UPDATING EXISTING JOBS ENQUIRIES Updating amending job operation combinations operates exactly as the adding facility The only major difference is in the scanning facility See the table below SCANNING FEATURES In all cases below the F5 key will toggle between different scanning sequences and F1 will scan in whichever scanning sequence is in effect at that stage Press F5 to toggle the scan sequence between the existing operations and those held on the description file if specified JCOO System Record Maintenance Transaction Press F5 to toggle between existing transaction types for this type job operation and available transaction types as entered on program JC33 Transaction Type Maintenance Cost category Press F5 to toggle between existing categories for this job operation and available cost categories as entered on program JC32 Cost Category Maintenance Product Press F5 to toggle between products held on the branch masterfile in either product or internal sequence and existing products relating to this job operation and existing employees relating to this job operation Press F5 to toggle between available WP codes as entered on WP31 and existing WP codes relating to this job operation Enter the job number or use the scanning facility and the job file is displayed The cursor is on the Details OK field Enter N or use the arrow ke
74. 192 TITAN 2000 The following programs will give a warning that an item has been superseded If you wish to receive on the new item you will have to make the change in PO11 PO13 INPUT OF GOODS RECEIVED 15 INPUT OF GOODS AND INVOICE The following program also gives a warning However this means that the item was received under the superseded old number and therefore it should be invoiced to the same PO14 INVOICE FOR GOODS RECEIVED Program PO94 Update Order Supersessions allows you to optionally update Purchase Orders Recommended Orders Standing or Temporary Orders with supersessions No partially received invoiced orders will be changed Please note that none of the programs in the PO4 RECOMMENDED ORDERS MODULE will allow you to use superseded items Appendix 193 TITAN 2000 APPENDIX B B1 DEFINITION OF FORM TYPE JC You must decide which of the available details you wish to print on your requisition form This form is produce by program JC73 Requisition Notes You will define these forms in program SU35 Customised Form Maintenance Refer to the System Utilities User Guide for general information It is advisable to print and file a copy of each form created This will prove useful if for any reason the forms have to be recreated When you have selected form type JC the first set up screen is displayed Appendix 194 TITAN 2000 GENERAL DATA JOB COSTING SOFT FORMS This section defines th
75. 20 00 0 00 03 04 05 06 MAY JUNE JULY AUGUST 0 00 0 00 0 00 0 00 09 10 111 12 NOVEMBER DECEMBER JANUARY FEBRUARY 0 00 120 00 0 00 0 00 CATEGORY ESC EXIT 3 2 digits Enter the expected markup percentage for this purchase category At present this is only a memorandum item Up to 30 digits as set up in program GLOO System Record Maintenance The purpose of this field is to provide information on program JC78 Cost Category Report which can be used as input to a General Ledger application If you are using the TITAN General Ledger system this field will be validated 12 monthly totals These are updated as cost category allocations are entered through program JC10 Job Cost Input or alternatively by interfaces from other systems Press F3 to update the data entered Press F10 will return to the category selection screen and F8 will tag this category for deletion Press Esc to end the program without adding the category Categories can be printed out using program JC78 Cost Category Report By pressing F9 at the category code screen a report of all categories and their values will be produced JC Maintenance JULY 2006 4 125 TITAN 2000 4 4 2 UPDATING COST CATEGORIES Proceed through the steps required for entering 4 4 1 but now enter the category to be updated Scan or partially scan using F1 for the required category Category totals are never available for alteration as they are sy
76. 219 95 cts fees cv ene a elie a iv 36 de 37 de 40 TLES nen 41 je ree 42 JOB 40 46 76 85 96 102 103 198 MS 65 69 73 JOB GOSTJETAIES uterum nier E LE I 155 JOB COST INPUT e 44 JOB COST INPUT FAST MATERIALS INPUT essent enne 94 JOB COST SUMMARY d 152 JOB COSTING RECORD STRUCTURE ai itudin ierra idee tn ai Lee dcn se re d 184 JOB COSTING SYSTEM p 3 JOB COSTING SYSTEM MENU Aten i inated ete Ale eae aids 8 JOB COSTING TRANSACTION 24 JOB DELE HON a ra 35 dS ajo e 198 JOB DET AMES 16 JOB END DATE dite sleeve 19
77. 6 2 11 ACTIVATE OPERATIONS 96 37 2 12 JOB TO SP SUMMARY INVOICE CREATION 97 40 2 13 SELECTIVE ARCHIVE DELETION 9 98 41 2 14 UPDATE TEMPLATE SUPERSESSIONS 99 42 3 43 3 1 THE INPUT MODULE 43 32 JOB COST INPUT JC O nanninannan a ES 44 3 3 INTERFACE TO ACCOUNTS 611 55 3 4 CREATE INVOICE IN SP 3 ence eee 56 3 5 PURCHASE ORDER ENTRY 17 59 3 6 DEMAND PURCHASE ORDER JC18 senem nre nre 61 3 4 CONTRACT INPUT JC19 ile cereo etai sancte rent sehen cnn 62 3 71 ORDER ENTRY iie tette edere eene oni acu ieee 63 3 7 2 INVOICE ENTRY cerei idt 68 3 43 CREDIT NOTE ENTRY eter tti ieiuno eene dt eee nC Rn nies 72 3 7 4 CUSTOMER INVOICE 20 nennen nennen nennen 75 3 7 5 CUSTOMER CREDIT NOTE 75 3 7 6 BRANCH ORDER 75 3 7 7 CUSTOMER ORDER ENTRY 75 3 8 JOB TEM
78. 8 dedic 122 JOB GROUP orina re sd tite 14 10 182 185 JOB TINO 149 JOB MAINTENANCE FAST MATERIALS INPUT sese 85 JOB NUMBER wei 201 JOB SEQUENCE 3 8 4 0 an da eens 149 JOB START pL 198 JOB STATUS oc cierres cat oet ea ee vl uva i o Do voe n EORR v OE 199 JOB TEMPLATE INPUT itte tritt i atten auntie edits 76 JOB TO SP SUMMARY INVOICE CREATION sese nne rer enete trente trennen enne 40 JOB TOTAL sospes US Uu LU dE uU I EE 112 114 JOB WITHUSTATUS 150 152 155 JOB OPERATION ENQUIRY erinnern tet DX ecu D EL re o dave ER Lee d e ELE aede 141 JOB OPERATION HEADER ENQUIRY essent ener ei ener 146 JOB OPERATION MAINTENANGGE ictor rrt reet en tue ete 102 JOB OPERATION RANGE tte reci ib uri vue vae Eee see Eee e Eee nbn cade 164 JOB PERIOD TRANSACTION CATEGORY WORK eerte 179 182 L LABOUR EE 214 EisisUlselN gp 213 LABOUR
79. A CRADLE FOR GRIP 012 WIT 46 WHITE CASCADE ADJ HANDSHOWER 028 WIT 46 WHITE SHOW ARM HEAVY PATTERN 067S SF WIT 46 WHITE DIVERTER BATH SPOUT 068ADJ WIT 46 WHITE HYDROMATIC ADJ SHOW ROSE 084 EXTRA LOOSE KEY FOR LOCKSHIELD FWD 2 OP DETAILS END OP FS TOGGLE FG SCAN CODES TRANS 1 digit The transaction types may be displayed on the screen by using the scanning facility The appropriate one for this operation should be selected CATG 4 digits This refers to the cost categories set up in program JC32 Cost Category Maintenance Scan the cost categories or enter the required one PRODUCT If the transaction type entered was material usage and if it was indicated in program JC33 Transaction Type Maintenance that an interface to the Inventory Module is required the operator will have to enter a valid product in this position If this item has been superseded and it is a date supersession and that date has been reached and you have not specified an automatic action to be taken in program 1 00 System Record Maintenance you will now have to select the appropriate option Depending on the 00 option a supervisor password may be required If the supersession is a zero quantity type action will only be taken after you have entered the quantity Please refer to Appendix A3 for more information 3 80 JULY 2006 Job Costing User Guide EMPLOYEE TITAN 2000 If the tra
80. ACH UNITCOST 20 0000 1 320 0000 OVERHEAD 0 0000 INVENTORY TOTAL UTS 521916 TOTAL 320 0000 CALCULATED OP OHD 0 0000 SUGGESTED SALES 320 00 1 EXPECTED PROFIT 0 0000 JOB TOTAL 15221252206 2 TOE DETAILS BS UPDATE FS TOGGLE DELETE ELO SCAN CALCULATED COSTS INVENTORY TOTAL 9 4 digits This is a calculated field and displays the estimated inventory or other cost CALCULATED OP OHD 9 4 digits This is a total of the overheads as calculated by the system according to the parameters set up in program JC35 Work Centre Maintenance JOB TOTAL 9 4 digits This is a calculated field an represents the total of the two fields above The following two fields are linked to each other A change in one will cause a corresponding change in the other SUGGESTED SALES 9 4 digits The total value of the planned sales EXPECTED PROFIT 3 4 digits If an expected profit percentage is entered here the Suggested Sales above will change accordingly Press F3 to update the record The next screen will show the accumulated totals for all the operations relating to the current job 3 112 JULY 2006 Job Costing User Guide After all details for all operations have the level 6 screen will be displayed TITAN 2000 been completed press F3 on the level 3 screen and Level 5 for transaction type LABOUR JOB COSTING JOB OPERATION MAINTENANCE CO 01 TECHNOLOGIES INCORPORATED BR DI
81. AME JOB START DATE JOB END DATE Appendix 198 TITAN 2000 4 characters digits depending on the definition in program 00 System Record Maintenance The job number for which items are requisitioned 30 characters This will be read from the job masterfile 9 2 digits This is the total amount quoted for the job and will be read from the job masterfile 2 digits The number of the Company where the details of the debtor for whom the job is done are held 30 characters The description associated with the number above 2 digits The number of the Branch where the details of the debtor for whom the job is done are held 30 characters The description associated with the number above 6 characters The account number of the debtor for whom the job is done 30 characters The name of the debtor will be read from the debtors masterfile DD MM CCYY The start date for the job as entered in program JC30 Job Operation Maintenance DD MM CCYY The end date for the job as entered in program JC30 Job Operation Maintenance TITAN 2000 HEADER 2 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE SUS 11 001 HEADER 2 JOB COSTING SOFT FORMS JOB STATUS COST OF BILLED AMOUNT PROFIT PROFIT PERCENTAGE PERCENTAGE COMPLETE TOTAL ESTIMATED COST TOTAL ESTIMATED SALES TOTAL ACTUAL SALES DEBTORS ADDRESS ADDRESS 1 ADDRESS 2 ADDRESS 3 POST CODE REFERENCE REFERENCE VALUE TEMPLATE
82. AN 2000 1 5 THE JOB COSTING SYSTEM MENU To select the Job Costing system from the main menu enter JC The following modules and programs form part of the Job Costing system TITAN JOB COSTING MENU JC1 INPUT MODULE JC10 JOB COST INPUT JC18 CONTRACT INPUT DEMAND PURCHASE ORDER JC COST INPUT INTERFACE 19 INPUT JC17_ CONTRACT INPUT PURCHASE ORDER JC2 BATCH NE JC20 JOB TEMPLATE INPUT JC22 JOB COST INPUT FAST MATERIALS INPUT d REQUIREMENTS INPUT JC3 MAINTENANCE MODULE JC33 TRANSACTION TYPE MAINTENANCE JC35 WORK CENTRE MAINTENANCE JC5 ENQUIRY MODULE JC7 PRINT MODULE JOBLISTING JOBCOSTSUMMARY 1072 JOBCOSTDETALS REQUISITION NOTES 1079 JC81 JC75 SCRAP ANALYSIS AUDIT TRAIL HISTORY JC9 PERIOD END MODULE 1095 JC96 OPERATIONS ACTIVATE 2692 PO UPDATES TO JOB 1097 JC98 SELECTIVE ARCHIVE DELETION JOB DELETION 1099 As you can see these modules are organised into functional groups for example the Input Module JC1 contains all the programs that are concerned with data input The menu system has pre loaded the JC mnemonic and all that is required is to enter the relevant module number for example 1 for the Input Module Enter M to select the main menu 1 8 JULY2006 X JobCosting User Guide TITAN 2000 2 SET UP AND RUN 2 1 SETTING UP THE SYSTEM This section sets out the
83. ANTITY etn eratac oh E 58 111 203 211 tier n n e e D er 207 QUANTITY OUTSTANDIING teat et nete er det ake ntl eee teenth i 207 QUANTITY REQUIRED ite ciel atid ei ee ele eee ee ean 199 ewen 84 92 115 QUOTED AMOUN TON JOB ritenere tta tr deel 198 alle E 50 52 91 99 100 RATE PERCENTAGE we 20 E 136 REDUCE COMMITTED COSTS WHEN POSTING 21 REF OTY 57 REFERENCE icd ied tert 45 49 57 78 87 95 99 105 200 209 05 at ae 78 87 105 REFERENCE VALUE c MH 200 ue Uere UE 58 REPORT SEQUEDGCE 106 159 179 182 REPORT TYPE eei ient erred et eer eee te iere ORT se ee cy epe eR 171 174 i e undc HH 170 173 REQUISITION NOTES i Eea 158 RETAINIFISTORY 13 82 203 RUN TIME
84. Accounts Receivable or Sales Analysis systems They merely update the actual cost and sales values on the job record in the Job Costing system JC Input JULY 2006 3 71 TITAN 2000 3 7 3 CREDIT NOTE ENTRY This option simulates either program SP17 Credit Note Entry or program SP18 Demand Credit Note Entry in the Sales Order Processing modules It allows the capture of credit notes relating to specific jobs on the Job Costing system It optionally produces a user defined credit note This program will update the job record on the Job Costing system but will have no effect on the debtors record at all The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 2 SALES ORDER PROCESSING CREDIT NOTE PRINT SP1811 005 01 TECHNOLOGIES INCORPORATED BR DI CAPE INVOICE FORM TYPE DUPLICATE REQUIRED PRINT TEST REQUIRED DETAILS OK Y N COSR ESC The entries for this level will only be required if the option to immediately produce forms has been selected INVOICE FORM TYPE SPxx This represents the user defined form set up in program SU35 Customised Form Maintenance DUPLICATE REQUIRED If Y is entered the program will print two forms exactly the same side buy side PRINT TEST REQUIRED Y will produce a test printout which will enable the operat
85. B COSTING REQUISITION NOTES wens OOL 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 FORM TYPE TEST PRINT Y N PQ PRINT OPTIONS IO COs INC jcc FORM TYPE JOxx This form is set up in program SU35 Customised Form Maintenance form type JC TEST PRINT Y N Enter Y if a test print is required This is normally the case where the correct line up of a pre printed form is essential 6 158 JULY 2006 Job Costing User Guide TITAN 2000 Level 2 REPORT SEQUENCE 1 by project 2 by job Select the required sequence Press F10 to return to the form selection screen The Esc key will end the program JOB COSTING REQUISITION NOTES wens AOON 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 START ALL END PROJ START ALL END JOB START ALL END OP START TRANSACTION 0 ALL END TRANS PRINTING 01 01 GAME GA01 INST Level 3 START END PROJ The default is all projects or enter the starting and ending project range START END JOB The default is all jobs or enter the starting and ending job range START END OP The default is all operations or enter the starting and ending operation range START END TRANSACTION The default is all types or enter the starting and ending transaction type range Press F3 to accept the default selections or F10 to return to the report sequence selection screen The Esc key will end the program
86. COSTING SYSTEM RECORD MAINTENANCE JCOO0 11 002 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN OPERATION DETAILS LONG TERMINOLOGY SHORT TERMINOLOGY CODE OPERATION CODE DEFAULT USE START END DATES Y N ALLOW BLANK SALESMAN ALLOW BLANK PRODUCT GROUP ALLOW BLANK CATEGORY OPERATION OP 1 ALPHA NUMERIC 1 1 1 aM PI POST DETAILS EA JOB DETAILS FS UPDATE FS DELETE PRINT LONG TERMINOLOGY SHORT TERMINOLOGY CODE OPERATION CODE DEFAULT JC Set up and Run 10 characters Enter the long terminology to be used by the system for Operation for instance OPERATION 4 characters Enter the short terminology to be used by the system for Operation for instance OP 1 character A Alpha numeric N Numeric Enter the format of the code 2 characters If an operation code needs validation this entry will indicate against which code in the description file the validation should take place for example PG for product groups If a user defined description code is required use any code starting with X Y or Z JULY 2006 2 19 USE START END DATES ALLOW BLANK SALESMAN ALLOW BLANK PRODUCT GROUP ALLOW BLANK CATEGORY TITAN 2000 Y N Y in this field will indicate that an operation will carry start and end dates for reporting purposes Y N If you enter N the Salesman code will be mandatory in JC30 Job Operation Maintena
87. COSTS SALES DETAILS OK Y N JE METUS oM POSTING MODE 1 Batch Input This indicates that a number of transactions will be batched and that the quantity and costs entered will be balanced against hash totals before update can take place 2 Transaction Capture This indicate that transactions will be posted as they are completed 3 44 JULY 2006 Job Costing User Guide TRANSACTION TYPE DETAILS OK Y N Level 2 JOB COSTING JOB COST INPUT CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN BATCH 1 REFERENCE WED 18 3 BATCH QUANTITY COST DETAILS OK Po POST FLO NEXT BATCH BATCH REFERENCE BATCH QUANTITY COST JC Input TITAN 2000 1 Orders Capture of order type transactions will update committed costs 2 Transaction Capture All transactions captured under this type will update actual costs and in addition subtract from committed costs if the option is set in program System Record Maintenance 3 Billed Costs or Sales Capture billed details Accept the details or make the required amendments and continue to the next level JC10 11 008 PERIOD 10 BATCH HEADER NOT ON FILE COMPUTED VARIANCE 0 00 300 00 0 0000 865 0000 6 digits A scan is available on all unposted batches indicating their status Select the batch required for correction or enter the next batch number 8 Charac
88. CTIVATE Wee 35 700 CO 01 TECHNOLOGIES INCORPORATED BR DI CAPE TOW PERIODO 10 JOB GAO1 GAME PARK Al ACTIVATE ALL OP Y N CALCULATE PRO RATA Y N PRO RATA ACCORDING TO 1 PLANNED COSTS 2 PLANNED SALES DETAILS OK Y N FIO JOS p MSG EXIT 1 38 JULY 2006 Job Costing User Guide TITAN 2000 This screen shows selected operations for a specific job JOB COSTING OPERATIONS ACTIVATE MEINE LDO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PEBIOD 10 JOB GA01 GAME PARK A1 SUMMARY OP SCAN OP TRANSACTION CATG PROD EMP START DATE END DATE ACTIVE PRO RATA FINI lt gt 00010 01 27 02 92 27702792 2 FINI 00011 01 7702792 BN OS OZ 2 500 INST 001 1WB WIT 46 21 27 0 SZ 2 INST 028 WIT 46 2 0127 92 52 INST 067S SF WIT 46 27 BOS 92 PN INST OOS 1015 27 02 98 BUM OS OA 60 INST 106AQ 15 27 02 92 27 03 92 44 INST 108 20 21 02 92 21 03 92 40 INST 121LK 15 ZOEN SZ 087492 69 INST 147 21 02 92 OE INST 158 AQ 27702792 27703792 2197 INST 191CA 291027492 27 08 92 44 INST 404CA PN 2 299 INST 414CA 202 492 98 INST 431 27 02 92 27 03 92 217 PRPPRPRPRPRPRPRPRPRPRPENN KKK KKK KKK KK KKK ARE N Fl FWD ACTIVATE FS TOGGLE PREVIOUS This screen shows the pro rata percentage calculation in relation to costs per job JOB COSTING OPERATIONS ACTIVATE
89. CULATED OP OHD 9 4 digits This is a total of the overheads as calculated by the system according to the parameters set up in program JC35 Work Centre Maintenance JOB TOTAL 9 4 digits This is a calculated field an represents the total of the two fields above The following two fields are relative to each other A change in one will cause a corresponding change in the other SUGGESTED SALES 9 4 digits The total value of the planned sales EXPECTED PROFIT 3 4 digits If an expected profit percentage is entered here the Suggested Sales above will change accordingly Press F3 to update the record The next screen will show the accumulated totals for all the operations relating to the current job After all details for all operations have been completed press F3 on the Level 3 screen and the Level 6 screen will be displayed 3 114 JULY 2006 Job Costing User Guide Level 6 JOB COSTING JOB OPERATION MAINTENANCE JC30 TITAN 2000 11 003 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN JOB INVENTORY LABOUR CALCD OHD OTHER LAB NOT WP NOT USED NOT USED NOT USED NOT USED TOTAL QUOTE EXPECTED PROFIT EXPECTED PROFIT UPDATE 5 1579 5296 0000 0000 0 0000 0000 0000 0000 0000 Caio PERIOD 10 FIRST FLOOR PRIVATE BATHROOMS 5 13 OF ESTIMATE ACTUAL ESTIMATED COST CUMULATIVE VARIANCE TO COMPLETE 560 00
90. DELETE FLO OF 20 0000 0 0000 LAB C OH OTH LAB KKK ck kv TOTAL MOI Jg 20 0000 200008 SCAN Level 5 for transaction types INVENTORY and OTHER ESTIMATED PLANNED COSTS QUANTITY UNIT COST A calculated cost field is displayed OVERHEAD JC Maintenance 9 4 digits The number of units to be used by this operation to produce one job item If this is an item where square metres are used as specified in 0 Company Inventory Maintenance then a small window will be presented requiring you to enter the Unit Quantity Length and Width and the system will do the required calculations 9 4 digits This comes from the specific stock item as set up in program JC33 Transaction Type Maintenance but not available for entry 9 4 digits This represents a contingency overhead to be added to the costs of the specific operation JULY 2006 4 111 TITAN 2000 TOTAL f 9 4 digits This is a calculated field displaying the total estimated cost for the operation JOB COSTING JOB OPERATION MAINTENANCE JC30 11 003 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 JOB OP FL1 INST FIRST FLOOR PRIVATE BATHROOM INSTALLATION TRANS 1 INVENTORY CLASS SET CLASS JC33 CATG 7000 MATERIAL COSTS INSTALLATIONS PRODUCT 001 1WB WIT 46 1 WHITE CASCADE HANDSHOWER SPIRA SALESMAN 1 PRODUCT GROUP 1 ESTIMATED PLANNED COSTS QUANTITY 16 00 E
91. DUCTIVE HOURS DAY EFFICIENCY FACTOR 0 0 0000 0 0000 NUMBER OF MEN 0 F2 BACKWARDS UPDATE ES DELETE WORK CENTRE ESC EXIT The entries on this screen are memorandum items and are optional JC Maintenance JULY 2006 4 137 TITAN 2000 4 6 1 ENTERING NEW WORK CENTRES Once the default has been set up the operator may proceed with entering the details for individual work centres Enter the following fields WORK CENTRE 8 characters This is the code which will uniquely identify the work centre If you intend using JC79 Work Centre Productivity enter an employee number in this field and refer to that program in this User Guide for more information DESCRIPTION 30 characters This is used to further identify and describe the work centre All the subsequent fields are exactly as those applying to the default work centre Values entered on that screen will be duplicated but may be altered The status line indicates all the available options JOB COSTING WORK CENTRE MAINTENANCE Jess 11 70 0011 01 TECHNOLOGIES INCORPORATED BR DI PERIOD 10 WORK CENTRE MANUF DESCRIPTION FACTORY PLANNING COSTING STD LABOUR RATE 35 0000 PER HOUR SETUP 8 0000 HOUR OVERHEAD COST APPLY ON TRANS TYPE S DESCRIPTIONS E PERCENTAGE CATEGORY 123 45 7 amp WAT amp ELEC OF TOTAL 29000 M
92. E MATERIAL COSTS INSTALLATIONS DATE REFERENCE DIVERSION FREE TOTAL 10 22 1027 25 0 0000 PRODUCT BIN UOM 001 1WB WIT 46 EXISTING OP SCAN OP DESCRIPTION INST 2INSTALLATION INST INSTALLATION INST INSTALLATION INST INSTALLATION INST INSTALLATION INST INSTALLATION INST INSTALLATION INST INSTALLATION QTY SRE OD OTY ISS OTY OUTST UNIT PRICE OK 16 00 0 00 122010 0 0000 TRANS CATG PROD EMP ACTIVE 001 1WB WIT 46 006S 20 WIT 46 O68ADJ WIT 46 106AQ 15 14 7 401 414CA Bpombpmopmopmopmop WHITE CASCADE HANDSHOWER SPIRA FI SCAN FILE REVIEW FS TOGGLE F110 BATCH ESC EXIT Enter the following fields LINE JOB OPERATION TRANSACTION TYPE 5 digits Each new batch will start at line number one and this will be incremented after each transaction 4 characters Enter the job number or scan the job numbers for the required job The F5 key provides a toggle between job and project sequence Once a job number has been entered or accepted the description is displayed 4 characters This will only be requested if the specific job entered has associated operations Enter the operation number or scan the operations required for the required one Once an operation has been entered or accepted the description is displayed 1 digit Only transaction types associated with this specific job operation as set up in program JC30 Job Operation Mainte
93. EW PAGE PER PROJ NEW PAGE PER JOB Y N PROCEED WITH PRINT Y N PROCESSING GAME GA03 FROM JOB TO JOB i The default is all jobs or enter the starting and ending job range It is possible to scan all the jobs on the file using the F1 key The F5 key will toggle the scan between job and project sequence JOB WITH STATUS CODE Enter the required status code entered in 5031 type JS or enter a zero for all status codes FROM TO 96 COMPLETE The default is from 0 to 100 or enter the percentage range Only jobs falling within this range will be selected for printing 6 152 JULY 2006 Job Costing User Guide TITAN 2000 TRANSACTION TYPE BREAKDOWN Y N Enter the correct selection Y will print values for each of the nine transaction types whereas N will print only summarised figures for the job as a whole NEW PAGE PER JOB Y N Enter the appropriate selection Sometimes filing might be easier if each job is printed on a separate page PROCEED WITH PRINT Y N Accept the information or alter any incorrect entries Press F10 to return to the company branch selection screen The Esc key will end the program JC Print JULY 2006 6 153 TITAN 2 01 TECHNOLOGIES INCORPORATED JOB COSTING JOB COST SUMMARY DATE 98 05 11 11 07 PAGE BR 01 CAPE TOWN JC71 11 008 PERIOD 10 OPTIONS FROM JOB ALL TO JOB END JOB WITH STATUS CODE FROM 0 0000 TO 999 9999 COMPLETE TRANSACTI
94. FORMS COMPANY COMPANY DESCRIPTION BRANCH BRANCH DESCRIPTION TODAY S DATE PROJECT PROJECT DESCRIPTION JOB JOB DESCRIPTION QUOTED AMOUNT ON JOB DEBTORS COMPANY DEBTORS COMPANY DESCRIPTION DEBTORS BRANCH DEBTORS BRANCH DESCRIPTION DEBTOR NUMBER DEBTOR NAME JOB START DATE JOB END DATE LINE COLMN DGT DEC 001 001 004 120 005 120 IS THE ABOVE INFORMATION CORRECT Y N IE 1 F2 PREVIOUS F3 SAVE COMPANY COMPANY DESCRIPTION BRANCH BRANCH DESCRIPTION TODAY S DATE PROJECT PROJECT DESCRIPTION FS DELETE F9 PRINT F10 NEXT FORM ESC EXIT 2 digits The number of the Company which is issuing the requisition 30 characters The name of the company associated with the number above 2 digits The number of the Branch issuing the requisition 30 characters The name of the Branch associated with the number above DD MM CCYY The date entered when generating the requisition 4 characters digits depending on the definition in program JCOO System Record Maintenance The project code for which items are requisitioned 30 characters The description associated with the code above These are set up and maintained in program 5031 Descriptions File Maintenance under type JP Appendix 197 JOB JOB DESCRIPTION QUOTED AMOUNT ON JOB DEBTORS COMPANY DEBTORS COMPANY DESCRIPTION DEBTORS BRANCH DEBTORS BRANCH DESCRIPTION DEBTORS NUMBER DEBTORS N
95. GORY WORK CENTRE 6 182 1 By Job Operation 2 By Period 3 By Date 4 By Transaction 5 By Category 6 By Work centre Enter one of the above to select the sequence in which transactions are to be printed Depending on the selection made above one of these ranges will be presented for entry Either enter a start and end range or press Enter in both fields for the full range to be selected for printing JULY 2006 Job Costing User Guide TRANSACTION DATE FROM TO COST OPTION PRINT SUBTOTAL Y N PROCEED WITH PRINT TITAN 2000 From date Enter the date DD MM CCYY from which the audit trail is to start printing The default date is the current date To date Enter the last date DD MM CCYY to be included in the audit trail The default date is one month greater than the from date 1 Actual Costs 2 Standard Costs 3 Sales value Enter one of the above to indicate which value is to be printed on individual transactions Y N Enter Y if subtotals are to be printed at each break in the report sequence For example if option 6 Work centre was selected for the report sequence Y in this field will cause a subtotal to print at the end of each work centre s transactions Y N Press Enter to accept the selections or enter N to enable changes to be made The Esc key will end the program This report looks exactly like that produced by JC80 Audit Trail Current JC Pri
96. H CLEARDOWN PLO BSC mon 1 28 JULY 2006 Job Costing User Guide TITAN 2000 2 6 SP UPDATES TO JOB COSTING JC91 This program is designed to update Job Costing values and transactions with invoicing information Program JC19 Contract Input may be used to enter different types of job costing invoices and orders Please refer to the INPUT section of this User Guide for further information If Options 2 or 3 have been selected in program JC19 Contract Input the invoices credit notes created by that program will be used to update actual cost figures when running program JC91 SP Updates to Job At the same time the committed cost figures will be decreased if the option has been set in program JC00 System Record Maintenance If Options 4 and 5 have been selected in program JC19 Contract Input the invoices credit notes created by that program will be used to update billed amounts on the relevant Job Costing files JC Set up and Run JULY 2006 2 29 Level 1 JOB COSTING SP UPDATES TO JOB TITAN 2000 weg LOOL CO DI TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN MONTH END DATE FOR WAREHOUSES t DETAILS OK Y N CURRENT IV PERIOD CURRENT AR PERIOD CURRENT SA PERIOD 1998 09 23 HOR Gr OMS Il lise MONTH END DATE DD MM CCYY The default is the current date Any invoices dated beyond the date entered here will be ignored for update purpos
97. IES INCORPORATED BR 01 CAPE TOWN WH 01 CENTRAL JOB J101 REF 4 QUANTITY 19 dil 018 CUSTOMER 1010 JONES GENERAL CONTRACTING CUST ORD DATE 89 04 23 PRODUCT 1220 OP F3 END Level 7 OP TRANS CATEGORY OR PROD ORDERED TO SUPPLY PRICE DISC SUR AMT 5 00 5 00 78 9 NET AMT T S ws TRANS 1 1220 PAINT PVA EXT WHITE 201 PRICE 00 TAX 0 00 GRP 0030 CAT F8 DELETE F10 CUST R RESERVE 4 characters Optional This entry is only requested if the specific job has associated operations Enter the operation to which this transaction line refers 1 digit Enter the transaction type of this transaction line as defined in the Job Costing system 4 characters Enter the sales category to which this transaction line refers If the transaction type is linked to the Inventory Module JULY 2006 Job Costing User Guide TITAN 2000 Level 8 The invoice details entry is exactly as described for program SP15 Batch Invoice Entry or program SP16 Demand Invoice Entry in the Sales Order Processing system Please refer to that User Guide for further information The program will now switch from Level 7 to Level 8 until all items have been entered If the direct printing option was selected the invoice will be printed automatically according to the parameters set up in program SU35 Customised Form Maintenance These invoices are not posted to the
98. INST INSTALLATION 001 1WB WIT 46 93 12 14 MATERIAL COSTS INS DECIDE ON BLUE WHITE INST INSTALLATION 106 0 15 93 12 14 MATERIAL COSTS INS OLD STOCK GIVE DISCOUNT 01 GAME PARK 1 FINI FINISHING 00010 93 12 14 LABOUR COSTS FINIS 7 00 PENALTIES FOR LATE INSTALLAT N INST INSTALLATION 100 15 93 12 14 MATERIAL COSTS INS 8 00 CAREFUL PENALTIES INST INSTALLATION 001 1WB WIT 46 93 12 14 MATERIAL COSTS INS 8 00 TRANSPORT NON CHARGEABLE POSTING SUMMARY NUMBER OF TRANSACTIONS gt JC80 Audit Trail Current JC Print JULY 2006 6 181 TITAN 2000 6 13 AUDIT TRAIL HISTORY JC81 The program prints a Job Costing audit trail from the archived transactions with a number of option levels Enter JC81 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING AUDIT TRAIL HISTORY 01 TECHNOLOGIES INCORPORATED Be 01 CAPE TOWN REPORT SEQUENCE JOB TRANSACTION DATE COST OPTION PRINT SUBTOTAL Y N DETAILS OK Y N 1 PERTODE MOV BY JOB OP BY PERIOD BY DATE BY TRANSACTION BY CATEGORY BY WORKCENTRE 98 04 11 98 05 11 1 XI Y ACTUAL COSTS STANDARD COSTS SALES HOSCE ESENIAOEUSUONS MSESIONC REPORT SEQUENCE JOB PERIOD TRANSACTION CATE
99. IT LENGTH 7 4 digits UNIT WIDTH 7 4 digits Appendix 212 TRAILER DETAILS TITAN 2000 Trailer detail screens will be presented until all trailer information has been specified Only then will the title screens be presented TRAILER 1 JOB COSTING SOFT FORMS The following refer to total quantities required for all transactions on this requisition SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE SIUS A00 TRAILER 1 JOB COSTING SOET FORMS TOTAL TRANSACTION QUANTITIES Stock quantity Labour quantity Calculated OHD quantity Transaction type Transaction type Transaction type Transaction type Transaction type Transaction type COLMN DGT DEC IS THE ABOVE INFORMATION CORRECT Y N S FI NEXI F2 PREVIQUS STOCK QUANTITY LABOUR QUANTITY CALCULATED OHD QUANTITY TRANSACTION TYPE 4 TO 9 QTY HS DELETE F9 PRINT F10 NEXT FORM ESC EXIT 9 4 digits This is the total planned quantity for the job for transaction type 1 9 4 digits This is the total planned quantity for the job for transaction type 2 9 4 digits This is the total planned quantity for the job for transaction type 3 9 4 digits These are the total planned quantities for the job for transaction types 4 to 9 Appendix 213 TITAN 2000 TRAILER 2 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE TRAILER 2 JOB COSTING SOFT FORMS TOTAL TRANSACTION COSTS SLOCK
100. Job Costing system but will have no effect on the debtors record at all Level 2 JOB COSTING CONTRACT INPUT SEO 01018 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN ORDER FORM TYPE DUPLICATE REQUIRED PRINT TEST REQUIRED DETAILS OK Y N PC OPTIONS ILO Ie The entries for this level will only be required if the option to immediately produce forms has been selected ORDER FORM TYPE SPxx This represents the user defined form set up in program SU35 Customised Form Maintenance DUPLICATE REQUIRED If Y entered the program will print two forms exactly the same side by side JC Input JULY 2006 3 63 PRINT TEST REQUIRED DETAILS OK Y N TITAN 2000 Y will produce a test printout which will enable the operator to ensure that the printer is lined up correctly N will return the cursor to the top of the page and Y causes the program to proceed to Level 3 The status line displays the other available options Level 3 SELECT CURRENCY TO BE USED JOB COSTING CONTRACT INPUT 01 TECHNOLOGIES INCORPORATED Be 01 TOWN SELECT CURRENCY TO BE USED CURRENCY CODE DETAILS OK Y N SP19 11 008 SCAN EID PREV SCBN ESC EXIT Currency codes and rates are set up in program SU36 Currency File Maintenance CURRENCY CODE Level 4 WAREHOUSE 4 digits Press Enter to accept the default curre
101. LE EJ REVIEW FS TOGGLE BATCH ESC EXIT 5 digits Each new batch will start at line number one and this will be incremented after each transaction Existing lines can be scanned and reviewed by selecting the appropriate line numbers 4 characters Enter the job number or scan the job numbers for the required job The F5 key provides a toggle between job and project sequence Once a job number has been entered and validated the description is displayed 3 46 JULY 2006 Job Costing User Guide OPERATION TRANSACTION TYPE CATEGORY PRODUCT JC Input TITAN 2000 4 characters This will only be requested if the specific job entered has associated operations Enter the operation number or scan the operations required for the required one Once an operation has been entered and validated the description is displayed 1 digit Only transaction types associated with this specific job operation as set up in program JC30 Job Operation Maintenance may be entered or any program JC33 Transaction Type Maintenance transaction type if program JCOO System Record Maintenance option was set to CREATE OPS WHEN POSTING 4 characters Only categories associated with the specific job operation transaction type combination as set up in program JC30 Job Operation Maintenance may be entered or any JC33 Transaction Type Maintenance transaction type if program System Record Maintenance option was s
102. N TYPE 153 TRANSACTION TYPE 128 iic 52 99 Index 223 TITAN 2000 U UNT COS Ti eaer ES 58 111 203 UNIT CENG TH tidia onnaa attest adie a 204 212 itr ttn fetten a e a eaa a ee ce 203 UNITERICE S eee reece 81 89 97 e ERE 204 212 UNIT WIDTH oii ret cae cies cri rem cian rt erre Mies clan t ect ee Guan teen reete 204 212 UOM wedi theo ie tie ei ned eee ty eevee tats nie nv 131 UPDATE aaa 123 UPDATE ESTIMATED FIGURES JC19 4 5 7 oneri tnter aaa 21 UPDATE JOB PROJEGT ITEMS coetu ct ete nen tte drehen egere doeet tede 127 UPDATE TEMPLATE SUPERSESSIONS 1 eves rrt ep herd ne t eder Deere rra 42 UPDATING COST CATEGORIES ntt rtt s od treo ie prod reed arriere refs 126 UPDATING EXISTING 22 244424 0 eene nennen enne nnns 117 UPDATING JOB COSTING ANALYSIS sese enne nre trennen nenne 127 UPDATING TRANSACTION TYPES 2 tete eet tte terree cer ee Entre ven ne 134 UPDATING WORKGENTERBES erret ttti ett deduced ec 139
103. NCE BATCH QUANTITY 1 10 00 0 00 COST 120 0000 120 0000 0 0000 DETAILS OK F3 POST FS DELETE FIO NEXT BATCH EXIT When the transaction input is complete press F3 to end the document and the F10 to return to the batch header screen Press F3 to post the batch A balanced batch will be posted immediately updating all the relevant files The system will not allow the posting of an unbalanced batch JC Input JULY 2006 3 53 TITAN 2000 CORRECTING DATA If the batch is out of balance the system will display for the batch quantity and cost the batch total total amount entered the computed values and the difference To correct an imbalance situation either input the correct batch total or review the entries and correct the data as required For extreme circumstances the selection of F8 will cancel the batch and return to the header screen or terminate the program with the Esc option BATCH COMPLETED When the balanced batch is complete press F3 the files are updated The program will then prompt for further batches to be entered End the program by pressing F10 to return to the previous menu 3 54 JULY 2006 Job Costing User Guide TITAN 2000 3 3 INTERFACE TO ACCOUNTS RECEIVABLE JC11 This program is similar to program JC10 Job Cost Input However in addition it allows you to post to the Accounts Receivable Module If you do not use Accounts Receivable it
104. NSACTION TYPE MAINTENANCE Jess 11 001 01 TECHNOLOGIES INCORPORATED BR DI CAPE TOWN PERIOH 12 TRANSACTION TYPE 3 LONG TERMINOLOGY CALCD OHD SHORT TERMINOLOGY C OH CLASS 131 1 MATERIAL USAGE 2 LABOUR 3 COMPUTED OVERHEADS 4 OTHER ALLOW MANUAL POSTINGS Y N DEFAULT COST CATEGORY EI SCAN FILE UPDATE RID TYPE 217 If Class 1 or 2 are selected the system will proceed to Level 3 for further data entry For Class 3 enter the following ALLOW MANUAL POSTINGS Y N DEFAULT COST CATEGORY 4 characters Enter the default cost category for this transaction type These categories are set up in program JC32 Cost Category Maintenance For Class 4 only the entry of a Default Cost Category will be requested Level 2 INTERFACE WITH IV Y N If the class selected above was either 1 or 2 this question will be asked If the system is to be interfaced to the Inventory System in the case of a material usage class or to the payroll system in the case of a labour class transaction Y must be entered here 3 130 JULY 2006 Job Costing User Guide Level 3a INTERFACE TO INVENTORY JOB COSTING TRANSACTION TYPE MAINTENANCE TITAN 2000 Jess 11 001 CO 01 TECHNOLOGIES INCORPORATED BR Dl CAPE TOWN TRANSACTION TYPE LONG TERMINOLOGY SHORT TERMINOLOGY CLASS INTERFACE WITH IV DEFAULT COST CATEGORY PRODUCT 20 PRODUCT BR PRODUCT DEFAULT WH
105. OLOGIES INCORPORATED BR Dl CAPE TOWN SYSTEM DETAILS YEAR END DATE PERIOD RETAIN HISTORY FOR ARCHIVE DELETED TRANSACTIONS Y ACCUMULATED COSTS DEFAULT 1 JOB GROUP DETAILS 1 12 PERIOD 02 195 02 28 PERIODS 99 AUTO DELETION ACTUAL 2 STANDARD ES D Me EVITE 6 EVITE RIS ESSO RNE mO COR JULY 2006 Job Costing User Guide RETAIN HISTORY FOR TITAN 2000 2 digits Enter the number of periods or months of history data needed to be held on file A 99 indicates that history will never be automatically deleted CAUTION Although the system caters for data to be held for up to 99 periods holding excessive amounts of historical data will consume disk space ARCHIVE DELETED TRANSACTIONS ACCUMULATED COSTS DEFAULT JC Set up and Run Y N If Y transactions deleted from JCHIST will be archived to JCARCH during the running of JC90 Month End Cleardown You must keep the disk space considerations in mind as described above 1 digit 1 Actual 2 Standard Both these costs are stored throughout The selected option is used as a default on enquiries and reports JULY 2006 2 13 TITAN 2000 Level 2 JOB GROUP DETAILS You may select your own terminology for job job group and operation A long description and a short description is available in each case JOB COSTING SYSTEM RECORD MAINTENANCE 9 00 11 002 CO 01 TECHNOLOGIES INCO
106. ON TYPE BREAKDOWN Y NEW PAGE PER JOB JOB DESCRIPTION STATUS COMPLETE QUOTED AMT EXPECTED PROFIT AND BILLED COSTS BILLED SALES TRANSACTIONS EST COST EST SALES MTD COST YTD COST CUM COST CUM SALES COST TO COMP DRAWING OF 1 PROPOSING QUOT 9 6900 49840 44 8718 64 INVENTORY 00 3600 00 3600 00 3600 00 LABOUR 00 240 240 00 240 CALCD OHD DRAWING OF PLAN FOR B TYPE 1 PROPOSING QUOT 17388 00 INVENTORY 00 00 LABOUR ie 00 0 0 00 CALCD OHD DRAWING OF PLAN FOR B TYPE 1 PROPOSING QUOT 17010 00 INVENTORY 00 s 0 00 LABOUR 00 43 CALCD OHD OTHER CONSTRUCTION PROJECT INTER CIT 3 TENDER ACCEPTE 87 4700 3 INVENTORY 150 00 190 31 425 00 LABOUR 18 00 CALCD OHD JC71 Job Cost Summary 6 154 JULY 2006 Job Costing User Guide TITAN 2000 6 4 JOB COST DETAILS JC72 The program prints the actual values by transaction type with the option to selectively print transaction details Enter JC72 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 HOR COSTING JOS COST DETALLS wey 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 FROM PROJ JOB ESTA FL1 TO PROJ JOB SPR1 GA03 JOB WITH STATUS CODE 0 ALL TRANSACTION DETAILS Ya TRANSACTION TYPE 01 ALL TRANSACTION DATES OON axo 92 02 27 NE
107. OST INPUI FAST MATERIALS INPUT JC22 11 008 01 TECHNOLOGIES INCORPORATED BR TOWN PERIOD 10 BATCH 4L BATCH HEADER NOT ON FILE REFERENCE 1 COMPUTED VARIANCE 0 00 200 00 BATCH QUANTITY 200 002 COST 2165 0000 0 0000 2165 0000 DETAILS OK xi POST REID e NEXT BATCH I ESCE BATCH 6 digits A scan is available on all unposted batches indicating their status Select the batch required for correction or enter the next batch number REFERENCE 8 Characters The batch number entered above is inserted as a default but this may be altered to any user defined reference If capturing actual costs and quantities this reference will appear on the transaction in the Inventory System BATCH QUANTITY 9 2 digits Enter the total transaction quantity of this batch COST 9 4 digits Enter the total cost for this batch DETAILS OK Y N Accept the details or make the required amendments and continue to the next level The computed or variance fields are not available for entry but are calculated by the system JC Input JULY 2006 3 95 Level 3 TITAN 2000 JOB COSTING JOB COST INPUT FAST MATERIALS INPUT J 22 11 7008 CO 01 TECHNOLOGIES INCORPORATED BR O01 CAPE TOWN BATCH 1 LINE 1 JOB OPERATION TRANSACTION TYPE CATEGORY WORK CENTRE PERIOD DOC PERIOD 10 NOT ON FILE FIRST FLOOR PRIVATE BATHROOMS INSTALLATION INVENTORY CLASS MATERIAL USAG
108. OWN PERIOB 10 PROJECT GA01 PROJECT SCAN PROJECT PROJ DESCRIPTION HOT1 FIRST FLOOR PRIVATE BATHROOMS FL2 HOT1 FLOOR 2 PRIVATE BATHROOMS FL3 HOT1 FLOOR 3 PRIVATE BATHROOMS FL4 HOTI STAFF BATHROOMS TOILETS 01 lt gt GAME GAME PARK 1 GA02 GAME STAFF QUARTERS PRIVATE 0 GAME VIP GUEST SUITE Puls CAN ma LOGCGRE PLO DSC DALI Level 1 PROJECT FROM TO 4 characters Enter or scan for the project for which operations are to activated and or pro rata percentages calculated Level 2 ACTIVATE ALL OP Y N If Y is entered all operations for the selected job will automatically be activated If N is entered the operator will be able to activate individual operations JC Set up and Run JULY 2006 2 37 TITAN 2000 The following two prompts only display if you selected the interim billing option in JCOO System record Maintenance CALCULATE PRO RATA Y N If Y is entered the system will calculate a pro rata percentage for each operation according to its relation to the job as a whole PRO RATA ACCORDING TO 1 Use Planned costs to derive the pro rata percentage 2 Use Planned Sales to derive the pro rata percentage When calculating the pro rata percentage the program uses one of the two values above to recalculate the operation cost as a percentage of the job cost or the operation sales value as a percentage of the job sales value JOB COSTING OPERATIONS A
109. OWN PURCHASE ORDERS TRANSACTIONS SEQUENCE 1 POST TO JC ALT KEY SCAN ALTERNATE SEQ FROM 1 011000 1 TO 01011000 1 CO BR PO LINE TYP AUD ALTERNATE CODE VENDOR 01 01 0000167 yf T 4 lt gt 01011000 1000 01 01 0000168 01 01 000177 10 R I 01 01 0000165 1 REC 01 01 PO000165 2 REC 01 01 000177 10 R I 01 01 PO000166 1 REC 01 01 000179 TORI T 01 01 000178 01 01 000185 10 R I 01011000 1000 01011000 1000 01011000 1000 01011000 1000 01011000 1000 01011000 1000 01011000 1000 01011000 1000 01011020 1020 CO XO F2 Q0 OO 1 O1 Es 2 SCAN FS SEQ Fb CODES FID ALI 1 32 JULY 2006 Job Costing User Guide TITAN 2000 Level 2 ALTERNATE SEQ FROM TO f Once the alternate sequence has been entered the Purchase Order file may be accessed in that sequence JORR COSTING SSE OSUE DATES lO ANT 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PURCHASE ORDERS TRANSACTIONS ALTERNATE SEQUENCE ALT1 POST TO JC CONSOLIDATION Y N PAGE SKIP Y N COMPANY N BRANCH N VENDOR N VENDOR REFERENCE N N N N N ES ACCEPT RANGE 59517 Depending on the sequence created a number of options will be displayed MONTH END DATE YYYY MM DD Enter the date up to which you want purchase order details to post to Accounts payable PRINT
110. P is a soft term which you may redefine in SU30 Installation Maintenance Option 4 This field is not available to the operator but is filled in by the system from the unit of time applying to labour 7 4 digits You need only complete this if you intend using JC79 Work Centre Productivity If so refer to that program in this User Guide for more information 10 characters This describes the overhead type For instance MANAGEMENT for an appropriation of Management Fees or W amp L for an appropriation of water and electricity costs 5 4 digits R Rate P Percentage If rate it is the same unit as the labour rate If percentage then it is of the total overheads 4 characters This is the cost category to which this specific overhead is to be allocated These categories are set up in program JC32 Cost Category Maintenance Enter Y under each transaction type to which this overhead applies Leave the position blank if it does not apply Transaction types are displayed at the bottom of the screen Press F1 to proceed to the next level of the WORK CENTRE MAINTENANCE 3 136 JULY 2006 Job Costing User Guide TITAN 2000 JOB COSTING WORK CENTRE MAINTENANCE Jess Lil 0001 01 TECHNOLOGIES INCORPORATED BR DI TOWN PERTOD 10 WORK CENTRE QUEUE TIME MACHINE CAPACITY LABOUR CAPACITY 0 0000 I i 1 0 0000 HOURS PER WEEK 0 0000 HOURS PER WEEK NUMBER OF MACHINES PRO
111. PLATE INPUT 4JC20 iere cae etcetera Eck Ped 76 3 9 JOB MAINTENANCE FAST MATERIALS INPUT 21 85 3 10 JOB COST INPUT FAST MATERIALS INPUT 22 94 4 MAINTENANCE MODULE 6 niinc cris in das a Cn dx da Ga dada acd asas 101 4 1 THE MAINTENANCE MODULE 101 4 2 JOB OPERATION 630 102 4 2 1 X ADDING NEW ener 103 4 2 2 UPDATING EXISTING JOBS ENQUIRIES sees 117 4 3 ALTERNATE FILE 631 eere 118 44 COST CATEGORY MAINTENANCE JC32 sse 123 441 ENTERING COST CATEGORIES eese 124 4 4 2 UPDATING COST CATEGORIES esee 126 4 4 8 DELETING COST 7 126 444 UPDATING JOB COSTING ANALYSIS 127 4 5 TRANSACTION TYPE MAINTENANCE JC33 eee 128 451 CREATING TRANSACTION 129 4 5 2 UPDATING TRANSACTION 134 4 5 3 DELETING TRANSACTION 134 4 6 WORK CENTRE 635 135 4 6 1 ENTERING NEW WORK 138 4 6 2 UPDATING WORK 139 4 6 3 DELETING WORK 139 b ENQUIRY MODULE 22 rra b ixrakas ax ci
112. PRINT REPORT SEQUENCE PROCEED WITH PRINT JCxx This form is set up in program SU35 Customised Form Maintenance form type JC Y N Enter Y if a test print is required This is normally the case where the correct line up of a pre printed form is essential 1 by project 2 by job Y N Accept the information or alter any incorrect entries Press F10 to return to the form selection screen The Esc key will end the program 3 106 JULY 2006 Job Costing User Guide Level 3 TITAN 2000 If on level 2 the you indicated that the job consists of more than one operation a further screen will now be presented for entry JOB COSTING JOB OPERATION MAINTENANCE JC30 I CO DI TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN OP HEADER DETAILS JOB OPERATION DESCRIPTION WORK CENTRE START DATE END DATE SCHEDULED Y N ACTIVE Y N STATUS PRO RATA PERCENTAGE DETAILS OK Y N UPDATE OP OPERATION DESCRIPTION WORK CENTRE START DATE END DATE SCHEDULED Y N ACTIVE Y N JC Maintenance PERIOD 10 J104 CONSTRUCTION PROJECT INTER CIT 0040 LAYING FOUNDATIONS 1 WC 300X1 LABOUR ALLOCATION 89 05 20 90 05 31 Pa A 1 PROPOSING QUOTING 15 00 i M 2 ESC 4 characters digits depending on the definition in program JCO00 System Record Maintenance This field s name i e operation will be taken f
113. PRO RATA eai 38 CALCULATED COSTS en rU BRI OP Un SO Hn 114 CALCULATED ORD EE 214 CALCULATED R ET ene na Eoo eee eee Een 213 CALCULATED OP ORD 3 triti enne teret rri eae ci ene a Enea eee eee 112 114 CALCULATED OVEREEAD treten reete certet n rer eru tnde ere dung ala eg vae ee abere nip buen 205 CAPTURE ESTIMATES ic c 17 58 adie aad aaa ee dee ei 47 66 70 74 97 124 202 CATEGORY DIVERSION S 209 CATEGORY DESCRIPTION eret irent 202 CATEGORY REPORT 170 avian ae alas eine clover 80 88 108 CATG ANALYSIS LEVEL rehus rie soe tier ert FO iet 77 86 104 GB I ede 129 CODE 14 16 19 COMMITTED COST ettet fr ret ier eds ett e t al ee 205 CONMPANY EU EU Icd 197 COMPANY IDESGRIPTION icc diede rd 197 ee reg ds 62
114. PRODUCT ISO DOC Y N Y N Because of page width limitations it is not possible to print both product code and document number The standard report prints the document number Y will print the product instead VALIDATION ONLY Y N Y N Y To produce an audit trail without posting N Will produce an audit trail and update simultaneously We strongly recommend that you do a validation only check that the report shows the details as required and only THEN post The program prints an audit trail detailing action taken on all records read from the purchase order file JC Set up and Run JULY 2006 2 33 TITAN 2000 2 8 YEAR END CLEARDOWN JC93 The program sets to zero the year to date costs on JCMAST actual and standard costs for each of the nine transactions It clears the categories on JCANAL for the period Enter JC93 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide JOB COSTING YEAR END CLEARDOWN wens 11 001 01 TECHNOLOGIES INCORPORATED BRE DI CAPE PERIODO 12 PROCEED WITH CLEARDOWN wil COs ESC Level 1 PROCEED WITH CLEARDOWN f Y N Enter Y to continue The status line displays the other options available 1 34 JULY 2006 Job Costing User Guide TITAN 2000 2 9 JOB DELETION JC94 The program deletes sp
115. QUENCE CODE 2 eene tu toe dre Ret Bc re LG ce LR icc 32 102 118 ANALYSIS 163 APPLY ON TRANS 5 ierra ttp rte eer eut 136 AR BATCH E P 55 55 AECINVOIGE uiuere A Ce 55 ARCHIVE DELETED to reete et nett re eter reet iere roger gms 13 AUDIT INOMBER ise citra iret te ttr trac eerta tri neant nde ta tenete rn tace aenea enn rta nn 209 AUDIT TRAIL CURRENT 2 c208 179 AUDIT HISTORY iid eif E bo ih P ite uin i eo ise A EU de bt E Feo pue eus 182 B nsectetur rd nee 45 95 BATCH GOMPLETED mereri tete rnit da tendra meon dein des rts 54 100 Wecker 45 95 BILLED AMOUN Em 199 BILLED COST eG eee 205 BILLED COS ICE 84 93 116 BILLED SALES et rete tri ttt ere tester Legat 84 93 116 205 BODY o n 196 BRANG T 197 BRANCH DESCRIP TONG fetes uM UII 197 BRANCH E 75 Index 216 TITAN 2000 C CALCULATE
116. R PRIVATE BATHROOMS OPERATION PREP DESCRIPTION SITE PREPARATION WORK CENTRE START DATE 92702720 END DATE 92740197227 SCHEDULED Y N ACTIVE Y N STATUS PRO RATA PERCENTAGE EIU ESC EXIT JC Enquiry JULY 2006 5 147 6 1 THE PRINT MODULE MENU This module consists of the following report programs JC70 JOB LISTING JC71 JOB COST SUMMARY JC72 JOB COST DETAILS JC73 REQUISITION NOTES JC74 COST TYPE BY JOB JC75 SCRAP ANALYSIS JC76 WORK CENTRE ANALYSIS JC77 ACTION REPORT JC78 COST CATEGORY REPORT JC79 WORK CENTRE PRODUCTIVITY JC80 AUDIT TRAIL CURRENT JC81 AUDIT TRAIL HISTORY TITAN 2000 6 PRINT MODULE This module makes extensive use of exception based reporting techniques This facility enables only that data which matches the selection criteria to be extracted and printed Each print provides an applicable selection range The selection range is pre loaded with the most commonly used selection criteria All print programs provide an option to either print directly to the printer or to the report management system Enter JC7 to display the print module menu 6 148 JULY 2006 Job Costing User Guide TITAN 2000 6 2 JOB LISTING JC70 The program prints static data applying to jobs operations and a summary of costs at job level Enter JC70 to select the program The Report Destination Company Branch combination and Report date may be optionally sele
117. RK CENTRE STD HOURS OVERTIME 1001 J WOODS 92 02 27 WED 18 3 92 02 27 WED 18 3 1002 F EDWARDS 92 02 27 WED 18 3 92 02 27 WED 18 3 10 0000 1000 00 1003 A ADAMS 93 11 17 ABBY 10 0000 B 45 0000 1005 HGB VAN ZYL 93 11 16 93 11 16 93 11 16 93 11 16 15 0000 1006 K L SUMNER 93 11 16 93 11 16 1007 MD GRANGER 93 11 16 25 0000 JC79 Work Centre Productivity 6 178 JULY 2006 Job Costing User Guide TITAN 2000 6 12 AUDIT TRAIL CURRENT JC80 The program prints a Job Costing audit trail with a number of option levels Enter JC80 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide JOB COSTING AUDIT TRAIL 01 TECHNOLOGIES INCORPORATED 01 CAPE TOWN REPORT SEQUENCE JOB TRANSACTION DATE COST OPTION PRINT SUBTOTAL Y N DETAILS OK Y N 1 MESO 11 002 PERIOD 10 BY PERIOD BY DATE BY TRANSACTION BY CATEGORY BY WORKCENTRE 98 01 27 98 02 27 1 Y Y ACTUAL COSTS STANDARD COSTS SALES HOR MPEINIOEISUONS SSEIUEM RIED Level 1 REPORT SEQUENCE JOB PERIOD TRANSACTION CATEGORY WORK CENTRE JC Print 1 By Job Operation 2 By Period 3 By Date 4 By Transaction 5 By Category 6 By Work centre Enter one of the abo
118. RPORATED BR 01 CAPE TOWN JOB GROUP DETAILS LONG TERMINOLOGY PROJECT SHORT TERMINOLOGY PROJ CODE ALPHA NUMERIC COSTING PARAMETERS DEFAULT UNIT COST FOR JC10 ZERO JC20 JOB OP TEMPLATE COST JEZI CURRENT JC33 DEFAULT JC22 Fl JOB DETAILS F2 SYSTEM DETAILS UPDATE FS DELETE E9 PRINT LONG TERMINOLOGY 10 characters Enter the long terminology to be used by the system for Job Group for instance PROJECT SHORT TERMINOLOGY 4 characters Enter the short terminology to be used by the system for Job Group for instance PROJ CODE 1 character A Alpha numeric N Numeric Enter the format of the code 1 14 JULY 2006 Job Costing User Guide TITAN 2000 COSTING PARAMETERS You may use the prompts below to indicate which costs should be used as a default in the Job Costing input programs There are 4 prompts relating to programs JC10 Job Cost Input JC20 Job Template Input JC21 Job Maintenance Fast Materials Input and JC22 Job Cost Input Fast Materials Input respectively JOB COSTING SYSTEM RECORD MAINTENANCE JCOO0 11 002 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN JOB GROUP DETAILS LONG TERMINOLOGY PROJECT SHORT TERMINOLOGY PROJ CODE A ALPHA NUMERIC COSTING PARAMETERS DEFAULT UNIT COST FOR JC10 ZERO JC20 JOB OP TEMPLATE COST IEZI CURRENT JC33 DEFAULT Jic PI JOR DETAILS 72 SYSTEM DETAILS Fo UPDATE ES DELETE PRINT DEFAUL
119. S ON ENTERING JOB OPERATIONS AT LEVEL 5 When capturing data at this level the system allows the following scan facilities while entering estimates By using the F5 key the lower right hand quarter of the screen may display different information JC Maintenance JULY 2006 4 109 TITAN 2000 SCREEN 1 The following information relating to the operation details is displayed Estimated Actual and Billed Sales Estimated Committed Actual and Billed costs JOB COSTING JOB OPERATION MAINTENANCE UCZO 7 005 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 JOB FL1 INST FIRST FLOOR PRIVATE BATHROOM INSTALLATION TRANS 1 INVENTORY CLASS SET CLASS JC33 CATG 7000 MATERIAL COSTS INSTALLATIONS PRODUCT 001 1WB WIT 46 1 WHITE CASCADE HANDSHOWER SPIRA SALESMAN 1 PRODUCT GROUP 1 ESTIMATED PLANNED COSTS DETAIL COSTS QUANTITY 16 00 EACH ESTIMATED SALES UNITCOST 20 0000 1 320 0000 ACTUAL SALES OVERHEAD 0 0000 BILLED SALES TOTAL 320 0000 ESTIMATED COSTS SUGGESTED SALES 320 008 COMMITTED COSTS EXPECTED PROFIT 060000 1 ACTUAL COSTS BILLED COSTS 2 TOE DETAILS UPDATE FS TOGGLE FS DELETE FID UE SCAN SCREEN 2 The following information relating to the job as a whole is displayed Estimated material usage Labour costs Computed overheads and Other JOB COSTING JOB OPERATION MAINTENANCE UEZO 17005 CO 01 TECHNOLOGIES INCORPORATED DI CAPE
120. SACTION TYPE 0 ALL TRANSACTION DATES 92 01 27 TO DATE 92 02 27 DETAILS OK TRANSACTION TYPES 1 INVENTORY OTHER 7 NOT USED 2 LABOUR LAB NOT WP 8 NOT USED SE CARED OHD NOT USED S NOT USED HON TPRI IN OPENS ON ING jaca FROM WORK CENTRE TO WORK CENTRE The default is all work centres or enter the starting and ending work centre range It is possible to scan all the work centres on file by using the F1 key TRANSACTION TYPE Enter the appropriate selection The types are listed on the screen A zero will print all transaction types TRANSACTION DATE Enter the appropriate date range for the transactions Only transactions falling within this range will be selected for printing PROCEED WITH PRINT s Y N Accept the information or alter any incorrect entries Press F10 to return to the company branch selection screen The Esc key will end the program 6 166 JULY 2006 Job Costing User Guide TITAN 2000 TECHNOLOGIES INCORPORATED JOB COSTING WORK CENTRE ANALYSIS DATE 98 05 11 11 18 PAGE CAPE TOWN JC76 11 007 PERIOD OPTIONS FROM WORK CENTRE ALL TO WORK CENTRE END TRANSACTION TYPES 0 ALL TRANSACTION DATES FROM 01 01 01 TO 99 12 31 WORK CENTRE STD LABOUR RATE 25 0000 PER HOUR STD SETUP RATE 4 PER HOUR LABOUR TRANSACTIONS DATE REFERENCE JOB CATEGORY EMPLOYEE HOURS COST CALCULATED OHD 89 05 11 2 1101 00008 CONRAD 6 0000 0000 144 0000 89 05 11 2 11
121. T UNIT COST FOR 1 Enter the required default unit O Zero J Job OP Template Cost C Current JC33 Transaction Type Maintenance default Press F1 to proceed to the Job Detail level The status line displays the other options JC Set up and Run JULY 2006 2 15 TITAN 2000 Level 3 JOB DETAILS You may select your own terminology for job job group and operation A long description and a short description is available in each case JOB COSTING SYSTEM RECORD MAINTENANCE JCOO0 11 002 CO 01 SEAGULL SOFTWARE CC BR 01 MAIN BRANCH PERIOD OL JOB DETAILS LONG TERMINOLOGY 1 SHORT TERMINOLOGY CODE A ALPHA N NUMERIC USE START END DATES Y N VALIDATE CUSTOMER Y N DEFAULT CATG ANALYSIS LEVEL 1 JOB OP 2 JOB 3 BRANCH SPECIFY OPERATIONS Y N CAPTURE ESTIMATES Y N DEFAULT ESTIMATING LEVEL 0 NONE aM OR 2 TRANS 3 ITEM DEFAULT EXP PROFIT LEVEL 1 JOB 2 DEFAULT CATG FROM JOB Y N ALLOW BLANK CUSTOMER ORDER JOB PRINTING DEFAULT FORM FOR JC30 FOR JC1O FI OPS FZ JOB GRP EF3 UPDATE FA COPY FS DELETE FO PRINT LONG TERMINOLOGY 10 characters Enter the long terminology to be used by the system for Job for instance JOB SHORT TERMINOLOGY 4 characters Enter the short terminology to be used by the system for Job for instance JOB CODE s 1 character A Alpha numeric N Numeric Enter the format of the code USE START END DATES Y N Y in this fiel
122. TIMATE 9 4 digits This represents the total cost estimate for all operations for a single job It is broken down in the 9 transaction types ACTUAL CUMULATIVE 9 4 digits This represents costs incurred to date The F7 key will toggle the display between actual and standard costs VARIANCE 9 4 digits The variance is a calculated figure representing the difference between the two previous fields ESTIMATED COST TO COMPLETE 9 4 digits This is a calculated field representing the estimated costs to complete the job QUOTE 9 4 digits This represents the total of all the Suggested Selling Price fields held on the individual operations relating to this job 3 92 JULY 2006 Job Costing User Guide TITAN 2000 EXPECTED PROFIT 9 4 digits This field represents the difference between the total value of the estimate and the value quoted EXPECTED PROFIT 3 4 digits This field is calculated using the estimated cost and selling values BILLED COSTS 9 4 digits BILLED SALES 9 4 digits The above two fields are updated by the system and are not available for entry Press F3 to end entry for the operation JC Input JULY 2006 3 93 TITAN 2000 3 10 JOB COST INPUT FAST MATERIALS INPUT JC22 The program caters for the input of costs to any job operation according to the transaction types and cost categories as set up in program JC30 Job Operation Maintenance It differs from program JC10 Job Cost Input in that
123. TION DETAILS JOB DESCRIPTION J101 DRAWING OF PLAN A INVENTORY LABOUR CALCD OHD OTHER INVENTORY TRANSACTIONS DATE REFERENCE OP 89 05 11 2 PRODUCT CATG 11 1200 LABOUR TRANSACTIONS DATE EMP LOYEE CATG 89 05 11 00008 CONRAD J102 DRAWING OF PLAN FOR B TYPE INVENTORY LABOUR CALCD OHD OTHER INVENTORY TRANSACTIONS DATE REFERENCE OP 89 04 23 2 PRODUCT CATG 0010 1230 JC Print JOB COSTING JOB COST DETAILS JOB WITH STATUS CODE TYPES ALL 1 PROPOSING QUOTING CLAW HAMMER HOURS 6 0000 RUN TIME 1 PROPOSING QUOTING STEEL BOLTS 100 JC72 Job Cost Details DATE TOTAL COST QUANTITY UOM 12 0000 RATE 40 0000 QUANTITY UOM 5 0000 JULY 2006 98 05 11 11 JC72 11 007 RATE 300 0000 COST 240 0000 240 0000 RATE 12 0000 107 PAGE PERIOD COST 3600 0000 CALCULATED OHD 144 0000 144 0000 COST 60 0000 6 157 TITAN 2000 6 5 REQUISITION NOTES JC73 The program prints a user defined report requisition note using any of the data available on the job operation file current as well as history details It can print such details as company branch and project descriptions start and end dates operation details with its associated work centres and categories In addition it prints planned values as well as transaction quantities and values Provision has also been made for free form titles Enter JC73 to select the program Level 1 JO
124. TITAN 2000 USER GUIDE JOB COSTING TITAN 2000 COPYRIGHT RESERVE The Copyright in this manual vests exclusively with The Titan Trust All rights are reserved No part of the manual may be modified added to reproduced transmitted transcribed stored in a retrievable system or translated into any language in any form or by any means electronic mechanical magnetic optical chemical manual or otherwise in whole or in part without the prior consent of The Titan Trust Any unauthorised use of this manual in whole or in part will result in legal action being taken against such user DISCLAIMER The Titan Trust hereby disclaims any and all guarantees and warranties on this manual or on the documentation relating to or backing up this manual the documentation and specifically disclaims any implied warranties of the merchantability or fitness of this manual or the documentation for any particular purpose This manual and documentation are sold on an as is basis any user of this manual or the documentation uses it entirely at his own risk The Titan Trust reserves the right to revise the publication and to make changes from time to time in this manual and the documentation The Trademark in the name Titan is registered in the name of The Titan Trust Any unauthorised use of the name Titan will result in legal action being taken against such user OTHER TRADEMARKS ACUCOBOL is a registered trademark
125. TOWN PERIOD 10 JOB FL1 INST FIRST FLOOR PRIVATE BATHROOM INSTALLATION TRANS 1 INVENTORY CLASS SET CLASS JC33 CATG 7000 MATERIAL COSTS INSTALLATIONS PRODUCT 001 1WB WIT 46 1 WHITE CASCADE HANDSHOWER SPIRA SALESMAN 1 PRODUCT GROUP 1 ESTIMATED PLANNED COSTS QUANTITY 16 00 EACH MATERIAL USAGE UNITCOST 20 0000 1 320 0000 LABOUR OVERHEAD 0 0000 COMPUTED O HDS OTHER TOTAL 320 0000 SUGGESTED SALES 5 20 0 0 1 TOTAL EXPECTED PROFIT 0 0000 1 DETAILS F3 UPDATE F5 TOGGLE Fo DELETE FIO OP 3 110 JULY 2006 Job Costing User Guide TITAN 2000 SCREEN 3 The following information relating to the job as a whole is displayed Estimated and Actual costs for all nine possible transaction types JOB COSTING JOB OPERATION MAINTENANCE CO 01 TECHNOLOGIES INCORPORATED ESO E008 BR 01 CAPE TOWN JOB OP TRANS CATG ELI INST FIRST FLOOR 1 INVENTORY CLA 7000 MAT PRODUCT 001 1WB WIT 46 WHI SALESMAN PRODUCT GROUP ESTIMATED PLANNED COSTS QUANTITY 16 00 EACH UNTTCOS TEI 20 0000 1 OVERHEAD 3 TOTAL SUGGESTED SALES EXPECTED PROFIT 3 E 0 000 9 Ea OP DETAILS UPDATE FERIOD 10 PRIVATE BATHROOM INSTALLATION SS SET CLASS JC33 ERIAL COSTS INSTALLATIONS TE CASCADE HANDSHOWER SPIRA JOB COSTS ESTIMATED LLY S D296 1440 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 0 0000 ASZLS BANG
126. The SIV if the report is printed from JC10 JOB COST INPUT or JC11 JOB COST INPUT INTERFACE TO AR TITLE DETAILS There are numerous screens providing up to 999 titles of 30 characters each These may be used to make your document more readable For instance if you have no PAGE NUMBER pre printed on your requisition you may use the titles to print this Or if legislation requires that you must always print your own VAT Registration number on all documents you may use this facility rather than go to the expense of having your stationery re or over printed Appendix 215 INDEX 5 COMPLE TE 150 152 9 LEES 125 DEBTORS AGE PERIOD eterne inrer iti x 57 ACCUMULATED COSTS DEFAULT isiin eerta e 13 AC TIONIBEEORT ren ares 168 ACTIVATE ACE OR m e 37 ACTIVATE OPEBATIONS irent eret nitet e a iere Re eT E rv 37 ACTIVE ies 202 79 88 107 ACTUAL GALGULATED OVERHEADS 3 nitidi eerie tiet idet rre rc RE deae dade 211 ACTUAL COST T 211 ACTUAL CUMULATIVE tet cite ere el ee t Fr eder epe 83 92 115 AGTUAEL RA TE orem EEUU 211 ACTUAL SALES
127. W PAGE PER PROJ NEW PAGE PER JOB PROCEED WITH PRINT PROCESSING GAME GA02 FROM JOB TO JOB The default is all jobs or enter the starting and ending job range It is possible to scan all the jobs on the file using the F1 key The F5 key will toggle the scan between job and project sequence JOB WITH STATUS CODE Enter the required status code entered in 5031 type JS or enter a zero for all status codes TRANSACTION DETAILS Y N Enter the correct selection Y will print the details for each individual transaction as entered in program JC10 Job Cost Input whereas N will only print summarised figures for each transaction TRANSACTION TYPE Enter the appropriate selection The types are listed the screen A zero will print all transaction types JC Print JULY 2006 6 155 TITAN 2000 TRANSACTION DATE DD MM CCYY Enter the appropriate date range for the transactions This entry will only be required if the response to the previous question was Y NEW PAGE PER PROJ Y N Enter Y to start each project on a new page NEW PAGE PER JOB Y N Enter Y to start each job on a new page PROCEED WITH PRINT Y N Accept the information or alter any incorrect entries Press F10 to return to the company branch selection screen The Esc key will end the program 6 156 JULY 2006 Job Costing User Guide TECHNOLOGIES INCORPORATED CAPE TOWN OPTIONS FROM JOB ALL TO JOB TRANSAC
128. al class type further scans of employees stock codes or category codes may be available Scan these and accept the record 5 144 JULY 2006 Job Costing User Guide TITAN 2000 Level 4 JOB COSTING JOB OPERATION ENQUIRY 01 TECHNOLOGIES INCORPORATED Be 1 CAPE TOWN PERIOD 10 JOB ELI FIRST FLOOR PRIVATE BATHROOMS OPERATION INST INSTALLATION TRANSACTION TYPE 1 INVENTORY CLASS MATERIAL USAGE PRODUCT 001 1WB WIT 46 WHITE CASCADE HANDSHOWER SPIRA REFERENCE DATE CATG QUANTITY sec S2 02 27 7000 ACTUAL 16 00 2 92 02 27 ACTUAL 1010 reese INTO T TEMS Pee Fl SCAN FILE FIO OP ESC EXIT As soon as a date range has been entered the transaction falling within that range will be displayed Further selections are FUNCTION KEY FACILITIES 1 SCAN to scan the operations relating to the job currently being viewed to return to the previous screen F10 toenter or scan another job number to end the program JC Enquiry JULY 2006 5 145 TITAN 2000 5 3 JOB OPERATION HEADER ENQUIRY JC51 The program provides a fast enquiry facility into job and operation header details Enter JC51 to select the program JOB COSTING JOB OPERATION HEADER ENQUIRY cid aba 00 7 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 15 JOB HEADER DETAILS JOB DESCRIPTION FIRST FLOOR PRIVATE BATHROOMS PROJECT HOT1 RAILWAY HOTEL PRIVATE BATHS
129. alysed at branch level Y N A Y in this field is mandatory JULY 2006 ESTIMATING LEVEL EXP PROFIT LEVEL REFERENCE REFERENCE QTY DETAILS OK Level 3 TITAN 2000 1 digit Enter 3 mandatory for this program No other entries may be made This will be at item level i e every transaction will be itemised individually Enter the level at which profits are to be monitored 1 at job level 2 at operation level 8 characters This reference will be carried through to the Inventory Transaction File when issuing materials to a job in program JC22 Job Cost Input Fast Materials Input 7 2 digits This is only a memorandum field and may be left as a zero Y N Accept the details entered to proceed to the next screen or amend any incorrect details If you indicated that the job consists of more than one operation a further screen will now be presented for entry JOB COSTING JOB TEMPLATE INPUT JC20 11 003 01 TECHNOLOGIES INCORPORATED BRE 1 CAPE HEADER DETAILS JOB OPERATION DESCRIPTION WORK CENTRE START DATE END DATE SCHEDULED Y N ACTIVE Y N STATUS PRO RATA PERCENTAGE DETAILS OK Y N EIU OP ESC EXIT OPERATION PEBIOD 10 TMP1 TEMPLATE FOR HOTEL FLOORS 1 4 INST INSTALLATION 92 02 27 22010072711 IN PRODUCTION 0 00 4 characters digits depending on the definition in program JCOO System Record Maintenance JULY 2006 Job
130. any branch combination that will be used on the system 1 10 JULY 2006 Job Costing User Guide TITAN 2000 2 2 THE SYSTEM PARAMETER FILE MAINTENANCE JC00 The program will test whether the Job Costing System data files are present If not it will automatically create them The system parameter file defines global parameters that will apply to the Job Costing system These parameters need to be set up for each company and branch combination that are required Enter JCOO to select the program Press F3 to save the parameters once they have been completed On all screens there is an F4 COPY facility which allows you to copy all the details entered from the currently selected Company and Branch to a different Company Branch combination If details exist you will be warned but will be able to continue if required The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide JC SetupandRun JUY206 2 M Level 1 SYSTEM DETAILS Enter the following fields YEAR END DATE PERIOD TITAN 2000 DD MM CCYY Enter the financial year end for this company and branch for example 28 02 91 2 digits Enter the financial period Current period in which data is to be taken on for example 03 for May if the company s year end is the 28th February JOB COSTING SYSTEM RECORD MAINTENANCE Je 11 103 01 TECHN
131. ated overheads that have accumulated for this operation Appendix 205 EXPECTED PROFIT EXPECTED PROFIT PERCENTAGE PRO RATA PERCENTAGE Appendix 206 TITAN 2000 9 2 digits This is calculated as the difference between the estimated cost and the suggested sales 3 4 digits This is the same figure expressed as a percentage 3 2 digits For use with Interim billing auto allocation BODY 4 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE BODY 4 JOB COSTING SOFT FORMS OPERATION DETAILS ACTUAL TITAN 2000 SUS omer le AD OK DGT DEC QUANTITY ISSUED SETUP TIME USED RUN TIME USED QUANTITY OUTSTANDING SETUP TIME OUTSTANDING RUN TIME OUTSTANDING INVENTORY PHYSICAL STOCK FREE STOCK IS THE ABOVE INFORMATION CORRECT Y N 1 F2 PREVIOUS F3 SAVE F8 DELETE F9 PRINT 10 FORM ESC EXIT OPERATION DETAILS ACTUAL QUANTITY TIME USED QUANTITY ISSUED SETUP TIME USED RUN TIME USED QUANTITY OUTSTANDING SETUP TIME OUTSTANDING RUN TIME OUTSTANDING 7 2 digits Total quantity issued for the operation 7 2 digits Total setup time issued for the operation for labour type transactions 7 2 digits Total run time issued for the operation for labour type transactions 7 2 digits Difference between the estimated quantity required and the quantity used 7 2 digits Difference between the estimated
132. ay be altered JULY 2006 3 81 TITAN 2000 Level 5 for transaction type LABOUR JOB COSTING JOB COST INPUT FAST MATERIALS INPUT 7 22 11 7008 01 TECHNOLOGIES INCORPORATED BR Ol CAPE TOWN BATCH 7 JOB OPERATION TRANSACTION TYPE CATEGORY EMPLOYEE WP CODE WORK CENTRE PERIOD DOC DATE REFERENCE DIVERSION HOURS BOOKED RATE TOTAL COST DETAILS OK PERIOD 12 LINE 1 FLL NOT ON FILE FIRST FLOOR PRIVATE BATHROOMS INSTALLATION LABOUR CLASS LABOUR COSTS SCOTT BASIC PAY LABOUR MANUF 151 USAGE 0 00 92 03 24 7 0 0000 12 200700 1 0 0000 UR gel deu SCRAP SCRAP COST 0 00 1 ACTUAL 0 0000 1 Y FACTORY PLANNING COSTING ACCHE 4 REVIEW 10 BATCH HEADER ESC EXIT ESTIMATED PLANNED COSTS SET UP TIME SET UP RATE 9 4 digits Enter the number of time units required to set up this job operation combination 9 4 digits This rate is duplicated from the cost category or WP code specified previously A calculated set up cost field is displayed but not available for entry RUN TIME RUN RATE OVERHEAD TOTAL 9 4 digits Enter the number of time units required to set up this job operation combination 9 4 digits This rate is duplicated from the cost category or WP code specified previously 9 4 digits This represents a contingency overhead to b
133. ber of finished items created by job and is used by this program when calculating default quantities and prices Enter JC13 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 COSTING CREATE INVOICE IN SP JE13 11 002 01 TECHNOLOGIES INCORPORATED BR Dl CAPE TOWN PERTOD 02 PROJECT AF01 AFFANE PROJECT PROJ DESCRIPTION M CUST STATUS LAST INVOICE 02 5 1000 BLA BLA DI BLA DI BLA 10 COLI COL TEST JOB VIA JC10 1050 COLP ENTER JOB DETAIL VIA JC17 1050 DP DAWN 1000 DP1 DP 1000 POSTED HOT1 TEMPLATE FOR HOTEL FLOORS 1 4 1010 HOT1 FIRST FLOOR PRIVATE BATHROOMS 9004 POSTED FL2 HOT1 FLOOR 2 PRIVATE BATHROOMS 9004 POSTED FL3 HOT1 FLOOR 3 PRIVATE BATHROOMS LOOT FL4 HOT1 STAFF BATHROOMS TOILETS 9004 COMPLETED FS HOT1 TEMPLATE FOR HOTEL FLOORS 1 4 9004 GAO1 GAME GAME PARK Al 1 1 ES CON ENUF TO muro PROJECT 4 characters Scan the file or enter a Project Job Remember the JC30 Estimating level must be 3 for item and you must specify operations PRINT ITEMS ON INVOICE Y N Items may selectively print on the invoice The entry you make here will be the default for all line items on the following screen DOCUMENT TYPE 1 digit Select whether you wish to create an invoice or credit note 1 Invo
134. change this ALLOW BLANK CATEGORY IN JC13 Y N If yes you will not be forced to enter a Category JC13 USE ESTIMATES ACTUALS E A Specify whether you wish to invoice from estimates or actuals in JC13 Create SP Invoice from Operations If you use actuals in JC13 Create SP Invoice from Operations then the selling price specified on the debtor will be used and you will be able to enter a global route and representative code 1 22 JULY 2006 Job Costing User Guide TITAN 2000 FORMULA DETAILS JOB COSTING SYSTEM RECORD MAINTENANCE Jcoo 11 005 01 TECHNOLOGIES INCORPORATED 01 CAPE TOWN PERIOD 9 POSTING DETAILS CREATE OPERATIONS WHEN POSTING UPDATE ESTIMATED FIGURES JC19 4 5 7 REDUCE COMMITTED COSTS WHEN POSTING ISSUE PRODUCTS TO JOB VIA JC92 USE JC10 TO ISSUE JC13 TO INVOICE ALLOW BLANK CUSTOMER ORDER IN JC13 ALLOW BLANK SALESMAN EN ELSE ALLOW BLANK PRODUCT GROUP IN JC13 JC13 USE ESTIMATES ACTUALS E A FORMULA DETAILS USE INTERIM BILLING AUTO ALLOCATION PRO RATA FORMULA PI COSIS EZ OP DETAILS UPDATE F5 DELETE F9 PRINT USE INTERIM BILLING AUTO ALLOCATION Y N Please see Appendix A2 PRO RATA FORMULA This prompt displays only if you answer Y to the one above This is a special formula set up in program 5037 Formula Maintenance It is used in program JC96 Operations Activate and in program JC19 Contract In
135. characters scan is available as aid but this field may be left blank DD MM CCYY DD MM CCYY Entry of these two dates will only be requested if this option has been selected in program JC00 System Record Maintenance Y N This field is for memorandum purposes only Y N This field is for memorandum purposes only 1 character A scan on this field is available but this field may be left blank 3 2 digits Y N Enter Y to proceed to the next level 1 digit The transaction types may be displayed on the screen by using the scanning facility The appropriate one for this operation should be selected 4 digits This refers to the cost categories set up in program JC32 Cost Category Maintenance Scan the cost categories or enter the required one Job Costing User Guide EMPLOYEE TITAN 2000 If the transaction type entered was labour and if it was indicated in program JC33 Transaction Type Maintenance that an interface to the Wages module is required the operator will have to enter a valid employee number in this position Level 5 for transaction types MATERIAL USAGE and OTHER PRODUCT QTY REQUIRED UNIT PRICE TOTAL UNIT PRICE If the transaction type entered was material usage the inventory items as entered on the template in program JC20 Job Template Input will be displayed The F5 key may be used to toggle in the following sequences branch stock number sequence interna
136. cted Please see the GETTING STARTED section at the beginning of this user guide JOB COSTING JOB LISTING VETO 11 001 CO 01 TECHNOLOGIES INCORPORATED BR DI CAPE PERIODO 10 REPORT SEQUENCE 1 il FROM PROJ JOB ESTA FL1 TO PROJ JOB SPR1 TMP1 JOB WITH STATUS CODE 0 ALL FROM OOO COR 1 55 COCR COS OM COMETE DE LIST OPERATION 2 NEW PAGE PER PROJ NEW PAGE PER JOB PROCEED WITH PRINT PRINTING 01 01 GAME GA01 Level 1 JOB SEQUENCE 1 digits Select the sequence for the report 1 Job sequence 2 Project sequence FROM JOB TO JOB The default is all jobs or enter the starting and ending job range If you selected to print by project then you will be prompted for the project range It is possible to scan all the jobs on the file using the F1 key The F5 key will toggle the scan between job and project sequence JC Print JULY 2006 6 149 JOB WITH STATUS CODE FROM TO COMPLETE LIST OPERATIONS NEW PAGE PER JOB PROCEED WITH PRINT TITAN 2000 Enter the required status Entered in program SU31 Descriptions File Maintenance type JS or enter a zero for all status codes The default is from 0 to 100 or enter the percentage range Only jobs falling within this range will be selected for printing Y N Enter the correct selection Y will print operation details whereas N will print only summarised figures for the job as a
137. d will indicate that a job will carry start and end dates to facilitate scheduling VALIDATE CUSTOMER Y N Enter Y if the system is required to ensure that only customer numbers held on the customer masterfile of the Accounts Receivable system are to be considered valid 1 16 JULY 2006 Job Costing User Guide DEFAULT CATG ANALYSIS LEVEL SPECIFY OPERATIONS DEFAULT ESTIMATING LEVEL DEFAULT EXP PROFIT LEVEL CAPTURE ESTIMATES USE OPERATIONS DEFAULT CATG FROM JOB Y N ALLOW BLANK CUSTOMER ORDER JOB PRINTING JC Set up and Run TITAN 2000 1 digit Enter the default level for category analysis in JC30 Job Operation Maintenance Y N Indicate whether you wish to specify operations in JC30 Job Operation Maintenance 1 digit Enter the default estimating level to be used in JC30 Job Operation Maintenance 1 digit Enter the default expected profit level to be used in JC30 Job Operation Maintenance Y N If Y is entered program JC30 Job Operation Maintenance will allow the capture of estimated costs If N these fields will not be presented for entry Y N Enter Y if jobs are to have one or more operations Y N if this is set to Y then the category defaults from the Job Number when entering details in JC10 Job Cost Input This is a useful feature when your Categories and Job Numbers are the same Please note that you must set up a category in JC32 Cost Category Mai
138. d xbox arg aic ecu du a i aa 140 5 1 THE ENQUIRY MODULE 140 5 2 JOB OPERATION ENQUIRY 50 141 5 3 JOB OPERATION HEADER 651 146 PRINT MODULE i 148 6 1 THE PRINT MODULE 148 6 2 JOB LISTING dOYO best 149 6 3 JOB COST 5 71 152 6 4 JOB COST DETAILS JG72 dnte tetra ete cee 155 6 5 REQUISITION 6 73 158 6 6 GOST TYPE BY JOB GO 4 iit trt re aap eee es exert 161 6 7 SCRAP ANALYSIS JG75 aset teri la tese 163 6 8 WORK CENTRE 1 51 5 7 76 166 6 9 ACTION REPORT JGYT iicet tette tetti er eem 168 6 10 CATEGORY REPORT 41C78 trt teet seemed diede ue 170 6 11 WORK CENTRE 7 67902 176 6 12 AUDIT TRAIL 80 179 6 13 AUDIT TRAIL 8 182 APPENDIX A T 184 A 1 JOB COSTING RECORD 184 A 2 INTERIM BILLING WITH AUTO 2 188 SUPERSESSIONS eee iit rette te f n ed gol v redet edid 190 APPENDIX M 194 B1 DEFINITION OF FORM
139. de which will identify the sequence for you 3 118 JULY 2006 Job Costing User Guide TITAN 2000 Level 2 JOB COSTING ALTERNATE FILE MAINTENANCE ISS MO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN JOB COSTING MASTERFILE ALTERNATE SEQUENCE ALT1 DESCRIPTION ALTERNATE SEQUENCE BY CUST ACC HIERARCHY OF OPTIONS FOR ALTERNATE SEQUENCE HIGH PART PART PART PART PART PART PART LOW PART COMPANY COMPLETION DATE BRANCH STATUS JOB CATEGORY LEVEL PROJECT PROFIT LEVEL CUSTOMER COMPANY ESTIMATING LEVEL CUSTOMER BRANCH TEMPLATE POSTED CUSTOMER ACCOUNT REFERENCE DESCRIPTION USER DEFINED 1 OPERATIONS USED USER DEFINED 2 COMMENCEMENT DATE USER DEFINED 3 O01 CO PO S OOoooctUu I1hNmrmT A c ALL TRANSACTIONS DETAILS OK Y N UPDATE FS TOGGLE OPTS FS DELETE EID CODES ESC EXIT DESCRIPTION 30 characters Enter a description that will adequately describe the sequence you are defining HIERARCHY OF OPTIONS FOR ALTERNATE SEQUENCE PART 1 TO8 2 digits EXAMPLE These 8 fields constitute the possible components of the alternate key Enter the number associated with the component in each of the fields For example if an alternate key is to consist of the following 4 components Company Branch Customer and Product Code in Figure 4 8 the entries will be as follows Part 1 01 Part 2 02 Part 3 07 Part 4 21 Where Part 1 is the highest level
140. e added to the costs of the specific operation 9 4 digits This is a calculated field and is not available for entry The formula is set up time x rate run time x rate overhead cost JULY 2006 Job Costing User Guide TITAN 2000 SUGGESTED SALES 9 4 digits Enter the total value of the planned sales Press F3 to update the record The next screen will show the accumulated totals for all the operations relating to the current job After all details for all operations have been completed press F3 on the Level 3 screen and the Level 6 screen will be displayed JOB COSTING JOB TEMPLATE INPUT Tee OE AS CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN Pep ton 17 JOB IMP TEMPLATE FOR HOTEL FLOORS 1 4 0 00 OF ESTIMATE ACTUAL ESTIMATED COST ESTIMATE CUMULATIVE VARIANCE TO COMPLETE INVENTORY 0 0000 0000 0 0000 0 0000 LABOUR 0000 0000 0000 0000 CALCD OHD 0000 0000 0000 0000 OTHER 0000 0000 0000 0000 LAB NOT WP 0000 0000 0000 0000 NOT USED 0000 0000 0000 0000 NOT USED 0000 0000 0000 0000 NOT USED 0000 0000 0000 0000 NOT USED SO oC OC oe C TOTAL QUOTE EXPECTED PROFIT BILLED COST EXPECTED PROFIT 0 0000 BILLED SALES UPDATE P7 SID RID PREV SCREEN ESC EXIT Level 6 This screen displays the following information ESTIMATE 9 4 digits This represents the total cost estimate for all operations for a single job It is broken down in the 9 transac
141. e been run it will not be possible to re run this module without restoring from backup data The sequence of events that are to be followed in the period end module are detailed below Please adhere strictly to this sequence JC Set up and Run JULY 2006 2 25 TITAN 2000 2 4 THE PERIOD END MODULE MENU This module consists of programs which perform various month and year end functions The programs in this module are JC90 MONTH END CLEARDOWN JC91 SALES ORDER PROCESSING UPDATES TO JOB COSTING JC92 PURCHASE ORDERING UPDATES TO JOB COSTING JC93 YEAR END CLEARDOWN JC94 JOB DELETION JC95 SELECTIVE TRANSACTION DELETION JC96 OPERATIONS ACTIVATE JC97 JOB TO SP SUMMARY INVOICE CREATION JC98 SELECTIVE ARCHIVE DELETION JC99 UPDATE TEMPLATE SUPERSESSIONS Press JC9 to display the period end module menu 1 26 JULY 2006 Job Costing User Guide TITAN 2000 2 4 1 MONTH END SEQUENCE STEP PROGRAM FUNCTION 1 BACKUP Make a backup of all Job Costing files 2 JCOO Print the System Parameter file 3 Print the Job Costing audit trail Do NOT proceed before the reports produced above have been balanced to one another It may be advisable to perform these balancing routines on a weekly basis if there is a high volume of transactions JC91 Update the Job Costing files with Sales Order Processing information JC92 Update the Job Costing files with Purchase Ordering information Delete any jobs which have been compl
142. e dimensions of the form The system will ensure that details for the various sections do not fall outside the parameters defined here SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE SSS 070 GENERAL DATA JOB COSTING SOFT FORMS DESCRIPTION JOB CARD PRINT FORM LENGTH Lines FORM WIDTH Columns START OF BODYT END OF BODY SUMMARY HEADER Line 001 to 009 BODY Line 010 to 040 TRAILER Line 041 to 066 IS THE ABOVE INFORMATION CORRECT Y N LS EI NEXT FS ACCEPT FS DELETE FO PRINT FIO NEXT FORM ESC EXIT DESCRIPTION 20 characters Enter a form description to identify this document FORM LENGTH Lines i 3 digits Enter the total number of lines that can be printed on one page of your stationery For instance enter 66 if your form is 11 inches long and your printer is set to print 6 lines to the inch FORM WIDTH Columns 3 digits Enter the number of columns across your form For instance 120 columns for a 12 inch form printing 10 characters to the inch START OF BODY 3 digits Enter the starting line on which the body of the requisition form begins that is where transaction lines will start printing END OF BODY 3 digits Enter the last line on which transactions are to be printed before the printer has to skip to a new page or before trailer information will start printing Appendix 195 TITAN 2000 The following summary information is calculated by the system Ensure that it
143. ecified jobs and all their associated operations and transactions You may delete a single job or a range of jobs You may also specify a date range for the end dates of jobs Enter JC94 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING JOB DELETION JC94 11 001 01 TECHNOLOGIES INCORPORATED 01 CAPE TOWN PERIOD 6 PROJECT FROM FL1 FIRST FLOOR PRIVATE BATHROOMS 1 1 JOB SEQ END DATE FROM 09 231 WO DETAILS OK Y N Y iiL SONA Ira Je Wola 01100 COIR Iasi c jaye PROJECT FROM TO 4 characters The default is all projects or enter the start and ending range You may use the F1 key to scan or jobs on file If you use the F5 key you may toggle the scan between the job number and project number sequence PROJECT FROM TO END DATE FROM TO DD MM CCYY Enter the date range for which you want to delete jobs PROCEED WITH DELETION Y N Accept the details for the specified jobs to be deleted or press Esc to exit the program without any deletions taking place JC Set up and Run JULY 2006 2 35 TITAN 2000 2 10 SELECTIVE TRANSACTION DELETION JC95 The program deletes those transactions selected by the operator Enter JC95 to select the program The Report Destination Company Branch
144. entered Correct any errors using program SU31 Descriptions File Maintenance Use program SU51 Descriptions File Scan to scan the description file without printing a report SU38 The Password Maintenance program is used to set up and Mandatory maintain user names and access permission for all programs in the system Use the super user logon SYSADMIN to gain access to this program Protect all programs with passwords and ensure that the super is gi password protection JC32 Cost Category Maintenance Mandatory Use this program to enter cost categories and diversion codes These categories are used to analyse the job costs into user defined categories and may be linked to a General Ledger account code for interface to the general ledger system Diversion codes are those which may be used to accumulate costs not referring to specific jobs The system requires at least a code of 4 blanks which is the sundry cost category 9 JC33 Transaction Type Maintenance program Mandatory Up to nine user defined transaction types may be defined 10 JC35 The Work Centre Maintenance program maintains standard data per work centre JC30 or JC21 The Job Operation Maintenance or Job Maintenance Estimate Requirements Input programs maintain job headers and planned operations within those jobs As the system is a multi company and multi branch system this sequence of set up procedures needs to be repeated for each comp
145. er Delete or Amend and program SP67 Back Order Report both give a message when an item has been superseded Program SP69 Back Order Release ignores superseded items and does not transfer them to orders Program SP90 Update Orders with Supersessions may be used to update outstanding orders with supersessions INVENTORY CONTROL Program 00 System Record Maintenance must be set for the Automatic and Supervisor Password options as described Program IV34 Alternative Supersessions Maintenance allows you to maintain supersessions Please refer to the Maintenance section of the Inventory User Guide for more information Program IV10 Issues Receipts Adjustments Transfers will check the 1 00 System Record Maintenance parameters and will take suitable action or prompt for operator and or supervisor intervention Program IV21 Interface to Point of Sale and program IV40 Batch input into IV from flatfile take the action specified in program 00 System Record Maintenance If no automatic option has been specified the item will be ignored but a warning will be printed on the report PURCHASE ORDERING The following programs will check the options set in program 00 System Record Maintenance for Receipt parameters and will take suitable action or prompt for operator and or supervisor intervention PO10 ORDER INPUT PO16 PURCHASE ORDER ADJUSTMENTS PO11 ORDER AMENDMENT PO17 DIRECT RECEIPT OF GOODS Appendix
146. es This facility allows invoicing to proceed for a new period prior to the old one being closed off Stopped Accounts Depending on the option selected in 5 00 System Record Maintenance for stopped or deleted accounts the program may stop to warn you that an account has been stopped If you respond with a Y that invoice will be processed if N the invoice will not be processed However in both cases a warning will be printed on the audit trail FOR WAREHOUSES This prompt will only display if you selected the option on SP00 System Record Maintenance When entering warehouses use the following delimiters to denote AND to denote a RANGE to denote ALL For instance to select warehouses 01 03 10 to 15 and 20 you should enter 01 03 10 15 20 do not enter the quotations or any spaces The program prints an audit trail detailing action taken on all records read from the invoice file 1 30 JULY 2006 Job Costing User Guide TITAN 2000 2 7 PO UPDATES TO JOB COSTING JC92 This program is designed to update Job Costing values and transactions with Purchase ordering information Program JC17 Contract Input Purchase Order or program JC18 Contract Input Demand Purchase Order may be used to enter purchase orders relating to specific jobs Please refer to the INPUT section of this User Guide for further information When running program JC92 PO Updates to Job any recei
147. es and on hand file with quantities 1 digit Select whether you wish to use Issues Receipts or Invoices Credit notes for materials issue type transactions 1 Issues Receipts 2 Invoices Credit Notes If option 1 is selected then programs JC10 Job Cost Input and JC22 Job Cost Input Fast Materials Input will update the average cost as per 1 00 System Record Maintenance specifications JOB COSTING TRANSACTION TYPE MAINTENANCE JC33 11 004 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN TRANSACTION TYPE LONG TERMINOLOGY SHORT TERMINOLOGY CLASS INTERFACE WITH WP DEFAULT COST CATEGORY WP CO WP BR DEFAULT WP33 CODE CODE DESCRIPTION BASI lt gt BASIC PAY BON BONUS GRSS GROSS EARNINGS HOLB HOLIDAY BONUS HOLP HOLIDAY PAY PERIOD 10 LABOUR LAB 1 MATERIAL USAGE 2 LABOUR 3 COMPUTED OVERHEADS 4 OTHER SUNDRY JOB COST CATEGORY PI SCAN FORWARDS 52 UPDATE FIO TYPE EXIT DEFAULT COST CATEGORY WP CO WP BR 3 132 4 characters Enter the default cost category for this transaction type These categories are set up in program JC32 Cost Category Maintenance 2 digits 2 digits JULY 2006 Job Costing User Guide DEFAULT WP33 CODE JC Maintenance TITAN 2000 4 characters This refers to the default earnings or deduction code to which a specific transaction type refers and will be used at interface stage JULY 20
148. escription associated with the code above Up to 15 characters This depends on whether the transaction is a labour or a material type 30 characters The description associated with the code above TITAN 2000 BODY 2 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE BODY 2 JOR COSTING SOFT FORMS OPERATION DETAILS PLANNED AMOUNTS QUANTITY UNIT OF MEASURE SET UP TIME RUN TIME UNIT COST SET UP RATE RUN RATE OVERHEAD COST TOTAL COST COST TO COMPLETE ESTIMATED SALES SQ METER USAGE UNIT QTY UNIT LENGTH UNIT WIDTH IS THE ABOVE INFORMATION CORRECT Y N 11 001 FONT COLMN DGT DEC 029 2 1 F2 PREVIOUS F3 SAVE F8 DELETE F9 PRINT 10 FORM ESC EXIT OPERATION DETAILS PLANNED AMOUNTS The following are all planned amounts QUANTITY UNIT OF MEASURE SET UP TIME RUN TIME UNIT COST SET UP RATE RUN RATE 7 2 digits This is the quantity required 4 characters The unit of measure of the product 7 2 digits The time it takes to set up the operation 7 2 digits The run time of the operation 7 4 digits The unit cost of the operation 7 4 digits The rate used to calculate the cost of the setup time 7 4 digits The rate used to calculate the cost of the run time Appendix 203 TITAN 2000 OVERHEAD COST 7 4 digits The overhead costs of the operation TOTAL COST 7 4 dig
149. et to CREATE OPS WHEN POSTING A scan will only display those categories linked to this particular combination 15 characters Enter a valid product code to which the transaction relates This entry will only be available if the transaction type is Inventory Materials If this item has been superseded and it is a date type supersession and that date has been reached and you have not specified an automatic action to be taken in program 00 System Record Maintenance will now have to select the appropriate option Depending on the IVOO option a supervisor password may be required If the supersession is a zero quantity type action will only be taken after you have entered the quantity Please refer to Appendix A3 for more information Where appropriate serial number entry will be required JULY 2006 3 47 JOB COSTING JOB COST INPUT 01 TECHNOLOGIES INCORPORATED BR Dl CAPE TOWN LINE 1 SESS INST 2 BATCH 6 JOB OPERATION TRANSACTION TYPE CATEGORY EMPLOYEE WP CODE WORK CENTRE PERIOD DOC DATE REFERENCE DIVERSION HOURS BOOKED RATE TOTAL COST NARRATIVE DETAILS OK iL TE aca EMPLOYEE WP CODE JOB COSTING JOB COST INPUT TITAN 2000 JC10 11 008 PERIOB 12 NOT ON FILE FIRST FLOOR PRIVATE BATHROOMS INSTALLATION LABOUR CLASS LABOUR COSTS SCOTT BASIC PAY LABOUR 1000 00007 01 1 1 dE 92 03 24 6 0 0000 12 0
150. eted All associated Operations will also be deleted Activate Operations if required JC97 1 015 5 Invoice Creation 002 468 7 Deletearchivedrecordsifrequred 00 12 JC99 Update Template Supersession Optional 2 4 2 YEAR END SEQUENCE STEP PROGRAM FUNCTION 1 Perform a backup of all Job Costing files 2 MONTH END Perform all the month end functions as described in section 2 4 1 3 JC93 Job Costing Year End Cleardown JC Set up and Run JULY 2006 2 27 TITAN 2000 2 5 MONTH END CLEARDOWN JC90 The program sets to zero all month to date figures on the cost category file and job file It deletes job transactions according to the parameters set in program System Record Maintenance and increments the period number on that file If the parameter is set in JCOO System record Maintenance the deleted transactions will be written to an archive file Enter JC90 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 PERIOD The current period is displayed and may not be altered PROCEED WITH CLEARDOWN Y N Enter Y to proceed The status line displays the other options JOB COSTING MONTH END CLEARDOWN JC90 11 001 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 11 PERIOD PROCEED WIT
151. f this option is set to Y Y N Y Will update estimates usually updated via program JC30 Job Operation Maintenance while capturing details in program JC19 Contract Input Y N When actual costs are being captured the committed cost values will be decreased by these values if this option is set to Y Y N If you enter Y program JC92 PO Updates to Job will automatically generate an issue from stock to the job according to the quantities received in the Purchase Ordering system This entry is similar to that entered in JC10 Job Cost Input JULY 2006 TITAN 2000 POST AP VIA JC92 Y N If N you will have to update the Accounts Payable system using PO92 Interface to Accounts Payable USE JC10 TO ISSUE JC13 TO INVOICE Y N If you enter Y you will be able to use program JC10 to issue items to jobs and JC13 to create an invoice semi automatically in the Sales Order Processing system The following prompts all determine whether the specified field is mandatory in JC13 Create Invoice In SP or whether it may be left blank ALLOW BLANK CUSTOMER ORDER IN JC13 Y N ALLOW BLANK SALESMAN IN JC13 Y N If yes you will not be forced to enter a Representative code ALLOW BLANK PRODUCT GROUP IN JC13 Y N If yes you will not be forced to enter a Product Group DEFAULT FROM IV Y N You may specify that the Product Group PG may be obtained from the Stock Master You will however be able to
152. ge the display from the default cost standard to the alternate cost actual F10 to enter or scan another job number Esc to end the program 5 142 JULY 2006 Job Costing User Guide Level 2 JOB COSTING JOB OPERATION ENQUIRY CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN JOB FL1 FIRST FLOOR PRIVATE BATHROOMS JOB ACTUAL CUMULATIVE 560 0000 0000 8000 0 0000 0000 0000 0000 0000 ESTIMATED 11 7735296 1579 0000 0000 0 0000 0000 0000 0000 0000 INVENTORY LABOUR CALCD OTHER LAB NOT WP NOT USED NOT USED NOT USED NOT USED OHD TOTAL QUOTE EXP PROFIT EXP PROFIT BILLED COST BILLED SALES EI SCAN FILE FS TOGGLE FID JOB ESC EXIT VARIANCE 1459 8000 0 0000 0000 0000 0000 0000 5296 0000 TITAN 2000 JC50 11 001 PERIOD 10 LEVEL EST ACT COMPLETE DETAILS ESTIMATED COST TO COMPLETE 121325299 1459 0000 0000 0 0000 0000 0000 0000 0000 To view the comparative actual and estimated costs press F1 to display the next level of enquiry This enquiry also displays the variances between the estimated and actual costs with a cost to complete calculation A toggle will allow the details displayed in each of the four headings to be viewed in different sequences Billed costs and sales are also displayed FUNCTION KEY FACILITIES F1 F WD to select individual operations and their associated transacti
153. he Estimating screen in JC30 Job Operation Maintenance has been designed to assist you with your estimations The top of the screen displays details of the job and operation transaction and the item depending on the level selected for which you require estimation The lower left hand side of the screen displays a worksheet where estimates are captured The lower right hand screen serves as an enquiry window allowing you to use the F5 toggle key to view estimated committed and actual costs at Job Transaction and Operation levels NOTE These costs may also be categorised into the various classes and transaction types 2 POSTING PHASE During this phase costs are posted to the various jobs from within the JC module or from linked modules such as Purchase Ordering or Sales Order Processing These posted costs may be broken down into three main categories Committed costs e Actual costs e Billed costs Committed costs These reflect order amounts and are posted to the specific job when a an order is created in the PO module b an order is created in the SP module c an order posting is done in program JC10 Job Cost Input Appendix 185 TITAN 2000 Actual Costs These reflect actual expenditure posted to the specific job via JC92 Updates to Job calls PO92 Batch Posting to Accounts Payable picks up all received orders from PO module b 91 SP Updates to Job
154. he cost category or WP code specified previously OVERHEAD 9 4 digits This represents a contingency overhead to be added to the costs of the specific operation TOTAL 9 4 digits This is a calculated field and is not available for entry The formula is setup time x rate run time x rate overhead cost SUGGESTED SALES 9 4 digits Enter the total value of the planned sales Press F3 to update the record The next screen will show the accumulated totals for all the operations relating to the current job After all details for all operations have been completed press F3 on the Level 3 screen and the Level 6 screen will be displayed JC Input JULY 2006 3 91 TITAN 2000 Level 6 JOB COSTING JOB MAINTENANCE FAST MATERIALS INPUT Soo 11 003 CO DI TECHNOLOGIES INCORPORATED BR 1 CAPE TOWN PERIOD 10 JOB FLS TEMPLATE FOR HOTEL FLOORS 1 4 0 00 OF ESTIMATE ACTUAL ESTIMATED COST ESTIMATE CUMULATIVE VARIANCE TO COMPLETE INVENTORY 0000 0000 0000 0000 LABOUR 0000 0000 0000 0000 CALCD OHD 0000 0000 0000 0000 OTHER 0 0000 0000 0 0000 0 0000 LAB NOT WP 0000 0000 0000 0000 NOT USED 0000 0000 0000 0000 NOT USED 0000 0000 0000 0000 NOT USED 0000 0000 0000 0000 NOT USED Se SOOO oe C TOTAL QUOTE EXPECTED PROFIT EXPECTED PROFIT BILLED COST BILLED SALES ES UPDATE P7 RFID PREV SCREEN ESC EXIT This screen displays the following information ES
155. ice 2 Credit Note 3 56 JULY 2006 Job Costing User Guide DEBTORS AGE PERIOD Press F3 to continue Level 2 TITAN 2000 2 digits If you are entering a credit note you may age it to the required debtors ageing period Enter or change details as shown below COSTING CREATE INVOICE IN SP 01 TECHNOLOGIES INCORPORATED BR CAPE TOWN Jers 11 006 INVOICE PERIOD 3 PROJ DP3 TEMPLATE FOR HOTEL FLOORS 1 4 CUST 01 01 1010 JONES GENERAL CONTRA JOB HOT1 RAILWAY HOTEL PRIVATE BATHS DATE 10 07 2000 REFERENCE STATUS 6 IN PRODUCTION OPRN T ITEM INST 1 001 1WB WIT 46 WHITE CASCADE HANDSHOWER SPIRA INST 1 012 WIT 46 WHITE CASCADE ADJ HANDSHOWER INST 1 433AQ SHOWER CUBICLE SET NO186AQUILA INST 2 00007 01 SET LABOUR COSTS INST 2 00007 01 RUN LABOUR COSTS 1 DEL ADDR 0001 REF QTY 0 00 SALESMAN CONR CUST ORD USAGE QUANTITY UNIT COST SELL PRICE 12 5085 REP GRP 42 2848 REP GREE 53 0610 GRP 12 0000 120000 GRP HS POSTARE COMMENTS EL PREV ESC EXIT HEADER DETAILS DATE REFERENCE DEL ADDR REF QTY SALESMAN JC Input DD MM YYYY Accept or change the invoice date 8 characters Enter a reference to be printed on the invoice if required 4 digits Scan for or enter a delivery address if required Display only This is the number of finished items created by the Job and will be used to calculate default
156. ities used may be captured on program JC22 This input program is faster for materials than program JC10 as it requires less input but the same for labour At the Job Costing System Menu enter JC1 to display the Input Module or JC2 to display the Template and Fast Input Module Enter JC to return to the Job Costing menu or M to return to the main menu JC Input JULY 2006 3 43 TITAN 2000 3 2 JOB COST INPUT JC10 The program caters for the input of costs to any job operation according to the transaction types and cost categories as set up in program JC30 Job Operation Maintenance program If the option CREATE OPS WHEN POSTING is chosen in program JCO0 System Record Maintenance then operations may be created here which have not been set up in program JC30 Job Operation Maintenance The Job number is written to SA1 and the project to SA2 for use on sales analysis The following pages will describe in detail what is required at each level of entry for the different transaction types Enter JC10 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING JOB COST INPUT JC10 11 008 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 POSTING MODE BATCH INPUT TRANSACTION CAPTURE TRANSACTION TYPE POST COMMITTED COSTS POST ACTUAL COSTS POST BILLED
157. its The total cost of the operation COST TO COMPLETE 7 4 digits The cost to complete the operation ESTIMATED SALES 9 2 digits The value of the estimated sales SQ METER USAGE If you wish to print the square meter dimensions enter details for the fields below UNIT QTY 7 2 digits UNIT LENGTH 4 3 digits UNIT WIDTH 4 3 digits Appendix 204 TITAN 2000 BODY 3 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE Suss L D BODY 3 JOB COSTING SOFT FORMS FONT COLMN DGT DEC OPERATION DETAILS AMOUNTS SCRAP QUANTITY SCRAP COST BILLED COSTS BILLED SALES ACTUAL SALES COMMITTED COST CALCULATED OVERHEAD EXPECTED PROFIT EXPECTED PROFIT PERCENTAGE PRO RATA PERCENTAGE IS THE ABOVE INFORMATION CORRECT Y N Y 1 F2 PREVIOUS F3 SAVE F8 DELETE F9 PRINT 10 FORM ESC EXIT OPERATION DETAILS AMOUNTS SCRAP QUANTITY 7 2 digits The scrap quantity accumulated for the operation SCRAP COST 7 4 digits The total cost of the accumulated scrap BILLED COST 7 2 digits The total cost of the amount that has been billed to the customer for the operation BILLED SALES 9 2 digits The total amount that has been billed to the customer for the operation ACTUAL SALES 9 2 digits The total actual sales for the operation COMMITTED COST 9 2 digits The total committed cost CALCULATED OVERHEAD 9 2 digits Total calcul
158. job and project sequence PRINT TRANSACTIONS f Y N Y will print details of all transaction whereas N will print summarised totals This entry will only be required if the option 2 has been selected PROCEED WITH PRINT Y N Accept the information or alter any incorrect entries Press F10 to return to the company branch selection screen The Esc key will end the program 6 164 JULY 2006 Job Costing User Guide COMPANY 01 TECHNOLOGIES INCORPORATED JOB COSTING SCRAP ANALYSIS DATE 18 06 98 8 12 06 PAGE BRANCH 01 CAPE TOWN JC75 11 014 PERIOD OPTIONS ANALYSIS BY TRANSACTIONS DATES FROM 01 01 87 TO 31 12 88 01 06 88 LABOUR LABOUR COSTS ON CLASSIC 01 06 88 LABOUR LABOUR COSTS ON CLASSIC 01 06 88 STOCK MATERIAL COSTS ON CLASSIC 01 06 88 STOCK DIVERTED O HEADS CLASSIC 01 06 88 OTHER OVERHEADS ON CLASSIC 01 06 88 OTHER OVERHEADS ON CLASSIC JC75 Scrap Analysis JC Print JULY 2006 6 165 TITAN 2000 6 8 WORK CENTRE ANALYSIS JC76 The program prints an analysis of selected transactions per work centre Enter JC76 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING WORK CENTRE ANALYSIS JC76 11 001 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 FROM WORK CENTRE MANUF TO WORK CENTRE SITE1 TRAN
159. l code sequence and existing operation sequence Lines may be added or deleted as required If this item has been superseded and it is a date type supersession and that date has been reached and you have not specified an automatic action to be taken in program IV0O System Record Maintenance you will now have to select the appropriate option Depending on the IVOO option a supervisor password may be required If the supersession is a zero quantity type action will only be taken after you have entered the quantity Please refer to Appendix A3 for more information 7 2 digits Enter the quantity required for this item 7 4 digits This value is read from the Inventory File according to the default unit of cost as specified in program JC33 Transaction Type Maintenance for Inventory Type transactions It may be altered 9 4 digits This field is calculated and is not available for entry The calculation is Quantity required Unit price When all material requirements have been captured use the up arrow to enter another category or transaction type or press F3 to proceed to the next level JC Input JULY 2006 3 89 TITAN 2000 Level 5 for transaction type LABOUR JOB COSTING JOB MAINTENANCE FAST MATERIALS INPUT JC21 11 003 01 TECHNOLOGIES INCORPORATED BR Dl CAPE PERIOD 10 JOB FL5 INST TEMPLATE FOR HOTEL FLOORS 1 INSTALLATION TRANS 1 INVENTORY CLASS SET CLASS JC33 CATG
160. lly according to the parameters set up in program SU35 Customised Form Maintenance The contract order created may be released to invoicing in the normal way using programs SP14 Order Release or SP78 Order Release and Print These invoices are not posted to the Accounts Receivable or Sales Analysis systems They merely update the actual cost and sales values on the job record in the Job Costing system JC Input JULY 2006 3 67 TITAN 2000 3 7 2 INVOICE ENTRY This option simulates either program SP15 Batch Invoice Entry or program SP16 Demand Invoice Entry in the Sales Order Processing modules It allows the capture of invoices relating to specific jobs on the Job Costing system It optionally produces a user defined invoice This program will update the job record on the Job Costing system but will have no effect on the customers record at all JOB COSTING CONTRACT INPUT 02 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN INVOICE FORM TYPE DUPLICATE REQUIRED PRINT TEST REQUIRED DETAILS OK Y N IHL USTED Level 2 The entries for this level will only be required if the option to immediately produce forms has been selected INVOICE FORM TYPE IVxx This represents the user defined form set up program SU35 Customised Form Maintenance DUPLICATE REQUIRED If Y is entered the program will print
161. may be deleted and new item lines may be added Level 1 JOB 4 characters digits depending on the definition in program JC00 System Record Maintenance Enter a new or existing job number If the job number is new and you wish to copy details from a template press F4 on the level 2 screen COPY CO BR JOB 6 digits characters Enter the company branch and job number which is to be used as a template for the new job being created Level 2 DESCRIPTION 30 characters Accept the default or enter a description for this job PROJECT 4 characters digits depending on the definition in program JCOO System Record Maintenance scan of project codes is available as an aid If a code is entered which has not been created using program 6031 Descriptions File Maintenance type JP then this code will be rejected for entry Accept the default or enter a new project code CUSTOMERS CO BR 2 digits 2 digits Accept the default or enter the specific company and branch against which customer numbers are to be validated JC Input JULY 2006 3 85 JOB COSTING JOB MAINTENANCE FAST MATERIALS INPUT TITAN 2000 ICZ M00 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN JOB HEADER DETAILS JOB DESCRIPTION PROJECT CUSTOMERS CO BR CUSTOMER STATUS START DATE END DATE CATG ANALYSIS LEVEL SPECIFY OPERATIONS ESTIMATING LEVEL EXP PROFIT LEVEL REFERENCE REFERENCE QTY DETAILS OK Y N COPY CO BR JOB
162. modules It is a multi purpose program with the options shown below Enter JC19 to select the program Level 1 JOB COSTING CONTRACT INPUT OPTION DIRECT PRINTING Y N DETAILS OK Y N ESC ICL OPTION Feie 11 001 ORDER ENTRY INVOICE ENTRY CREDIT NOTE ENTRY CUSTOMER INVOICE ENTRY CUSTOMER CREDIT NOTE ENTRY BRANCH ORDER ENTRY CUSTOMER ORDER ENTRY 1 Order entry 2 Invoice entry 3 Credit note entry 4 Customer invoice entry 5 Customer credit note entry 6 Branch order entry 7 Customer order entry The program defaults to the first option Accept it by pressing Enter or select another DIRECT PRINTING Y N DETAILS OK Y N Y will cause the form printing program to be called and a form will be produced on completion of the input N will cause the relevant files to be updated from which the associated forms may be printed at a later stage Accept the details or correct them JULY 2006 Job Costing User Guide TITAN 2000 3 7 1 ORDER ENTRY This option simulates either program SP10 Order Entry or program SP19 Demand Order Entry in the Sales Order Processing modules It updates the Order and Inventory files It allows the capture of contract orders and the picking of items for those orders It optionally produces a user defined form which may be used as a picking list an order confirmation or a delivery note This program will update the committed costs on the
163. nance program Enter JC3 to display the Maintenance Module JC Maintenance JULY 2006 4 101 TITAN 2000 4 2 JOB OPERATION MAINTENANCE JC30 The Job Operation Maintenance program is a multi purpose program which is used for adding and amending jobs and their associated operations Enter JC30 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 ALTERNATE SEQUENCE CODE 4 characters Scan for or enter the required alternate sequence These sequences are entered in program JC31 Alternate File Maintenance If no alternate sequence codes have been set up records will be displayed in the default sequence which is Company Branch and Job number Even if you have set up alternate sequences you may still select the default sequence by entering a blank code Level 2 JOB 4 Characters There are two options available at this point e enter new jobs update existing job details If amending an existing job a scan is available The F5 key will toggle the scan between a job or project sequence The F1 key will scan the file in whatever sequence is in operation due to the toggle The options will be described in further detail in the next sections The status line shows the scanning options available 3 102 JULY 2006 Job Costing User Guide TITAN 2000 4 2 1 ADDING NEW
164. nance may be entered JULY 2006 Job Costing User Guide CATEGORY TITAN 2000 4 characters Only categories associated with the specific job operation transaction type combination as set up in program JC30 Job Operation Maintenance may be entered A scan will only display those categories linked to this particular combination Level 5 for transaction types MATERIAL USAGE and OTHER PRODUCT QTY ISS UNIT PRICE TOTAL UNIT PRICE JC Input If the transaction type entered was material usage the inventory items as entered on the template in program JC20 Job Template Input will be displayed The F5 key may be used to toggle in the following sequences branch stock number sequence internal code sequence and existing operation sequence Lines may be added or deleted as required If this item has been superseded and it is a date type supersession and that date has been reached and you have not specified an automatic action to be taken in program 1 00 System Record Maintenance you will now have to select the appropriate option Depending on the IVOO option a supervisor password may be required If the supersession is a zero quantity type action will only be taken after you have entered the quantity Please refer to Appendix A3 for more information Where appropriate serial number entry will be required 7 2 digits Enter the quantity of this item issued to this job operation 7 4 digits This val
165. nce Y N If you enter N the Product group will be mandatory in JC30 Job Operation Maintenance Y N If you enter N the Sales Category will be mandatory in JC30 Job Operation Maintenance Now press F1 to proceed to the POSTING DETAILS SCREEN or press F3 to update the record 1 20 JULY 2006 Job Costing User Guide Level 5 POSTING DETAILS JOB COSTING SYSTEM RECORD MAINTENANCE 01 SEAGULL SOFTWARE CC BR 01 MAIN BRANCH POSTING DETAILS CREATE OPERATIONS WHEN POSTING UPDATE ESTIMATED FIGURES JC19 4 5 7 REDUCE COMMITTED COSTS WHEN POSTING ISSUE PRODUCTS TO JOB VIA JC92 POST TO AP VIA JC92 USE JC10 TO ISSUE ALLOW BLANK CUSTOMER ORDER IN JC13 ALLOW BLANK SALESMAN ALLOW BLANK PRODUCT GROUP IN JC13 ALLOW BLANK CATEGORY IN JC13 JC13 USE ESTIMATES ACTUALS E A FORMULA DETAILS USE INTERIM BILLING AUTO ALLOCATION WC PRO RATA FORMULA Joc TOM NVORSE TITAN 2000 Jcoo 11 004 PERIOD OL 2 2 2 DEFAULT FROM IV JC00 H COSTS E2 OPS ES UPDATE HA CORY ES DELEIE BO BRENT CREATE OPERATIONS WHEN POSTING UPDATE ESTIMATED FIGURES JC19 4 5 7 REDUCE COMMITTED COSTS WHEN POSTING ISSUE PRODUCTS TO JOB VIA JC92 JC Set up and Run Y N If Jobs are created without associated operations it will still be possible to allocate individual transactions to operations at capture stage i
166. ncy or F1 to scan and select If another currency is selected the document values will be printed in the foreign currency using the rate held on file 2 digits This question will only be asked if the system parameter file for the stock system indicates that warehousing is an option JULY 2006 Job Costing User Guide Level 5 NUMBERING M A S TITAN 2000 A for automatic numbering of invoices This increments invoice numbers by one M For manual numbering of invoices This allows the operator to enter invoice numbers S for semi automatic numbering This allows the operator to enter the first invoice number and the system will increment this by one each time a new invoice is entered An alteration to this may require a supervisor password to be entered Level 5 COSTING CONTRACT INPUT SPIS CO 01 TECHNOLOGIES INCORPORATED BR 0l WH 01 CENTRAL JOB Fhi JOB JOB DESCRIPTION ELI FIRST FLOOR PRIVATE BATHROOMS FL2 FLOOR 2 PRIVATE BATHROOMS FL3 FLOOR 3 PRIVATE BATHROOMS FLA STAFF BATHROOMS TOILETS GAO1 GAME PARK Al GA02 STAFF QUARTERS PRIVATE GA03 VIP GUEST SUITE ovs INTO ICTS Ps Fl SCAN FILE FS TOGGLE EID PREVIOUS 11 029 JOB JC Input 4 characters Enter the required job number to which this order refers JULY 2006 3 65 TITAN 2000 Level 6 The order header program is exactly as described for program SP10 Order Entry or
167. nformation is accepted and another screen appears this will be shown in the manual as Level 1 Level 2 and so on When multiple choices appear and these have to be described individually the first level will be the major input screen TITAN 2000 1 2 THE TITAN SYSTEM PROFILE Please refer to the Systems Utilities Manual for a profile of the TITAN system which consists of the following modules Application Builder Accounts Receivable Bill of Materials Chart Writer Fixed Assets Instalment Sales Job Costing Purchase Ordering Report Writer Sales Order Processing Weekly Payroll Accounts Payable Bank Link Cashbook Electronic Data Interchange General Ledger Inventory Control Monthly Payroll Point of Sale Sales Analysis Systems Utilities JULY 2006 Job Costing User Guide TITAN 2000 1 3 JOB COSTING SYSTEM Job Costing provides management with up to the minute status and control over ongoing projects or contracts Projects may be monitored and future commitments accurately predicted Cash flow is controlled and adequate inventory holdings can be maintained The system is modular and can be used either as a stand alone system or combined within a fully integrated accounting environment Using Job Costing in conjunction with the Estimating system actual costs incurred may be compared with those estimated at the time contract being awarded Advantages of the system are e Managers have immediate control
168. nine eed 112 INVENTORY TRANSACTIONS 59 trt terrace etr edere npe te Pe iva rt eges 132 agde 68 INVOICE FORM TYPE iere PEE MEUM UM 68 72 ISSUE PRODUCTS TO JOB VIA JG927 n ttr t rr irpo da dei edie E EE 21 ISSUE TO ction 98 zT 127 l izizu 185 J LA 11 dej 44 de p tines 55 dei ke 56 JC13 USE ESTIMATES AGTUALS 2 rtr rere cen eerte eeu eere n 22 59 je 61 ju H 62 deu 76 85 dc 94 decp E 102 deu
169. nsaction type entered was labour and if it was indicated in program JC33 Transaction Type Maintenance that an interface to the Wages module is required the operator will have to enter a valid employee number in this position Press F3 to accept the entry and display the next screen Level 5 for transaction types MATERIAL USAGE and OTHER PRODUCT UNIT PRICE JC Input If the transaction type entered was material usage and if it was indicated in program JC33 Transaction Type Maintenance that an interface to the Inventory Module is required the operator will have to enter a valid product in this position The F5 key may be used to toggle in the following sequences branch stock number sequence internal code sequence and existing operation sequence If this item has been superseded and it is a date type supersession and that date has been reached and you have not specified an automatic action to be taken in program IV0O System Record Maintenance you will now have to select the appropriate option Depending on the IVOO option a supervisor password may be required If the supersession is a zero quantity type action will only be taken after you have entered the quantity Please refer to Appendix A3 for more information 7 4 digits This value is read from the Inventory File according to the default unit of cost as specified in program JC33 Transaction Type Maintenance for Inventory Type Transactions It m
170. nt JULY 2006 6 183 TITAN 2000 APPENDIX A A 1 JOB COSTING RECORD STRUCTURE The method of operation can be split into two main phases Planning Estimating stage e Posting phase The costs reflected by the JC system can therefore be categorised into these two phases as e Estimated costs e Posted costs 1 PLANNING ESTIMATING PHASE e Planning You may optionally bypass this phase only using the Job Costing system to open a job and record actual expenses against this job In this case please note that estimated costs and all associated calculated costs such as Suggested Sales and Expected Profits will be zero e Estimating If this option is selected you may chose for each specific job the level at which estimation is to be done RECORD STRUCTURE PROJECT JOB JOB OPERATION OPERATION TRANSACTION TRANSACTION TRANSACTION OTHER MATERIAL LABOUR STOCK ITEM EMPLOYEE COST EARNING CODE CATEGORY Appendix 184 TITAN 2000 JOB LEVEL Total estimates are captured for up to nine transaction types at the job level TRANSACTION LEVEL Estimates are captured for each transaction type within an operation which forms a SUBSET of a job ITEM LEVEL Estimates are captured at the highest level for each specific POSTED COST item NOTE You may also specify whether operations are to be used for each job If operations are not specified then estimating can obviously only be done up to job level 1 FEATURES T
171. ntenance Y N If you enter N the Product group will be mandatory in JC30 Job Operation Maintenance JULY 2006 2 17 DEFAULT FORM FOR JC30 DEFAULT FORM FOR JC10 TITAN 2000 JCxx If you enter a suffix to the form type JC program JC30 Job Operation Maintenance will allow you to print a job card by pressing the F9 key If you leave this blank you will only be able to print job cards using program JC73 Requisition Notes Forms are set up in program SU35 Customised Form Maintenance under type JC JCxx If you enter a suffix to the form type JC program JC10 Job Cost Input will allow you to print a stock issue voucher SIV If you leave this blank you will only be able to print stock issue vouchers using program JC73 Requisition Notes Forms are set up in program SU35 Customised Form Maintenance under type SIV numbers are set up 6031 Descriptions File Maintenance type WH per warehouse Press F1 to proceed to the Operation Detail level or Posting Details if operations are not to be used The status line displays the other options 1 18 JULY 2006 Job Costing User Guide Level 4 OPERATION DETAILS TITAN 2000 This screen will only be presented if Y was entered on the previous screen indicating that operations are to be used You may select your own terminology for job job group and operation A long description and a short description is available in each case JOB
172. o update estimates 3 7 5 CUSTOMER CREDIT NOTE ENTRY This option simulates either program SP17 Credit Note Entry or program SP18 Demand Credit Note Entry in the Sales Order Processing modules It allows the capture of credit notes relating to specific jobs on the Job Costing system It optionally produces a user defined credit notes This option differs from option 3 section 3 6 in that it does update the customers and sales analysis records as well as the billed amount on the associated job record You may also select to update estimates 3 7 6 BRANCH ORDER ENTRY This program simulates Program SP20 Branch Order Entry in the Sales Order Processing modules It allows the capture of branch warehouse transfers with a reference to a specific job However there is no option for direct printing Provided the option is set in program JC00 System Record Maintenance estimates which are normally captured via program JC30 Job Operation Maintenance will be updated when capturing details here 3 7 7 CUSTOMER ORDER ENTRY This option is exactly the same as Option 1 Order Entry with one exception Once orders have been entered via this option and have been released to invoicing the invoice will be used in program JC91 SP Updates to Job to update the actual and committed costs on the Job Costing files where applicable It will also update the customer details in the Accounts Receivable system You may also select to
173. of sequencing and Part 4 the lowest level or least important sequence If required all or none of the components may be user defined The maximum length of the alternate key is 34 characters JC Maintenance JULY 2006 4 119 If F8 is pressed here all transactions allocated to this code as well as the code set up will be deleted ALL TRANSACTIONS f Y N Y If alternate sequence applies to all transactions for example all Company Branch Accept the entries to proceed to the next level 3 120 JULY 2006 Job Costing User Guide TITAN 2000 Level 3 This level defines the start positions and lengths of the components of the alternate key as defined at Level 1 Each of these components may be optionally validated against a pre defined description type set up in the Description File ALTERNATE KEY SET UP JOB COSTING ALTERNATE FILE MAINTENANCE JESL 1 10 01 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN JOB COSTING MASTERFILE ALTERNATE SEQUENCE ALT1 ALTERNATE SEQUENCE BY CUST ACC ALTERNATE KEY SET UP START POSITION LENGTH DESCRIPTION TYPE ALPHA NUM COMPANY BRANCH CUSTOMER ACCOUNT JOB UPDATE FIO OPTIONS ESC EXIT START POSITION 2 digits Mandatory for as many components as defined at the previous level Indicates the start position of each of the components of the code LENGTH 2 digits Mandatory if a start position has been entered Indicates the length of the com
174. ogram at this point After deletion the program returns to the work centre input field JC Maintenance JULY 2006 4 139 TITAN 2000 5 ENQUIRY MODULE 5 1 THE ENQUIRY MODULE MENU This module uses a single multi purpose program for job costing enquiries JC50 JOB OPERATION ENQUIRY JC51 JOB OPERATION HEADER ENQUIRY These enquiries may be made for both jobs and operations The program handles the following enquiry types e Job detail enquiry Operation details e Operation transactions e Transaction details Enter JC5 to display the Enquiry Module menu 5 140 JULY 2006 Job Costing User Guide TITAN 2000 5 2 JOB OPERATION ENQUIRY JC50 The program provides an enquiry facility into the job file at both a job and project level In addition the transactions may be viewed against each job or operation item Enter JC50 to select the program JOB COSTING JOB OPERATION ENQUIRY veS L D 01 TECHNOLOGIES INCORPORATED BR Dl CAPE TOW PERIODO 10 JOB COSTING SEQUENCE ALT1 ALTERNATE SEQUENCE BY CUST ACC ALT KEY SCAN ALTERNATE SEQUENCE 1 019001 GA01 GAO1 CO BR JOB ALTERNATE CODE DESCRIPTION 01 01 GA01 lt gt 01019001 01 GAME PARK 1 01 01 GA02 01019001 02 STAFF QUARTERS PRIVATE 01 01 GA03 01019001 03 VIP GUEST SUITE 01 01 FL1 01019004 FL1 FIRST FLOOR PRIVATE BATHR 01 01 FL2 01019004 FL2 FLOOR 2 PRIVATE BATHROOMS 01 01 FL3 01019004 FL3 FLOOR 3 PRIVATE BATHROOMS 01 01 FL4 01019004
175. ograms may be used ona daily and weekly basis As the system is an on line real time system data is updated immediately upon entry Enquiries and reports will show the latest data as at the last entry before enquiry or printing Control of data entered into the system and the taking of backups are essential to the successful running of a system Appropriate controls and methods need to be implemented to ensure that these two areas are covered adequately DATA ENTRY AND CONTROL Data is normally entered in groups or batches and thus a record of batches received and entered must be made After each batch is entered into the system the batch should be stamped as POSTED DD MM CCY Y A check should also be made to see that document and batch numbering is sequential and that all batches have been entered All prime input programs provide audit trails These audit trails should be attached to the original batches of input documents and filed daily in a computer file Any discrepancies in batch totals should be investigated and corrected immediately BACKUP Backup is mandatory and must be performed strictly in accordance with the procedures laid down in the System Utilities User Guide PERIOD END CYCLES It is essential that all programs in the period end module are protected by passwords and that backup is performed prior to using this module Ensure that all transactions have been entered into the system Once the period end programs hav
176. on types F2 B WD to return to the previous screen F7 ALT to view the alternate cost for example if standard if the default is actual F10 to enter or scan another job number Esc to end the program JC Enquiry JULY 2006 5 143 TITAN 2000 JOB COSTING JOB OPERATION ENQUIRY Beso 01 TECHNOLOGIES INCORPORATED BR CAPE TOWN PERLOR 10 JOB FL1 FIRST FLOOR PRIVATE BATHROOMS START DATE 92 02 27 OPERATION INST INSTALLATION END DATE 92105922 TRANS TYPE 1 INVENTORY CLASS MATERIAL USAGE SCHEDULED Y PRODUCT 001 1WB WIT 46 WHITE CASCADE HANDSHOWER SPIRA ACTIVE aM STATUS 6 COST CATG 7000 MATERIAL COSTS INSTALLATIONS WORKCENTRE ESTIMATED ACTUAL QUANTITY 16 0000 28 0000 UNIT COST 20 0000 20 0000 OVERHEAD 0 0000 3 6000 COMMITTED BILLED TOTAL COST 320 0000 560 0000 378 0700 0 0000 TOTAL SALES 320 0000 0 0000 0 0000 SHOW TRANSACTIONS DATED 92 92 02 21 2 7 JOR ESC EXIT Level 3 To view individual operations press F1 to display the next level of enquiry FUNCTION KEY FACILITIES F1 SCAN to scan the operations relating to the job currently being viewed F2 B WD to return to the previous screen F10 to enter or scan another job number l Esc to end the program Scan the operations and select enter the appropriate Scan or enter the required transaction type If the transaction type is a labour or materi
177. operation and transaction detail e Calculation of cost to complete Using the variances between actual and estimates per job it is possible to calculate the revised anticipated cost of finishing a project e Multiple sequence tenders Tender documents and details can be printed in a variety of different sequences e Automatic cleardown On completion of a contract automatic cleardown facilities are provided e Interfaces Optional Purchasing Inventory Invoicing and Payroll interfaces enable additional information to be transferred to and from these systems 1 4 JULY2008 Job Costing User Guide TITAN 2000 MODULE REVIEW The Job Costing system consists of the following functional modules Input Batch Maintenance Enquiries Scans Print Period end and Interface INPUT MODULE Used to input the relevant job cost information Costs are posted to the various operations within the jobs that form a project Default cost rates are available per line item and can be overridden as circumstance demands e May be interfaced to the Inventory system Weekly Payroll system Accounts Receivable Sales Order Processing and Purchase Ordering systems BATCH This includes Job templates and batch capturing of materials input MAINTENANCE MODULE The module maintains the job header cost category transaction type and work centre maintenance functions ENQUIRIES SCAN MODULE The Job Costing file may be viewed as foll
178. or to ensure that the printer is lined up correctly 3 72 JULY 2006 Job Costing User Guide TITAN 2000 DETAILS OK Y N Accept the details entered or correct them will return the cursor to the top of the page and Y will allow the program to proceed to Level 3 The status line displays the other available options Level 3 NUMBERING M A S M For manual numbering of invoices This allows the operator to enter invoice numbers A For automatic numbering of invoices This increments invoice numbers by one S For semi automatic numbering This allows the operator to enter the first invoice number and the system will increment this by one each time a new invoice is entered An alteration to this may require a supervisor password to be entered Level 4 WAREHOUSE 2 digits This question will only be asked if the system parameter file for the stock system indicates that warehousing is an option Level 5 JOB 4 characters The required job number to which this order refers Level 6 The credit note header program is exactly as described for program SP18 Demand Credit Note Entry in the Sales Order Processing system Please refer to that User Guide for further information Level 7 OP 4 characters Optional This entry is only requested if the specific job has associated operations Enter the operation to which this transaction line refers TRANS 1 digit Enter the transaction type of this transaction
179. ows e Scan complete jobs and the operations within them displaying current month year to date cumulative and estimate costs In addition the variance amounts and percentages are calculated and displayed e Enquire against detail transaction items which can be viewed with an option to print PRINT MODULE All reports allow the project job and operation range and status codes to be selected The print module produces the following reports e Job detail listing e Detailed or summary costing reports e User definable form per job operation e Cost type per job e Scrap analysis report e Work centre analysis e Action report e Cost category report Work Centre productivity report e Transaction audit trail JC Getting Started JULY 2006 1 5 TITAN 2000 PERIOD END MODULE This module is used at month and year end to perform the following function e Month end update Year end update Job deletion and Selective transaction deletion functions INTERFACE MODULE This module interfaces to Purchase Orders Sales Order Processing and Inventory Control systems allowing costs to be posted to the relevant jobs from receipt of purchases or issue of an invoice 1 6 JULY2006 Job Costing User Guide TITAN 2000 1 4 CONCEPTS AND FUNCTIONS Please refer to the Systems Utilities Manual for a complete explanation of the concepts and functions used throughout the TITAN system JC Getting Started JULY 2006 1 7 TIT
180. ponent and may not exceed 30 characters The sum of all the components including any blanks may not exceed 30 characters DESCRIPTION TYPE 2 characters Optional if a description is to be attached to the component enter the description type here The description code must be present in the descriptions file when entering alternate codes as all entries are validated ALPHA NUM A or N If a component is defined as being numeric N this will be validated at all stages Press F1 to select which records are to be linked to the current alternate key JC Maintenance JULY 2006 4 121 TITAN 2000 Level 4 JOB COSTING ALTERNATE FILE MAINTENANCE JESL LIDO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN JOB COSTING MASTERFILE ALTERNATE SEQUENCE ALT1 ALTERNATE SEQUENCE BY CUST ACC JOB FROM 00 1 uo t 7 7 ALTERNATE CODE 1 019001 4 011 ALTERNATE KEY SCAN CO BR JOB ALTERNATE CODE CUSTMR STRT DATE STATUS 01 01 GA01 01019001 01 9001 92 702 721 01 01 GA02 01019001 02 9001 92 02 27 01 01 GA03 01019001 03 9001 01 01 FL1 01019004 FL1 9004 92 02 27 01 01 FL2 01019004 FL2 9004 927012 27 01 01 FL3 01019004 FL3 9004 92 02 27 01 01 FL4 01019004 FL4 9004 o2 01 01 FL5 01019004 FL5 9004 92 02 27 01 01 TMP1 01019004 1 9004 912 7012 1 277 OV OV OV 0 OF T TEMSE Fl SCAN FILE P3 UPDATE FS SEO FG SCAN CODES
181. post the invoice through to Sales Order Processing The system displays the invoice details and requires you to press F3 again before posting 3 58 JULY 2006 Job Costing User Guide TITAN 2000 3 5 PURCHASE ORDER ENTRY JC17 This program simulates program PO10 Order Input in the Purchase Order Processing module It allows you to capture Purchase Orders against a specific Job The Purchase Order which is created will have receipts entered against it in the normal way These receipts are posted the Creditor and to the Job as actual costs using PO92 Batch Posting to Accounts Payable to post to Creditors for non job PO s and program JC92 PO Updates to Job to post to Job Costing AND Creditors for Purchase Orders relating to jobs Enter JC17 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide JOB COSTING CONTRACT INPUT PURCHASE ORDER wey 11 40 7 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN WH 01 CENTRAL HEADER 1 PURCHASE ORDER STATUS OUTSTANDING NEW ORDER VENDOR RICHARDS CONCRETE CORP TAX EXEMPT VENDOR REFERENCE JOB FREE FORMAT Y N N COMMENCING DATE 92710277 COMPLETION DATE 77 273 ROUTE DELIVERY ADDRESS 000 CAPE TOWN BUYER REFERENCE CONFIRM Y N N WHO CONFIRM Fl WEXT SCRN FS FIO BACK
182. prints each transaction type in its own column For this reason the operator has to select whether to print month to date year to date or cumulative values Enter JC74 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING COST TYPE BY JOB JC74 11 001 CO 01 TECHNOLOGIES INCORPORATED BR CAPE TOW PERIOD 10 FROM JOB Fil 10 JOB GA03 JOB SCAN PRINT VALUES JE DATE 2 YEAR TO DATE 3 CUMULATIVE PROCEED WITH PRINT Y N PROCESSING GA03 FROM JOB TO JOB f The default is all jobs or enter the starting and ending job range It is possible to scan all the jobs on the file using the F1 key The F5 key will toggle the scan between job and project sequence PRINT VALUES 1 Month to date 2 Year to date 3 Cumulative Enter the appropriate selection PROCEED WITH PRINT f Y N Accept the information or alter any incorrect entries Press F10 to return to the company branch selection screen The Esc key will end the program JC Print JULY 2006 6 161 TITAN 2000 01 TECHNOLOGIES INCORPORATED JOB COSTING COST TYPE BY JOB DATE 98 05 11 11 17 PAGE a BR 01 CAPE TOWN JC74 11 002 PERIOD 10 OPTIONS FROM JOB ALL TO JOB PRINT VALUES YTD ACTUAL CALCD OHD 3600 00 J102 00 J103 J104
183. pts relating to purchase orders for jobs entered via program JC17 or program JC18 will be posted to the Job Costing files updating the actual costs These receipts will also automatically generate an issue from stock to the job if the option is set in JCOO System Record Maintenance At the same time the committed cost figures will be decreased if the option has been set in program JC00 System Record Maintenance In addition invoices and optionally receipts depending on the option selected in POOO System Record Maintenance will be posted to Accounts Payable There is an option in JC00 System Record Maintenance which will prevent this program from updating the Accounts Payable system all updates will then be done PO92 Interface to Accounts Payable When stock transactions are created the JOB is written to SA1 JOB COSTING PO UPDATES TO JOB wegen CO 01 TECHNOLOGIES INCORPORATED BR DI TOWN ALTERNATE SEQUENCE CODE ALT1 CODE DESCRIPTION 6 PURCHASE ORDERS TRANSACTIONS FI SCAN OPTS EID JC Set up and Run JULY 2006 2 31 TITAN 2000 Level 1 ALTERNATE SEQUENCE CODE f 4 characters These codes are set up in program PO31 Alternate Sequence File Maintenance and provide user defined sequences JOB COSTING PO UPDATES TO JOB IEHL boy CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE T
184. put Please refer to the System Utilities User Guide and to Appendix A2 at the back of this guide for more information JC Set up and Run JULY 2006 2 23 TITAN 2000 Level 6 JOB COSTING TRANSACTION SUMMARY If the General Ledger system is not being used or integrated to this system leave the code displayed as it is and use the totals displayed as control totals Enter a relevant General Ledger code into the JOB COSTING CONTROL C FWD field This is a user defined field of up to 30 characters for example 9999 99 999 99 and is set up in program GLOO System Record Maintenance JOB COSTING SYSTEM RECORD MAINTENANCE JCOO0 11 002 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN SINCE LAST MONTH END DESCRIPTION ACTUAL COSTS INVENTORY 4938 2014 LABOUR 82825000 CALCD OHD 0 0000 OTHER 0000 LAB NOT WP 0000 NOT USED 0000 NOT USED 0000 NOT USED 0000 NOT USED 0000 JC CONTROL B FWD 0000 JC COSTING C FWD 1000 00 666 01 o MOILA SORTA 55 Use the F5 key to toggle the display between actual and standard costs Press F3 to update the record The status line provides all the function key options 1 24 JULY 2006 Job Costing User Guide TITAN 2000 2 3 PROCESSING AND BACKUP CYCLES DAILY amp WEEKLY CYCLES Once the steps outlined in the set up sequence have been followed all programs in the Job Costing system with the exception of the period end module pr
185. quired quantity Enter JC99 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide FROM TO JOB f 4 characters Enter the required range of jobs or leave this blank for all jobs to be affected Press F3 for the update to take place and the audit trail to print 1 42 JULY 2006 Job Costing User Guide TITAN 2000 3 INPUT MODULE 3 1 THE INPUT MODULE MENU This module consists of two separate modules which contain the following programs INPUT MODULE JC10 JOB COST INPUT JC11 INTERFACE TO ACCOUNTS RECEIVABLE JC13 CREATE INVOICE IN SP JC17 PURCHASE ORDER ENTRY JC18 DEMAND PURCHASE ORDER JC19 CONTRACT INPUT BATCH MODULE JC20 JOB TEMPLATE INPUT JC21 JOB MAINTENANCE FAST MATERIALS INPUT JC22 JOB COST INPUT FAST MATERIALS INPUT The Input module consists of a multi purpose program that handles the input of costing transactions for any or all of the nine transaction types set up in program JC33 Transaction Type Maintenance It also provides a link to the Sales Order and Purchase Order systems through the contract input programs The fast input module provides the facility to capture job templates which may be copied to jobs This saves capturing time for similar jobs The job copied from the template may then be altered and maintained using program JC21 Actual material quant
186. ress Enter in both fields for the full range to be printed A scan of the categories is available 1 Current period 2 Periods 1 through 6 the default 3 Periods 7 through 12 Make the appropriate selection Y N Press Enter to accept the selections or enter N to enable changes to be made The Esc key will end the program JULY 2006 6 171 TECHNOLOGIES INCORPORATED JOB COSTING COST CATEGORY REPORT DATE 98 05 11 11 19 PAGE CAPE TOWN JC78 11 003 PERIOD OPTIONS FROM CATG SUNDRY JOB COST CATEGORY 7340 00 000 00 Sundry Expenses LABOUR COSTS HOUSING 7340 00 000 00 Sundry Expenses COMPUTER USAGE 7180 00 000 00 Lease Payments CASUAL LABOUR 7300 10 000 00 Salaries 8 Wages LABOUR COSTS MALLS 7340 00 000 00 Sundry Expenses DRAWING EQUIPMENT 7180 00 000 00 Lease Payments LABOUR COSTS ROAD BUILDING 7340 00 000 00 Sundry Expenses GRAND TOTAL JC78 Cost Category report 6 172 JULY 2006 Job Costing User Guide REPORT TYPE 2 JOB COSTING COST CATEGORY REPORT 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN REPORT TYPE PRINT DIVERSIONS DIVERSIONS ONLY Y JOB OP PERIODS PROCEED WITH PRINT Y N N FROM TO 3 N N FL1 INST FL1 INST 1 TITAN 2000 JC78 11 001 PERIOD 10 CATEGORY LEVEL JOB LEVEL JOB LEVEL OB SCAN CURRENT PERIOD PERTODS TO 6 PERIODS 7 YO 12 SP EINIAOETSUONS SEESIONC
187. rom the description of the of the operation default as set up in program System Record Maintenance 30 characters Enter a meaningful description for this operation 8 characters A scan is available as an aid but this field may be left blank DD MM CCYY DD MM CCYY Entry of these two dates will only be requested if this option has been selected in program JC00 System Record Maintenance Y N This field is for memorandum purposes only Y N This field is for memorandum purposes only JULY 2006 4 107 TITAN 2000 STATUS 1 character scan on this field is available PRO RATA PERCENTAGE 3 2 digits Please see Appendix A at the back of this User Guide for more information JOB COSTING JOB OPERATION MAINTENANCE Jes 11 003 CO 01 TECHNOLOGIES INCORPORATED BR Dl CAPE TOWN PERIOD 10 JOB FL1 INST FIRST FLOOR PRIVATE BATHROOM INSTALLATION TRANS SUNDRY JOB COST CATEGORY PRODUCT TRANS SCAN TRANS DESCRIPTION CLASS 0001 lt gt INVENTORY MATERIAL USAGE 0002 LABOUR LABOUR 0003 CALCD OHD CALCULATED OHD 0004 OTHER OTHER 0005 LAB NOT WP LABOUR 0006 NOT USED NOT USED 0007 NOT USED NOT USED 0008 NOT USED NOT USED 0009 NOT USED NOT USED PL F2 DETAILS END FS TOGGLE EID PREV Level 4 TRANS 1 digit The transaction types are displayed on the screen The appropriate one for this operation should be selected CATG 4
188. ry 9 The Standard Cost is calculated using the actual quantity posted and the standard rate The Work Centre File JCWORK is read and calculated overheads are computed Appendix 186 TITAN 2000 Job Operation File JCOPRN is read at the level specified on the Job Masterfile If an operation record is not found and the CREATE OPERATIONS option is set then an operation record is created with zero estimates The actual quantity rate amount and calculated overheads together with standard rate amount and calculated overheads are updated for the operation If the JCOO reduce committed costs option is set then the actual amount posted is deducted from the committed cost for the operation The Job Masterfile JCMAST is then updated where the actual amount is added to the MTD YTD and cumulative actual amounts for the specific transaction type The calculated standard amount is likewise added to the MTD YTD and cumulative amounts Calculated overheads are added to the dedicated calculated overheads transaction type Percentage complete and cost to complete fields are then re calculated and updated for the job If the JCOO REDUCE COMMITTED COSTS option is set then the actual amount posted is deducted from the committed cost for the job The Job Category File JCANAL is updated with the actual amount posted Each category specified for overheads in the work centre file are then updated with the calculated overhead
189. s This will be read from the debtors masterfile 20 characters This will be read from the debtors masterfile 15 characters This will be read from the debtors masterfile 8 characters This is the user defined reference entered in JC30 Job Operation Maintenance 9 2 digits This field is used by program JC13 Create SP Invoice from Operations for calculating the quantity of an operation to issue to SP It implies the number of completed items this job creates 8 characters This is an indicator showing whether the job is complete a template or invoiced BODY DETAILS TITAN 2000 Body detail screens will be presented until all body information has been specified Only then will the trailer and title screens be presented Please refer to the Systems Utilities manual program SU35 Customised Form Maintenance for more details regarding fonts and currency formatting BODY 1 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE Sus 8 001 BODY 1 JOB COSTING SOFT FORMS OPERATION DETAILS JOB NUMBER OPERATION NUMBER OPERATION DESCRIPTION OPERATION START DATE OPERATION END DATE TRANSACTION TYPE TRANSACTION DESCRIPTION WORK CENTRE WORK CENTRE DESCRIPTION STATUS SCHEDULED ACTIVE CATEGORY CATEGORY DESCRIPTION EMPLOYEE STOCK NUMBER EMPLOYEE STOCK DESCRIPTION COLMN DGT DEC IS THE ABOVE INFORMATION CORRECT Y N Ya FI NEXI F2 PREVIQUS F3 SAVE FS DELETE F9 PRINT
190. sessions are entered in the Inventory system using program IV34 Alternative Supersessions Maintenance Program 00 System Record Maintenance is also used Look at the screen called INVENTORY TRANSACTION PARAMETERS there two columns which pertain to Supersessions The first is called SUPERSESSIONS AUTO OPTION and the second PASSWD The first allows you to specify an automatic action to be taken on the different transaction types when the system detects that an item has been superseded In the absence of a specified action the input programs will stop and wait for operation intervention The possible actions are as follows 1 Continue as though there is no supersession and process on the old item 2 Supply the available quantity on the old item and ignore the remainder 3 Supply the available quantity on the old item and the remainder for the supersession 4 Supply everything on the supersession item We suggest that options be allowed as below although this is not mandatory Option Goods Invoice for Transaction received Goods Type received o If the field is left blank a second prompt will be displayed This requires an N in any or all of the 4 positions which correspond to the options above An N in any position indicates that this specific option will not be available to an operator at entry stage The second new column expects a Y N response This is to indicate whether a supervisor password will be
191. setup time and the time used Remember that SETUP is a soft term which you may redefine in SU30 Installation Maintenance Option 4 7 2digits Difference between the estimated run time and the time used Appendix 207 TITAN 2000 INVENTORY You may print the inventory details listed below if required PHYSICAL STOCK 7 2 digits FREE STOCK 7 2 digits Appendix 208 TITAN 2000 BODY 5 JOB COSTING SOFT FORMS SYSTEM UTILITIES CUSTOMISED FORM MAINTENANCE Sus 11 001 BODY 5 JOB COSTING SOFT FORMS COLMN DGT DEC TRANSACTION DETAILS DOCUMENT DATE AUDIT NUMBER PERIOD CATEGORY DIVERSION WORK CENTRE NARRATIVE REFERENCE CROSS REFERENCE SIv IS THE ABOVE INFORMATION CORRECT Y N 1 F2 PREVIOUS F3 SAVE F8 DELETE F9 PRINT 10 FORM ESC EXIT TRANSACTION DETAILS Complete these fields if you wish to print transaction details DOCUMENT DATE DD MM CCYY Document date of the transaction AUDIT NUMBER 7 digits Audit number per transaction as defined by SU32 NUMBERS FILE MAINTENANCE type J PERIOD 2 digits Transaction Period CATEGORY DIVERSION 4 characters Category or diversion code to which the transaction belongs WORK CENTRE 8 characters Work centre for the transaction NARRATIVE 30 characters Narrative as entered for the transaction REFERENCE 8 characters Reference as entered for the transaction
192. stem maintained If the warning message There are existing transactions using this GL Are you sure you want to change this GL then the system requires Yes or No answer On completion of the update press F3 to update the file or press F10 to end the program at this point and leave the data unchanged 4 4 3 DELETING COST CATEGORIES Proceed through the steps required for entering 4 4 1 but now enter the category to be deleted Scan or partially scan using F1 for the required category Press F8 to initiate deletion or Esc to end the program at this point If there are balances in any of the twelve periods a warning message Non zero balances deletion not allowed will appear on the screen and no deletion will be permitted After deletion the program returns to the category input field 3 126 JULY 2006 Job Costing User Guide TITAN 2000 4 4 4 UPDATING JOB COSTING ANALYSIS CODES At the Level 2 Update field select 2 Job Costing Analysis to update the levels at which sales will be analysed Setting up a job analysis code is completed at the time of loading that job program JC30 Job Operation Maintenance but this program provides a fast and convenient method of updating the analysis codes of a range of job Level 2 The program prompts for a selection of the basis on which the update will be carried out UPDATE JOB PROJECT ITEMS 1 Range of job Update a range of job analysis codes 2
193. ters The batch number entered above is inserted as a default but this may be altered to any user defined reference 9 2 digits Enter the total transaction quantity of this batch 9 4 digits Enter the total cost for this batch JULY 2006 3 45 TITAN 2000 The total of ALL transaction lines will be compared to these fields and must be equal before posting allowed DETAILS OK Y N Accept the details or make the required amendments and continue to the next level The computed or variance fields are not available for entry but are calculated by the system The computed figures are the sum of the transactions entered thus far for this batch Level 3 LINE JOB JOB COSTING JOB COST INPUT JC10 11 008 01 TECHNOLOGIES INCORPORATED Be Dl CAPE TOWN PERIOD 10 BATCH 1 LINE 1 NOT ON FILE JOB pact FIRST FLOOR PRIVATE BATHROOMS OPERATION INST INSTALLATION TRANSACTION TYPE 1 INVENTORY CLASS MATERIAL USAGE CATEGORY 7000 MATERIAL COSTS INSTALLATIONS PRODUCT 001 1WB WIT 46 WHITE CASCADE HANDSHOWER SPIRA EXISTING OP SCAN OP DESCRIPTION CATG PROD EMP ACTIVE ST 2INSTALLATION 001 1WB WIT 46 NSTALLATION 006S 20 WIT 46 STALLATION 068ADJ WIT 46 NSTALLATION 106AQ 15 STALLATION 125 15B NSTALLATION 147CA STALLATION 401 NSTALLATION 414CA STALLATION 431 LANNING WITH PROJECT MANAGER 00010 01 z n 4 fs IH BEI E nun Wee ee ee ee ST NST KKK KK KK KKK Pl SCAN FI
194. ters A code of 4 blanks which indicates default category is always required DESCRIPTION 30 characters DIVERSION CODE Y N Y will indicate that this cost code is never to be allocated to a specific job operation but that the cost category only is to be updated This is used for exceptional type costs where a record must be kept of expenses but where they do not relate directly to a job STANDARD COST 7 4 digits Enter the standard cost applicable to this category or leave it blank PER H hour D Day M Month OVERRIDABLE Y N If Y may be overridden on Program JC30 Job Operation Maintenance and or JC10 Job Cost Input LEAD TIME 5 digits memorandum only Unit of time H hour D day M month MARGIN f 3 2 digits Enter the expected gross margin percentage for this cost category At present this is only a memorandum item 124 JULY 2006 Job Costing User Guide TITAN 2000 JOB COSTING COST CATEGORY MAINTENANCE SIG 2 11 00 01 CO 01 TECHNOLOGIES INCORPORATED BR DL CAPE TOWN CATEGORY 1000 DESCRIPTION L DIVERSION CODE N STANDARD COST MARGIN 25 00 LEAD TIME 01 GL ACCOUNT CODE 02 APRIL 0 00 08 SEPTEMBER OCTOBER 0 00 0 00 UPDATE ES DELETE MARKUP GL ACCOUNT CODE TOTALS ABOUR COSTS 25 0000 5100 00 100 001 10 PER HOUR OVERRIDABLE Y 3 MARKUP 0 00 DEBIT CREDIT 1
195. the default or enter a relevant reference This reference will be carried through to the Inventory Transaction File when issuing materials to a job in program JC22 Job Cost Input Fast Materials Input 7 2 digits This is only a memorandum field and may be left as a zero Y N Accept the details entered to proceed to the next screen or amend any incorrect details If you indicated that the job consisted of more than one operation a further screen will now be presented for entry JOB COSTING JOB OPERATION MAINTENANCE JC30 11 003 CO 01 TECHNOLOGIES INCORPORATED BRE 01 CAPE OP HEADER DETAILS JOB OPERATION DESCRIPTION WORK CENTRE START DATE END DATE SCHEDULED Y N ACTIVE Y N STATUS PRO RATA PERCENTAGE DETAILS OK Y N EIU OP 5 ESC EXIT OPERATION JC Input PERIOD 12 FLI FIRST FLOOR PRIVATE BATHROOMS FINI FINISHING FACTORY PLANNING COSTING P27 02 211 92 019 211 4 characters digits depending on the definition in program JC00 System Record Maintenance Accept the operation as entered on the template or enter a new one if any additions are required JULY 2006 3 87 DESCRIPTION WORK CENTRE START DATE END DATE SCHEDULED Y N ACTIVE Y N STATUS PRO RATA PERCENTAGE DETAILS OK Y N Level 4 TRANS CATG JULY 2006 TITAN 2000 30 characters Accept the default from the template or enter a description for this operation 8
196. these values on any subsequent work centre records but the operator will be allowed alter any or all of them CREATING WORK CENTRE DEFAULTS Level 1 JOB COSTING WORK CENTRE MAINTENANCE MESS CO DI TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN 11 001 PERIOD 10 WORK CENTRE MANUF DESCRIPTION FACTORY PLANNING COSTING STD LABOUR RATE 35 0000 PER HOUR 8 0000 PER HOUR 15 0000 STD SETUP RATE STD HOURS OVERHEAD DESCRIPTIONS RATE PERCENTAGE WAT amp ELEC 0 5000 COST CATEGORY 2000 APPLY ON TRANS TYPE S i 2 94 50 y X Y LEY NE 30 NG OF TOTAL PER HOUR 1 5 1 PER HOUR 1 PER HOUR 1 x 0000 AREA MAINT 0000 1 0000 0000 Y TRANSACTION TYPES 1 INVENTORY OTHER 7 NOT USED 2 LABOUR 3 CALCD OHD F1 FWD F3 UPD STD LABOUR RATE PER JC Maintenance 09 DE LAB NOT WP NOT USED 10 WORK CENTRE 7 4 digits 3 INO 0 00 9 NOT USED ESG Jap IEE This is the standard labour rates relating to the work centres 4 characters This is the unit of time to which the rate applies for example day hour etc JULY 2006 4 135 STD SETUP RATE PER STD HOURS OVERHEADS DESCRIPTIONS RATE PERCENTAGE COST CATEGORY APPLY ON TRANS TYPE S TITAN 2000 7 4 digits This is the rate of cost to set up the work centre to start production Remember that SETU
197. tion types ACTUAL CUMULATIVE 9 4 digits This represents costs incurred to date The F7 key will toggle the display between actual and standard costs VARIANCE 9 4 digits The variance is a calculated figure representing the difference between the two previous fields ESTIMATED COST TO COMPLETE 9 4 digits This is a calculated field representing the estimated costs to complete the job JC Input JULY 2006 3 83 QUOTE EXPECTED PROFIT EXPECTED PROFIT BILLED COSTS BILLED SALES TITAN 2000 9 4 digits This represents the total of all the Suggested Selling Price fields held on the individual operations relating to this job 9 4 digits This field represents the difference between the total value of the estimate and the value quoted 3 4 digits This field is calculated using the estimated cost and selling values 9 4 digits 9 4 digits The above two fields are updated by the system and are not available for entry Press F3 to end entry for the operation JULY 2006 Job Costing User Guide TITAN 2000 3 9 JOB MAINTENANCE FAST MATERIALS INPUT JC21 The function of this program is twofold it allows templates created in program JC20 Job Template Input to be copied as actual jobs and it provides a facility for the fast capture of estimated materials usage It is similar to program JC20 Items already captured on program JC20 may now have a quantity entered against them item lines
198. to this labour transaction TYPE R refers to normal run time units of labour S refers to set up units of labour RATE 7 4 digits This is the Rand value rate per labour unit as set up in program JC30 Job Operation Maintenance It defaults to that rate but may be altered TOTAL COST This field is not available for entry It is a calculated field using the two values entered above This entry will display COMMITTED ACTUAL or BILLED depending on the transaction type selected on the batch header SALES VALUE 7 4 digits This field is only available when entering billed amounts NARRATIVE i 30 characters Enter a meaningful narrative This will be printed on JC80 Audit Trail 3 52 JULY 2006 Job Costing User Guide TITAN 2000 If the transaction type selected on the batch header was 2 Transaction Capture the following will be presented for entry SCRAP QTY i 7 2 digits If a record of scrap quantities is to be kept enter the scrap quantity pertaining to this transaction here SCRAP COST 7 4 digits Enter the value relating to the scrap quantity if applicable This field represents the total cost of scrap for this transaction Accept the entries or correct any of the fields The status line displays all the options available JOB COSTING JOB COST INPUT JC10 11 008 CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 BATCH 1 BATCH HEADER REFERENCE WED 18 3 COMPUTED VARIA
199. two forms exactly the same side by side PRINT TEST REQUIRED Y will produce a test printout which will enable the operator to ensure that the printer is lined up correctly 3 68 JULY 2006 Job Costing User Guide DETAILS OK Y N TITAN 2000 Accept the details entered or correct them N will return the cursor to the top of the page and Y will allow the program to proceed to Level 3 The status line displays the other available options Level 3 NUMBERING M A S M For manual numbering of invoices This allows the operator to enter invoice numbers A for automatic numbering of invoices This increments invoice numbers by one S for semi automatic numbering This allows the operator to enter the first invoice number and the system will increment this by one each time a new invoice is entered An alteration to this may require a supervisor password to be entered Level 4 WAREHOUSE Level 5 JOB JC Input 2 digits This question will only be asked if the system parameter file for the stock system indicates that warehousing is an option 4 characters The required job number to which this order refers JULY 2006 3 69 Level 6 TITAN 2000 The invoice header program is exactly as described for program SP16 Demand Invoice Entry in the Sales Order Processing system Please refer to that User Guide for further information JOB COSTING CONTRACT INPUT 01 TECHNOLOG
200. ue is read from the Inventory File according to the default unit of cost as specified in program JC33 Transaction Type Maintenance for Inventory Type transactions It may be altered 9 4 digits This field is calculated and is not available for entry The calculation is Quantity issued Unit price JULY 2006 3 97 TITAN 2000 6 characters The default is the vendor code held on the stock masterfile but may be altered This field is not validated It is written to the stock transaction file and may be viewed in program IV50 When all material requirements have been captured use the up arrow to enter another category or transaction type or press F3 to proceed to the next level Level 5 for transaction type LABOUR ISSUE TO JOB COSTING JOB OPERATION MAINTENANCE CO 01 TECHNOLOGIES INCORP BR 01 CAPE TOWN J104 0040 2 LABOUR JOB OB TRANS HOUR SET TIME RATE RUN TIME RATE OVERHEAD Z000 i 25 0000 15 0000 TOTAL SUGGESTED SALES EXPECTED PROFIT 1105 0 EZ DETAILS UPDAT EMPLOYEE WP CODE WORK CENTRE JESO LOLS ORATED 10 CONSTRUCTION PROJECT LAYING FOUNDATIONS CLASS LABOUR SUNDRY JOB COST CATEGORY LABOUR TOTAL 535 0000 CALCULATED OP OHD 0 0000 JOB TOTAL 687 2500 1 TOGGLE 000 F10 OP SCAN If the transaction type entered was labour the employees as entered on
201. update estimates JC Input JULY 2006 3 75 TITAN 2000 3 8 JOB TEMPLATE INPUT JC20 This program allows you to create job templates which is a useful feature where many similar jobs exist These templates may be accessed in program JC21 Job Maintenance Fast Materials Input and copied to a genuine job Enter data into the following job masterfile fields Level 1 JOB i 4 characters digits depending on the definition in program System Record Maintenance End each input by pressing Enter or by filling the field with data If an error is made use the arrow keys to move back to the field and re enter the data Use the backspace key if an incorrect character or digit is entered Not all the fields displayed on the screen are mandatory Enter data only into those fields that are applicable Press F3 at any point in the data entry to end data input and update the file Level 2 DESCRIPTION s 30 characters Enter a description for this job PROJECT 4 characters digits depending on the definition in program System Record Maintenance scan of project codes is available as an aid If a code is entered which has not been created using program 6031 Descriptions File Maintenance type JP then this code will be rejected for entry CUSTOMERS CO BR 2 digits 2 digits Enter the specific company and branch against which customer numbers are to be validated 3 76 JULY 2006 Job Costing User Guide
202. upervisor intervention The option selected will be saved on the ORDERS file SP10 ORDER ENTRY SP19 DEMAND ORDER ENTRY SP11 ORDER REVIEW The following programs will check the options set in program 00 System Record Maintenance for Issue parameters and will take suitable action or prompt for operator and or supervisor intervention SP15 BATCH INVOICE ENTRY SP18 DEMAND CREDIT NOTE ENTRY SP16 DEMAND INVOICE ENTRY SP40 BATCH ORDER CAPTURE SP17 CREDIT NOTE ENTRY The following programs will check the options set in program 00 System Record Maintenance for Transfer parameters and will take suitable action or prompt for operator and or supervisor intervention SP20 BRANCH ORDER ENTRY SP21 BRANCH ORDER REVIEW Appendix 191 TITAN 2000 When the following programs are run the system checks to see if any supersession decisions were taken in program SP10 Order Entry program SP11 Order Review or program SP20 Branch Order Entry or program SP21 Branch Order Review If so it uses the record as it stands If no check has been performed yet and the item has been superseded the transfer does not take place and the relevant review programs must be used to change the records with supersessions SP14 ORDER RELEASE SP78 ORDER RELEASE AND PRINT SP24 BRANCH ORDER RELEASE Program SP45 Batch Invoice Capture does not check for supersessions at all but use the records as they stand Program SP61 Back Ord
203. ve to select the sequence in which transactions are to be printed Depending on the selection made above one of these ranges will be presented for entry Either enter a start and end range or press Enter in both fields for the full range to be selected for printing JULY 2006 6 179 TRANSACTION DATE FROM TO COST OPTION PRINT SUBTOTAL Y N DETAILS OK 6 180 TITAN 2000 From date Enter the date DD MM CCYY from which the audit trail is to start printing The default date is the current date To date Enter the last date DD MM CCYY to be included in the audit trail The default date is one month greater than the from date 1 Actual Costs 2 Standard Costs 3 Sales value Enter one of the above to indicate which value is to be printed on individual transactions Y N Enter Y if subtotals are to be printed at each break in the report sequence For example if option 6 Work centre was selected for the report sequence Y in this field will cause a subtotal to print at the end of each work centre s transactions Y N Press Enter to accept the selections or enter N to enable changes to be made The Esc key will end the program JULY 2006 Job Costing User Guide TECHNOLOGIES INCORPORATED JOB COSTING AUDIT TRAIL 98 12 14 17 15 PAGE CAPE TOWN DATES FROM 93 11 14 93 12 14 JC80 11 101 PERIOD JOB DESCRIPTION DESCRIPTION N ACTUAL COSTS FL1 FIRST FLOOR PRIVATE BATHROOMS
204. vertime Idle Productivity Productivity Employee hours per hours time Percentage including week overtime Work Centre Read from Hours booked Hours booked a b b a 100 b c a 100 code and the Work to the work to the work description Centre file centre as centre as entered in entered in JC10 as Run JC10 as time Setup time Enter JC79 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide 6 176 JULY 2006 Job Costing User Guide TITAN 2000 Level 1 JOB COSTING WORK CENTRE PRODUCTIVITY JUS LILO CO 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 FROM WORK CENTRE TO WORK CENTRE TRANSACTION DATES 1998 08 23 TO DATE DETAILS OK 1 5 FILE F9 PRT OPTS 10 5 FROM WORK CENTRE TO WORK CENTRE Enter the start and end range or press Enter in both fields for the full range to be selected for printing TRANSACTION DATES TO DATE Enter the date range for which transactions are to be selected The report will print as per the example on the next page JC Print JULY 2006 6 177 01 TECHNOLOGIES INCORPORATED JOB COSTING WORK CENTRE PRODUCTIVITY DATE 98 11 22 16 49 PAGE JC79 80 101 PERIOD 10 OPTIONS FROM WORK CENTRE ALL TO WORK CENTRE END 01 01 01 TO 93 11 22 WO
205. will add the relevant values to billed mounts Enter JC11 to select the program The Report Destination Company Branch combination and Report date may be optionally selected Please see the GETTING STARTED section at the beginning of this user guide Level 1 JOB COSTING JOB COSTE INPUL INTERFACE TO AR JC11 11 008 01 TECHNOLOGIES INCORPORATED BR 01 CAPE TOWN PERIOD 10 POST TO ACCOUNTS RECEIVABLE CUSTOMER 9004 AR BATCH 000210 AR INVOICE 000077 AR CATEGORY 1000 DETAILS OK Y N POSTING FL1 INST 001 1WB WIT 46 POST TO ACCOUNTS RECEIVABLE CUSTOMER 6 characters Enter required customer number AR BATCH 6 digits Enter the Accounts Receivable batch number AR INVOICE 6 digits Enter the Accounts Receivable invoice number AR CATEGORY 4 digits Enter the sales category to which this invoice must be allocated in the Accounts Receivable system DETAILS OK Y N Accept the details to continue with processing JC Input JULY 2006 3 55 TITAN 2000 3 4 CREATE INVOICE IN SP JC13 This program allows you to semi automatically create invoices in the Sales Order Processing system from a job using estimated costs and prices Please note that the USE JC10 TO ISSUE JC13 TO INVOICE parameter 9 00 System record Maintenance must be set to Y In addition the JC30 Estimating level must be 3 for item and you must specify operations The REF QTY is the num
206. y be left blank USAGE 5 2 digits This is read from the Work Centre file PERIOD 2 digits The current period is the default but may be changed This refers to the period in which the cost was incurred DOC DATE DD MM CCYY The current date is the default but may be changed REFERENCE 8 characters The reference is duplicated from the previous screen but may be altered DIVERSION 4 characters Scan for a diversion code as entered in program JC32 Cost Category Maintenance or enter one if the costs of this specific transaction should not be posted to the job entered Leave blank if a diversion code does not apply The following entries apply to all transactions except LABOUR please see Level 4 a for the LABOUR transaction types JC Input JULY 2006 3 49 TITAN 2000 Level 4 QTY 7 4 digits This quantity refers to usage for example 5 kg of a specific product The unit of measure as set up in program JC30 Job Operation Maintenance is displayed If this is an item where square metres are used as specified in IV30 Company Inventory Maintenance then a small window will be presented requiring you to enter the Unit Quantity Length and Width and the system will do the required calculations RATE 7 4 digits This entry defaults to the Rand value rate per unit of measure as set up in program JC30 Job Operation Maintenance but may be altered The default rate unit cost must be set up in program
207. ys to move the cursor to the fields to be updated Complete data entry into a field by pressing Enter or filling the field with data The cursor will then move to the next field The field size is indicated by the space between the square brackets Press F10 to ignore the changes made and return to the job number field To update the record after making changes press F3 Press F3 at any point in the update process without having to move right down the screen to the last field The record is updated and the program returns to the job number field for input of the next job number Pressing Esc will abandon the program and return to the Maintenance Module menu If instead of pressing F3 Y is entered into the Details OK field the various operations are presented for alteration JC Maintenance JULY 2006 4 117 TITAN 2000 4 3 ALTERNATE FILE MAINTENANCE JC31 This program is used to create user defined keys This will allow you to print certain reports in a sequence you require Enter JC31 to select the program JOB COSTING ALTERNATE FILE MAINTENANCE wes LLO 01 TECHNOLOGIES INCORPORATED BR Dl CAPE TOWN PERIOD 10 ENTER FILE FOR ALTERNATE SEQUENCES aly 1 JOB COSTING MASTERF ILE PS iil BSC Level 1 ENTER FILE FOR ALTERNATE SEQUENCES 1 character At present there is only one choice the JC Masterfile ALTERNATE SEQUENCE CODE 4 characters Enter a co

USER GUIDE - Seagull

Contents

Download Pdf Manuals

Related Search

Related Contents