View the budget information.

View the actual expenses $($in total$)$ from this year.

Read the requirement

$($Enter the variances as positive numbers. Label each variance as favorable $($F$)$ or unfavorable $($U$),$ in the input field after the amount you enter. If the variance is $0,$ make sure to enter in a $"0".$ A variance of zero is considered favorable.$)$

Echo Canyon Muffins

Flexible Budget Performance Report $-$ Sales and Operating Expenses

For the Year Ended December $31$

$\backslash$table$[[,$Flexible,Flexible,,Master$],[$Actual$,$Budget,Budget,Volume,Budget$],[8,100$ cases,Variance,$8,100$ cases,Variance,$7,500$ cases$]]$

Sales revenue

$($ $$35$ per case$)$

$$

$$

$$

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).$

Actual expenses

Budget information

$\backslash$table$[[$Budgeted sales in cases $.......,7,500$ cases$],[$Packaging cost per case $......$ $$,1],[$Shipping expense per case $.....$ $$,5],[$Sales commission expense $.....,3\%$ of sales price$],[$Salaries expense $...........$ $$,6,400],[$Office rent $..............$ $$,3,100],[$Depreciation $...............$ $$,2,800],[$Insurance expense $..........$ $$,2,400],[$Office supplies expense $......$ $$,1,100]]$