Audience: Council Leaders only
The output of this report is understanding both the return to Unit total as well as the return to Council total.
Fields in Report with definitions:
Council_Name: Council sale is associated with
SKU_Name: Name of product sold
SKU: SKU of product sold
Council Case Qty Purchased: Cases that have been purchased by Council
Council Container Qty Purchased: Containers that have been purchased by Council
Unit Container Qty Purchased: Containers that have been purchased by Units
Unit Retail Dollars Purchased: Containers multiplied by the retail price that have been purchased by Units
Base_Commission: Unit retail dollars purchased multiplied out by the Units base commission rate
Cash_Commission : Unit retail dollars purchased multiplied out by the Units cash commission rate
Bonus_Commission: Unit retail dollars purchased multiplied out by the Units bonus commission rate
Total_Commission: sum of base commission + cash commission + bonus commission
Council Product Cost: cost of product from Trail's End
National Fee: Total of the national fee cost collected
TE Rewards: Total of the rewards amount cost collected
Other: Total of allowances and other misc debit/credit memos tied to a specific product
Return to Unit $: Total Commission
Return to Unit %: Total Commission / Unit Retail Dollars Sold
Return to Council $: Unit Retail Dollars Purchased - Total Commission - Net Product Cost - National Fee - TE Rewards-Other
Return to Council %: (Unit Retail Dollars Purchased - Total Commission - Net Product Cost - National Fee - TE Rewards-Other) / Unit Retail Dollars Purchased
Return to Scouting $: Return to Council $ + Return to Unit $
Return to Scouting %: (Return to Council $ + Return to Unit $) / Unit Retail Dollars Purchased
Note: These return amounts will be driven off system costing and will not include any Council specific debit or credit memos for a given Council.