Docstoc

Formulas

Document Sample
Formulas Powered By Docstoc
					                                      Fall Festival Supplies
                                       2006                    2007            Projected for 2008
                               Amount Used Cost        Amount Used Cost        Amount Used
Food
Hot Dogs                               300    $54.00           315    $57.00            307.5
Buns                                   312    $30.00           299    $31.00            305.5
Chip packages                          400    $75.00           411    $75.00            405.5
Canned drinks                          240   $100.00           260   $115.00              250
Juice boxes                            189    $89.00           200    $95.00            194.5
Ice bags                                17    $35.00            15    $32.00                16
Cookies                                308    $42.00           312    $45.00              310
Cocoa Packets                           92    $16.00            45    $10.00             68.5
Coffee packets                           8    $18.00             5    $12.00               6.5
Ketchup Bottles                          3    $12.00             3    $12.00                 3
Mustard Bottles                          3    $11.00             3    $11.00                 3
Relish Bottles                           2     $6.00             2     $6.00                 2
Creamer (individual packets)            62    $15.00            48    $12.00                55
Sugar (individual packets)              85    $12.00            52    $12.00             68.5
Totals                                       $515.00                 $525.00



Supplies
Hot Dog Trays
Napkins
Stir Sticks
Coffee/Cocoa cups
Wet wipes
ojected for 2008
              Cost

                $55.50
                $30.50
                $75.00
               $107.50
                $92.00
                $33.50
                $43.50
                $13.00
                $15.00
                $12.00
                $11.00
                 $6.00
                $13.50
                $12.00
               $520.00
Built-in Calculator
             45                           2
             84                           3
             62                           5
             27                           4
            112                           6
                                          7
                                          9




       Autofill Examples
       January                    Monday                          35                       35
       February                   Tuesday                         35                       45
       March                      Wednesday                       35                       55
       April                      Thursday                        35                       65
       May                        Friday                          35                       75
       June                       Saturday                        35                       85
       July                       Sunday                          35                       95
       August                     Monday                          35                      105
       September                  Tuesday                         35                      115
       October                    Wednesday                       35                      125
       November                   Thursday                        35                      135
       December                   Friday                          35                      145


       January        February    March        April        May        June        July          August

       Monday         Tuesday             Thursday Friday
                                  Wednesday                            Saturday    Sunday

                 10          20           30           40         50          60            70            80
        1
        2
        3
        4
        5
        6
        7
        8
        9
       10
       11
       12


September October    November December



       90      100
Formula Operators
"+"   Add
"-"   Subtract
"*"   Multiply
"/"   Divide
"^"   Exponent         ie




                                                                        ie




                                                                                                ie
                   ok




                                                                       ok
                                                h




                                                                                             ok
                                            ug
                 Co




                                                                   Co




                                                                                           Co
                                          Do
                ip




                                                                  in




                                                                                          ter
                                                                 ais
              h Ch




                                         ie
                                          k




                                                                                    ug ut
                                                          ug l R
                                       oo
            ug te




                                                                                 Do nut B
                                  rC
         Do cola




                                                        Do ea




                                                                                                              L
                                                            h




                                                                                      h




                                                                                                          TA
                                                          tm
                                  ga
            o




                                                                                   a




                                                                                                         TO
                                                        Oa
         Ch




                                Su




                                                                                 Pe
Price         $12.75                   $10.00                  $12.75                  $11.00

Bob                         1                       2                        0                       0        $32.75
Sandra                      2                       0                        0                       0        $25.50
Aluri                       0                       0                        1                       1        $23.75
Kathie                      1                       0                        1                       0        $25.50
Kawren                      0                       2                        0                       1        $31.00
                       nt
                     ou
                isc
                rd
              de
     L



          or
 TA



         e-
TO



         Pr




                        $3

                     $29.75
                     $22.50
                     $20.75
                     $22.50
                     $28.00
             Jan      Feb      Mar     Apr      May      Jun      Jul     Aug
Income        10000    11000   12000    13000    14000    15000   16000    17000
Expenses       8900     9800   10700    11600    12500    13400   14300    15200
Profit         1100     1200    1300     1400     1500     1600    1700     1800


Net        Q1          3600
           Q2          4500
           Q3          5400
           Q4          6300
           Year       19800
Sep      Oct     Nov      Dec
 18000   19000    20000    21000
 16100   17000    17900    18800
  1900    2000     2100     2200
Create a spreadsheet tracking a club's attendance, money taken in (dues and fundraising) and expenditures for six months.


Members                               Dues
Micheal                               $25 quarterly
Susan
Mark                                  Attendance
Sam                                   Monthly meetings
Beth
Elaine                                Fundraising
Tyler                                 Ticket Sales(by members) to an event; $15 each
Jim
Scott                                 Expenses
Tom                                   Food for monthly meetings; $15
Donna                                 monthly gift baskets for nursing home; $25 each
Michelle                              Donations determined by club members
                                      Incidentals for club activities




                                                      Attendance and Income
               Jan Dues Feb           March April Dues May June July Dues               Aug Sept       Oct Dues
Members
Micheal
Susan
Mark
Sam
Beth
Elaine
Tyler
Jim
Scott
Tom
Donna
Michelle


                         0                               0                         0                          0


               Jan Feb       March April        May June July Aug Sept Oct              Nov Dec
Food
Gift Baskets
Donations
Incidentals
                 0       0        0         0     0      0    0     0    0         0      0        0     0
enditures for six months.




             Nov Dec Ticket Sales




                                0


                               0




                                0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:14
posted:7/30/2011
language:English
pages:10