Felicetti Corporation bases its budgets on the activity measure customers served. During November, the company planned to serve 21,000 customers. The company has provided the following data concerning the formulas it uses in its budgeting: Fixed element per month Variable element per customer $0 $6.90 $2.70 $ 37,700 $0 $ 1.10 $ 9,900 $0.00 Miscellaneous expense $6,600 $0.20 The company has also furnished its income statement for November Felicetti Corporation Income Statement For the Month Ended November 30 Actual customers served 26,000 Revenue $ 177,900 Expenses: Wages and salaries Supplies Insurance Revenue Wages and salaries Supplies Insurance 108,900 26,900 11,900 Miscellaneous expense 14,200 161,900 $ 16,000 Total expense Net operating income Required: Prepare a report showing the company's activity variances for November. Indicate in each case whether the variance is favorable (F) or unfavorable (U).

Felicetti Corporation bases its budgets on the activity measure customers served. During November, the company planned to serve 21,000 customers. The company has provided the following data concerning the formulas it uses in its budgeting: Fixed element per month Variable element per customer $0 $6.90 $2.70 $ 37,700 $0 $ 1.10 $ 9,900 $0.00 Miscellaneous expense $6,600 $0.20 The company has also furnished its income statement for November Felicetti Corporation Income Statement For the Month Ended November 30 Actual customers served 26,000 Revenue $ 177,900 Expenses: Wages and salaries Supplies Insurance Revenue Wages and salaries Supplies Insurance 108,900 26,900 11,900 Miscellaneous expense 14,200 161,900 $ 16,000 Total expense Net operating income Required: Prepare a report showing the company's activity variances for November. Indicate in each case whether the variance is favorable (F) or unfavorable (U).

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Guareno Clinic uses client-visits as its measure of activity. During December, the clinic budgeted for 4,100 client-visits, but its actual level of activity was 4,030 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: Fixed element per month Variable element per client-visit Revenue - $ 44.70 Personnel expenses $ 35,900 $ 13.30 Medical supplies 1,600 5.30 Occupancy expenses 11,600 2.20 Administrative expenses 5,400 0.20 Total expenses $ 54,500 $ 21.00 Actual results for December: Revenue $ 178,885 Personnel expenses $ 88,515 Medical supplies $ 22,515 Occupancy expenses $ 19,960 Administrative expenses $ 6,290 The activity variance for administrative expenses in December would be closest to:
None
A manager is preparing a revenue budget for next month. The following is the manager’s current month actual operating results. ACTUAL OPERATING RESULTS CURRENT MONTH Revenue Source Number of Guests Average Sale per Guest Sales Restaurant 3492 $20.50 $71,586 Lounge 515 $12.00 $ 6,180 Banquet room 388 $28.50 $11,058 Total 4395 $20.21 $88,824 Create the revenue forecast for next month based on the following assumptions. Restaurant guest counts will be 3,600 with an average sale per guest of $21.00. Lounge guests to be served are estimated at 525 with a 10 percent increase in average sale per guest. The banquet room will serve 425 customers and generate $12,750 in sales. NEXT MONTH BUDGET Revenue Source Number of Guests Average Sale per Guest Sales Restaurant 3,600.00 ? ? Lounge ? ? ? Banquet room ? ? ? Total ? ? ? What will be the manager’s revenue forecast for next month?…
Dinham 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 March, the kennel budgeted for 3,400 tenant-days, but its actual level of activity was 3,460 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for March: Data used in budgeting: Revenue Wages and salaries Food and supplies Facility expenses Administrative expenses Total expenses Actual results for March: Fixed Variable element per element per month tenant-day $0 $ 34.30 $ 2,300 $ 7.30 1,300 13.80 7,800 6,300 $ 17,700 2.80 0.40 $ 24.30 Revenue $ 115,625 Wages and salaries $ 28,530 Food and supplies $ 49,580 Facility expenses $ 16,500 Administrative expenses $ 7,093 The spending variance for facility expenses in March would be closest to:
Annie's Homemade is preparing a planning budget for August. Its budgeted revenue per serving is $5.00. It has identified two cost drivers-number of servings and number of labor-hours. The company expects to sell 10,800 servings and to staff 700 employee labor-hours in August. Data concerning the company's cost formulas are shown below: Ingredients expense Salaries and wages expense Franchise fee Credit card processing fees Utilities expense $ 300 Rent expense $ 3,000 Equipment depreciation expense $1,750 Other expenses $4,200 Required: Prepare a planning budget for August. Budgeted servings Budgeted labor-hours Revenue Expenses: Fixed Cost Cost per Per Month $ 7,000 Ingredients expense Salaries and wages expense Franchise fee Credit card processing fees Utilities expense Rent expense Equipment depreciation expense Other expenses Total expense Net operating income $ Serving $ 1.25 $ 0.25 $ 0.09 $ 0.02 0 Cost per Labor-Hour $ 8.00
Dinham 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 March, the kennel budgeted for 4,500 tenant-days, but its actual level of activity was 4,560 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for March: Data used in budgeting: Fixed element per month Variable element per tenant-day Revenue 0 $ 35.00 Wages and salaries $ 3,400 $ 8.40 Food and supplies 2,400 14.90 Facility expenses 8,900 3.90 Administrative expenses 7,400 0.30 Total expenses $ 22,100 $ 27.50 Actual results for March: Revenue $ 142,130 Wages and salaries $ 28,640 Food and supplies $ 71,025 Facility expenses $ 26,125 Administrative expenses $ 7,104 The spending variance for food and supplies in March 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: Fixed Element per Month Variable element per tenant-day Revenue $ 0 $33.00 Wages and salaries $ 3,800 $ 7.90 Food and supplies 1,000 11.60 Facility expenses 8,600 2.20 Administrative expenses 6,200 0.20 Total expenses $19,600 $21.90 The net operating income in the planning budget for December would be closest to: Multiple Choice A. $8,150 B. $11,914 C. $8,483 D. $11,633
Fager Clinic uses client-visits as its measure of activity. During February, the clinic budgeted for 2,200 client-visits, but its actual level of activity was 2,250 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for February: Data used in budgeting: Fixed element per month Variable element per client-visit Revenue - $ 68.20 Personnel expenses $ 32,300 $ 21.50 Medical supplies 1,200 12.50 Occupancy expenses 9,700 3.40 Administrative expenses 5,000 0.10 Total expenses $ 48,200 $ 37.50 Actual results for February: Revenue $ 156,210 Personnel expenses $ 80,445 Medical supplies $ 30,105 Occupancy expenses $ 16,800 Administrative expenses $ 5,015 The revenue variance for February would be closest to:
None
Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Foundational 9-14 (Algo) Fixed Element per Month $ 55,000 $ 34,000 When preparing its planning budget, the company estimated it would serve 30 customers per month; however, during May the company actually served 35 customers. Answer is complete but not entirely correct. 5,283,600 F Activity variance Variable Element per Customer Served $ 5,600 $ 1,600 $ 850 $ Actual Total for May $ 182,000 $ 110,300 14. What activity variance would Adger report in May with respect to its revenue? Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values. $ 27,200 $ 32,600
Hemphill 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 amount per month Variable amount 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 $52,700 Supplies $17,500 Insurance $5,500 Miscellaneous $12,200 Calculate revenue variance, spending variance for wages and salaries, and spending variance for insurance. Label them as favorable or unfavorable. Please show your workings
If someone can help me quickly I will give a thumbs up!