Dear all experts, and Mr Rafael
I am very interested in this procedure to control cost, productivity for our projects (offshore platforms, jackup rigs). Can you share the material, etc related to job costing system.
The differences between CBS (focused on "product"), and WBS (focus on "work"/sequence) make me confused. And what detail level of OBS/RBS? How to use/compromise both these breakdown structures for cost & schedule control proper manner.
Thanks in advance,
Kanye Tuan Tong
Thank you sir so much!
- "I just think Job-costing softwares or ERP softwares will never fit every custommer, customers have specific requirements for their system, their projects."
- "So only them with their IT guys can build it by themselve perfectly, called inhouse software...or if having a very very flexible software."
Mr Rafael,
I just think Job-costing softwares or ERP softwares will never fit every custommer, customers have specific requirements for their system, their projects. So only them with their IT guys can build it by themselve perfectly, called inhouse software...or if having a very very flexible software.
Thanks
Agree.
Usually Unit/Job-Costing software provides for entering data by using a prefix to identify the job, then a few characters to identify the cost code and finally a suffix to identify the cost type.
In this way you can segregate reports by job. Then within jobs the software will provide a detailed cost report grouped per every cost account with several columns for each cost type [L/E/M/S/O] and a column that adds all cost types for every cost account.
Each software have their own reports the relevant issue is that quantities are reported and not only costs or percentages.
Mr Rafael,
Can not agree more with you.
I would like to ask more about the information flow in job costing for actual cost tracking because I am not on familiar terms with accounting guys...everything related to them shall be treated as top of top secret.
Please correct me if I'm wrong.
1. Direct Labor : Timecards from Field -> Payroll system of HR Dept -> Account Payable
2. Labor Burden/overhead: using method "normal costing", estimated rate shall be allocated to Labor, at the end of fiscal year shall re-calculate the actual rate for to be in line with actual cost. (information from Account Payable)
3. Production: to record achieved and forecast remaining quantity of each cost account from Field.
4. Material: MTO from engineering team or construction team -> POs of commercial team -> Invoice of Vendors -> Account Payable.
5. Subcontract: TR from construction team or engineering team -> POs of commercial team -> Invoice of Vendors (depends on contract type: lumpsum, unit rate, time rate) -> Account Payable.
6. Direct Equipment: Electricity, Fuel, Equip-hours... records from Field -> Account Payable. (maybe I'm wrong here, because electricity, fuel are difficult to distribute into each cost account, should them be equipment overhead)
7. Equipment Overhead such as Depreciation, Insurance, Maintenance & Repair, Tyre, Lubricant, Grease: also using "normal costing", allocated per Equip-hour. Should depreciation be Overhead cost?
All 1->7 shall be assigned into each cost account
Seems like you got the idea about coding.
Think also in terms of applying the codes, it is easy to apply different cost codes for labor in case of forms. On the time card the supervisor will write the appropriate descriptions such as column forms and wall forms but for materials it is difficult, when you buy lumber and nails it might be for wall forms as well as for column forms.
About the forms the labor unit cost for columns is substantially higher than the unit cost for elevated slab, same goes for walls. Also the quantities of each are different even if the unit of measure is the same [in case of forms we use contact area].
But for cost control we also have to look for accountability, if you mix costs whose responsibility is spread under different supervisors the system will not help. We usually have different crews and supervisors for installation of walls, columns and elevated slabs. So when we design our coding system we consider in which way the breakdown will be of value not only for estimating but equally important, for field management.
For some equipment at times it is different, a crane might be used for walls as well as columns but distributing operator and equipment might be difficult. In such case it is more practical to keep the equipment under a single separate cost code.
Do not overlook the idea about the cost types usually subdivided in labor, equipment, materials, subcontracts, other. By keeping them separate it is easier to interpret actual unit costs. Maybe you already bought 90% of the form wood but only have installed 20% of it.
For subcontracts we allocate units for each unit price item if a unit price subcontract, for others such as Air Conditioning we use quantity 1 unit LS but in the description use some measure such as Tons or BTU.
Most job costing software provides for a percentage allocation of labor burden, learn about it. If you are loosing money on installation it is not only on direct labor cost but also on labor burden where you are also loosing money. If you apply labor burden individually the variance will make sense if you apply it to a single account it will not tell you about the distribution.
Our labor burden usually includes the employer contribution to Social Security and Medicare, vacations, sick-leave, workmen compensation insurance, medical insurance, union fees and any other contribution by the employer directly related to labor costs. Some keep workmen compensation under separate code as it might be substantially different for different job risks.
Hi Mr Rafael,
For classification of cost accounts, I think the common sense here is the UNIFORMITY of production rate of each cost account. For your example, why should you separate Form works into Form Wall, Form Column, Form Elevated Slab? does it depend on the differences of production rates between Form Wall, Form Column, and Form Elevated Slab?
Our estimator guy has a list of cost items but it similars to PBS (product breakdown structure) regardless the continualness of time, and space...I also think in some cases it must be decomposed more...because the production rates dependes on some factors:
+ type of material
+ working space: limitation of space, high level, underground, onshore vs offshore, open yard vs. inhouse,...
Therefore if one of the factors impacts clearly to the uniformity of production rate of the cost account, it should be decomposed, if not...stop and make it as simple as possible
An ISO Standard shall be available soon.
http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=63708
Meanwhile I suggest using the brakdown used by your estimators, summarized to a reasonable level. Then check on those cost components that for practical reasons shall be grouped on a single cost account. For example we keep track of form materials using a single cost account but for inatallation we use specific cost accounts such as installation of Column Forms, installation of Wall Forms ... Some use similar approach for Concrete materials and even keep a songle account for concrete pouring. There are no rules but common sense and experience.
No matter if creating your own cost accounts or if using a standard as a reference I suggest to keep it within practical limist, too much detail can be as bad as too little. Therefore you shall adjust the chart of account to fit your needs.
If you create a draft of your accounts maybe we can make our suggestions, as long as you do not disclose costs it will not be confidential data in any way.
Suggest the following Structure:
Discuss the cost accounts with the estimators but always keep the details under control. And once again, do not overdo it, some industry standards are too detailed for use in cost control systems, perhaps good to organize cost references, drawings and specifications. I would target for something between 50 to 100 cost accounts to cover all my jobs and coding easy to remember. Perhap 3 first digits for Job ID, then 3 digits for the code and suffix letters for the type [L/E/M/S/O].
We use the CSI coding that is geared for specifications not for cost. Still our cost books such as RS Means do follow CSI organization in some way, they go into very detailed codes but we never use such codes, too detailed for practical use in job costing.
Mr Rafael, thank you for your supports
You leaded me into the term "Chart of accounts"...but it seems to be difficult to find a standard of it in petroleum project (offshore platforms).
I can only find some materials below:
1. "NORSOK STANDARD Z-014" for PBS (Physical Breakdown Structure), SAB (standard activity breakdown) for petroleum.
2. "PMI - Practice Standard for Work Breakdown Structures" - having a sample WBS for production platform.
IMHO, both of them do not fit to build a Chart of account.
So, do you have any rule for clustering of cost accounts to build CoA?
FIGURE 04
FIGURE 03
FIGURE 02
FIGURE 01
The following references can provide an introduction to our discussion.
http://www.foundationsoft.com/resources/articles/77-unit-cost-and-production-reporting.htm
http://www.nflaace.org/index_files/john_orr_cost_loaded_schedule_updating_pdf.pdf
As we discuss how the selection af your cost codes is critical to the success of the system we will discuss why cost codes shall not be forced to match the breakdown for Billings nor the Activities and/or WBS Breakdown of your CPM.
For a start you shall track separately labor from materials and equipment costs but you do not bill separately labor and material but use a single number that includes costs and markup. You shall keep a uniform cost coding system on all jobs but the work breakdown of individual jobs might require different WBS structures, or different clients might require their preferred structure.