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 1 Dock sales Actual Results $ 199,660 41,400 172,888 155 77 $ 206,150 47,355 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 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 1 Dock sales Actual Results $ 199,660 41,400 172,888 155 77 $ 206,150 47,355 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

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 10CE: Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects...

See similar textbooks

Similar questions

Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?
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 $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 $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 $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 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…
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $169.380 budgeted expenses include $120,000 in variable expenses for desks and $19,380 in variable expenses for chairs, as well as $30,000 of fixed expenses. Actual fixed expenses total S31,500. Actual Fixed Budget Results Variances Desk sales (in units) 150 156 Chair sales (in units) Desk sales Chair sales Total expenses 57 65 $ 189,000 30,210 169, 380 $ 49,830 $ 6,000 F 5,215 F $ 195,000 35,425 178,820 $ 51,605 9,440 U $ 1,775 Income 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 For Quarter Ended June 30 Desk sales Chair sales Variable expenses Contribution margin Fixed expenses Flexible Budget Actual Results Variance FavorableiUntavorable…
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
Please help me with the functions for this ! Thank you! Jay Corporation has decided to prepare contribution income statements for internal planning. Budgeted information for Quarter 1 of 2024: Sales in units 17,000 Sales price per unit $48.00 After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) $29.00 Sales Commissions (per dollar of sales) 9.50% Administrative Salaries (per quarter) $45,000 Rent Expense (per quarter) $27,000 Depreciation Expense (per quarter) $36,000 Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Total Cost Units Quarter 1 $67,000 12,500 Quarter2 $94,000 21,000 Quarter 3 $89,800 13,800 Quarter 4 $92,600 20,000 2023 Quarter 1 $72,500 13,700 Quarter2 $80,000 14,000 Quarter 3 $84,000 14,300 Quarter…
Business Solutions's second-quarter 2022 fixed budget performance report for its computer furniture operations follows. The $183,820 budgeted expenses include $125,800 in variable expenses for desks and $18,020 in variable expenses for chairs, as well as $40,000 of fixed expenses. Actual fixed expenses total $41,000. Fixed Budget Actual Results Variances Desk sales (in units) 148 154 Chair sales Total expenses Income Chair sales (in units) Desk sales $ 192,400 31,270 183,820 53 61 $ 198,660 36,905 193,110 $ 6,260 F 5,635 F 9,290 U $ 39,850 $ 42,455 $ 2,605 F 13 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.) For Quarter Ended June 30 BUSINESS SOLUTIONS Flexible Budget Performance Report Flexible Budget Actual Results Variance Favorable/Unfavorable Desk sales Chair sales Variable expenses Contribution margin Fixed expenses…