Sales Forecast Dashboard Generator

v1
Model: GPT-4 Level: Intermediate 👍 0 📋 0
businessdashboardExcelforecastingsales
Prompt 55 words

Create an Excel spreadsheet that forecasts sales for [insert time period] across [insert number] of product categories. Include columns for historical sales, projected growth rate, seasonal adjustments, and total revenue. Visualize monthly sales trends using line and bar charts. Add filters by region and sales rep. Make the sheet dynamic with formulas that auto-update projections.

Try in ChatGPT Try in Claude

Why It Works

Combines historical and projected data for dynamic forecasting. Chart visuals aid quick interpretation, while filters make it interactive.

Example Output

A spreadsheet that auto-calculates monthly sales projections for 6 products, visualized in a line graph, with dropdowns to filter by sales region.

Suggest an Improvement

Log in to suggest improvements.

Related Prompts

Advanced Data-Driven Market Research Report Generator GPT-4 Advanced You are a market research analyst. Generate a comprehensive market research report on [Product/Service/Industry] targeting [Country/Region] for [Year].… Social Media Content Calendar Builder GPT-4 Intermediate Create a 4-week social media content calendar for [Business/Brand] in the [Industry] niche targeting [Audience]. Include: 1) Daily… Fitness Progress Log for Personal Trainers GPT-4 Beginner Create an Excel spreadsheet to track client fitness progress over [insert time period]. Include fields for weight, body… Product Inventory Management Sheet GPT-4 Beginner Develop an Excel spreadsheet to manage inventory for a business with [insert number] of products. Track product name,…