602 FIG. 6 sm
T^lYear Time(Active Dynamic Time Series Members:H-T-D,Q-T-D,M-T-D)(Dynamic Cole) -0 Otrl (+) (Dynamic Cole) —□ Jan (+) —□ Feb (+) '—□ Mar (+) —0 Qtr2 (+) (Dynamic Calc) —0 Qtr3 (+) (Dynamic Calc) £04 —0 Qtr4 (+) (Dynamic Calc)
^0Product
-Q 100 (+) (Alias: Colas)
—□ 100-10 (+) (Alias: Colo)
—□ 100-20 (+) (Alias: Diet Cola)
'—□ 100-30 (+) (Alios: Caffeine Free Cola)
—0 200 (+) (Alias: Root Beer)
—0 300 (+) (Alias: Cream Soda)
—0 400 (+) (Alias: Fruit Soda)
—0 Diet (~) (Alias: Diet Drinks)
Measures Accounts (Label Only)
£3 Profit (+) (Dynamic Calc)
-Q Margin (+) (Dynamic Calc)
—□ Sales (+)
'—□ COGS (-) (Expense Reporting)
'—0 Total Expenses (-) (Dynamic Calc) (Expense Reporting)
—0 Inventory (~) (Label Only)
—0 Ratios (~) (Label Only)
N^Morket
-0 East (+) (UDAs: Major Market)
—□ New York (+) (UDAs: Major Market)
—□ Massachusetts (+) (UDAs: Major Market)
—□ Florida (+) (UDAs: Major Market)
—□ Connecticut (+) (UDAs: Small Market)
—□ New Hampshire (+) (UDAs: Small Market)
—0 West (+)
—0 South (+) (UDAs: Small Market)
—0 Central (+) (UDAs: Major Market)
N3 Scenario (Label Only)
—Q Actual (+)
—Q Budget (~)
—0 Varionce (~) (Dynomic Calc) (Two Pass Calc) @VAR(Actual, Budget);
'—E! Variance % (~) (Dynamic Cole) (Two Pass Cole) 9 VARPER(Actuol, Budget);
