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

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

Step-by-step 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).