Santa Martha Cafe – Roast Planner

Use one source of truth: the Live Roast Queue. The old local “Roasting Time Sheet” is only a legacy estimate and can disagree with the live schedule. Normal flow: load the actual Saturday events → adjust the Bin Targets if needed → rebuild the Live Roast Queue → roast/print that exact queue.
After Market — Shopify Sales / Inventory Update

Import Shopify Orders

Importing the CSV is still a preview first. Use Review / Apply Shopify Sales to On-Hand when the preview looks right. Every mapped Regular/Small coffee line in the uploaded CSV is reviewed as an inventory sale. Shopify sales do not change Ken, Ruth, or Tayler Bin Targets. Re-importing the same Shopify orders will not deduct them again. If an open Roast Run exists, it is recalculated after the inventory change. 


  







  
On-Hand Inventory

  
  
  
  
  
Gross pail − tare = Net Coffee. Net Coffee is the amount available for bagging and roasting math.


  

    
      

        Coffee
        Type
        Regular Bags
        Small Bags
        Gross Pail (oz)
        Pail Tare (oz)
        Net Coffee (oz)
      

    
    
  







  Roast Profiles / Bag Sizes
  

  
Bag Sizes + Roast Profile

  

    
      

        Coffee
        Regular Bag oz
        Small Bag oz
        Profile
        Min/Roast
        Roasts/Set
        Yield/Roast (oz)
        Yield Verified
        Green Input oz
        Green Verified
        Loss %
        Tare (oz)
        Tare Verified
      

    
    
  

  







  Legacy Presets / Day Plans
  

  
Market Presets

  

    

      

      

      Save From

      Load To

      Other

    

  

  
Save one person's market setup and reuse it for anyone later.



  
Day Plans

  

    

      

      

      

      Actions

    

  

  
Save the whole group for a specific market/date.

  







  
Bin Targets


  

    
      

        Coffee
        Type
        
          
Ken

          

          

            
            
            
            
            

          

        		
        
          
Ruth

          

          

            
            
            
            
            

          

        		
        
          
Tayler

          

          

            
            
            
            
            

          

        		
      

      

        RegularSmall3 lbBrews
        RegularSmall3 lbBrews
        RegularSmall3 lbBrews
      

    
    
  




  

    
Production Week — One Plan, One Queue

    

      Saturday demand comes from the events actually scheduled for the date.
      Assign each selected event to Ken, Ruth, or Tayler so its saved target loads into the correct physical bin column.
      A special event can be assigned to a different person for this Saturday without changing that person's normal weekly market.
      The live queue is rebuilt from the numbers currently shown above; stale unstarted roasts are removed automatically.
    


    

      

        

        
      

      

        Check the markets/events you are actually doing, then choose Who is taking it? for each selected event.
        If SVAF replaces a normal market, leave SVAF checked and uncheck the market you are skipping.
      

    


    
Loading scheduled Saturday events…


    

      
      
      
      
    


    
Loading scheduled Saturday events…

    
  


  

    Advanced / Manual Planner Tools
    

      
      
      
      
      
      
      
      
      
      
      
    

    
Loading open roast schedule…

  


  

    
Thursday Market Prep — Before Saturday


    

      Thursday:
      
        Use the forecast only to prepare Thursday. After Thursday, import the
        actual Shopify sales. Unsold bags stay On-Hand and are automatically
        available for Saturday.
      
    


    

      

        
        CGFM — Cottage Grove

        Person
        
      


      

        
        KFM — Kenyon

        Person
        
      


      

        
        FFM — Farmington

        Person
        
      

    


    

    

    

    

      Select the production week to prepare Thursday.
    

  






















  
Label Printing


  

    

    

    

    
  







  Legacy Local Roast Estimate — not the source of truth
  

    
This older calculator is kept only for troubleshooting. Use the Live Roast Queue and “Print Exact Live Roast Sheet” for actual production.