Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $177,430budgeted expenses include $123,670 in variable expenses for desks and $18,760 in variable expenses for chairs, as well as $35,000of fixed expenses. Actual fixed expenses total $36,900.Desk sales (in units)Chair sales (in units)Desk salesChair salesTotal expensesIncomeFor Quarter Ended June 30Desk salesChair salesVariable expensesContribution marginFixedBudgetFixed expensesIncome14967ActualResults34,170177,43015575$ 201,150 $ 207,70039,375186,840$ 57,890 $ 60,235VariancesRequired:Prepare a flexible budget performance report that shows variances between budgeted results and actual results. (Indicate the effectof each variance by selecting favorable, unfavorable, or no variance.)$ 6,550 F5,205 F9,410 U$ 2,345 FBUSINESS SOLUTIONSFlexible Budget Performance ReportFlexible Budget Actual Results VarianceFavorable/Unfavorable

The flexible budget is prepared to compare the actual results with flexible budget. It helps to…

Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $177,430 budgeted expenses include $123,670 in variable expenses for desks and $18,760 in variable expenses for chairs, as well as $35,000 of fixed expenses. Actual fixed expenses total $36,900. Desk sales (in units) Chair sales (in units) Desk sales Chair sales Total expenses Income Fixed Budget 149 67 Actual Results 155 75 Variances. $ 201,150 $ 207,700 $ 6,550 F 34,170 39,375 5,205 F 177,430 186,840 9,410 U $ 57,890 $ 60,235 $ 2,345 F Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results. (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.)

Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $177,430 budgeted expenses include $123,670 in variable expenses for desks and $18,760 in variable expenses for chairs, as well as $35,000 of fixed expenses. Actual fixed expenses total $36,900. Desk sales (in units) Chair sales (in units) Desk sales Chair sales Total expenses Income Fixed Budget 149 67 Actual Results 155 75 Variances. $ 201,150 $ 207,700 $ 6,550 F 34,170 39,375 5,205 F 177,430 186,840 9,410 U $ 57,890 $ 60,235 $ 2,345 F Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results. (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.)

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter9: Profit Planning And Flexible Budgets

Section: Chapter Questions

Problem 66P: Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the...

See similar textbooks

Similar questions

Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $179,710 budgeted expenses include $122.010 in variable expenses for desks and $20,700 in variable expenses for chairs, as well as $37,000 of fixed expenses. Actual fixed expenses total $38,300. Desk sales (in units) Chair sales (in units) Desk sales Chair sales Total expenses Income For Quarter Ended June 30 Desk sales Chair sales Variable expenses Contribution margin Fixed Budget 147 69 Fixed expenses Income Actual Results 153 77 Variances $ 188,160 37,950 179,718 $ 46,400 $ 48,975 $ 2,575 F $ 194,310 43,505 188,840 Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results. (Indicate the effect of each varlance by selecting favorable, unfavorable, or no variance.) $ 6,150 F 5,555 F 9,130 U BUSINESS SOLUTIONS Flexible Budget Performance Report Flexible Budget Actual Results Variance…
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $178,970 budgeted expenses include $120,800 in variable expenses for desks and $19,170 in variable expenses for chairs, as well as $39,000 of fixed expenses. Actual fixed expenses total $40,400. Desk sales (in units) Chair sales (in units) Desk sales Chair sales Total expenses Income. For Quarter Ended June 30 Desk sales Chair sales Variable expenses Contribution margin Fixed Budget Fixed expenses Income 151 71 Actual Results 157 79 $ 202,340 $ 208,810 36,210 41,475 178,970 187,670 Variances Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results. (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.) $6,470 F 5,265 P 8,700 U $ 59,580 $ 62,615 $ 3,035 F BUSINESS SOLUTIONS Flexible Budget Performance Report Flexible Budget Actual Results Variance…
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $163,970 budgeted expenses include $118,150 in variable expenses for desks and $14,820 in variable expenses for chairs, as well as $31,000 of fixed expenses. Actual fixed expenses total $32,900. Desk sales (in units) Chair sales (in units) Desk sales. Chair sales Total expenses Income For Quarter Ended June 30 Desk sales Chair sales Variable expenses Contribution margin Fixed Budget 139 57 Fixed expenses Income Actual Results $ 176,530 30, 210 163,970 145 65 Variances $ 6,170 F $ 182,700 35,425 173,380 5,215 F 9,410 U $ 42,770 $ 44,745 $ 1,975 F Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results. (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.) BUSINESS SOLUTIONS Flexible Budget Performance Report Flexible Budget Actual Results Variance…
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $157,830 budgeted expenses include $109,350 in variable expenses for desks and $18,480 in variable expenses for chairs, as well as $30,000 of fixed expenses. Actual fixed expenses total $31,800. Desk sales (in units) Chair sales (in units); Desk sales Chair sales Total expenses Income For Quarter Ended June 30 Desk sales Chair sales Variable expenses Contribution margin Fixed Budget Fixed expenses Income Actual Results Variances 135 141 56 64 Dok 28,560 33,600 157,830 167,530 $ 176,850 $ 183,300 $ 6,450 P 5,040 P 9,700 U Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results. Note: Indicate the effect of each variance by selecting favorable, unfavorable, or no variance. $ 47,580 $ 49,370 $ 1,790 F BUSINESS SOLUTIONS Flexible Budget Performance Report Flexible Budget Actual Results Variance Favorable…
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $170.470 budgeted expenses include $120,080 in variable expenses for desks and $15.390 in variable expenses for chairs, as well as $35,000 of fixed expenses. Actual fixed expenses total $36,500 Desk sales (in units) Chair sales (in units) Desk sales. Chair sales Total expenses Income For Quarter Ended June 30 Desk sales Chair sales Variable expenses Contribution margin Fixed Budget 152 57 Fixed expenses Income $ 194,560 31,920 170,470 Actual Results 158 65 $ 200,660 37,375 179,160 $ 56,010 $ 58,875 Variances Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results, (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.) $ 6,100 F 5,455 F 8,690 U $ 2,065 BUSINESS SOLUTIONS Flexible Budget Performance Report Flexible Budget Actual Results Variance +…
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $171,170 budgeted expenses include $114,000 in variable expenses for desks and $19,170 in variable expenses for chairs, as well as $38,000 of fixed expenses. Actual fixed expenses total $39,600. Desk sales (in units) Chair sales (in units) Desk sales Chair sales Total expenses Income Fixed Budget 152 71 For Quarter Ended June 30 Desk sales Chair sales Variable expenses Contribution margin Actual Results 158 79 Variances. $ 199,120 41,890 $ 205,400 47,795 179,780 $ 6,280 F 5,905 F 8,610 U 171,170 $ 69,840 $ 73,415 $ 3,575 F Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results. (Indicate the effect of each varlance by selecting favorable, unfavorable, or no variance.) BUSINESS SOLUTIONS Flexible Budget Performance Report Flexible Budget Actual Results ENG
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $172,880 budgeted expenses include $122.180 in variable expenses for desks and $20,700 in variable expenses for chairs, as well as $30,000 of fixed expenses Actual fixed expenses total $31,400. Desk sales (in units) Chair sales (in units) Desk sales Chair sales Total expenses Income Fixed Budget 149 69 For Quarter Ended June 30 2 Dock sales Actual Results 155 77 $ 206,150 $ 199,660 41,400 47,355 172,880 181,918 $ 68,180 $ 71,595 Variances $ 6,490 F 5,955 F 9,030 U $ 3,415 F Required: Prepare a flexible budget performance report that shows variances between budgeted results and actual results. (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.) BUSINESS SOLUTIONS Flexible Budget Performance Report Flexible Budget Actual Results Variance Favorable/Unfavorable
Business Solutions's second-quarter 2020 fixed budget performance report for its computer furniture operations follows. The $159,370 budgeted expenses include $106,650 in variable expenses for desks and $18,720 in variable expenses for chairs, as well as $34,000 fixed expenses. The actual expenses include $35,400 fixed expenses. List fixed and variable expenses separately. Desk sales (in units) Chair sales (in units) Desk sales. Chair sales Total expenses Income from operations Desk sales Chair sales Variable expenses Contribution margin Fixed Budget Actual Results Variances 135 72 $170, 100 42,480 159,370 $ 53,210 Fixed expenses income from operations 141 80 $176,250 48,400 168,050 $ 56,600 Prepare a flexible budget performance report that shows any variances between budgeted results and actual results. $6,150 F 5,920 F 8,680 U $3,390 F BUSINESS SOLUTIONS Flexible Budget Performance Report For Quarter Ended June 30 Flexible Budget Actual Results Variance Fav/Unt. Unfavorable Favorable…
Business Solutions's second-quarter 2020 fixed budget performance report for its computer furniture operations follows. The $166,660 budgeted expenses include $110,200 in variable expenses for desks and $20,460 in variable expenses for chairs, as well as $36,000 fixed expenses. The actual expenses include $37,300 fixed expenses. List fixed and variable expenses separately. Desk sales (in units) Chair sales (in units) Desk sales Chair sales Total expenses Income from operations Desk sales Chair sales Variable expenses Contribution margin Fixed Budget Actual Results Variances 145 66 Fixed expenses Income from operations $ 194,300 35,640 166,660 $ 63,280 151 74 $200,830 41,070 175,330 $ 66,570 Prepare a flexible budget performance report that shows any variances between budgeted results and actual results. BUSINESS SOLUTIONS Flexible Budget Performance Report For Quarter Ended June 30 Flexible Budget Actual Results $6,530 F 5,430 F 8,670 U $3,290 F Variance Fav./Unf. Unfavorable Favorable…
The actual selling expenses incurred in March 2020 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $11,180 Sales salaries $35,500 Advertising 10,530 Depreciation 7,400 Travel 6,920 Insurance 1,100 Delivery 3,580 (b) Prepare a flexible budget performance report, assuming that March sales were $180,500. (List variable costs before fixed costs.) FALLON COMPANYSelling Expense Flexible Budget ReportFor the Month Ended March 31, 2020 Difference Budget Actual FavorableUnfavorableNeither Favorablenor Unfavorable Select an opening flexible budget report item AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses $Enter a dollar amount $Enter a dollar amount Select an opening name for…
Sheffield Company combines its operating expenses for budget purposes in a selling and administrative expenses budget. For the first six months of 2022, the following data are available: 1. 2 3. 4 Sales: 19,800 units in quarter 1: 21.300 units in quarter 2 D Variable costs per dollar of sales: sales commissions 5%; delivery expense 2%; and advertising 4% Fixed costs per quarter: sales salaries $10,700; office salaries $8,300: depreciation $4,300; insurance $1,300: utilities $800; and repairs expense $600 Unit selling price: $19 Prepare a selling and administrative expenses budget by quarters for the first six months of 2022 SHEFFIELD COMPANY Selling and Administrative Expenses Budget For the Six Months Ending June 30, 2022 2 Total