Alley Corner CoffeeINTERNAL
INTERNAL · Gemini · 2026-10-22
Alley Corner Coffee — 2025 Annual Operating Report
Year in review · Supplier comparison · Customer feedback · Action plan
Prompt
I'm putting together the annual operating report for Alley Corner Coffee, an independent café in Taipei. Start with an outline.
Answer · Gemini
1. Annual Performance & Financial Review
- Revenue overview
- Full-year revenue and year-over-year growth
- Revenue mix by product line:
- Espresso drinks and single-origin pour-overs
- Light meals, desserts and retail beans
- Cost structure and gross margin
- Changes in raw-material spend (green beans, fresh milk, packaging)
- Cost-effectiveness of rent and staffing
2. Customers & Market Context
- Membership and repeat visits
- New members from the LINE official account and stamp cards
- Table turnover and average ticket at peak times (morning takeaway, weekend afternoons)
- Industry trends and benchmarks
- External food-and-beverage trends from Taiwan's Ministry of Economic Affairs statistics
- Social buzz (Google reviews and check-in trends)
3. Strategy & Resources for the Coming Year
- Product and experience upgrades: plan seasonal house blends and evaluate an in-house roaster to lift margins
- Operational automation and digital transformation:
- Introduce QR-code ordering to speed up the counter
- Host beginner pour-over workshops with the local community
- Build inventory management and a more flexible supply chain
Prompt
Compare three coffee bean suppliers in a table: origin, price per kg, minimum order, lead time and rating.
Answer · Gemini
| Supplier | Origin | Price per kg | Minimum order | Lead time | Rating |
|---|---|---|---|---|---|
| Green Origin Selects | Ethiopia, Colombia | NT$ 480 - 620 | 5 kg | 2 - 3 business days | 4.8 / 5.0 |
| Green Origin Selects | Kenya, Guatemala | NT$ 520 - 700 | 5 kg | 2 - 3 business days | 4.7 / 5.0 |
| Hiyori Estate Trading | Brazil, Sumatra Mandheling | NT$ 380 - 450 | 10 kg | 3 - 5 business days | 4.5 / 5.0 |
| Hiyori Estate Trading | Costa Rica (honey process) | NT$ 560 - 680 | 10 kg | 3 - 5 business days | 4.6 / 5.0 |
| Equator Direct Green Coffee | Honduras, El Salvador | NT$ 420 - 510 | 15 kg | 4 - 7 business days | 4.3 / 5.0 |
| Equator Direct Green Coffee | Yirgacheffe (direct trade) | NT$ 600 - 750 | 15 kg | 4 - 7 business days | 4.9 / 5.0 |
Prompt
Pick three representative customer reviews and analyse them, then close with a quote about coffee or running a business.
Answer · Gemini
"The Yirgacheffe pour-over is beautifully clean and floral, with a delicate citrus sweetness on the finish. Lots of light, quiet and comfortable — one of the few spots in Banqiao where you can really focus on work or reading."
— Google Local Guide review (5 stars)
"The cinnamon roll is crisp outside and soft inside, fragrant without being overpowering, and perfect with a hot oat-milk latte. The only downside: weekend afternoons get busy, and a table often means a 20–30 minute wait."
— Social media check-in (4 stars)
"Consistently good coffee, but I'd love prepaid cups or online pre-ordering for takeaway. On weekday mornings before work, the pour-over wait is a bit long."
— Morning takeaway customer (4 stars)
What the reviews tell us
- Core product and atmosphere are clearly valued: the depth of the single-origin pour-overs and the roast quality win over specialty customers, and the calm interior gives the shop strong "third place" loyalty and word of mouth.
- Desserts have real add-on potential: signature bakes like the cinnamon roll raise the average ticket and drive afternoon traffic — a natural pairing to promote.
- Peak-time service and flow need work: waiting time at peaks is the main pain point. Introduce LINE pre-ordering for takeaway and a fast lane for espresso and cold brew, so pour-over orders don't hold everyone up.
"Coffee is not just a drink; it connects people. A good coffee shop gives people a refuge from the noise of the city."
— Howard Schultz, former CEO and chairman emeritus of Starbucks, Pour Your Heart Into It
Prompt
Generate a daily sales log for the 60 days from 1 January 2025: date, day, cups, revenue, weather and notes.
Answer · Gemini
| Date | Day | Cups | Revenue | Weather | Notes |
|---|---|---|---|---|---|
| 2025-01-01 | Wed | 168 | NT$ 21,840 | Cloudy | New Year's Day; afternoon seating full |
| 2025-01-02 | Thu | 112 | NT$ 14,560 | Sunny | First workday; strong morning takeaway demand |
| 2025-01-03 | Fri | 125 | NT$ 16,250 | Sunny | Friday after-work dessert sets sold well |
| 2025-01-04 | Sat | 185 | NT$ 24,050 | Partly cloudy | Weekend afternoon full; ~20 min wait |
| 2025-01-05 | Sun | 172 | NT$ 22,360 | Sunny | Many pour-over orders in the afternoon |
| 2025-01-06 | Mon | 98 | NT$ 12,740 | Cloudy | Typical Monday; mostly morning commuters |
| 2025-01-07 | Tue | 105 | NT$ 13,650 | Partly cloudy | Restocked oat milk and packaging |
| 2025-01-08 | Wed | 110 | NT$ 14,300 | Rainy | Cold drizzle; hot lattes 70% of orders |
| 2025-01-09 | Thu | 115 | NT$ 14,950 | Sunny | Sold 4 bags of retail beans |
| 2025-01-10 | Fri | 130 | NT$ 16,900 | Partly cloudy | Small evening cupping session |
| 2025-01-11 | Sat | 190 | NT$ 24,700 | Sunny | Cinnamon rolls sold out early afternoon |
| 2025-01-12 | Sun | 178 | NT$ 23,140 | Sunny | Long stays; high average ticket |
| 2025-01-13 | Mon | 95 | NT$ 12,350 | Cloudy | Smooth morning takeaway, no backlog |
| 2025-01-14 | Tue | 102 | NT$ 13,260 | Partly cloudy | Trialled new Colombian green bean samples |
| 2025-01-15 | Wed | 108 | NT$ 14,040 | Sunny | Lunch takeaway from nearby offices |
| 2025-01-16 | Thu | 114 | NT$ 14,820 | Cloudy | A regular re-bought 2 lb of beans |
| 2025-01-17 | Fri | 135 | NT$ 17,550 | Partly cloudy | Takeaway orders peaked in the afternoon |
| 2025-01-18 | Sat | 182 | NT$ 23,660 | Sunny | Sunny weekend; patio fully seated |
| 2025-01-19 | Sun | 175 | NT$ 22,750 | Cloudy | Cooler evening; more hot drinks |
| 2025-01-20 | Mon | 92 | NT$ 11,960 | Rainy | Cold front; mostly regulars |
| 2025-01-21 | Tue | 100 | NT$ 13,000 | Sunny | Routine machine service and filter change |
| 2025-01-22 | Wed | 118 | NT$ 15,340 | Partly cloudy | Lunar New Year drip-bag gift boxes on pre-order |
| 2025-01-23 | Thu | 122 | NT$ 15,860 | Sunny | 15 more gift box pre-orders |
| 2025-01-24 | Fri | 140 | NT$ 18,200 | Sunny | Pre-holiday gifting boosted bean sales |
| 2025-01-25 | Sat | 165 | NT$ 21,450 | Partly cloudy | Travellers heading home bought drip-bag sets |
| 2025-01-26 | Sun | 150 | NT$ 19,500 | Cloudy | New Year shoppers stopped by for takeaway |
| 2025-01-27 | Mon | 138 | NT$ 17,940 | Sunny | Last workday before the holiday; busy takeaway |
| 2025-01-28 | Tue | 88 | NT$ 11,440 | Sunny | New Year's Eve; closed early at 2 pm |
| 2025-01-29 | Wed | 160 | NT$ 20,800 | Sunny | Lunar New Year; afternoon seating full |
| 2025-01-30 | Thu | 176 | NT$ 22,880 | Sunny | Holiday day 2; family gatherings, many takeaways |
| 2025-01-31 | Fri | 184 | NT$ 23,920 | Partly cloudy | Holiday day 3; day-trippers ordered pour-overs |
| 2025-02-01 | Sat | 192 | NT$ 24,960 | Sunny | Holiday day 4; long waits for seating |
| 2025-02-02 | Sun | 170 | NT$ 22,100 | Cloudy | Last day of the break; more beans to go |
| 2025-02-03 | Mon | 120 | NT$ 15,600 | Rainy | First workday after the holiday; hot lattes sold well |
| 2025-02-04 | Tue | 104 | NT$ 13,520 | Cloudy | Stock count after the holiday |
| 2025-02-05 | Wed | 110 | NT$ 14,300 | Sunny | Deliveries in: fresh milk and green beans |
| 2025-02-06 | Thu | 116 | NT$ 15,080 | Partly cloudy | Roasted a new Yirgacheffe honey-process lot |
| 2025-02-07 | Fri | 132 | NT$ 17,160 | Sunny | Steady takeaway before the make-up workday |
| 2025-02-08 | Sat | 126 | NT$ 16,380 | Sunny | Make-up workday; busy morning takeaway |
| 2025-02-09 | Sun | 168 | NT$ 21,840 | Partly cloudy | Day off after the make-up day; busy afternoon |
| 2025-02-10 | Mon | 94 | NT$ 12,220 | Rainy | Cold and rainy; slower table turnover |
| 2025-02-11 | Tue | 106 | NT$ 13,780 | Cloudy | Roaster cleaning and calibration |
| 2025-02-12 | Wed | 112 | NT$ 14,560 | Sunny | Launched a Valentine's cocoa special |
| 2025-02-13 | Thu | 125 | NT$ 16,250 | Sunny | Dessert pre-orders up before Valentine's |
| 2025-02-14 | Fri | 158 | NT$ 20,540 | Sunny | Valentine's Day; set for two sold well |
| 2025-02-15 | Sat | 186 | NT$ 24,180 | Partly cloudy | Weekend afternoon full; desserts sold out early |
| 2025-02-16 | Sun | 174 | NT$ 22,620 | Sunny | Families and couples; steady revenue |
| 2025-02-17 | Mon | 96 | NT$ 12,480 | Cloudy | Weekday prep and deep machine backflush |
| 2025-02-18 | Tue | 108 | NT$ 14,040 | Rainy | Chilly day; mostly hot lattes and cappuccinos |
| 2025-02-19 | Wed | 115 | NT$ 14,950 | Partly cloudy | A regular bought 3 boxes of drip bags |
| 2025-02-20 | Thu | 118 | NT$ 15,340 | Sunny | Strawberry Basque cheesecake trial went well |
| 2025-02-21 | Fri | 136 | NT$ 17,680 | Sunny | More Friday-afternoon delivery pre-orders |
| 2025-02-22 | Sat | 188 | NT$ 24,440 | Partly cloudy | Pour-overs paired well with Basque cheesecake |
| 2025-02-23 | Sun | 179 | NT$ 23,270 | Sunny | Weekend seating full; average stay 1.5 hours |
| 2025-02-24 | Mon | 98 | NT$ 12,740 | Cloudy | More customers using prepaid cups |
| 2025-02-25 | Tue | 105 | NT$ 13,650 | Sunny | End-of-month packaging and bean stock count |
| 2025-02-26 | Wed | 116 | NT$ 15,080 | Sunny | More weekday-afternoon business meetings |
| 2025-02-27 | Thu | 142 | NT$ 18,460 | Partly cloudy | Eve of the 228 long weekend; takeaway surge |
| 2025-02-28 | Fri | 195 | NT$ 25,350 | Sunny | First day of the long weekend; full all day |
| 2025-03-01 | Sat | 198 | NT$ 25,740 | Sunny | Long weekend day 2; record pour-over and bean revenue |
Prompt
Wrap it up with five concrete action items.
Answer · Gemini
Conclusions & Recommendations
Drawing on the outline, the supplier comparison, the break-even calculation, the sales trends, customer feedback and the inventory tooling, here are five core action items for Alley Corner Coffee:
- Protect the break-even line and watch margins: with NT$180,000 in monthly fixed costs, a NT$120 price and NT$45 variable cost per cup, the shop needs at least 2,400 cups (NT$288,000) a month; keep tracking each item's margin with the Python script or a reporting tool.
- Tier purchasing and stabilise green-bean supply: having compared price, lead time and ratings, make Green Origin Selects the main source of specialty beans and use Hiyori Estate Trading for good-value espresso base beans — consistent quality with flexible costs.
- Fix peak-time flow and launch online pre-ordering: customers flagged morning waits; LINE pre-orders and prepaid cups, plus separate pour-over and espresso lanes, speed up service and lock in steady weekday commuter revenue.
- Plan around weekends and holidays: the 60-day log shows weekends and long holidays (Lunar New Year, the 228 weekend) often top 180 cups a day, so schedule staff and roasting early; desserts such as the cinnamon roll and Basque cheesecake sell well alongside drinks, so set daily prep levels that don't sell out by mid-afternoon.
- Automate inventory with safety-stock alerts: roll out the inventory class with low-stock alerts and CSV export, with reorder points for short-shelf-life items like fresh and oat milk and for the main green beans, to avoid stock-outs and cut waste.
With solid financial discipline, tight supply and inventory control, and digital ordering for a better customer experience, Alley Corner Coffee can keep its independent specialty character while growing sustainably.
1 / 1Typeset with Folio Press