How to Use This Tool
1. Overview
This application allows you to upload sales data to visualize the key drivers of revenue variation between a budgeted period and an actual period.
- Volume Effect: The impact from selling more or fewer units.
- Mix Effect: The impact of changes in the product sales mix.
- Price Effect: The impact of selling at a higher or lower price.
2. How to Use
- Download the Template: Click the "Download Template" button.
- Add Your Data: Replace the sample data with your own. You can rename the first three columns, but do not change the names of the four value columns.
- Upload the File: Click "Choose File" and select your updated file.
- Analyze: Click the "Analyze" button.
3. File Format
Your data must be a .csv or .xlsx file with a header and exactly 7 columns.
Value Columns (must be named exactly):
Budgeted VolumeBudgeted RevenueActual VolumeActual Revenue
Example File Structure
Region,Channel,Product,Budgeted Volume,Budgeted Revenue,Actual Volume,Actual Revenue
Northeast,Retail,Widget A,100,1000,120,1320
West,Retail,Widget C,0,0,30,500
4. Data Security and Privacy
To ensure confidentiality, uploaded data is not stored anywhere. The application processes the data in memory for analysis and discards it once the page is closed or refreshed.