Echo Canyon Muffins sells its muffins to restaurants and coffee houses for an average selling price of $29 per case. The following information relates to the budget for Echo Canyon Muffins for this year( all figures are annual totals unles otherwise noted)
Budgeted Information:
Budgeted sales in cases: 8500 cases
Packaging cost per case: $5
Shipping expense per case: $4
Sales commission expense: 1% of sales price
Salaries expense:$6700
Office rent:$3100
Depreciation:$3200
Insurance expense: $2300
Office supplies expense:$1000
During the year, Echo Canyon Muffins actually sold 9200 cases, resulting in total sales revenue of $274,400. Actual expenses (in total) from this year are as follows.
Packaging cost:$46,200
Shipping expense:$37,600
Sales commission expense:$2744
Salaries expense:$8100
Office rent:$3100
Depreciation:$3200
Insurance expense:$1500
Office supplies expense:$1300
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 or unfavorable. If the variance is 0 make sure to enter a 0. A variance of zero is considered favorable)