Module+14000+XVI+Formulas

=XVI. Module 14000 Formulas CQ =

Formulas
Sales price variance= (Actual price- Expected price)x Quantity sold

Price volume variance= (Actual volume- Expected volume)x Expected price

Overall sales variance= Sales price variance+ Price volume variance

Contribution margin variance= Actual contribution margin- Budgeted contribution margin

Contribution margin volume variance= (Actual quantity sold- Budgeted quantity sold)x Budgeted average unit contribution margin

Sales mix variance= [(Product 1 actual units- Product 1 budgeted units)x (Product 1 budgeted average unit contribution margin)]+ [(Product 2 actual units- Product 2 budgeted units)x (Product 2 budgeted contribution margin- Budgeted average unit contribution margin)]

Market share variance= [(Actual market share percentage- Budgeted market share percentage)x Actual industry sales in units]x Budgeted average unit contribution margin

Market size variance= [(Actual industry sales in units- Budgeted industry sales in units)x Budgeted market share percentage]x Budgeted average unit contribution margin