I run, or am opening, a small independent optometry practice. Attached is the Optometry Business Plan and Operations Starter Kit from businessconsultant.services; help me make it my own plan with my numbers only. Follow these rules for the whole conversation: 1. Use only numbers I give you, or numbers you calculate from mine with the formulas below. Never invent a fee, allowed amount, rate, wage, percentage or benchmark. 2. The numbers printed in the kit are worked examples. Never use them as my numbers, not even as a placeholder. 3. If a number you need is missing, ask me for it. If I ask you to estimate or use typical figures, write [NEED: ...] instead and tell me which quote, record or calculation will give me the real number. If I give you my own estimate, label it MY ESTIMATE. 4. Use these formulas exactly, and show your arithmetic for every number you calculate: - Monthly sales = exams (page 7) x clean collectible per exam (page 9) + recovered denials after each payer's lag + each optical line's exams x capture x net sale (page 10). Year 2 holds new patients at month 12's pre-season level, plus returns due (page 7). - Net sales exclude sales tax. Labor = wages, payroll taxes and benefits, plus a market wage for the owner-optometrist's exam and management time (line 4), never also in line 3 or 14. Shift hours count as cash even if I skip my own pay, so the plan still holds when I step back from the work; only line 4 may go undrawn, and Tests 1 and 6 count it anyway. - Contribution margin ratio = 1 minus variable cost share; a line's contribution = its sales times its own ratio. Operating break-even sales = fixed costs divided by contribution margin ratio. Cash break-even sales = (fixed costs with line 4 even if I do not draw it, plus monthly loan principal and any recurring other cash out) divided by contribution margin ratio; only the cash forecast drops an undrawn wage. A blended ratio holds only at its own sales mix: name that mix beside each break-even, and recompute from each line's own contribution when a what-if changes one line. Loan interest is fixed; principal is not an operating cost, so it never enters operating break-even or operating profit. - Weekly = monthly times 12, divided by 52. Daily = weekly divided by days open per week. - Break-even exams = (fixed costs with line 4 even if undrawn, plus principal and other recurring cash out) divided by one exam's contribution with its optical and recovered denials; 0 if covered. If the other lines already cover fixed costs and principal, report 0 and say so; never report a negative break-even count. Optometrist minutes a month = days x hours x 60; lane minutes = lanes x open hours x 60 x days; pretest minutes = technician hours x 60; minutes used = exams in the settled peak month x minutes per exam on each. - Rent share = line 1 divided by net sales. Planning debt service coverage, before income tax and equipment replacement = (full-run sales times contribution margin ratio, minus fixed costs other than loan interest) divided by (loan interest + loan principal). - Month-12 run rate = average monthly sales over year 2 (new patients held at month 12's pre-season level, returns already due counted; page 7, seasons included), not month 12's own sales. Test 1 needs that rate at or above cash break-even and my floor held 24 months; Test 3, coverage at full run and at that rate. - Test 6 = 12 months of (full-run sales minus their variable costs, minus full-run fixed costs, line 4 included, minus principal), seasons applied to every sales line but booked lines, which run in their own months, and seasonal fixed lines at each month's amount. The cushion to set aside = the largest fall in running net cash from a high to any later low, the year run twice so a dip can cross into month 1 (zero if it never falls). - Full-run figures (break-even, coverage, floor) take booked lines at full bookings averaged over 12 months, a late-starting fixed line at its full amount, a fixed line that steps down after year 1 at its later amount, and a seasonal fixed line at its year average. - For pages 7, 9 and 10, use the formulas printed on those pages of the attached kit, exactly as written, with my own figures. - Cash forecast: closing cash = opening cash + cash in minus cash out. Month 1 opening cash = cash on hand on opening day after startup spending is paid. Place every receipt and payment (deposits, supplier invoices, startup bills, funding) in the month the cash moves. Income tax set-aside, equipment replacement and stock build-up go in their own row. Open month 1 with the cash I give; report the page 5 two-pass size beside it, never as a substitute. Place each receipt in the month my payment terms say, or mark [NEED: payment timing]. Collect each payer on its own split (page 9) and each optical line on its own split (page 10). In the slow-start case, every month's sales on every line are the tested share of expected sales; fixed costs, other cash out, principal, bills and funding stay as planned; all variable lines fall with sales, each figured from the slow-start sales of the same month, on the same payment timing as the expected case (fair because line 14 holds only hours I would cut). Runway = the number of consecutive future months, counted from the latest closed month (before opening, from opening day), before the first month in which closing cash falls below my cash floor. 5. Do not give legal, tax, clinical, billing, payer contract and patient privacy requirements, employment, wage or lease advice. Do not name laws, programs, agencies, government fees or wage rates, even as examples. When my question touches these, write only "Review this with a qualified professional" and continue with the rest. You may record and use figures I give from my own records, such as my sales tax rate and when I remit it, without checking, interpreting or advising on them. 6. Do not quote statistics, studies or sources that are not in the kit. For the market and marketing sections, use only what I tell you, and list the local facts I should gather. 7. Work every total step by step and recheck it a second way. In the cash forecast, show the arithmetic for month 1, one later month and the year total; give plain numbers for the other months. 8. If a formula would divide by zero or a contribution margin is zero or below, write N/A, say why, and do not continue that calculation. If my lender defines coverage differently, show both results and label each. If cash never falls below my floor in the forecast, write the runway as more than 24 months; otherwise give the runway in months and, separately, the first month below it, counting year 2. With no loan, Test 3 passes. 9. Use business figures only. Never include or paste patient records, billing or claim exports, screenshots, dates of service, names, member or account numbers, free-text notes or small groups that could identify a person. If a report you received holds patient-level detail, do not paste it; enter only the totals you need. Never paste login details. 10. Mark every output: Draft for my own planning. Not for a lender or investor until a qualified accountant has reviewed it. 11. If your full answer would be very long, deliver outputs 1 to 4 first, then stop and ask me to type "continue" for the rest. 12. Build the cash forecast month by month from the sales build, the cost lines, my payment terms and my opening cash; it needs only the page 7, 9 and 10 results I gave, not the tables. Each month: cash in = sales receipts plus money arriving; cash out = each variable cost, calculated from the sales that created it and placed in the month it is paid under my terms, plus fixed costs (lines 1 to 12, with line 4 only if I draw it in cash), plus loan principal, startup bills and other cash out. Loan interest is already in line 5; never add it again. Supplier payments follow the cost of what I sold plus any stock build-up I give; if I buy ahead or carry supplier balances, ask me for purchases and payments by month instead. If you can run code, do every calculation in code. Step 1. Before you write anything else, ask me for the inputs below in three rounds, one message per round. Ask round A as one numbered list, then wait for my answers. When I answer, ask round B and wait; then round C and wait. Start Step 2 only after I answer round C. Round A, sales, capacity and evidence: a. Exams and fees, the payers I accept, the office, lanes and exam hours, new patients and where they come from, how patients return, the optical lines, the staff with hours and pay, and days open per week. b. Sales build: the page 7 panel inputs in the next item, the page 10 optical inputs in round B, and the slow-start percentage I want to test (this kit sets a 70 percent stress test, a kit rule rather than my estimate; use it unless I give evidence for a higher share). Never daily; the page 7 panel sets the exam line's count. Give counts at full run, with month 1 as my opening month. Give the evidence behind each count (site counts, comparables, signed orders or my history), and the sales lines (exams, recovered denials, frames, lenses, contacts) follow the page 7 panel built from item c, so give no other monthly counts for them. c. New patients each month 1 to 12 and the season index; shares due back after 12 and after 24 months; annual attrition; full-run exams a month and the steady new patients that hold it (N = full run x (1 - (share at 12 x (1 - x)^12 + share at 24 x (1 - x)^24)), where x is the monthly attrition); exam, lane and pretest minutes, lanes, and doctor and technician hours. Then wait for my answers. Round B, costs, the startup budget and my lender: d. Startup budget: an amount and its source (landlord quote, contractor quote, equipment quote, frame supplier quote or calculation) for each line on page 5, from the build-out to the working capital reserve and contingency. e. Monthly fixed costs for lines 1 to 12 on page 8, including rent, the optician, technician, front desk and billing, software, insurance, loan interest and my market wage as the optometrist; whether I draw that wage in cash; and my monthly loan principal. Give interest and principal as year 1 monthly averages for break-even and coverage, and, for the cash forecast, any payment, fixed line or other cash line that changes in months 1 to 24 (a payment holiday, a balloon payment, a rent step) with its month. My market wage as the optometrist covers exam and management time (line 4), never also in line 3 or 14. f. Variable cost shares of net sales for lines 13 to 16: line 13, optical cost of goods, each line at its own share; line 14, hourly help above the minimum staff that moves with exams; line 15, card processing, as an effective share of all sales; line 16, unplanned costs; and any sales line whose own shares differ, given for that line. g. For each payer: my fee and its allowed amount for an exam, its share of my exams, the share the payer pays and the share the patient owes, its first-pass denial share, the share of denials I recover and how many months later, the share of patient balances I write off, and the share of each month's claims it pays in that month and in each later month. For the cash forecast, collect each payer and each optical line on its own split; never reuse the kit's printed blend. h. For each optical line: capture on exams, average net sale, cost-of-goods share and the share collected in the month of sale and each later month. i. The debt service coverage ratio my lender requires and how the lender calculates it, if I know them. Then wait for my answers. Round C, cash timing, sales tax, deposits and Gate 0: j. Payment terms: when each payer pays (the share of a month's claims paid that month and in each later month), when patients pay their share and their optical orders, when denied claims are paid after rework, and when staff, the lab and frame suppliers are paid. k. For every other cash line (payroll, card settlements, insurance, loan payments, rent and fixed bills), when it is paid, or confirm it is paid in the month it is incurred. l. Monthly cash out beyond operating costs: income tax set-aside, equipment replacement and frame and contact lens stock build-up. m. Cash on hand on the first day the practice opens after all startup spending, startup bills still to pay by month, owner money or loans still to arrive by month, and my minimum cash floor (at least one full-run month of fixed costs plus principal). n. If I am already open: what customers owe me and what I owe suppliers and staff, each by the month it will be paid, deposits I already hold, and sales tax already owed with its payment month. o. Sales tax: the rate I collect on taxable sales, from my own registration, which sales lines (or what share of each) are taxable, and when I remit what I collect (each month, each quarter or another schedule), so the forecast holds collected tax apart until it is paid. p. Gate 0: which agreements, quotes and approval requirements I already have in writing. Then wait for my answers. Step 2. When I answer, produce these as plain tables I can copy back into the kit: 1. Business plan sections 1 to 8 for my practice, drafted from my answers, with gaps marked [NEED: ...]. 2. The sales build by line and month (exams, recovered denials, frames, lenses and contacts), with annual sales and the capacity check from page 6. 3. The completed startup budget, line by line as on page 5, with the total. Size the reserve by the page 5 rule; if I gave another, show both and the result for each. 4. Operating and cash break-even per month, per week and per day open; break-even exams a month (use cash break-even); rent share and planning debt service coverage at full-run sales, labeled before income tax and equipment replacement, and on my lender's definition too if I gave it. 5. The 12-month cash forecast for the expected and slow-start cases, in thousands of dollars to two decimals (51.25 means $51,250) to match the kit, with, for each case, the first month below my cash floor and the first month below zero, and the runway; the second year's lowest closing cash (new patients held at month 12's level and the returns already due counted, page 7 Year 2 exams, each month with its own season, not a flat average); any extra reserve the slow start needs; and the Test 6 cushion, with whether the page 5 buffer covers it (add any excess to the reserve). Add memo rows for each month; they track amounts owed and do not change closing cash: sales tax collected, remitted and owed at month end (last month's owed + collected minus remitted), and claims owed by payers (last month's + billed minus paid), money not yet in the bank. 6. The panel by month (new, due back, exams) for months 1 to 24, the 12 year-2 exam figures, the steady new patients for full run, and capacity used at the settled peak; then, if the month-12 run rate falls short of cash break-even, the extra new patients every month from month 1 on (the same number added to each month's plan and held into year 2) at which it reaches break-even, found by trying values in code. Shares must lie between 0 and 100, return shares must not exceed 100 in total, and payer shares and every split must total 100; otherwise mark [NEED: corrected shares]. 7. The payer table with clean collectible per exam, the claims owed month by month, and what the waiting costs in cash: the lowest, over 24 months, of closing cash plus that month's claims and balances owed, minus the lowest closing cash, with the second year's 12 closing balances printed (receipts keep arriving on their splits across the year end). 8. Optical sales and cost of goods by line and month, and the contribution each line adds per exam. Then, over 24 months: the lowest closing cash and its month, the first month below my floor and the first below zero, and the extra opening cash that would hold the floor through month 24 (my floor minus that lowest close, rounded up to $100; 0 if none). 9. The kit's page 4 check: Gate 0 and pass or fail for each of the six tests with the reason (if Gate 0 fails, the result is not ready), and the overall result: not ready if Gate 0 fails, with no color; otherwise green, amber or red under the page 4 rules. 10. A final checklist: every MY ESTIMATE figure, every [NEED: ...] gap, every payer term, capture rate or new-patient count I should verify, and every question that needs a qualified professional.