Straight into the service manual page
WrenchQuarry
More

Cost of parts used: 3 totals from a periodic count

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

The cost of parts used in the worked example period is $8,283. You get it by subtracting the $7,872 of parts still on the shelf at period end from the $16,155 of goods available for sale.

  • Total one: a $27.62 average unit cost across all 585 units available.
  • Total two: 285 of those 585 units still on the shelf at period end.
  • Total three: $7,872 of ending parts stock, from 285 × $27.62.
  • Fourth figure: $8,283 cost of parts used, by subtraction from the $16,155 pool.

This post walks through the three totals that a periodic count produces, using a worked example from an accounting textbook. Along the way it covers the fourth figure that falls out of the count, the adjusting entry, and the places where a count and the books tend to disagree.

Total one: the $27.62 average unit cost across all parts available

The first total is a unit cost. A periodic count does not price each part as it leaves the shelf. Instead, it looks at the whole period at once. The OpenStax worked example explains that, for the weighted-average method, "considering the entire period, the weighted-average cost is computed by dividing total cost of goods available for sale ($16,155) by the total number of available units (585) to get the average cost of $27.62."

In practice, "goods available for sale" means everything you had to work with during the period: the parts already on hand when the period started plus everything bought during it. The dollar total covers all of that cost, and the unit total covers every unit in that same pool. Dividing one by the other gives a single average that applies to every part of that type, regardless of when it arrived.

This matters for a small shop because the average smooths out price changes. If a fitting cost one amount in January and a higher amount in March, the periodic average does not ask which specific unit went into which job. The result is one number you can apply to the count, which is exactly what the rest of the calculation needs.

The first total, then, is not a count of anything on a shelf. Keep the two inputs, $16,155 and 585, written down next to the result. You will need both again when you check the other totals.

It also helps to be clear about what goes into the pool. Opening stock, purchases during the period, and any other additions that increased the cost of parts on hand all belong in the dollar total. The unit total has to match that same set of parts. If the dollar side includes a purchase that the unit side leaves out, or the reverse, the average is off before any counting begins, and every later figure inherits the error.

Total two: 285 of 585 units still on the shelf

The second total is physical. It answers the question of how many units you still have. The textbook example states: "Note that 285 of the 585 units available for sale during the period remained in inventory at period end."

That single sentence is the bridge between your count and your books. The 585 units are the total pool from the first total. The 285 units are what your counter found when the period closed. Subtracting 285 from 585 gives the number of units that left inventory during the period, which is the quantity side of the cost of parts used.

Several practical points follow from this. The count has to be a true count of what is physically on hand at period end, not a guess from the purchase log. It also has to cover the same part types as the pool in the first total. If the count skips a whole family of parts, the ending figure will look too low and the cost of parts used too high.

Notice that the example gives the count as a unit number, not a dollar figure. Dollars come from multiplying this count by the unit cost in the next section. Keeping quantity and cost as separate columns on your count sheet makes that multiplication easy to check later. A count sheet that records only dollars leaves no room to test the result against the unit total.

Timing matters too. The count should reflect the shelf at the moment the period closes. Parts that arrive after the cutoff belong to the next period, and parts pulled for jobs before the cutoff have already left the shelf. Recording the date and time of the count, and who performed it, makes it much easier to explain any difference that someone questions later.

Total three: $7,872 in ending parts stock

The third total turns the count into a dollar value. The textbook puts it this way: "Following that logic, ending inventory included 285 units at an average cost of $27.62 for a total AVG periodic ending inventory value of $7,872."

The arithmetic is simple. Multiply the counted units by the average unit cost. The table below sets the three inputs and the output next to each other.

MeasureFigure in the worked example
Units available for sale during the period585
Units in inventory at period end285
Ending inventory value (285 × $27.62)$7,872

The table makes one point clear: the ending value depends on both inputs. If the count is off by a few units, the value moves by a few times the unit cost. If the average is wrong, every unit on the shelf is wrong by the same proportion. That is why the first two totals need checking before this one is treated as final.

For an office lead, this is the number that matters most at close, because it is the value of the parts asset the business holds. Write it down with the count date and the name of whoever counted, so the figure can be traced if anyone asks where it came from.

Cost of parts used this period: $8,283

With the first three totals in hand, the fourth falls out by subtraction. The textbook states: "Subtracting this ending inventory from the $16,155 total of goods available for sale leaves $8,283 in cost of goods sold this period."

The logic runs in one direction. Everything you had available was either used or still on the shelf. So the cost of what was used equals the total available less what remains. Here, $16,155 minus $7,872 gives $8,283. The parts you used cost $8,283, and the parts still in stock are worth $7,872. Together those two numbers add back to the full $16,155 pool.

That check is worth doing every time. If the used figure plus the ending figure does not equal the available figure, something upstream is wrong: a purchase was left out of the pool, a count sheet has an arithmetic slip, or a unit cost was applied to the wrong quantity. The subtraction is the cheapest audit you have, because it uses numbers already on the page.

It is the amount that reduces profit, which is why owners care about it. A higher ending count lowers this figure and raises profit on paper. A lower count does the reverse. Because the number moves with the count, an unexplained change in the count shows up directly in the profit picture. A shop that counts carelessly at the end of one period and carefully at the end of the next may see profit swings that have nothing to do with how the business actually performed.

Why the unit cost rounds to $27.62

The unit cost in this example is not a clean division. The textbook notes: "In this case, the cost comes to $27.6154 but rounds up to the stated cost of $27.62."

The rounding is small, but it is still a choice, and it is worth understanding before the close. Dividing $16,155 by 585 gives a quotient rounded to four decimal places of $27.6154, and the exact quotient is a repeating decimal, so any number of places you keep is an approximation. The important thing is to pick a convention and apply it the same way in every period.

Rounding creates a practical trap for parts stock. If you round the unit cost to the cent, then multiply by the count, the result can differ by a few dollars from what you would get using the unrounded average. Across a large parts inventory, those few dollars can accumulate. The fix is not to chase fractions of a cent. The fix is to record which figure you used, keep it consistent, and make sure the totals still reconcile.

In the example, the stated figure is what carries through. The ending value is $7,872 and the used cost is $8,283, and those two figures sum to the $16,155 pool. A reader checking the example can confirm that the rounding did not break the reconciliation. Use the same test on your own numbers: if the two totals do not sum to the pool, the rounding or a multiplication is the first place to look.

Adjusting the books to the count: the $4,722 entry

The last figure in the worked example is the journal entry needed to make the recorded inventory match the count. The textbook says: "The inventory at period end should be $7,872, requiring an entry to increase merchandise inventory by $4,722."

The principle is that the recorded balance has to agree with what the count shows. The count establishes the correct ending balance, $7,872. The books may show a different amount, perhaps because purchases were recorded during the period but the periodic method only updates inventory when the count is taken. The adjusting entry closes that gap. In the example, the entry increases merchandise inventory by $4,722 so that the books show $7,872.

For a small firm, this entry is where the count meets the general books. The count sheet supplies the target. The entry moves the account to that target. Writing the entry with a short note that cites the count date, the counted quantity, and the unit cost makes the adjustment easy to defend later. An entry with no supporting count is much harder to explain to an owner, a bookkeeper, or an outside accountant who reviews the records.

Two habits keep this step clean. First, post the adjustment only after the count is checked, since an entry built on a bad count simply moves the error into the books. Second, keep the entry separate from routine purchase postings so that a reader can see what the count changed. The $4,722 figure in this example is a single line, but the same discipline applies whether the adjustment is small or large.

When the stock count and the books disagree

A count sheet and the general books are two records of the same parts, and they can disagree.

The worked example shows what a gap looks like in dollars. The ending value should be $7,872, and the entry needed to reach it is $4,722. That $4,722 is the expected close entry the periodic method requires; check it against the count before you post, rather than treating the amount itself as a discrepancy.

A practical sequence helps. Confirm the count, confirm the purchase postings, confirm the unit cost applied, and only then post the difference. A gap explained by a missing purchase calls for a different fix than one explained by a miscounted shelf. A gap explained by a return that was never recorded calls for yet another fix. Writing down which cause you found keeps the reconciliation traceable, and it gives you a record to compare against if the same kind of gap appears next period.

Why recorded stock drifts from the warehouse

Stock on paper and stock on the shelf can diverge for reasons outside normal business.

Cause named in the Zoho definitionEffect on the recorded figure
TheftActual stock falls, but the record may still show the old quantity
Damaged goodsUsable stock falls, and the record may not reflect it
Data entry errorThe record holds a number that was never on the shelf
Write-offStock is removed from the books on purpose
DonationStock leaves the warehouse without a sale

Reading the list as a checklist is useful at close. If the count and the record disagree, ask whether one of these causes applies before assuming the count is wrong. The list offers examples rather than an exhaustive set, so a late-posted sale or an unrecorded return may fall outside it and should be traced separately.

Data entry errors deserve particular attention in a small office, because they are the cause most likely to be fixed quietly and forgotten. A part number typed with one digit transposed, or a quantity keyed into the wrong line, can throw the record off for months. Comparing the count sheet against the purchase and issue records for the largest items often finds these errors faster than a full line-by-line review.

Side-by-side comparison of the three totals

The three totals from a periodic count are related, and each one feeds the next. The OpenStax worked example supports all three figures.

TotalWhat it measuresWorked-example figureBuilt from
Units in inventoryPhysical quantity on hand at period end285 unitsPeriod-end count
Ending inventory valueDollar value of parts still on the shelf$7,872285 × $27.62

Read across the rows. The first total is a rate, the second is a quantity, and the third combines them into a dollar amount. Because the third depends on the first two, an error in the unit cost or the count carries straight into the ending value and, through subtraction, into the $8,283 cost of parts used.

Which one should you pick?

When the books and the count disagree, you have to decide which figure anchors the close. The sources point to the physical count.

OptionRole at closeSupport in the sources
Physical count at period endSets the correct ending balanceThe worked example says ending inventory "should be $7,872"
Recorded balance before adjustmentGets corrected to match the countThe $4,722 entry moves the recorded balance to the target
Purchase and stock recordsFeed the $16,155 poolZoho treats recorded stock that differs from actual stock as the thing to adjust

The count is the better anchor because the recorded balance and the purchase records are the things being checked. The OpenStax example uses the count to set the target and the entry to close the gap, and Zoho's definition describes adjustments as corrections to recorded stock. This only works if the count itself is careful, so recount any item where the difference is large before you post.

Recounting is not the same as recounting everything. A sensible approach is to recount the items that carry the most value or that show the largest gap, and to spot-check a sample of the rest. If the spot checks agree with the count sheet, the count is probably sound. If they do not, widen the recount before posting anything.

Checking which figure to trust before you close

Before posting, run three arithmetic checks on the figures. The worked example passes all three, and you can repeat the same checks on your own numbers.

CheckCalculationResult
Used plus ending equals available$8,283 + $7,872$16,155, which matches the pool
Units on hand plus units that left equal units available285 + (585 − 285)585, which matches
Count times unit cost gives ending value285 × $27.62Rounds to $7,872, which matches

The third check explains the rounding. The source carries the stated $27.62 forward, so the product rounds to the stated $7,872 ending value. If any check fails on your numbers, find the failing input before you post the entry.

These checks are deliberately simple. They do not prove the count was right, because a miscount can still add up perfectly. What they prove is that the arithmetic is internally consistent. Accuracy of the count depends on the count itself, which is why the recount step comes first.

What to write down at close

The three totals and the fourth figure are only useful if someone can trace them later. A short close record should hold the period dates, the total cost of goods available for sale, the counted units, the unit cost used and the rounding convention, the ending value, the cost of parts used, and the adjusting entry with its reason. Keep the count sheet itself with that record, not in a separate folder.

It also helps to note any difference you investigated and what caused it. A gap traced to a data entry error, a late purchase, or a miscounted bin is far more useful to a future reader than a bare adjustment with no explanation. Over several periods, these notes show which causes come up most often in your shop, which points to where better receiving or issuing habits would help the most.

For related counting discipline, see Van stock surprise count: 5 checks for accuracy, and for the adjustment side see Periodic inventory adjustment: the 2 amounts to post.

Finally, match the record to the level of detail your business needs. A firm with a few dozen parts can keep a single worksheet with every count, cost, and entry on one page. A firm with thousands of part numbers will want a system that handles the pool and the count automatically. The method in the worked example stays the same either way. What changes is how many lines you have to carry through it.

Related guides: Floor price for a one-off job: 3 cost parts · Parts cost percentage on a service job: 3 figures to track · 2 worked examples: hourly cost of tech benefits.

Common questions

What is the cost of parts used in a periodic count? It is the goods available for sale minus ending inventory: $16,155 − $7,872 = $8,283 in the worked example.

How do you get the ending inventory value? Multiply the counted units by the average unit cost: 285 × $27.62 gives the $7,872 ending value.

Why does the unit cost round to $27.62? $16,155 ÷ 585 gives a repeating decimal, so the example rounds to the cent and carries that figure forward.

What does the $4,722 entry do? It increases merchandise inventory so the recorded balance reaches the counted $7,872 ending value.

Do this today

On your own count sheet, run the reconciliation check: add your ending inventory value to your cost of parts used and confirm the sum equals your goods available for sale. If it does not, one of the three inputs is wrong, and you have found it before posting.

Sources

More field guides