Guided project · 6 steps Cellwise Plus
Farmers market sales report in Excel
Turn what you brought and what you took home into units sold, sales by product and sell-through.
You will use: SUM, SUMIF, MAX, MATCH, INDEX
Starting data
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Product | Category | Price | Brought | Left | Sold | Sales | Sell-through | Market total | |
| 2 | Heirloom tomatoes (lb) | Veg | 4.5 | 60 | 8 | Vegetable sales | ||||
| 3 | Salad mix (bag) | Veg | 6 | 40 | 3 | Top product by sales | ||||
| 4 | Garlic (head) | Veg | 2 | 80 | 22 | |||||
| 5 | Eggs (dozen) | Eggs | 6 | 30 | 0 | |||||
| 6 | Sourdough (loaf) | Baked | 9 | 24 | 5 | |||||
| 7 | Honey (jar) | Pantry | 12 | 18 | 11 | |||||
| 8 | Sweet peppers (lb) | Veg | 3.5 | 30 | 9 | |||||
| 9 | Cut flowers (bunch) | Flowers | 10 | 20 | 2 |
Build it step by step
Step 1
Units sold are what you brought minus what you took home. Write it in F2 and fill to F9.
Step 2
Sales for each product: units sold times price. Write it in G2 and fill to G9.
Step 3
Sell-through is the share of what you brought that sold. Write it in H2 and fill to H9.
Step 4
Total the market day in K1.
Step 5
How much came from vegetables? Add up Sales where Category is "Veg", in K2.
Step 6
Which product brought in the most money? Return its name in K3.