Latihan Nyata · Data

Work out margins for 10 shop products

The owner of an invented cake shop sells 10 products but does not know which ones earn the most. Lay out ingredient, packaging and overhead costs per product, then use AI to build a margin table. Done means you can explain every margin figure with a formula, and you have recomputed at least three products with a calculator.

Difficulty: Easy
Time: About 1.5 hours
Tools: spreadsheet, asisten AI percakapan
Fits: AI Foundations, Small Business & Sales

Learn it first: Working out price, margin and fees

What you hand in

A cost table per product: ingredients, packaging, share of fixed costs and selling price, all invented figures.
A margin table in rupiah and percent, sorted from highest, with the formula visible in each cell.
Hand calculations for three products and a note on whether they match the table.
Three pricing or recipe suggestions you chose yourself from the result, each with its reason.

0 of 4 ticked