Chapter 4 Flexible Budget PDF

Preview

Summary

Flexible budget [Problems and solution]...

Description

Chapter-Flexible Budget Flexible Budget: A flexible budget is an estimate of what revenues and cost should have been, give the actual level of activity for the period.

Variance Cycle: Raise Questions

Identify Root

Take Actions

Conduct next period’s

Analyze Variances

Prepare Performance Report

Begin

Some Important Definitions  Activity Variance: The difference between a revenue or cost item in the flexible budget and the same item in the static planning budget. An activity variance is due to solely to the difference between the actual level of activity used in the flexible budget and the level of activity assumed in the planning budget.

 Planning Budget: A budget created at the beginning of the budgeting period that is valid only for the planned level of activity.

 Revenue Variance: The difference between the actual revenue for the period and how much the revenue should have been, given the actual level of activity. A favorable (unfavorable) revenue variance occurs because the revenue is higher (lower) than expected, given the actual level of activity for the period.

 Spending Variance: The difference between the actual amount of the cost and how much the cost should have been, given the actual level of activity. A favorable (unfavorable) spending variance occurs because the cost is lower (higher) than expected, given the actual level of activity for the period.

Math AirQual Test Corporation provides on-site air quality testing services. The company has provided the following data concerning it’s operations:

Fixed Component per Month

Variable Component per Job $360

Actual Total for February

Revenue Technician wages Mobile lab operating expenses

$6,400 $2,900

$35

$18,950 $6,450 $4,530

Office expenses

$2,600

$2

$3,050

Advertising expenses Insurance Miscellaneous expenses

$970

$995

$1,680

$1,680

$500

$3

$465

The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $2,900 plus $35 per job, and the actual mobile lab operating expenses for February were $4,530. The company expected to work 50 jobs in February, but actually worked 52 jobs. Required: Prepare a flexible budget performance report showing AirQual Test Corporation’s revenue and spending variances and activity variances for February.

Solution: AirQual Test Corporation Flexible Budget Performance Report For the month ended Feb, 28 Actual Flexible Planning (1) (2) (3) Jobs (q) Revenue per job $360 Exp: Tech. wages 6400 Mobile lab expense (2900+ 35q) Office expense (2600 + 2.00 q) Advertising Insurance Misc. expenses ($500 + 3q) Total expense NOI

Rev. & Spending (1-2)

Activity Variance (2-3)

52 $18,950

52 $18,720

50 $18,000

$230 (F)

$720 (F)

6450 4530

6400 4720

6400 4650

50 (U) 190 (F)

0 70 (U)

3050

2704

2700

346 (U)

4 (U)

995 1680 465

970 1680 656

970 1680 650

25 (U) 0 191 (F)

0 0 6 (U)

17,170 $1780

17,130 $1590

17,050 $950

40 (U) $190 (F)

80 (U) 640 (F)...