IIIOrganization & Project ManagementGuide

Scheduling Jobs: From Quote to Date Without Double Booking

A customer accepts, and suddenly two job sites are on the same day. Double bookings rarely come from carelessness. They happen because open quotes do not appear in the schedule and dates are given out in several places.

Old masonry kiln
Photo: Gary Todd / Wikimedia Commons

Key takeaways

  • A double booking occurs when the same capacity is promised twice. The cause usually lies in several people assigning dates and open quotes being invisible in the schedule.
  • The workload control thinking model distinguishes three levels of workload: the work in progress, all confirmed orders, and the total load including open quotes, weighted by the probability that they will be accepted.
  • In a simulation by Thürer, Stevenson, Silva, and Land (2013), out of eleven rules, the one that explicitly included the load of open quotes produced the best delivery dates.
  • In practice this means: pencil in quotes at hours times win rate, name a time window rather than a date in the quote, and assign fixed dates in one place only and by one person.

Why do double bookings happen even though everyone is careful?

In many trade and service businesses, scheduling runs through several channels at once. The owner promises the week after Easter on the phone, the office assistant enters a maintenance visit, the foreman promises on site to come back next week. Each promise is reasonable on its own. Together they produce two crews for the same day.

There is also a second, quieter problem. Weeks often pass between quote and order. During this time the quote is not visible in the schedule, even though it will claim capacity if the customer accepts. If three acceptances arrive in the same week, the schedule is full before anyone has noticed. This leads to the guiding question of this guide: how does a small business schedule jobs from the quote to the fixed date so that no capacity is promised twice and commitments hold?

To answer it, we first clarify the terms, present a thinking model from production planning, review the studies, weigh two perspectives, and finally describe a six-step procedure.

Whoever leaves open quotes out of the schedule plans with a calendar that keeps quiet about the future.

Terms: pencil-in, fixed date, double booking

A double booking exists when the same capacity, meaning the same person, crew, or machine, is promised twice for the same period. A fixed date is a period bindingly assigned to a commissioned job. A pencil-in is a provisional entry for an open quote. It does not reserve a specific hour but shows how much load to expect in a period.

What also matters for scheduling is the plannable time. As the guide on capacity planning describes, only the time left after absences, fixed appointments, and day-to-day business is plannable. In many teams this is less than half of working time. Finally, the win rate is the share of accepted quotes among all decided quotes. Open quotes do not belong in this calculation, as the guide on quotes that win points out.

Three types of entries in the booking schedule
EntryMeaningWho may set itWhat it does in the schedule
Pencil-inopen quote, not yet commissionedwhoever writes the quoteshows expected load per week, weighted
Fixed datecommissioned job with a periodonly the person who runs the scheduleoccupies hours bindingly
Buffertime deliberately kept freeset during planningabsorbs rework, urgent jobs, and delays

The thinking model: three levels of workload according to workload control

For businesses that execute each job individually to customer specifications, production research has developed a planning concept called workload control. It is regarded as one of the few concepts that suit make-to-order firms with changing jobs, and therefore many small and medium-sized businesses (Thürer, Stevenson, Silva, and Land 2013). At its core is a distinction between three levels of workload that links sales and execution.

The three levels of workload, applied to a small business
LevelWhat it includesIn a trade businessControlled through
Work in progressjobs currently being executedthis week's sites and assignmentsrelease: when a job starts
Planned workwork in progress plus all confirmed jobs not yet startedall fixed dates in the booking scheduledate assignment on order
Total workplanned work plus a share of open quotesfixed dates and weighted pencil-instime window in the quote

The decisive idea lies in the third row. In this research, open quotes are called contingent orders, because their effect on capacity depends on whether the customer accepts. They are neither scheduled at full load nor ignored, but with a share that corresponds to the company's own win rate. A quote for 40 hours at a rate of 50 percent therefore appears in the schedule with 20 hours. If the customer accepts, it becomes 40 hours; if they decline, the pencil-in disappears.

An analogy from the hotel business makes this tangible. A hotel that holds rooms for groups on option does not resell them, but it does not keep every one free as if it were certainly occupied either. It calculates with experience.

What studies show about delivery promises and open quotes

Thürer, Stevenson, Silva, and Land (2013) used a simulation to study how businesses should set delivery dates when part of their load consists of open quotes. They simulated a job shop with six work centers at a utilization of 90 percent. They varied the win rate between 20 and 100 percent and the time customers need to decide. They compared eleven rules, from simple rules of thumb that look only at a job's processing time to procedures that offset the load period by period against the available capacity.

The best performer was a rule that schedules jobs period by period into free capacity and explicitly takes into account the load of open quotes at their weighted share. It allowed demand to be smoothed over time, so that dates could be both short and reliable. Rules that looked only at the job itself did worse. The authors stress that the inquiry stage had hardly been studied until then.

In a follow-up study, Thürer, Stevenson, Silva, Land, Fredendall, and Melnyk (2014) linked the date promised in the quote with the release of jobs. In their simulation, this reduced the share of late jobs, and the workload became smaller and more even. How hard implementation is was shown by Stevenson, Huang, Hendry, and Soepenberg (2011). They interviewed key staff at 41 make-to-order firms: the operations of small and medium-sized businesses differ so much that the concept usually has to be adapted.

Why utilization matters so much is shown in the article on capacity planning. There, the waiting time of a new task rises to four times its processing time at 80 percent utilization and to nine times at 90 percent. A schedule filled to the last hour cannot absorb an urgent job or a delay. Every disruption then pushes back all subsequent dates.

Date in the quote or only with the order? Two perspectives

There are two readings of the right moment to commit to a date. The first says: the date belongs in the quote. Customers compare not only prices but also delivery times, and a quote without a date seems noncommittal. Whoever names a concrete date early is more likely to win. This is supported by the fact that delivery time is a purchasing argument in its own right for many business customers.

The second says: the date comes only with the order. As long as the customer has not signed, the business cannot block a period without making other customers wait. Whoever names a fixed date in every quote ends up with three dates for two crews when three acceptances come in at once. This is supported by many businesses' experience with double bookings.

Fixed date in the quote and time window with pencil-in compared

Fixed date in the quote

  • seems binding and fast
  • blocks capacity without an order or gets promised twice
  • leads to conflicts when acceptances coincide
  • commitments are moved afterwards

Time window with pencil-in

  • names a realistic period, such as two calendar weeks
  • includes open quotes at their weighted share
  • the fixed day is confirmed within one working day of the order
  • commitments are based on the total expected load

I consider a combination of both perspectives sound, and the thinking model shows what it looks like. The quote names a time window derived from the total load, meaning fixed dates and weighted pencil-ins. The fixed day follows with the order confirmation. The customer gets a reliable statement, and the business never promises an hour twice. How the confirmation should be structured is described in the guide on the order confirmation.

From quote to date in six steps

  1. One booking schedule, one person in charge

    All dates are in one single place, whether a planning board or a program. Only one named person, with a deputy, enters fixed dates. Everyone else requests and does not enter themselves.

  2. Set plannable hours per week

    For each crew, the hours after deducting vacation, maintenance, travel, and base load. Only this figure is scheduled, not the contractual working time.

  3. Pencil in quotes at their weighted share

    Every quote sent goes into the weeks in which it would be executed, at estimated hours times your own win rate. The rate comes from your own figures, not from gut feeling.

  4. Derive the time window from the total load

    The quote names the first week in which fixed dates, pencil-ins, and this job together do not exceed the booking limit, plus a two-week window.

  5. Assign the fixed date on order

    Within one working day of the acceptance, the person in charge sets the fixed date, deletes the pencil-in, and confirms the day to the customer in writing.

  6. Reconcile weekly

    Once a week, declined and stale quotes are removed from the pencil-ins, moved dates are updated, and the bookings for the next six weeks are checked.

A worked example shows what this looks like. A plumbing business with two installation crews has a combined 120 plannable hours per week. Its own win rate over the last twelve months is 40 percent. The owner sets the booking limit at 85 percent of plannable hours, or 102 hours. The rest is a buffer for rework and urgent jobs. All figures are a worked example.

Pencil-ins for open quotes in one calendar week in the example business
QuoteEstimated hoursWin ratePencil-in
Bathroom renovation A6040%24 hours
Heating replacement B3040%12 hours
Pipework C2040%8 hours
Total pencil-ins110·44 hours
Fixed dates in this week··70 hours
Total expected load··114 hours

Worked example

Expected booking of plannable hours over the next five weeks, fixed dates and weighted pencil-ins combined
  • Week 198%
  • Week 295%
  • Week 381%
  • Week 462%
  • Week 540%

Worked example with freely chosen values. Week 3 is the first week below the booking limit of 85 percent. A new quote therefore names the window week 3 to 4, not next week.

At 114 hours, the week in the table is above the limit of 102 hours. Without pencil-ins, the schedule would have shown only 70 occupied hours, apparently plenty of room. It is exactly this difference that produces double bookings in everyday work.

  • There is exactly one place where fixed dates are kept.
  • Fixed dates are assigned by a named person with a deputy.
  • Every open quote is in the schedule, weighted with your own win rate.
  • Quotes name a time window, not a fixed date.
  • Every fixed date carries a job number and crew.
  • At least 15 percent of plannable hours remain free as a buffer.

What carries over and what does not

The method shifts a question that used to be decided on the phone into a fixed procedure. That has a price: whoever names a window instead of a date may lose a job to a competitor who commits faster. A broken promise, however, usually costs more trust. How on-time delivery can be measured is described in the guide on measuring and improving on-time delivery.

A second limit lies in the win rate. It is an average, often higher with regular customers and lower with first inquiries. Whoever has enough data can work with probabilities per stage, as described in the guide on pipeline management. To start with, one rate from your own figures is enough.

And finally: if the booking limit is exceeded permanently, no planning rule helps anymore. Demand is then greater than capacity, and the question becomes prices, lead times, or more capacity, as the guide on steering demand instead of just serving it shows.

Conclusion: how does a business schedule without double booking?

The question at the start was  a small business schedules jobs from the quote to the fixed date so that no capacity is promised twice and commitments hold. The answer has two parts. First, the schedule needs a single place and a single person who assigns fixed dates. Double bookings arise where several people make promises independently of each other.

Second, open quotes must be visible in the schedule, weighted with your own win rate. This is the core message of the three-level thinking model, and it is supported by the simulations: delivery promises that take into account the expected load of open quotes are shorter and more reliable at the same time. Whoever puts this into practice commits to the customer a little later, but correctly. A date that holds is worth more than one that sounds early.

First steps for this week

  1. Decide on the single place where fixed dates will be kept from now on, and name the person who assigns them.
  2. Calculate the plannable hours of a normal week for each crew.
  3. Determine your win rate over the last twelve months: accepted divided by decided quotes.
  4. Enter all open quotes at hours times rate into the next six weeks.
  5. Set a booking limit and write one sentence you will use from now on to name time windows instead of dates.

Frequently asked questions

How do I avoid double bookings in a trade business?

Keep all dates in a single place and have fixed dates assigned only by one named person with a deputy. Also enter open quotes at their weighted share so that the schedule shows how much load may still come. Most double bookings arise when several people make commitments independently.

Should I name a fixed date in the quote?

A time window of about two weeks, derived from fixed dates and weighted pencil-ins, is better. You confirm the exact day with the order confirmation. This keeps the statement reliable without blocking capacity nobody has commissioned yet.

How do I include open quotes in capacity planning?

Multiply the estimated hours of each quote by your win rate and enter the result in the weeks in which the job would be executed. A quote for 40 hours at a 50 percent rate thus appears with 20 hours. On acceptance it becomes the full value; on rejection the entry is deleted.

How full may the booking schedule be?

Do not plan to the last hour. Even at 80 percent utilization, the waiting time of new tasks rises sharply, and every disruption pushes back all subsequent dates. A limit of about 85 percent of plannable hours leaves room for rework and urgent jobs.

Sources

  1. Thürer, M.; Stevenson, M.; Silva, C.; Land, M. (2013): Towards an Integrated Workload Control (WLC) Concept: The Performance of Due Date Setting Rules in Job Shops with Contingent Orders. International Journal of Production Research, 51(15), 4502-4516.
  2. Thürer, M.; Stevenson, M.; Silva, C.; Land, M. J.; Fredendall, L. D.; Melnyk, S. A. (2014): Lean Control for Make-to-Order Companies: Integrating Customer Enquiry Management and Order Release. Production and Operations Management, 23(3), 463-476.
  3. Stevenson, M.; Huang, Y.; Hendry, L. C.; Soepenberg, E. (2011): The theory and practice of workload control: A research agenda and implementation strategy. International Journal of Production Economics, 131, 689-700.

All sources in the knowledge base

Reading room of a historic library with galleries, walls of books, and a skylight

Found a mistake or a topic that’s missing?

Feedback, corrections, and topic ideas go straight to the editorial team. We correct openly and with a date.