Academic Pizza Excel 1

7/23/2019 Academic Pizza Excel 1

1/9

Produse Ianuarie Februarie Martie

Pizza Mare

Nr. 1524 1611 1814

Pret 17.5 17.5 17.5

VANZARI 26670 28192.5 17!5

Pizza MedieNr. 1328 1243 1348

Pret 13.5 13.5 13.5

VANZARI 17928 16780.5 18198

Pizza Mi"aNr. 604 555 612

Pret 9.5 9.5 9.5

VANZARI 57 8 5272.5 581!

#auturi A$"oo$i"eNr. 3016 2978 3200

Pret 9 9 9

VANZARI 271!! 26802 28800Nr. 3168 3123 3345

Pret 7 7 7

VANZARI 22176 21861 2 !15

%osuriNr. 1136 1187 1343

Pret 2 2 2

VANZARI 2272 2 7! 2686

101928 101282.5 110658

#auturiRa"oritoare

&'&A(Vanzari)(una


2/9

A*ri$ie Mai Iunie Iu$ie Au+ust

1612 1566 1423 1578 1501

17.5 17.5 17.5 17.5 17.5

28210 27!05 2!902.5 27615 26267.51221 1233 1322 1201 1310

13.5 13.5 13.5 13.5 13.5

16!8 .5 166!5.5 178!7 1621 .5 17685586 561 541 571 585

9.5 9.5 9.5 9.5 9.5

5567 5 29.5 51 9.5 5!2!.5 5557.53313 3414 3612 3789 3812

9 9 9 9 9

29817 0726 2508 !101 ! 083456 3512 3678 3777 3867

7 7 7 7 7

2!192 2!58! 257!6 26! 9 270691244 1189 1101 1212 1187

2 2 2 2 2

2!88 2 78 2202 2!2! 2 7!

106757.5 107068 108 !5 112217 11 261


3/9

%e*te,brie '"to,brie Noie,brie -e"e,brie&'&A(

An *re izoriu1712 1723 1489 1887

!020017.5 17.5 17.5 17.5

29960 0152.5 26057.5 022.51392 1396 1212 1510

21216613.5 13.5 13.5 13.5

18792 188!6 16 62 20 85650 680 598 740

69188.59.5 9.5 9.5 9.5

6175 6!60 5681 70 03200 3101 3015 3846

6266!9 9 9 9

28800 27909 271 5 !61!3234 3123 3034 3734

287 577 7 7 7

226 8 21861 212 8 261 81312 1323 1111 1412

2951!2 2 2 2

262! 26!6 2222 282!

108989 10787!.5 98695.5 12!01 .5 1 01089.5


4/9

Previzionarea nivelului costurilor Luna 0 Luna 11. COSTUL PROPRIU-ZIS AL VNZRILOR1. Cheltuieli cu materii prime si materiale1.1. Materii prime 0 237121.2.Materiale consumabile 500 2001.3.Materiale auxiliare 150 301.4.Materiale pentru ambalat 0.5 0.51.5.Piese de schimb 0 01. .!h. cu ener"ia utilizata in proc. de prod. 350 3502. Cheltuieli privind personalul direct productiv 2.1.#alarii 7710 77102.2.!ontributii la asi"urari sociale 1 03. $ 1 03. $2.3.!ontributii la asi"urarile de soma% 0 02.4.!ontributii la asi"urarile medicale 525.7 525.72.5.&mpozit pe salarii 1201. 1201.3.Alte costuri 0 0TOTAL COSTURI VARIABILE (CV) 12041.48 35333.482. CHELTUIELI GENERALE SI A !INISTRATIVE1. Cheltuieli ntreinere1.1. !hirii si impozite imobiliare 0 01.2. 'mortizare 0 01.3. (ntre)inere electricitate 700 7002.Cheltuieli birou2.1.'mortizare mobilier birou 5.*5 5.*52.2.'mortizare echipamente birou 0 02.3.+chipamente 12340 02.4.Papetarie 100 02.5.,ari-e si abonamente 0 02. .'lte cheltuieli de birou 0 03. Comunicaii 3.1.'mortizare echipamente comunicatii 0 03.2.,ele-on si -ax 30 303.3.#ervicii in-ormationale 0 03.4. Po t/ i curier 0 0

4. Calculatoare4.1 'mortizare calculatoare 3$.$$ 3$.$$4.2 'mortizare so-t are 0 04.3. !onsumabile calculatoare 50 05.Transport 5.1.'mortizare mi%loace de transport 0 05.2.!hirie mi%loace de transport 0 05.3.!heltuieli privind mi%loacele de transport 4300 05.4. 'lte cheltuieli privind transportul 1$ 1$6. Cheltuieli privind personalul TES

.1 #alarii 0 0.2.!ontributii la asi"urari sociale 0 0

.3 !ontribu)ii la asi"ur/rile de oma% 0 0


5/9

.4 !ontribu)ii la asi"ur/rile medicale 0 0

.5 &mpozit pe salarii 0 03. CHELTUIELI E VNZRI SI ISTRIBU"IE1. !ar"etin# $i v%n&'ri 1.1 itributie produse 2000 13001.2. ro uri i imprimeuri 700 2001.3 'rticole promo)ionale 00 1501.4 'lte cheltuieli de mar etin" 0 0

0 020882.83 2442.83

32#24.31 3$$$%.31

4. CHELTUIELI CU OBNZILE5. TOTAL COSTURI &I'E (C&)

. TOTAL COSTURI (C& CV)


6/9

Luna 2 Luna 3 Luna 4 Luna 5 Luna Luna 7

23753 2 3*1 23$10 2335* 225$1 2332150 340 120 210 1$0 250

30 30 30 30 30 300.5 0.5 0.5 0.5 0.5 0.5

0 0 0 0 0 0350 350 350 350 350 350

7710 7710 7710 7710 7710 77101 03. $ 1 03. $ 1 03. $ 1 03. $ 1 03. $ 1 03. $

0 0 0 0 0 0525.7 525.7 525.7 525.7 525.7 525.7

1201. 1201. 1201. 1201. 1201. 1201.0 0 0 0 0 0

35324.48 38152.48 35351.48 34##0.48 34182.48 34##$.48

0 0 0 0 0 00 0 0 0 0 0

700 700 700 700 700 700

5.*5 5.*5 5.*5 5.*5 5.*5 5.*50 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 0

0 0 0 0 0 030 30 30 30 30 30

0 0 0 0 0 00 0 0 0 0 0

3$.$$ 3$.$$ 3$.$$ 3$.$$ 3$.$$ 3$.$$0 0 0 0 0 0

20 0 0 0 30 0

0 0 0 0 0 00 0 0 0 0 00 0 0 0 0 0

1$ 1$ 1$ 1$ 1$ 1$

0 0 0 0 0 00 0 0 0 0 00 0 0 0 0 0


7/9

0 0 0 0 0 00 0 0 0 0 0

1100 *00 700 00 500 400200 200 200 200 200 200150 150 150 150 150 150

0 0 0 0 0 00 0 0 0 0 0

22%2.83 2042.83 1842.83 1$42.83 1%$2.83 1542.833$58$.31 401#5.31 3$1#4.31 3%$33.31 35855.31 3%540.31


8/9

Luna $ Luna * Luna 10 Luna 11 Luna 12 ,otal

233*5 25* 0 2 203 22 $7 2$52$ 2*3705220 140 1*0 210 310 3020

30 30 30 30 30 5100.5 0.5 0.5 0.5 0.5 .5

0 0 0 0 0 0350 350 350 350 350 4550

7710 7710 7710 7710 7710 1002301 03. $ 1 03. $ 1 03. $ 1 03. $ 1 03. $ 20$47.$4

0 0 0 0 0 0525.7 525.7 525.7 525.7 525.7 $34.1

1201. 1201. 1201. 1201. 1201. 15 20.$0 0 0 0 0 0

3503%.48 3$521.48 3$814.48 34318.48 4025#.48 445324.24

0 0 0 0 137 1370 0 0 0 0 0

700 700 700 700 700 *100

5.*5 5.*5 5.*5 5.*5 5.*5 77.350 0 0 0 0 00 0 0 0 0 12340

100 0 0 0 0 2000 0 0 0 0 00 0 0 0 0 0

0 0 0 0 0 030 30 30 30 30 3*0

0 0 0 0 0 00 0 0 0 0 0

3$.$$ 3$.$$ 3$.$$ 3$.$$ 3$.$$ 505.440 0 0 0 0 00 0 0 40 0 140

0 0 0 0 00 0 0 0 0 00 0 0 0 0 4300

1$ 1$ 1$ 1$ 1$ 234

0 0 0 0 0 00 0 0 0 0 00 0 0 0 0 0


9/9

0 0 0 0 0 00 0 0 0 0 0

300 250 250 200 200 $700200 200 200 200 200 3100150 150 150 150 150 2400

0 0 0 0 0 00 0 0 0 0 0

1542.83 13#2.83 13#2.83 1382.83 14$#.83 41%23.$#3%5$#.31 38#14.31 3#20%.81 35$01.31 41$3#.31 48%#4$.53

Academic Pizza Excel 1

Documents

Transcript of Academic Pizza Excel 1