Page 161 - Budgeting for Managers
P. 161

Budgeting for Managers
                                      necessary, borrowing money from a line of credit.
                                      loans, and lines of credit that are due or will be due before
                                      the end of the month so that we do not incur penalties,
                                               144 • Paying bills and loans. We pay all bills, credit cards,
                                      aggravate our vendors, or have unresolved items when we
                                      close our books.
                                    When we have completed all the transactions we can and
                                                    TEAMFLY
                                 the accounting department has balanced the books and recon-
                                 ciled all accounts, then the books can be closed and a final ver-
                                 sion of the financial statements can be prepared.

                                 Comparing Estimated Versus Actual Budgets
                                 Once the books are closed for the period, we can create a
                                 spreadsheet that compares our estimated budget with our actual
                                 results. We can see an example for a single month in Table 9-4.
                                                   January
                                  Expenses        Projected   Actual   Difference  Variance

                                    Computer       $1,000      $850      ($150)     -15%
                                                               $100
                                                     $250
                                                                         ($150)
                                    Education
                                                                                    -60%
                                    Insurance        $250      $250         —         0%
                                    Marketing        $500      $500         —         0%
                                                                                    -25%
                                    Medical        $1,500     $1,125     ($375)     100%
                                    Miscellaneous
                                                                          $250
                                                     $250
                                                               $500
                                    Office Rent      $450      $500        $50       11%
                                    Office Supplies  $100       $50      ($50)      -50%
                                    Shipping & Post.  $50       $50         —         0%
                                    Subscriptions    $100     $1,200    $1,100     1100%
                                                     $100
                                                               $125
                                                                           $25
                                    Telephone
                                                                                     25%
                                    Travel           $250      $300        $50       20%
                                  Total            $4,800     $5,550     $750        16%
                                 Table 9-4. Estimated vs. actual for a single month

                                 Overspending and Underspending

                                 On each line item, we may be overspending or underspending
                                 compared with the estimate we made. So, we need to consider






                                                         Team-Fly
                                                                  ®
   156   157   158   159   160   161   162   163   164   165   166