Meniu Complet

10
Pranz Specificare UM CMZ T Stoc Curent Cant Val Piept de pui Kg 0.300 65 2 15 15 585 8775 3 15 Cartofi Kg 0.250 65 30 1 0.6 487.5 292.5 3 15 Ulei L 0.020 65 30 1 3.5 39 136.5 3 15 Condimente Kg 0.005 65 30 1 13 9.75 126.75 3 15 Rosii Kg 0.050 65 5 6 5 97.5 487.5 3 15 Castraveti Kg 0.050 65 5 6 4 97.5 390 3 15 Ceapa Kg 0.030 65 30 1 1 58.5 58.5 3 15 Ridichi Kg 0.030 65 5 6 2 58.5 117 3 15 Lamaie Kg 0.010 65 30 1 1.5 19.5 29.25 3 15 Chifle Buc 2.000 65 30 1 0.5 3900 1950 3 15 Carne Vita Kg 0.200 65 2 15 17 390 6630 3 15 Ardei gras multicolo Kg 0.010 65 5 6 8 19.5 156 3 15 Ulei L 0.020 65 30 1 3.5 39 136.5 3 15 Condimente Kg 0.005 65 30 1 13 9.75 126.75 3 15 Făină Kg 0.005 65 30 1 1.5 9.75 14.625 3 15 Morcov Kg 0.015 65 5 6 1 29.25 29.25 3 15 Ceapa Kg 0.030 65 30 1 1 58.5 58.5 3 15 Smântână kg 0.025 65 3 10 10 48.75 487.5 3 15 Lamaie Kg 0.010 65 30 1 4 19.5 78 3 15 Chifle Buc 2.000 65 30 1 0.5 3900 1950 3 15 Ţelină kg 0.020 65 30 1 4 39 156 3 15 Capsuni kg 0.120 65 3 10 13 234 3042 3 15 Smantana Kg 0.030 65 3 10 10 58.5 585 3 15 Crema de branza Kg 0.020 65 3 10 13 39 507 3 15 Zahar Kg 0.020 65 30 1 2.5 39 97.5 3 15 Esenta de vanilie buc 0.005 65 30 1 0.5 9.75 4.875 3 15 Ananas Kg 0.050 65 3 10 9 97.5 877.5 3 15 Nr client i Nr aprov Pret achizitie lei/UM Timp de siguranta(zil e) Nr clienti siguranta

description

Gestiune , agronomie anul 3

Transcript of Meniu Complet

Sheet1PranzSpecificareUMCMZNr clientiTNr aprovPret achizitie lei/UMStoc CurentTimp de siguranta(zile)Nr clienti sigurantaStoc SStoc TCantValCantVaCantValPiept de puiKg0.3006521515585877531513.5202.5787.58977.5Ceafa de porc cu cartofiCartofiKg0.250653010.6487.5292.531511.256.75494.25299.25UleiL0.020653013.539136.53150.93.1542.15139.65CondimenteKg0.00565301139.75126.753150.2252.92512.675129.675RosiiKg0.0506556597.5487.53152.2511.25108.75498.75CastravetiKg0.0506556497.53903152.259106.5399CeapaKg0.03065301158.558.53151.351.3559.8559.85RidichiKg0.0306556258.51173151.352.761.2119.7LamaieKg0.010653011.519.529.253150.450.67520.17529.925ChifleBuc2.000653010.539001950315904539451995Carne VitaKg0.2006521517390663031591535436783Ciorba de VacutaArdei gras multicolorKg0.0106556819.51563150.453.623.1159.6UleiL0.020653013.539136.53150.93.1542.15139.65CondimenteKg0.00565301139.75126.753150.2252.92512.675129.675Fin Kg0.005653011.59.7514.6253150.2250.337510.087514.9625MorcovKg0.0156556129.2529.253150.6750.67529.92529.925CeapaKg0.03065301158.558.53151.351.3559.8559.85Smntnkg0.025653101048.75487.53151.12511.2560498.75LamaieKg0.01065301419.5783150.451.821.379.8ChifleBuc2.000653010.539001950315904539451995elinkg0.020653014391563150.93.642.6159.6Capsunikg0.120653101323430423155.470.2304.23112.2Prajitura cu capsuni si ananasSmantanaKg0.030653101058.55853151.3513.572598.5Crema de branzaKg0.0206531013395073150.911.750.7518.7ZaharKg0.020653012.53997.53150.92.2541.2599.75Esenta de vaniliebuc0.005653010.59.754.8753150.2250.11259.86254.9875AnanasKg0.05065310997.5877.53152.2520.25117.75897.7527930Mic dejunSpecificareUMCMZNr clientiTNr aprovPret achizitie lei/UMStoc CurentTimp de siguranta(zile)Nr clienti sigurantaStoc SStoc TMic dejunCantValCantVaCantValOuaBuc265560.639002340315905439542394BaconKg0.02565651748.75828.753151.12519.12567.875847.875CeapaKg0.025653011.548.7573.1253151.1251.687550.437574.8125CartofiKg0.100653010.61951173154.52.7197.7119.7PatrunjelBuc0.565301197597531522.522.5997.5997.560029.55CondimenteKg0.00565301139.75126.753150.2252.92512.675129.675UleiL0.010653013.519.568.253150.451.57521.07569.8254633.3875CinaSpecificareUMCMZNr clientiTNr aprovPret achizitie lei/UMStoc CurentTimp de siguranta(zile)Nr clienti sigurantaStoc SStoc TCantValCantVaCantValCinaSomonKg0.150655653292.515502.53156.75357.75650.2515860.25BrocoliKg0.125656517.6243.7542903155.62599342.754389LamaieKg0.005653011.59.7514.6253150.2250.337510.087514.9625CondimenteKg0.00565301139.75126.753150.2252.92512.675129.675Condimente ExoticKg0.00365301155.8587.753150.1352.0257.87589.775CascavalKg0.075655625146.253656.253153.37584.375230.6253740.625AperitiveMuschi de porcKg0.075655619146.252778.753153.37564.125210.3752842.875Ardei RosuBuc0.0256556848.753903151.125957.7539927466.1625PranzSpecificareCMZPret achizitie lei/UMAd. ComercialTVAPret vanzare

Piept de pui0.300154.5006.751.628.370Cartofi0.2500.60.1500.2250.0540.279Ulei0.0203.50.0700.1050.02520.130Condimente0.005130.0650.09750.02340.121Rosii0.05050.2500.3750.090.465Castraveti0.05040.2000.30.0720.372Ceapa0.03010.0300.0450.01080.056Ridichi0.03020.0600.090.02160.112Lamaie0.0101.50.0150.02250.00540.028Chifle2.0000.51.0001.50.361.860Carne Vita0.200173.4005.11.2246.324Ardei gras multicolor0.01080.0800.120.02880.149Ulei0.0203.50.0700.1050.02520.130Condimente0.005130.0650.09750.02340.121Fin 0.0051.50.0080.011250.00270.014Morcov0.01510.0150.02250.00540.028Ceapa0.03010.0300.0450.01080.056Smntn0.025100.2500.3750.090.465Lamaie0.01040.0400.060.01440.074Chifle2.0000.51.0001.50.361.860elin0.02040.0800.120.02880.149Capsuni0.120131.5602.340.56162.902Smantana0.030100.3000.450.1080.558Crema de branza0.020130.2600.390.09360.484Zahar0.0202.50.0500.0750.0180.093Esenta de vanilie0.0050.50.0030.003750.00090.005Ananas0.05090.4500.6750.1620.83726.040Mic dejunSpecificareCMZPret achizitie lei/UMAd. ComercialTVAPret vanzare

Oua20.61.2001.80.4322.232Bacon0.025170.4250.63750.1530.791Ceapa0.0251.50.0380.056250.01350.070Cartofi0.1000.60.0600.090.02160.112Patrunjel0.510.5000.750.180.930Condimente0.005130.0650.09750.02340.121Ulei0.0103.50.0350.05250.01260.0654.320

SpecificareCMZPret achizitie lei/UMAd. ComercialTVAPret vanzare

Somon0.150537.95011.9252.86214.78749.457Brocoli0.12517.62.2003.30.7924.092Lamaie0.0051.50.0080.011250.00270.014Condimente0.005130.0650.09750.02340.121Condimente Exotic0.003150.0450.06750.01620.08419.098

Sheet2S126700.00n10.00i0.11

a21513.84Valoarea credituluiDobandaRata rambursareAn 113937.007576.84An 2119123.1613103.558410.29An 3110712.8712178.429335.42An 4101377.4411151.5210362.32An 591015.1210011.6611502.18An 679512.958746.4212767.42An 766745.537342.0114171.83An 852573.705783.1115730.73An 936842.964052.7317461.11An 1019381.852132.0019381.84

Sheet3

Sheet4SpecificareUMCMZNr clientiTNr aprovizionariPret achizitie lei/UMStoc CurentTimp de siguranta(zile)Nr clienti sigurantaStoc sigurantaStoc totalCantitateValoareCantitateValoareCantitateValoareCapsunikg0.1206231013223.22901.64104.862.4285.62964SmantanaKg0.030623101055.85584101.21267.8570Crema de branzaKg0.020623101337.2483.64100.810.447.6494ZaharKg0.020623012.537.2934100.8239.295Esenta de vaniliebuc0.005623010.59.34.654100.20.19.44.75AnanasKg0.05062310993837410218111855Desert cu capsuni, ananas si crema de branza

500 gr capsuni reci spalate si curatate de codite150 ml smantana pentru frisca (minim 30% grasime)150 gr crema de branza8 linguri rase cu zahar pudraesenta de vanilieo cutie rece cu compot de ananas bucati4 portii