Exam 9: Flexible Budgets and Performance Analysis

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 wages and salaries in the flexible budget for July would be closest to:

Herlocker 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 February, it assumed that 26 containers would have been refurbished. The amount shown for revenue in the planning budget for February would have been closest to:

Paulis 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 February, the kennel budgeted for 2,500 tenant-days, but its actual level of activity was 2,480 tenant-days. The kennel 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 activity variance for net operating income in February 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 cleaning equipment and supplies in the planning budget for April would be closest to:

Witten 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. A total of 27 customers were actually served during January. The revenue in the company's flexible budget for January would have been closest to:

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

Pittman Framing's cost formula for its supplies cost is $1,150 per month plus $11 per frame. For the month of November, the company planned for activity of 789 frames, but the actual level of activity was 792 frames. The actual supplies cost for the month was $9,480. The spending variance for supplies cost in November 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 selling and administrative expenses in the planning budget for March 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 cleaning equipment and supplies in the flexible budget for April would be closest to:

Solimini Memorial Diner is a charity supported by donations that provides free meals to the homeless. The diner's budget for January was based on 3,900 meals, but the diner actually served 3,400 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 January. Label each variance as favorable (F) or unfavorable (U).

Sunn 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 6,100 units, but its actual level of activity was 6,050 units. The company has provided the following data concerning the formulas to be used in its budgeting: The manufacturing overhead in the flexible budget for November would be closest to:

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 net operating income in the planning budget for June would be closest to:

Grohs 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 2,500 tenant-days, but its actual level of activity was 2,530 tenant-days. The kennel has provided the following data concerning the formulas to be used in its budgeting: The net operating income in the planning budget for December would be closest to:

Kirnon Clinic uses client-visits as its measure of activity. During July, the clinic budgeted for 2,000 client-visits, but its actual level of activity was 2,010 client-visits. The clinic has provided the following data concerning the formulas to be used in its budgeting: The activity variance for net operating income in July would be closest to:

Fixed costs should usually be included in performance reports because fixed costs are generally controllable.

An unfavorable activity variance for revenue indicates that activity was less than expected when the static planning budget was developed.

Wisseman 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 September, it assumed that 28 containers would have been refurbished. However, 26 containers were actually refurbished during September. The activity variance for total expenses for September would have been closest to:

Ibsen Clinic uses client-visits as its measure of activity. During December, the clinic budgeted for 3,300 client-visits, but its actual level of activity was 3,340 client-visits. The clinic 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 personnel expenses in the planning budget for December 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 spending variance for medical 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 materials in the flexible budget for May would be closest to: