Question

Echo Canyon Muffins sells its muffins to restaurants and coffee houses for an average selling price of $26 per case. The following information relates to the budget for Echo Canyon Muffins for this year (all figures are annual totals unless otherwise noted): E: (Click the icon to view the budget information.) During the year, Echo Canyon Muffins actually sold 9,500 cases, resulting in total sales revenue of $255,000. Actual expenses (in total) from this year are as follows: (Click the icon to view the actual expenses.) Requirement Construct a flexible budget performance report for Echo Canyon 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.) * Data Table h Muffi - X Data Table - Sale Dece Flexit Packaging.cost..............................$ Budd Shipping expense................ Variai Sales. commission expense.........$ Budgeted sales in cases ........ Packaging cost per case Shipping.expense per case ...... Sales commission expense...... Salaries expense.... Office rent Depreciation........ Insurance expense. Office supplies expense.. 8,800 cases $ 5 $ 1 4% of sales price $ 6,100 $ 3,800 Salaries, expense.................$ Office rent.......... Depreciation.......... Insurance expense.................. 48,100 10,300 10,200 7,500 3,800 2,600 2,200 2,600 2,400 Office supplies expense....... 800 $ 500

Answer 1

Solution:

Echo Canyan Muffins
Flexible Budget Performance Report
For the year
Particulars	Actual results	Revenue and spending variances		Flexible Budget	Activity Variances		Planning Budget
Nos of units sold	9500			9500			8800
Revenue	$255,000.00	$8,000.00	F	$247,000.00	$18,200.00	F	$228,800.00
Expenses:
Packaging cost	$48,100.00	$600.00	U	$47,500.00	$3,500.00	U	$44,000.00
Shipping Expense	$10,300.00	$800.00	U	$9,500.00	$700.00	U	$8,800.00
Sales commission expense	$10,200.00	$320.00	U	$9,880.00	$728.00	U	$9,152.00
Salaries expense	$7,500.00	$1,400.00	U	$6,100.00	$0.00	None	$6,100.00
Office rent	$3,800.00	$0.00	None	$3,800.00	$0.00	None	$3,800.00
Depreciation	$2,600.00	$0.00	None	$2,600.00	$0.00	None	$2,600.00
Insurance expense	$2,200.00	$200.00	F	$2,400.00	$0.00	None	$2,400.00
Office supplies expense	$800.00	$300.00	U	$500.00	$0.00	None	$500.00
Total Expenses	$85,500.00	$3,220.00	U	$82,280.00	$4,928.00	U	$77,352.00
Net Income	$169,500.00	$4,780.00	F	$164,720.00	$13,272.00	F	$151,448.00