Disregard the numbers in the first photo, that is just to show what answers I need. Use the data given in the second picture to construct a flexible budget performance report. Be sure to indicate whether each variance is favorable or unfavorable
Amazing Muffins sells its muffins to restaurants and coffee houses for an average selling price of $35 per case. The following information relates to the budget for Amazing Muffins for this year (all figures are annual totals unless otherwise noted): (Click the icon to view the budget Information.) During the year. Amazing Muffins actually sold 7,500 cases, resulting in total sales revenue of $270,700. Actual expenses (in total) from this year are as follows: :: (Click the icon to vlew the actual expenses.) Requirement Construct a flexible budget performance report for Amazing 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.) Actual 7,500 cases Budget Variance Budget 7,500 cases volume Variance Budget 7,000 cases $ 270,700 $ 8,200 F $ 262,500 S 17,500 '$ 245,000 7,000 7,700 40,400 Sales revenue ($35 per case) Variable operating expenses: Packaging expense ($1 per case sold) Shipping expense (S5 per case sold) Sales commissions (4% of sales price) Fixed operating expenses: Salaries Office rent Depreciation Insurance expense 200 2,900 U 328 7,500 37,500 10,500 500 2,500 700 u 35,000 9,800 10,828 6,600 200' ' : O'F' 6,400 3,200 6,400 3,300 3,000 O'F' OF 3,300 3,000 3,000 1,800 1,300 500 PPP 1,800 800 200U 600 600 D'or Office Supplies expense Total operating expenses Choose from any list or enter any number in the innut fields and then click herk Answer 6 of 7 (7 complete) HW Scc Score: 0.06 of 1 pt W E10-39B (similar to) Data Table The Requirement Construct a flexible variance is favorable (F) or unfavorable Budgeted sales in cases ........ Organic Muffins sells its muffins to restaurants and coffee houses for an average selling price of $35 per case. The following information relates to the budget for Organic Muffins for this year (all figures are annual totals unless otherwise noted): (Click the icon to view the budget information.) During the year, Organic Muffins actually sold 9,900 cases, resulting in total sales revenue of $353,700. Actual expenses (in total) from this year are as follows: (Click the icon to view the actual expenses.) Packaging cost per caso ........ Shipping expense per case ...... Sales commission expense...... Salaries expense Office rent................ Depreciation.................. 9,200 cases S 2 $ 5 1% of sales price $ 6,000 $ 3,600 $ 2,700 $ 1,800 $ 1,400 Insurance expense ............ Organic Muffins Flexible Budget Performance Report - Sales and Operating Expenses For the Year Ended December 31 Flexible Flexible Actual Budget Budget Volume 9,900 cases Variance 9,900 cases Variance Master Office supplies expense ........ Budget 9,200 cases i Data Table Sales revenue ($35 per case) Packaging cost...................$ Shipping expense ............. Sales commission expense....... Salaries expense............... Office rent .................. Depreciation... .............. Insurance expense............ Office supplies expense............ to en 20,100 50,500 3,537 7,500 3,600 2,700 1,300 1,500 Choose from any list or enter any number in the input fields and then click Check
