Departmentalized-Profit-_-Loss-Statement

Document Sample
Departmentalized-Profit-_-Loss-Statement Powered By Docstoc
					                                                                          Profit and Loss Statement July 2003 - Fully Departmental
               As of:                 1-Jul

                                       Total                         %                                                                                                                                                                                                                             Residential                   %                                                                                                                                                                                       Residential                  %                                                                                                                                                                                 Residential                  %
                                      Company                                                                                                                                                                                                                                                        Service                                                                                                                                                                                                             Maintenance                                                                                                                                                                                                    Replacement
Sales                             $    220,000.00                                                                                                                                                                                                            Sales                             $     40,000.00                                                                                                                                                                       Sales                           $      30,000.00                                                                                                                                                               Sales                           $     150,000.00


Parts/Materials                   $     20,200.00                 9.18%                                                                                                                                                                                      Parts/Materials                   $       5,200.00               13.00%                                                                                                                                                 Parts/Materials                 $       4,500.00              15.00%                                                                                                                                           Parts/Materials                 $      10,500.00              7.00%
Direct Labor                      $     30,000.00                 13.64%                                                                                                                                                                                     Direct Labor                      $       8,000.00               20.00%                                                                                                                                                 Direct Labor                    $      10,000.00              33.33%                                                                                                                                           Direct Labor                    $      12,000.00              8.00%
Equipment                         $     45,000.00                 20.45%                                                                                                                                                                                     Equipment                         $               -              0.00%                                                                                                                                                  Equipment                       $            -                0.00%                                                                                                                                            Equipment                       $      45,000.00              30.00%
Subcontractors                    $            -                  0.00%                                                                                                                                                                                      Subcontractors                    $               -              0.00%                                                                                                                                                  Subcontractors                  $            -                0.00%                                                                                                                                            Subcontractors                  $            -                0.00%
Permit                            $      1,500.00                 0.68%                                                                                                                                                                                      Permit                            $               -              0.00%                                                                                                                                                  Permit                          $            -                0.00%                                                                                                                                            Permit                          $       1,500.00              1.00%
Callbacks                         $       700.00                  0.32%                                                                                                                                                                                      Callbacks                         $        400.00                1.00%                                                                                                                                                  Callbacks                       $        300.00               1.00%                                                                                                                                            Callbacks                       $            -                0.00%
Buydown Financing                 $      1,500.00                 0.68%                                                                                                                                                                                      Buydown Financing                 $               -              0.00%                                                                                                                                                  Buydown Financing               $            -                0.00%                                                                                                                                            Buydown Financing               $       1,500.00              1.00%
Other                             $            -                  0.00%                                                                                                                                                                                      Other                             $               -              0.00%                                                                                                                                                  Other                           $            -                0.00%                                                                                                                                            Other                           $            -                0.00%
Warranty Reserve                  $      2,200.00                 1.00%                                                                                                                                                                                      Warranty Reserve                  $        400.00                1.00%                                                                                                                                                  Warranty Reserve                $        300.00               1.00%                                                                                                                                            Warranty Reserve                $       1,500.00              1.00%
Allocated Fringes                 $      9,216.00                 4.19%                                                                                                                                                                                      Allocated Fringes                 $       1,920.00               4.80%                                                                                                                                                  Allocated Fringes               $       2,616.00              8.72%                                                                                                                                            Allocated Fringes               $       4,680.00              3.12%
Sales Salaries                    $            -                  0.00%                                                                                                                                                                                      Sales Salaries                    $               -              0.00%                                                                                                                                                  Sales Salaries                  $            -                0.00%                                                                                                                                            Sales Salaries                  $            -                0.00%
Sales Commissions                 $      8,400.00                 3.82%                                                                                                                                                                                      Sales Commissions                 $               -              0.00%                                                                                                                                                  Sales Commissions               $        900.00               3.00%                                                                                                                                            Sales Commissions               $       7,500.00              5.00%


Total Cost                        $    118,716.00                 53.96%                                                                                                                                                                                     Total Cost                        $     15,920.00                39.80%                                                                                                                                                 Total Cost                      $      18,616.00              62.05%                                                                                                                                           Total Cost                      $      84,180.00              56.12%


Gross Mar.                        $    101,284.00                 46.04%                                                                                                                                                                                     Gross Mar.                        $     24,080.00                60.20%                                                                                                                                                 Gross Mar.                      $      11,384.00              37.95%                                                                                                                                           Gross Mar.                      $      65,820.00              43.88%




Total Oper. Exp.                  $     60,659.40                               Other Income:           $                             -            0.00%                              Budget Net:                 $                8,000.00                  Total Oper. Exp.                  $     20,632.20                             Other Income:         $                 -           0.00%                       Budget Net:       $               8,000.00                Total Oper. Exp.                $      10,470.00                         Other Income: $                     -           0.00%                       Budget Net:       $               8,000.00                Total Oper. Exp.                $      29,557.20                           Other Income:         $                 -            0.00%                       Budget Net:       $               8,000.00
Oper. Exp. %                               27.57%                               Net Profit              $                       40,624.60        18.47%                               Projected Net                                                          Oper. Exp. %                               51.58%                             Net Profit            $           3,447.80          8.62%                       Projected Net                                             Oper. Exp. %                             34.90%                          Net Profit        $            914.00           3.05%                       Projected Net                                             Oper. Exp. %                              19.70%                           Net Profit            $           36,262.80        24.18%                        Projected Net
                                                                                                                                                                                      As % of Budget:                        508%                                                                                                                                                                                          As % of Budget:             43%                                                                                                                                                                                As % of Budget:             11%                                                                                                                                                                                       As % of Budget:             453%



Operating Expenses                                                                                                                                                                                                                                           Operating Expenses                                                                                                                                                                                                      Operating Expenses                                                                                                                                                                                             Operating Expenses
                      Marketing                                      Employee Related                                     Plant and Equipment                                 Vehicle Related                                    Administrative                                    Marketing                                     Employee Related                       Plant and Equipment                    Vehicle Related                             Administrative                                Marketing                                 Employee Related                    Plant and Equipment                    Vehicle Related                             Administrative                                Marketing                                    Employee Related                       Plant and Equipment                     Vehicle Related                             Administrative


Yellow Pages                      $      2,500.00   Mgt. Bonus                  $                 -     Depr. - Leasehold                   $        -     Depreciation Exp.          $               3,000.00   Permit and Licenses          $    200.00    Yellow Pages                      $       2,000.00    Mgt. Bonus              $               -     Depr. - Leasehold      $        -     Depreciation Exp.   $   2,000.00    Permit and Licenses          $   100.00   Yellow Pages                    $            -     Mgt. Bonus             $           -    Depr. - Leasehold      $        -     Depreciation Exp.   $     500.00    Permit and Licenses          $      -     Yellow Pages                    $         500.00   Mgt. Bonus              $               -     Depr. - Leasehold       $        -     Depreciation Exp.   $     500.00    Permit and Licenses          $   100.00
Direct Mail                       $      7,000.00   Admin. Wages                $            6,000.00   Depr. - Equip.                      $   1,200.00   Vehicle Repair             $               1,700.00   Accounting Fees              $        -     Direct Mail                       $               -   Admin. Wages            $         4,000.00    Depr. - Equip.         $    400.00    Vehicle Repair      $   1,500.00    Accounting Fees              $      -     Direct Mail                     $       5,000.00   Admin. Wages           $           -    Depr. - Equip.         $    400.00    Vehicle Repair      $     100.00    Accounting Fees              $      -     Direct Mail                     $       2,000.00   Admin. Wages            $        2,000.00     Depr. - Equip.          $    400.00    Vehicle Repair      $     100.00    Accounting Fees              $      -
Newspaper                         $     10,000.00   Warehouse Purchases         $                 -     Depr. - Furn.                       $        -     Vehicle Fuel               $               1,200.00   Goodwill Amort.              $        -     Newspaper                         $               -   Warehouse Purchases     $               -     Depr. - Furn.          $        -     Vehicle Fuel        $     800.00    Goodwill Amort.              $      -     Newspaper                       $            -     Warehouse Purchases    $           -    Depr. - Furn.          $        -     Vehicle Fuel        $     200.00    Goodwill Amort.              $      -     Newspaper                       $      10,000.00   Warehouse Purchases     $               -     Depr. - Furn.           $        -     Vehicle Fuel        $     200.00    Goodwill Amort.              $      -
Television                        $      4,000.00   Officer Salary              $        10,000.00      Building Maint.                     $        -     Vehicle Licenses           $                    -     Bad Debts                    $        -     Television                        $               -   Officer Salary          $         5,000.00    Building Maint.        $        -     Vehicle Licenses    $        -      Bad Debts                    $      -     Television                      $            -     Officer Salary         $           -    Building Maint.        $        -     Vehicle Licenses    $        -      Bad Debts                    $      -     Television                      $       4,000.00   Officer Salary          $        5,000.00     Building Maint.         $        -     Vehicle Licenses    $        -      Bad Debts                    $      -
Homeshow                          $       525.00    Vacation/Holiday            $                 -     Shop Supplies                       $        -     Auto. Insurance            $                 600.00   Dues and Subscriptions       $    680.00    Homeshow                          $               -   Vacation/Holiday        $               -     Shop Supplies          $        -     Auto. Insurance     $     600.00    Dues and Subscriptions       $   340.00   Homeshow                        $            -     Vacation/Holiday       $           -    Shop Supplies          $        -     Auto. Insurance     $        -      Dues and Subscriptions       $      -     Homeshow                        $         525.00   Vacation/Holiday        $               -     Shop Supplies           $        -     Auto. Insurance     $        -      Dues and Subscriptions       $   340.00
Co-op                             $            -    Tng./Meet. Wage             $                 -     Equip. Maint                        $        -     Auto. Lease                $                    -     Industry Group Fees          $        -     Co-op                             $               -   Tng./Meet. Wage         $               -     Equip. Maint           $        -     Auto. Lease         $        -      Industry Group Fees          $      -     Co-op                           $            -     Tng./Meet. Wage        $           -    Equip. Maint           $        -     Auto. Lease         $        -      Industry Group Fees          $      -     Co-op                           $            -     Tng./Meet. Wage         $               -     Equip. Maint            $        -     Auto. Lease         $        -      Industry Group Fees          $      -
Sub Total Marketing               $     24,025.00   Payroll Taxes- FICA         $            1,050.00   General Liab. Insur.                $   1,800.00                                                         Data Processing              $        -     Sub Total Marketing               $       2,000.00    Payroll Taxes- FICA     $            350.00   General Liab. Insur.   $    600.00                                        Data Processing              $      -     Sub Total Marketing             $       5,000.00   Payroll Taxes- FICA    $       350.00   General Liab. Insur.   $    600.00                                        Data Processing              $      -     Sub Total Marketing             $      17,025.00   Payroll Taxes- FICA     $            350.00   General Liab. Insur.    $    600.00                                        Data Processing              $      -
Marketing %                                10.92% Payroll Taxes- Other          $                 -     Rent                                $   3,300.00                                                         Postage                      $    444.40    Marketing %                                  5.00% Payroll Taxes- Other       $               -     Rent                   $   1,100.00                                       Postage                      $    22.20   Marketing %                              16.67% Payroll Taxes- Other      $           -    Rent                   $   1,100.00                                       Postage                      $   400.00   Marketing %                               11.35% Payroll Taxes- Other      $               -     Rent                    $   1,100.00                                       Postage                      $    22.20
                                                    Worker's Comp               $            1,200.00   Utilities                           $    960.00    Sub. Vehicle               $               6,500.00   Office Supplies              $    600.00                                                          Worker's Comp           $            400.00   Utilities              $    320.00    Sub. Vehicle        $   4,900.00    Office Supplies              $   200.00                                                      Worker's Comp          $       400.00   Utilities              $    320.00    Sub. Vehicle        $     800.00    Office Supplies              $   200.00                                                      Worker's Comp           $            400.00   Utilities               $    320.00    Sub. Vehicle        $     800.00    Office Supplies              $   200.00
                                                    Group Med.                  $            1,950.00   Telephone                           $    600.00    Vehicle %                                     2.95% Radio, Pager Exp.              $        -                                                           Group Med.              $            650.00   Telephone              $    200.00    Vehicle %                 12.25% Radio, Pager Exp.               $      -                                                        Group Med.             $       650.00   Telephone              $    200.00    Vehicle %                  2.67% Radio, Pager Exp.               $      -                                                        Group Med.              $            650.00   Telephone               $    200.00    Vehicle %                  0.53% Radio, Pager Exp.               $      -
                                                    401-K                       $                 -     Janitorial Exp.                     $        -                                                           Cellular Exp.                $        -                                                           401-K                   $               -     Janitorial Exp.        $        -                                         Cellular Exp.                $      -                                                        401-K                  $           -    Janitorial Exp.        $        -                                         Cellular Exp.                $      -                                                        401-K                   $               -     Janitorial Exp.         $        -                                         Cellular Exp.                $      -
                                                    Self Work. Comp             $                 -     Prop. Tax                           $        -                                                           Bank and Credit Card         $        -                                                           Self Work. Comp         $               -     Prop. Tax              $        -                                         Bank and Credit Card         $      -                                                        Self Work. Comp        $           -    Prop. Tax              $        -                                         Bank and Credit Card         $      -                                                        Self Work. Comp         $               -     Prop. Tax               $        -                                         Bank and Credit Card         $      -
                                                    Uniforms                    $                 -                                                                                                              T&E                          $        -                                                           Uniforms                $               -                                                                               T&E                          $      -                                                        Uniforms               $           -                                                                              T&E                          $      -                                                        Uniforms                $               -                                                                                T&E                          $      -
                                                    Employee Relations          $                 -     Sub. P&E                            $   7,860.00                                                         T&E Meals                    $        -                                                           Employee Relations      $               -     Sub. P&E               $   2,620.00                                       T&E Meals                    $      -                                                        Employee Relations     $           -    Sub. P&E               $   2,620.00                                       T&E Meals                    $      -                                                        Employee Relations      $               -     Sub. P&E                $   2,620.00                                       T&E Meals                    $      -
                                                    Drug Testing                $             150.00                    P&E %                      3.57%                                                         Contributions                $        -                                                           Drug Testing            $             50.00           P&E %                 6.55%                                       Contributions                $      -                                                        Drug Testing           $        50.00           P&E %                 8.73%                                       Contributions                $      -                                                        Drug Testing            $             50.00           P&E %                  1.75%                                       Contributions                $      -
                                                    Hiring Exp.                 $                 -                                                                                                              Mileage Reimburse            $        -                                                           Hiring Exp.             $               -                                                                               Mileage Reimburse            $      -                                                        Hiring Exp.            $           -                                                                              Mileage Reimburse            $      -                                                        Hiring Exp.             $               -                                                                                Mileage Reimburse            $      -
                                                    Small Tools                 $                 -                                                                                                              Other                        $        -                                                           Small Tools             $               -                                                                               Other                        $      -                                                        Small Tools            $           -                                                                              Other                        $      -                                                        Small Tools             $               -                                                                                Other                        $      -
                                                    Education Exp.              $                 -                                                                                                              Sub. Admin.                  $   1,924.40                                                         Education Exp.          $               -                                                                               Sub. Admin.                  $   662.20                                                      Education Exp.         $           -                                                                              Sub. Admin.                  $   600.00                                                      Education Exp.          $               -                                                                                Sub. Admin.                  $   662.20
                                                    Support Wages               $                 -                                                                                                                                                                                                                Support Wages           $               -                                                                                                                                                                            Support Wages          $           -                                                                                                                                                                           Support Wages           $               -


                                                    Sub. Emp. Rel.              $        20,350.00                                                                                                               Admin. %                            0.87%                                                         Sub. Emp. Rel.          $        10,450.00                                                                              Admin. %                          1.66%                                                      Sub. Emp. Rel.                1450.00                                                                             Admin. %                          2.00%                                                      Sub. Emp. Rel.                   8450.00                                                                                 Admin. %                          0.44%
                                                    Emp. Relations %                            9.25%                                                                                                                                                                                                              Emp. Relations %                     26.13%                                                                                                                                                                          Emp. Relations %                4.83%                                                                                                                                                                          Emp. Relations %                      5.63%

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:19
posted:4/12/2012
language:English
pages:1