Variance Computations Sales Mix Variance BBJ EBJ JBJ Total Actual units of all Actual sales mix...

Transcribed Image Text:

Variance Computations Sales Mix Variance BBJ EBJ JBJ Total Actual units of all Actual sales mix products sold percentage Sales Quantity Variance Actual units of all of all products products sold sold BBJ EBJ JBJ Total Sales Price Variance BBJ EBJ JBJ Total Budgeted sales Budgeted CM mix percentage per unit Sales mix variance Budgeted units Budgeted sales mix percentage Budgeted CM per unit Sales quantity variance Flexible budget Sales price Actual sales sales variance Note: Please write the formulae so that positive values represent favorable (F) variances, and negative values represent unfavorable (U) variances. The template is setup to make this easy to accomplish. Use conditional formatting to label your variances in column I Variance Computations Sales Mix Variance BBJ EBJ JBJ Total Actual units of all Actual sales mix products sold percentage Sales Quantity Variance Actual units of all of all products products sold sold BBJ EBJ JBJ Total Sales Price Variance BBJ EBJ JBJ Total Budgeted sales Budgeted CM mix percentage per unit Sales mix variance Budgeted units Budgeted sales mix percentage Budgeted CM per unit Sales quantity variance Flexible budget Sales price Actual sales sales variance Note: Please write the formulae so that positive values represent favorable (F) variances, and negative values represent unfavorable (U) variances. The template is setup to make this easy to accomplish. Use conditional formatting to label your variances in column I