Extras din referat
Scenario Summary
Furnizor1 Furnizor2 Furnizor3
Changing Cells:
Pret_M1 200 230 220
Pret_M2 300 320 280
Pret_M3 150 160 170
Pret_M4 400 350 380
Result Cells:
Chelt_mat_unitare 129650 133760 127670
Chelt_materiale-Qmax 28412500 29279500 27896500
Chelt_materiale-Qmin 17980000 18509500 17659000
Ch_Qmax_cu_discount 21309375 20495650 20922375
Ch_Qmin_cu_discount 14384000 13882125 14127200
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
P1 P2 P3 P4 Furnizorul 1 Pret furnizor ales:fz 2
M1 10 20 5 15 200 230
M2 40 120 10 60 300 320
M3 20 50 6 75 150 160
M4 10 15 20 25 400 350
Total sume
Cheltuieli materiale unitare 21000 53500 12900 42250 129650
Ch materiale Qmax 4830000 13375000 3870000 6337500 28412500
Ch materiale Qmin 3150000 8025000 2580000 4225000 17980000
Cheltuieli Qmax discount 21309375
Cheltuieli Qmin discount 14384000
Se va alege furnizorul numarul 2 pentru a minimiza costurile.
Cheltuielile materiale unitare sunt: P1 P2 P3 P4
21800 56250 12310 43400
Scenario Summary
Current Values: Scenariu Pmax si qmin Scenariu Pmediu si Qmediu
Changing Cells:
P1_cantitate 230 150 190
P2_cantitate 250 150 200
P3_cantitate 300 200 250
P4-cantitate 150 100 125
P1_pret 28000 30000 29000
P2_pret 60000 62000 61000
P3_pret 18000 20000 19000
P4-_pret 50000 52000 51000
Result Cells:
CheltuieliTotale 27415650 19302125 22956150
Rezultat 6924350 3697875 5878850
RataRentabilitatii 20,1641% 16,0777% 20,3879%
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
Conținut arhivă zip
- Proiect SIAD.xlsx