Docstoc

Book 1 _WIP_.xlsx - Wikispaces

Document Sample
Book 1 _WIP_.xlsx - Wikispaces Powered By Docstoc
					                       Jan-12          Feb-12         Mar-12           Apr-12
      Item        Income Expenses Income Expenses Income Expenses Income Expenses
Sandwiches
Meals
Beef
Chicken
Fish
Pork
      Total sales $   -           $   -           $   -           $   -
Stationary
Consumables
Fresh produce
Staff
Stock
Transport

 Total expenses           $   -           $   -           $   -           $   -
  Profit / Loss $             -   $           -   $           -   $           -
                        INCOME / EXPENSES
    May-12           Jun-12          Jul-12          Aug-12          Sep-12
Income Expenses Income Expenses Income Expenses Income Expenses Income




$   -           $   -           $   -           $    -           $   -




        $   -           $   -           $   -            $   -
$           -   $           -   $           -    $           -   $            -
    Sep-12           Oct-12          Nov-12          Dec-12          Annual
       Expenses Income Expenses Income Expenses Income Expenses Income Expenses




               $   -           $    -           $   -           $   -




       $   -           $   -            $   -           $   -           $   -
$          -   $           -    $           -   $           -   $           -
                                                                        DRAFT
                                                                        Expenses
               Office + Stationary       Consumables             Fresh produce                         Stock               Human Resources     Transport/Delivery
Month
               Budget       Actual   Budget      Actual        Budget         Actual          Budget           Actual      Budget    Actual    Budget      Actual
Opening         $2,000.00                         $1,575.00                       $0.00                            $0.00                         $100.00        $0.00

     Jan-12      $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    Feb-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    Mar-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    Apr-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    May-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
     Jun-12      $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
      Jul-12     $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    Aug-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    Sep-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    Oct-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    Nov-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    Dec-12       $170.00                           $1,835.00                       $0.00                          $0.00                           $60.00
    TOTAL      $4,040.00                        $23,595.00                        $0.00                           $0.00                $0.00   $820.00         $0.00




                                                               Karin Langenegger (110 4468)
                                                                DRAFT
                   Required budget for initial office equipment + stationary
            Item              Amount         Officeworks          Big W            Marbig
Desk                             1         $          80.00 $            -     $            -
2 hole punch                     1         $          60.00 $            -     $            -
Bookshelf                        1         $         100.00 $            -     $            -
Cabinet                          2         $         125.00 $            -     $            -
Clock                            1         $          25.00 $            -     $            -
Chairs                           2         $         100.00 $            -     $            -
Guillotine                       1         $          80.00 $            -     $            -
Laminator                        1         $         100.00 $            -     $            -
Office signage                             $         150.00 $            -     $            -
Safety + First aid                         $         210.00 $            -     $            -
Shredder                         1         $         100.00 $            -     $            -
           Equipment Total                 $       1,130.00 $            -     $            -

Initial stationary                        $        270.00   $            -     $            -
Ink cartridges                    4       $        400.00   $            -     $            -
Files                                     $         75.00   $            -     $            -
Paper                          3 box      $         75.00   $            -     $            -
Miscellaneous                             $         50.00   $            -     $            -
                     Total                $        870.00   $            -     $            -
                                          $      2,000.00   $            -     $            -


                               Monthly budget for stationary
            Item              Amount     Officeworks             Big W             Marbig

Paper                             1        $        30.00   $            -     $            -
Miscellaneous                              $        50.00   $            -     $            -
Delivery                                   $        20.00   $            -     $            -
                                           $       100.00   $            -     $            -



                                                      Karin Langenegger (110 4468)
                                                                                            DRAFT
                                                                                           Stationary
     Item           Price / unit   Units      Opening stock Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12                       Jul-12    Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Annual cost
Paper                               1        $       30.00                                                                                                                              $   -
Miscellaneous                                $       40.00                                                                                                                              $   -
                                                                                                                                                                                        $   -
                                                                                                                                                                                        $   -
                                                                                                                                                                                        $   -
            Total                            $       70.00      0         0            0          0           0         0         0         0         0         0           0         0 $   -

Ink cartrages
  Black                                       $      20.00                                                                                                                              $   -
  Yellow                                      $      20.00                                                                                                                              $   -
  Magenta                                     $      20.00                                                                                                                              $   -
  Cyan                                        $      20.00                                                                                                                              $   -
                                        Total $      80.00      0         0            0          0           0         0         0         0         0         0           0         0 $   -
  Delivery cost                               $      20.00                                                                                                                              $   -
                                                                                                                                                                                        $   -
                                        Total $      20.00      0         0            0          0           0         0         0         0         0         0           0         0 $   -
        Total Monthly cost of stationary $         170.00 $ -       $ -       $    -        $ -       $   -       $ -       $ -       $ -       $ -       $ -       $   -       $ -     $   -




                                                                                  Karin Langenegger (110 4468)
                                                                                                      DRAFT
                                                                                                 Consumables
       Item          Service fee Price / unit   Units   Opening amount   Jan-12   Feb-12     Mar-12    Apr-12    May-12    Jun-12    Jul-12    Aug-12    Sep-12    Oct-12    Nov-12    Dec-12 Annual cost
Rental
  Premises                                                        1575     1575      1575       1575      1575      1575      1575      1575      1575      1575      1575      1575      1575 $     18,900.00
  Phone / Internet                                                   0      260       260        260       260       260       260       260       260       260       260       260       260 $      3,120.00
Water                                                                                                                                                                                          $           -
Electricity                                                                                                                                                                                    $           -
Gas                                                                                                                                                                                            $           -
                                                                                                                                                                                               $           -
                                                                                                                                                                                               $           -
                                                                                                                                                                                               $           -
                                                                                                                                                                                               $           -
                                                TOTAL $     1,575.00      1835     1835        1835     1835       1835     1835      1835      1835      1835      1835      1835      1835 $ 22,020.00




                                                                                            Karin Langenegger (110 4468)
                                                                                                     DRAFT
                                                                                                    Fresh produce
         Item             Price / kg   Units   Opening stock   Jan-12       Feb-12       Mar-12          Apr-12       May-12       Jun-12       Jul-12    Aug-12      Sep-12       Oct-12       Nov-12       Dec-12 Annual cost
Bread                                                                                                                                                                                                                                 0
Butter                                                                                                                                                                                                                                0

                  Total                        $         -              0            0               0            0            0            0         0           0            0            0            0           0 $          -
Avocado                                                                                                                                                                                                                               0
Carrots                                                                                                                                                                                                                               0
Garnish                                                                                                                                                                                                                               0
Lettuce                                                                                                                                                                                                                               0
Onions                                                                                                                                                                                                                                0
Tomatoes                                                                                                                                                                                                                              0
                                                                                                                                                                                                                                      0
     Total Vegetables                          $         -              0            0               0            0            0            0         0           0            0            0            0           0 $          -
Pork                                                                                                                                                                                                                                  0
Beef                                                                                                                                                                                                                                  0
Chicken
Fish
           Total Meat                          $         -              0            0               0            0            0            0         0           0            0            0            0           0 $          -
                          Total Fresh Produce $          -     $   -        $   -        $      -        $   -        $   -        $   -        $ -       $   -       $   -        $   -        $   -        $   -     $          -
Transport costs                                                                                                                                                                                                                       0
                                                                                                                                                                                                                                      0
                                         Total $         -              0            0               0            0            0            0         0           0            0            0            0           0 $          -
                                       TOTAL $          -      $ -          $ -          $     -         $ -          $   -        $ -          $ -       $ -         $ -          $ -          $   -        $ -       $      -




                                                                                             Karin Langenegger (110 4468)
                                                                                           Staff expenses
            Item                Basic   Per hour   Super       Initial cost   Jan-12    Feb-12
Human resources
Store Manager
Permanent Staff 1
Permanent Staff 2
Permanent Staff 3
       Permanent Staff Total                               $              -         0         0

Casual staff
Staff 1
Staff 2
Staff 3
Staff 4
           Casual Staff Total                              $              -         0         0

Training
Induction
OHS Training
Ongoing Training
               Training Total                              $              -         0         0
                   TOTAL COST OF EMPLOYMENT (TCE) $                      -    $ -       $ -
Staff expenses
   Mar-12 Apr-12 May-12 Jun-12              Jul-12    Aug-12 Sep-12       Oct-12 Nov-12 Dec-12




          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
    $ -       $ -       $ -       $ -       $ -       $ -       $ -       $ -       $ -       $ -
    Annual cost


$              -
$              -
$              -
$              -
$           -



$              -
$              -
$              -
$              -
$           -



$              -
$              -
$              -
$           -
$          -
                                                                                       DRAFT
                                                                             Non-perishable stock
        Item         Price / kg   Units     Opening stock    Jan-12    Feb-12 Mar-12 Apr-12 May-12 Jun-12                Jul-12    Aug-12 Sep-12      Oct-12 Nov-12 Dec-12 Annual cost
Food
Salt                                                                                                                                                                                      0
Gerkens                                                                                                                                                                                   0
Mayonaise                                                                                                                                                                                 0
Mustard                                                                                                                                                                                   0
Pepper                                                                                                                                                                                    0
Spicing                                                                                                                                                                                   0
Sugar                                                                                                                                                                                     0
Tomato sauce                                                                                                                                                                              0
                                            $        -             0         0         0         0         0         0         0        0         0         0         0         0 $   -

Non-food
Disposable gloves                                                                                                                                                                         0
Dishwashing cloths                                                                                                                                                                        0
Dishwashing soap                                                                                                                                                                          0
Hair nets                                                                                                                                                                                 0
Hand soap                                                                                                                                                                                 0
                                    Total $          -             0         0         0         0         0         0         0        0         0         0         0         0 $   -
Transport costs                                                                                                                                                                           0
                                                                                                                                                                                          0
                                    Total                0         0         0         0         0         0         0         0        0         0         0         0         0 $   -
                     TOTAL cost of stock $           -       $ -       $ -       $ -       $ -       $ -       $ -       $ -       $-       $ -       $ -       $ -       $ -     $   -




                                                                             Karin Langenegger (110 4468)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/15/2012
language:
pages:12
fanzhongqing fanzhongqing http://
About