Question

The Eastern District of Adelson Inc. is organized as a cost center. The budget for the Eastern District of Adelson Inc. for the month ended December 31 is as follows:
Sales salaries $819,840
System administration salaries 448,152.00
Customer service salaries 152,600.00
Billing salaries 98,760.00
Maintenance 271,104.00
Depreciation of plant and equipment 92,232.00
Insurance and property taxes 41,280.00
Total $1,923,968.00

During December, the costs incurred in the Eastern District were as follows:

Sales salaries $818,880.00
System administration salaries 447,720.00
Customer service salaries 183,120.00
Billing salaries 98,100.00
Maintenance 273,000.00
Depreciation of plant and equipment 92,232.00
Insurance and property taxes 41,400.00
Total $1,954,452.00

Required:
Prepare a budget performance report for the manager of the Eastern District of Adelson for the month of December.

Answer 1

Answer:

                         Eastern District: Adelson Inc.

                         Budget Performance Report

                   For the Year Ended December 31, XX

                                             Actual               Static             Variance

                                             results              budget                          

Sales salaries                       $818,880       $819,840              -$960

System adm. salaries          $447,720       $448,152               -$432

Customer service salaries   $183,120       $152,600          $30,520

Billing salaries                        $98,100        $98,760               -$660

Maintenance                       $273,000         $271,104             $1,896

Depreciation of P & E           $92,232         $92,232                    $0

Insurance and prop. taxes    $41,400          $41,280                $120

Total                                  $1,954,452       $1,923,968       $30,484  

Explanation:

A budget performance report shows how the actual costs and/or revenues perform according to the planned budget. A negative sign on the variance column shows a favorable variance (lower costs or higher revenues), while a positive sign shows an unfavorable variance (higher costs or lower revenues).