Coffee Shop Operations
Fernwood Coffee Roasters · Coffee shop · Eugene, OR
Marisol Brennan-Okoye owns a coffee shop and uses this to see menu margins, what is below par, what is being wasted, which machines are due for service and what is on order.
Use this templateMenu board
MenuFlat white
Oat milk latte
Americano
Pumpkin spice cortado
Pour-over, single origin
Cold brew
Iced chai
Earl grey
Brown butter croissant
Seeded banana bread
Almond croissant
Egg and cheddar sandwich
Fernwood house blend, 12 oz
Tables
Menu
13 sample rows · 10 columnsWhat the shop sells, with price, cost and margin.
| Drink or food | Status | Category | Price (USD) | Cost to make (USD) | Sold last week | Added |
|---|---|---|---|---|---|---|
| Flat white | Core | $4.75 | $1.05 | 410 | — | |
| Oat milk latte | Core | $5.50 | $1.40 | 365 | — | |
| Americano | Core | $3.50 | $0.40 | 150 | — | |
| Pour-over, single origin | Core | $5 | $1.20 | 120 | — | |
| Cold brew | Core | $4.75 | $0.90 | 205 | — | |
| Iced chai | Seasonal | $5.25 | $1.10 | 95 | — | |
| Earl grey | Core | $3.75 | $0.35 | 40 | — | |
| Brown butter croissant | Core | $4.25 | $1.30 | 260 | — | |
| Seeded banana bread | Core | $3.75 | $0.95 | 115 | — | |
| Egg and cheddar sandwich | Core | $8.50 | $2.80 | 98 | — | |
| Fernwood house blend, 12 oz | Core | $16 | $7.20 | 64 | — | |
| Pumpkin spice cortado | Seasonal | $5.75 | $1.50 | 0 | — |
Supplies
11 sample rows · 12 columnsEverything stocked, counted against par.
| Supply | Category | Counted in | On hand | Par level | Last counted | Last ordered |
|---|---|---|---|---|---|---|
| House blend beans | lb | 38 | 60 | Oct 17, 2026 | Oct 12, 2026 | |
| Single origin, Guatemala | lb | 14 | 20 | Oct 17, 2026 | Oct 9, 2026 | |
| Whole milk | gallon | 12 | 18 | Oct 17, 2026 | Oct 16, 2026 | |
| Oat milk | case | 3 | 5 | Oct 17, 2026 | Oct 14, 2026 | |
| Vanilla syrup | bottle | 4 | 4 | Oct 17, 2026 | Sep 28, 2026 | |
| Chai concentrate | carton | 2 | 6 | Oct 17, 2026 | Oct 7, 2026 | |
| Croissant dough | tray | 3 | 6 | Oct 17, 2026 | Oct 17, 2026 | |
| Banana bread loaves | loaf | 5 | 6 | Oct 17, 2026 | Oct 17, 2026 | |
| 12 oz hot cups | sleeve | 22 | 25 | Oct 15, 2026 | Oct 6, 2026 | |
| Compostable lids | sleeve | 9 | 20 | Oct 15, 2026 | Oct 6, 2026 | |
| Espresso machine cleaner | box | 2 | 2 | Oct 10, 2026 | Sep 18, 2026 |
Waste log
9 sample rows · 8 columnsEverything thrown away, with the reason and the value lost.
| What was wasted | Date | Quantity | Reason | Value lost (USD) | Menu item | Logged by |
|---|---|---|---|---|---|---|
| Unsold croissants | Oct 17, 2026 | 6 | $7.80 | Brown butter croissant | Wilhelmina Tan | |
| Banana bread slices | Oct 16, 2026 | 4 | $3.80 | Seeded banana bread | Wilhelmina Tan | |
| Milk shot dropped | Oct 16, 2026 | 1 | $1.10 | Flat white | Cyrus Delacroix | |
| Wrong drink made, iced chai | Oct 15, 2026 | 2 | $2.20 | Iced chai | Dexter Halvorsen | |
| Cold brew batch off taste | Oct 14, 2026 | 3 | $18 | Cold brew | Anaya Petrovic | |
| Egg sandwiches unsold | Oct 13, 2026 | 5 | $14 | Egg and cheddar sandwich | Wilhelmina Tan | |
| Oat latte remakes | Oct 12, 2026 | 3 | $4.20 | Oat milk latte | Cyrus Delacroix | |
| Croissants unsold | Oct 11, 2026 | 9 | $11.70 | Brown butter croissant | Wilhelmina Tan | |
| Pour-over spilled during training | Oct 9, 2026 | 2 | $2.40 | Pour-over, single origin | Anaya Petrovic |
Equipment
7 sample rows · 9 columnsThe machines that make the coffee, with service dates.
| Machine | Condition | Kind | Last serviced | Next service due | Technician | Added |
|---|---|---|---|---|---|---|
| Two-group espresso machine | Working | Aug 9, 2026 | Nov 7, 2026 | Bellwether Coffee Service | — | |
| Main grinder | Needs service | May 11, 2026 | Oct 8, 2026 | Bellwether Coffee Service | — | |
| Decaf grinder | Working | Jul 20, 2026 | Jan 16, 2027 | Bellwether Coffee Service | — | |
| Batch brewer | Working | Sep 3, 2026 | Mar 2, 2027 | In-house | — | |
| Undercounter fridge | Working | Apr 1, 2026 | Apr 1, 2027 | Coldline Repair | — | |
| Pastry oven | Out of order | Oct 3, 2025 | Oct 3, 2026 | Coldline Repair | — | |
| Walk-in cooler | Working | Jun 20, 2026 | Dec 17, 2026 | Coldline Repair | — |
Orders
6 sample rows · 9 columnsOrders sent to vendors and when they arrive.
| Order | Status | Placed | Arrives | Order total (USD) | Vendor | Placed by |
|---|---|---|---|---|---|---|
| Weekly milk and dairy | Placed | Oct 17, 2026 | Oct 19, 2026 | $286 | Cascadia Dairy | Cyrus Delacroix |
| Cups and lids restock | Draft | — | Oct 24, 2026 | $410 | Greenware Packaging | Dexter Halvorsen |
| Roastery beans, wall and bar | Placed | Oct 16, 2026 | Oct 20, 2026 | $640 | Fernwood roastery | Dexter Halvorsen |
| Syrups and chai | Draft | — | Oct 15, 2026 | $198 | Lantern Beverage | Cyrus Delacroix |
| Cleaning supplies | Arrived | Oct 10, 2026 | Oct 13, 2026 | $74 | Tidy Supply Co. | Dexter Halvorsen |
| Weekly milk and dairy, last week | Arrived | Oct 10, 2026 | Oct 12, 2026 | $301 | Cascadia Dairy | Cyrus Delacroix |
Also included
- Service done
- Log delivery
Related templates
- Boutique hotelIronbridge Valley Hotel4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 row action · 1 agentImports
- Brewery Taproom DeskKingfisher Creek Brewing6 tables · 27 views · 1 form · 4 row actions · 1 agentLinked tables
- Coffee roasterGannet Wharf Roasters5 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 drill-down · 1 digest · 1 agentDimensions
- Coffee shopSilverbirch Valley Coffee4 tables · 6 views · 1 form · 3 dimension sets · 1 dashboard · 1 digest · 1 document · 1 notification · 1 agentImports
- Event venue kitchenThistledown Way Banquets4 tables · 5 views · 1 form · 1 dimension set · 1 dashboard · 1 digest · 1 notification · 1 stage rule set · 1 row action · 1 agentImports
- Food truckCactus Wren Taco Trucks6 tables · 7 views · 1 form · 3 dimension sets · 1 drill-down · 1 document · 1 notification · 1 stage rule set · 1 agentDimensions