2012 Fundraising SS

Document Sample
2012 Fundraising SS Powered By Docstoc
					Instructions for using the 2012 Fundraising Tally Spreadsheet
1
2




3
4
Instructions for using the 2012 Fundraising Tally Spreadsheet
  Clear the white area with the order numbers & the members names in the 2012 Fundraising Spreadsheet (see tabs below)
  Enter values that correspond to your group's fundraiser in pink cells
          - Fundraiser $$ Profit Goal
          - # of Members Selling
          - Selling Prices
          - Shipping Costs
          - Greenzit Costs (if applicable)
  As members report sales, enter the # of items sold in the appropriate cells.
  Moniter the progress of your fundraiser using the Charts provided

  We are more than happy to answer any questions! Please call (800) 446-4229 with any questions.
My Group's 2012 Fundraising Goals:
2   Profit $$ Goal:                                              Summary                                   $            -


       Total Units Sales Goal                                    Fundraising
     (assumes $5 profit per unit
                sold)                              0                  Results                                           0

3   # of Members:                                                                                                                                                                                                                                         (see instructions below)

    Unit Sales Goal per member                 #DIV/0!
                                                                      (Next
                                                                     Column)                                   #DIV/0!                                                                                      2012 Fundraising Tally Spreadsheet
                                                                                                                                                                                                                                  Products                                                                                                                                                                                                                             Holiday Gift Products                                                      Total      Greens         Profit
                                                                                                                                                                                                                                                                                                                                                                                                                                                  Holiday          Holiday        Holiday    Holiday
                                                                                               25"                                 28"               28"               36"               36"               36"                                                                                   Cranberry                                                          25' Rope                                                                       Gift              Gift           Gift       Gift   Holiday Gift Holiday                                    Unit          earned
                                               25" Classic           25" Victorian          Cranberry      28" Classic          Victorian         Cranberry          Classic          Victorian         Cranberry      48" Classic        60" Classic         Classic          Victorian          Splash           Center-      The Living         25' Rope           with           50' Rope          EZ        Christmas Decorator              Classic          Victorian     Wintergree Cranberry  Candlelit   Gift Living                    $$ Sales    Sales          per
                                                 Wreath                Wreath                Splash          Wreath             Wreath             Splash            Wreath            Vreath            Splash          Wreath             Wreath            Spray             Spray              Spray            Piece         Tree                              Greenzit                          Hanger     Light Sets  Bags                 Wreath           Wreath        n Wreath    Wreath   Centerpiece     Tree                          per        per
4                   Your Selling Price                                                                                                                                                                                                                                                                                                                                                            $ 1 .7 5       $ 3 .7 5                                                                                                                        Member      Member        Member
         Members' Names                                                                                                                                                                                                                                                              Items Sold
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             $          -              0      $0.00
    Total Products Sold                                      0                      0                  0                0                 0                  0                0                 0                  0              0                   0                0                 0                 0                0              0                0                0                0              0            0               0                0                 0              0              0                0              0 $          -              0      $0.00
    Case Quanities To Order                                  0                      0                  0                0                 0                  0                0                 0                  0              0                   0                0                 0                 0                0              0                0                0                0
    Your Product Cost                      $        1 0 .4 8     $         1 4 .2 9     $     1 5 .2 9     $ 1 1 .6 6       $ 1 5 .1 5        $     1 6 .1 8     $ 1 8 .8 4       $ 2 2 .9 3        $     2 3 .9 4     $ 3 2 .5 9     $      5 5 .3 2     $     8 .6 9     $ 1 1 .9 8        $ 1 2 .9 9        $ 1 5 .9 8       $ 1 3 .4 9     $ 1 6 .2 9       $ 1 6 .2 9       $ 3 2 .1 0       $ 1 .2 5       $ 3 .2 5                     $ 2 3 .9 8       $ 2 7 .9 2        $ 2 8 .0 9     $ 2 8 .2 5     $   2 5 .4 5     $ 2 4 .9 3
5   Shipping Cost (if applicable)
6   Insert Greenzit cost (if applicable)
    Total Costs per Product                $         10.48       $          14.29       $      15.29       $     11.66      $     15.15       $      16.18       $ 18.84          $ 22.93           $      23.94       $   32.59      $       55.32       $      8.69      $ 11.98           $      12.99      $     15.98      $ 13.49        $ 16.29          $ 16.29          $     32.10      $ 1.25         $   3.25     $   -           $ 23.98          $     27.92       $   28.09      $ 28.25        $    25.45       $ 24.93

    Group Total Sales                      $             -       $              -       $          -       $        -       $         -       $          -       $        -       $         -       $          -       $      -       $           -       $        -       $         -       $         -       $        -       $      -       $        -       $        -       $        -       $      -       $    -       $       -       $        -       $         -       $      -       $      -       $        -       $      -     $                     -
    Group Total Costs                      $             -       $              -       $          -       $        -       $         -       $          -       $        -       $         -       $          -       $      -       $           -       $        -       $         -       $         -       $        -       $      -       $        -       $        -       $        -       $      -       $    -       $       -       $        -       $         -       $      -       $      -       $        -       $      -     $                     -

    Group Profits                          $             -       $              -       $          -       $        -       $         -       $          -       $        -       $         -       $          -       $      -       $           -       $        -       $         -       $         -       $        -       $      -       $        -       $        -       $        -       $      -       $    -       $       -       $        -       $         -       $      -       $      -       $        -       $      -     $                 -
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 TOTAL FUNDRAISING




    HOW TO USE YOUR FUNDRAISING TALLY SHEET: www.holidayfundraiser.com
    NOTE: Please replace values in pink cells with values that correspond to your organization. Do not delete any rows or columns, this will render your formulas inneffective.
                        1. Enter each of your members' names
                        2. Enter your Profit $$ Sales Goal
                        3. Enter the # of members selling
                        4. Enter your Selling Prices
                        5. Enter the Shipping Costs for your zone (if applicable)
                        6. Enter your Greenzit costs (if applicable)
                        7. You're ready to go! Record your members' sales to track the progress of your fundraiser!
                                                            1
$1


                                                            1
$1


                                                            1
$1


                                                            1
$1


                                                            1
$1
                                         Fundraising Goal                                      Fundraising Unit Goal
                                                            1
$1
                                         Profits to Date                                       Items Sold to Date

                                                            0
$0

                                                            0
$0

                                                            0
$0

                                                            0
$0

                                                            0
$0

                                                                Wreath Fundraiser Items Sold
     Wreath Fundraiser Profit Progress
                                                                         Progress
25" Classic Wreath


25" Victorian Wreath

25" Cranberry Splash



28" Classic Wreath
                                         Member Sales Bar Chart




                      Members' Item Sales to Date
                                                                  Unit Sales Goal

             1
Item Sales




             1

             0
                    Individual Sales Goal & Progress

                 Member Sales Goals & Progress




                                                Page 6

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:10/4/2013
language:English
pages:6
huangyuarong huangyuarong
About