Lighting Showroom
Revenue Leak Audit
A ranked review of how inquiries, quotes, follow-up, scheduling, and invoicing actually move through the business, built from one month of the company's own phone, email, quote, and webstore records.
Rank the places revenue is leaking, show the evidence for each, and lay out the fixes in the order they pay back.
Internal records provided by the owner July 9 to 10, 2026: call logs, three inboxes, the last fifteen quotes, webstore cart data, a voicemail week, three threads, and a recorded owner interview.
Every claim is labeled Confirmed, Reported, Suggested, or Unknown. Nothing resting on public research is presented as documented fact.
Scope And Evidence Standard
What this report rests on, what it could not see, and how to read every label in it.
One month of phone activity on both lines (June 8 to July 8). Thirty days of all three inboxes, info@, sales@, and the first-name address, with reply status marked by the owner and the sales lead. The last fifteen quotes with outcomes, from QuickBooks and owner memory. A month of webstore cart and wish list data. One full week of voicemails with return status. Three forwarded email threads. A recorded 45-minute owner interview.
Walk-in traffic counts. A receivables aging report. Message-by-message verification of the owner-marked reply columns. Two quotes, missing from the quote log even though the sales inbox shows one was sent June 30.
This audit is the verification step after the free Snapshot delivered July 11. The Snapshot's hypothesis, built from public pages only, is tested here against internal records and is confirmed, revised, or retired accordingly.
Confirmed Documented internal evidence reviewed in this engagement.
Reported Stated by the owner or team, not yet seen in documents.
Suggested Outside-in interpretation from public materials, still unverified.
Unknown Could not be determined from the available evidence.
The label travels with the claim everywhere it appears, including the executive summary. A Suggested leak is never allowed to read as Confirmed, and no dollar figure appears in this report unless it is the business's own number.
The quote goes out. Then nothing.
Six leaks were found. Five are Confirmed in the business's own records. The one at the top is also the cheapest to fix.
The most likely leak is the simplest one: quotes go out and nothing follows them Confirmed. Fourteen of the last fifteen quotes show no recorded follow-up. Five of the fifteen ended in "no response," worth $18,820 in the business's own quote values, and the one documented follow-up call came two weeks late on a bid that was already lost. The whole-house remodel customer thread shows the mechanism exactly: a $6,850 whole-house quote, a buyer who said he was comparing bids, sale pricing that expired June 15, and no call from anyone. The owner's own note: "That one stings, they were ready."
In the interview, the owner guessed that maybe five inquiries a month get no answer. The documents say the real number is well past that Confirmed. In one month, 103 of 310 inbound calls never reached a person, and 33 of those callers hung up without leaving a message, so nobody can even call them back. At least five customer emails in thirty days got no reply at all, including a builder's six-home pricing request and a model-home RFQ. One customer is currently emailing the business to chase her own quote.
A fixed three-touch follow-up on every quote, owned by one named person and tracked on one sheet. Alongside it, one immediate call: the city public works department's $38,500 street lighting quote is open right now with a late-September install deadline, and no one has followed up since it was sent July 1.
Fix the top item as a Leak Fix Sprint, then re-measure with the same reports this audit used: the quote log, the inbox exports, the call log, and the webstore report.
Business And Offer Reviewed
Who was reviewed, what they sell, and which records this audit could see.
Family lighting showroom, in business for decades. The owner runs it full time; the sales lead has run the sales floor for 22 years; the bookkeeper does the books Tuesdays and Thursdays; the warehouse lead handles warehouse and deliveries; the founder comes in mornings and runs the commercial street lighting line.
Lighting fixtures, ceiling fans, and home accents sold from the showroom and the webstore. A dedicated area for design sessions. A trade program with about 30 active accounts. The commercial street lighting line, designed and warehoused by the business.
Walk-in sale $300 to $600. Chandelier project $2,000 to $5,000. Whole-home package $8,000 to $20,000. Last street lighting order, 2024, around $40,000: "the biggest single tickets we see."
Both phone lines, one month. Three email inboxes, thirty days. Webstore carts and wish lists, one month. Front desk voicemail, one week. Walk-in traffic is not tracked anywhere. Confirmed
Quotes in QuickBooks. Design-session appointments on a paper calendar. No CRM, no inquiry list, no voicemail return list. Confirmed
The city public works department street lighting thread. An interior designer trade signup thread. The whole-house remodel customer quote thread. Confirmed
Hours: Monday to Thursday 7:30 to 4:30, with an early Friday close, closed weekends. Contact points shown publicly: one phone number and three email addresses, with no inquiry form or booking link (Observed in the July 11 Snapshot).
How Work Moves Today
The real path from inquiry to invoice, reconstructed from the records, with the leak points marked.
- A buyer calls, emails one of three addresses, walks in, or starts a webstore cart. Confirmed
During open hours the phone works well: 207 of 233 open-hours inbound calls were answered. - Leak: outside those hours, the phone is the only door and it is closed. Confirmed
77 calls in one month arrived after close, Friday afternoons, or weekends. 44 left voicemail; 33 hung up without a message and are untraceable. - Email lands in whichever inbox the buyer guessed. Confirmed
sales@ is the sales lead's and moves same or next day. info@ is "whoever's up front," in practice the owner on Mondays. The first-name address can sit for days, and sat through the June 17 to 21 market week. - Leak: inquiries with no owner get slow answers or none. Confirmed
The city public works department's street lighting request sat 19 days across two emails. A six-home builder request, an HOA's 18-fixture job, and a model-home RFQ got no reply at all. - Quotes are written in QuickBooks and emailed as a PDF. Confirmed
This part works. Quote turnaround from inquiry is usually same day to a few days. - Leak: after the send, silence. Confirmed
No follow-up recorded on 14 of the last 15 quotes. "If they call back, they call back." - Won jobs get scheduled; design sessions book by phone onto a paper calendar. Reported
Occasional double-bookings that get shuffled. - Invoices go out net 30 for trade; a few accounts run past 60 days and are left alone. Reported
"The founder's rule, don't hassle good accounts." No aging report was reviewed.
The inbox reply columns are the owner's marking, not verified message by message. Two quotes are missing from a log built from QuickBooks plus memory. Walk-in traffic, the store's main channel, has no records at all. And the interview says customer email gets answered "same day"; the documents show a Monday rhythm, three Friday inquiries answered Tuesday, and a stated 48-hour return confirmation missed by 11 days. The business cannot currently see its own misses.
Six Leaks, Ranked By Likely Cost
One row per leak. Detail cards for each follow on the next three pages.
| # | Leak | Status | Why it is likely costing money | Evidence reviewed | First fix |
|---|---|---|---|---|---|
| 1 | Quotes get no follow-up after send | Confirmed | 5 of the last 15 quotes ended "no response," $18,820 in open quote value; buyers comparing bids hear nothing | Quote log, whole-house remodel customer thread, interview | Three-touch follow-up on every quote, one owner, one tracking sheet |
| 2 | Big-ticket inquiries have no owner | Confirmed | $38,500 muni quote sat 19 days and sits unfollowed now; builder RFQs went unanswered | city public works department thread, info@ and the first-name address logs, interview | Name an owner per inquiry type; log every inquiry on one sheet; call the city public works department this week |
| 3 | A third of inbound calls never reach a person | Confirmed | 103 of 310 calls in a month; 33 hang-ups left no trace; one returned caller had already bought elsewhere | Call log, voicemail sample week | After-hours greeting that promises a return time, plus a morning callback list worked to zero |
| 4 | Webstore recovery is switched off | Confirmed | $23,480 of abandoned carts with captured emails in one month vs $8,912 in completed online orders | Webstore back office report | Turn on the platform's built-in cart recovery email; assign a weekly cart review |
| 5 | No response-time standard | Confirmed | Friday inquiries answered Tuesday; market week froze the first-name address for days; a customer is chasing her own quote | All three inbox logs, threads | One stated reply standard; cover inboxes on Fridays and travel weeks |
| 6 | Trade receivables drift past terms | Reported | Some net-30 accounts run 60+ days; nobody follows up on them | Interview only; no aging report reviewed | Pull the QuickBooks aging report; send monthly statements |
Ranking is by likely revenue impact: what each leak costs and how often it happens, using the business's own numbers where the evidence contains them. Confirmed leaks outrank equally sized Reported ones. Leaks 1 and 2 are close; 1 leads because it recurs every month with documented dollar values, while 2 carries the biggest single tickets at a lower frequency.
Leak Cards 1 And 2
The required depth behind rows 1 and 2 of the ranked table.
Leak 1: Quotes get no follow-up after send Confirmed
What it is. Once a quote PDF is emailed, no one owns the next touch. Whether the sale closes depends on whether the customer calls back.
Evidence. Quote log, April 21 to July 1: follow-up recorded as "none" on 14 of 15 quotes. Outcomes: 5 won, 1 partial, 3 lost, 5 "no response" worth $18,820 ($2,315 + $6,850 + $3,480 + $3,970 + $2,205), 1 open. The one recorded follow-up (a restaurant patio quote, $5,600) came two weeks after send and still lost. Whole-house remodel customer thread (the whole-house quote, $6,850): June 2, "We're comparing a couple of bids from our contractor's supplier"; the sale pricing expired June 15; nobody called. Owner: "That one stings, they were ready." Interview: "there's no system. If they call back, they call back."
Mechanism. Quoted buyers are comparing: one quoted project went to another store, a restaurant patio quote to an electrician's supplier, an online comparison quote to an online retailer. Silence hands the comparison to whoever calls back first. The wins are mostly trade accounts who return on their own.
Impact. $18,820 of the business's own quoted value went silent in about ten weeks, on top of $10,960 in recorded losses. The five silent quotes average $3,764. How much follow-up rescues is an assumption to verify, not a promise.
First fix. Three touches, one owner (the sales lead for sales@ quotes): call day 2, email or text day 5, close-the-loop day 10. Log every quote and touch on one sheet, starting with the two hanging now (one customer, chasing her own mid-June quote; another customer's July 2 request, no reply).
Automation, once proven. Reminders that trigger each touch from the quote date. Never messages that send themselves.
What would change the ranking. If the missing two quotes closed without follow-up, or most silent quotes were unqualified, this drops toward the phone leak. The tracking sheet answers that within a month.
Leak 2: Big-ticket inquiries have no owner Confirmed
What it is. Inquiries outside the sales lead's sales@ lane, street lighting, builder RFQs, commercial work, have no assigned owner, so they wait for the owner's Monday pile or fall through entirely.
Evidence. A city public works department emailed info@ June 12 for specs and budget pricing on 44 roadway fixtures, install by late September. Re-sent June 23 "in case this didn't reach the right person." The owner replied July 1, 19 days after arrival, with a $38,500 budget quote; no correspondence since, no follow-up recorded. Also unanswered in the same thirty days: a production builder's six-home pricing, a homeowners association's 18 post lights, another production builder's model-home RFQ, and a staging-rental inquiry marked "nobody sure whose this is." Interview: street inquiries come "one or two a quarter... They usually don't go anywhere."
Mechanism. These are the largest checks the business sees and the only inquiries with no owner. A procurement coordinator who must resend an email to "reach the right person" is learning the vendor is risky before pricing is discussed.
Impact. The one street order that landed, 2024, was around $40,000, the owner's number; the open quote for the city public works department is $38,500. The builder RFQs are unsized, but the log's own comparable, a production builder's spec-home package, was $7,940. One rescued inquiry a year is the biggest single fix in this report.
First fix. Call the city public works department this week; the quote is open and their deadline is real. Then a one-page ownership map: street and commercial to the owner and the founder with a two-business-day spec-pack rule, trade to the sales lead, everything else to the owner by default. Every inquiry goes on one shared intake sheet the day it arrives.
Automation, once proven. Forwarding rules so info@ and the first-name address inquiries land with their owner the hour they arrive; a weekly unanswered-inquiry report from the intake sheet.
What would change the ranking. If the city public works department and the RFQs prove to be third-bid gathering, the ceiling drops and Leak 1 stands alone at the top. The intake sheet plus 90 days settles it.
Leak Cards 3 And 4
The required depth behind rows 3 and 4 of the ranked table.
Leak 3: A third of inbound calls never reach a person Confirmed
What it is. The phone is the store's main door, and outside 40 open hours a week it goes to a machine with no promised return time. A third of the callers who hit it leave no message, so they are invisible.
Evidence. Call log, June 8 to July 8: 310 inbound calls, 207 answered, 103 never reached a person. Of those 103, 77 arrived outside open hours (44 voicemails, 33 hang-ups with no message), 14 on Friday afternoons after the early Friday close, 27 on weekends. Voicemail week of June 22 to 28: 8 legitimate messages, 2 with no return call found, 2 returned only the next business day or later. One, a contractor needing 14 recessed trims for a Thursday inspection, was called back Wednesday morning; he had already bought elsewhere. Another, Friday 2:14 pm: "You close early on Fridays?? Calling about the pendant quote I got last week, wanted to add two more."
Mechanism. Answered calls clearly convert; the log shows long, engaged conversations all day. The leak is the callers nobody sees: 33 monthly hang-ups are unrecoverable, and slow-returned voicemails go to whoever answers next.
Impact. Cannot be sized precisely because hang-ups leave no trace, which is itself the finding. Owner's own values: walk-in $300 to $600, chandelier project $2,000 to $5,000. The owner said she would "be sick if it was twenty" unanswered a month; the hang-ups alone are 33.
First fix. Not Saturday hours; that was tested in 2023 and did not pay (Reported). Instead: re-record the greeting to promise a specific return time, and run a morning callback list worked to zero. Track one month.
Automation, once proven. A missed-call text-back on the main line, the only way to recover callers who will not leave voicemail.
What would change the ranking. If a month of the callback list shows mostly vendors and robocalls, this drops below the webstore leak. The list provides the count.
Leak 4: Webstore recovery is switched off Confirmed
What it is. The webstore captures buyer intent, carts with email addresses attached, and does nothing with it. The platform's recovery features exist and have never been configured.
Evidence. Back office report, June 8 to July 8: 6,418 sessions, 118 carts, 11 completed orders worth $8,912. Abandoned carts with an email captured: 41, worth $23,480, including single carts of $3,214 and $2,760. Wish lists: 14, worth $9,105. Recovery email OFF, never configured; wish list reminder OFF; back-in-stock OFF. Nobody is assigned to the report; intake was the first time anyone had opened the cart view "in at least a year." Interview: "we never set it up. Nobody looks at the carts."
Mechanism. These buyers picked specific fixtures and left an email address. With recovery off, each one comes back on their own or quietly buys elsewhere; the quote log already shows a loss to an online retailer.
Impact. $23,480 of captured-email cart value abandoned in one month against $8,912 of completed online revenue, both the platform's own numbers. No recovery rate is promised; the point is the ratio, two and a half times the store's actual online month sitting in reachable carts, at near-zero cost.
First fix. Turn on the built-in abandoned-cart email, roughly half an hour in the back office. Assign the weekly cart and wish list review to one person; personal email or call on the five largest carts.
Automation, once proven. This leak is the automation: the feature exists and is off. Wish list reminders and back-in-stock notices follow once the cart email is proven.
What would change the ranking. A month of recovery data. If recovered value is small, this drops below Leak 5 and the review shrinks to monthly.
Leak Cards 5 And 6
The required depth behind rows 5 and 6 of the ranked table.
Leak 5: No response-time standard Confirmed
What it is. Nobody has agreed what "answered fast enough" means, so speed depends on which inbox, which day, and who is in the building. Friday afternoons after the early close and market weeks are structural dead zones.
Evidence. Interview: "Is there a target? No." Three Friday inquiries were answered the following Tuesday, including a consultation request and two quote requests. During the June 17 to 21 out-of-town market week, the first-name address sat: two trade emails waited until Monday, and the city public works department's inquiry waited 19 days in the same stretch. A designer who asked for an answer "by Friday" got it Monday. The stated 48-hour return confirmation was missed by 11 days on a customer return. As of July 8, one customer is chasing her own mid-June quote and a July 2 quote request has no reply. The counterexample proves the value: an interior designer's trade inquiry got the sales lead's reply in three and a half hours, the account opened next day, first order of $2,340 within eight days, and two more projects since.
Mechanism. Inquiries are perishable. The same business that turned a designer inquiry into revenue in eight days by answering at lunch loses momentum whenever the answer waits for Monday.
Impact. Not separately sized; this leak feeds Leaks 1 through 3, and its fix makes those fixes stick.
First fix. One written standard: customer inquiries same business day; Friday afternoon and weekend arrivals by Monday 10 am; named cover for info@ and the first-name address when the owner travels, fifteen minutes a day. State the standard publicly at the site's contact points.
Automation, once proven. Forward all three addresses into one shared view so coverage stops depending on memory.
What would change the ranking. Nothing raises it above Leaks 1 and 2; it is a multiplier, not a source. If message-level verification shows faster real replies, parts soften to Reported.
Leak 6: Trade receivables drift past terms Reported
What it is. Trade accounts run net 30 through QuickBooks, some run past 60 days, and nobody follows up. "The founder's rule, don't hassle good accounts."
Evidence. Interview only: "A few accounts run sixty plus. We let it slide, they always pay eventually." No aging report was provided or reviewed, so amounts and account count are Unknown.
Mechanism. Cash timing rather than lost sales: with about 30 active trade accounts, slow-paying balances quietly finance customers' projects at the business's expense.
Impact. Not sized; no documents. Listed because the owner named it and the fix costs almost nothing.
First fix. The bookkeeper pulls the QuickBooks A/R aging report on her next Tuesday and sends monthly statements to every account over 45 days. A statement is not hassling; it is bookkeeping.
Automation, once proven. QuickBooks can send statements and reminders on a schedule once the first manual pass shows which accounts need them.
What would upgrade this to Confirmed. The aging report itself. If over-60 balances are trivial, this drops off the list entirely.
The Fixes, In Order
Practical order, what each fix takes, and what should be measurable after each one.
- Call the city public works department (this week, one phone call).
The $38,500 quote is open, the Phase 1 deadline is late September, and the thread has been silent since July 1. Measurable: a yes, a no, or a real timeline, instead of an open row. - Quote follow-up sequence (week 1, one meeting plus a shared sheet).
Three touches per quote, the sales lead owns it, every quote and touch logged. Start with the two hanging now (one customer, another customer). Measurable in 30 days: touches logged per quote, and the "no response" share against the current 5 of 15. - Inquiry ownership map and intake sheet (weeks 1 to 2, one page plus a habit).
Owner per inquiry type; everything from all three inboxes and voicemail logged the day it arrives; two-business-day rule for spec or pricing packs. Measurable: zero unanswered inquiries on the next thirty-day export, against at least five in this one. - After-hours phone handling (week 2, an afternoon).
New greeting with a promised return time; morning callback list worked to zero. Measurable: returned-call rate on voicemails, currently 6 of 8 in the sample week with 2 late. - Turn on webstore cart recovery (week 2, about half an hour).
Enable the built-in recovery email; weekly review of carts and wish lists; personal touch on the biggest carts. Measurable: recovered cart revenue on the platform's own report, against $0 today. - Response standard and travel coverage (week 3, one conversation).
Same-business-day standard, Monday-10-am rule for weekend arrivals, named cover during market weeks. Measurable: reply lag on the next inbox export. - Receivables pass (month 2, one bookkeeping session).
Aging report, monthly statements over 45 days. Measurable: days-outstanding trend quarter over quarter.
Every item on this list is executable by the business's own team without hiring anyone. The measurements come from the same four reports this audit used, so progress is visible in the company's own numbers.
What Can Wait, And The Next Step
Six things that look urgent and are not, and the one step that is.
- Saturday hours. Tested February to August 2023 and did not pay for the staffing (Reported). The after-hours leak is a capture-and-return problem, not an opening-hours problem. Do not revisit until the callback list shows real weekend buyer volume.
- A website rebuild or new inquiry forms. The Snapshot reasonably suspected the site's missing "way in" was the core leak. The internal evidence revises that: the city public works department found the site and wrote in anyway; the loss happened after arrival. A single project-inquiry form is still worth adding, but it ranks behind ownership and follow-up, because a form that lands in an unowned inbox just moves the leak.
- Buying a CRM. The one-sheet intake and quote logs prove the habits first. Software bought before the habit exists becomes another unread inbox.
- Missed-call text-back service. The natural automation for the 33 monthly hang-ups, but only after the manual callback list proves someone owns returned calls.
- Replacing the paper design-session calendar. Double-bookings are occasional (Reported) and cheap. Fold it into whatever shared sheet the intake habit settles on.
- About-page and policy-page cleanup. The Snapshot noted out-of-date location copy and a tax reference for another state. Worth an hour someday; it does not move revenue this quarter.
Evidence Reviewed
Everything this report rests on, dated, with its limitations stated.
- Carrier call log, both lines, June 8 to July 8, 2026 (415 calls)
- info@ inbox export, 30 days, reply status owner-marked
- sales@ inbox export, 30 days, reply status marked by the sales lead
- The first-name address inbox export, 30 days, reply status owner-marked
- Quote log, last 15 quotes with outcomes, QuickBooks plus owner memory (April 21 to July 1, 2026)
- Webstore back office report, June 8 to July 8, 2026, transcribed from screenshots
- Voicemail transcriptions, week of June 22 to 28, 2026, with return status
- Forwarded threads: the city public works department street lighting, an interior designer trade signup, whole-house remodel customer quote
- Owner interview, recorded and transcribed with consent, July 9, 2026
- Lighting Showroom Revenue Leak Snapshot, prepared July 11, 2026: public-source review of the company website and ten nearby competitors
- The company website, re-checked July 12, 2026; the site loads through a storefront script, so page details are cited from the July 11 Snapshot review
Reply-status columns in the inbox exports were marked by the owner and the sales lead during intake and are owner accounts, not verified message by message. No raw client evidence is reproduced in this report beyond the quotes shown, and no evidence files are included in the deliverable folder.