Exam 9: Flexible Budgets and Performance Analysis

Standahl 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 $39,590 per month plus $2,649 per flight plus $4 per passenger. The company expected its activity in August to be 82 flights and 294 passengers, but the actual activity was 85 flights and 297 passengers. The actual cost for plane operating costs in August was $255,690. The plane operating costs in the flexible budget for August would be closest to:

Stegemann Corporation is a shipping container refurbishment company that measures its output by the number of containers refurbished. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results of operations for May. When the company prepared its planning budget at the beginning of May, it assumed that 27 containers would have been refurbished. However, 29 containers were actually refurbished during May. The spending variance for "Employee salaries and wages" for May would have been closest to:

Salina Clinic uses patient-visits as its measure of activity. The clinic has provided the following report: Required: Prepare the clinic's flexible budget performance report for February. Label each variance as favorable (F) or unfavorable (U).

Groupe 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 $48,840 per month plus $2,381 per flight plus $7 per passenger. The company expected its activity in October to be 63 flights and 293 passengers, but the actual activity was 61 flights and 298 passengers. The actual cost for plane operating costs in October was $199,070. The activity variance for plane operating costs in October would be closest to:

Pratte Boat Wash's cost formula for its cleaning equipment and supplies is $2,460 per month plus $49 per boat. For the month of April, the company planned for activity of 58 boats, but the actual level of activity was 18 boats. The actual cleaning equipment and supplies for the month was $3,470. The spending variance for cleaning equipment and supplies in April would be closest to:

Piechocki Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During May, the company budgeted for 5,900 units, but its actual level of activity was 5,940 units. The company 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 activity variance for direct labor in May would be closest to:

Benjamin Corporation is a shipping container refurbishment company that measures its output by the number of containers refurbished. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes. When the company prepared its planning budget at the beginning of March, it assumed that 26 containers would have been refurbished. However, 23 containers were actually refurbished during March. The amount shown for "Refurbishing materials" in the planning budget for March would have been closest to:

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

Thorman Corporation is a service company that measures its output by the number of customers served. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results of operations for August. When the company prepared its planning budget at the beginning of August, it assumed that 35 customers would have been served. However, 39 customers were actually served during August. Required: Prepare a report showing the company's revenue and spending variances for August. Indicate in each case whether the variance is favorable (F) or unfavorable (U).

Mandalay Hotel bases its budgets on guest-days. The hotel's static budget for August appears below: The total fixed cost at the activity level of 5,500 guest-days per month should be:

Schriever Corporation is an oil well service company that measures its output by the number of wells serviced. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes. The planning budget for May was based on 36 wells serviced, but a total of 31 wells were actually serviced in May. The activity variance for "Servicing materials" for May would have been closest to:

Buckson Framing's cost formula for its supplies cost is $1,350 per month plus $18 per frame. For the month of June, the company planned for activity of 716 frames, but the actual level of activity was 713 frames. The actual supplies cost for the month was $14,820. The supplies cost in the flexible budget for June would be closest to:

Medlar Corporation's static planning budget for June appears below. The company bases its budgets on machine-hours. In June, the actual number of machine-hours was 9,300, the actual supplies cost was $19,760, the actual power cost was $35,720, the actual salaries cost was $27,130, and the actual equipment depreciation was $39,430. The spending variance for supplies cost in the flexible budget performance report for the month should be:

Schoening Corporation is a shipping container refurbishment company that measures its output by the number of containers refurbished. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results of operations for January. When the company prepared its planning budget at the beginning of January, it assumed that 40 containers would have been refurbished. However, 38 containers were actually refurbished during January. The total expenses in the flexible budget for January would have been closest to:

During September, Ferman Clinic budgeted for 3,800 patient-visits, but its actual level of activity was 4,100 patient-visits. The clinic uses the following revenue and cost formulas in its budgeting, where q is the number of patient-visits: Revenue: $21.60q Personnel expenses: $22,600 + $6.60q Medical supplies: $1,000 + $2.60q Occupancy expenses: $6,000 + $0.90q Administrative expenses: $4,300 + $0.30q Required: Prepare the clinic's flexible budget for September based on the actual level of activity for the month.

Stegemann Corporation is a shipping container refurbishment company that measures its output by the number of containers refurbished. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results of operations for May. When the company prepared its planning budget at the beginning of May, it assumed that 27 containers would have been refurbished. However, 29 containers were actually refurbished during May. The activity variance for total expenses for May would have been closest to:

A favorable spending variance occurs when the actual cost is less than the amount of the cost in the static planning budget.

Quesnel Clinic bases its budgets on the activity measure patient-visits. During February, the clinic planned for 2,800 patient-visits, but its actual level of activity was 3,000 patient-visits. The clinic has provided the following data concerning the formulas it uses in its budgeting: Required: Prepare a report showing the clinic's activity variances for February. Indicate in each case whether the variance is favorable (F) or unfavorable (U).

Trevorrow Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During June, the company budgeted for 6,200 units, but its actual level of activity was 6,160 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for June: Data used in budgeting: Actual results for June: The overall revenue and spending variance (i.e., the variance for net operating income in the revenue and spending variance column on the flexible budget performance report) for June would be closest to:

Tennies Clinic uses client-visits as its measure of activity. During November, the clinic budgeted for 3,300 client-visits, but its actual level of activity was 3,290 client-visits. The clinic 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 activity variance for personnel expenses in November would be closest to: