Exam 9: Flexible Budgets and Performance Analysis

Neighbors 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 April, the kennel budgeted for 3,000 tenant-days, but its actual level of activity was 2,960 tenant-days. The kennel 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 activity variance for net operating income in April would be closest to:

Keisker Clinic uses client-visits as its measure of activity. During November, the clinic budgeted for 2,200 client-visits, but its actual level of activity was 2,190 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 personnel expenses in the planning budget for November would be closest to:

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 October would 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:

Elvin Hospital bases its budgets on patient-visits. The hospital's static planning budget for May appears below: Required:Prepare a flexible budget for 5,300 patient-visits per month.

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 spending variance for plane operating costs in August would be closest to:

Malander 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 November, the kennel budgeted for 3,400 tenant-days, but its actual level of activity was 3,390 tenant-days. The kennel 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 food and supplies in November 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 direct labor in the planning budget for May would be closest to:

Brong 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 March. When the company prepared its planning budget at the beginning of March, it assumed that 22 containers would have been refurbished. However, 18 containers were actually refurbished during March.The spending variance for "Refurbishing materials" for March would have been 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:

Kirnon Clinic uses client-visits as its measure of activity. During July, the clinic budgeted for 3,800 client-visits, but its actual level of activity was 3,750 client-visits. The clinic has provided the following data concerning the formulas to be used in its budgeting: The activity variance for administrative expenses in July would be closest to:

Harold Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During March, the company budgeted for 7,900 units, but its actual level of activity was 7,860 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for March:Data used in budgeting: Actual results for March: The activity variance for selling and administrative expenses in March would be closest to:

Wember Catering uses two measures of activity, jobs and meals, in the cost formulas in its budgets and performance reports. The cost formula for catering supplies is $400 per month plus $82 per job plus $10 per meal. A typical job involves serving a number of meals to guests at a corporate function or at a host's home. The company expected its activity in September to be 20 jobs and 144 meals, but the actual activity was 16 jobs and 141 meals. The actual cost for catering supplies in September was $3,100. The catering supplies in the planning budget for September 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 activity variance for cleaning equipment and supplies in April would be closest to:

Tos Corporation's flexible budget cost formula for indirect materials, a variable cost, is $0.60 per unit of output. If the company's performance report for last month shows an $800 unfavorable spending variance for indirect materials and if 9,000 units of output were produced last month, then the actual costs incurred for indirect materials for the month must have been:

Teel Printing uses two measures of activity, press runs and book set-ups, in the cost formulas in its budgets and performance reports. The cost formula for wages and salaries is $8,850 per month plus $400 per press run plus $950 per book set-up. The company expected its activity in July to be 204 press runs and 111 book set-ups, but the actual activity was 201 press runs and 110 book set-ups. The actual cost for wages and salaries in July was $193,780.The activity variance for wages and salaries in July would be closest to:

Sathre 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. When the company prepared its planning budget at the beginning of December, it assumed that 34 wells would have been serviced. However, 32 wells were actually serviced during December.The "Employee salaries and wages" in the flexible budget for December would have been closest to:

Gordin 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,000 tenant-days, but its actual level of activity was 3,020 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 activity variance for administrative expenses in May would be closest to:

Chimilio Clinic uses client-visits as its measure of activity. During June, the clinic budgeted for 3,400 client-visits, but its actual level of activity was 3,360 client-visits. The clinic 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 January: The occupancy expenses in the flexible budget for June would be closest to:

Hirons 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 $57,440 per month plus $2,962 per flight plus $15 per passenger. The company expected its activity in November to be 83 flights and 255 passengers, but the actual activity was 86 flights and 257 passengers. The actual cost for plane operating costs in November was $305,490. The spending variance for plane operating costs in November would be closest to: