Bicycle Shop Plan: Can Repairs Offset Slower Bike Sales?

Repair work offsets slower bicycle sales only when enough additional paid jobs fit the qualified workshop schedule and their contribution replaces what the lost sales would have earned. Check the retail stock payment separately: a busy bench can improve the result while cash remains committed to unsold bicycles.

Build two sales plans with a shared resource calendar

Forecast new bicycles by category, size and season, and repairs by complete job class. Use collected retail sales and accepted service work rather than adding every inquiry to demand. A tune-up, wheel build and fault diagnosis need different parts, skills and completion time. Reserve assembly, handover, warranty work and parts waiting before declaring workshop hours available for extra repairs.

For staffing context, BLS lists May 2025 occupational estimates, and the O*NET bicycle-repairer wage table using those 2025 data shows a US hourly median of $20.57. That is a dated employee wage measure, not a local job offer or the full cost of employing a qualified mechanic. Obtain the actual pay, benefits, paid nonproductive time and skill requirements. In the case below, existing staffing is already inside the fixed commitment; do not add a variable wage charge from that median on top.

Retain the original retail and repair comparison

Original monthly assumptions, in dollars: buy and pay for 20 comparable bicycles at $350 each; each sold bicycle collects $500. A standard repair collects $75 and consumes $20 of parts. Standing staffing and other commitments total $3,000, excluding repair parts. Each repair takes 1.5 hours. Seventy-two workshop hours are reserved for these repairs after all initially planned other tasks. Fees, returns, tax, financing and other unlisted costs are excluded.

Four lost bicycle sales remove $600 contribution: four times the $150 difference between selling price and landed cost. Each additional repair contributes $55 before the unchanged roster. Replacing $600 requires eleven whole extra repairs; ten contribute only $550, while eleven contribute $605. But forty existing repairs leave just twelve hours, enough for eight more. Those eight recover $440, so the selected result remains $160 below the original mix.

Do not turn a positive result into an assumed bank balance

In the eight-bike cases, twelve unsold bikes retain $4,200 of purchase cost. In the 48-repair case, the $840 selected result less that inventory increase reconciles to negative $3,360 cash movement. It is not a claim that the business bank balance is negative $3,360.

Add an explicitly assumed $9,000 unrestricted opening bank before the $7,000 bicycle purchase. If all selected sales are collected and commitments paid by the review date, the three mixes close with $7,200, $5,200 and $5,640 respectively. Suppose a further six-bike order costs $2,100 and is payable immediately, before more receipts. From the last mix it leaves $3,540, only $40 above a chosen $3,500 bank buffer. That buffer is an assumption, not proof that the whole shop is funded or a reason to buy six bikes without demand.

Include the next order's assembly work

Now stress that reorder rather than treating it as a cash-only event. Assume each of the six incoming bikes needs an additional half-hour of qualified assembly within the same 72-hour window. This is new work beyond the tasks already reserved. It takes three hours, leaving 69 for repairs and room for 46 complete 1.5-hour jobs, not 48.

The order's $2,100 is new inventory cash, not another expense on the eight bicycles already sold. Losing two repairs removes $110 contribution and receipts net of parts, changing the narrow $40 buffer headroom into a $70 shortfall. Confirmed additional qualified hours, a later assembly date or a different order needs a revised case with its actual cost and service consequences.

Use the stock report and job diary together

• Workshop: record complete job hours, approved scope, parts delays and return work. Count a repair once even when it needs more than one visit.
• Retail stock: reconcile purchased, sold and remaining bikes by category and size, plus assembly status. A slow model is not a substitute for a missing demanded size.
• Purchasing: obtain landed quotes, due dates, minimums and written return or credit terms. Do not spend an expected supplier credit before it is available.
• Cash: date receipts, payroll, parts and stock bills. The review-date bank is not the lowest day; the assumed $9,000 leaves only $2,000 immediately after the initial purchase.

Keep the chosen buffer distinct from bills already entered, so the same commitment is not reserved twice. The separate Bicycle Shop Financial Model page describes the selected product and its service-led opening case. Add a distinct retail-bike stock and assembly plan when both activities operate together; the comparable repair and bike figures here are original assumptions, not a workbook test or verified service-time standard.