KRAKEN COFFEE 2024 HALF TIME REVIEW

Click here for Excel Data Set

The objective of this 2024 Half-Time Review Report for Kraken Koffee's new Florida sales region is to:

1. Evaluate Performance for the First Half of 2024

• Highlight key metrics:
  
  

  • Total purchases (1,49,116)
    
    

  • Total sales ($6,98,812)
    
    

  • Average order size ($4.69)
    
    

  • Number of new stores opened (3)
    
    

  • Total menu items (80)
    
    

  • Best-selling items (by quantity and revenue)
    
    

2. Identify Top-Selling Products and Categories

• Pinpoint best-selling products in terms of revenue and volume
  
  

• Highlight product performance by category and type
  
  

• Showcase product trends by location, such as the top item in Tampa or Orlando
  
  

3. Analyze Customer Purchase Patterns

• Determine the most popular times and days for spending (e.g., 10 AM, Monday)
  
  

• Reveal underperforming times and propose re-evaluation of store hours to optimize revenue
  
  

4. Set and Justify Future Sales Goals

• Present a realistic sales goal of $14,09,207 for 2024 based on trends
  
  

• Introduce a stretch goal of $15,92,839 if current momentum continues
  
  

• Show daily sales trends by location and day to back up projections