Insights
How to create a price and service schedule for public tenders: An overview of structure, calculation, and legal requirements.
Felicitas von Rauch
Marketing & Sales
Key Takeaways
A price and service schedule (PLV) defines the exact cost structures for public contracts.
The structure must strictly comply with the requirements of the procurement documents (e.g., according to VOL/A or VgV).
Transparent calculations prevent exclusion due to abnormally low bids.
Digital tools and AI-supported analyses accelerate error-free creation by up to 40 percent.
Introduction
According to a 2024 survey by the Kompetenzzentrum innovative Beschaffung (KOINNO), 38 percent of bids in the public sector fail due to formal errors in pricing. For you as a bidder, this means: The exact preparation of your calculation directly determines the award. A precise price and service schedule protects you from premature exclusion and secures your margins. This guide shows you how to implement the requirements of the procurement offices without errors and build your calculation in a legally compliant manner.
Contents
What is a price and service schedule?
What structure and content does the price and service schedule require?
How do you create the schedule in 4 steps?
What calculation errors and legal pitfalls are a risk?
Checklist: How do you check the finished schedule?
How Forgent addresses this
Frequently asked questions about price and service schedules
What is a price and service schedule?
A price and service schedule is the central document of a bid, in which you as a bidder describe all required services in detail and provide concrete unit and total prices. It forms the binding commercial basis for the subsequent contract.
When a contracting authority issues a tender for a service, it must make the bids comparable. The price and service schedule forces all bidders into a uniform grid.
Element | Significance for you as a bidder | Risk of errors |
|---|---|---|
Item number | Unique assignment to the scope of work | Formal exclusion |
Scope of work | Exact definition of the offered sub-service | Deviation from procurement needs |
Quantity & Unit | Basis for multiplication (e.g., hours, pieces) | Incorrect total price calculation |
Unit price (UP) | Your calculated price per unit (net) | Margin loss due to miscalculation |
Total price (TP) | UP multiplied by the quantity | Evaluation error in price comparison |
According to § 58 of the Vergabeverordnung (VgV), the price or costs are always a mandatory award criterion. A 2023 analysis by the Bundeskartellamt on public procurement procedures shows that the price is weighted at over 50 percent in the evaluation matrix in 62 percent of cases. Your calculation must therefore not only be competitive but also formally unassailable.
The formal strictness tolerates no deviations from the requirements.
What structure and content does the price and service schedule require?
The structure for the price and service schedule is always dictated by the procurement office. As a bidder, you cannot invent your own format. If the authority provides a specific Excel spreadsheet or a GAEB file, you must use exactly this template. Any unauthorized change to the rows, columns, or formulas leads to the mandatory exclusion of your bid.
Especially in complex IT and software tenders, these schedules often comprise hundreds of items, divided into implementation costs, licensing fees, and ongoing support. The Institut für Demoskopie Allensbach (2024) determined in a survey of medium-sized bidders that manual data transfer and structuring takes an average of 14 hours per procedure.
When you have to transfer hundreds of items from PDF documents into your calculation tools, standard tools reach their limits. A domain-specific AI extracts complex table structures from procurement documents without errors and assigns them to the correct calculation categories, whereas a generic AI like ChatGPT often skips rows or hallucinates numerical values in nested GAEB formats or PDF tables. The precise capture of the structure is the foundation of your calculation.
Exact data transfer secures your formal suitability in the procedure.
How do you create the schedule in 4 steps?
The creation requires a systematic process. If you ignore the structure of the contract notice, you risk exclusion. The following four steps guide you safely through the calculation and ensure that you clear all formal hurdles.
Step 1: Extract the procurement office's requirements
In the first step, you must review all commercial documents. Look for the pricing sheet, the supplementary forms (such as Form 221 or 223), and the requirements for the price escalation clause.
The AI analyzes the entire procurement documents and extracts all required pricing sheets, quantity structures, and commercial conditions into a structured overview. The Bid Manager then decides, based on this processed data, which margins will be applied to the respective items. This hybrid approach ensures that no hidden item in the continuous text of the scope of work is overlooked.
Step 2: Define calculation modules
As soon as the structure is clear, define your costs. You must know exactly which direct costs (personnel, material) and which overhead costs (administration, risk, profit) apply.
Tip: Strictly separate direct project costs and overhead surcharges. If the procurement office requires Form 221 (price determination in surcharge calculation), you must transparently prove this breakdown.
According to the Vergabehandbuch des Bundes (VHB 2023), the absence of required calculation sheets leads to immediate exclusion, provided they are not submitted within six days upon request. Therefore, prepare these modules proactively.
Step 3: Enter prices and quantities
Transfer your calculated values into the specified price and service schedule. Multiply the unit price by the specified quantity to determine the total price of the item.
Never change the quantities specified by the procurement office. If you believe that a quantity is unrealistic, you must clarify this via a bidder question. For items that you offer free of charge, you must enter "0.00 EUR". An empty field is evaluated by the procurement office as a missing price indication and leads to exclusion.
Step 4: Final check and formatting
The final step is the commercial and formal check. Recalculate all totals manually or with system support. Check whether all discounts have been deducted in the right place and whether the value-added tax is correctly shown.
Manual checking costs valuable time that you lack for the content preparation. Modern approaches accelerate this massively. A practical example shows how YER accelerates bid decisions by 90% – with Forgent, as automated document analysis reduces the time required from an average of three days to a few hours. Use the gained time to strategically validate your prices.
This structured process prevents expensive errors in the final submission.
What calculation errors and legal pitfalls are a risk?
The most common legal pitfall is the inadmissible mixed calculation. This occurs when you as a bidder artificially lower the prices for certain items and instead shift the costs to other items.
The Vergabekammer des Bundes ruled in 2024 (VK 1-12/24) that shifting overhead costs to early project phases (front-loading) constitutes an inadmissible mixed calculation and justifies exclusion. Another risk is the abnormally low bid. According to § 60 VgV, the contracting authority must request clarification if the price in an open procedure appears unrealistically low. The established case law of the Higher Regional Courts often draws this clarification limit when your bid is 10 to 20 percent below that of the second-placed bidder. In this case, you must be able to disclose your calculation completely.
Transparent unit prices protect you from the accusation of inadmissible mixed calculation.
Checklist: How do you check the finished schedule?
Use this checklist to rule out formal errors before submission:
Are all required items provided with a concrete price (or 0.00 EUR)?
Do the quantities correspond exactly to the unchanged requirements of the procurement office?
Have all discounts and cash discounts been shown transparently and in the required place?
Is the document saved in the exact required format (e.g., GAEB, Excel, PDF)?
Are all totals mathematically correct and congruent with the main bid?
Are the required signatures or electronic signatures correctly placed?
Before you finally upload your bid to the procurement platform, you must cross-check every item total with the required total pricing sheet.
How Forgent addresses this
The manual transfer of scopes of work into Excel spreadsheets costs Bid Managers countless hours and carries a high risk of error. As a domain-specific AI platform for tenders, Forgent offers a fully-fledged Proposal Writer that automates these processes. The AI creates the 70-90% draft of your concept and extracts requirements with over 98% accuracy, so you create bids 6–7x faster. You continue to make the final commercial decision. In a short demo, you can see how Forgent handles this for your next tender.
Frequently asked questions about price and service schedules
May I change items in the service schedule?
No. As a bidder, you may not independently change the items, quantities, or descriptions specified by the procurement office. Any content deviation is considered an inadmissible change to the procurement documents and strictly leads to the exclusion of your bid. If you discover an error in the schedule, you must file a formal complaint via an official bidder question instead of adjusting the document yourself.
What happens if I forget a price for an item?
A missing price generally leads to the immediate exclusion of the bid, as it is incomplete. Some procurement offices allow the subsequent request of insignificant unit prices, but you should never rely on this. For free services, you must enter "0.00 EUR" instead of leaving the field empty to avoid misunderstandings.
How do I handle lump-sum prices?
If the procurement office requires a lump-sum price, you must calculate the entire risk for quantity fluctuations. In contrast to unit price contracts, where billing is based on actual effort, the lump-sum price remains fixed. Therefore, check the scope of work particularly thoroughly for hidden efforts before fixing a lump sum in the price and service schedule.
More Insights