Docstoc

Budget Auto Sales - Excel

Document Sample
Budget Auto Sales - Excel Powered By Docstoc
					World Travel Inc.
Budget 1998
Category Name              Jan           Feb           Mar           Apr           May        June       July

INFLOWS
 Bonus                        20000         20000         20000         20000         20000      20000      20000
 Commission                   35000         35000         35000         35000         35000      35000      35000
 Consulting                   10000         10000         10000         10000         10000      10000      10000
 Gross Sales                 600000        600000        600000        600000        600000     600000     600000
 Interest Inc                   500           500           500           500           500        500        500
 Other Inc                    10000         10000         10000         10000         10000      10000      10000
 Prof. Services                5000          5000          5000          5000          5000       5000       5000
OUTFLOWS
 Ads                             30000         30000         30000         30000     30000       30000      30000
 Auto                              500           500           500           500       500         500        500
 Bad Debt                         1000          1000          1000          1000      1000        1000       1000
 Bank Charge                        30            30            30            30        30          30         30
 Cash                              300           300           300           300       300         300        300
 Charity                           500           500           500           500       500         500        500
 Commission                      60000         60000         60000         60000     60000       60000      60000
 Dues                               40            40            40            40        40          40         40
 Insurance                        3000          3000          3000          3000      3000        3000       3000
 Interest Exp                     1700          1700          1700          1700      1700        1700       1700
 Legal-Prof Fees                    50            50            50            50        50          50         50
 Licenses and Permits              200           200           200           200       200         200        200
 Meals & Entertn                  5000          5000          5000          5000      5000        5000       5000
 Misc                             1000          1000          1000          1000      1000        1000       1000
 Office                           3000          3000          3000          3000      3000        3000       3000
 Postage / Delivery               2000          2000          2000          2000      2000        2000       2000

 Printing / Reproduction       5000          5000          5000          5000          5000       5000       5000
 Rent - Office                 2000          2000          2000          2000          2000       2000       2000
 Rent on Equip                   50            50            50            50            50         50         50
 Repairs                       2000          2000          2000          2000          2000       2000       2000
 Returns                      30000         30000         30000         30000         30000      30000      30000
 Subscriptions                   50            50            50            50            50         50         50
 Supplies                       300           300           300           300           300        300        300
 Tax                          10000         10000         10000         10000         10000      10000      10000
 Travel                         500           500           500           500           500        500        500
 Trip Costs                  500000        500000        500000        500000        500000     500000     500000
 Utilities                      450           450           450           450           450        450        450
 Wages                         2000          2000          2000          2000          2000       2000       2000

Total Inflows                680500        680500        680500        680500        680500     680500     680500
Total Outflows               660670        660670        660670        660670        660670     660670     660670
Difference                    19830         19830         19830         19830         19830      19830      19830
Aug           Sept       Oct           Nov           Dec           Totals


   20000         20000      20000         20000         20000        240000
   35000         35000      35000         35000         35000        420000
   10000         10000      10000         10000         10000        120000
  600000        600000     600000        600000        600000       7200000
     500           500        500           500           500          6000
   10000         10000      10000         10000         10000        120000
    5000          5000       5000          5000          5000         60000

      30000      30000         30000         30000         30000     360000
        500        500           500           500           500       6000
       1000       1000          1000          1000          1000      12000
         30         30            30            30            30        360
        300        300           300           300           300       3600
          0        500           500           500           500       5500
      60000      60000         60000         60000         60000     720000
         40         40            40            40            40        480
       3000       3000          3000          3000          3000      36000
       1700       1700          1700          1700          1700      20400
         50         50            50            50            50        600
        200        200           200           200           200       2400
       5000       5000          5000          5000          5000      60000
       1000       1000          1000          1000          1000      12000
       3000       3000          3000          3000          3000      36000
       2000       2000          2000          2000          2000      24000

    5000          5000       5000          5000          5000         60000
    2000          2000       2000          2000          2000         24000
      50            50         50            50            50           600
    2000          2000       2000          2000          2000         24000
   30000         30000      30000         30000         30000        360000
      50            50         50            50            50           600
     300           300        300           300           300          3600
   10000         10000      10000         10000         10000        120000
     500           500        500           500           500          6000
  500000        500000     500000        500000        500000       6000000
     450           450        450           450           450          5400
    2000          2000       2000          2000          2000         24000

  680500        680500     680500        680500        680500       8166000
  660170        660670     660670        660670        660670       7927540
   20330         19830      19830         19830         19830        238460
                                                  World Travel Inc. 1998


          1600000


          1400000


          1200000


          1000000


           800000

                                                                                                    Total Inflows
Dollars




           600000                                                                                   Total Outflows
                                                                                                    Difference

           400000


           200000


                0
                    Jan   Feb   Mar   Apr   May      June    July    Aug   Sept   Oct   Nov   Dec

          -200000


          -400000
                                                        Months
World Travel Inc.
Report for 1998
Category Name              Jan           Feb        Mar         Apr         May        June        July

INFLOWS
 Bonus                        22000         20000      18000       19000       26000      40000       23000
 Commission                   38500         35000      31500       33250       45500      70000       40250
 Consulting                   11000         10000       9000        9500       13000      20000       11500
 Gross Sales                 660000        600000     540000      570000      780000    1200000      690000
 Interest Inc                   550           500        450         475         650       1000         575
 Other Inc                    11000         10000       9000        9500       13000      20000       11500
 Prof. Services                5500          5000       4500        4750        6500      10000        5750
OUTFLOWS
 Ads                           38520        36000      30300       22500       45000      26700       36000
 Auto                              642        600         505         375        750         445        600
 Bad Debt                        1284        1200       1010          750       1500         890       1200
 Bank Charge                    38.52          36        30.3        22.5         45        26.7         36
 Cash                           385.2         360         303         225        450         267        360
 Charity                           642        600         505         375        750         445        600
 Commission                    77040        72000      60600       45000       90000      53400       72000
 Dues                           51.36          48        40.4          30         60        35.6         48
 Insurance                       3852        3600       3030        2250        4500       2670        3600
 Interest Exp                 2182.8         2040       1717        1275        2550       1513        2040
 Legal-Prof Fees                  64.2         60        50.5        37.5         75        44.5         60
 Licenses and Permits           256.8         240         202         150        300         178        240
 Meals & Entertn                 6420        6000       5050        3750        7500       4450        6000
 Misc                            1284        1200       1010          750       1500         890       1200
 Office                          3852        3600       3030        2250        4500       2670        3600
 Postage / Delivery              2568        2400       2020        1500        3000       1780        2400
 Printing / Reproduction         6420        6000       5050        3750        7500       4450        6000
 Rent - Office                   2568        2400       2020        1500        3000       1780        2400
 Rent on Equip                    64.2         60        50.5        37.5         75        44.5         60
 Repairs                         2568        2400       2020        1500        3000       1780        2400
 Returns                       38520        36000      30300       22500       45000      26700       36000
 Subscriptions                    64.2         60        50.5        37.5         75        44.5         60
 Supplies                       385.2         360         303         225        450         267        360
 Tax                             5000        4500       5500       47000        3000     198300        3000
 Travel                            642        600         505         375        750         445        600
 Trip Costs                  642000        600000     505000      375000      750000     445000      600000
 Utilities                      577.8         540         375         480        380         470        520
 Wages                           2140        2000       2000        2000        2000       2000        2000

Total Inflows                748550        680500   612450        646475      884650 1361000         782575
Total Outflows             840032.3        784904 662577.2        535645      977710 777685.8        783384
Difference                  -91482.3      -104404    -50127.2     110830      -93060 583314.2             -809
Aug        Sept       Oct           Nov         Dec        Totals


   15000      22000      21000         17400       26000     269400
   26250      38500      36750         30450       45500     471450
    7500      11000      10500          8700       13000     134700
  450000     660000     630000        522000      780000    8082000
     375        550        525           435         650       6735
    7500      11000      10500          8700       13000     134700
    3750       5500       5250          4350        6500      67350

   24000      42000      33000         24900       45000      403920
     400        700        550            415        750          6732
     800       1400       1100            830       1500        13464
      24         42         33           24.9         45       403.92
     240        420        330            249        450       4039.2
     400        700        550            415        750          6732
   48000      84000      66000         49800       90000      807840
      32         56         44           33.2         60       538.56
    2400       4200       3300          2490        4500        40392
    1360       2380       1870          1411        2550     22888.8
      40         70         55           41.5         75         673.2
     160        280        220            166        300       2692.8
    4000       7000       5500          4150        7500        67320
     800       1400       1100            830       1500        13464
    2400       4200       3300          2490        4500        40392
    1600       2800       2200          1660        3000        26928
    4000       7000       5500          4150        7500        67320
    1600       2800       2200          1660        3000        26928
      40         70         55           41.5         75         673.2
    1600       2800       2200          1660        3000        26928
   24000      42000      33000         24900       45000      403920
      40         70         55           41.5         75         673.2
     240        420        330            249        450       4039.2
    3000       4500       3000         15300        3000      295100
     400        700        550            415        750          6732
  400000     700000     550000        415000      750000    6732000
     330        365        478            501        420       5436.8
    2000       2000       2000          2000        2000        24140

  510375     748550     714525   592035           884650    9166335
  523906     914373     718520 555823.6           977750    9052311
  -13531    -165823         -3995    36211.4      -93100    114024

				
DOCUMENT INFO
Description: Budget Auto Sales document sample