CP 6 MONTHS SALES (XLSX) - Fichier XLS

Fichier partagé
CP 6 MONTHS SALES (XLSX)

Aperçu texte

                 
 DELIVERY 1 - APRIL > JUNE            QUANTITIES    
                 
 PRODUCTS QUANTITIES RETAIL PRICES WITHOUT VAT TOTAL RETAIL WITHOUT VAT PRICES VAT TOTAL RETAIL WITH VAT WHOLESALE PRICE TOTAL WHOLESALE FIRST COST TOTAL FIRST COST   FIRST DELIVERY  SECOND DELIVERY  TOTAL OVER 6 MONTHS
 Outerwear1denim 25  133 €  " 3 325 € "  159.60 €  " 3 990.00 € " 49.26 € "1 231.48 €" 24.63 € 615.74 €   1345  385  1730
 Outerwear1solid 25  118 €  " 2 950 € "  141.60 €  " 3 540.00 € " 43.70 € "1 092.59 €" 21.85 € 546.30 €       
 Outerwear2 50  120 €  " 6 000 € "  144 €  " 7 200.00 € " 44.44 € "2 222.22 €" 22.22 € "1 111.11 €"       
 Outerwear3 50  140 €  " 7 000 € "  168 €  " 8 400.00 € " 51.85 € "2 592.59 €" 25.93 € "1 296.30 €"       
 Knit1 75  56 €  " 4 200 € "  67.20 €  " 5 040.00 € " 20.74 € "1 555.56 €" 10.37 € 777.78 €   WHOLESALE TURNOVER    
 Knit2 solid 38  30 €  " 1 140 € "  36 €  " 1 368.00 € " 11.11 € 422.22 € 5.56 € 211.11 €       
 Knit2 liberty 37  35 €  " 1 295 € "  42 €  " 1 554.00 € " 12.96 € 479.63 € 6.48 € 239.81 €       
 Knit3 75  47 €  " 3 525 € "  56.40 €  " 4 230.00 € " 17.41 € "1 305.56 €" 8.70 € 652.78 €   FIRST DELIVERY  SECOND DELIVERY  TOTAL OVER 6 MONTHS
 Top2 silk 25  65 €  " 1 625 € "  78 €  " 1 950.00 € " 24.07 € 601.85 € 12.04 € 300.93 €       
 Top2 solid 25  30 €   750 €   36 €   900.00 €  11.11 € 277.78 € 5.56 € 138.89 €       
 Top2 liberty 25  52 €  " 1 300 € "  62.40 €  " 1 560.00 € " 19.26 € 481.48 € 9.63 € 240.74 €       
 Top3 silk 37  65 €  " 2 405 € "  78 €  " 2 886.00 € " 24.07 € 890.74 € 12.04 € 445.37 €   "31 031.48 €"  "6 481.11 €"  "37 512.59 €"
 Top3 38  30 €  " 1 140 € "  36 €  " 1 368.00 € " 11.11 € 422.22 € 5.56 € 211.11 €       
 Dress1 75  60 €  " 4 500 € "  72 €  " 5 400.00 € " 22.22 € "1 666.67 €" 11.11 € 833.33 €       
 Dress2 75  86 €  " 6 450 € "  103.20 €  " 7 740.00 € " 31.85 € "2 388.89 €" 15.93 € "1 194.44 €"       
 Dress3 75  75 €  " 5 625 € "  90 €  " 6 750.00 € " 27.78 € "2 083.33 €" 13.89 € "1 041.67 €"       
 All1 denim 16  45 €   720 €   54 €   864.00 €  16.67 € 266.67 € 8.33 € 133.33 €   RETAIL TURNOVER WITHOUT VAT    
 All1 liberty 16  64 €  " 1 024 € "  76.80 €  " 1 228.80 € " 23.70 € 379.26 € 11.85 € 189.63 €       
 All1 solid 18  53 €   954 €   63.60 €  " 1 144.80 € " 19.63 € 353.33 € 9.81 € 176.67 €       
 All3 denim 16  45 €   720 €  54 €  864.00 €  16.67 € 266.67 € 8.33 € 133.33 €   FIRST DELIVERY  SECOND DELIVERY  TOTAL OVER 6 MONTHS
 All3 solid 18  53 €   954 €  63.60 € " 1 144.80 € " 19.63 € 353.33 € 9.81 € 176.67 €       
 All3 liberty 16  64 €  " 1 024 € " 76.80 € " 1 228.80 € " 23.70 € 379.26 € 11.85 € 189.63 €       
 Pants1 denim 40  48 €  " 1 920 € " 57.60 € " 2 304.00 € " 17.78 € 711.11 € 8.89 € 355.56 €       
 Pants1 liberty 40  66 €  " 2 640 € " 79.20 € " 3 168.00 € " 24.44 € 977.78 € 12.22 € 488.89 €   "83 785.00 €"  "17 499.00 €"  "101 284.00 €"
 Pants3denim 27  50 €  " 1 350 € "  60 €  " 1 620.00 € " 18.52 € 500.00 € 9.26 € 250.00 €       
 Pants3solid+liberty 25  52 €  " 1 300 € "  62.40 €  " 1 560.00 € " 19.26 € 481.48 € 9.63 € 240.74 €       
 Pants3solid 28  43 €  " 1 204 € "  51.60 €  " 1 444.80 € " 15.93 € 445.93 € 7.96 € 222.96 €       
 Skirt1 40  43 €  " 1 720 € "  51.60 €  " 2 064.00 € " 15.93 € 637.04 € 7.96 € 318.52 €       
 Skirt1 denim 40  52 €  " 2 080 € "  62.40 €  " 2 496.00 € " 19.26 € 770.37 € 9.63 € 385.19 €   RETAIL TURNOVER WITH VAT    
 Skirt2solid 30  35 €  " 1 050 € "  42 €  " 1 260.00 € " 12.96 € 388.89 € 6.48 € 194.44 €       
 Skirt2liberty 30  66 €  " 1 980 € "  79.20 €  " 2 376.00 € " 24.44 € 733.33 € 12.22 € 366.67 €       
 Skirt3denim 30  52 €  " 1 560 € "  62.40 €  " 1 872.00 € " 19.26 € 577.78 € 9.63 € 288.89 €   FIRST DELIVERY  SECOND DELIVERY  TOTAL OVER 6 MONTHS
 Skirt3solid+liberty 30  60 €  " 1 800 € "  72 €  " 2 160.00 € " 22.22 € 666.67 € 11.11 € 333.33 €       
 Shorts2 60  53 €  " 3 180 € " 63.60 € " 3 816.00 € " 19.63 € "1 177.78 €" 9.81 € 588.89 €       
 Shorts3denim 25  40 €  " 1 000 € " 48 € " 1 200.00 € " 14.81 € 370.37 € 7.41 € 185.19 €       
 Shorts3solid 25  35 €   875 €  42 € " 1 050.00 € " 12.96 € 324.07 € 6.48 € 162.04 €   "100 542.00 €"  "20 998.80 €"  "121 540.80 €"
 Shorts3liberty 25  60 €  " 1 500 € " 72 € " 1 800.00 € " 22.22 € 555.56 € 11.11 € 277.78 €       
 TOTAL 1345  " 83 785 € "  " 100 542.00 € "  "31 031.48 €"  "15 515.74 €"       
                 
             FIRSTS COSTS    
                 
 DELIVERY 2 - JUNE > SEPTEMBER                
             FIRST DELIVERY  SECOND DELIVERY  TOTAL OVER 6 MONTHS
                 
 PRODUCTS QUANTITIES PRICES WITHOUT VAT TOTAL RETAIL WITHOUT VAT PRICES VAT TOTAL RETAIL WITH VAT WHOLESALE PRICES WHOLESALE TOTAL FIRST COSTS TOTAL FIRST COSTS       
 Swim1solid 30  29 €   870 €   34.80 €  " 1 044 € "  10.74 €   322.22 €   5.37 €   161.11 €        
 Swim1liberty 30  39 €  " 1 170 € "  46.80 €  " 1 404 € "  14.44 €   433.33 €   7.22 €   216.67 €    "15 515.74 €"  "3 240.56 €"  "18 756.30 €"
 Swim2solid 30  29 €   870 €   35 €  " 1 044 € "  10.74 €   322.22 €   5.37 €   161.11 €        
 Swim2liberty 30  39 €  " 1 170 € "  47 €  " 1 404 € "  14.44 €   433.33 €   7.22 €   216.67 €        
 Hat1 20  31 €   620 €   37.20 €   744 €   11.48 €   229.63 €   5.74 €   114.81 €        
 Shorts1 solid 30  35 €  " 1 050 € "  42 €  " 1 260 € "  12.96 €   388.89 €   6.48 €   194.44 €        
 Shorts1 denim 30  46 €  " 1 380 € "  55.20 €  " 1 656 € "  17.04 €   511.11 €   8.52 €   255.56 €        
 Pants2 60  60 €  " 3 600 € "  72 €  " 4 320 € "  22.22 €  " 1 333.33 € "  11.11 €   666.67 €        
 All2 liberty 25  55 €  " 1 375 € "  66 €  " 1 650 € "  20.37 €   509.26 €   10.19 €   254.63 €        
 All2 solid 25  40 €  " 1 000 € "  48 €  " 1 200 € "  14.81 €   370.37 €   7.41 €   185.19 €        
 Top1 silk 38  65 €  " 2 470 € "  78 €  " 2 964 € "  24.07 €   914.81 €   12.04 €   457.41 €        
 Top1 liberty 37  52 €  " 1 924 € "  62 €  " 2 308.80 € "  19.26 €   712.59 €   9.63 €   356.30 €        
 TOTAL 385  " 17 499 € "  " 20 999 € "  " 6 481.11 € "  " 3 240.56 € "
CP 6 MONTHS SALES (XLSX) - Fichier XLS

CP 6 MONTHS SALES (XLSX)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent
