JOSA.AI | Fictional classroom exercise

Outcome: Create an Excel workbook for the owner of a fictional donut shop to understand July and August 2026 sales and the amount left after direct product costs.

Context: Use only donut-sales-july-2026.csv, donut-sales-august-2026.csv. Each file has six product records. net_sales_usd is monthly product sales after discounts and refunds, excluding tax. direct_costs_usd is the monthly ingredients and packaging cost for the units sold; it excludes wages, rent, utilities and other overhead. Both dollar fields are already totals, so do not multiply them by units_sold. Each box is a separate sales unit. Box sales are not also included in individual-product rows.

Standard: Include three tabs: Source data, Product summary and Owner brief. Retain the month and source filename for each record. Summarize units, net sales, direct costs and amount left after direct costs by product. Keep individual donuts and boxes in separate groups. Do not combine donut and box quantities into one unit total. Use formulas for calculated amounts and summaries. Show dollars with two decimal places and label units clearly. The Owner brief should give three observations supported by the records, two possible next steps, and any limitations. Do not describe the amount left after direct costs as overall business profit. Flag missing information rather than guessing. Check that both months and all records are included, reconcile sales and direct-cost totals, and show how one product calculation works. Preserve the original files. Create the requested workbook only; do not send, publish, or change anything else.

First propose a short plan and identify essential questions. Wait for my approval before creating the workbook.