Instructions
this work sheet can be found at www.bsagrfc.org
Only complete the RED TABS
By 9/15/2011
1). Fill in information on the ROSTER TAB All scouts both selling and Non-selling
2). Complete SUMMARY TAB with show N sell pre-order cases (Only the row highlighted in RED needs to be filled in)
*** This is the information you will enter online (www.trails-end.com) for show N sell DATE 9/15/2011
10/1/2011
3). Print out S-N-S PICKUP TAB (GREEN TAB)
4). Bring S-N-S PICKUP print out to the popcorn pick-up
10/1-11/7
5). Fill in data for each boy's total on the S-N-S TAB
6). Fill in data for each boy's totals for Take Order TAB
7). Fill in Centennial Popcorn Club Tab
8). Fill in FOS Tab
11/7/2011
9). Save this excel settlement tool as your unit number (once all tabs are completed and you have placed your take order product order online as well as your prize order
Be sure that your summary tab is correct. Email this file (saved as your unit number) to aaron.gach@scouting.org
10). Print out SUPER SATURDAY PICK UP TAB (BLUE TAB)
*** This is the information you will enter online (www.trails-end.com) for TAKE ORDER DATE 11/7/2011
11/12/2011
All returns need to be brought to distribution sites
11/19/2011
11). Print out each Tab and bring it to Super Saturday
12). Write two checks with dates and totals found on the bottom of the SUMMARY TAB and Bring to Super Saturday with your Super Saturday Che
*******Remember to Check your Online Invoice (found in the report menu on the online ordering system) before you write your checks. Your checks MUST add up to the
If it does not please call your popcorn sale advisor or Kernel ASAP to fix this BEFORE you come to super Saturday. Remember that it may take a day or two for your onli
Show and Sell Returns on your settlement sheet.************
er online as well as your prize order.)
h your Super Saturday Checklist competed.
. Your checks MUST add up to the TOTAL DUE at the bottom.
may take a day or two for your online invoice to update if you have
1 Unit Kernel attends popcorn University
2 Final order placed online and is on time.
Unit submits full unit roster of all scouts in your unit (this is not produced by the service
center) including name, address, date of birth, phone, and sales volume( if scout sold) on
3 or before super Saturday
4 Unit submits completed 2012 Friends of Scouting form, on tab in settlement tool
5 Prizes are ordered ONLINE and on time, including patches, pins, $600 prize, and $1500 prize.
6 Unit submits $2500 scholarship form manually at Super Saturday if applicable.
Both show & sell and take order checks turned in by Super Saturday - Your check amount
7 must match the SETTLEMENT tool you submit on Nov 7, and must clear your account
when deposited.
8 Unit submits a SETTLEMENT tool to the DeVos Family Center for Scouting by 11:59pm on Nov 7.
9 Returns match your settlement tool and are made on time, and do not exceed 15% of
your total (gross retial) show and sell order. (see return policy)
10 Unit Kernel is trained, encourages all scouts to register to sell online, and hold an exciting
unit kickoff sharing key info and excitement with scouts and parents.
Leader: Work Phone
Unit #
E-mail Home Phone
TEAM PLAYERS
#N/A
Scout phone Address Date of Birth Phone
Total
Total Sold
$ - Add the name of each boy in your unit even if they did not sell popcorn
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
Leader:
Unit # 0 0
E-mail Home Phone Work Phone
TEAM PLAYERS
#N/A 0 0 0
L Sweet White 18 Pack 18-Pack 18-Pack Caramel Butter
i Military Military Product Cheese Chocolaty Caramel Popping GROSS DOLLAR
Products and Choc Kettle Corn Butter Light Corn w/ Toffee Plan A Plan B
n Product $50 $30 Lovers Triple Delight corn Pail TOTALS
Savory Pretzels Micro Micro Micro almond Carmel Corn
e
A Retail Price of a container $50 $30 $40 $30 $25 $25 $18 $18 $20 $20 $20 $10 $10 #N/A #N/A
Number containers in a
B
case
1 1 1 1 8 6 6 6 8 8 8 12 6 $1,376.00 #N/A #N/A
Cases Ordered for
C Show- N - Delivery / $0.00 #N/A #N/A
Sale
Show-N-Sell Cases in
D
Containers 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 #N/A #N/A
Show-N-Sell CONTAINERS
E
SOLD 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 #N/A #N/A
Extra Show-N-Sell to use
F
toward Take Order
0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 #N/A #N/A
# of Take Order Containers
G
Sold 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 #N/A #N/A
H Amount of Take Order 0 0 0 0 0 0 0 0 0 0 0 0 0
Product Needed after
The POSITIVE
NUMBERS AND
I
FRACTIONS (the
0 0 0 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00
CASES need to order)
CASES OF POPCORN
PRODUCT TO ORDER -
J
PUT IN ON LINE
0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 #N/A #N/A
POPCORN SYSTEM
The NEGATIVE
NUMBERS AND
K
FRACTIONS (CASES to
0 0 0 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00
be RETURNED)
CASES OF POPCORN
PRODUCT TO BE
L RETURNED - HARD 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00 #N/A #N/A
COPY TO SCOUT
OFFICE
$0.00
Checks Plan A Cash Plan B Prizes Show N Sell
Show N Sell check dated #N/A #N/A $0.00
11/19 Take Order
Take Order check dated #N/A #N/A $0.00
12/16 Total Sales
Rev F 2011
SHOW AND DELIVER PICKUP
Work
Unit # 0 Leader: 0 Phone 0
Home
TEAM PLAYERS #N/A E-mail 0 Phone 0
Item Cases
Sweet and Savory
0
Cheese Lovers C 0
White Choc Pretzels
0
18 Pack Kettle Corn Micro
0
18-Pack Butter Micro
0
18-Pack Light Micro
0
Chocolaty Triple Delight
0
Caramel Corn w/ almond
0
Butter Toffee Carmel Corn 0
Caramel corn
0
Popping Pail
0
Total 0
18 Pack Butter
White 18-Pack 18-Pack Chocolaty Caramel
Military Military Sweet and Cheese Kettle Toffee Caramel Popping
Choc Butter Light Triple Corn w/ total
Product $50 Product $30 Savory Lovers Corn Carmel corn Pail
Pretzels Micro Micro Delight almond
Micro Corn
Scout
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
18 Pack 18- Butter
White 18-Pack Caramel
Military Military Sweet and Cheese Kettle Pack Chocolaty Toffee Caramel Popping
Product $50 Product $30 Savory Lovers
Choc
Corn Butter
Light
Triple Delight
Corn w/
Carmel corn Pail Total
Pretzels Micro almond
Scout Micro Micro Corn
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
0 $0.00
Super Saturday Pickup
Work
Unit # 0 Leader: 0 Phone 0
Home
TEAM PLAYERS #N/A E-mail 0 Phone 0
Item Cases
Sweet and Savory
0
Cheese Lovers C 0
White Choc Pretzels
0
18 Pack Kettle Corn Micro 0
18-Pack Butter Micro
0
18-Pack Light Micro
0
Chocolaty Triple Delight
0
Caramel Corn w/ almond
0
Butter Toffee Carmel Corn 0
Caramel corn
0
Popping Pail
0
Total 0
Centennial Popcorn Club Form 0
When a Scout reaches $600 in total sales add his or her name to this form. When you submit this settlement tool by
Nov 19 we will take the Scouts on this sheet and add them to the Club.
You will receive the Centennial Popcorn Club pins for the number of Scouts listed here.
It is VERY important that you correctly type in each Scout's email address here, as the Scout will get special Club
notices, offers, and prizes by email ONLY for all of 2012.
Please also remember that Scouts reaching $600 in sales qualify for the Zyclone, which is order online with your prize
order.
Scouts Name Total Sales Volume Email Address
2011 Friends of Scouting Presentation Info
0 Unit
FOS Contact person
Address
Daytime phone
Evening phone
Email address
DATE OF FOS PRESENTATION
JANUARY
FEBRUARY
MARCH
Location Address
on Info
Returns
Work
Unit # 0 Leader: 0 Phone 0
Home
Return % #DIV/0! E-mail 0 Phone 0
Item Cases
Sweet and Savory
0
Cheese Lovers C 0
White Choc Pretzels
0
18 Pack Kettle Corn Micro 0
18-Pack Butter Micro
0
18-Pack Light Micro
0
Chocolaty Triple Delight
0
Caramel Corn w/ almond
0
Butter Toffee Carmel Corn 0
Caramel corn
0
Popping Pail
0
Total 0
18 Pack Butter
Military Military 18-Pack 18-Pack Caramel
Sweet and Cheese White Choc Kettle Chocolaty Toffee Caramel Popping
Product Product Butter Light Corn w/ total
Savory Lovers Pretzels Corn Triple Delight Carmel corn Pail
$50 $30 Micro Micro almond
Scout Micro Corn
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $ -
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0.00
SNS Signout
Work
Parent name Phone
Home
Scout name Phone
Cases
Item picked up
Sweet and Savory
Cheese Lovers C
White Choc Pretzels
18 Pack Kettle Corn Micro
18-Pack Butter Micro
18-Pack Light Micro
Chocolaty Triple Delight
Caramel Corn w/ almond
Butter Toffee Carmel Corn
Caramel corn
Popping Pail
Signature Date
containers
picked up