Project presentation
Read aloud once, then adjust the wording to your voice. Blue cue boxes describe what to show on screen; do not read them aloud.
0:00–0:30 · The business decision
“For this project, I analyzed Button and Bear, a fictional online teddy-bear business choosing its next-quarter offer.
The founder had 3 options: keep the promotion, reset prices and shipping charges, or introduce a bundle. My goal was to improve operating profit while protecting inventory and a $15,000 cash reserve.
My first hypothesis was that the bundle would be the best choice.”
0:30–1:00 · Checking the data
“I used AI to review the financial workbooks, orders, and planning inputs. Independent AI agents challenged the calculations and recommendation.
We combined each order’s product lines before calculating shipping, so it wasn’t counted twice. All 10,800 orders reconciled to the monthly records. The original files stayed unchanged.”
1:00–1:40 · What Q3 revealed
“The first finding was that more orders did not mean more profit. Q3 orders beat budget by 20%, but operating profit was only about $5,500 against a $31,400 plan.
Extra volume added about $9,900 to profit. But discounts removed roughly $21,000, and higher shipping cost per order removed another $9,000. Smaller effects complete the reconciliation.
Those figures explain the financial gap. They don’t prove the promotion caused every change in customer behavior.”
1:40–2:50 · Why I chose Option B
“Next, I compared all 3 offers under base, upside, and downside assumptions.
In the base case, quarterly operating profit was about $9,000 for the current promotion, $49,000 for Option B, the price and shipping reset, and $51,000 for Option C, the bundle.
These are estimates. For example, the reset assumes 10% fewer orders.”
“Based on profit alone, the bundle looked best. But its lead was only about $2,200 before rounding.
We then asked: what if customers who already planned to buy both bears switched to the cheaper bundle? In that test, the bundle’s profit fell below the reset.
The case’s competitor examples also showed Nightlight’s delivered gift set at $48, versus $49 for our bundle. Those fictional snapshots provided context, not proof of demand.
That is why I changed my recommendation to pilot Option B before scaling.”
2:50–3:25 · Inventory and cash
“I also checked whether the business could fund the offers.
Base-case inventory purchases were $36,400 for the reset, versus $48,000 for the bundle.
In the bundle’s upside case, the supplier deposit pushed cash below the reserve, and key products ran out before replenishment arrived. The cash timing assumptions need confirmation before launch.”
3:25–4:00 · Recommendation and deliverable
“My recommendation is to pilot the price and shipping reset, then test the bundle against it before scaling.
I would track contribution per visitor to see whether better margins offset fewer purchases, while monitoring inventory and cash.
The deliverable is this dashboard and supporting workbook, with editable formulas, source references, and reconciliation checks.
AI helped test the evidence. My judgment was to change my initial hypothesis when the numbers showed that the bundle’s advantage was fragile.”

