Mark Fletcher, president of SoftGro, Inc., was looking forward to seeing the performance reports for November because he knew the company’s sales for the month had exceeded budget by a considerable margin. SoftGro, a distributor of educational software packages, had been growing steadily for approximately two years. Fletcher’s biggest challenge at this point was to ensure that the company did not lose control of expenses during this growth period. When Fletcher received the November reports, he was dismayed to see the large unfavorable variance in the company’s Monthly Selling Expense Report that follows.
SoftGro, Inc. | |||||||||||||||
Monthly Selling Expense Report | |||||||||||||||
For the Month of November | |||||||||||||||
Annual Budget | November Budget | November Actual | November Variance | ||||||||||||
Unit sales | 2,110,000 | 302,000 | 342,000 | 40,000 | |||||||||||
Dollar sales | $ | 156,140,000 | $ | 22,348,000 | $ | 25,308,000 | $ | 2,960,000 | |||||||
Orders processed | 69,600 | 7,800 | 7,240 | (560 | ) | ||||||||||
Sales personnel per month | 90 | 90 | 96 | (6 | ) | ||||||||||
Advertising | $ | 38,400,000 | $ | 3,200,000 | $ | 3,225,000 | $ | 25,000 | U | ||||||
Staff salaries | 3,120,000 | 260,000 | 260,000 | ||||||||||||
Sales salaries | 2,376,000 | 198,000 | 213,000 | 15,000 | U | ||||||||||
Commissions | 6,245,600 | 893,920 | 1,012,320 | 118,400 | U | ||||||||||
Per diem expense | 4,212,000 | 351,000 | 378,700 | 27,700 | U | ||||||||||
Office expenses | 8,644,800 | 796,400 | 758,800 | 37,600 | F | ||||||||||
Shipping expenses | 12,182,000 | 1,646,000 | 1,829,000 | 183,000 | U | ||||||||||
Total expenses | $ | 75,180,400 | $ | 7,345,320 | $ | 7,676,820 | $ | 331,500 | U | ||||||
Fletcher called in the company’s new controller, Susan Porter, to discuss the implications of the variances reported for November and to plan a strategy for improving performance. Porter suggested that the company’s reporting format might not be giving Fletcher a true picture of the company’s operations. She proposed that SoftGro implement flexible budgeting. Porter offered to redo the Monthly Selling Expense Report for November using flexible budgeting so that Fletcher could compare the two reports and see the advantages of flexible budgeting.
Porter discovered the following information about the behavior of SoftGro’s selling expenses.
Required:
1.) Why would Susan Porter propose that SoftGro use flexible budgeting in this situation?
2.) Prepare a revised Monthly Selling Expense Report for November that would permit Mark Fletcher to more clearly evaluate SoftGro’s control over selling expenses.
Answer with working notes is given below
Mark Fletcher, president of SoftGro, Inc., was looking forward to seeing the performance reports for November...
Mark Fletcher, president of SoftGro, Inc., was looking forward to seeing the performance reports for November because he knew the company’s sales for the month had exceeded budget by a considerable margin. SoftGro, a distributor of educational software packages, had been growing steadily for approximately two years. Fletcher’s biggest challenge at this point was to ensure that the company did not lose control of expenses during this growth period. When Fletcher received the November reports, he was dismayed to see...
Mark Fletcher, president of SoftGro, Inc., was looking forward to seeing the performance reports for November because he knew the company’s sales for the month had exceeded budget by a considerable margin. SoftGro, a distributor of educational software packages, had been growing steadily for approximately two years. Fletcher’s biggest challenge at this point was to ensure that the company did not lose control of expenses during this growth period. When Fletcher received the November reports, he was dismayed to see...
Lewis Co. reports the following results for May. Prepare a flexible budget report showing variances between budgeted and actual results. please help Lewis Co. reports the following results for May Prepare a flexible budget report showing variar results. Sales Variable expenses Fixed expenses (total) Units produced and sold Budgeted $ 1,250 per unit $ 500 per unit $153,500 1,390 Actual $2,836,000 5 831,000 $ 141,000 1,590 List variable and fixed expenses separately (Indicate the effect of each variance by selecting...
Bay City Company’s fixed budget performance report for July follows. The $440,000 budgeted total expenses include $300,000 variable expenses and $140,000 fixed expenses. Actual expenses include $130,000 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 6,000 4,900 Sales (in dollars) $ 480,000 $ 436,100 $ 43,900 U Total expenses 440,000 410,000 30,000 F Income from operations $ 40,000 $ 26,100 $ 13,900 U Prepare a flexible budget performance report that shows any variances between budgeted results and actual...
Exercise 21-6 Preparing a flexible budget report LO P1 Lewis Co. reports the following results for May. Prepare a flexible budget report showing variances between budgeted and actual results. Sales Variable expenses Fixed expenses (total) Units produced and sold Budgeted $ 550 per unit $ 220 per unit $132,500 1,250 Actual $815,000 $332,000 $127,000 1,450 List variable and fixed expenses separately. (Indicate the effect of each variance by selecting for favorable, unfavorable, and no variance) LEWIS CO. Flexible Budget Performance...
2. Bay City Company’s fixed budget performance report for July follows. The $594,000 budgeted total expenses include $450,000 variable expenses and $144,000 fixed expenses. Actual expenses include $134,000 fixed expenses. Fixed Budget Actual Results Variances Sales (in units) 8,100 7,000 Sales (in dollars) $ 648,000 $ 623,000 $ 25,000 U Total expenses 594,000 563,000 31,000 F Income from operations $ 54,000 $ 60,000 $ 6,000 U BAY CITY COMPANY Flexible Budget Performance Report For Month Ended July 31 Flexible budget...
ses. To follow is the company's performance report in contribution margin format for August: Data Table The Outrageous Balloon Company Actual vs. Budget Performance Report For the Month Ended August 31 Master Budget Master Budget Variance Actual Sales volume (number of cases sold) Sales revenue 60,000 57,000 Less: Variable expenses Contribution margin 217,800 $ 124,500 93,300 $ 66,200 193,800 114,000 79,800 65,000 Less: Fixed expenses Operating income $ 27,100 $ 14.800 PR 7 of 9 (1 complete) ulti-pack cases. To...
Lewis Co. reports the following results for May. Prepare a flexible budget report showing variances between budgeted and actual results. Budgeted $ 1,150 per unit %24 Actual Sales Variable expenses Fixed expenses (total) Units produced and sold $1,828,000 $ 726,000 $ 139,000 1,570 460 per unit $150, 500 1,370 List variable and fixed expenses separately. (Indicate the effect of each variance by selecting for favorable, unfavorable, and no variance) LEWIS CO. Flexible Budget Performance Report For Month Ended May 31...
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...
E10-39B (similar to) Question Help Requirement Construct a flexible budget performance report for Divine Muffins for the year. Be sure to indicate whether each variance is favorable (F) or unfavorable (U). (Enter the variances as positive numbers. Label each variance as favorable (F) or unfavorable (U). If the variance is 0, make sure to enter in a "0". A variance of zero is considered favorable.) Divine Muffins sells its muffins to restaurants and coffee houses for an average selling price...