Exam 2: Flexible Budgets and Performance Analysis

During April, Cheatam Corporation budgeted for 27,000 customers, but actually served 23,000 customers. The company uses the following revenue and cost formulas in its budgeting, where q is the number of customers served: Revenue: $4.10q Wages and salaries: $33,300 + $1.10q Supplies: $0.70q Insurance: $8,600 Miscellaneous expense: $3,700 + $0.40q Required: Prepare the company's flexible budget for April based on the actual level of activity for the month.

Hairston Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During November, the company budgeted for 7,700 units, but its actual level of activity was 7,720 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for November: Data used in budgeting: Actual results for November: -The spending variance for direct materials in November would be closest to:

Coderre Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During July, the company budgeted for 7,800 units, but its actual level of activity was 7,780 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for July: Data used in budgeting: Actual results for July: -The direct materials in the flexible budget for July would be closest to:

Wesolick Clinic uses client-visits as its measure of activity. During August, the clinic budgeted for 2,900 client-visits, but its actual level of activity was 2,870 client-visits. The clinic 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 personnel expenses in August would be closest to:

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

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 equipment depreciation in the flexible budget performance report for the month should be:

Lehnertz Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During February, the company budgeted for 7,100 units, but its actual level of activity was 7,150 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for February: Data used in budgeting: Actual results for February: -The direct materials in the flexible budget for February would be closest to:

Bobe Air uses two measures of activity, flights and passengers, in the cost formulas in its budgets and performance reports. The cost formula for plane operating costs is $44,580 per month plus $2,390 per flight plus $8 per passenger. The company expected its activity in May to be 68 flights and 211 passengers, but the actual activity was 71 flights and 210 passengers. The actual cost for plane operating costs in May was $215,140. -The spending variance for plane operating costs in May 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 spending variance for cleaning equipment and supplies in September would be closest to:

Bobe Air uses two measures of activity, flights and passengers, in the cost formulas in its budgets and performance reports. The cost formula for plane operating costs is $44,580 per month plus $2,390 per flight plus $8 per passenger. The company expected its activity in May to be 68 flights and 211 passengers, but the actual activity was 71 flights and 210 passengers. The actual cost for plane operating costs in May was $215,140. -The plane operating costs in the planning budget for May would be closest to:

Bard Hotel bases its budgets on guest-days. The hotel's static budget for January appears below: -The total variable cost at the activity level of 10,200 guest-days per month should be:

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 activity variance for manufacturing overhead in July would be closest to:

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

Gearhart Corporation bases its budgets on the activity measure customers served. During September, the company planned to serve 25,000 customers, but actually served 29,000 customers. The company has provided the following data concerning the formulas it uses in its budgeting: Required: Prepare the company's flexible budget for September based on the actual level of activity for the month.

Zelenka Clinic uses client-visits as its measure of activity. During June, the clinic budgeted for 2,700 client-visits, but its actual level of activity was 2,710 client-visits. The clinic has provided the following data concerning the formulas to be used in its budgeting for June: -The administrative expenses in the planning budget for June would be closest to:

A flexible budget report should contain variable costs and mixed costs but not fixed costs.

Nicolaysen Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During February, the company budgeted for 5,700 units, but its actual level of activity was 5,690 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for February: Data used in budgeting: Actual results for February: -The selling and administrative expenses in the planning budget for February would be closest to:

Thune Memorial Diner is a charity supported by donations that provides free meals to the homeless. The diner's budget for September was based on 3,100 meals, but the diner actually served 3,500 meals. The diner's director has provided the following cost formulas to use in budgets: Required: Prepare a report showing the activity variances for each of the expenses and for total expenses for September. Label each variance as favorable (F) or unfavorable (U).

Zike Corporation's static planning budget for October appears below. The company bases its budgets on machine-hours. In October, the actual number of machine-hours was 6,000, the actual supplies cost was $14,740, the actual power cost was $49,170, the actual salaries cost was $15,390, and the actual equipment depreciation was $63,670. -The spending variance for power cost in the flexible budget performance report for the month should be:

Towne Snow Removal's cost formula for its vehicle operating cost is $1,470 per month plus $399 per snow-day. For the month of November, the company planned for activity of 13 snow-days, but the actual level of activity was 9 snow-days. The actual vehicle operating cost for the month was $5,230. The vehicle operating cost in the flexible budget for November would be closest to: