Latihan Nyata · Data

A weekly warehouse stock summary

The warehouse head wants to know which items are running low without opening the whole stock book. Build an invented sheet of 30 items with opening stock, in, out and minimum level, then use AI to summarise it. Done means the list of items below minimum is correct by your own count, not just by AI's.

Difficulty: Easy
Time: About 1.5 hours
Tools: spreadsheet, asisten AI percakapan
Fits: AI Foundations, Logistics & Operations

Learn it first: Checking figures and spreadsheets

What you hand in

A 30-row sheet with columns for item code, item name, opening stock, in, out, closing stock and minimum level.
A one-paragraph summary and a list of items below minimum, sorted from most critical.
A recount note: closing stock for at least 5 items computed by hand or with your own formula, compared with AI's answer.
One paragraph on any mismatch you found and its cause.

0 of 4 ticked