**Arrasmith Corporation****Flexible Budget Performance Report****For the Month Ended February 28**| | Actual Results | Revenue and Spending Variances | Flexible Budget | Activity Variances | Planning Budget ||------------------------------------|----------------|-------------------------------|-----------------|--------------------|-----------------|| Customers served | 32,800 | | 32,800 | | 35,200 || Revenue | | | | | || Expenses: | | | | | || - Wages and salaries | | | | | || - Supplies | | | | | || - Insurance | | | | | || - Miscellaneous expense | | | | | || Total expense | | | | | || Net operating income | | | | | |**Description:**This table represents a Flexible Budget Performance Report for Arrasmith Corporation for the month ended February 28. The report compares various budget categories and underscores the actual results versus the budget projections.- **Customers Served:** The actual number of customers served was 32,800, which matched the flexible budget but was lower than the planning budget of 35,200 customers.- **Revenue and Expenses:** Detailed data for revenue, wages and salaries, supplies, insurance, miscellaneous expenses, total expenses, and net operating income are not provided in this chart.- **Variance Categories:** The report examines revenue and spending variances as well as activity variances to assess the differences between budgeted and actual figures.This format provides a structured overview to assist in analyzing performance and identifying areas for financial adjustments or improvements. ABC Corporation uses customers served as its measure of activity. During February, the company budgeted for 35,200 customers, but actually served 32,800 customers. The company uses the following revenue and cost formulas in its budgeting, where q is the number of customers served:- **Revenue:** $3.70q- **Wages and salaries:** $33,400 + $1.16q- **Supplies:** $0.56q- **Insurance:** $10,600- **Miscellaneous expenses:** $6,600 + $0.32qThe company reported the following actual results for February:- **Revenue:** $123,800- **Wages and salaries:** $68,200- **Supplies:** $14,600- **Insurance:** $10,600- **Miscellaneous expense:** $18,700**Required:**Prepare the company's flexible budget performance report for February. Label each variance as favorable (F) or unfavorable (U). *(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.)*

The variance is the difference between the standard and actual cost data. The revenue and spending…

ABC Corporation uses customers served as its measure of activity. During February, the company budgeted for 35,200 customers, but actually served 32,800 customers. The company uses the following revenue and cost formulas in its budgeting, where q is the number of customers served: Revenue: $3.70q Wages and salaries: $33,400 + $1.16q Supplies: $0.56q Insurance: $10,600 Miscellaneous expenses: $6,600 + $0.32q The company reported the following actual results for February: Revenue Wages and salaries. Supplies Insurance Miscellaneous expense $123,800 $ 68,200 $ 14,600 $ 10,600 $ 18,700 Required: Prepare the company's flexible budget performance report for February. Label each variance as favorable (F) or unfavorable (U). 56á

ABC Corporation uses customers served as its measure of activity. During February, the company budgeted for 35,200 customers, but actually served 32,800 customers. The company uses the following revenue and cost formulas in its budgeting, where q is the number of customers served: Revenue: $3.70q Wages and salaries: $33,400 + $1.16q Supplies: $0.56q Insurance: $10,600 Miscellaneous expenses: $6,600 + $0.32q The company reported the following actual results for February: Revenue Wages and salaries. Supplies Insurance Miscellaneous expense $123,800 $ 68,200 $ 14,600 $ 10,600 $ 18,700 Required: Prepare the company's flexible budget performance report for February. Label each variance as favorable (F) or unfavorable (U). 56á

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

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 Customers served Revenue ($3.504) Expenses: Mages and salaries ($24,200 $1.324) Supplies ($0.729) Insurance ($6,100) Miscellaneous expense (55,100 50.410) Total expense Net operating income Actual Results 43,000 $150,300 80,960 28,840 6,100 20,920 136,820 $ 11,400 Planning Budget 42,000 $147,000 79,640 30,240 6,100 22,320 138,300 $1,700 Variances $3,300 F 1,320 U 1,400 F 0 None 1,400 F 1,480 F $4,780 F Required: Prepare the company's Comprehensive Performance Report for November. Label each variance as favorable (F) or unfavorable (U). (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.)
Lemon, Inc. has prepared the following budgets for March. In March, budgeted production is 1,000 units, budgeted sales is 1,200 units, and raw materials inventory and unit costs will stay constant. Direct materials Direct labor Manufacturing overhead Selling and administrative expense What is budgeted cost of goods sold for March? A. $40,734 B. $42,400 C. $48,880 D. $50,880 $8,000 $14,400 $20,000 $16,000
Elroy Corporation bases its manufacturing overhead budget on budgeted direct labor-hours. The variable overhead rate is $2.90 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $198,560 per month, which includes depreciation of $28,970. All other fixed manufacturing overhead costs represent current cash flows. The July direct labor budget indicates that 9,800 direct labor-hours will be required in that month. Required: SHOW YOUR WORK in budget format a. Determine the cash disbursements for manufacturing overhead in good form, including heading, for January 2024b. Determine the predetermined overhead rate for July. (Round your answer to 2 decimal places.)
ABC Company's budgeted sales for June, July, and August are 13,000, 17,000, and 14,700 units respectively. The following cost behavior patterns are budgeted for ABC Company's operating expenses each month: Fixed costs: salaries, $2,500; rent, $5,500; depreciation, $2,900; advertising, $3,700 Mixed costs: utilities, $3,500 + $0.40 per unit Variable costs per unit sold: sales commissions, $2.50; marketing promotions, $1.50; supplies, $0.45; bad debt expense, $0.20 Required: Prepare ABC Company's operating expense budget for June, July, and August. Note: Enter all values as positive value.
At the beginning of the period, the Cutting Department budgeted direct labor of $54,060 and supervisor salaries of $47,590 for 3,180 hours of production. The department actually completed 3,500 hours of production. Determine the budget for the department assuming that it uses flexible budgeting.$______________
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:
The following budgeted data pertain to Zee Corporation for the month of Janua Quantity (Q) Static Budget 15,000 Tir Sales Revenue (13Q) $195,000 Variable Manufacturing Cost (4Q) 60,000 Fixed Manufacturing Cost 30,000 Variable Selling and Administrative Expenses (1Q) 15,000 Fixed Selling and Administrative Expenses 15,000 Zee Corporation incurred the following costs during the month: Actual Quantity (Q) 13,500 Sales Revenue $189,000 Variable Manufacturing Cost 56,000 Fixed Manufacturing Cost 30,000 Variable Selling and Administrative Expenses 13,500 Fixed Selling and Administrative Expenses 15,000 The activity variance for Variable Manufacturing cost for January is: O a. $4,000 F O b. $6,000 F O c. $4,000 U O d. $6,000 U
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?…
ABC Company’s budgeted sales for June, July, and August are 13,000, 17,000, and 14,700 units respectively. The following cost behavior patterns are budgeted for ABC Company’s operating expenses each month: Fixed costs: salaries, $2,500; rent, $5,500; depreciation, $2,900; advertising, $3,700 Mixed costs: utilities, $3,500 + $0.40 per unit Variable costs per unit sold: sales commissions, $2.50; marketing promotions, $1.50; supplies, $0.45; bad debt expense, $0.20 Required: Prepare ABC Company’s operating expense budget for June, July, and August. Note: Enter all values as positive value.
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
Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,200 units. Sales Costs Direct materials Direct labor PHOENIX COMPANY Fixed Budget For Year Ended December 31 Sales staff commissions Depreciation-Machinery. Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-office equipment Income $ 3,040,000 1,003, 200 212,800 45,600 295,000 202,000 228,000 246,000 457,400 198,000 $ 152,000 Problem 8-1A (Algo) Preparing and analyzing a flexible budget LO P1 Required: 1&2. Prepare flexible budgets at sales volumes of 14,200 and 16,200 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,200 units. Prepare a simple budgeted income statement if 18,200 units are sold. Complete this question by entering your answers in the tabs below.
None