Budget Dashboard by iv5VrbF

VIEWS: 0 PAGES: 25

									###
      Department:             #####                                                    2004 Budget Dashboard
                             Budget Process                                                   Profit & Loss Summary
      Budget Kick-off date:           30-Aug
      You started:                    2-Sep                                     2000
                                                                                1800
      Submission date:                5-Sep                                     1600
                                                                                1400
      Reviewed by:                    Peter Johnson                             1200
                                                                                                                                                 Act
                                                                                1000
                                                                                 800                                                             Bud

        J      Approved:                                                         600

        K      Approved with Changes:
                                                                                 400
                                                                                 200

        L      Rejected:                           14-Sep              779         0
                                                                                           Revenues       Expenses    Net Profit (Loss)


      Re-submitted date:              16-Sep
        J      Approved:                           19-Sep                    Drill Down                    Act       Bud           Var
        K      Approved with Changes:                                        Revenues                     1813       1430          383
        L      Rejected:                                                     Expenses                     786        779                  7
                                                                             Net Profit (Loss)            1027       651           376

                              HR Summary                                                           Expense Summary
                   Salaries                        Headcount                                               Budget




                                                                                                                                      Salaries
                                                                                                                                      Travel
                                                                                                                                      Cost of Sales




               0        50      100                95      100   105

                                                                                          Drill Down                         Budget
               Drill Down               Actual          Budget                            Salaries                                  65
                Salaries                      54           65                             Travel                                    13
                Headcount                  101            104                             Cost of Sales                           540
                            Date:          ############
                   Budget Analysis
        What-if Analysis


      Items that changed by more than 20%


       Historical budget accuracy


2       Items with budget comments


a       Account Usage Analysis


       Reconciliation report & diagram

        Management Guidelines


                   Benchmarking

                                 Dept.     Avg. All      %
        Measure:                     101    Dept's      Var.
 ▲      Revenues                 1430        1250     14.4%
 ▼      Salaries                     65         70     -7.1%
     ▲ Travel Exp.                   13         12     8.3%
 ▼      Office Supplies              4.1         5    -18.0%
Drill-up

Account Usage Analysis
 Dept. :   #NAME?

 Account Description            #NAME?        #NAME?        Comment
  #NAME?               #NAME?     $50,427     #NAME?        #NAME?
  #NAME?               #NAME?   #NAME?        #NAME?        #NAME?
  #NAME?               #NAME?   #NAME?        #NAME?        #NAME?
  #NAME?               #NAME?     $83,450              $0   Used last year but NOT this Year
  #NAME?               #NAME?     $45,970              $0   Used last year but NOT this Year
  #NAME?               #NAME?       $345      #NAME?        #NAME?
  #NAME?               #NAME?       $367      #NAME?        #NAME?
  #NAME?               #NAME?            $0            $0   Not used last year
  #NAME?               #NAME?   #NAME?        #NAME?        #NAME?
  #NAME?               #NAME?   #NAME?        #NAME?        #NAME?
  #NAME?               #NAME?       $350               $0   Used last year but NOT this Year
Drill-up

Historical Budget Accuracy Report
 Dept. :   #NAME?
                                               #NAME?                              #NAME?                               #NAME?
 Account Description                  #NAME?    #NAME?        Var.    #NAME?        #NAME?        Var.     #NAME?        #NAME?        Var.
  #NAME?                     #NAME?   #NAME?        $3,000   #NAME?       $3,000        $5,000      -40%   #NAME?            $3,000   #NAME?
  #NAME?                     #NAME?   #NAME?    $1,100,000   #NAME?   $1,102,348      $900,000       22%     $890,000      $900,000       -1%
  #NAME?                     #NAME?   #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?
  #NAME?                     #NAME?   #NAME?       $89,000   #NAME?   #NAME?           $84,000   #NAME?       $89,234       $87,000        3%
                                                                                                                                                $1
  #NAME?                     #NAME?   #NAME?    #NAME?       #NAME?       $4,278          $523      718%   #NAME?        #NAME?       #NAME?
  #NAME?                     #NAME?   #NAME?        $6,500   #NAME?   #NAME?            $6,500   #NAME?    #NAME?            $6,500   #NAME?
  #NAME?                     #NAME?   #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?    $1
  #NAME?                     #NAME?   #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?
  #NAME?                     #NAME?   #NAME?      $155,000   #NAME?     $145,289      $130,000       12%     $129,857      $120,000        8%
  #NAME?                     #NAME?   #NAME?       $10,000   #NAME?   #NAME?           $10,000   #NAME?    #NAME?           $10,000   #NAME?    $0
                                                                                                                                                     0
  #NAME?                     #NAME?   #NAME?      $160,000   #NAME?   #NAME?          $160,000   #NAME?    #NAME?          $160,000   #NAME?
  #NAME?                     #NAME?   #NAME?       $10,000   #NAME?   #NAME?           $10,000   #NAME?    #NAME?           $10,000   #NAME?
  #NAME?                     #NAME?   #NAME?       $55,000   #NAME?   #NAME?           $55,000   #NAME?    #NAME?           $55,000   #NAME?
  #NAME?                     #NAME?   #NAME?        $3,000   #NAME?   #NAME?            $3,000   #NAME?    #NAME?            $3,000   #NAME?
  #NAME?                     #NAME?   #NAME?        $4,000   #NAME?   #NAME?            $4,000   #NAME?    #NAME?            $4,000   #NAME?
           Sales                      #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?

  #NAME?                     #NAME?   #NAME?       ($3,000) #NAME?    #NAME?           ($3,000) #NAME?     #NAME?           ($3,000) #NAME?
  #NAME?                     #NAME?   #NAME?       ($4,500) #NAME?    #NAME?           ($4,500) #NAME?     #NAME?           ($4,500) #NAME?
  #NAME?                     #NAME?   #NAME?      ($38,000) #NAME?    #NAME?          ($38,000) #NAME?     #NAME?          ($38,000) #NAME?
           Sales Returns              #NAME?      ($45,500) #NAME?    #NAME?          ($45,500) #NAME?     #NAME?          ($45,500) #NAME?

           Total Sales                #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?

  #NAME?                     #NAME?   #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?
  #NAME?                     #NAME?   #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?
           COGS                       #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?

  #NAME?                   #NAME?     #NAME?          $150 #NAME?     #NAME?              $150 #NAME?      #NAME?              $150 #NAME?
  #NAME?                   #NAME?     #NAME?      ($15,000) #NAME?    #NAME?          ($15,000) #NAME?     #NAME?          ($15,000) #NAME?
  #NAME?                   #NAME?     #NAME?       ($1,000) #NAME?    #NAME?           ($1,000) #NAME?     #NAME?           ($1,000) #NAME?
  #NAME?                   #NAME?     #NAME?       ($7,000) #NAME?    #NAME?           ($7,000) #NAME?     #NAME?           ($7,000) #NAME?
           Purchase Variance          #NAME?      ($22,850) #NAME?    #NAME?          ($22,850) #NAME?     #NAME?          ($22,850) #NAME?     $1


           Total Purchases            #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?    $1

           Gross Margin               #NAME?    #NAME?       #NAME?   #NAME?        #NAME?       #NAME?    #NAME?        #NAME?       #NAME?
                                                                                                                                                $0
                                                                                                                                                     0
  #NAME?                     #NAME?   #NAME?       $50,000   #NAME?   #NAME?           $50,000   #NAME?    #NAME?           $50,000   #NAME?
  #NAME?                     #NAME?   #NAME?       $15,000   #NAME?   #NAME?           $15,000   #NAME?    #NAME?           $15,000   #NAME?
  #NAME?                     #NAME?   #NAME?       $65,000   #NAME?   #NAME?           $65,000   #NAME?    #NAME?           $65,000   #NAME?
  #NAME?                     #NAME?   #NAME?        $2,000   #NAME?   #NAME?            $2,000   #NAME?    #NAME?            $2,000   #NAME?
#NAME?                  #NAME?    #NAME?      $2,000   #NAME?   #NAME?      $2,000   #NAME?   #NAME?      $2,000   #NAME?
         Employee Expenses        #NAME?    $134,000   #NAME?   #NAME?    $134,000   #NAME?   #NAME?    $134,000   #NAME?

#NAME?                   #NAME?   #NAME?    $350,000   #NAME?   #NAME?    $350,000   #NAME?   #NAME?    $350,000   #NAME?
         Contract Expenses        #NAME?    $350,000   #NAME?   #NAME?    $350,000   #NAME?   #NAME?    $350,000   #NAME?

#NAME?                   #NAME?   #NAME?      $6,000   #NAME?   #NAME?      $6,000   #NAME?   #NAME?      $6,000   #NAME?
#NAME?                   #NAME?   #NAME?      $1,100   #NAME?   #NAME?      $1,100   #NAME?   #NAME?      $1,100   #NAME?
#NAME?                   #NAME?   #NAME?      $1,800   #NAME?   #NAME?      $1,800   #NAME?   #NAME?      $1,800   #NAME?
#NAME?                   #NAME?   #NAME?        $500   #NAME?   #NAME?        $500   #NAME?   #NAME?        $500   #NAME?   $1
#NAME?                   #NAME?   #NAME?      $1,600   #NAME?   #NAME?      $1,600   #NAME?   #NAME?      $1,600   #NAME?   $1
#NAME?                   #NAME?   #NAME?     $12,000   #NAME?   #NAME?     $12,000   #NAME?   #NAME?     $12,000   #NAME?
                                                                                                                            $1
#NAME?                   #NAME?   #NAME?      $1,200   #NAME?   #NAME?      $1,200   #NAME?   #NAME?      $1,200   #NAME?
#NAME?                   #NAME?   #NAME?      $5,500   #NAME?   #NAME?      $5,500   #NAME?   #NAME?      $5,500   #NAME?   $0
#NAME?                   #NAME?   #NAME?     $67,000   #NAME?   #NAME?     $67,000   #NAME?   #NAME?     $67,000   #NAME?   $0
#NAME?                   #NAME?   #NAME?      $7,000   #NAME?   #NAME?      $7,000   #NAME?   #NAME?      $7,000   #NAME?
                                                                                                                            $0
#NAME?                   #NAME?   #NAME?      $4,000   #NAME?   #NAME?      $4,000   #NAME?   #NAME?      $4,000   #NAME?        0
#NAME?                   #NAME?   #NAME?      $1,000   #NAME?   #NAME?      $1,000   #NAME?   #NAME?      $1,000   #NAME?
#NAME?                   #NAME?   #NAME?     $17,000   #NAME?   #NAME?     $17,000   #NAME?   #NAME?     $17,000   #NAME?
#NAME?                   #NAME?   #NAME?        $400   #NAME?   #NAME?        $400   #NAME?   #NAME?        $400   #NAME?
#NAME?                   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?
#NAME?                   #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?
#NAME?                   #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?
#NAME?                   #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?
#NAME?                   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?
#NAME?                   #NAME?   #NAME?      $4,000   #NAME?   #NAME?      $4,000   #NAME?   #NAME?      $4,000   #NAME?
#NAME?                   #NAME?   #NAME?     $20,000   #NAME?   #NAME?     $20,000   #NAME?   #NAME?     $20,000   #NAME?
#NAME?                   #NAME?   #NAME?     $86,000   #NAME?   #NAME?     $86,000   #NAME?   #NAME?     $86,000   #NAME?
#NAME?                   #NAME?   #NAME?      $4,000   #NAME?   #NAME?      $4,000   #NAME?   #NAME?      $4,000   #NAME?
#NAME?                   #NAME?   #NAME?        $200   #NAME?   #NAME?        $200   #NAME?   #NAME?        $200   #NAME?
#NAME?                   #NAME?   #NAME?      $1,000   #NAME?   #NAME?      $1,000   #NAME?   #NAME?      $1,000   #NAME?
#NAME?                   #NAME?   #NAME?        $500   #NAME?   #NAME?        $500   #NAME?   #NAME?        $500   #NAME?
#NAME?                   #NAME?   #NAME?         $10   #NAME?   #NAME?         $10   #NAME?   #NAME?         $10   #NAME?
#NAME?                   #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?
#NAME?                   #NAME?   #NAME?      $1,100   #NAME?   #NAME?      $1,100   #NAME?   #NAME?      $1,100   #NAME?
#NAME?                   #NAME?   #NAME?     $20,000   #NAME?   #NAME?     $20,000   #NAME?   #NAME?     $20,000   #NAME?
#NAME?                   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?
#NAME?                   #NAME?   #NAME?      $6,000   #NAME?   #NAME?      $6,000   #NAME?   #NAME?      $6,000   #NAME?
#NAME?                   #NAME?   #NAME?      $8,000   #NAME?   #NAME?      $8,000   #NAME?   #NAME?      $8,000   #NAME?
#NAME?                   #NAME?   #NAME?        $500   #NAME?   #NAME?        $500   #NAME?   #NAME?        $500   #NAME?
#NAME?                   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?
#NAME?                   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?   #NAME?        $300   #NAME?
#NAME?                   #NAME?   #NAME?      $3,400   #NAME?   #NAME?      $3,400   #NAME?   #NAME?      $3,400   #NAME?
         Operating Expenses       #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?

#NAME?                  #NAME?    #NAME?        $23    #NAME?   #NAME?        $23    #NAME?   #NAME?        $23    #NAME?
#NAME?                  #NAME?    #NAME?       $400    #NAME?   #NAME?       $400    #NAME?   #NAME?       $400    #NAME?
#NAME?                  #NAME?    #NAME?       $600    #NAME?   #NAME?       $600    #NAME?   #NAME?       $600    #NAME?
#NAME?                  #NAME?    #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?
#NAME?                  #NAME?    #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?
         Misc Income               #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?

#NAME?                    #NAME?   #NAME?      $3,000   #NAME?   #NAME?      $3,000   #NAME?   #NAME?      $3,000   #NAME?
         Taxes and Interest        #NAME?      $3,000   #NAME?   #NAME?      $3,000   #NAME?   #NAME?      $3,000   #NAME?


         Net Income (Loss)         #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?   #NAME?   #NAME?      #NAME?
    Budget Accuracy - Revenues




0       0        0        0          0   0




    Budget Accuracy - Gross Margin




0       0        0        0          0   0
    Budget Accuracy - Net Profit




0     0         0         0        0   0
Drill-up

Budget Comments
 Dept. :   #NAME?

 Account Description            #NAME?   Department Manager's Comments                       Budget Manager's Comments
  #NAME?               #NAME?   #NAME?   Needed more parts than planned
  #NAME?               #NAME?   #NAME?   Canada sales are coming in fast                     Good, but be careful as you were above last year
  #NAME?               #NAME?   #NAME?   Adjustment down from last round
  #NAME?               #NAME?   #NAME?   Waiting for turn-around
  #NAME?               #NAME?   #NAME?   New plant delaying orders
  #NAME?               #NAME?   #NAME?   We hope to max out here this year
  #NAME?               #NAME?   #NAME?   Stable unless currency depreciates again
  #NAME?               #NAME?   #NAME?   From Jim Carrigan's estimates                       Please double check as he changed them
  #NAME?               #NAME?   #NAME?   High because of new plant
  #NAME?               #NAME?   #NAME?   Needed adjustment from last year
  #NAME?               #NAME?   #NAME?   New vehicles are much more expensive in insurance   OK
Drill-up
 Exception Report

#NAME?

Account        Description            Actual   Budget
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
      #NAME?                 #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?   #NAME?   #NAME?   #NAME?
#NAME?           #NAME?   #NAME?   #NAME?
#NAME?           #NAME?   #NAME?   #NAME?
#NAME?           #NAME?   #NAME?   #NAME?
#NAME?           #NAME?   #NAME?   #NAME?
#NAME?           #NAME?   #NAME?   #NAME?
#NAME?           #NAME?   #NAME?   #NAME?
#NAME?           #NAME?   #NAME?   #NAME?
#NAME?           #NAME?   #NAME?   #NAME?
         Total            #NAME?   #NAME?
 Exceptions       Reset row s

Enter Variance:          20%



  Variance         Variance (%)
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
   #NAME?                  #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
#NAME?   #NAME?
Drill-up                                                                                                             Date: 11/17/2011

                                            Salaries & Headcount
 Dept. :     #NAME?
 Period:     November-11
   Account   Description                    Actual            Budget       Variance
             Salaries
    #NAME?                     #NAME?       #NAME?              $60,000    #NAME?                Salary Expenses per Employee
             Total Salaries                 #NAME?              $60,000       $60,000


   Account   Department Code                Actual            Budget       Variance       $600
             Headcount                                                                    $500
    #NAME?                     #NAME?                25             27              (2)
                                                                                          $400
    #NAME?                     #NAME?                12             14              (2)
    #NAME?                     #NAME?                13             14              (1)   $300
    #NAME?                     #NAME?                19             16              3     $200
    #NAME?                     #NAME?                29             28              1
                                                                                          $100
    #NAME?                     #NAME?                 3                5            (2)
             Total Headcount                     101               104              (3)    $-
                                                                                                 Actual         Budget
             Salary Expenses per Employee   #NAME?        $        577     #NAME?
Drill-up
######




            Management Budget Guidelines

           General Strategy
           With the launch of our new XL-Man product, we will be highly competitive next year,
           and we will have one of the most attractive product suites on the market. Further on,
           our training- and employee motivation programs has lead to the most driven and
           knowledgeable employee team in North America. Based on this we are aiming at
           taking 10% additional market share in the XL Super Boost market.

           Revenues
           We will introduce XL-Man at an attractive price point, so even though we are aiming
           at a 10% market share increase, this will not result in an assumed $25,000,000
           revenue increase. Assume a $15,000,000 revenue increase above last year, and
           introductory price discounts around 15%.

           Marketing
           Please budget for the necessary increase in marketing expenses to properly launch
           XL-Man and to drive the targeted 10% market share increase.

           Salaries
           Assume a 4% salary increase across the board. Bonuses will remain the same as last
           year.
 next year,
Further on,
en and
 ming at



are aiming
0,000
 ar, and



rly launch



 ame as last
Drill-up                                                                                               Date: 11/17/2011


                                           Profit & Loss - Budget
 Dept. :   #NAME?
 Period:   #NAME?
 Account Description                  Actual   Budget        Variance         Profit & Loss KPI Analysis
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
  #NAME?                     #NAME?   #NAME?    $950,000     #NAME?
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?      $1
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?      $1
  #NAME?                     #NAME?   #NAME?    $150,000     #NAME?
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
  #NAME?                     #NAME?   #NAME?    $220,000     #NAME?
                                                                         $1
                                                                                                           Sales
  #NAME?                     #NAME?   #NAME?      $9,000     #NAME?
  #NAME?                     #NAME?   #NAME?     $99,000     #NAME?      $0                                Sales Returns
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?      $0
           Sales                      #NAME?   #NAME?        #NAME?

                                                                         $0
  #NAME?                     #NAME?   #NAME?      ($5,000)   #NAME?
                                                                              Actual Budget
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
  #NAME?                     #NAME?   #NAME?     ($60,000)   #NAME?
           Sales Returns              #NAME?   #NAME?        #NAME?

           Total Sales                #NAME?   #NAME?        #NAME?

  #NAME?                     #NAME?   #NAME?    $530,000     #NAME?
  #NAME?                     #NAME?   #NAME?   #NAME?        #NAME?
                                                                        $1
           COGS                       #NAME?   #NAME?        #NAME?
                                                                        $1
  #NAME?                   #NAME?     #NAME?   #NAME?        #NAME?                                                Purchase
  #NAME?                   #NAME?     #NAME?     ($30,000)   #NAME?
                                                                        $1                                         Variance
  #NAME?                   #NAME?     #NAME?     ($10,000)   #NAME?     $0                                         COGS
  #NAME?                   #NAME?     #NAME?      ($7,000)   #NAME?
           Purchase Variance          #NAME?   #NAME?        #NAME?     $0

                                                                        $0
           Total Purchases            #NAME?   #NAME?        #NAME?
                                                                              Actual       Budget

           Gross Margin               #NAME?   #NAME?        #NAME?
                                                                                          Actual

  #NAME?                  #NAME?      #NAME?     $65,000     #NAME?
           Employee Expenses          #NAME?     $65,000     #NAME?                                                Taxes and Interest

                                                                                                                   Misc Income

                                                                                                                   Operating Expenses
                                                                                                    Operating Expenses
         Contract Expenses                $0          $0          $0                                Contract Expenses

                                                                                                    Employee Expenses


#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?        $13,000   #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?           $100   #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?         $1,400   #NAME?       100%
#NAME?                   #NAME?    #NAME?           $800   #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?       90%
#NAME?                   #NAME?    #NAME?         $1,300   #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?       80%
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
                                                                        70%
#NAME?                   #NAME?    #NAME?        $14,000   #NAME?                                Net Income
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?       60%                      (Loss)
#NAME?                   #NAME?    #NAME?         $6,000   #NAME?
#NAME?                   #NAME?    #NAME?        $16,000   #NAME?       50%                      Total
#NAME?                   #NAME?    #NAME?         $1,300   #NAME?                                Purchases
#NAME?                   #NAME?       $3,500      $4,100       ($600)   40%                      Total Sales
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
         Operating Expenses        #NAME?      #NAME?      #NAME?
                                                                        30%

#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?       20%
#NAME?                   #NAME?    #NAME?           $900   #NAME?
#NAME?                   #NAME?    #NAME?         $4,000   #NAME?       10%
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?
#NAME?                   #NAME?    #NAME?      #NAME?      #NAME?        0%
         Misc Income               #NAME?      #NAME?      #NAME?              Actual   Budget
#NAME?                    #NAME?   #NAME?         $3,000   #NAME?
         Taxes and Interest        #NAME?         $3,000   #NAME?


         Net Income (Loss)         #NAME?      #NAME?      #NAME?
Drill-up

Reconciliation Diagram
 Dept. :   #NAME?



                                  Revenues


                                  #NAME?
                     P&L Report

                         #NAME?


                                  Salaries
                         #NAME?

                                  #NAME?
Drill-up

What-if Analysis                                            Net Profit - Scenarios
 Dept. :   #NAME?
                                          $1
                                          $1
                                          $1
                                          $0
                                          $0
                                      $-
                                                   #NAME?               Fixed Change         Variable Change


                                                                  % change in                                  Activate Goal
                                                                   Net Profit:                                 Seek by chang-
                                                                      20%                                      ing this chart

 Account Description                           #NAME?             Fixed Change            Variable Change            %
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
           Sales                               #NAME?                 #NAME?                  #NAME?

           Sales Returns              $                 -                            $0                  $0

           Total Sales                         #NAME?                 #NAME?                  #NAME?

  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
           COGS                                #NAME?                 #NAME?                  #NAME?

           Purchase Variance          $                 -                            $0                  $0

           Total Purchases                     #NAME?                 #NAME?                  #NAME?

           Gross Margin                        #NAME?                 #NAME?                  #NAME?


           Employee Expenses          $                 -                            $0                  $0

           Contract Expenses          $                 -                            $0                  $0

  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
  #NAME?                     #NAME?            #NAME?                 #NAME?                  #NAME?
#NAME?                   #NAME?       #NAME?       #NAME?        #NAME?
#NAME?                   #NAME?       #NAME?       #NAME?        #NAME?
         Operating Expenses           #NAME?       #NAME?        #NAME?

         Misc Income              $            -            $0            $0

         Taxes and Interest       $            -            $0            $0


         Net Income (Loss)            #NAME?       #NAME?        #NAME?

								
To top