Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Excel

VIEWS: 6 PAGES: 13

									                                   Ivy University Payroll


Employee Rate/Hr           Mon        Tue    Wed      Thu     Total Hours
                                                             Fri              Pay
Alban, B.          $5.35       9        0        6       9    6      30.0 $160.50
Angulo, M.         $5.25       0       10        7       8    5      29.5 $154.88
Balto, Y.          $7.00       8        0        8       7    6      29.0 $203.00
Cruz, S.           $5.80       5        5        3       0    0      13.0    $75.40
Del Vecchio, E.    $6.25       8        5        8       1    5      27.0 $168.75
Eklund, E.         $6.00       7        6        5       8    5      31.0 $186.00
Esposito, S.       $6.00       5       10        0       5    0      19.5 $117.00
Hirsch, I.         $6.00       8        5        0       0    5      18.0 $108.00
Juarez, V.         $5.75       8        5        8       0    0      21.0 $120.75
Karas, A.          $5.25       7        0        0       8    0      15.0    $78.75
Keller-Sakis, G.   $6.25       0        0        9       6    5      20.0 $125.00
Lopez, R.          $5.25       1        0        8       0    8      17.0    $89.25
Otis, H.           $5.50       8        5        7      10    7      37.0 $203.50
Parker, L.         $6.50       5        7        0       7    8      27.0 $175.50
Quinn, P.          $5.25       8        8        0       8    3      27.0 $141.75
Ramis, C.          $5.25       7        3        8       0    0      18.0    $94.50
Rappaport, L.      $6.30       0        8        5       0    5      18.0 $113.40
Rosen, R.          $5.80       5        0        0       0    5      10.0    $58.00
Rubec, K.          $7.00       6        8       10       5    0      28.5 $199.50
Sladek, C.         $5.25      10        0        0       0    0       9.5    $49.88
Sworsy, E.         $6.50       0        0        8      10    0      17.5 $113.75
Toro, H.           $6.25       7        5        8       5    5      30.0 $187.50
   Totals                  121.5       89    107.5    96.5   78     492.5 $2,924.55
             Squeaky Clean Cars

               June Expense Budget                                                                 Junes Budgeted and Actu
                     Budgeted   Actual Difference
Soap                   $35.00   $28.65      $6.35                                         $60.00
Wax                    $50.00   $43.45      $6.55                                         $50.00




                                                                          Dollar Amount
Vinyl Cleaner          $25.00   $32.75     -$7.75
                                                                                          $40.00
Window Cleaner         $15.00   $20.50     -$5.50
Sponges and Towels     $10.00   $12.56     -$2.56                                         $30.00
                                                                                          $20.00
              Total:   $135.00     $137.91                                                $10.00
                                                                                           $0.00




                                                                                                     Soap
                                 Junes Actual Expenses




                              9%
                                     21%                 Soap
                       15%                               Wax
                                                         Vinyl Cleaner
                                                         Window Cleaner
                        24%           31%                Sponges and Towels
Junes Budgeted and Actual Expenses




                                               Budgeted
                                               Actual
                                 Sponges and
                 Vinyl Cleaner




                                   Towels




           Type of Expense
                            Pizza Palace
                         Expenses per Pizza

Ingredients           Cheese Extra Cheese Pepperoni Vegatarian The Works
Dough                   $1.25        $1.25    $1.25      $1.25      $1.25
Cheese                  $1.50        $2.50    $1.50      $1.50      $1.50
Sauce                   $0.50        $0.50    $0.50      $0.50      $0.50
Pepperoni               $0.00        $0.00    $0.75      $0.00      $0.75
Sausage                 $0.00        $0.00    $0.00      $0.00      $1.00
Onion                   $0.00        $0.00    $0.00      $0.15      $0.15
Mushroom                $0.00        $0.00    $0.00      $0.35      $0.35
Green Pepper            $0.00        $0.00    $0.00      $0.40      $0.40
      Cost of Pizza:    $3.25        $4.25    $4.00      $4.15      $5.90
       Selling price:   $4.88        $6.50    $8.50      $8.00      $8.30


                                                                 Ingredient Costs of the Works Pizza


                                                                           7%
                                                                     6%
                                                                3%
                                                                                 21%

                                                                     17%
                                                                                  25%
                                                                      13%
                                                                            8%
of the Works Pizza


                     Dough
                     Cheese
                     Sauce
                     Pepperoni
                     Sausage
                     Onion
                     Mushroom
                     Green Pepper
                                   Adams Workout room
                                       Balance Sheet
                                  Month Ended Jan 31,1998

Assets                                  Liabilities
         Cash                   $12,000                         Accounts Payable           $75,987
         Accounts Receivable    $15,000 Stockholders' Equity
         Gym Equipment          $45,000                         Stockholders' Equity       $95,003
         Office Computers       $98,990

               Total Assets:   $170,990        Total Liabilities and Stockholders' Equity: $170,990
               Elaine's Bakery
             Income Statement
          for the years 1995-1997

                         1995     1996      1997
                                                                                                               1995-1997 Income
Revenues:
Cookie Sales          $15,500   $16,896   $17,864
                                                                                          $12,000
Cake Sales            $27,589   $26,298   $25,982




                                                                          Dollar Amount
                                                                                          $10,000
Bread Sales           $24,980   $25,298   $25,398                                          $8,000
      Total Revenues: $68,069   $68,492   $69,244                                          $6,000
Expenses:                                                                                  $4,000
Advertising            $5,000    $4,500 $4,500                                             $2,000
Baking Supplies        $2,000    $1,000 $1,750                                                 $0
                                                                                                    1           2
Ingrediants           $13,275   $15,298 $16,490
Salaries              $30,000   $30,000 $35,000                                                                Year
Utilities              $6,570    $7,250 $8,090

   Total Expenses: $56,845 $58,048 $65,830                                                          Revenues 1995
 Net Income (loss): $11,224 $10,444 $3,414
                                                                    $30,000
                                                                    $25,000
                                                    Dollar Amount



                                                                    $20,000
                                                                    $15,000
                                                                    $10,000
                                                                     $5,000
                                                                        $0
                                                                                                        Year
1997 Income




                          Net Income/(loss)+'Pizza
                          Palace'!




       3




           Cookie Sales
           Cake Sales
           Bread Sales
                         Victorias Meister's Personal Budget

                       Sep-98            Oct-98             Nov-98             Dec-98
                     Budgeted Actual   Budgeted Actual    Budgeted Actual    Budgeted Actual
Income:
Loan                   $4,000 $4,000         $0     $0          $0     $0          $0     $0
Job                      $500   $425       $500   $465        $500   $485        $600   $725
Parents                $5,500 $5,500         $0     $0          $0     $0          $0     $0
           Totals:    $10,000 $9,925       $500   $465        $500   $485        $600   $725
Expenses:
Tuition                $3,000 $2,943         $0     $0          $0     $0          $0     $0
Room/Board             $5,500 $5,575         $0     $0          $0     $0          $0     $0
Books                    $200   $235         $0    $45          $0     $0          $0     $0
Food                     $300   $315       $300   $325        $300   $320         $35   $375
Entertainment            $150   $175       $150   $165        $150   $180        $175   $200
Clothes                   $50     $0        $50    $80         $50     $0        $100   $100

          Totals:      $9,200 $9,243       $500   $615        $500   $500        $310   $675
Budgeted Savings:        $800                $0                 $0               $290
  Actual Savings:               $682              -$150               -$15               $50
                          Brochure Costs

Number of Brochures:       100      250                      500        750    1000

Fixed Costs:
Art Work                   $500     $500                     $500     $500      $500
Salaries                 $1,500   $1,500                   $1,500   $1,500    $1,500
Initial setup fee        $2,500   $2,500                   $2,500   $2,500    $2,500
Variable costs:                                                                                        56%
Paper                      $10      $25                      $50       $75      $100
Printing                   $20      $50                     $100      $113      $150
Labor                     $150     $375                     $750    $1,125    $1,500
Shipping                   $55     $138                     $275      $413      $550

          Total Costs:   $4,735   $5,088                   $5,675   $6,225    $6,800
    Cost per Brochure:    $0.02    $0.05                    $0.09    $0.12     $0.15




                                                                                  Brochure Costs

                                                           1200
                                                           1000
                                           Dollar Amount




                                                            800
                                                            600
                                                            400
                                                            200
                                                              0
                                                                    1         2         3          4
                                                                               Number of Brochures
Number of Brochures
          Fixed Costs



      11%

                             Art Work
                             Salaries
56%       33%
                             Initial setup fee




                   Series1




      5

								
To top