Understanding the Job Cost Summary

<< Click to Display Table of Contents >>

Navigation:  Job Module >

Understanding the Job Cost Summary

Previous pageReturn to chapter overviewNext page

 

Overview:

The job costing screen, or report, is use to evaluate the performance of the job against estimates. From the information presented you will be able to determine very quickly whether your estimated time, material and workcenter costs are accurate and make adjustments accordingly.

 

To demonstrate the information contained in the JOB COST SUMMARY, the following image is layered to show the ‘Employee Details’, the ‘Workcenter Details’ and the  ‘CURRENT Job – 1016’ Job Cost Summary.

 

 

 

In this Job;

Workcenter 1 has a Charge Rate of $0.5555 per minute = $33.33 per hour

Workcenter 1 has a cost of $0.2500 per minute = $15.00 per hour

We are also charging the job “from the Workcenter” so the charge rate of $0.5555 will appear on the Process Control Sheet.

 

IMPORTANT – If we do not charge from the Workcenter the program will enter the charge rate from the employee file instead, eg. $1.00 = $60.00/hr

The employee clocking on to the job has a cost of $0.6666 per minute = $40.00 per hour

 

The Parameters – Job Ticket

A is a parameter that determines how the COST amount (pink) is calculated. In this example, un-ticked COST = 0.6666 + 0.2500

If it was ticked as black then, COST = 0.6666 + 0.2500 + overtime mark-ups (see parameters – main)

If it was half ticked as grey then, COST = CHARGE rate.

 

 

B is a parameter that determines how CHARGE B (green) is calculated. In this example, un-ticked CHARGE B = CHARGE A + (overtime + Mark-up)

If it was ticked full black it CHARGE B = CHARGE A +Workcenter Cost

 

In Both cases the Job Cost Summary window will tell you what has been set

 

 

The’ Parameters – MAIN’ window shows the mark-up on employee cost and charges as it uses the parameter – Job Ticket options, for Overtime as described above.

 

 

The image below now shows the same Job Cost Summary and the Process Control Sheet for Workcenter 1 on the same job.

 

From – The Job Cost Summary

Q-Rate        =  The Workcenter charge rate

Quote        = Est Time * Q-rate

C-Rate        = CHARGE A / Used Hours (shows variation)

Charge – A = used (H) * Charges from the process control sheet

Charge - B  = determined by parameter – Job Ticket (above)

 

 

From - Process Control

WC = Workcenter cost from WC details

EMP = Employee cost from the security tab of the employee file

These are all Costs and therefore have no mark-up

Charge = determined by WC parameter

NT = Normal time

1 ½ = Time and a half

DT = Double time

 

 

Additionally

 

 

Actual cost of material as it appears on the Job Cost Summary is picked up from ‘Process Control’.

 

1.A ‘Purchase Order’        COST = purchase cost
2.A ‘Material Issue’        COST = selected by user at data entry (see below)

 

 

Estimated material cost is taken from the job tickets and is the preferred suppliers cost at the time the job tickets were created.

 

 

Last Revised: 12/01/2012 SJ