Proiect 14 Ianuarie 2013

Fabrica Craiova

DataDenumire produs Pret productie Sum of Pret desfacerSum of Productie Sum of Valoare Balerini 108.498 1500###

39 108.498 1500###Bocanci barbat 347.75 1500###

125 347.75 1500###Bocanci copii 344.968 1500###

124 344.968 1500###Bocanci dama 378.352 1500###

136 378.352 1500###Cizme barbat 230.906 1500###

83 230.906 1500###Cizme copii 155.792 1500###

56 155.792 1500###Cizme dama 442.338 1500###

159 442.338 1500###Cizme dama cu talpa ortopedica 344.968 1500###

124 344.968 1500###Cizme dama cu toc 414.518 1500###

149 414.518 1500###Ghete barbat 386.698 1500###

139 386.698 1500###Ghete copii 275.418 1500###

99 275.418 1500###Ghete cu platforma 216.996 1500###

78 216.996 1500###Ghete cu talpa ortopedica 475.722 1500###

171 475.722 1500###Ghete dama 428.428 1500###

154 428.428 1500###Ghete dama cu toc 628.732 1500###

226 628.732 1500###Pantofi barbat 584.22 1500###

210 584.22 1500###Pantofi copii 609.258 1500###

219 609.258 1500###Pantofi dama 628.732 1500###

226 628.732 1500###Pantofi dama cu platforma 831.818 1500###

299 831.818 1500###Pantofi dama cu toc 603.694 1500###

217 603.694 1500###Pantofi dama talpa ortopedica 742.794 1500###

267 742.794 1500###Pantofi sport barbat 573.092 1500###

206 573.092 1500###

Pantofi sport copii 470.158 1500###169 470.158 1500###

Pantofi sport dama 372.788 1500###134 372.788 1500###

Papuci barbat 155.792 1500###56 155.792 1500###

Papuci dama 189.176 1500###68 189.176 1500###

Saboti dama 497.978 1500###179 497.978 1500###

Sandale barbat 342.186 1500###123 342.186 1500###

Sandale copii 275.418 1500###99 275.418 1500###

Sandale dama 612.04 1500###220 612.04 1500###

Tenisi copii 331.058 1500###119 331.058 1500###

Tenisi dama 325.494 1500###117 325.494 1500###

Tenisi darbat 314.366 1680###113 314.366 1680###

Total Result 13640.146 49680###

Sum of Valoare

Fabrica - all -

DataDenumire produs Min of Pret desfacere Max of Pret desfacere Balerini 69.55 108.498Bocanci barbat 275.418 347.75Bocanci copii 278.2 433.992Bocanci dama 344.968 378.352Cizme barbat 208.65 275.418Cizme copii 139.1 191.958Cizme dama 417.3 589.784Cizme dama cu talpa ortopedica 344.968 598.13Cizme dama cu toc 403.39 470.158Ghete barbat 378.352 392.262Ghete copii 239.252 275.418Ghete cu platforma 216.996 275.418Ghete cu talpa ortopedica 361.66 475.722Ghete dama 428.428 442.338Ghete dama cu toc 612.04 628.732Pantofi barbat 336.622 584.22Pantofi copii 339.404 609.258Pantofi dama 584.22 628.732Pantofi dama cu platforma 620.386 831.818Pantofi dama cu toc 598.13 606.476Pantofi dama talpa ortopedica 687.154 742.794Pantofi sport barbat 278.2 573.092Pantofi sport copii 319.93 470.158Pantofi sport dama 342.186 372.788Papuci barbat 97.37 155.792Papuci dama 100.152 189.176Saboti dama 433.992 497.978Sandale barbat 272.636 342.186Sandale copii 255.944 275.418Sandale dama 612.04 625.95Tenisi copii 314.366 331.058Tenisi dama 306.02 325.494Tenisi darbat 308.802 319.93Total Result 69.55 831.818

69.55 275.418 278.2344.96

8208.65

139.1

417.3344.96

8403.39378.35

2239.25

2216.99

6361.66

428.428

612.04336.62

2

339.404 584.22620.386598.13

687.154

278.2

319.93

342.186

97.37

100.152

433.992

272.636

255.944

612.04314.36

6

306.02308.802

Min of Pret desfacere Denumire produs Balerini Bocanci barbatBocanci copii Bocanci dama Cizme barbatCizme copii Cizme dama Cizme dama cu talpa ortopedicaCizme dama cu toc Ghete barbat Ghete copiiGhete cu platforma Ghete cu talpa ortopedica Ghete dama Ghete dama cu toc Pantofi barbat Pantofi copiiPantofi dama Pantofi dama cu platforma Pantofi dama cu tocPantofi dama talpa ortopedica Pantofi sport barbat Pantofi sport copiiPantofi sport dama Papuci barbat Papuci damaSaboti dama Sandale barbat Sandale copiiSandale dama Tenisi copii Tenisi damaTenisi darbat

nr.crit Fabrica Denumire produs Pret productie Cheltuieli de productie1 Bucuresti Balerini 25 152 Brasov Balerini 28 16.85 Bucuresti Bocanci barbat 125 756 Brasov Bocanci barbat 121 72.69 Bucuresti Bocanci copii 100 60

10 Brasov Bocanci copii 109 65.413 Bucuresti Bocanci dama 130 7814 Brasov Bocanci dama 135 8117 Bucuresti Cizme barbat 75 4518 Brasov Cizme barbat 80 4821 Bucuresti Cizme copii 50 3022 Brasov Cizme copii 51 30.625 Bucuresti Cizme dama 150 9026 Brasov Cizme dama 154 92.429 Bucuresti Cizme dama cu talpa ortopedica 125 7530 Brasov Cizme dama cu talpa ortopedica 126 75.633 Bucuresti Cizme dama cu toc 145 8734 Brasov Cizme dama cu toc 149 89.437 Bucuresti Ghete barbat 136 81.638 Brasov Ghete barbat 139 83.441 Bucuresti Ghete copii 86 51.642 Brasov Ghete copii 88 52.845 Bucuresti Ghete cu platforma 99 59.446 Brasov Ghete cu platforma 97 58.249 Bucuresti Ghete cu talpa ortopedica 132 79.250 Brasov Ghete cu talpa ortopedica 131 78.653 Bucuresti Ghete dama 157 94.254 Brasov Ghete dama 158 94.857 Bucuresti Ghete dama cu toc 224 134.458 Brasov Ghete dama cu toc 220 13261 Bucuresti Pantofi barbat 124 74.462 Brasov Pantofi barbat 121 72.665 Bucuresti Pantofi copii 122 73.266 Brasov Pantofi copii 129 77.469 Bucuresti Pantofi dama 210 12670 Brasov Pantofi dama 215 12973 Bucuresti Pantofi dama cu platforma 223 133.874 Brasov Pantofi dama cu platforma 230 13877 Bucuresti Pantofi dama cu toc 215 12978 Brasov Pantofi dama cu toc 217 130.281 Bucuresti Pantofi dama talpa ortopedica 247 148.282 Brasov Pantofi dama talpa ortopedica 254 152.4

85 Bucuresti Pantofi sport barbat 100 6086 Brasov Pantofi sport barbat 203 121.889 Bucuresti Pantofi sport copii 115 6990 Brasov Pantofi sport copii 116 69.693 Bucuresti Pantofi sport dama 123 73.894 Brasov Pantofi sport dama 129 77.497 Bucuresti Papuci barbat 35 2198 Brasov Papuci barbat 45 27

101 Bucuresti Papuci dama 36 21.6102 Brasov Papuci dama 55 33105 Bucuresti Saboti dama 156 93.6106 Brasov Saboti dama 178 106.8109 Bucuresti Sandale barbat 98 58.8110 Brasov Sandale barbat 100 60113 Bucuresti Sandale copii 94 56.4114 Brasov Sandale copii 92 55.2117 Bucuresti Sandale dama 225 135118 Brasov Sandale dama 221 132.6121 Bucuresti Tenisi copii 113 67.8122 Brasov Tenisi copii 117 70.2125 Bucuresti Tenisi dama 112 67.2126 Brasov Tenisi dama 110 66129 Bucuresti Tenisi darbat 115 69130 Brasov Tenisi darbat 111 66.6

IF Fabrica Nr. Articole fabricate Vanzare Targhetcountif Bucuresti 49500 39600 32000sunif Iasi 49500 34650 32000sunif Brasov 49500 32175 32000sunif Craiova 49680 22356 32000

MEDIA VANZARILOR 29727

Cheltuieli de transport Cheltuieli de personal T.V.A. Ados comercial Pret desfacere Productie5.5 8.75 6 9.3 69.55 1500

6.16 9.8 6.72 10.416 77.896 150027.5 43.75 30 46.5 347.75 1500

26.62 42.35 29.04 45.012 336.622 150022 35 24 37.2 278.2 1500

23.98 38.15 26.16 40.548 303.238 150028.6 45.5 31.2 48.36 361.66 150029.7 47.25 32.4 50.22 375.57 150016.5 26.25 18 27.9 208.65 150017.6 28 19.2 29.76 222.56 1500

11 17.5 12 18.6 139.1 150011.22 17.85 12.24 18.972 141.882 1500

33 52.5 36 55.8 417.3 150033.88 53.9 36.96 57.288 428.428 1500

27.5 43.75 30 46.5 347.75 150027.72 44.1 30.24 46.872 350.532 1500

31.9 50.75 34.8 53.94 403.39 150032.78 52.15 35.76 55.428 414.518 150029.92 47.6 32.64 50.592 378.352 150030.58 48.65 33.36 51.708 386.698 150018.92 30.1 20.64 31.992 239.252 150019.36 30.8 21.12 32.736 244.816 150021.78 34.65 23.76 36.828 275.418 150021.34 33.95 23.28 36.084 269.854 150029.04 46.2 31.68 49.104 367.224 150028.82 45.85 31.44 48.732 364.442 150034.54 54.95 37.68 58.404 436.774 150034.76 55.3 37.92 58.776 439.556 150049.28 78.4 53.76 83.328 623.168 1500

48.4 77 52.8 81.84 612.04 150027.28 43.4 29.76 46.128 344.968 150026.62 42.35 29.04 45.012 336.622 150026.84 42.7 29.28 45.384 339.404 150028.38 45.15 30.96 47.988 358.878 1500

46.2 73.5 50.4 78.12 584.22 150047.3 75.25 51.6 79.98 598.13 1500

49.06 78.05 53.52 82.956 620.386 150050.6 80.5 55.2 85.56 639.86 150047.3 75.25 51.6 79.98 598.13 1500

47.74 75.95 52.08 80.724 603.694 150054.34 86.45 59.28 91.884 687.154 150055.88 88.9 60.96 94.488 706.628 1500

22 35 24 37.2 278.2 150044.66 71.05 48.72 75.516 564.746 1500

25.3 40.25 27.6 42.78 319.93 150025.52 40.6 27.84 43.152 322.712 150027.06 43.05 29.52 45.756 342.186 150028.38 45.15 30.96 47.988 358.878 1500

7.7 12.25 8.4 13.02 97.37 15009.9 15.75 10.8 16.74 125.19 1500

7.92 12.6 8.64 13.392 100.152 150012.1 19.25 13.2 20.46 153.01 1500

34.32 54.6 37.44 58.032 433.992 150039.16 62.3 42.72 66.216 495.196 150021.56 34.3 23.52 36.456 272.636 1500

22 35 24 37.2 278.2 150020.68 32.9 22.56 34.968 261.508 150020.24 32.2 22.08 34.224 255.944 1500

49.5 78.75 54 83.7 625.95 150048.62 77.35 53.04 82.212 614.822 150024.86 39.55 27.12 42.036 314.366 150025.74 40.95 28.08 43.524 325.494 150024.64 39.2 26.88 41.664 311.584 1500

24.2 38.5 26.4 40.92 306.02 150025.3 40.25 27.6 42.78 319.93 1500

24.42 38.85 26.64 41.292 308.802 1500

Prima Valoare Prima Calificativ Lookup table 500.00 lei 500.00 lei B 0 E 500.00 lei 500.00 lei C 25000 D 500.00 lei 500.00 lei C 30000 C 500.00 lei - lei E 35000 B

D 40000 A

Valoare 104325116844521625504933417300454857542490563355312975333840208650212823625950642642521625525798605085621777567528580047358878367224413127404781550836546663655161659334934752918060517452504933509106538317876330897195930579959790897195905541

10307311059942

417300847119479895484068513279538317146055187785150228229515650988742794408954417300392262383916938925922233471549488241467376459030479895463203

Proiect 14 Ianuarie 2013

Documents

Transcript of Proiect 14 Ianuarie 2013