Sales Analysis Example 5 Example

RJLasap             Sales Analysis Report by PRODUCT                     Printed 30/09/08 17:10 By Administrator            Page : 1
Sales Analysis By GROUP  From  01/09/08 To 30/09/08   Ordered By Profit % Descending
CODE     NAME/DESC                     SALES  DISCOUNT  NET SALES   RETURNS        NET      COST     PROFIT  PROFIT% RETRNS% O/L    DEL   RET    RET% O/L    NET
----     ---------                ---------- --------- ---------- --------- ---------- --------- ----------  ------- ------- --- ------ ----- ------- --- ------
ROLL     ROLL                    
BLT101   BACON LETTUCE TOMATO ROL    632.250    17.483    614.768     0.000    614.768   172.138    442.630   72.000   0.000        417     0   0.000        417
CHI102   CORONATION CHICKEN ROLL     633.600    17.982    615.618     0.000    615.618   211.961    403.657   65.569   0.000        417     0   0.000        417
CHE101   CHEESE AND, ONION ROLL    18289.490  5088.122  13201.368     0.000  13201.368  5252.238   7949.130   60.214   0.000      11062     0   0.000      11062
CHI104   CHICKEN AND PESTO ROLL      242.700    79.326    163.374     0.000    163.374    66.194     97.180   59.483   0.000        131     0   0.000        131
CHI101   CHICKEN SALAD ROLL          120.900    43.368     77.532     0.000     77.532    32.271     45.261   58.377   0.000         62     0   0.000         62
CHI103   CHICKEN CAESER ROLL          49.950    18.482     31.469     0.000     31.469    13.433     18.036   57.314   0.000         27     0   0.000         27
CHE105   CHEESE SALAD ROLL          2147.840   550.781   1597.059     0.000   1597.059   707.290    889.770   55.713   0.000       1356     0   0.000       1356
BEE101   BEEF AND HORSERADISH ROL   3659.465   819.767   2839.698     0.000   2839.698  1427.228   1412.470   49.740   0.000       1990     0   0.000       1990
EGG101   EGG MAYO ROLL                48.600    17.982     30.618     0.000     30.618    16.135     14.483   47.302   0.000         27     0   0.000         27
PRA101   PRAWN COCKTAIL ROLL         714.600    46.692    667.908     0.000    667.908   580.617     87.291   13.069   0.000        482     0   0.000        482
TUN101   TUNA MAYONNAISE ROLL         47.250    17.483     29.768     0.000     29.768    32.642     -2.874   -9.655   0.000         47     0   0.000         47
                                  ---------- --------- ---------- --------- ---------- --------- ----------  ------- -------     ------ ----- -------     ------
                                   26586.645  6717.467  19869.178     0.000  19869.178  8512.146  11357.033   57.159   0.000      16018     0   0.000      16018
                                  ---------- --------- ---------- --------- ---------- --------- ----------  ------- -------     ------ ----- -------     ------
   GRAND TOTAL                     26586.645  6717.467  19869.178     0.000  19869.178  8512.146  11357.033   57.159   0.000      16018     0   0.000      16018