Question

In: Accounting

Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning...

Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of December:

Cicchetti Corporation
Comparison of Actual Results to Planning Budget
For the Month Ended December 31
Actual Results Planning Budget Variances
Customers served 38,000 34,000
Revenue ($4.6q) $ 175,100 $ 156,400 $ 18,700 F
Expenses:
Wages and salaries ($36,100 + $1.4q) 91,400 83,700 7,700 U
Supplies ($0.7q) 26,000 23,800 2,200 U
Insurance ($13,100) 13,400 13,100 300 U
Miscellaneous expense ($6,100 + $0.4q) 22,550 19,700 2,850 U
Total expense 153,350 140,300 13,050 U
Net operating income $ 21,750 $ 16,100 $ 5,650 F


Required:

Prepare the company's flexible budget performance report for December. Select each variance as favorable (F), unfavorable (U) or "None".

Cicchetti Corporation
Flexible Budget Performance Report Part 1
For the Month Ended December 31
Actual Results Revenue and Spending Variances Flexible Budget
Customers served
Expenses:
Total expenses 0 0 0
Net operating income
Cicchetti Corporation
Flexible Budget Performance Report Part 2
For the Month Ended December 31
Flexible Budget Activity Variances Planning Budget
Customers served
Expenses:
Total expenses 0 0 0
Net operating income

Solutions

Expert Solution

Cicchetti Corporation
Flexible Budget Performance Report Part 1
For the Month Ended December 31
Actual Results Revenue and Spending Variances Flexible Budget
Customers served 38000 38000
Revenue(4.6q) 175100 300 F 174800
Expenses:
Wages and salaries ($36,100 + $1.4q) 91400 2100 U 89300
Supplies ($0.7q) 26000 600 F 26600
Insurance ($13,100) 13400 300 U 13100
Miscellaneous expense ($6,100 + $0.4q) 22550 1250 U 21300
Total expenses 153350 3050 U 150300
Net operating income 21750 2750 U 24500
Cicchetti Corporation
Flexible Budget Performance Report Part 2
For the Month Ended December 31
Flexible Budget Activity Variances Planning Budget
Customers served 38000 34000
174800 18400 F 156400
Expenses:
Wages and salaries ($36,100 + $1.4q) 89300 5600 U 83700
Supplies ($0.7q) 26600 2800 U 23800
Insurance ($13,100) 13100 0 None 13100
Miscellaneous expense ($6,100 + $0.4q) 21300 1600 U 19700
Total expenses 150300 10000 U 140300
Net operating income 24500 8400 F 16100

Related Solutions

Bickel Corporation uses customers served as its measure of activity. The following report compares the planning...
Bickel Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of November: Bickel Corporation Comparison of Actual Results to Planning Budget For the Month Ended November 30 Actual Results Planning Budget Variances Customers served 36,000 35,000 Revenue ($3.40q) $ 122,300 $ 119,000 $ 3,300 F Expenses: Wages and salaries ($23,500 + $1.25q) 68,500 67,250 1,250 U Supplies ($0.65q) 20,450 22,750 2,300 F Insurance ($5,400) 5,400...
Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning...
Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of December: Cicchetti Corporation Comparison of Actual Results to Planning Budget For the Month Ended December 31 Actual Results Planning Budget Variances   Customers served 29,000   28,000     Revenue (3.40q) $ 98,800 $ 95,200 $ 3,600 F   Expenses:      Wages and salaries ($22,800 + $1.18q) 57,020 55,840 1,180 U      Supplies ($0.58q) 14,540 16,240 1,700 F      Insurance ($4,700) 4,700...
Rundell Corporation uses customers served as its measure of activity. The following report compares the planning...
Rundell Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of July. Wages and Supplies are purely variable costs while Insurance is all fixed cost. Miscellaneous expense is a mixed cost with $2,500 being the fixed component of the total amount planned. Rundell Corporation Comparison of Actual Results to Planning Budget For the Month Ended July 31 Actual Results Planning Budget Customers Served 4,260 5,000...
Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning...
Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of December: Cicchetti Corporation Comparison of Actual Results to Planning Budget For the Month Ended December 31 Actual Results Planning Budget Variances   Customers served 38,000   37,000     Revenue (3.50q) $ 133,800 $ 129,500 $ 4,300 F   Expenses:      Wages and salaries ($23,700 + $1.27q) 71,960 70,690 1,270 U      Supplies ($0.67q) 22,290 24,790 2,500 F      Insurance ($5,600) 5,600...
Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning...
Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of December: Cicchetti Corporation Comparison of Actual Results to Planning Budget For the Month Ended December 31 Actual Results Planning Budget Variances Customers served 40,000 35,000 Revenue ($4.8q) $ 192,400 $ 168,000 $ 24,400 F Expenses: Wages and salaries ($36,300 + $1.7q) 106,600 95,800 10,800 U Supplies ($0.9q) 35,300 31,500 3,800 U Insurance ($13,300) 13,700...
Bellamy Corporation uses customers served as its measure of activity. The company bases its budgets on...
Bellamy Corporation uses customers served as its measure of activity. The company bases its budgets on the following information: Revenue should be $3.20 per customer served. Wages and salaries should be $21,000 per month plus $0.80 per customer served. Supplies should be $0.70 per customer served. Insurance should be $5,300 per month. Miscellaneous expenses should be $3,100 per month plus $0.10 per customer served. The company reported the following actual results for October: Customers served 22,000 Revenue $ 73,300 Wages...
Crovo Corporation uses customers served as its measure of activity. During December, the company budgeted for...
Crovo Corporation uses customers served as its measure of activity. During December, the company budgeted for 42,000 customers, but actually served 44,000 customers. The company has provided the following data concerning the formulas used in its budgeting and its actual results for December: Data used in budgeting: Fixed element per month Variable element per customer   Revenue $ 2.60             Wages and salaries $ 20,300         $ 0.89             Supplies $ 0         $ 0.54             Insurance $ 7,300         $ 0.00             Miscellaneous $...
Manic Corporation uses customers served as its measure of activity. During June, the company budgeted for...
Manic Corporation uses customers served as its measure of activity. During June, the company budgeted for 20,000 customers, but actually served 19,000 customers. The company has provided the following data concerning the formulas used in its budgeting and its actual results for June: Data used in budgeting: fixed Element per month Variable Element per customer revenue $4.50 wages and Salaries $23,900 $1.40 Supplies 0 $0.80 Insurance $5,700 $0.00 Miscellaneous $5,000 $0.40 Actual results for June: Revenue $85,400 wages and salaries...
Crovo Corporation uses customers served as its measure of activity. During December, the company budgeted for...
Crovo Corporation uses customers served as its measure of activity. During December, the company budgeted for 39,000 customers, but actually served 41,000 customers. The company has provided the following data concerning the formulas used in its budgeting and its actual results for December: Data used in budgeting: Fixed element per month Variable element per customer   Revenue $ 2.50             Wages and salaries $ 20,000         $ 0.86             Supplies $ 0         $ 0.51             Insurance $ 7,000         $ 0.00             Miscellaneous $...
Abel Corporation uses customers served as its measure of activity. During February, the company budgeted for...
Abel Corporation uses customers served as its measure of activity. During February, the company budgeted for 36,400 customers, but actually served 27,600 customers. The company uses the following revenue and cost formulas in its budgeting, where q is the number of customers served: Revenue: $4.90q Wages and salaries: $34,600 + $1.52q Supplies: $0.92q Insurance: $11,800 Miscellaneous expenses: $7,800 + $0.44q The company reported the following actual results for February: Revenue $ 147,800 Wages and salaries $ 69,400 Supplies $ 15,800...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT