Loading ...
Sorry, an error occurred while loading the content.
 

spreadsheet to manage GS Week orders

Expand Messages
  • RJ Herbison
    The attached spreadsheet might make it easier for you to encourage a volunteer to run this - I just made one for our SU so it was no extra work to share. Note:
    Message 1 of 1 , Feb 5, 2014
      The attached spreadsheet might make it easier for you to encourage a volunteer to run this - I just made one for our SU so it was no extra work to share.

      Note: Set the prices that your SU pays in row 2.  Mkae sure they match the order form that you give to leaders.
      It may be difficult to estimate accurately how many will participate in your first year. If you sell at least 46, you will not lose any money if each patch is $0.80. If you sell at least 76, the price can drop to $0.75 each.

      If you plan to make this a "money earner", a form needs to be approved by GSNNJ first.
      (if you sold 100 of any of those mix & match patches from snappy logos at $1 each, the SU would make $26, and the girls would have patches at $0.49 less than if they bought the new Birthday Week patch that GSUSA sells)

      A table of the price breaks that I calculated follows - unless I made a mistake or S&H suddenly changed. (A version with more rows is in the summary tab of the attached file)

      yigggs,
          Robin
      life member, GSUSA
      member, GSNNJ
      former SUM, Parsippany (100 troops and 900 girls)
      delegate, 1979 GSUSA National Convention







      (if you buy only mix & match pricing and no cheaper patches)

      patchesprice each
      S&Htotal price



      50 $                                     0.68 $    34.00 $      5.65 $                                        39.65

       $    0.79
      56 $                                     0.68 $    38.08 $      5.65 $                                        43.7356 patches CHEAPER than 49 $    0.78
      49 $                                     0.78 $    38.22 $      5.65 $                                        43.87

       $    0.90
      100 $                                     0.68 $    68.00 $      5.65 $                                        73.65

       $    0.74
      250 $                                     0.59 $  147.50 $      8.95 $                                      156.45

       $    0.63
      286 $                                     0.59 $  168.74 $    10.95 $                                      179.69286 patches same price each as 250, but total is LESS $    0.63
      249 $                                     0.68 $  169.32 $    10.95 $                                      180.27

       $    0.72
      450 $                                     0.52 $  234.00 $    13.95 $                                      247.95

       $    0.55
      566 $                                     0.52 $  294.32 $    13.95 $                                      308.27Cheaper to buy 566 patches than 499! $    0.54
      499 $                                     0.59 $  294.41 $    13.95 $                                      308.36

       $    0.62

      ###

    Your message has been successfully submitted and would be delivered to recipients shortly.