100 Best Claude Excel Data Analysis Prompts for Florists

Direct Answer

The best Claude prompts for Excel data analysis for florists are a curated set of precise, instruction-rich tasks that drive actionable insights from sales, inventory, and operational data. They enable forecasting, optimization, and performance tracking with clear outputs and constraints.

Introduction

This page compiles 100 Claude prompts focused on Excel data analysis for florists. It is designed for shop owners, managers, and data-minded florists who want practical prompts they can paste directly into Claude to generate Excel-ready analyses.

Each prompt includes role, task, context placeholders, output format, and constraints to ensure you get repeatable results for inventory, sales, and profitability planning.

How to Use These Claude Prompts

• Replace placeholders like [season], [category], and [vendor] with your actual data labels.
• Add constraints such as date ranges, currency, or units to tailor outputs to your workbook.
• Request outputs in a tabular format or chart-ready summaries to minimize post-processing.
• Ask Claude to verify outputs by cross-checking totals against your source data.
• If needed, copy the generated results back into your Excel workbook and adjust formulas as needed.
• Use consistent sheet names to ensure prompts reference the correct data ranges.

100 Best Claude Excel Data Analysis Prompts for Florists

1. Seasonal sales heatmap: Act as a data analyst for a florist. You have an Excel workbook with sheets: Sales, Inventory, and Calendar. Analyze seasonality by month and holiday weeks. Provide a heatmap of sales by month for the last two years, and highlight peak weeks. Output a summary table with month, year, total units, revenue, and growth vs prior year. Include a brief interpretation.
2. Best selling bouquets by season: You are an Excel analyst for a florist shop. In the Sales sheet, categorize bouquets by type and season. Create a pivot table showing top five bouquets by revenue per season, with counts and average price. Provide a ready-to-use chart captions and a short interpretation.
3. Inventory turnover rate: As an inventory analyst for a florist, calculate monthly turnover rate from Inventory and Sales sheets. Show formula-driven steps to compute turnover, days-on-hand, and reorder point by flower type. Include a summary table and recommendations for reducing slow-moving stems.
4. Gross margin by bouquet: Act as a financial analyst. Use Sales and Cost sheet to compute gross margin percent for each bouquet category. Build a pivot showing bouquet, gross margin, units sold, and margin trend over the last six months. Deliver a one-line takeaway per bouquet.
5. Demand forecasting baseline: You are forecasting demand for florists. Build a baseline forecast using last 12 months of sales by category with a simple moving average in Excel. Output a forecast table, error metrics (MAD, MAPE), and a row for recommended stock levels.
6. Price sensitivity matrix: Act as a pricing data analyst. Using historical prices and units sold per bouquet, compute price elasticity for three price tiers. Create a matrix table, with recommended price adjustments and expected revenue impact.
7. Vendor cost comparison: You are an Excel analyst comparing flower vendors. Build a table comparing unit cost, lead time, and reliability for three suppliers. Compute total cost of ownership for a typical weekly order and provide a recommendation with rationale.
8. Open-to-close sales gap: As an analyst, compare daily sales at opening vs closing hours for the last 90 days. Build a chart and compute percent difference. Suggest staffing and promotions to smooth the gap.
9. Promotions impact analysis: Act as a data analyst. Track promotional events in a Promotion log and align with daily sales. Build a calculated column to attribute incremental revenue to promotions, and provide a post-promo lift report.
10. Flower longevity planning: You are planning inventory with vase-life data. Create a worksheet that estimates waste by flower type based on days-to-sell and peak demand. Output a waste forecast and recommended spoilage buffers.
11. SKU profitability breakdown: As a florist data analyst, analyze profitability by SKU (bouquet code). Build a summary table showing revenue, cost, gross profit, and margin by SKU for the last six months. Provide an actionable profitability insight.
12. Stockout risk heatmap: Act as an Excel risk analyst. Build a risk dashboard highlighting stockout risk by flower type, using sales velocity, lead time, and current stock. Output a color-coded risk score and mitigation steps.
13. Seasonal bouquet mix testing: You are testing bouquet mix performance across seasons. Create a test framework in Excel with control and test groups, track conversion rates, and provide recommended season-specific mixes.
14. In-season reorder triggers: As a florist inventory planner, develop reorder triggers based on lead time and sales rate. Output a table of reorder points per flower type with recommended order quantities.
15. Delivery route optimization: Act as a logistics analyst. Given daily delivery data, create a simple route efficiency score per route and propose improvements to reduce delivery time and fuel cost. Provide a step-by-step method and resulting scores.
16. Waste reduction planner: You are an operations analyst. Build a waste tracker in Excel by flower type, including waste reason categories. Output a monthly waste percentage and top waste drivers with suggestions.
17. Weather-adjusted demand: As an analyst, incorporate weather data and events into sales trends. Create a weather-adjusted demand model with a simple regression in Excel and produce a forecast table.
18. Seasonal staff planning: Act as a workforce planner. Using sales seasonality, generate a staffing plan by week for the next 12 weeks. Include hours, headcount, and cost estimates.
19. Email campaign lift: You are evaluating email campaign impact on sales. Match campaign dates with daily sales, compute uplift, and output a concise impact summary with confidence note.
20. Florist master dashboard: Create a master Excel dashboard plan for a florist with sections for sales, inventory, margins, and promotions. Outline required sheets, links, and a simple KPI chart set.
21. SKU mix optimization: As an analyst, optimize bouquet SKU mix for revenue. Use last twelve months data to propose a revised SKU distribution and show expected revenue change.
22. Lead time by supplier: Evaluate supplier lead times. Build a table listing average, median, and percentile lead times for each supplier, with recommended safety buffer per item.
23. Seasonal inventory rebalancing: You are a planner. Develop a rebalancing plan by month to shift stock between stems with high vs low demand. Provide target stock levels and a change plan.
24. Sales channel comparison: Act as an analytics assistant. Compare sales by channel (in-store, online, markets) for last six months. Output channel revenue shares, growth, and recommended focus.
25. Top customer segments: Identify top customer segments by repeat purchases and average order value. Build a segment table with actionable marketing ideas per segment.
26. Bouquet pricing simulator: Create a pricing simulator in Excel for three bouquet archetypes. Allow scenario input for cost, demand, and margin to display projected profit.
27. Seasonal stockouts per stem: Track stem-level stockouts by season. Produce a report listing stems most prone to stockouts and propose contingency substitutes.
28. Event-driven demand spikes: Model demand spikes around events (weddings, funerals, holidays). Output a spike-adjusted forecast and recommended stock plan.
29. Vendor payment aging: Analyze accounts payable aging by vendor. Create a dashboard showing aging buckets, total due, and recommended payment timing.
30. Color palette profitability: Evaluate profitability by color palette across bouquets. Build a color palette profitability table with revenue, cost, and margin.
31. Seasonal promotion calendar: Design a calendar-driven promotions planner. List promotions by month with goals, budget, and expected lift in sales.
32. Customer churn indicators: Identify churn indicators among regular buyers. Produce a churn risk score by customer cohort and suggested re-engagement actions.
33. Turnover by category: Compute monthly inventory turnover by category (roses, lilies, etc.). Output a chart and brief interpretation.
34. Stock coverage report: Create a stock coverage report showing days of cover per stem type based on current stock and sales pace. Include reorder recommendations.
35. Basket analysis: Perform a cross-sell analysis on bouquets often bought together. Output a recommendation list of bundles with potential uplift.
36. Supplier reliability score: Develop a reliability score per supplier using on-time delivery and defect rate data. Provide a ranking and improvement notes.
37. Profit by event type: Analyze profit by event type (weddings, funerals, corporate). Build a filterable table showing revenue, costs, and profit margin.
38. Seasonal sentiment cues: Integrate customer feedback data with sales to identify sentiment cues affecting demand. Output a sentiment-to-sales correlation report.
39. Forecast accuracy audit: Audit forecast accuracy. Compare forecast vs actual for the last six months, compute error metrics, and propose forecast adjustments.
40. Promo ROI tracker: Track return on investment for promotions. Build a calculator that inputs discount, reach, and incremental sales to output ROI.
41. Lead time risk matrix: Create a risk matrix by item showing lead time risk, supplier reliability, and buffer recommendations.
42. Waste vs revenue analysis: Analyze waste relative to revenue by stem. Produce a table mapping waste rate to revenue loss and suggest mitigations.
43. Daily sales trend: Plot a rolling 14-day sales trend. Output a chart-ready table with day, revenue, moving average, and anomaly flags.
44. Seasonal future forecast: Use last 12 months to forecast next quarter by category with a simple exponential smoothing model. Provide forecast and confidence ranges.
45. Cost-cutting opportunities: Identify cost-saving opportunities in bouquet assembly. List actionable steps with potential savings and impact on margins.
46. Inventory aging report: Track inventory age by stem. Output a table of days in stock, aging category, and recommended actions.
47. Promotion timing optimization: Analyze promotion timing against demand peaks. Propose optimal days of week and dates to run promotions.
48. Delivery window optimization: Model delivery windows for efficiency. Output a recommendation for optimal delivery windows by region.
49. Seasonal supplier calendar: Create a calendar view of supplier lead times and seasonal availability. Flag potential shortages and suggest backups.
50. Bouquet SKU rationalization: Rationalize bouquet SKUs to reduce complexity. Propose pruning candidates and a revised mix with impact on variety and revenue.
51. Loyalty program analysis: Assess loyalty program impact on repeat purchases. Build a table showing members, visits, average spend, and uplift.
52. SEO-aware product mix: Align product mix with seasonal search trends. Output a sheet suggesting bouquets aligned to seasonal demand signals.
53. Cost vs price crossover: Plot cost per bouquet against selling price to identify where margins collapse. Propose price adjustments or cost-saving ideas.
54. Staff overtime forecast: Forecast overtime needs based on peak days. Output a plan with hours, cost, and coverage suggestions.
55. Sales anomaly detector: Implement a simple anomaly detector for daily sales. Flag days with abnormal deviations and propose reasons.
56. Color trend demand: Investigate color trends by month. Produce a table showing color family demand and recommended stock levels.
57. SKU performance heatmap: Create a heatmap of SKU performance across quarters. Include revenue, margin, and volume cells.
58. Cumulative sales by bouquet: Compute cumulative sales by bouquet over time. Provide a chart-ready table and insights on momentum.
59. Lead time by product type: Break down lead time by product type. Output a table with averages, medians, and delivery risk notes.
60. In-store vs online lift: Compare in-store and online sales performance. Output a combined view with channel-specific growth and recommended focus.
61. Seasonal demand by region: Segment demand by region. Build a regional demand table with recommended stock levels per region.
62. Refund and return impact: Analyze refunds relative to sales by bouquet. Provide a refund rate by bouquet and remediation steps.
63. A/B testing plan: Design an A/B test plan for bouquet variants. Outline sample sizes, metrics, and decision criteria.
64. Cost per stem benchmark: Benchmark cost per stem by flower type. Output a benchmark table and actionable cost-saving notes.
65. Seasonal supplier risk: Score supplier risk for seasonality. Produce a risk score per supplier with contingency recommendations.
66. Campaign uplift comparison: Compare multiple campaigns' uplift on sales. Output a stacked bar with campaign, baseline, uplift, and final revenue.
67. Delivery cost optimization: Model delivery costs by route. Output a recommended routing plan to minimize cost per order.
68. Freshness decay model: Estimate freshness decay for stems in transit. Create a decay curve and recommended shelf life adjustments.
69. Order profitability by event: Analyze profitability of orders tied to events. Provide a per-event profitability table with notes.
70. Budget-to-actual variance: Track marketing budget vs actual spend and revenue. Produce a variance report with corrective actions.
71. Seasonal markup strategy: Develop markup guidance by season and category. Output tiered markup recommendations and expected margins.
72. Inventory shortage alerts: Set up alert rules for low stock. Output a checklist of thresholds and automatic reminders.
73. Commissions and incentives: Model salesperson commissions linked to bouquet profitability. Output a commission table and payout projections.
74. Cross-sell opportunity map: Identify cross-sell opportunities by bouquet attributes. Produce a map of recommended cross-sell bundles.
75. Seasonal pricing ladder: Create a pricing ladder for peak seasons. Output tiered prices, rationale, and expected demand response.
76. Cumulative profit by category: Compute cumulative profit by category over twelve months. Provide a chart-ready table and insights.
77. Lead time forecast: Forecast lead time distribution using historical data. Output a probability table and recommended buffers.
78. Stock rotation plan: Plan stock rotation to minimize waste. Provide a per-stem rotation schedule and adjustment rules.
79. Seasonal supplier swap: Plan alternates for seasonal shortages. Output a swap plan with impact on cost and lead times.
80. Event prep checklist: Create an Excel-based event prep checklist linked to sales forecast. Include tasks, owners, dates, and status.
81. Sensitivity to promotions: Measure sensitivity of bouquet demand to discount levels. Output a sensitivity table with recommended discount bands.
82. Thematic bouquet performance: Analyze performance by bouquet themes (romantic, bridal, sympathy). Provide a theme table with revenue and margins.
83. Seasonal procurement plan: Develop a procurement plan aligned to seasonal demand. Output itemized orders with quantities and lead times.
84. Refund mitigation plan: Create a plan to reduce refunds. Provide root-cause hypotheses and recommended process adjustments.
85. Customer lifetime value: Estimate customer lifetime value per segment. Build a table with LTV, churn rate, and recommended targeting.
86. Production throughput: Analyze production throughput by bouquet type. Output a bottleneck report and proposed workflow improvements.
87. Sourcing scenario analysis: Model scenarios for sourcing changes (local vs imported). Output cost, lead time, and risk comparisons.
88. Seasonal cashflow forecast: Create a cash flow forecast for the next quarter based on sales seasonality and expenses.
89. Aging stock risk: Identify aging stock risk by stem. Output items at risk with recommended actions.
90. Customer feedback signals: Quantify feedback signals affecting sales. Produce a table mapping feedback themes to sales impact.
91. SKU level forecasting: Forecast demand at SKU level using last months data. Output forecast table and confidence estimates.
92. Delivery window adherence: Measure on-time delivery adherence. Output a compliance score and improvement plan.
93. Basket value optimization: Optimize average order value by bundle suggestions. Provide a chart-ready plan with potential bundles.
94. Seasonal risk dashboard: Build a seasonality risk dashboard with KPIs and color-coded alerts for florists.
95. Inventory reconciliation: Perform a monthly inventory reconciliation. Output discrepancies, root cause, and corrective steps.
96. Vendor negotiation prep: Prepare a data-backed vendor negotiation packet. Include price, lead time, and performance metrics.
97. Bestseller forecast ranking: Rank bouquets by projected future revenue. Provide top five recommendations with rationale.
98. Seasonal margins by stem: Break down margins by stem type across seasons. Output a seasonal margin table and notes.
99. Promotional risk alert: Set up an alert for promotions that might erode margins. Output alert conditions and mitigation steps.
100. Executive summary blueprint: Create a one-page executive summary template for florist Excel analytics, including key metrics, trends, and actions.

Best Practices

• Keep prompts specific to the worksheet structure you use to avoid misalignment.
• Ask for both a summary and the underlying calculations to ensure transparency.
• Limit outputs to one or two sheets at a time to keep models focused.
• Validate Claude outputs with a quick sanity check against known numbers.
• Store commonly used prompts in a labeled library for reuse and safety.

Common Mistakes to Avoid

• Using vague prompts that don’t fix data ranges or sheet names.
• Asking for outputs in a format that requires heavy post-processing.
• Ignoring data quality issues and expecting perfect results.
• Overly complex prompts that mix multiple goals without clear priorities.
• Assuming Claude knows your business context without explicit instructions.

FAQ

Can I use these prompts with any Excel file?

Yes, but you should tailor placeholders to your workbook's sheet names, column headers, and data ranges.

Do these prompts require programming knowledge?

No, they are designed to be copy-pasted into Claude with plain Excel-oriented instructions.

How do I verify Claude outputs?

Cross-check totals against your source data and run quick sanity checks on margins and counts.

Can I adapt prompts for quarterly planning?

Yes, replace dates with quarter markers and adjust aggregation levels accordingly.

What if results are not as expected?

Refine the data range, simplify the prompt, or split tasks into smaller prompts to isolate issues.

How should I store prompts for reuse?

Keep a labeled prompt library with a short description and the exact data ranges it expects.