Trading Performance Tracker Report & Charts
Help Print Report & Charts
 
 
12 Months to           2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005  
end Dec 2005           Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec Year  
  $000 $000 $000 $000 $000 $000 $000 $000 $000 $000 $000 $000 $000  
Sales - Group1:    
Projected 100.0 110.0 95.0 115.0 85.0 130.0 105.0 125.0 140.0 145.0 135.0 150.0 1,435.0  
Actual (year-to-date) ->> 90.0 100.0 80.0 110.0 90.0   470.0  
Combined actual + projected 90.0 100.0 80.0 110.0 90.0 130.0 105.0 125.0 140.0 145.0 135.0 150.0 1,400.0  
                            Projected Full-Year Variance: -2.4%  
Sales - Group2:    
Projected 33.5 57.0 70.4 77.1 70.4 83.8 93.8 103.9 110.6 107.2 120.6 115.0 1,043.3  
Actual (year-to-date) ->> 40.0 60.0 89.0 85.0 83.0   357.0  
Combined actual + projected 40.0 60.0 89.0 85.0 83.0 83.8 93.8 103.9 110.6 107.2 120.6 115.0 1,091.9  
                            Projected Full-Year Variance: 4.7%  
Sales - Group3:    
Projected 16.5 28.1 34.7 38.0 34.7 41.3 46.2 51.2 54.5 52.8 59.4 65.0 522.4  
Actual (year-to-date) ->>   15.0 21.0 35.0 26.0   97.0  
Combined actual + projected 16.5 15.0 21.0 35.0 26.0 41.3 46.2 51.2 54.5 52.8 59.4 65.0 483.9  
                            Projected Full-Year Variance: -7.4%  
Sales - Group4:    
Projected 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 120.0  
Actual (year-to-date) ->> 8.0 8.0 8.0 8.0 8.0   40.0  
Combined actual + projected 8.0 8.0 8.0 8.0 8.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 110.0  
                            Projected Full-Year Variance: -8.3%  
Sales - Group5:    
Projected 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 240.0  
Actual (year-to-date) ->> 17.0 17.0 17.0 17.0 17.0   85.0  
Combined actual + projected 17.0 17.0 17.0 17.0 17.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 225.0  
                            Projected Full-Year Variance: -6.3%  
Sales - Group6:    
Projected 56.6 51.1 56.6 54.8 56.6 54.8 56.6 56.6 54.8 56.6 54.8 56.6 666.7  
Actual (year-to-date) ->> 100.0 123.0 112.0 125.0 130.0   590.0  
Combined actual + projected 100.0 123.0 112.0 125.0 130.0 54.8 56.6 56.6 54.8 56.6 54.8 56.6 980.9  
                            Projected Full-Year Variance: 47.1%  
Total sales:    
Projected 236.6 276.2 286.7 314.9 276.7 339.9 331.6 366.7 389.9 391.6 399.8 416.6 4,027.4  
Actual (year-to-date) 255.0 323.0 327.0 380.0 354.0 1,639.0  
Combined actual + projected 271.5 323.0 327.0 380.0 354.0 339.9 331.6 366.7 389.9 391.6 399.8 416.6 4,291.7  
                            Projected Full-Year Variance: 6.6%  
Gross margin:    
Projected (32.5) (19.7) 117.5 123.2 113.9 109.2 131.3 129.9 151.4 151.8 144.9 152.4 1,273.3  
Actual (year-to-date) ->> 80.0 130.0 130.0 125.0 120.0   585.0  
Combined actual + projected 80.0 130.0 130.0 125.0 120.0 109.2 131.3 129.9 151.4 151.8 144.9 152.4 1,555.9  
                            Projected Full-Year Variance: 22.2%  
Overhead expenses:    
Projected 170.1 171.3 171.6 172.4 171.3 173.2 172.9 174.0 174.7 174.7 175.0 175.5 2,076.8  
Actual (year-to-date) ->> 160.0 160.0 160.0 160.0 160.0   800.0  
Combined actual + projected 160.0 160.0 160.0 160.0 160.0 173.2 172.9 174.0 174.7 174.7 175.0 175.5 2,020.1  
                            Projected Full-Year Variance: -2.7%  
Net income before taxes:    
Projected (229.5) (211.6) (52.2) (69.8) (91.0) (87.2) (67.2) (77.1) (46.7) (56.8) (74.6) 23.4 (1,040.3)  
Actual (year-to-date) ->> (90.0) (60.0) (30.0) 12.0 (40.0)   (208.0)  
Combined actual + projected (90.0) (60.0) (30.0) 12.0 (40.0) (87.2) (67.2) (77.1) (46.7) (56.8) (74.6) 23.4 (594.2)  
                            Projected Full-Year Variance:    
 
Trading Performance Tracker Charts  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Chart Values - These items will not be printed      
Sales - Group1:  
Months   Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Cumulative projected   100.0 210.0 305.0 420.0 505.0 635.0 740.0 865.0 1,005.0 1,150.0 1,285.0 1,435.0  
Cumulative actual+projected   90.0 190.0 270.0 380.0 470.0 600.0 705.0 830.0 970.0 1,115.0 1,250.0 1,400.0  
Sales - Group2:      
Months           Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Cumulative projected   33.5 90.5 160.9 238.0 308.4 392.2 486.0 589.9 700.5 807.7 928.3 1,043.3  
Cumulative actual+projected   40.0 100.0 189.0 274.0 357.0 440.8 534.6 638.5 749.1 856.3 976.9 1,091.9  
Sales - Group3:      
Months           Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Cumulative projected   16.5 44.6 79.3 117.3 152.0 193.3 239.5 290.7 345.2 398.0 457.4 522.4  
Cumulative actual+projected   16.5 31.5 52.5 87.5 113.5 154.8 201.0 252.2 306.7 359.5 418.9 483.9  
Sales - Group4:      
Months           Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Cumulative projected   10.0 20.0 30.0 40.0 50.0 60.0 70.0 80.0 90.0 100.0 110.0 120.0  
Cumulative actual+projected   8.0 16.0 24.0 32.0 40.0 50.0 60.0 70.0 80.0 90.0 100.0 110.0  
Sales - Group5:      
Months   Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Cumulative projected   20.0 40.0 60.0 80.0 100.0 120.0 140.0 160.0 180.0 200.0 220.0 240.0  
Cumulative actual+projected   17.0 34.0 51.0 68.0 85.0 105.0 125.0 145.0 165.0 185.0 205.0 225.0  
Sales - Group6:      
Months   Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Cumulative projected   56.6 107.8 164.4 219.2 275.8 330.6 387.2 443.8 498.6 555.3 610.0 666.7  
Cumulative actual+projected   100.0 223.0 335.0 460.0 590.0 644.8 701.4 758.0 812.8 869.5 924.2 980.9  
Cumulative Actual+Projected      
Months           Jan Feb Mar  Apr May Jun Jul Aug Sep Oct Nov Dec  
Sales   271.5 594.5 921.5 1,301.5 1,655.5 1,995.4 2,327.0 2,693.7 3,083.6 3,475.3 3,875.0 4,291.7  
Gross Margin   80.0 210.0 340.0 465.0 585.0 694.2 825.5 955.4 1,106.8 1,258.6 1,403.5 1,555.9  
Overhead Expenses   160.0 320.0 480.0 640.0 800.0 973.2 1,146.1 1,320.1 1,494.8 1,669.6 1,844.6 2,020.1  
Net Income   (90.0) (150.0) (180.0) (168.0) (208.0) (295.2) (362.4) (439.6) (486.3) (543.0) (617.6) (594.2)