Turn a losing week into a plan
A worked example: describe a bakery that lost money with its week attached as a workbook, solve next week's plan, test it with what-ifs, verify one and compare them on a workspace.
Where: Models→+ New→Upload
Harbor Point Bakery lost money last week. It bakes sourdough loaves and croissants in one oven, buys flour and butter, and sells to walk-in customers and to Pier Cafe. This walk turns its numbers into next week's plan, checks the answer, and pressure-tests it before anyone acts on it.
Download the week: harbor-point-week.xlsx. Its eight sheets hold the recipes, what the vendors charge, the oven's 60 hours and costs, what each customer buys and pays, and delivery costs. They're listed on Start from your workbook.
Describe the bakery and attach the week
In the rail, click + New beside Models. In the new conversation, click Upload beside the message box and
choose harbor-point-week.xlsx, or drop it on the box. Its name shows above the box with Uploading, then
Added: it's in your Datasets now, and goes with your next message.
Type this and press Enter:
Harbor Point Bakery is a neighborhood bakery with one oven. We bake sourdough loaves and croissants, buy flour from Mill Supply and butter from Dairy Co-op, and sell to walk-in customers and to Pier Cafe. Last week we lost money. We plan one week at a time, and we want the plan for next week that makes the most profit. The attached workbook has our recipes, prices, oven hours and what each customer will buy.
Sending creates the model, named from your first words: Harbor Point Bakery plan (with a number after it, such as Harbor Point Bakery plan #2, if you already have a model by that name). Its page opens with the conversation on the left and The record on the right. See Describe your business.
Let RIA read the sheets
RIA reads the workbook while it works on what your words already say: the decision, and the one week the plan covers. In the conversation it says what it set up from your sheets and what it assumed where they're silent, such as no stock on hand at the start of the week. On the record's top card, Since your last message lists each part of the model it added from the workbook (buying flour, the oven, getting product to customers and so on).
To see what RIA took each sheet to be, open Details at the foot of the record, then Data: What each data sheet holds gives one sentence for each sheet. See Start from a workbook.
Answer what the sheets leave open
RIA asks in the conversation about what the workbook doesn't settle, with its possible answers numbered and the one it suggests marked. Type the number of your answer and send it, or say what's true in your own words; where the answers end RIA's message, they also show as buttons under it. RIA's questions differ from run to run. On one walk it asked whether the demand figures are the most each customer will buy or firm orders, then whether Mill Supply and Dairy Co-op can sell as much as the plan needs. These are the facts of this bakery to answer from:
- The plan covers one week, Week 1.
- There's no stock on hand at the start of the week, and nothing is kept for the week after.
- Flour and butter bought in the week can be baked that week, with no minimum order and no lead time.
- Mill Supply and Dairy Co-op can sell as much flour and butter as the plan needs.
- The demand figures are ceilings: each customer buys up to that many, and nothing more is promised.
- Holding flour and butter costs nothing.
Each open question also counts under Needs you on the record's top card ("1 answer needed in the chat before the build goes on."), with Go to the chat. See Answer what your sheets leave open.
Accept the objective
At Objective, RIA proposes the objective in a Your objective card: Maximize profit, with a sentence on
what it adds up (what both customers pay, less flour, butter, the oven's running and fixed costs, and Pier Cafe
delivery). Click Accept this objective. If it proposes something else, type Maximize weekly profit. in
"Or say what you would rather have" and click Reply.
Let RIA check the design and build
At Check, RIA reads the design back against your words and workbook. On the record, What this model will do
gives the Objective, what It decides, Over, which should be the one week, and Your workbook. If
Over says more than one week, tell RIA The plan covers one week: Week 1.
With your answers in, nothing waits on you: RIA moves on and starts the build itself, and the conversation says so. Had RIA changed, assumed or left out something you said, that row would wait on you with Keep it as it is; see Review the design.
The record's top card follows the build, with a line saying it's Building from your workbook. The build can stop to ask one more thing, such as whether stock may be left at the end of the week or whether a customer's demand may go short: the top card then reads The build stopped., and your answer in the conversation starts it again. See Build and baseline.
Check the Base by hand
When the build lands, Where it stands shows your objective over the Base figure: $1,422, next week's best plan on your numbers.
You can check it by hand. An oven hour earns most on walk-in croissants, then walk-in loaves, then Pier Cafe croissants, then Pier Cafe loaves. So the plan sells all 200 + 150 croissants (35 hours) and the 80 walk-in loaves (20 hours), and spends the last 5 hours on 20 of Pier Cafe's 40 loaves.
Ask what more oven time is worth
In the rail, under your model, click + New beside SCENARIOS. In the New scenario. conversation, type
What if the oven could run 70 hours a week instead of 60? and press Enter. Your message makes the
what-if, named from your words, and RIA says what it will change: the oven's hours, from 60 to 70, with its running
and fixed costs as they were. If that's right, type Looks right and send it.
When the run ends, RIA gives the result in the conversation, and the what-if's record shows Solved: $1,524, $102 above the base. with the two side by side. The extra hours fill every order, including the 20 Pier Cafe loaves that went short (5 hours, $5.10 each), and the oven runs 65 of its 70 hours.
Ask what a flour price rise costs
Click + New beside SCENARIOS again, type What if Mill Supply raises flour to $2.00 a kg?, send it, and
reply Looks right when RIA's change reads right (here RIA asks "Shall I run it?" with Yes and No under
it; Yes does the same).
It comes to $1,354, $68 below the Base: the plan doesn't change, and the same 85 kg of flour cost 80 cents more a kilogram.
Verify the one you'd act on
Click SCENARIOS in the rail to open the Scenarios list: Base and your two what-ifs, each with its result and its change against Base in percent. Click the oven what-if's row; it opens in the pane beside its conversation, headed The scenario. If the pane shows the record, click Back to the scenario. Then click Verify.
A drawer opens that says how far to trust the number: a confidence badge with its reason, the Result (shown rounded, $1.5K), the KPIs, and under Inputs your oven-hour change marked ← you (override). Export gives Evidence JSON or Evidence Markdown for the record. See Verify a result.
Put them side by side on a workspace
Click SCENARIOS in the rail again. Tick both what-ifs, and click Compare in the bar that shows 2 selected. eode opens a workspace with Base as the baseline, named after your model with · compare after it (Harbor Point Bakery plan #2 · compare on the walk), in the pane beside its own conversation. Click Focus at the top of the pane to give it the full width.
Scenario comparison sets the three objectives side by side, each what-if with its change against Base, then every KPI's change and a PROFIT IMPACT VS BASE chart. Financials comparison lays out the income statement for each. Base's comes to the same $1,422: Gross Sales $2,105, less Net Purchases $242, Labor $240 (the oven's running cost), Fixed Processing $150 and Distribution $51.
To arrange the tiles, ask RIA for more, or share the workspace, see Workspaces.
Related
- Start from a workbook: how RIA reads your sheets and what it asks
- Run a what-if and Read results
- Scenarios: the list, selecting and comparing
- Widgets: what each tile on the compare workspace shows
Quickstart
Describe a small bakery to RIA in one message, build and solve its plan, ask one what-if and open it in a workspace.
Start from your workbook
Hand RIA a planning workbook in a new model's conversation, see how each sheet was read, solve the week it describes, test a change to one of its values, and download your inputs.