ORDERING POPCORN & REWARDS

IMPORTANT: THIS SITE IS FOR GROUPS IN THE PACIFIC COAST COUNCIL ONLY AND IS NOT VALID FOR GROUPS IN ANY OTHER COUNCIL

This section explains how to place your popcorn orders, when to pay for your orders, and how to order your incentive rewards.

There are two separate popcorn orders that must be entered through the "on-line" Popcorn System (Trails End website) by the Group Coordinator:

1. "SNS" (INITIAL ORDER) is the September Show & Sell Order (for those who are ordering Show & Sell); and

2. "TAKE ORDER" is your October Main Take Order (using order forms).

PLEASE FOLLOW THESE INSTRUCTIONS TO LOG IN:

1. Click on the Popcorn System website scouting.trails-end.com;

2. Enter your username which is usually your "firstname.lastname" (if this doesn't work, email Steve at info@pccpopcorn.com);

3. If you have forgotten your password or you are a first time user, click on "Need Help?" and follow the instructions to reset your password (your reset instructions will be sent to the email address that you provided to us when you registered your group);

4. WHEN LOGGED ON, DO NOT USE ANY OF THE WEBSITE FUNCTIONALITY EXCEPT AS PER THE INSTRUCTIONS BELOW.

5. If you have any problems, please email Steve at info@pccpopcorn.com.

If you are not ordering for Show & Sell, skip this section and go to #3 - ORDERING YOUR OCTOBER MAIN "TAKE ORDER" which is the next section below.

NOTE: PAYMENT FOR THE SHOW & SELL ORDER IS WITH A POST DATED CHEQUE DATED OCTOBER 31ST AND DUE ON OR BEFORE THE DATE YOUR SHOW & SELL ORDER IS PICKED-UP (REFER TO THE "TIMELINE" PAGE FOR DETAILS).

The SEPTEMBER SHOW & SELL "SNS" INITIAL ORDER is a single Group order entered by "CASES" in September. These orders must be entered onto the Popcorn System (Trails-End website) for each Group no later than the deadline shown on the Timeline and using the instructions below.

Note that if youth/adults are selling by SHOW & SELL, the amounts they sell must be tracked. A separate sheet should be created for tracking purposes. For example, if eight sellers are taking turns at a table in front of a store for a day, the total dollar sales amount should be allocated to each seller according to the hours they spent at the table. Each Popcorn Coordinator for a section (Beaver Scouts, Cub Scouts, Scouts, etc.) must track these sales carefully. As many of you know, Excel spreadsheets work well for tracking sales in a variety of ways.

To enter your SEPTEMBER "SNS" - SHOW & SELL INITIAL ORDER, carefully follow these steps and DO NOT USE ANY OF THE FUNCTIONALITY ON THE TRAILS-END WEBSITE OTHER THAN AS DESCRIBED HERE:

1. Click on the Popcorn System website scouting.trails-end.com

2. Sign into your account (if you have forgotten your username/password, follow the instructions at the top of this page).

3. Note: do not click on any buttons other that the "Popcorn" & "Order Popcorn" buttons;

4. Click on the "Order Popcorn" button;

5. Make sure the campaign shows -> "2019 Selling Campaign".

6. Choose Delivery as -> "SNS";

7. The order form will appear;

8. To add or subtract cases use "Order Adj (+or-)" column by clicking on the number and then using the "up arrow key" or "down arrow key" on your computer to increase or decrease your "Final Unit Order" to the desired amount and then click on the "Save as Draft" button when you are done;

9. The last column "Final Unit Order" shows the number of cases in your current (or "draft") order;

10. You can come back at a later time and adjust your Show & Sell order (provided that you have not clicked the Submit button);

11. Remember, for the Show & Sell YOU MUST ORDER BY THE CASE (note that the number of Packages/Bags of product in each Case is shown on the "Selling Units Case" column;

12. You can make changes to your order UP TO SEPTEMBER 6th, and provided you have not clicked the "Submit" button;

13. When you are sure that your "Final Unit Order" column is correct, click on the "Submit" Button (YOU MUST CLICK THE SUBMIT BUTTON FOR YOUR ORDER TO BE PROCESSED);

14. Your invoice will be available once your order has been approved at the Council level (approximately two or three days after your submission you will receive an approved confirmation email - if you do not get your confirmation within three days of your submission, email info@pccpopcorn.com).

15. Once you have received your order confirmation email, download your invoice by signing in to your Trails-End account and then on the left side menu click on "Popcorn".

16. Prepare a posted dated cheque (dated October 31st and made out to "Scouts Canada") in the amount owing to Council and bring it with you when you pick up your Show & Sell order. This Cheque must be brought with you in order to receive your Show & Sell stock.

MAKE SURE THAT YOU START ENTERING YOUR DATA WELL BEFORE THE OCTOBER 29TH DEADLINE

***DO NOT DO ANY ENTRIES UNTIL YOU HAVE CAREFULLY READ THE ENTIRE FOLLOWING INSTRUCTIONS, PLEASE.

THESE INSTRUCTIONS SHOULD MAKE YOUR WORK LOAD LESS. OFTEN IT IS EASIER TO PRINT THESE INSTRUCTIONS OUT AND FOLLOW THEM AS YOU ARE MAKING YOUR GROUP WORKSHEET ENTRIES AS WELL AS THE POPCORN ORDERING SYSTEM ENTRIES.

We will be using the Group Worksheet to record individual's "Take Order" product quantities and the individual's Show & Sell dollar assignments (click on "DOCUMENTS" to download this year's Group Worksheet). This spreadsheet will summarize an individual's popcorn sales quantities, the Take Order earnings and Show & Sell earnings as well as the Traditional Rewards choices for groups who have opted into the Traditional Rewards Program. It will then be used when entering the final "TAKE ORDER" popcorn quantities and information into the Popcorn Ordering System (Trails-End system).

Orders must be entered onto the Popcorn Ordering System (Trails-End website) for each Group no later than the deadline shown on the TIMELINE of this website. In addition, the final Worksheet must be emailed to info@pccpopcorn.com no later than the deadline shown on the Timeline.

If youth have sold popcorn by SHOW & SELL, the amounts they sell must be tracked. A separate Sales Form should be created for tracking purposes. For example, if eight sellers are taking turns at a table in front of a store for a day, the total dollar sales amount needs to be allocated to each seller according to the hours they spent at the table and what was sold in those hours. Each Popcorn Coordinator in each section (Beaver Scouts, Cub Scouts, Scouts, etc.) must track these sales carefully. As many of you know, Excel spreadsheets work well for tracking sales in a variety of ways.

To place your "TAKE ORDER", you must carefully follow these steps:

"Download" the current "Group Popcorn Worksheet" (which can be found on the "DOCUMENTS" page of this website) and save it to your desktop IN EXCEL FORMAT (DO NOT OPEN THE DOCUMENT IN GOOGLE SHEETS AS IT WILL NOT WORK FOR YOU). The saved name of the file must include your group name.

Save 2 copies - one to start with the word PRACTICE if you feel you need it. The other one will be your FINAL copy to be used for your Popcorn Ordering and also to be sent to info@pccpopcorn.com.

1. Open the spreadsheet, click on the " Group Name & Info" tab, and fill in your: Group Name, Your Name and your Phone Number (cell preferred). (Save the file).

2. Now go to Tab - "Sellers Orders." Spend some time studying this form (you may want to save a "practice file to test out).

3. GO TO YOUR FINAL COPY and THEN in the left column, enter all the names of the youth who sold popcorn in each Section (remember to save your file frequently); Try to have all sellers together for each section as you cannot use the sort function as it will mess up the other spreadsheets.

4. Enter the number of packages (also called containers) that each youth sold of each item for the "TAKE ORDERS" excluding the SHOW & SELL sales;

5. Enter any SHOW & SELL dollar allocations for each youth in the "Show & Sell column; We trust that all S&S sales were tracked for each youth so that you have this information. If the tracking did NOT occur, you will need to estimate and allocate the sales to the individuals who participated in the Show & Sell the best you can because these sales will also contribute to the prizes/rewards that each youth earn.

6. We assume that ahead of using this spreadsheet, you will use your own Excel or something similar to figure out the $$ sold and items sold for each youth and calculate their Total Sales.

7. Check that the "TOTAL SALES" are correct for each youth; IF A YOUTH IS CLOSE TO SPECIAL REWARDS, PLEASE LOOK SERIOUSLY AT THIS SITUATION AND SEE IF THE AMOUNT NEEDED CAN BE SOLD RIGHT AWAY SO THEY EARN THEIR SPECIAL PRIZE I.E. SCHOLARSHIP MONEY ($2500.00 for first qualification). Or other amounts for any Rewards. Explain this to parents.

8. ****If you have any Show and Sell popcorn stock left over that you will be using to offset the Take Order, then click on the SELLERS ORDERS and add a line called "S&S Leftover Stock", and enter all the remaining stock as Negative Numbers. This will decrease the number of packages for your Group Order.

9. Click on the "SELLERS ORDERS" page again and view the popcorn quantities in the purple row near the top of the spreadsheet which shows your order. You must now do a separate calculation to cross check that the quantities in the purple row are indeed the stock that you will need.

10. If your Group has opted into the Traditional Rewards Program, Click on the "Traditional Prizes Sheet" tab and add the "Reward Code" and "Reward Chosen Description" for each youth - note that the names and $$$ sold will have already been transferred to this sheet. Please ensure that the correct name of the prize and the prize code are entered for each qualifying youth. Do not use the "Sort" function on this spreadsheet;

11. Once you have checked and "verified" that your entries are correct, click on "File Save As" and save the file with the words "PCCFINAL2019" at the end of the file name (eg. 2ndLakeView Popcorn Sales PCCFINAL2019);

12. Print out the "Sellers Orders" page and now you are ready to enter your final order into the Popcorn System;

13. Click on the Popcorn System website scouting.trails-end.com and sign into your account (follow the "TEST THE POPCORN ORDERING SYSTEM RIGHT AWAY" at the top of this page if you have not already done so).

14. When you have signed in, size the page to FULL SCREEN so that all the selection subpages will show across the page near the top (eg. DETAIL, CONTACTS, ORDER, etc.).

15. Click the "Order Popcorn" button. Choose the delivery as "Take Order". You will now be able to see your entire Take Order quantities. Using the "Order Adj (+/-) column, enter the quantities of containers (ie packages) needed . Remember cs:=cases and ct:=containers (or packages).

16. The "Final Unit Order" column should equal the top purple line of your worksheet (remember, if you have show & sell stock left over, be sure it is deducted from your Take Order quantities (ie put in a line of negative numbers on your Group Worksheet equal to the packages you have left over).

17. The "Final Unit Order" column must also equal your final required stock.

18. Again, double check your order and when you are sure it is correct and final, click the "Submit" Button (this submits your final order to Council).

19. DO NOT MAKE ANY CHANGES TO YOUR ORDER AFTER YOU SUBMIT YOUR ORDER TO COUNCIL AS YOUR ORDER WILL BE INCORRECT. If you have found that a Scout has brought in a late order, after you have clicked "Submit to Council", call Steve at 604-396-4533. We may be able to make the changes needed, or a small amount of popcorn might be available from the extra Council stock;

20. Once your Oder has been approved by the Council, print your Unit Invoice by clicking on "Reports" and then "Invoice". The amount of the cheque payable to Scouts Canada is at the bottom of your invoice (follow timeline instructions) YOUR CHEQUE MUST BE HANDED IN TO SCOUT HOUSE BEFORE FRIDAY NOVEMBER 1st at 4:00pm;

21. One of the final steps is to email your final "......PCCFINAL2019" spreadsheet to info@pccpopcorn.com no later than the date shown on the TIMELINE.

IF YOU HAVE PROBLEMS WITH THE POPCORN ORDERING SYSTEM, YOU CAN CONTACT THE TRAILS-END HELP LINE:

help@trails-end.com

OR CALL THEM DIRECTLY AT 1-888-997-3897.

MAKE SURE THAT YOU START ENTERING YOUR DATA WELL BEFORE THE OCTOBER 29TH DEADLINE

The National Rewards (Visa cards & Adventure Boxes) will automatically be sent to each winner. Note that only youth will qualify for the National rewards (not Scouters).

For the Groups who are participating in the Traditional Rewards Program, you must complete the rewards selection on the Group Worksheet and mail a separate cheque made out to "Scouts Canada" to the 21st Capilano Group, Attn: Scouter Steve, 971 Belgrave Avenue, North Vancouver, BC V7R 1Z3 by the due date shown on the "TIMELINE". These rewards will be available when you pick up your "Take Orders" at the warehouse.

The Trail's End Scholarship reward requires separate documentation. YOU MUST complete the Scholarship Enrollment Form and make a copy of the individual's "Popcorn Sales Order Forms" for each participant who achieves the Scholarship Reward level or who was a previous Scholarship qualifier AND EMAIL THEM TO info@pccpopcorn.com by the due date shown on the "TIMELINE" (the scholarship form can be downloaded from the "DOCUMENTS" page). The scholarship requirement information sheet can also be downloaded from the "DOCUMENTS" page.

It is IMPORTANT TO NOTE that if a participant has reached the Scholarship level in a previous year, a copy of their current "Popcorn Sales Order Form" and a completed Scholarship Rewards form must be emailed no matter what their sales level is this year (6% of their sales will go towards their scholarship fund). Please ensure that parents know that they are responsible for tracking scholarship information each year. The list of Scholarship qualifiers since 2003 is on the DOCUMENTS page.

***BE SURE TO COMPLETE ALL FINAL TIMELINE ITEMS WHEN YOUR ORDER HAS BEEN SUBMITTED TO COUNCIL.

***KEEP COPIES OF ALL THE POPCORN ORDER SHEETS FOR THE SCOUTS TO USE NEXT YEAR AS REFERENCE FOR NAMES FOR ADDITIONAL SALES and KEPT FOR A NUMBER OF YEARS AS VERIFICATION FOR SCHOLARSHIPS.

CONGRATULATIONS!! YOU READ THIS FAR - NOW probably a good idea to print out these instructions so you can check off what has been done, along with the Timeline at the beginning of this website.

If you have any questions, you can email us at info@pccpopcorn.com or you can phone Steve directly at 604-396-4533.

--------------------------------------------------------------------------------------------