top of page

CASE STUDY · Inventory Management 

How much should I order? Which SKU is the best value? Do I have enough cash? 3 questions a CEO asked.
Retail and wholesale inquiries can be answered in 10 minutes.

Answer these questions with Business Play, which combines Data Science + Finance — telling you how much your business can invest before impacting its liquidity.

image.png
  • The problems that every retail and wholesale CEO faces.

Every month, the CEO answers this question "by guessing."

Every day without a decision-making system costs money. These three problems account for 80% of avoidable inventory losses.
01

Ordered too many items.

Funds were locked in slow-selling stock, inventory costs accumulated, and price reductions became the only solution, eroding margins built up over months.

02

Risk of stock running out.

Empty shelves, customers switch to competitors, brand trust wanes, a single stock depletion event costs more than maintaining a complete safety stock.

03
 

Purchasing based on feelings.

Experience, spreadsheets, and intuition. No framework, no financial modeling, no verification. AI, just hope.

  • THE FRAMEWORK · GOLDEN EQUILIBRIUM

Opportunity + Financial Readiness = Sweet Spot

Combining Data Science with Financial Expertise — reveals what kind of Magical Creature your business is and how to navigate the game.
Calculated_ambition.png

Calculated Ambition

Financially secure, but lacking the lens to seize opportunities — opportunities are steadily growing.

LOW OS · HIGH FRS

Handle_the_ski.png

Handle the Ski

A rare balance: both opportunity and finances are in place — invest proactively.

HIGH OS · HIGH FRS

Dinosaur

Both sides are tired and need to reset before continuing.

Dinosaur_hoping_for_luck.png
Unicorn_Mistake_Step.png

Unicorn

Surfing offers high potential, but the burn rate is worrying — it's too risky.

HIGH OS · LOW FRS

← Oppotunity Score (OS) →

← Financial Readiness (FRS) →

  • HOW IT WORKS · STEP-BY-STEP

From 4 data sources to a secure Purchase Order.

Every step runs on Streamlit-in-Snowflake — your data never leaves your Snowflake account.

01

The system provides the safest numbers for investment right now.

It's not just about "should buy"—but how much can you afford to buy without dropping your Quick Ratio below a safe threshold?

  • Use 89% of the Budget Cap (฿1.2M) — according to V2 Rule 1.1 Sweet Spot.

  • Expected ROI +27% · Quick Ratio after investment = 1.18 (safe ≥ 1.0)

  • Cash Runway still has 5.2 months remaining after approval.

image.png
image.png

02

Which SKU is the Winner? Which SKU is the Cash Trap?

All SKUs are processed via Knapsack based on DESC unit margin. SKUs with high cost and low ROI are automatically removed with a reason understandable to the auditor.

  • 3 SKUs funded — starting at ฿670,000 today + ฿400,000 pending Feb 1.

  • Two SKUs were rejected based on numerical reasons, not feelings.

  • With just one click, you can export a Purchase Order CSV file to the Procurement department.

03

Please check against the Balance Sheet before placing your order.

Cash, AR, Debt, and Procurement Cap — all four are updated live, indicating whether your business is still in a safe zone after investment.

  • If the Procurement Cap touches the Hard Cap, the system will trigger a Diminishing Returns warning.

  • Every number can be manipulated according to the CEO's assumptions.

  • The Sweet Spot score is recalculated immediately after the correction.

image.png
image.png

04

Ask Smart Camel anything — every answer is tied to your Business Play.

ChatGPT doesn't always start from scratch. Every Smart Camel answer comes from your own OS, FRS, Sweet Spot, and V2 Rule.

  • Explain every number. Why was this SKU cut? What will the result be if the budget is increased?

  • We can immediately suggest a scenario for testing Quick Ratio sensitivity.

  • You can export the conversation results to your audit log.

  • WHY SNOWFLAKE · NOT GENERIC AI

ChatGPT is a magnifying glass . Business Play on Snowflake is the nervous system.

Typical AI starts from scratch every time it's restarted — Business Play learns daily from your data.
01 - DATA

Data Sovereignty

Your data is not exposed to the security perimeter of your Snowflake account; there is no data leak risk.

02 · LEARNING

Do · Learn · Improve

Every Business Play compares predictions with actual results every day.

• Automatically adjust the next business play session.

03 · HUMAN

Humans and AI working in the same app.

Power Ladder Data Scientists embed annotations in the results, such as "Head of Consultant sign-off" for every verdict before it becomes an action.

  • SOP DECISION GATES

Standard procedures before ordering products.

The SOP content was broken down into points that the CEO could easily read and the operations team could immediately use.
01
02

Identify business opportunities.

Determine the SKUs and quantities to be decided upon based on sales data, marketing stream, forecast, and inventory on hand.

Measure the uncertainty of the forecast.

Examine the prediction discrepancies and the impact if sales do not meet expectations.

Check Financial Readiness.

Compare cash required using the cash balance, debt obligation, quick ratio, and runway.

Calculate Sweet Spot Score

Combine Opportunity and Financial Readiness to indicate the security level of the order.

05
07
08
 

Assess the impact on cash flow.

Review the quick post-purchase ratio, cash runway, and budget sizing that won't compromise the business's liquidity.

เลือก SKU ที่ควรสั่ง

ระบบจัดลำดับ SKU ตาม demand, margin, ROI และ Cash Trap rule

Verified via AI Chat.

Ask about the reasons, quantity, risks, and waiting conditions before purchasing the next batch.

Approved on the Cloud

Running through Snowflake and Streamlit keeps data, models, and approval traces on a single platform.

bottom of page