Inventory and Sales Summary

  • Net Sales Summary: Overview of various products with their respective details,

    • Each item categorized by type, such as BAR, LIQ (Liquor), WINE, etc.
    • Each category provides:
    • Count of units sold
    • Unit of Measure (UofM)
    • Actual vs. Theoretical costs and variances
    • Waste, Donation, and Unexplained Variance percentages

  • Categories and Selected Products:

    • BAR: Various syrups, bitters, fruit preparations, etc.
    • Example: Ghia Le Spritz
      • Actual Cost: $3.56, Theoretical Cost: $7.00, Variance: $0.00
    • LIQ: Primarily liquor and spirits listings
    • Example: Amaro Averna - Actual Cost: $24.15, with similar variance data
    • WINE: Accounting for multiple wine selections with respect to cost and sales performance
    • Example: Cab Sauvignon Domaine Curry - Actual Cost: $56.01, with detailed performance metrics
    • DAIRY & MEAT: Listings of dairy products like cheese and butter, along with meat products including chicken and beef, outlining prices and quantity sold.
    • Example: Butter - Actual Cost: $3.14

  • Financial Overview:

    • Total Sales and Variance Analysis providing insights on revenue against actual usage vs. theoretical estimates.
    • Categories segmented for detailed analysis e.g., Dry Goods, Produce, etc.
    • Itemized financial summary at the end capturing overall performance in terms of cost control and inventory efficiency.

  • Timeframe for Analysis: Inventory analyzed over a timeframe given (03/03/2025 to 03/23/2025).

    • Comparison of actual vs. theoretical sales to evaluate performance.