Buy vs Sold
This new Buy vs Sold widget compares the amount of product purchased and the amount sold, often used in inventory and sales analysis. Here are some key points related to "Buy vs Sold":
-
Index Calculations: The "Buy vs Sold Index" measures revenue earned per dollar of product purchased. It includes target lines for ideal revenue per ounce and variance displays showing percentage and dollar amount differences from the ideal.
-
Revenue and Cost Calculations: Revenue is calculated as the sum of daily summary data, and purchase cost is similarly aggregated. The actual index is derived from revenue divided by purchase cost, and various metrics like revenue per ounce and cost per ounce are used to assess performance.
-
Technical Specifications: The system includes drill-down capabilities for detailed analysis at different levels (e.g., regional, district, store) and ensures data accuracy by verifying calculations against source data.
These elements are part of a broader system designed to optimize inventory management and sales performance by providing detailed insights into the relationship between products bought and sold.
This graph compares financial and performance metrics over time, including:
- Revenue and Purchase Cost (bar graph)
- Actual Index and Ideal Index (line graph)
- Index is an indicator for the amount made per dollar.
Use the Product Type dropdown in the sidebar to filter for Draft, Package (Bottles & Cans), Liquor, or Wine.
- Perpetual Inventory added to Buy vs Sold
- Click "View More", then click the product to view its Perpetual Inventory page
- This is a view only screen. No adjustments can be made to inventory from this page.
- Displays the date selected
- Export available
- Click $$ or Units in View More to see your data in dollars or units
- Product type filter will influence the report so if you select "Package" then only package will appear, for example
drills down to:
