I am opening (or running) an online business. I have attached the Ecommerce Business Plan Template and Operations Starter Kit from businessconsultant.services. Help me turn it into my own plan for my categories, my warehouse and my buying budget, using only my real numbers. 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 rent, wage, landed cost, order value, order count, supplier term, percentage or benchmark. 2. The numbers in the kit, including the example's categories, orders and buying budget, 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: ...] and tell me which quote, order export, sales report or calculation gives the real number. Label my own estimates MY ESTIMATE. 4. Use these formulas exactly, and show your arithmetic for every number you calculate: - Monthly sales for a category = orders a month times the average order value. Each month's expected sales = full-run category sales times the ramp percentage times the seasonal percentage. - Net sales exclude sales tax. Labor = the salaried crew and the hourly crew, payroll taxes and benefits, plus a market wage for my own hours, management and buying. 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 orders a month = (monthly fixed costs, principal and other recurring cash out minus the monthly contribution from the other two categories at planned full-run sales and own contribution ratios, each category's line-13 share plus its share of lines 14 to 17) divided by the contribution from one average order in your fast-turn consumable category, the one you name in round A of the prompt on page 17, and never the example's (write the category you choose in the margin beside this formula). If the other lines already cover fixed costs and principal, report 0 and say so; never report a negative break-even count. Monthly capacity = the stock the racking, the pick faces and the reserve location hold, turned at your planned annual turns and divided by 12, converted to orders at each category's average cost; the buying budget on page 9 is the cash version of the same limit. - 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 a year at month 12's ramp and bookings, seasons applied (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 a late-starting fixed line at its full 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 (stock orders, 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. Enter supplier payments on the terms I actually get. In the slow-start case, every month's sales 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 is charged per parcel and falls with the orders). 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, employment, wage or lease advice. Do not name laws, approval types, 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, and make no claim about product safety or suitability for a use. For the market and marketing sections, use only what I tell you, and list the facts I should gather, such as the category demand and the competing offers. 7. Work every total line by line and recheck it in total. 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. Do not ask for names, home addresses, bank account or tax ID numbers. 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 does not need the inputs for pages 7, 9 and 10. 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. Concept, customer and category mix, warehouse and racking, the categories I carry and the racking each one takes, whether I buy on import, and which of my categories is the fast-turn restock line. b. The sales build: for each category, the orders a month and the average order value, the days I ship each week and the dispatch cutoff; a ramp percentage for every month from 1 to 12 (ask me to confirm any month I leave out); a seasonal percentage for each month; 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). Give counts at full run, with month 1 as my opening month. Give the evidence behind each count (the platform's own order export, or the records of a business you have run). c. For each merchandise category: orders a month at full run, the average order value, and the average cost of an order at cost, plus the margin the category has to hold. Then wait for my answers. Round B, costs, the startup budget and my lender: d. The startup budget: an amount and its source (contractor, racking or equipment quote, or calculation) for each line on page 5, from the fit-out to the contingency. e. Monthly fixed costs for each numbered line on page 8, from rent (line 1) to bank charges and renewals (line 12), including loan interest and my market wage for buying and merchandising (line 4; my hours on the pick line go in line 3 or 14 at a crew wage), 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. f. Variable cost shares of net sales for lines 13 to 17: line 13, cost of goods sold, blended across the three categories (set by the category costs); line 14, fulfillment: postage, packaging, pick-and-pack labor and returns processing; line 15, card and wallet processing fees; line 16, shrink at cost (set by the stock counts); line 17, marketplace commission and coupon discounts; and any sales line whose own shares differ, given for that line. g. My annual inventory turns (a year of cost of goods divided by average stock at cost), stock on hand at cost on the first day of the plan month, stock already ordered and arriving this month at cost, the supplier lead time in days, and the supplier payment terms in days. h. For each category: book stock at cost and counted stock at cost at my last physical count, and the number of months since the count before that. 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 customers pay me (at checkout by card or wallet, and how many days a settlement takes), any marketplace remittance schedule, any deposits I collect on pre-orders, and when the business pays its suppliers, including how many days the supplier allows me and when the invoice falls due. Say when each sales line pays me. 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, conveyor and vehicle replacement and stock build-up. m. Cash on hand on opening day after all startup spending, fit-out 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 online business, drafted from my answers, with gaps marked [NEED: ...]. 2. The sales build by category and month, with annual sales and the stock and cash capacity check from page 6. 3. The completed startup budget with the total, showing the fit-out and equipment first. Size the reserve by the page 5 rule, then add the peak-season purchase you computed for page 9 to it before any peak order goes in, keeping that purchase out of the supplier payments and stock build-up rows you enter on page 11 so the cash is counted once; 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 orders a month (use cash break-even); rent share and planning debt service coverage at full-run sales and at the month-12 run rate, 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 (month 12's ramp held, 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 a sales tax memo for each month: collected, remitted, and owed at month end (last month's owed + collected minus remitted), kept out of closing cash. 6. Gross margin and markup for each category and blended across the business, the category carrying the most sales and the one carrying the weakest margin, and the cost-of-goods share the rest of the plan uses. 7. The month's open-to-buy at cost, whether the business is over-bought or under-bought, months of stock on hand, and the date the cash leaves for an order placed today. 8. Shrink in dollars by category, the annualized shrink rate, the shrink share of sales the plan carries, and the count discipline the kit recommends. 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 order export or quote I should verify, and every question that needs a qualified professional.