FIN 375 Week 5 Monitoring Financial Performance Example

A One-Page Dashboard for Three Bike Shops: Choosing the Measures, Setting Targets, Comparing Actual With Plan and Knowing When to Act

[Student Name]

University of Phoenix

FIN/375: Financial Management in the Small Business

Week 5 Assignment

[Instructor Name]

[Date]

The bicycle shop and all figures are composites written for a model paper; methods and research findings come from the sources listed.

The bike shop now operates three locations, has a revolving line, floor-plan financing and an SBA loan with covenants and employs 24 people in peak season. The owner can no longer see every sale or check every stockroom. Once a business outgrows the owner's eyes, it needs a few numbers the owner trusts to show what the eyes can no longer see. This paper designs the monitoring system.

Choosing the Measures

The owner chose ten measures, each tied to a goal or risk from the course. For the whole business: sales against budget, gross margin percentage, cash on hand and forecast low point for the next 90 days, inventory turns overall and for bikes older than 180 days, debt service coverage on a trailing twelve-month basis and the current ratio. For each store: sales per labor hour, repair shop billable hours as a share of available hours, average bike sale value and e-bike test rides converted to sales. Fewer measures would miss important drivers; more would not be read, a common problem in small firms whose owners have limited time (Scarborough & Cornwall, 2019).

Setting Targets

Targets come from the budget and cash forecast. The whole business targets a gross margin of 44%, inventory turns of 3.0, debt service coverage of at least 2.0, twice the lender's 1.25 requirement, and a cash low point never below $30,000. Store targets reflect each store's plan: the new store targets sales of $65,000 in its first full month, rising through the spring.

The Monthly Dashboard

The bookkeeper prepares a one-page dashboard by the fifth business day of each month. Each measure shows the month's actual result, the target, the year-to-date result and a simple color: green within 5% of target, yellow between 5% and 15% off and red beyond 15% or past a covenant threshold. A second page lists the three largest variances with a sentence of explanation for each.

Comparing Actual With Plan

In its first full month, the new store had sales of $52,000, 20% below target. Gross margin was 41%, below the 44% target. The variances traced to causes: rain on two weekends reduced foot traffic on the trail, and the store discounted demo e-bikes to attract first customers. Sales per labor hour were low because the store was fully staffed for the trail traffic that did not come. The owner cut one weekday shift until traffic builds and ended the demo discounts.

Break-Even for the New Store

The new store's monthly fixed costs, rent, base staffing, utilities and loan payments allocated to it, are about $24,500. Its contribution margin ratio, after variable costs of merchandise, card fees and commissions, is about 38%. Break-even sales are $24,500 divided by 0.38, about $64,500 a month, using the standard contribution margin approach (Garrison et al., 2021). The first month's sales were about $12,500 short of break-even; the spring forecast shows the store passing break-even by April.

Covenant Thresholds

The SBA loan requires debt service coverage of at least 1.25 tested annually, and the line of credit carries a 1.3 minimum on the current ratio. The dashboard shows coverage on a trailing basis monthly, and the owner has set an internal warning at 1.6, well above the covenant, so there is time to act. If coverage falls below 1.6, the owner will delay discretionary spending and review staffing; below 1.4, the owner will call the bank before the annual test.

Using the Dashboard

The owner meets with the three store managers for an hour after the dashboard is issued. Each manager explains variances at their store and proposes actions. The owner and bookkeeper review the whole-business measures and the cash forecast. Decisions are recorded in a short log that names who owns each action, and the next month's dashboard shows whether they worked.

Why Operating Measures Help

Kaplan and Norton (1992) argued that financial figures describe what past decisions already produced, while operating measures such as customer and process indicators show what will drive future results. For the bike shop, e-bike test ride conversion and repair shop utilization change before sales and margin do, which is why they are on the dashboard alongside the financial measures.

Reading the Cash Line

Cash on hand is the measure the owner reads first, because the business's earlier weeks showed how quickly a seasonal shop can report a monthly profit while its bank balance shrinks toward zero. The dashboard therefore shows two cash figures: the balance at month end and the lowest balance projected in the rolling 90-day forecast. In February the month-end balance was $61,000, comfortably above target, but the forecast low point was $34,000 in late March, when spring bike orders arrive before spring sales. That figure sat close enough to the $30,000 floor to turn yellow. The owner asked the main supplier to split the spring order into two deliveries three weeks apart, which lifted the projected low point to about $47,000 without reducing the season's stock. A cash forecast earns its place on the dashboard when it changes a decision before the shortfall arrives.

Inventory turns sit next to cash for the same reason. Bikes older than 180 days tie up money the shop needs in spring, so the dashboard lists their value separately, and the owner marks any model past that age for a clearance price before new stock lands.

Keeping the System Simple

The owner resisted adding measures each time a question came up. Every quarter, the owner reviews whether each measure led to a decision; any measure that did not is replaced.

Conclusion

A one-page dashboard of ten measures, with targets from the plan, color thresholds, explained variances, break-even for the new store and covenant warnings, lets the owner of a three-store bike business see performance each month and act before small problems become cash problems. It ties together the forecasting, budgeting, working capital and financing work of the course.

References

Garrison, R. H., Noreen, E. W., & Brewer, P. C. (2021). Managerial accounting (17th ed.). McGraw Hill.

Kaplan, R. S., & Norton, D. P. (1992). The balanced scorecard: Measures that drive performance. Harvard Business Review, 70(1), 71-79.

Scarborough, N. M., & Cornwall, J. R. (2019). Essentials of entrepreneurship and small business management (9th ed.). Pearson.