Project Material Cost

On a material-intensive project the cost exists in three states at the same time: budgeted, ordered but not invoiced, and invoiced. Looking at only one of them gives an answer that is always either too optimistic or too late.

Who is it for

Companies whose project cost is driven mainly by materials, equipment and internal production.

How it works

Each activity is budgeted for raw material and for equipment.
The actual cost is built from the invoices received and from the material delivered to the site.
What is committed on confirmed orders but not invoiced yet is shown as a separate figure.
Internal production is split between what has been completed and what is still to be made.
The project adds its own charges: an overhead percentage on the contract value and other costs.
The remaining cost to finish is shown per activity and totalled on the project.

The result: The whole material picture at once: budgeted, committed, invoiced and still to spend.

More Information

Per maggiori info sui nostri moduli non esitare a contattarci

Project Material Cost

Raw material, equipment and production cost of tasks and projects

Adds the material side of the project cost: raw material, equipment and subcontracted material, each budgeted, each tracked from the purchase and the inventory documents, plus the cost of the manufacturing orders of the task.

Features

Budget per task: Estimated Raw Material Costs and Cost of Equipment.
Actual cost per sector, from the invoiced journal items plus the stock moves of the task that are neither purchased nor invoiced (valued at standard price).
Cost still to be invoiced per sector, computed on the remaining quantity of the confirmed purchase order lines with the v19 tax engine.
Production cost of the task split between Done and To Do, from the BoM cost, the product cost and the actual production cost of its manufacturing orders.
Project level charges: General Cost Percentage applied on the project value, and Other Charges.
Remaining costs: Costs To Finish, and its raw material and subcontractor breakdown.

Main fields

Model	Field	Type	Description
project.task	estimated_raw_material_costs / cost_of_equipment	Monetary	Material and equipment budget of the task
project.task	actual_raw_material_cost / actual_cost_of_equipment / actual_raw_material_contractor_cost	Float	Actual cost per sector
project.task	actual_*_no_invoiced	Float	Cost still to invoice per sector
project.task	bom_cost_done / product_cost_done / total_production_cost_done	Float	Production cost of the done manufacturing orders
project.task	bom_cost_to_do / product_cost_to_do / total_production_cost_to_do	Float	Production cost of the open manufacturing orders
project.task	costs_to_finish / costs_to_finish_raw_material / costs_to_finish_subcontractor	Float	Remaining costs to complete the task
project.project	precent_project_general_cost / project_general_cost / project_other_charges	—	Project level charges
project.project	project_*	—	Every task figure rolled up on the project

Demo data

118 000.00 of raw material and 13 000.00 of equipment budgeted across the four tasks of the site.
A general cost of 8 % on the 390 000.00 project value (31 200.00) plus 15 000.00 of other charges.
A reinforcement steel bill of 6 400.00 already charged to the structural task, next to the concrete (1 416.00) and the scaffolding (4 800.00) ordered but still to be invoiced.
The custom furniture task produced in house: 8 cabinet modules, i.e. 840.00 of BoM cost and 1 440.00 of product cost to do.

Changelog

Version	Notes
19.0.1.0.0	Migration to Odoo 19.0: unit tests, demo data, Italian translation and documentation.

Developed by STeSI Consulting — Francesco Moccia <moccia.f@stesi.consulting>