Docstoc

Dashboard

Document Sample
Dashboard Powered By Docstoc
					       Period Starting:                        Jan       Feb        Mar             Apr          May           Jun            Jul       Aug        Sep         Oct         Nov         Dec        Totals

       Sales
            Sales by Product Line 1             1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      (17,179)

            Sales by Product Line 2             2,600     3,350      4,100           4,850         5,600         6,350         7,100      7,850      8,600       9,350     10,100      10,850       80,700
                       Budget                   1,595     1,678      2,754           3,168         3,748         4,327         4,907      5,486      6,066       6,645      7,225       7,804       55,401
                       Over / (Under Budget)    1,005     1,672      1,346           1,682         1,853         2,023         2,194      2,364      2,535       2,705      2,876       3,046       25,299

            Sales by Product Line 3             1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                   1,895     3,678      5,754           7,501         9,431        11,320        13,209     15,099     16,988     18,878      20,767      22,656      147,175
                       Over / (Under Budget)     (295)     (328)      (654)           (651)         (831)         (970)       (1,109)    (1,249)    (1,388)    (1,528)     (1,667)     (1,806)     (12,475)

            Sales by Product Line 4             1,600      3,350      5,100          6,850        12,600        10,350        15,100     15,183     16,433     17,683      18,933      20,183      143,367
                       Budget                   2,895      4,678      7,754          6,501         9,431        11,320        13,209     15,099     16,988     18,878      20,767      22,656      150,175
                       Over / (Under Budget)   (1,295)    (1,328)    (2,654)           349         3,169          (970)        1,891         85       (555)    (1,194)     (1,834)     (2,473)      (6,809)

            Sales by Product Line 5             1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954       17,179

            Sales by Product Line 6            16,000    13,350     15,100          16,850        16,400        16,830        17,260     17,690     15,600     17,350      19,100      20,850      202,380
                       Budget                   1,595     1,678      4,754           6,501         8,081         9,860        11,639     13,419     14,323     15,434      16,543      17,896      121,722
                       Over / (Under Budget)   14,405    11,672     10,346          10,349         8,320         6,970         5,621      4,271      1,277      1,916       2,557       2,954       80,658

       Total Sales                             25,000    30,100     39,600          49,100        60,400        64,580        75,760     82,273     87,433     96,433     105,433     114,433      830,547
       Total Sales Budget                       9,170    15,068     30,524          36,673        46,177        56,517        64,916     71,566     83,011     90,702      98,387     106,805      709,516
       Total Over / (Under Budget)             15,830    15,032      9,076          12,427        14,223         8,063        10,844     10,707      4,423      5,731       7,046       7,629      121,031

       Less Cost of Goods Sold
            Materials                           1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                      Budget                      595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                      Over / (Under Budget)     1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954       17,179

            Labor                               1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954       17,179

            Overhead                            1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954       17,179

            Other                               1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954       17,179

       Total Cost of Goods Sold                 6,400    13,400     20,400          27,400        34,400        41,400        48,400     55,400     62,400     69,400      76,400      83,400      538,800
       Total COG Budget                         2,380     6,712     19,016          26,004        30,976        39,380        43,904     44,928     57,292     61,736      66,172      71,584      470,084
       Total Over / (Under Budget)              4,020     6,688      1,384           1,396         3,424         2,020         4,496     10,472      5,108      7,664      10,228      11,816       68,716


    Operating Expenses
G&A Expenses
            Operating Expenses                  1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                   Budget                         595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                   Over / (Under Budget)        1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      252,221

               Payroll Salaries                 1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      252,221

Total G&A Expenses                              3,200     6,700     10,200          13,700        17,200        20,700        24,200     27,700     31,200     34,700      38,200      41,700      269,400
Total G&A Budget                                1,190     3,356      9,508          13,002        15,488        19,690        21,952     22,464     28,646     30,868      33,086      35,792      235,042
Total Over / (Under Budget)                     2,010     3,344        692             698         1,712         1,010         2,248      5,236      2,554      3,832       5,114       5,908       34,358


Sales Expenses
            Operating Expenses                  1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                   Budget                         595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                   Over / (Under Budget)        1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      252,221

               Payroll Salaries                 1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      252,221

Total Sales Expenses                            3,200     6,700     10,200          13,700        17,200        20,700        24,200     27,700     31,200     34,700      38,200      41,700      269,400
Total Sales Expense Budget                      1,190     3,356      9,508          13,002        15,488        19,690        21,952     22,464     28,646     30,868      33,086      35,792      235,042
Total Over / (Under Budget)                     2,010     3,344        692             698         1,712         1,010         2,248      5,236      2,554      3,832       5,114       5,908       34,358


Marketing Expenses
            Operating Expenses                  1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                   Budget                         595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                   Over / (Under Budget)        1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      252,221

               Payroll Salaries                 1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      252,221

Total Marketing Expenses                        3,200     6,700     10,200          13,700        17,200        20,700        24,200     27,700     31,200     34,700      38,200      41,700      269,400
Total Maeketing Expense Budget                  1,190     3,356      9,508          13,002        15,488        19,690        21,952     22,464     28,646     30,868      33,086      35,792      235,042
Total Over / (Under Budget)                     2,010     3,344        692             698         1,712         1,010         2,248      5,236      2,554      3,832       5,114       5,908       34,358


Research & Development Expenses
            Operating Expenses                  1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                   Budget                         595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                   Over / (Under Budget)        1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      252,221

               Payroll Salaries                 1,600     3,350      5,100           6,850         8,600        10,350        12,100     13,850     15,600     17,350      19,100      20,850      134,700
                       Budget                     595     1,678      4,754           6,501         7,744         9,845        10,976     11,232     14,323     15,434      16,543      17,896      117,521
                       Over / (Under Budget)    1,005     1,672        346             349           856           505         1,124      2,618      1,277      1,916       2,557       2,954      252,221

Total Research & Development Expenses           3,200     6,700     10,200          13,700        17,200        20,700        24,200     27,700     31,200     34,700      38,200      41,700      269,400
Total R&D Expenses Budget                       1,190     3,356      9,508          13,002        15,488        19,690        21,952     22,464     28,646     30,868      33,086      35,792      235,042
Total Over / (Under Budget)                     2,010     3,344        692             698         1,712         1,010         2,248      5,236      2,554      3,832       5,114       5,908       34,358


            Total Operating Expenses           12,800    26,800     40,800          54,800        68,800        82,800       96,800     110,800    124,800    138,800     152,800     166,800     1,077,600
            Total Payroll Salaries              6,400    13,400     20,400          27,400        34,400        41,400       48,400      55,400     62,400     69,400      76,400      83,400       538,800
       Total All Operating Expenses            19,200    40,200     61,200          82,200       103,200       124,200      145,200     166,200    187,200    208,200     229,200     250,200     1,616,400

EBIT                                            5,800    (10,100)   (21,600)       (33,100)      (42,800)      (59,620)      (69,440)   (83,927)   (99,767)   (111,767)   (123,767)   (135,767)    (785,853)

            Interest income (expense)          10,000    10,300     10,609          10,912        11,217        11,521        11,826     12,130     12,435     12,739      13,044      13,348      140,079
            Other income (expense)             20,000    20,600     21,218          21,824        22,433        23,042        23,651     24,260     24,869     25,478      26,087      26,696      280,158
       Total Nonoperating Income (expense)     30,000    30,900     31,827          32,736        33,650        34,563        35,477     36,390     37,304     38,217      39,131      40,044      420,237




                                                                               © Copyright, 2006, Jaxworks, All Rights Reserved.
                    Financial Summary
                                 Financial Summary

300,000
250,000
200,000
150,000
100,000
 50,000
      -
            J   F   M     A              M              J             J     A    S      O   N   D
 (50,000)
(100,000)
(150,000)
(200,000)

                         Total Sales              Total All Operating Expenses   EBIT




                        © Copyright, 2006, Jaxworks, All Rights Reserved.
                                  Financial Summary

300,000
250,000
200,000
150,000
100,000
 50,000
      -
            J   F   M        A             M             J              J            A   S      O   N   D
 (50,000)
(100,000)
(150,000)
(200,000)

                            Total Sales             Total All Operating Expenses         EBIT



                        © Copyright, 2007, Jaxworks, All Rights Reserved.




                                 © Copyright, 2006, Jaxworks, All Rights Reserved.
                           Total Sales vs. Total Budget

140,000

120,000

100,000

 80,000

 60,000

 40,000

 20,000

     -
          J   F   M          A            M              J             J             A       S         O     N   D


                      Total Sales         Total Sales Budget                   Total Over / (Under Budget)




                                 © Copyright, 2006, Jaxworks, All Rights Reserved.
                              Sales Product 1

25,000


20,000


15,000


10,000


 5,000


    -
           J     F     M       A       M        J        J       A        S   O   N     D


         Sales by Product Line 1             Budget             Over / (Under Budget)




                      © Copyright, 2006, Jaxworks, All Rights Reserved.
                              Sales Product 2

12,000

10,000

 8,000

 6,000

 4,000

 2,000

    -
           J     F     M       A       M        J        J       A        S   O   N     D


         Sales by Product Line 2             Budget             Over / (Under Budget)




                      © Copyright, 2006, Jaxworks, All Rights Reserved.
                               Sales Product 3

25,000

20,000

15,000

10,000

 5,000

    -
            J     F     M       A       M        J        J       A        S   O   N     D

(5,000)

          Sales by Product Line 3             Budget             Over / (Under Budget)




                       © Copyright, 2006, Jaxworks, All Rights Reserved.
                               Sales Product 4

25,000

20,000

15,000

10,000

 5,000

    -
            J     F     M       A        M       J        J       A        S   O   N     D

(5,000)

          Sales by Product Line 4             Budget             Over / (Under Budget)




                       © Copyright, 2006, Jaxworks, All Rights Reserved.
                              Sales Product 5

25,000


20,000


15,000


10,000


 5,000


    -
           J     F     M       A       M        J        J       A        S   O   N     D


         Sales by Product Line 5             Budget             Over / (Under Budget)




                      © Copyright, 2006, Jaxworks, All Rights Reserved.
                              Sales Product 6

25,000


20,000


15,000


10,000


 5,000


    -
           J     F     M       A       M        J        J       A        S   O   N     D


         Sales by Product Line 6             Budget             Over / (Under Budget)




                      © Copyright, 2006, Jaxworks, All Rights Reserved.
                          Total COG vs. Total COG Budget

90,000
80,000
70,000
60,000
50,000
40,000
30,000
20,000
10,000
    -
         J   F      M         A            M              J              J             A           S         O           N   D


                 Total Cost of Goods Sold             Total COG Budget                     Total Over / (Under Budget)




                                   © Copyright, 2006, Jaxworks, All Rights Reserved.
                                 Materials

25,000


20,000


15,000


10,000


 5,000


    -
         J   F    M        A       M        J        J       A        S   O   N   D


                 Materials             Budget            Over / (Under Budget)




                  © Copyright, 2006, Jaxworks, All Rights Reserved.
                                   Labor

25,000


20,000


15,000


10,000


 5,000


    -
         J   F   M        A       M        J        J       A        S   O   N   D


                  Labor           Budget             Over / (Under Budget)




                 © Copyright, 2006, Jaxworks, All Rights Reserved.
                                 Overhead

25,000


20,000


15,000


10,000


 5,000


    -
         J   F    M        A       M        J        J       A        S   O   N   D


                 Overhead              Budget            Over / (Under Budget)




                  © Copyright, 2006, Jaxworks, All Rights Reserved.
                       Total G&A vs. Total G&A Budget

45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
 5,000
    -
         J   F    M        A           M              J              J             A         S         O         N   D


                 Total G&A Expenses            Total G&A Budget                    Total Over / (Under Budget)




                               © Copyright, 2006, Jaxworks, All Rights Reserved.
                      Operating Expenses

25,000


20,000


15,000


10,000


 5,000


    -
         J   F    M        A       M        J        J       A        S   O   N     D


         Operating Expenses              Budget             Over / (Under Budget)




                  © Copyright, 2006, Jaxworks, All Rights Reserved.
                           Payroll Expenses

25,000


20,000


15,000


10,000


 5,000


    -
         J   F      M        A       M        J        J       A        S   O     N        D


                 Payroll Salaries             Budget               Over / (Under Budget)




                    © Copyright, 2006, Jaxworks, All Rights Reserved.
                                Total Sales vs. Total Budget

45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
 5,000
    0
         J   J         J         J              J              J              J             J        J         J         J    J


                 Total Sales Expenses               Total Sales Expense Budget                  Total Over / (Under Budget)




                                        © Copyright, 2006, Jaxworks, All Rights Reserved.
                      Operating Expenses

25,000


20,000


15,000


10,000


 5,000


    -
         J   F    M        A       M        J        J       A        S   O   N     D


         Operating Expenses              Budget             Over / (Under Budget)




                  © Copyright, 2006, Jaxworks, All Rights Reserved.
                           Payroll Expenses

25,000


20,000


15,000


10,000


 5,000


    -
         J   F      M        A       M        J        J       A        S   O     N        D


                 Payroll Salaries             Budget               Over / (Under Budget)




                    © Copyright, 2006, Jaxworks, All Rights Reserved.
             Total Marketing Expenses vs. Total Marketing Expense Budget

45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
 5,000
    0
         J       F        M         A             M              J              J              A   S         O         N         D


                Total Marketing Expenses           Total Maeketing Expense Budget                  Total Over / (Under Budget)




                                           © Copyright, 2006, Jaxworks, All Rights Reserved.
                      Operating Expenses

25,000


20,000


15,000


10,000


 5,000


    -
         J   F    M        A       M        J        J       A        S   O   N     D


         Operating Expenses              Budget             Over / (Under Budget)




                  © Copyright, 2006, Jaxworks, All Rights Reserved.
                           Payroll Expenses

25,000


20,000


15,000


10,000


 5,000


    -
         J   F      M        A       M        J        J       A        S   O     N        D


                 Payroll Salaries             Budget               Over / (Under Budget)




                    © Copyright, 2006, Jaxworks, All Rights Reserved.
                            © Copyright, 2007, Jaxworks, All Rights Reserved.



                    Total R&D Expenses vs. Total R&D Expenses Budget

45,000
40,000
35,000
30,000
25,000
20,000
15,000
10,000
 5,000
    -
           J        F        M         A           M              J              J             A   S           O         N           D


         Total Research & Development Expenses             Total R&D Expenses Budget                   Total Over / (Under Budget)




                                           © Copyright, 2006, Jaxworks, All Rights Reserved.
                      Operating Expenses

25,000


20,000


15,000


10,000


 5,000


    -
         J   F    M        A       M        J        J       A        S   O   N     D


         Operating Expenses              Budget             Over / (Under Budget)




                  © Copyright, 2006, Jaxworks, All Rights Reserved.
                           Payroll Expenses

25,000


20,000


15,000


10,000


 5,000


    -
         J   F      M        A       M        J        J       A        S   O     N        D


                 Payroll Salaries             Budget               Over / (Under Budget)




                    © Copyright, 2006, Jaxworks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass
documents, that cover a number of financial, accounting and sales functions. These are invalua

Also included Free are:
   - business plan tools, including spreadsheets and excellent instructions
   - Excel functions glossary and guide;
   - free training courses for most Microsoft Office applications. These guides are in
     PDF format and rival commercial books!
   - comprehensive list of acronyms, ratios and formulas in customer financial
     analysis, and financial terms;
   - suite of online calculators, including, breakeven analysis, productivity analysis,
     business evaluation;
   - Altman Z-Score (covering publicly and privately held firms, and small
     businesses);
   - and payroll analysis.

If you are involved in financial analysis at any level, or want to learn more about MS Excel and o
suite this site is invaluable.




                                              JaxWorks Small Business Spreadsheet Factory
 preadsheets, and associated MS Word, PDF and HTML
ons. These are invaluable small business tools.




ides are in



 analysis,




 about MS Excel and other applications in the Office




sheet Factory
                                                                   Copyright Notice
© 2007, JaxWorks
All rights reserved.
Specifications are subject to change without notice.

NeoCalc™ is a registered trademark of Jaxworks. All other brands or products are trademarks or registered trademarks of their respective holders a
treated as such.


NOTICES REGARDING SOFTWARE, DOCUMENTS AND SERVICES.

IN NO EVENT SHALL JAXWORKS BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSO
RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS AC
OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF SOFTWARE, DOCUMENTS, PROVISION OF OR FAILURE TO PROVID
OR INFORMATION AVAILABLE FROM THIS PROGRAM.




                       © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
        Copyright Notice




 rands or products are trademarks or registered trademarks of their respective holders and should be



SERVICES.

 PECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER
WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING
 RMANCE OF SOFTWARE, DOCUMENTS, PROVISION OF OR FAILURE TO PROVIDE SERVICES,




                                                 © Copyright, 1996-2004, JaxWorks, All Rights Reserved.

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:799
posted:1/5/2008
language:Dutch
pages:30