TM FIG. 6 j-600
^jjYear Time(Active Dynamic Time Series Members:H-T-0,Q-T-D.M-T-D)(Dynamic Cole)
-Q Qtr1 (+) (Dynamic Cole)
—□ Jan (+)
—□ Feb (+)
—□ Mar (+)
—0 Qtr2 (+) (Dynamic Calc) —0 Qtr3 (+) (Dynamic Calc) 604- —0 Qtr4 (+) (Dynamic Calc)
N^lProduct
-0 100 (+) (Alias: Colas)
—-O 100-10 (+) (Alias: Cola)
—□ 100-20 (+) (Alios: Diet Cola)
—□ 100-30 (+) (Alias: Caffeine Free Cola)
—El 200 (+) (Alias: Root Beer)
—0 300 (+) (Alias: Cream Soda)
—0 400 (+) (Alios: Fruit Soda)
—0 Diet (~) (Alias: Diet Drinks)
iMeasures Accounts (Label Only)
-£p Profit (+) (Dynamic Calc)
-0 Margin (+) (Dynamic Calc)
—□ Sales (+)
1—□ COGS (-) (Expense Reporting)
'—0 Total Expenses (-) (Dynamic Calc) (Expense Reporting)
—0 Inventory (~) (Label Only)
608-\ —^3 Ratios (~) (Label Only)
Nc3Market
-0 East (+) (UDAs: Major Market)
—□ New York (+) (UDAs: Major Market)
—O 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 Morket)
Scenario (Label Only)
—0 Actual (+)
—0 Budget (~)
—0 Voriance (~) (Dynamic Calc) (Two Pass Calc) @VAR(Actual, Budget);
'—0 Variance % (~) (Dynamic Calc) (Two Pass Calc) @ VARPER(Actual, Budget);
