Docstoc

popcorn spreadsheet Fall 2009

Document Sample
popcorn spreadsheet Fall 2009 Powered By Docstoc
					                                        2009 FALL Popcorn Sale SMART Forms
This document will help you complete the 2009 Fall Popcorn Sale paperwork. Along the bottom of the screen, you
will see a series of worksheets that are the forms required for this year's sale. To open these worksheets, just
click your mouse on them - starting with the "Show & Deliver" tab. All worksheets are protected, so there is no
worry of harming the program - just use your tab key on your keyboard to move through the fields that require you
to provide information. Follow these simple instructions:



                          If your unit is participating in the Show & Deliver Sale, start with the "Show & Deliver" tab, otherwise skip this step and
                          move to the next box of instructions. Show & Deliver method of popcorn sales is when the unit orders popcorn and
                          use this popcorn to sell immediately to the customer. These sales can be done through door to door canvassing, at
  Show & Deliver




                          booth sales at an event, or in front of a store with the proper approvals/permission.
                          This form is required to place your unit's Show & Deliver order, to pick up the order at delivery, and to return any
                          unused popcorn when the sale is completed. Use your tab key to fill in the "ordered" boxes and your unit's Popcorn
                          Kernel information. Once the ordering information is completed, save the document on your computer as "YOUR
                          UNIT # 2009 Fall Popcorn" i.e. " Pack 100 2009 Fall Popcorn "
                          To submit the completed worksheets, just make sure you have saved the document, as described above, open a new
                          e-mail addressed to popcornsale@mccbsa.org, attach the saved document and press send. You will receive an
                          electronic receipt of your order. If you do not have internet access, print this worksheet for your
                          records and submit a copy of it to:
                          Boy Scout Popcorn Order, 330 South 84th Street, Milwaukee, WI 53214-1468, or FAX (414) 774-1799.
                          Refer to the 2009-2010 Popcorn Sale Unit Resource Guide for additional info. on the Show & Deliver Sale.




                           The "Unit Master Record" tab is where your unit's information is entered and then utilized automatically in the
  Unit Master Record




                          remaining worksheets. Start by completing the required information called for in the green boxes, which can be easily
                          tabbed through.

                          Once you have gathered every Scout's order forms it is time to enter the required information regarding each Scout's
                          sale. Complete each youth's personal information, number of containers sold in each product line and prize codes.
                          This is the bulk of your required work. From this point on all forms are automated.

                          Please note that this worksheet is to be completed using the total containers sold by each Scout, from both the Show
                          & Deliver and the Take Order Sales.

                          This worksheet will serve as your unit's master record, show what popcorn needs to be picked up during the Take
                          Order Sale product delivery, and serve as your unit's delivery receipt.
Unit Order & Settlement




                          This form is automated and requires no calculations to be completed. It summarizes the Show & Deliver Sale, Take
                          Order Sale and provides you with a total of your unit's gross dollars sold.
                          Also calculated in are your unit's commission based upon 33% commission & prizes, or 37% commission & no prizes.
                          The amount due to the council is indicated. This allows you to deduct the unit's commission from the gross dollars
                          and then write a check for the balance - your unit keeps its profit and does not have to wait to receive a check from
                          the council.
                          Additional sale statistics are included on this worksheet.
         Finally, the "Prizes" tab shows the prizes that need to ordered for the unit. This form should be submitted with the rest
Prizes




         of the unit's paperwork even if your unit chose the cash option, with no prizes, because Super Seller incentives are
         shown here and this incentives are available to those receiving prizes and those electing the cash option. All four
         popcorn forms should be submitted in a group by November 4th, along with your post-dated check
         (12/11/2009).
                       Show & Deliver Sale Pick up and Drop off Reconciliation Form
  Date of                    Date of                          Date of                              District         Iron Horse                          Popcorn Kernel              JAMES HEGYI
  pick up #1                 pick up #2                       pick up #3
                                                                                                                             #
     10/3/09                     10/2/09                          10/1/09                       Unit Type        Pack       595                          Phone Number                262-366-6621
   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver             Show & Deliver        This form is for only those units that
Chocolate Lover's Tin      Chocolate Lover's Tin           Chocolate Lover's Tin         Chocolate Lover's Tin         Chocolate Lover's Tin      Chocolate Lover's Tin   participate in the Show & Deliver Sale.
    Ordered                     Ordered                          Ordered                       Ordered                  Can't Be Returned                Sold                               Tab Key on
        0             +                                +                           =               0               -                         =             0                                Keyboard

   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver              Show & Deliver       Tab through all of the green selection
Savory & Sweet Tin         Savory & Sweet Tin               Savory & Sweet Tin            Savory & Sweet Tin           Savory & Sweet Tin          Savory & Sweet Tin     boxes and complete the following
                                                                                                                                                                          information, including your unit
     Ordered                    Ordered                          Ordered                       Ordered                  Can't Be Returned                 Sold
                                                                                                                                                                          contact information at the top:
        0              +                               +                           =              0                -                         =             0
                                                                                                                                                                          1) List the number of individual
   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver              Show & Deliver
                                                                                                                                                                          containers ordered for the Show &
 Cheese Lover's Tin         Cheese Lover's Tin              Cheese Lover's Tin            Cheese Lover's Tin            Cheese Lover's Tin       Cheese Lover's Tin       Deliver Sale.
    Ordered                     Ordered                         Ordered                        Ordered                      Returned                      Sold
       2               +                               +                           =              2                -                         =             2              Note this is not asking for cases, but
                                                                                                                                                                          rather individual containers. Please
   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver             Show & Deliver        order in full cases for this portion of
Chocoatey Tri Delight      Chocoatey Tri Delight           Chocoatey Tri Delight         Chocoatey Tri Delight         Chocoatey Tri Delight      Chocoatey Tri Delight   the sale. The box below will indicate
    Ordered                     Ordered                         Ordered                        Ordered                  Can't Be Returned                 Sold            an ordering error if full cases are not
        0             +                                +                           =              0                -                         =             0              ordered. This sheet allows 3 product
                                                                                                                                                                          pickups, leave unrequired boxes
   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver              Show & Deliver       blank.
 Large Caram Corn           Large Caram Corn                Large Caram Corn              Large Caram Corn              Large Caram Corn            Large Caram Corn
                                                                                                                                                          Sold            2) List the number of individual
     Ordered                    Ordered                          Ordered                       Ordered                      Returned
                                                                                                                                                           0
                                                                                                                                                                          containers that were not sold and
        0              +                               +                           =              0                -                         =                            returned to the Scout Office on April
   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver
                                                                                                                                                                          7th.
                                                                                                                         Show & Deliver              Show & Deliver
  Light Caram Corn           Light Caram Corn               Light Caram Corn               Light Caram Corn             Light Caram Corn            Light Caram Corn
                                                                                                                                                                          3) Print out a copy to order your
     Ordered                     Ordered                         Ordered                         Ordered                    Returned                      Sold            popcorn and to accompany any
         0             +                               +                           =                0              -                         =             0              returns of product to the council. A
                                                                                                                                                                          printed sheet is required for every
   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver              Show & Deliver       exchange of product.
15 Pack Butter Micro       15 Pack Butter Micro            15 Pack Butter Micro          15 Pack Butter Micro          15 Pack Butter Micro        15 Pack Butter Micro
    Ordered                     Ordered                          Ordered                       Ordered                      Returned                      Sold
       24              +                               +                           =              24               -            6           =              18

   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver             Show & Deliver
 15 Pack Light Micro        15 Pack Light Micro            15 Pack Light Micro            15 Pack Light Micro          15 Pack Light Micro         15 Pack Light Micro
     Ordered                     Ordered                        Ordered                        Ordered                     Returned                       Sold
       12              +                               +                           =              12               -           6           =               6

   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver              Show & Deliver
 Small Caram Corn           Small Caram Corn                Small Caram Corn              Small Caram Corn              Small Caram Corn            Small Caram Corn
   Ordered                     Ordered                           Ordered                       Ordered                     Returned                       Sold
       24              +                               +                           =             24                -           6             =             18

   Show & Deliver             Show & Deliver                  Show & Deliver                Show & Deliver               Show & Deliver              Show & Deliver
 Popping Corn Pail          Popping Corn Pail               Popping Corn Pail             Popping Corn Pail             Popping Corn Pail           Popping Corn Pail
    Ordered                    Ordered                          Ordered                       Ordered                      Returned                       Sold
       12              +                               +                           =             12                -                         =             12


  Total Product at Delivery                    Cases         Full Cases Only                      74                           18                          56
                             # Per Case                    NO Partial Orders
  Chocolate Lover's Tin          1/Case            0                                                                        20% Return Warning Penalty Will Be
  Savory & Sweet Tin             1/Case            0                                                                                    Assessed
  Cheese Lover's Tin             1/Case            2                                                                                                                           Click Here for E-mail
                                                                                          A copy of this form
  Chocoatey Tri Delight          6/Case            0
                                                                                        should be printed and
                                                                                                                            _____________________________________                  Instructions
  Large Caram Corn               6/Case            0                                                                                   Unit Representative
                                                                                       signed for each product
  Light Caram Corn               6/Case            0
                                                                                         delivery and product
  15 Pack Butter Micro           6/Case            4                                                                        _____________________________________
                                                                                                return.
  15 Pack Light Micro            6/Case            2                                                                             Council Popcorn Representative
  Small Caram Corn               6/Case            4
  Popping Corn Pail              6/Case            2




         Milwaukee County Council, BSA                                                                                                                                                       9/25/2012
Milwaukee County Council, BSA   9/25/2012
                                This form is for only those units that
                                participate in the Show & Deliver Sale.



                                                   he green selection




                                                 asking for cases, but
                                rather individual containers. Please
                                order in full cases for this portion of
                                the sale. The box below will indicate
                                an ordering error if full cases are not
                                ordered. This sheet allows 3 product




                                returned to the Scout Office on April




Milwaukee County Council, BSA                                             9/25/2012
                           District:                  Iron Horse                                                                                               Popcorn Kernel's Name                                                 262-784-4766               Home
                                                                                                                                                                   JAMES HEGYI                                                       414-791-3107               Work
                       Unit Type:                 Pack                                                                                                               Email Address                                                                              Fax
                                                                                                                                                                  jim@canoestories.com
                            Unit #:                   595                                                                                                   Mailing Address                                               City, State, Zip Code
                                                                                                                                                    15901 W Mayflower Dr                                              New Berlin, WI 53151
              Participating in the prize program?            No                                                                                                                       Unit Leader's Name & Phone #
                                                                                                                                                         William Imp - CC                                              414-427-4423


                               Scout Information                                                                            Show & Deliver and Take Order Combined Sales Per Youth                                                                                                                                                      Standard Prizes
                                                                                                                                                                                                                                                                                                                                                                                                      Six Flags
                                                                                                                                                                                                                                                                                                                                                                                                       Tickets     Enter a "1" if                  $50
                                                                                                                                                                                                                                                                          Total Sold per   Combined Sales
                                                            Den/                    Show &
                                                                                                Support Our   Chocolate      Savory &    Cheese Lover's Chocoatey Tri   Large Caram   Light Caram   15 Pack Butter 15 Pack Light   Small Caram   Popping Corn                                                                Prize                                                                    Earned for   Scout Filled a   Scholarship   Bonus
  First Name        Last Name          Phone Number                     Date       Deliver or                                                                                                                                                                         0   Type of Sale     Total per Scout   Patch or Pin                                 Prize Description
                                                            Patrol                                Troops      Lover's Tin    Sweet Tin        Tin          Delight          Corn          Corn          Micro          Micro          Corn           Pail                                                                   Selection                                                                   selling     Sales Form                    Prize
                                                                                  Take Order
                                                                                                                                                                                                                                                                                                                                                                                                       $1,000+


            Show & Deliver Inventory to be used to fill Take Orders.

                                                                                    S&D                                                        1                                                          8              1              5             2                            $235                                                  You've Selected not to participate in prizes in the yellow
US Bank           NA                   262-366-6621           1        10/10/09                                                                                                                                                                                                                       $235                                                     box above
                                                                                  T-Order                                                                                                                                                                                            $0
                  Imp                                                               S&D             2                                          1                                                          1              3              3             5                            $220
John                                                                   10/4/09                                                                                                                                                                                                                        $260
                  Church S&S                                                      T-Order                                                                     1              1                                                                                                      $40
                                                                                    S&D                                                                                                                                  2                            2                             $50
Mike              Sibila                                                                                                                                                                                                                                                                               $50
                                                                                  T-Order                                                                                                                                                                                            $0
All Other                                                                           S&D                                                                                                                   9                            10             3                            $265
Scouts
                                                                                                                                                                                                                                                                                                    $1,630                                                                                                0                                        Yes
                                                                                  T-Order           5             1             2              7             10             13            7               2             11              7             7                          $1,365
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0
                                                                                  T-Order                                                                                                                                                                                            $0
                                                                                    S&D                                                                                                                                                                                              $0
                                                                                                                                                                                                                                                                                                        $0


                                                                                                                                                                                                                      Page 6 of 13                                                                                                                                                                                            9/25/2012
                    Scout Information                                                             Show & Deliver and Take Order Combined Sales Per Youth                                                                                                                                                Standard Prizes
                                                                                                                                                                                                                                                                                                                                         Six Flags
                                                                                                                                                                                                                                                                                                                                          Tickets     Enter a "1" if                  $50
                                                                                                                                                                                                                                          Total Sold per   Combined Sales
                                        Den/              Show &
                                                                      Support Our   Chocolate      Savory &    Cheese Lover's Chocoatey Tri   Large Caram   Light Caram   15 Pack Butter 15 Pack Light   Small Caram   Popping Corn                                                          Prize                                       Earned for   Scout Filled a   Scholarship   Bonus
First Name   Last Name   Phone Number            Date    Deliver or                                                                                                                                                                   0   Type of Sale     Total per Scout   Patch or Pin                            Prize Description
                                        Patrol                          Troops      Lover's Tin    Sweet Tin        Tin          Delight          Corn          Corn          Micro          Micro          Corn           Pail                                                             Selection                                      selling     Sales Form                    Prize
                                                        Take Order
                                                                                                                                                                                                                                                                                                                                          $1,000+
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0
                                                          S&D                                                                                                                                                                                        $0
                                                                                                                                                                                                                                                                        $0
                                                        T-Order                                                                                                                                                                                      $0




                                                                                                                                                                                            Page 7 of 13                                                                                                                                                         9/25/2012
                    Scout Information                                                                         Show & Deliver and Take Order Combined Sales Per Youth                                                                                                                                                 Standard Prizes
                                                                                                                                                                                                                                                                                                                                                      Six Flags
                                                                                                                                                                                                                                                                                                                                                       Tickets     Enter a "1" if                  $50
                                                                                                                                                                                                                                                      Total Sold per   Combined Sales
                                            Den/                      Show &
                                                                                  Support Our   Chocolate      Savory &    Cheese Lover's Chocoatey Tri   Large Caram   Light Caram   15 Pack Butter 15 Pack Light   Small Caram   Popping Corn                                                           Prize                                       Earned for   Scout Filled a   Scholarship   Bonus
First Name   Last Name   Phone Number                     Date       Deliver or                                                                                                                                                                   0   Type of Sale     Total per Scout   Patch or Pin                             Prize Description
                                            Patrol                                  Troops      Lover's Tin    Sweet Tin        Tin          Delight          Corn          Corn          Micro          Micro          Corn           Pail                                                              Selection                                      selling     Sales Form                    Prize
                                                                    Take Order
                                                                                                                                                                                                                                                                                                                                                       $1,000+

                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                                                      S&D                                                                                                                                                                                         $0
                                                                                                                                                                                                                                                                                    $0
                                                                    T-Order                                                                                                                                                                                       $0
                                 Show & Deliver Sales Total:                          2             0             0              2              0              0            0              18              6             18            12                       $770
                                        Take Order Sales Total:                       5             1             2              7             11             14            7               2             11              7              7                   $1,405
                                                     Total Sales:                     7             1             2              9             11             14            7              20             17             25            19                    $2,175                                                                                       0             0

             Unaccounted for product which will be added to your Unit
                                      Order & Settlement Worksheet:


                                                                                                                                                                                                                              Take Order Sale            Cases                                  Containers


                                                                                                                                                                                                                     Chocolate Lover's Tin                 1
                                                                                                                                                                                                                     Savory & Sweet Tin                    2
                                                                                                                                                                                                                     Cheese Lover's Tin                    7
                  Click Here for E-mail                                                                                                                                                                              Chocoatey Tri Delight                 1                                        5
                      Instructions                                                                                                                                                                                   Large Caram Corn                      2                                        2
                                                                                                                                                                                                                     Light Caram Corn                       1                                       1
                                                                                                                                                                                                                     15 Pack Butter Micro                   0                                       2
                                                                                                                                                                                                                     15 Pack Light Micro                    1                                       5
                                                                                                                                                                                                                     Small Caram Corn                       1                                       1
                                                                                                                                                                                                                     Popping Corn Pail                      1                                       1
                                                                                                                                                                                                                                                           17                                       17




                                                                                                                                                                                                        Page 8 of 13                                                                                                                                                          9/25/2012
                  District          Iron Horse                                                                                                                                    Unit Popcorn Chairman: JAMES HEGYI
                                 Pack 595                                                                                                                                                 Home Address: 15901 W Mayflower Dr
                   Unit #
                                                                   2009 UNIT ORDER AND SETTLEMENT FORM                                                                              City, State, Zip Code: New Berlin, WI 53151
                                                                               BY CONTAINER                                                                                                          Home: 262-784-4766         Business: 414-791-3107
                                                                                                                                                                                                     Email: jim@canoestories.com

                                   Show & Deliver Sale                                                  Carryover             Take Order Sale                    Total Sales                                         Settlement Calculations
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales
Support Our Troops                  Support Our Troops                  Support Our Troops             unreturned S&D         Support Our Troops           Support Our Troops                         Gross Unit
                                                                                                           Product                                                                                      Sales
                                                                                                                                                                                                                                                    $2,175.00
       Ordered                              Returned                            Sold                                            Minus Carryover
        N/A                                                    =                 2               +          N/A           +              5             =            $175.00
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &           Take Order Sales                  Total Sales
Chocolate Lover's Tin               Chocolate Lover's Tin               Chocolate Lover's Tin          unreturned S&D         Chocolate Lover's Tin           Chocolate Lover's Tin                Commission 33%
                                                                                                           Product                                                                                   With Prizes
                                                                                                                                                                                                                                   FALSE
       Ordered                              Returned                            Sold                                               Minus Carryover
          0                  -                                 =                 0               +            0           +              1             =             $50.00
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales
 Savory & Sweet Tin                   Savory & Sweet Tin                Savory & Sweet Tin             unreturned S&D         Savory & Sweet Tin               Savory & Sweet Tin                Commission 37% Cash
                                                                                                           Product                                                                                 Option/No Prizes
                                                                                                                                                                                                                                   $804.75
       Ordered                              Returned                            Sold                                            Minus Carryover
          0                  -                                 =                 0               +            0           +              2             =             $80.00
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales
 Cheese Lover's Tin                  Cheese Lover's Tin                  Cheese Lover's Tin            unreturned S&D          Cheese Lover's Tin              Cheese Lover's Tin
       Ordered                              Returned                            Sold                       Product              Minus Carryover                                                    Unit Commission
                                                                                                                                                                                                                                   $804.75     -     $804.75
          2                  -                 0               =                 2               +            0           +              7             =            $270.00
                                                                                                                                                                                                                                                   __________
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales
Chocoatey Tri Delight               Chocoatey Tri Delight               Chocoatey Tri Delight          unreturned S&D         Chocoatey Tri Delight            Chocoatey Tri Delight
       Ordered                              Returned                            Sold                       Product              Minus Carryover
          0                  -                                 =                 0               +            0           +              11            =            $220.00
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales                Amount Due to the Council                         $1,370.25
 Large Caram Corn                    Large Caram Corn                    Large Caram Corn              unreturned S&D          Large Caram Corn                  Large Caram Corn                                             Make Check Payable: MCC-BSA
       Ordered                              Returned                            Sold                       Product              Minus Carryover
          0                  -                 0               =                 0               +            0           +              14            =            $280.00                        SALE REPORT
                                                                                                                                                                                                     0                         4                   $543.75
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales
 Light Caram Corn                    Light Caram Corn                    Light Caram Corn              unreturned S&D          Light Caram Corn                  Light Caram Corn
                                                                                                                                                                                                   # of                                        Average Dollars
                                                                                                                                                                                                                             # Who
       Ordered                              Returned                            Sold                       Product              Minus Carryover
                                                                                                                                                                                                Registered                                     per Scout Selling
                                                                                                                                                                                                                              Sold
                                                                                                                                                                                                 Scouts
          0                  -                 0               =                 0               +            0           +              7             =            $105.00                                                 Popcorn
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales
15 Pack Butter Micro                15 Pack Butter Micro                15 Pack Butter Micro           unreturned S&D         15 Pack Butter Micro              15 Pack Butter Micro
       Ordered                              Returned                            Sold                       Product              Minus Carryover
         24                  -                 6               =                18               +            0           +              2             =            $300.00                      Unit's
                                                                                                                                                                                                                   $16.48
     Show & Deliver                   Show & Deliver                    Show & Deliver                                         Take Order Sales                     Total Sales                 Average
                                                                                                       This is unsold &
15 Pack Light Micro                 15 Pack Light Micro                 15 Pack Light Micro            unreturned S&D         15 Pack Light Micro               15 Pack Light Micro
                                                                                                                                                                                                Container
       Ordered                              Returned                            Sold                       Product              Minus Carryover
         12                  -                 6               =                 6               +            0           +              11            =            $255.00
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales
 Small Caram Corn                    Small Caram Corn                    Small Caram Corn              unreturned S&D          Small Caram Corn                  Small Caram Corn
       Ordered                              Returned                            Sold                       Product              Minus Carryover
         24                  -                 6               =                18               +            0           +              7             =            $250.00
     Show & Deliver                   Show & Deliver                    Show & Deliver                 This is unsold &        Take Order Sales                     Total Sales
 Popping Corn Pail                   Popping Corn Pail                   Popping Corn Pail             unreturned S&D          Popping Corn Pail                Popping Corn Pail
       Ordered                              Returned                            Sold                       Product              Minus Carryover
         12                  -                 0               =                12               +            0           +              7             =            $190.00

                                                       S&D Containers           58             T.O. Containers                           74           Total          $2,175.00
                                                                                               Total Containers                         132
                                                                              TRAIL'S END UNIT PRIZE ORDER FORM


               781200                                      Milwaukee County Council                                                                          Milwaukee, WI
          Council's Customer #                               Council Name                                                               Council City/State

Unit Leaders: Please return this form with your popcorn order by: November 4th
Person Placing Order/Unit Leader

                    JAMES HEGYI                                                                                          Iron Horse                          595
                    Unit Popcorn Kernel                                                                                      District                     Pack#               Troop#              Crew#

                                                                                                 15901 W Mayflower Dr
                                                                         Street - Fed/Ex Will NOT deliver to PO Box - must be a physical street address

                                                                                New Berlin, WI 53151
                                                    City                                                                     State                                 Zip Code
                jim@canoestories.com                                           414-791-3107                                             262-784-4766
                      E-Mail Address                                          Phone Number Day                                   Phone Number Evening


                                         Level 1 - $10                                                                                                        Level 7 - $825
              59071        Trail's End Patch (Individual)                                                                            09-7A        Coleman 7 x 5 Sundome Tent
                                                                                                                                     09-7B        Meade Adventure Pack
              59081        Trail's End Pin (Individual)                                                                              09-7C        GPX 2GB MP3 Player / Video Player
                                        Level 2 - $125                                                                             BSA30          Scout Stuff Gift Card
              09-2A        Master Jack Knife                                                                                       WM30           Wal-Mart Gift Card
              09-2B        Hand Crank/Eco Friendly Flashlight                                                                       C30           Coleman Web Gift Certificate
              09-2C        FM Scanner Radio                                                                                                                  Level 8 - $1,100
              09-2D        75 piece Balloons Sling Shot with Pump                                                                    09-8A        Meade 100 x 50 Telescope
                                          Level 3 - $225                                                                           09-8B          Cobra 22 Mile GMRS Rechargeable Radio Set
              09-3A        Lego Racers Set                                                                                         09-8C          RCA 2GB MP3 Player
              09-3B        11 in 1 Multi Tool with LED Light                                                                       BSA45          Scout Stuff Gift Card
              09-3C        Eva Glider Set                                                                                          WM45           Wal-Mart Gift Card
              09-3D        Regulation Football                                                                                      C45           Coleman Web Gift Certificate
                                          Level 4 - $325                                                                                                     Level 9 - $1,300
              09-4A        Lego Power Miners Set                                                                                     09-9A        Coleman 1 Person Kayak with Paddles
              09-4B        11 in 1 Multi Tool, Compass & Torch                                                                       09-9B        RCA 4GB MP3 Player
              09-4C        4 Piece Outdoor Kit Set                                                                                 09-9C          Coleman Montana 9 x 7 Tent
              09-4D        Trailworthy All Purpose Backpack                                                                        BSA65          Scout Stuff Gift Card
                                        Level 5 - $425                                                                               WM65         Wal-Mart Gift Card
              09-5A        6 in 1 Outdoor Set                                                                                         C65         Coleman Web Gift Certificate
             09-5B         Bear Archery 1st Shot Bow Set                                                                                                      Level 10 - $1,800
             09-5C         Remote Control Off Road Racer                                                                          09-10A          RCA Small Wonder HD Digital Camcorder
             BSA13         Scout Stuff Gift Card                                                                                  09-10B          Bushnell Imageview Binocular / Digital Camera
             WM13          Wal-Mart Gift Card                                                                                     09-10C          Apple iPod 2GB Shuffle
              C13          Coleman Web Gift Certificate                                                                           BSA100          Scout Stuff Gift Card
                                       Level 6 - $625                                                                              WM100          Wal-Mart Gift Card
              09-6A        Leatherman Multi Tool                                                                                    C100          Coleman Web Gift Certificate
             09-6B         GPX Clock Radio with iPod Dock                                                                                                     Level 11 - $2,300
             09-6C         Mitchell Travel Fishing Pack                                                                           09-11A          Razor Electric Scooter
             BSA22         Scout Stuff Gift Card                                                                                  09-11B          Audiovox 8" DVD Player Package
             WM22          Wal-Mart Gift Card                                                                                     09-11C          Garmin eTrex Legend GPS Unit
              C22          Coleman Web Gift Certificate                                                                           BSA140          Scout Stuff Gift Card
                                                                                                                                   WM140          Wal-Mart Gift Card
                                                                                                                                    C140          Coleman Web Gift Certificate


                                                                                                                                      Unit
   Council Bonus                                                Six Flags Great America Super Seller Qualifiers                      Total:
                                                                                                                                      Unit                                      0
      Prizes                                                                       Filled It Up Form Qualifiers                      Total:                                     0
                                            Questions about your Prize Program Levels or to order prizes - call your Council at 414-443-2844

                                          Questions about Prizes or Status of your Prize Order, call Trail's End Prize Program at 1-800-401-4015.




                                                                                                                                                                                           9/25/2012

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:11
posted:9/25/2012
language:English
pages:13