Sales Trends
Analyze sales data to identify patterns, trends, and opportunities for growth.
Example Prompt 1: Q4 Sales Analysis
Analyze the Q4 sales data spreadsheet and identify: the top 3 equipment categories by total sales, average sale price for each location (Lethbridge, Taber, Burdett, Medicine Hat), sales trends over the quarter, and customer type distribution (Farm, Commercial, Residential). Create a summary with key insights for management review.
Example Prompt 2: Seasonal Sales Patterns
Analyze sales data from the last 12 months to identify: seasonal sales patterns by equipment category, which months have highest sales for tractors vs. combines vs. implements, correlation between location and seasonal patterns, and recommendations for inventory planning based on seasonal trends. Create visualizations and a summary report.
Example Prompt 3: Customer Purchase Patterns
Analyze the customer database and sales data to identify: customers who purchased equipment in the last 2 years with total purchase value over $200,000, customer lifetime value by location, repeat purchase patterns, and average time between purchases. Create a filtered list with customer names, contact information, and total lifetime value for follow-up marketing.
Inventory Analysis
Monitor inventory levels, identify slow-moving items, and optimize stock levels.
Example Prompt 1: Stock Level Analysis
Analyze the parts inventory spreadsheet. Identify: parts with low stock levels (below reorder level), parts with high stock levels (more than 2x reorder level), slow-moving inventory items (no sales in 90+ days), and fast-moving items that may need higher reorder points. Create a summary report with key findings and action items.
Example Prompt 2: Parts Demand Forecasting
Analyze parts inventory and sales data to identify: parts with increasing demand trends, parts with decreasing demand, seasonal demand patterns, and recommended reorder quantities based on historical sales. Create a forecast report with recommendations for inventory management.
Example Prompt 3: Inventory Value Analysis
Calculate total inventory value by category, identify high-value inventory items, analyze inventory turnover rates, and identify opportunities to reduce inventory costs. Create a comprehensive analysis with recommendations for inventory optimization.
Budget Reports
Create financial reports and budget analyses to support decision-making.
Example Prompt 1: Department Budget Analysis
Analyze the service department budget spreadsheet. Compare actual expenses to budgeted amounts, identify categories where spending is over or under budget, calculate variance percentages, and create a summary report highlighting key findings and recommendations for the next quarter.
Example Prompt 2: Sales Performance vs. Budget
Compare Q4 sales performance to the annual sales budget. Calculate: percentage of annual budget achieved, sales by location vs. budget, sales by equipment category vs. budget, and forecast for remaining period. Create a comprehensive report with visualizations for management review.
Example Prompt 3: Profitability Analysis
Analyze sales and cost data to calculate: profit margins by equipment category, profit margins by location, most profitable customer segments, and cost trends. Create a profitability analysis report with recommendations for improving margins.
