How Overhead Allocation Works for Antique Dealers
Overhead is the shared cost of keeping an antique business operating, whereas direct costs can be traced to one specific piece. Allocation assigns a reasonable share of monthly recurring expenses—such as antique mall booth rent, shop utilities, insurance, bookkeeping, and storage—to individual inventory items so that retail asking prices and markdown decisions are not based solely on auction hammer price.
How to Use This Calculator
- Enter Total Monthly Shop or Booth Overhead: Sum your shared operating expenses for one month. Keep the time period consistent across the whole calculation.
- Choose an Allocation Method: Select Equal-Per-Unit for a fast average across comparable stock, Acquisition Value Share or Expected Selling Value Share when inventory prices vary widely, or Labor & Handling Hours when preparation time drives your costs.
- Enter the Total Inventory Basis: Provide the total unit count, total acquisition dollars, total expected sale dollars, or total monthly labor hours for the same inventory set and period.
- Enter This Item's Figures: Input the piece's acquisition cost, direct restoration/prep cost, expected selling price, and optional commission percentage to inspect both the Fully Loaded Item Cost and Estimated Net Contribution.
Calculation Method & Formulas
Every allocation method computes the item's proportional share of the total monthly basis and multiplies that share by monthly overhead:
Allocated Overhead = Monthly Overhead × Allocation Share
Fully Loaded Item Cost = Acquisition Cost + Direct Preparation Costs + Allocated Overhead
Estimated Net Contribution = Expected Selling Price - Fully Loaded Item Cost - (Expected Selling Price × Selling Fee Rate)
- Equal-Per-Unit: Divides shared overhead equally across the number of units (`1 ÷ Total Units`). Simple and consistent when items consume broadly similar showcase space and handling effort.
- Acquisition Value Share: Allocates overhead in proportion to each item's purchase cost (`Item Acquisition Cost ÷ Total Monthly Acquisition Basis`). Places more shared expense on capital-intensive pieces, though a zero-cost item receives zero overhead under this rule.
- Expected Selling Value Share: Allocates overhead according to realistic expected retail price (`Item Expected Price ÷ Total Expected Inventory Sale Value`).
- Labor & Handling Hours: Allocates overhead by tracked or estimated hours spent researching, cleaning, photographing, and listing (`Item Labor Hours ÷ Total Monthly Shop Hours`).
Worked Example
Suppose an antique shop has $1,500.00 of monthly shared overhead spread across 300 comparable units:
- Under Equal-Per-Unit allocation, the unit share is
1 ÷ 300 = 0.333%, producing a simple overhead allowance of $5.00 per unit. - A piece acquired for $100.00 with $20.00 of direct preparation costs has a Fully Loaded Item Cost of $125.00 before selling fees.
- If the piece is priced at $185.00 in a mall charging 12% combined commission and card fees ($22.20), the dealer retains $37.80 in net contribution after covering purchase, prep, overhead, and selling fees. (Click Load Example above to test this exact calculation.)
Important Assumptions & Limitations
The fully loaded item cost is a management-planning reference, not an appraisal, tax filing calculation, or guarantee that an item will sell at the expected price. Always match your allocation period—do not divide one month of booth rent by an entire year's sales volume unless you convert both numbers to the same period. Avoid double-counting: if a restorer's invoice is entered as a Direct Preparation Cost for a specific cabinet, do not also include that invoice inside shared monthly overhead.