Jobcost

Job Costing From MSD - Features
The MSD Job Costing Database contains several secondary-databases which have summarised overviews shown below.

Links To Sage Line 100
The MSD Job Costing Database "captures" information from the standard Sage Line 100 Modules and automatically posts the transactions. The links available are detailed under the features heading.

Job Costing Master File
The Job Costing Master File will contain all the static data in relation to each individual job. The job number will be the unique index. Transactions will be posted to the MSD Job Costing Database from the Sage Line 100 Modules during each period. This includes Committed Cost. In addition, the MSD Job Costing Database will have transaction routines (Journals) so adjustment postings can be made. There will be a parameter file within the MSD Job Costing Database which will hold the unique setting for each company for example the Job Number. The MSD Job Costing Database will also provide the costings for WIP (Work In Progress) and for the Job Profitability/Budget Reports. The user will have the option to run several management reports. A parameter can be set to either post the WIP figure directly to the Sage Line 100 Nominal Ledger or to prepare the information for the user to enter their own journal. Period end and year end routines are catered for. The parameters for the period end processing will be controlled by the calendar set up with the MSD Job Costing Database, and can differ from the Financial Month End Table set up within Sage Line 100. The system will maintain two files, these will be split into current jobs and historical jobs. The Job Completion routine provided will move the jobs when completed from current to history automatically. Enquiries can be made in summary form with the optional drill down to each line to obtain transaction details. Reports are available from the enquiry screen if required by the user. Management Reports will be available along with the normal maintenance reports and audit trails. If the Sage Line 100 Windows Report Generator is installed the user will be able to design and print their "one off" reports.

Employee Table
The employee table will hold all the employee details and pay rates. Each employee will be set-up on the table. The employee rates per hour can be entered for each individual employee, or, if the employee belongs to a group then the group code is attached to their table and the group rates will apply.

Labour Group Table
Each employee can be grouped together for labour costings, for example an Account Manager may belong to Group A and all labour costs for that employee will be charged at the group rate.

Revenue/Cost Headings
The user can set up and define the revenue and cost headings globally for the MSD Job Costing Database. This table will also hold associated rates and if a percentage/amount uplift is required for overheads this can be added to the table.

Description Table
For ease of use the user can set up a Job Description Table for either employees or a process within the factory or a job.

Budgets
There will be a parameter which the user can switch on if budgets are required. This will be done on a job level to allow flexibility within the MSD Job Costing Database. This will enable the user to decide when the job record is created whether they wish to apply a budget table to a job. If budgets are used then the system will be able to produce comparison reports and enquiries for the user against actual revenue and costs. Enquiries can be controlled by user access and the budgets can be isolated to specific user.

Contracts
The user may wish to split a job (contract) for a company into sections. For example Job Number 1006 may be the master job (contract). This may be then split down into sub sections. For example 1006/1 could be Artwork, 1006/2 could be Binding, 1006/3 could be Graphic Design and so on. The user will then be able to obtain costs and revenue (Expenditure & Income) for the overall job (1006) and for each sub section within that Job i.e. Artwork.

Estimates
This feature is linked to the MSD Contact Database and will allow the user to prepare quotations for prospects, using the MSD Job Costing Database. These can then be turned into actual jobs or contracts very easily at a later date when the customer orders.

Parts Lists (MSD Bill of Materials)
This allows the setting up of parts lists (Bill of Materials) for an item. The Bill of Materials interfaces with the MSD Job Costing Database. The parts list can contain items from stock, bought in parts, labour time, machine time and operational instructions. If linked to MSD Purchase Order Processing and Supplier Database, automatic purchase orders can be generated for stock outs and contract labour.

Parameters
The parameter file contains all the "switches" which detail how the system generates Job Numbers. The Job Costing period table will hold all the month end dates and period information of how each user wishes to handle the period end processing for their individual requirements. Linking to the Sage Line 100 modules will allow the user to monitor both committed and actual income and expenditure.

Click here for more information