Exam 2: Flexible Budgets and Performance Analysis

Bracamonte Hospital bases its budgets on patient-visits. The hospital's static planning budget for November appears below: Required: Prepare a flexible budget for 8,900 patient-visits per month.

Kari Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During May, the kennel budgeted for 3,200 tenant-days, but its actual level of activity was 3,230 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for May: Data used in budgeting: Actual results for May: -The facility expenses in the flexible budget for May would be closest to:

During January, Desousa Clinic plans for an activity level of 3,200 patient-visits. Revenue is $38.50 per patient-visit. Personnel expenses are $36,700 per month plus $10.20 per patient-visit. Medical supplies are $1,800 per month plus $6.00 per patient-visit. Occupancy expenses are $7,600 per month plus $1.50 per patient-visit. Administrative expenses are $4,600 per month plus $0.20 per patient-visit. Required: Prepare the clinic's planning budget for January.

Spirer Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During September, the company budgeted for 6,700 units, but its actual level of activity was 6,750 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for September: Data used in budgeting: Actual results for September: -The activity variance for net operating income in September would be closest to:

Letts Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During January, the company budgeted for 7,000 units, but its actual level of activity was 6,970 units. The company has provided the following data concerning the formulas to be used in its budgeting: -The net operating income in the planning budget for January would be closest to:

Lartey Corporation's cost formula for its selling and administrative expense is $22,200 per month plus $27 per unit. For the month of December, the company planned for activity of 5,300 units, but the actual level of activity was 5,270 units. The actual selling and administrative expense for the month was $168,150. -The selling and administrative expense in the planning budget for December would be closest to:

Gilson Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During April, the company budgeted for 5,100 units, but its actual level of activity was 5,060 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for April: Data used in budgeting: Actual results for April: -The revenue variance for July would be closest to:

Gilson Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During April, the company budgeted for 5,100 units, but its actual level of activity was 5,060 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for April: Data used in budgeting: Actual results for April: -The spending variance for manufacturing overhead in April would be closest to:

Hettinger Hospital bases its budgets on patient-visits. The hospital's static budget for March appears below: -The total variable cost at the activity level of 7,200 patient-visits per month should be:

Letts Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During January, the company budgeted for 7,000 units, but its actual level of activity was 6,970 units. The company has provided the following data concerning the formulas to be used in its budgeting: -The selling and administrative expenses in the planning budget for January would be closest to:

Cosme Tech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: In April, the school budgeted for 1,870 students and 174 courses. The school's income statement showing the actual results for the month appears below: Required: Prepare a flexible budget performance report showing both the school's activity variances and revenue and spending variances for April. Label each variance as favorable (F) or unfavorable (U).

Diemert Corporation bases its budgets on machine-hours. The company's static planning budget for June appears below: Actual results for the month were: -The spending variance for supplies costs in the flexible budget performance report for the month should be:

Juenemann Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During December, the kennel budgeted for 3,800 tenant-days, but its actual level of activity was 3,770 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for December: Data used in budgeting: Actual results for December: -The activity variance for administrative expenses in December would be closest to:

Wexell Framing's cost formula for its supplies cost is $1,230 per month plus $10 per frame. For the month of October, the company planned for activity of 592 frames, but the actual level of activity was 597 frames. The actual supplies cost for the month was $7,050. The activity variance for supplies cost in October would be closest to:

Nicolini Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During October, the kennel budgeted for 2,200 tenant-days, but its actual level of activity was 2,250 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting: Actual results for October: -The administrative expenses in the planning budget for October would be closest to:

Comparing a static planning budget to actual costs is a good way to assess whether variable costs are under control.

A flexible budget can be used to estimate what revenues and costs should have been, given the actual level of activity for the period.

Eberley Corporation's cost formula for its manufacturing overhead is $25,700 per month plus $10 per machine-hour. For the month of July, the company planned for activity of 5,900 machine-hours, but the actual level of activity was 5,920 machine-hours. The actual manufacturing overhead for the month was $86,800. -The spending variance for manufacturing overhead in July would be closest to:

Tabeling Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During August, the company budgeted for 6,500 units, but its actual level of activity was 6,540 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for August: Data used in budgeting: Actual results for August: -The activity variance for net operating income in August would be closest to:

Chirico Clinic uses client-visits as its measure of activity. During February, the clinic budgeted for 2,500 client-visits, but its actual level of activity was 2,550 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for February: Actual results for February: -The personnel expenses in the planning budget for February would be closest to: