Skip to content
Website
Sign in Sign up
Template and resource

Downloadable Template: D-1 Loading Preparation Sheet (PDF)

Download the Excel supplier run log and D-1 loading sheet. Eliminate supply shortages and unplanned merchant trips on Swiss construction sites.

Table of contents
The 3 Major Site Risks
  1. Financial / Margin: Direct productivity losses caused by unplanned runs to the wholesaler, representing an illustrative extra cost in the range of 350,00 CHF to 900,00 CHF per incident (unproductive hours and tied-up vehicle), eroding gross margin under the Code of Obligations.
  2. Legal / Joint Commission / SUVA: Unplanned overtime and disrupted rest periods, exposing the company to joint commission audits and the requirements of the Labour Act.
  3. Administrative / Acceptance: Cumulative delays on the contractual work schedule, leading to delay penalties or the postponement of joint verification under standard SIA 118.

This operational Excel workbook structures the tracking of supply shortages and the systematic monitoring of unplanned trips to merchant trade counters. Designed for business owners, site managers, and foremen in Romandy, this tool quantifies the actual cost price of each urgent run: round-trip travel time, labour tied up at the company's hourly charge-out rate, van mileage costs, and waiting time generated on the workface.

Using this matrix daily starting at D-1 preparation eliminates forgotten tooling, locks down the material list by CFC chapter, and prevents work disruptions across workstations. By systematically logging the root causes of shortages in the dedicated register, site management identifies recurring logistics gaps, stabilises execution profitability, and secures compliance with deadlines agreed upon with the site management.

Document download — XLSX (14 ko)

Supplier Run Log and Hidden Costs

Receive the document

Receive this document by email

Enter your address: the document is sent to you immediately. The link remains valid for 7 days. Your data is not shared with third parties.

Architecture and operational deployment of the Excel workbook

The Excel workbook "Supplier Run Log and Hidden Costs" is structured into four interdependent sheets designed to isolate logistics drift without adding administrative burden. The foreman logs the raw facts on site during each incident, while the site manager consolidates the data weekly for executive review.

  • "Read Me" sheet: summary of the operating protocol, field definitions, entry rules, and reminder of responsibilities between central logistics and site management.
  • "Parameters" sheet: configuration of the company's average hourly rates by staff category, commercial vehicle mileage costs according to the internal scale, and recurring trip motives (shortage of consumables, broken tooling, ordering error, execution modification).
  • "Log" sheet: chronological register for logging unplanned runs. The user enters the date, the construction site concerned, the employee mobilised, departure time, return time, mileage covered, the supplier visited, a brief description of the missing material, and the number of workers left waiting on the structure. The workbook automatically calculates the total absence time, direct labour cost, vehicle expenditure, and downtime cost of stalled workstations.
  • "Summary" sheet: dynamic dashboard aggregating losses by construction site, by root cause, and by month. It highlights the overall volume of lost hours and the cumulative amount in CHF, enabling SME owners to measure the financial impact on their overheads and adjust tooling allocations.

Logistics management comparison table

Eliminating unplanned runs relies on precise item descriptions and full material traceability starting right from loading at the workshop.

Risky wording / frequent mistake Compliant formulation or practice Why
"Grab some standard screws for the day" "Standard allocation of 500 wood screws 5x80 mm and 200 nylon wall plugs 8 mm as per schedule" Prevents mid-morning emergency trips to the hardware store for a specific missing size.
"Pick up fittings if needed during installation" "D-1 onboard inventory check with duplicate emergency kit as per packing slip" Prevents complete shutdown of the installation crew while a worker navigates dense urban traffic.
"Log the travel time as regular site hours" "Book under a dedicated cost code for unplanned logistics runs" Isolates the loss of productivity without distorting the productive labour tracking of the quote.
"Let the worker pick whichever trade counter is closest" "Procure via framework-contract wholesaler with scheduled express pick-up" Prevents prolonged trade counter waiting times and secures pre-negotiated discount rates.
"Buy another rotary hammer drill without checking workshop inventory" "Nominal assignment of power tools inspected the evening before departure" Eliminates duplicate purchases of secondary tools that unnecessarily strain operating cash flow.
"Wait until Friday to report recurring shortages" "Daily log sign-off with immediate notification sent to the site manager" Allows supply adjustments for the following day before vans head out at dawn.

Critical errors prevented by the tracking matrix

Without an objective tracking tool, logistics slippage remains invisible in the company's cost accounting. This workbook locks down three major operational failures:

First, the uncontrolled dispersion of skilled tradesmen. When a foreman leaves the installation front to buy a forgotten sleeve, the output of two or three installers plummets. The illustrative scale of this disruption typically represents an extra cost of around 420,00 CHF to 850,00 CHF per incident, wiping out the entire profit planned for that trade package.

Second, repeated trade counter purchases without price checks. Emergency procurement often occurs at list price without trade discounts, generating an extra material cost of around 150,00 CHF to 300,00 CHF per visit that escapes standard management control.

Third, delivery schedule slippage. Accumulated trips delay progress on critical path tasks. Under art. 97 CO, the debtor is liable to make good the damage arising from non-performance or defective performance of an obligation, exposing the contractor to contractual disputes from the client.

Illustrative practical cases (typical scenarios on Swiss construction sites)

The figures presented in the scenarios below are illustrative examples intended to model the use of the file.

Scenario A: Renovation of an apartment building in Lausanne (Canton of Vaud)

A Plumbing & Sanitary Installations firm deploys 4 fitters on a refurbishment construction site. On day 3, a shortage of specific pipe clamps and waste elbows triggers 2 unplanned runs to the Renens industrial zone. Entered into the "Log" sheet, the total loss reaches 3 hours and 45 minutes of cumulative travel time for one worker, 18 kilometres driven in the van, and 2 hours of partial waiting time for the assistant fitter. The "Summary" sheet reveals an overall hidden cost of around 585,00 CHF. Following the site manager's review, a standardised modular kit locked down at D-1 was established for each floor.

Scenario B: Construction of an administrative building in Meyrin (Canton of Geneva)

A Steel Construction SME deploys a crew of 6 erectors. Due to a lack of check-off the previous evening, the crew discovers on site that they lack chemical anchors suited to the concrete substrate. A run to the specialist trade counter ties up the foreman for 2 hours in urban traffic congestion, leaving 3 workers unable to grout the baseplates. The log quantifies the expense at an illustrative amount of around 760,00 CHF. The company systematised the use of the "Parameters" sheet to block any workshop departure without prior validation of the full loading list.

Frequently asked questions

Who fills out the supplier run log in a Romand SME?

The foreman or driver records the unplanned trip immediately upon returning to the yard. Under art. 3 OTConst, works must be planned to minimise occupational hazards; logging these detours makes field supervision directly accountable.

How should an unplanned trade counter trip be allocated in site job costing?

Each trip mobilises a utility vehicle and an installer. This average indirect cost, illustratively estimated between 95.00 CHF and 160.00 CHF per hour, is charged to internal logistics overheads under the Code of Obligations (CO).

Can inventory shortages be recharged to the client?

No. Shortages of tools or fixings fall strictly under the contractor's internal operational duties. Pricing contractual variations is handled via /soumissions/, while formal reservation management under standard SIA 118 is managed via /portail/.

How should travel hours be handled with regard to payroll?

Time spent driving to a wholesaler constitutes effective working time. Wage scales and collective allowances can be reviewed on /jobs/, in accordance with the requirements of the Labour Act and applicable collective labour agreements.

Where should supplier site access plans be filed to avoid traffic bottlenecks?

Site traffic layouts and unloading zones are drawn according to standard SIA 400 on /plans/. D-1 logistics collates these access routes to prevent hazardous manoeuvres in accordance with the Construction Works Ordinance.

Mastering logistics at D-1 protects the profitability of construction SMEs against recurring lost hours. To build lasting structure into your site processes and eliminate waste across your operations in Romandy, leverage the following resources:

Art Construction is an independent company: it is not affiliated with the SIA, CRB, SUVA, or KBOB. Referenced norms and standards point to publications from these bodies; only official versions are legally binding.