Docstoc

Operating Expense Budget

Document Sample
Operating Expense Budget Powered By Docstoc
					                                  Operating Expense Budget Data



                                  Operating Expense Budget
      Month    Qtr   Year       Category           Expenses           Budget         Actual         Variance
       Jan     Q1    2004   Employee       Salaries and Wages     $     20,000   $     21,000   $        (1,000)
       Feb     Q1    2004   Employee       Salaries and Wages     $     20,000   $     24,000   $        (4,000)
       Mar     Q1    2004   Employee       Salaries and Wages     $     20,000   $     25,000   $        (5,000)
       Apr     Q2    2004   Employee       Salaries and Wages     $     20,000   $     22,000   $        (2,000)
       May     Q2    2004   Employee       Salaries and Wages     $     20,000   $     19,000   $         1,000
       Jun     Q2    2004   Employee       Salaries and Wages     $     20,000   $     20,000   $          —
       Jul     Q3    2004   Employee       Salaries and Wages     $     20,000   $       —
       Aug     Q3    2004   Employee       Salaries and Wages     $     20,000   $       —
       Sep     Q3    2004   Employee       Salaries and Wages     $     20,000   $       —
       Oct     Q4    2004   Employee       Salaries and Wages     $     20,000   $       —
       Nov     Q4    2004   Employee       Salaries and Wages     $     20,000   $       —
       Dec     Q4    2004   Employee       Salaries and Wages     $     25,000   $       —
       Jan     Q1    2004   Employee       Payroll Taxes          $      7,500   $      7,800   $          (300)
       Feb     Q1    2004   Employee       Payroll Taxes          $      7,500   $      8,200   $          (700)
       Mar     Q1    2004   Employee       Payroll Taxes          $      7,500   $      8,500   $        (1,000)
       Apr     Q2    2004   Employee       Payroll Taxes          $      7,500   $      7,900   $          (400)
       May     Q2    2004   Employee       Payroll Taxes          $      7,500   $      7,400   $           100
       Jun     Q2    2004   Employee       Payroll Taxes          $      7,500   $      7,000   $           500
       Jul     Q3    2004   Employee       Payroll Taxes          $      7,500   $       —
       Aug     Q3    2004   Employee       Payroll Taxes          $      7,500   $       —
       Sep     Q3    2004   Employee       Payroll Taxes          $      7,500   $       —
       Oct     Q4    2004   Employee       Payroll Taxes          $      7,500   $       —
       Nov     Q4    2004   Employee       Payroll Taxes          $      7,500   $       —
       Dec     Q4    2004   Employee       Payroll Taxes          $      8,500   $       —
       Jan     Q1    2004   Employee       Employee Benefits      $      5,000   $      5,500   $          (500)
       Feb     Q1    2004   Employee       Employee Benefits      $      5,000   $      6,500   $        (1,500)
       Mar     Q1    2004   Employee       Employee Benefits      $      5,000   $      7,500   $        (2,500)
       Apr     Q2    2004   Employee       Employee Benefits      $      5,000   $      6,500   $        (1,500)
       May     Q2    2004   Employee       Employee Benefits      $      5,000   $      5,000   $          —
       Jun     Q2    2004   Employee       Employee Benefits      $      5,000   $      5,000   $          —
       Jul     Q3    2004   Employee       Employee Benefits      $      5,000   $       —
       Aug     Q3    2004   Employee       Employee Benefits      $      5,000   $       —
       Sep     Q3    2004   Employee       Employee Benefits      $      5,000   $       —
       Oct     Q4    2004   Employee       Employee Benefits      $      5,000   $       —
       Nov     Q4    2004   Employee       Employee Benefits      $      5,000   $       —
       Dec     Q4    2004   Employee       Employee Benefits      $      7,500   $       —
       Jan     Q1    2004   Program        Advertising            $      1,000   $      1,000   $          —
       Feb     Q1    2004   Program        Advertising            $      1,000   $      1,000   $          —
       Mar     Q1    2004   Program        Advertising            $      1,000   $      1,000   $          —
       Apr     Q2    2004   Program        Advertising            $      1,000   $      1,000   $          —
       May     Q2    2004   Program        Advertising            $      1,000   $      1,000   $          —
       Jun     Q2    2004   Program        Advertising            $      1,000   $      1,500   $          (500)
       Jul     Q3    2004   Program        Advertising            $      2,000   $       —
       Aug     Q3    2004   Program        Advertising            $      2,000   $       —
       Sep     Q3    2004   Program        Advertising            $      2,000   $       —
       Oct     Q4    2004   Program        Advertising            $      2,000   $       —
       Nov     Q4    2004   Program        Advertising            $      2,000   $       —
       Dec     Q4    2004   Program        Advertising            $      2,000   $       —
       Jan     Q1    2004   Program        Marketing              $      2,500   $      2,500   $          —
       Feb     Q1    2004   Program        Marketing              $      2,500   $      2,500   $          —
       Mar     Q1    2004   Program        Marketing              $      2,500   $      2,500   $          —
       Apr     Q2    2004   Program        Marketing              $      2,500   $      2,500   $          —
       May     Q2    2004   Program        Marketing              $      2,500   $      2,500   $          —
       Jun     Q2    2004   Program        Marketing              $      2,500   $      3,000   $          (500)
       Jul     Q3    2004   Program        Marketing              $      2,500   $       —
       Aug     Q3    2004   Program        Marketing              $      2,500   $       —
       Sep     Q3    2004   Program        Marketing              $      2,500   $       —
       Oct     Q4    2004   Program        Marketing              $      2,500   $       —
       Nov     Q4    2004   Program        Marketing              $      2,500   $       —
       Dec     Q4    2004   Program        Marketing              $      2,500   $       —
       Jan     Q1    2004   Program        R&D                    $      4,000   $      4,500   $          (500)
       Feb     Q1    2004   Program        R&D                    $      4,000   $      5,000   $        (1,000)
       Mar     Q1    2004   Program        R&D                    $      4,000   $      5,000   $        (1,000)



Confidential                                   1                                                         6/12/2011
                                  Operating Expense Budget Data



                                  Operating Expense Budget
      Month    Qtr   Year       Category            Expenses            Budget         Actual         Variance
       Apr     Q2    2004   Program        R&D                      $      4,000   $      4,000   $          —
       May     Q2    2004   Program        R&D                      $      4,000   $      4,000   $          —
       Jun     Q2    2004   Program        R&D                      $      4,000   $      3,500   $          500
       Jul     Q3    2004   Program        R&D                      $      5,000   $       —
       Aug     Q3    2004   Program        R&D                      $      5,000   $       —
       Sep     Q3    2004   Program        R&D                      $      5,000   $       —
       Oct     Q4    2004   Program        R&D                      $      5,000   $       —
       Nov     Q4    2004   Program        R&D                      $      5,000   $       —
       Dec     Q4    2004   Program        R&D                      $      5,000   $       —
       Jan     Q1    2004   Overhead       Insurance                $        500   $        500   $         —
       Feb     Q1    2004   Overhead       Insurance                $        500   $        500   $         —
       Mar     Q1    2004   Overhead       Insurance                $        500   $        500   $         —
       Apr     Q2    2004   Overhead       Insurance                $        500   $        500   $         —
       May     Q2    2004   Overhead       Insurance                $        500   $        500   $         —
       Jun     Q2    2004   Overhead       Insurance                $        500   $        600   $         (100)
       Jul     Q3    2004   Overhead       Insurance                $        650   $       —
       Aug     Q3    2004   Overhead       Insurance                $        650   $       —
       Sep     Q3    2004   Overhead       Insurance                $        650   $       —
       Oct     Q4    2004   Overhead       Insurance                $        650   $       —
       Nov     Q4    2004   Overhead       Insurance                $        650   $       —
       Dec     Q4    2004   Overhead       Insurance                $        650   $       —
       Jan     Q1    2004   Overhead       Utilities                $        500   $        500   $         —
       Feb     Q1    2004   Overhead       Utilities                $        500   $        500   $         —
       Mar     Q1    2004   Overhead       Utilities                $        500   $        500   $         —
       Apr     Q2    2004   Overhead       Utilities                $        500   $        500   $         —
       May     Q2    2004   Overhead       Utilities                $        500   $        500   $         —
       Jun     Q2    2004   Overhead       Utilities                $        500   $        550   $          (50)
       Jul     Q3    2004   Overhead       Utilities                $        650   $       —
       Aug     Q3    2004   Overhead       Utilities                $        650   $       —
       Sep     Q3    2004   Overhead       Utilities                $        650   $       —
       Oct     Q4    2004   Overhead       Utilities                $        650   $       —
       Nov     Q4    2004   Overhead       Utilities                $        650   $       —
       Dec     Q4    2004   Overhead       Utilities                $        650   $       —
       Jan     Q1    2004   Overhead       Rent / Leases            $      1,200   $      1,200   $         —
       Feb     Q1    2004   Overhead       Rent / Leases            $      1,200   $      1,200   $         —
       Mar     Q1    2004   Overhead       Rent / Leases            $      1,200   $      1,200   $         —
       Apr     Q2    2004   Overhead       Rent / Leases            $      1,200   $      1,200   $         —
       May     Q2    2004   Overhead       Rent / Leases            $      1,200   $      1,200   $         —
       Jun     Q2    2004   Overhead       Rent / Leases            $      1,200   $      1,200   $         —
       Jul     Q3    2004   Overhead       Rent / Leases            $      1,200   $       —
       Aug     Q3    2004   Overhead       Rent / Leases            $      1,200   $       —
       Sep     Q3    2004   Overhead       Rent / Leases            $      1,200   $       —
       Oct     Q4    2004   Overhead       Rent / Leases            $      1,500   $       —
       Nov     Q4    2004   Overhead       Rent / Leases            $      1,500   $       —
       Dec     Q4    2004   Overhead       Rent / Leases            $      1,500   $       —
       Jan     Q1    2004   Overhead       Supplies / Maintenance   $        500   $        500   $         —
       Feb     Q1    2004   Overhead       Supplies / Maintenance   $        500   $        500   $         —
       Mar     Q1    2004   Overhead       Supplies / Maintenance   $        500   $        500   $         —
       Apr     Q2    2004   Overhead       Supplies / Maintenance   $        500   $        500   $         —
       May     Q2    2004   Overhead       Supplies / Maintenance   $        500   $        500   $         —
       Jun     Q2    2004   Overhead       Supplies / Maintenance   $        500   $        400   $         100
       Jul     Q3    2004   Overhead       Supplies / Maintenance   $        500   $       —
       Aug     Q3    2004   Overhead       Supplies / Maintenance   $        500   $       —
       Sep     Q3    2004   Overhead       Supplies / Maintenance   $        500   $       —
       Oct     Q4    2004   Overhead       Supplies / Maintenance   $        500   $       —
       Nov     Q4    2004   Overhead       Supplies / Maintenance   $        500   $       —
       Dec     Q4    2004   Overhead       Supplies / Maintenance   $        500   $       —
       Jan     Q1    2004   Other          Travel                   $        750   $        750   $         —
       Feb     Q1    2004   Other          Travel                   $      1,000   $      1,000   $         —
       Mar     Q1    2004   Other          Travel                   $        500   $        500   $         —
       Apr     Q2    2004   Other          Travel                   $        750   $        750   $         —
       May     Q2    2004   Other          Travel                   $      1,000   $      1,000   $         —
       Jun     Q2    2004   Other          Travel                   $        500   $      1,000   $         (500)



Confidential                                   2                                                           6/12/2011
                                  Operating Expense Budget Data



                                  Operating Expense Budget
      Month    Qtr   Year       Category            Expenses          Budget         Actual         Variance
       Jul     Q3    2004   Other          Travel                 $      1,000   $       —
       Aug     Q3    2004   Other          Travel                 $      1,000   $       —
       Sep     Q3    2004   Other          Travel                 $      1,000   $       —
       Oct     Q4    2004   Other          Travel                 $      1,000   $       —
       Nov     Q4    2004   Other          Travel                 $      1,000   $       —
       Dec     Q4    2004   Other          Travel                 $        500   $       —
       Jan     Q1    2004   Other          Other                  $        600   $        600   $         —
       Feb     Q1    2004   Other          Other                  $        600   $        600   $         —
       Mar     Q1    2004   Other          Other                  $        600   $        600   $         —
       Apr     Q2    2004   Other          Other                  $        600   $        600   $         —
       May     Q2    2004   Other          Other                  $        600   $        600   $         —
       Jun     Q2    2004   Other          Other                  $        600   $        800   $         (200)
       Jul     Q3    2004   Other          Other                  $        600   $       —
       Aug     Q3    2004   Other          Other                  $        600   $       —
       Sep     Q3    2004   Other          Other                  $        600   $       —
       Oct     Q4    2004   Other          Other                  $        600   $       —
       Nov     Q4    2004   Other          Other                  $        600   $       —
       Dec     Q4    2004   Other          Other                  $        600   $       —




Confidential                                   3                                                         6/12/2011
                                           Operating Expense Budget
[Company Name]
Operating Expense Budget
[Date]

Year           (All)
Expenses       (All)
Month          (All)


                          Data
Qtr            Category   Budget Plan          Actuals       Budget to Actual Variance
Q1             Employee   $       97,500   $ 114,000     $                     (16,500)
               Other      $        4,050   $     4,050   $                         -
               Overhead   $        8,100   $     8,100   $                         -
               Program    $       22,500   $ 25,000      $                      (2,500)
Q1 Total                  $      132,150   $ 151,150     $                     (19,000)
Q2             Employee   $       97,500   $ 99,800      $                      (2,300)
               Other      $        4,050   $     4,750   $                       (700)
               Overhead   $        8,100   $     8,150   $                         (50)
               Program    $       22,500   $ 23,000      $                       (500)
Q2 Total                  $      132,150   $ 135,700     $                      (3,550)
Q3             Employee   $       97,500   $       -     $                         -
               Other      $        4,800   $       -     $                         -
               Overhead   $        9,000   $       -     $                         -
               Program    $       28,500   $       -     $                         -
Q3 Total                  $      139,800   $       -     $                         -
Q4             Employee   $      106,000   $       -     $                         -
               Other      $        4,300   $       -     $                         -
               Overhead   $        9,900   $       -     $                         -



Confidential                                                            4                 6/12/2011
                                       Operating Expense Budget
Q4             Program   $    28,500   $    -      $           -
Q4 Total                 $   148,700   $    -      $           -
Grand Total              $   552,800   $ 286,850   $       265,950




Confidential                                           5             6/12/2011
                                                                       Operating Expense Budget
                      $140,000


                      $120,000


                      $100,000


                       $80,000
   Budget / Actuals




                       $60,000


                       $40,000


                       $20,000


                           $0


                      -$20,000


                      -$40,000
                                            Other


                                                         Overhead




                                                                                            Other


                                                                                                         Overhead




                                                                                                                                          Other


                                                                                                                                                       Overhead




                                                                                                                                                                                       Other


                                                                                                                                                                                                    Overhead
                                 Employee




                                                                                 Employee




                                                                                                                               Employee




                                                                                                                                                                            Employee
                                                                    Program




                                                                                                                     Program




                                                                                                                                                                  Program




                                                                                                                                                                                                               Program
                                                    Q1                                              Q2                                            Q3                                           Q4
                                                                                                         Expense Categories

                                                                              Budget Plan           Actuals         Budget to Actual Variance




Confidential                                                                                                    Page 6                                                                                         6/12/2011

				
DOCUMENT INFO