CP BUDGET:OTB (XLSX) - Fichier XLS

Fichier partagé
CP BUDGET:OTB (XLSX)

Aperçu texte

                 
 ANNUAL BUDGET                
                 
 TOTAL BUDGET 1Y   "133 694 €"             
 TOTAL OTB 1Y (15% OF TOTAL)   "20 054.10 €"             
                 
 Q1 BUDGET - 15% :   "3 008.12 €"             
 ORDER 1 - 30% :   902.43 €             
 ORDER 2 - 70% :   "2 105.68 €"             
                 
 Q2 - 30% :   "6 016.23 €"             
 Q3 - 45% :   "9 024.35 €"             
 Q4 - 10% :   "2 005.41 €"             
                 
 "Q1 OPEN TO BUY : APRIL/MAY/JUNE (IN STORE) - 15% OF ANNUAL BUDGET OF 20 054 10€"                
                 
 OTB TOTAL €                OTB VALUE  % MIX  PER STORE OTB UNITS  AV SP  FPR ROS  TOTAL FPR LIFE CYCLE  FPR SELL THRU  UNITS DEPTH OF BUY  TOTAL NB OF OPTIONS
                 
 "3 008.12 €"  100%  52.77  57 €  3.8  9  70.92  49  1
                 
 Q1 : DELIVERY 1 - 25TH OF MARCH - COLLECTION LAUNCH - 30% OF THE QUARTERLY PLAN                
                 
 OTB TOTAL €                OTB VALUE  % MIX  PER STORE OTB UNITS  AV SP  FPR ROS  FPR LIFE CYCLE  FPR SELL THRU  UNITS DEPTH OF BUY  TOTAL NB OF OPTIONS
                 
 902.43 €  100%  15.83  57 €  3.8  11  70.92  29  1
                 
 Q1 : DELIVERY 2 - 1ST OF MAY - 70% OF THE QUARTERLY PLAN                
                 
 OTB TOTAL €                OTB VALUE  % MIX  PER STORE OTB UNITS  AV SP  FPR ROS  FPR LIFE CYCLE  FPR SELL THRU  UNITS DEPTH OF BUY  TOTAL NB OF OPTIONS
                 
 "2 105.68 €"  100%  36.94  57 €  3.8  7  70.92  38  1
                 
 "Q2 OPEN TO BUY : JULY/AUGUST/SEPTEMBER (IN STORE) - 30% OF ANNUAL BUDGET OF 20 054 10€"                
                 
 OTB TOTAL €                OTB VALUE  % MIX  PER STORE OTB UNITS  AV SP  FPR ROS  TOTAL FPR LIFE CYCLE  FPR SELL THRU  UNITS DEPTH OF BUY  TOTAL NB OF OPTIONS
                 
 "6 016.23 €"  100%  105.55  57 €  3.8  6  70.92  33  3
                 
 "Q3 OPEN TO BUY : OCTOBER/NOVEMBER/DECEMBER (IN STORE) - 45% OF ANNUAL BUDGET OF 20 054 10€"                
                 
 OTB TOTAL €                OTB VALUE  % MIX  PER STORE OTB UNITS  AV SP  FPR ROS  TOTAL FPR LIFE CYCLE  FPR SELL THRU  UNITS DEPTH OF BUY  TOTAL NB OF OPTIONS
                 
 "9 024.35 €"  100%  158.32  57 €  3.8  12  70.92  65  2
                 
 "Q4 OPEN TO BUY : JANUARY/FEBRUARY/MARCH (IN STORE) - 10% OF ANNUAL BUDGET OF 20 054 10€"                
                 
 OTB TOTAL €                OTB VALUE  % MIX  PER STORE OTB UNITS  AV SP  FPR ROS  TOTAL FPR LIFE CYCLE  FPR SELL THRU  UNITS DEPTH OF BUY  TOTAL NB OF OPTIONS
                 
 "2 005.41 €"  100%  35.18  57 €  3.8  6  70.92  33  1
CP BUDGET:OTB (XLSX) - Fichier XLS

CP BUDGET:OTB (XLSX)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent
