Must show ALL calculation. Please see attachment for complete problem.

ACC-102 Student Name TO RECEIVE FULL CREDIT, YOU MUST PRO AND ALL SCHEDULES AND STATEMENTS Problem 23.7A Snells is a retain department store. The following cost-volume relationships were used in developing a flexible budget for the company for the current year: Cost of merchandise sold Selling and promotion expense Building depreciation expense Buying expense Delivery expense Credit and collection expense Administrative Expense Totals Management expected to attain a sales level of $12 million during the current year. At the end o the actual results achieved by the company were as follows: Net Sales Cost of Goods Sold Selling and promotion expense Building occupancy expense Buying expense Delivery expense Credit and collection expense Administrative expense $ $ $ $ $ $ $ $ 10,500,000 6,180,000 1,020,000 420,000 594,000 183,000 90,000 564,000 a. 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 (3) Any amount over (under) budget. Use the cost-volution relationships given in the problem to compute the flexible budget amounts b. Write a statement evaluating the company's performance in relation to the plan reflective in t flexible budget. NOTE: This statement must be a minimum of 2 paragraphs and provide supporting evidence to y VE FULL CREDIT, YOU MUST PROVIDE ALL SUPPORTING CALCULATIONS INCLUDING FORMULAS SCHEDULES AND STATEMENTS MUST BE IN PROPER FORMAT Embed all calculations in the results cell lationships were used in Yearly Fixed Expenses $ $ $ $ $ $ $ 210,000 186,000 150,000 111,000 72,000 531,000 1,260,000 Variable Expenses per Sales Dollar $ $ $ $ $ $ $ $ 0.600 0.082 0.022 0.041 0.008 0.002 0.003 0.758 g the current year. At the end of the year, budget amounts developed for as a partial multiple-step ate columns for ute the flexible budget amounts. elation to the plan reflective in the rovide supporting evidence to your position! NCLUDING FORMULAS e results cell