Straight into the service manual page
WrenchQuarry
More

Quarterly materials budget for parts: 3 inputs

WrenchQuarry Editorial Team · Published · 12 min read · How these guides are written

A quarterly materials budget for parts uses planned work, material for each job, and desired ending stock to calculate purchases and cost. It answers three questions: how many of each part the quarter will use, how many should remain on the shelf at quarter end, and what the purchase will cost.

If you run a small field-service firm, you probably know the situation. The calendar fills before the quarter starts, the van shelves run thin, and someone asks you to order "a bunch of the usual parts" before the busy weeks begin. A bunch is not a number. Order too little and a technician drives to a supply house in the middle of a job. Order too much and cash sits on a shelf, or in a back room, waiting for a slow season that may not come.

The fix is not a complicated spreadsheet. It is a short calculation finished before anyone places an order. The three inputs are:

  1. The work you expect. How many jobs, or units of service, you will perform in the quarter.
  2. The material each job uses. How much of each part a single job consumes.
  3. The stock you want on hand. How much you want left at the end of the quarter, so the next quarter can start without a gap.

Once you have those three, you can work out how many parts to buy and what they will cost. This post walks through each input, shows how they fit together, and closes with a routine you can repeat before the next purchase.

The method comes from managerial accounting, the part of finance that plans what a business will spend and make. The OpenStax chapter on preparing operating budgets builds a direct materials budget from the same three ideas: production, material for each unit, and ending inventory. A maker of bicycle trainers is not a field-service firm, but the arithmetic carries over. You turn planned work into planned material, and then into planned money.

Why a quarter, and not a month

Quarters are a useful planning unit because a busy season rarely lasts exactly one month. Parts ordered for a single week run out too fast. Parts ordered for a full year tie up cash and go stale. A quarter gives you enough time to see demand build and enough room to adjust.

Quarters also tend to line up with the rhythms of the business: billing cycles, supplier terms, and the point where you review how the last period went. The same chapter plans materials one quarter at a time while also looking at the quarter that follows. That detail matters, and it comes back in the section on stock on hand.

Input 1: the work you expect

Every parts budget begins with a count of what you plan to produce or perform. For a field-service firm, that might be service calls, installations, repairs, or scheduled maintenance visits. Use the unit your dispatch board already tracks, and use the same unit for the whole calculation.

Pull the number from history first. Look at the last similar quarter, or the same quarter last year if you have it. Note what was booked, what was finished, and what was cancelled. Then adjust for what you know about the coming quarter. A new contract, a seasonal rush, or a technician who is leaving all change the count. Write the adjusted number down as a single figure. A range helps you think, but the budget needs one number to multiply.

Be honest about the gap between work booked and work completed. A booked job that is not yet done still needs parts. A job that cancels at the last minute may leave parts sitting unused. Decide which measure you are budgeting against and stick to it. Planning against booked work, then trimming for known cancellations, is one workable choice. Use consistent work order statuses when checking those counts.

The textbook example starts the same way. It fixes the number of units to be produced in a quarter. In that example, the first quarter of the next year is set at 3,800 units. Your figure will differ. The step is the same: fix the planned count before you touch the parts list.

Input 2: the material each job uses

The second input turns work into parts. For each unit of work, you need to know how much of each part it consumes. Its example is a product that uses 3.2 pounds of material for each unit, with material costing $1.25 for each pound. Those two figures are enough to price the material each unit consumes.

A typical repair might use a set number of fittings, a length of cable, or a particular filter. The logic does not change. Multiply the planned work by the usage for each job, and you have the amount of each part the work will consume.

Some items need more thought than others. Take a repair that uses a fitting, a length of cable, and a filter. The fitting and the filter are easy to count. The cable is a length, so write it in the unit you buy, whether that is a full reel or a cut piece, and note how much you typically trim off as waste.

Getting this input right takes some digging. Do not rely on memory alone. Pull a sample of recent completed jobs and count what was actually used. Include the small items everyone forgets: sealant, fasteners, labels, and disposable gloves if you bill for them. Those items add up across a busy quarter, and they are often the first to run out.

Keep usage for each job in a short list, one line for each part, with the unit written beside it. "Fittings, each" is clear. "Fittings" invites an argument later about whether a box or a single piece was meant. Use the same unit on the purchase order that you use in the budget, so nobody converts boxes to pieces in the middle of a rush.

When you multiply, keep the arithmetic visible. For each part, write the planned work, the usage for each job, and the result. The budget is then easy to check, and easy to fix when the work count changes. It will change.

Input 3: the stock you want on hand

The third input is your desired ending stock. Decide how much of each part should be on hand when the quarter ends. That ending stock is the starting point for the next quarter.

The chapter treats this as a policy choice. Its example sets a goal of having 20 percent of the next quarter's material needs on hand as desired ending inventory. The percentage is not a law of nature. A firm close to its supplier, able to reorder in a day, might choose less. A firm that drives long distances to job sites, or depends on slow deliveries, might choose more. Whatever you pick, write it down and use it the same way each quarter.

Timing is easy to miss. The ending inventory for one quarter depends on the production needs of the quarter after it. In the chapter's example, the ending inventory for quarter 4 depends on the first quarter of the next year. So you cannot finish this quarter's budget without a rough view of next quarter's work. That is why the planning step looks ahead.

Then count what you already have. The purchase quantity is what you need to buy so the shelf ends where your policy says.

This is where stock tracking earns its keep. Zoho Books describes the behavior this step depends on: "Whenever you make sales or purchase transactions for items in Zoho Books, this stock gets auto-calculated accordingly." Software is optional. The principle is not. The on-hand number should move with the work, not sit as a figure someone typed once and forgot.

A small firm can keep this in a shared sheet. The tool matters less than the habit. Keep the count current before you sit down to plan.

Putting the three inputs together

Now combine the pieces. Each part runs through four steps:

StepWhat you doWhat it gives you
1Multiply planned work by usage for each jobMaterial the work will consume
2Multiply next quarter's need by your ending-stock percentageStock you want to keep
3Add steps 1 and 2, then subtract stock on hand at the startQuantity to buy
4Multiply quantity to buy by unit costMoney the budget needs

Step 3 deserves a moment. The shelf has to supply this quarter's work and also end at the level your policy sets. Adding the two needs gives the total that must be available. Subtracting what is already on the shelf leaves only the gap you have to fill with a purchase.

The source's figures show the path from units to dollars. The planned first-quarter figure of 3,800 units gives production material needs when multiplied by 3.2 pounds, priced at $1.25 for each pound; purchases also add desired ending stock and subtract opening stock, as in Step 3. Your firm has its own figures, but the path from units to pounds to dollars is the same.

If you are a field-service firm, swap the trainer for a job type and the pounds for items. You end with a quantity for each part and a cost for each quantity. Add those costs across all parts, and you have the materials budget for the quarter.

Write the result on one page. Include the planned work, the usage for each job, the ending-stock percentage, the opening stock, the quantity to buy, and the cost. A reader who missed the planning meeting should be able to follow it in five minutes. If they cannot, the budget is not ready to use.

Pricing the parts: unit cost

The cost step is where many budgets go wrong. Parts rarely cost the same every time you buy them. Prices move with supplier changes, bulk discounts, and the mix of older and newer stock on your shelf. If you use the latest invoice for every calculation, you can badly misstate what the quarter will cost.

An average cost is a common and sensible fix. Microsoft's guidance for Business Central explains that average cost is calculated with a periodic weighted average, based on the average cost period you have specified. Plainly: pick a period, then average each item's cost over that period, weighted by quantity. The result smooths out the swings of individual purchases.

You do not need enterprise software for the idea. Add up what you paid for a part over the last period, divide by the total quantity bought, and you have a weighted average unit cost. Use that in the budget and revisit it each quarter. If a supplier changes prices sharply, note it, and decide whether the change is temporary or lasting before you update the average.

Include the costs that come with the part, too. Delivery charges, handling fees, and restocking charges are real money if you pay them. Leave them out, and the budget will come in low every quarter.

Averages hide variation. If a part has two very different prices, one for a small lot and one for a bulk lot, the average will be wrong for both. Budget the two lots separately. The goal is a number you can defend when someone asks why the quarter cost what it did.

Keep the period consistent. Averaging over one month in one quarter and three months in the next will mislead you. Pick a period that matches how you buy. A firm that buys every two weeks might average over a quarter. A firm that buys in one large order each season might average over the season.

What to do with the number

A budget is useful only if it guides a purchase. Before you order, check the result against three questions.

First, does the quantity fit the work? Compare it to the planned jobs. If you are buying far more than the work needs, look for a double count, such as adding the stock on hand twice or mixing booked work with completed work. If you are buying far less, check whether you forgot a job type.

Second, does the cost fit the cash you have? A correct quantity can still strain the budget if it lands in the same month as a large tax payment or a payroll run. Look at timing, not just the total. Split the order if the supplier allows it, or move part of it to the start of next quarter if the stock will keep.

Third, does the ending stock match your policy? If the number at quarter end is much higher or lower than your percentage, find out why before you buy. If the total is simply more than the budget allows, you have two levers: a smaller ending-stock percentage, or a purchase split across the boundary between quarters.

When you are satisfied, place the order and record the arrival. The record is what makes next quarter's budget better. Without actual received quantities, you keep guessing.

Common mistakes to avoid

MistakeFix
Budgeting on memoryPull usage counts from completed jobs
Mixing unitsPick one unit for each part and keep it on every line
Forgetting small itemsWalk the van and the shelf for fasteners, sealant, and labels
Ignoring the next quarterLook ahead, because ending stock depends on the quarter that follows
Using one price foreverAverage over a consistent period and revisit it
Skipping the recordWrite down what arrived and what was used

A simple routine for each quarter

Set aside a short block of time before the quarter starts. If you have a dispatch lead or someone who places orders, bring them in, since they often hold the numbers you need. Run the four steps for each part. Check the result against the three questions.

The routine takes an hour or two the first time and less after that. The first pass will be rough. The second will be better, because you will know which numbers to chase and which you can trust. Over a few quarters, the budget becomes a habit rather than a scramble.

Expect the numbers to be wrong at first. That is fine. A wrong budget that you check against actual usage teaches you more than a guess you never test. Adjust the usage for each job, the ending-stock percentage, or the work forecast, and the next budget gets closer.

Summary

Combine the three inputs with the stock you already have and the unit cost, and you get a quantity to buy and a dollar figure to plan for. The method is not complicated. It is a discipline of writing things down and checking them before the order goes out.

Related guides: Flat-rate pricebook price: 3 parts to build in · Set 6 reorder rule fields before your van parts run out · Van parts: 6 stock rules to set before labeling.

Sources

More field guides