The systems consulting department of

CarlsonFootball

Products designs systems for data collection, encoding, and reporting to fit the needs of other departments within the company. The cost driver for costs in the systems consulting department is the number of requests made to the department. The expected variable cost of handling a request was

$530,

and the number of requests expected for June 20X1 was

40.

Carlson

budgeted its monthly fixed costs for the department (salaries, equipment depreciation, space costs) at

$64,500.

The actual number of requests serviced by systems consulting in June 20X1 was

30,

and the total costs incurred by the department was

$73,100.

Of that amount,

$57,500

was for fixed costs.

Requirement

1.	Compute the static budget variances and the flexible-budget variances for the variable and fixed costs for the systems consulting department for June 20X1.

Begin with the actual results, then complete the flexible budget columns and the static budget columns, and finally, compute the static budget variances. Label each variance as favorable or unfavorable. (Enter all amounts as positive numbers. For variances with a $0 balance, make sure to enter "0" in the appropriate field. If the variance is zero, do not select a label.)

	Actual
	Results
Variable costs
Fixed costs

Flexible-Budget	Flexible
Variances	Budget

Sales-Activity	Static
Variances	Budget

Static-Budget
Variances