Spreadsheet: 260060d1377219143-sales-price-volume-mix-variance-analysis-who-can-explain-copy-of-price-volume-mix-variance
Sheet: Sheet1

Current Formula | Volume
Volume/Price/Mix Calculation | (Act Vol - Bud Vol)*Weighted Average Bud Price
 | Price
 | (Act Price-Bud Price)*Act Vol
 | Mix
 | (Act Vol - Bud Vol)*(Bud Price-Weighted Ave Bud price)
 | Actual Vol | [NAME] |  | Act Price | [NAME] |  | Total Act | Total Bud | Total |  | Volume | Price | Mix | Total
Prod
1 | 200 | 150 |  | 200 | 210
2 | 600 | 50 |  | 100 | 180
3 | 50 | 150 |  | 150 | 200
4 | 300 | 150 |  | 50 | 70
My Proposed | Volume
Volume/Price/Mix Calculation | (Act Vol - Bud Vol)*Weighted Average Bud Price
 | Price
 | (Act Price-Bud Price)*Act Vol
 | Mix
 | (Act Vol * Bud price)-(Bud Vol/total bud Vol*total Act Vol*Bud price)
 | Actual Vol | [NAME] |  | Act Price | [NAME] |  | Total Act | Total Bud | Total |  | Volume | Price | Mix | Total
Prod
1 | 200 | 150 |  | 200 | 210
2 | 600 | 50 |  | 100 | 180
3 | 50 | 150 |  | 150 | 200
4 | 300 | 150 |  | 50 | 70
# e.g. Product 1 was budgetd to sell 150/500 = 30% mix of total volume, instead it sold 200/1,150 = 17% mix of total volume - I would therefore assume that this would produce a negative mix variance for this grade.
Full Year
Full Year Budget |  |  | Full Year Actual
$/t | t | $ | $/t | t | $ | [NAME]
49.30573414952677 | 0 |  | 49.30573414952677 | 499.5352999979306
58.9081728743103 | 56334.44291687012 |  | 58.7531509470362 | 49232.9422519748
68.16157120359253 | 90383.61639308928 |  | 67.79947596465009 | 82234.36077080668
81.59565103751567 | 95207.04963421822 |  | 81.12699498457154 | 87092.68623951005
91.25596844687192 | 51386.68878555298 |  | 90.72014285887494 | 47120.2480324237
91.12960652592298 | 20447.6922672987 |  | 90.70563069008291 | 18351.30387076864
100.7691633154385 | 1224.308300197124 |  | 99.42420773876447 | 1296.367342070034
99.82784846089031 | 0 |  | 99.82784846089031 | 54.68003251756467
0 | 0 |  | 0 | 0
0 | 0 |  | 0 | 0
43.49999999999999 | 44548.87643814087 |  | 43.60345736848715 | 43846.65941472716
0 | 0 |  | 0 | 0
52 | 17076.31550693512 |  | 52 | 14182.02474304781
0 | 0 |  | 0 | 0
57 | 0 |  | 57 | 167.64
0 | 0 |  | 0 | 0
39.88641401931247 | 0 |  | 39.88641401931247 | 296.1208795125372
58.9081728743103 | 35087.32401863542 |  | 58.66378703997385 | 31617.37536355764
68.16157120359252 | 16775.06277279288 |  | 67.82610306998143 | 15156.11539390148
81.5956510375157 | 10838.47425994007 |  | 81.41166171435022 | 9339.17569733258
91.25596844687192 | 2170.779976061093 |  | 91.02458006540625 | 1879.378394791941
91.12960652592298 | 360.3229106289027 |  | 90.75819922412906 | 320.180624662086
100.7691633154385 | 61.14755458132836 |  | 100.3663038438843 | 54.2910007879648
106.4039622641509 | 3.609790656783067 |  | 104.7806980369129 | 3.983033276261609
58.22860439390515 | 0 |  | 58.22860439390515 | 840.71
0 | 0 |  | 0 | 0
43.49999999999999 | 118793.44 |  | 43.38846074050697 | 103723.4786440678
37.98 | 149950.5 |  | 37.98 | 124535.1610169491
52 | 919.7531723401524 |  | 51.99999999999999 | 763.8628041469063
61.5 | 43591.68554436337 |  | 61.50000000000001 | 36203.26426565771
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
AUD Price Volume Mix Analysis
YEE F13 vs Budget F13
Price | Volume | Mix | Total
 |  |  |  |  | Equals
 |  |  | 25831.8229613801
 |  |  | -82572.20328830188
 |  |  | -29527.70204821431
 |  |  | -69310.98532555143
 |  |  | -12660.64618539508
 |  |  | -1009.382431716144
 |  |  | -161.4169604998601
 |  |  | 105.5283199436892
 |  |  | 88758.99920543001
 |  |  | 0
 |  |  | -645970.590220375
 |  |  | -1358951.754949439
 |  |  | -8687.719478648141
 |  |  | -423068.4563890497
 |  |  | 0
 |  |  | 0