Question
Snells is a retail department store. The following cost-volume relationships were used in developing a flexible budget for the company for the current year: Yearly
Snells is a retail department store. The following cost-volume relationships were used in developing a flexible budget for the company for the current year: |
Yearly Fixed Expenses | Variable Expenses per Sales Dollar | |||||
Cost of merchandise sold | $ | 0.600 | ||||
Selling and promotion expense | $ | 210,000 | 0.082 | |||
Building occupancy expense | 186,000 | 0.022 | ||||
Buying expense | 150,000 | 0.041 | ||||
Delivery expense | 111,000 | 0.008 | ||||
Credit and collection expense | 72,000 | 0.002 | ||||
Administrative expense | 531,000 | 0.003 | ||||
Totals | $ | 1,260,000 | $ | 0.758 | ||
| | | | |||
Management expected to attain a sales level of $12 million during the current year. At the end of the year, the actual results achieved by the company were as follows: |
Net sales | $ | 10,500,000 |
Cost of goods sold | 6,180,000 | |
Selling and promotion expense | 1,020,000 | |
Building occupancy expense | 420,000 | |
Buying expense | 594,000 | |
Delivery expense | 183,000 | |
Credit and collection expense | 90,000 | |
Administrative expense | 564,000 | |
Instructions |
Prepare a schedule comparing the actual results with flexible budget amounts developed for the actual sales volume of $10,500,000. Organize your schedule as a partial multiple-step income statement, ending with operating income. Include separate columns for (1) flexible budget amounts, (2) actual amounts, and (3) any amount over (under) budget. Use the cost-volume relationships given in the problem to compute the flexible budget amounts. (Leave no cells blank - be certain to enter "0" wherever required.Amounts to be deducted should be indicated with a minus sign. Omit the "$" sign in your response.) |
SNELLS Comparison of Budgeted and Actual Revenue and Expenses For the Year Ended December 31, 20__ | |||
Flexible Budget | Actual | Over (or Under) Budget | |
$ | $ | $ | |
$ | $ | $ | |
Operating expenses: | |||
$ | $ | $ | |
Total operating expenses | $ | $ | $ |
Operating income | $ | $ | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started