Business Solutions\' second quarter 2012 fixed budget performance report for its
ID: 2589362 • Letter: B
Question
Business Solutions' second quarter 2012 fixed budget performance report for its computer furniture operations follows. The $164,780 budgeted expenses include $114,760 in variable expenses for desks and $18,020 in variable expenses for chairs, as well as $32,000 fixed expenses. The actual expenses include $33,200 fixed expenses Actual Fixed Budget Results Variances 151 53 193,280 Desk sales (in units) 157 Chair sales (in units) Desk sales (in dollars) Chair sales (in dollars) Total expenses Income from operations 61 s 6,110 F 199,390 33,855 s 5,235 F 173,690 s 8,910 U 59,555 s 2435 F s 28,620 164,780 $57,120 Prepare a flexible budget performance report that shows any variances between budgeted results and actual results. List fixed and variable expenses separately. (Input all amounts as positive values. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Omit the "$" sign in your response.) BUSINESS SOLUTIONS Flexible Budget Performance Report For Quarter Ended June 30 Flexible Budget Actual Results Variances $200960|199390 $ | 1570| Desk sales Chair sales Variable expenses 3294033855 915 FC 152260 x Contribution margin Fixed expenses Income from operationsl $1595551.Explanation / Answer
Business Solutions Flexible Budget Variance Flexible Budget Actual Budget Variance Desk sales (Units) 157 157 Chairs Sales (Units) 61 61 Desk Sales in dollars($193280/151)*157 200960 199390 $ 1,570.00 (U) Chairs Sales in dollars($28620/53)*61 32940 33855 $ 915.00 (F) Variable Expenses (114760)*(157/151)+(18020)*(61/53) $ 140,060.00 $ 140,490.00 $ 430.00 (U) Contribution Margin=(Sales-Variable Expenses) $ 93,840.00 $ 92,755.00 $ 1,085.00 (U) Fixed Expenses $ 32,000.00 $ 33,200.00 $ 1,200.00 (U) Net Income=(Contribution-Fixed Expenses) $ 61,840.00 $ 59,555.00 $ 2,285.00 (U) Total Budgeted Expenses Variable expenses of Desk $ 114,760.00 Variable expenses of Chairs $ 18,020.00 Fixed Expenses $ 32,000.00 Total Budgeted Exp $ 164,780.00 Actual Variable Expenses Actual Total Expenses $ 173,690.00 Less: Fixed Expenses $ 33,200.00 Actual Variable Expenses $ 140,490.00 Note: Flexible Budget always prepared on the basis of actual output
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.