Please get totals as well for last part thankyou:)

Dream Muffins sells its muffins to restaurants and coffee houses for an average selling price of $33 per case. The following information relates to the budget for Dream Muffins for this year (all figures are annual totals unless otherwise noted): (Click the icon to view the budget information.) During the year, Dream Muffins actually sold 8,100 cases, resulting in total sales revenue of $274,800. Actual expenses (in total) from this year are as follows: (Click the icon to view the actual expenses.) Dream Muffins Flexible Budget Performance Report - Sales and Operating Expenses For the Year Ended December 31 Flexible Master Actual 8,100 cases Flexible Budget Variance Budget 8,100 cases Volume Variance Budget 8,000 cases Sales revenue ($33 per case) Requirement Construct a flexible budget performance report for Dream 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.) 0 Data Table 8,000 cases 2 Budgeted sales in cases Packaging cost per case Shipping expense per case. Sales commission expenses Salaries expense. Office rent.............. Depreciation. Insurance expense. Office supplies expense... 3% of sales price $ 7,000 $ 3,800 $ 2,900 $ 2,100 $ 1,300 Dream Muffins Flexible Budget Performance Report - Sales and Operating Expenses For the Year Ended December 31 Flexible Flexible Actual Budget Budget Volume 8,100 cases Variance 8,100 cases Variance Master Budget 8,000 cases Fales revenue $ 274,800 $ 7,500 F $ 267,300 $ 3,300 F $ 264,000 16,800 10,300 8,244 600 U 2,200 U 225 U 16,200 8,100 8,019 200 U 100 U 1 6,000 8,000 7.920 99 U ($33 per case) ariable operating expenses: Packaging expense ($2 per case sold) Shipping expense ($1 per case sold) Sales commissions (3% of sales price) ixed operating expenses Salaries Office rent Depreciation Insurance expense 1,600 U 8,600 3,800 2,900 1,800 54244 7,000 3,800 2,900 2,100 49419 7,000 3,800 2,900 2,100 49020 300 F 4825 U Office Supplies expense 399 0