BUSINESS SOLUTIONS | ||||
Flexible Budget Performance Report | ||||
For Quarter Ended June 30 | ||||
Flexible Budget | Actual Results | Variance | Fav./Unf. | |
Desk sales | 192,400.00 | 190,920.00 | 1,480.00 | Unfavorable |
Chair sales | 36,300.00 | 37,290.00 | 990.00 | Favorable |
Variable expenses | 134,080.00 | 134,400.00 | 320.00 | Unfavorable |
Contribution margin | 94,620.00 | 93,810.00 | 810.00 | Unfavorable |
Fixed expenses | 36,000.00 | 37,500.00 | 1,500.00 | Unfavorable |
Income from operation | 58,620.00 | 56,310.00 | 2,310.00 | Unfavorable |
Explanation | ||||
Total budgeted desk sales | $ 184,600.00 | |||
Total units budgeted | 142.00 | |||
Budgeted selling price | $ 1,300.00 | per unit | ||
Flexible budget units | 148.00 | |||
Flexible budget sales | $ 192,400.00 | |||
Total budgeted chair sales | $ 31,900.00 | |||
Total units budgeted | 58.00 | |||
Budgeted selling price | $ 550.00 | per unit | ||
Flexible budget units | 66.00 | |||
Flexible budget sales | $ 36,300.00 | |||
Total budgeted variable costs for desks | $ 112,180.00 | |||
Total units budgeted | 142.00 | |||
Budgeted variable expenses per desk | $ 790.00 | per unit | ||
Flexible budget units | 148.00 | |||
Flexible budget variable expenses for desks | $ 116,920.00 | |||
Total budgeted variable costs for chairs | $ 15,080.00 | |||
Total units budgeted | 58.00 | |||
Budgeted variable expenses per chair | $ 260.00 | per unit | ||
Flexible budget units | 66.00 | |||
Flexible budget variable expenses for chair | $ 17,160.00 | |||
Variable expenses (Actual) = 171,900 - 37,500 = $134,400 | ||||
Business Solutions's second-quarter 2020 fixed budget performance report for its computer furniture operations follows. The $163,260...
Business Solutions's second quarter 2020 fixed budget performance report for its computer furniture operations follows. The $166140 budgeted expenses include $114.540 in variable expenses for desks and $15,600 in variable expenses for chairs, as well as $36.000 foed expenses. The actual expenses include $37100 fixed expenses. Usted and variable expenses separately Detals (ints) Chair sales in its) Desk sales Chair sales Total penes $184,920 $191,520 $6,0 f $2. Prepare a flexible budget performance report that shows any variances between budgeted...
Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $167,240 budgeted expenses include $114,240 in variable expenses for desks and $21,000 in variable expenses for chairs, as well as $32,000 fixed expenses. The actual expenses include $33,600 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 Fixed Budget Actual Results Variances 136 142 60 68 $170,000 $176,080 $6,080...
Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $156,000 budgeted expenses include $108,000 in variable expenses for desks and $18,000 in variable expenses for chairs, as well as $30,000 fixed expenses. The actual expenses include $31,000 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 Fixed Budget Actual Results Variances 144 150 72 80 $180,000 $186,000 $6,000...
Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $168,990 budgeted expenses include $111,200 in variable expenses for desks and $20,790 in variable expenses for chairs, as well as $37,000 fixed expenses. The actual expenses include $38,000 fixed expenses. List fixed and variable expenses separately. Fixed Budget Actual Results Variances Desk sales (in units) 139 145 Chair sales (in units) 63 71 Desk sales $ 179,310 $ 185,600 $ 6,290 F Chair sales 34,020...
Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $176,950 budgeted expenses include $120,350 in variable expenses for desks and $19,600 in variable expenses for chairs, as well as $37,000 fixed expenses. The actual expenses include $38,200 fixed expenses. List fixed and variable expenses separately. Fixed Budget Actual Results Variances Desk sales (in units) 145 151 Chair sales (in units) 70 78 Desk sales $ 191,400 $ 197,810 $ 6,410 F Chair sales 35,000...
Need help with this accounting question. Serial Problem Business Solutions LO P1 Business Solutions's second-quarter 2018 fixed budget performance report for its computer furniture operations follows. The $173,200 budgeted expenses include $120,080 in variable expenses for desks and $15,120 in variable expenses for chairs, as well as $38,000 fixed expenses. The actual expenses include $39,900 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...
Solitaire Company’s fixed budget performance report for June follows. The $311,250 budgeted expenses include $273,900 variable expenses and $37,350 fixed expenses. Actual expenses include $43,850 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,300 10,700 Sales (in dollars) $ 415,000 $ 535,000 $ 120,000 F Total expenses 311,250 374,500 63,250 U Income from operations $ 103,750 $ 160,500 $ 56,750 F Prepare a flexible budget performance report showing any variances between budgeted and actual results. List fixed and...
Bay City Company's fixed budget performance report for July follows. The $587,000 budgeted total expenses include $400,000 variable expenses and $187,000 fixed expenses. Actual expenses include $177,000 fixed expenses. Variances Sales (in units) Sales (in dollars) Total expenses Income from operations Fixed Budget 8,000 $640,000 587,000 $ 53,000 Actual Results 6,900 $607,200 550,000 $ 57,200 $32,800 U 37,000 F $ 4,200 U Prepare a flexible budget performance report that shows any variances between budgeted results and actual results. List fixed...
Bay City Company's fixed budget performance report for July follows. The $587,000 budgeted total expenses include $400,000 variable expenses and $187,000 fixed expenses. Actual expenses include $177,000 fixed expenses. Actual Fixed Budget Variances Results Sales (in units ) Sales (in dollars) Total expenses 8,000 $640,000 587,000 $ 53,000 6,900 $614,100 547,000 $25,900 U 40,000 F $67,100 $14,100 U Income from operations Prepare a flexible budget performance report that shows any variances between budgeted results and actual results. List fixed and...