PLAN FINANSOWY FIRMY F2
ZARZĄD: DIANA KLECZKOWSKA, MONIKA NAGADOWSKA, ALEKSANDRA RYLSKA
miesiąc | I | II | III | IV | V | VI | VII | VIII | IX | X | XI | XII | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Środki finansowe | 1500 000 | 1132000 | 508 000 | 4773500 | 6835500 | 7161100 | 8197600 | 9193100 | 21297950 | 30178850 | 40864190 | 44581350 | |
Cena maszyny | 1000 | 1500 | 900 | 1100 | 1300 | 1000 | 1250 | 1250 | 1700 | 1100 | 1300 | 1500 | |
Ilość zakupionych maszyn | 80 | 0 | 25 | 0 | 0 | 50 | 0 | 30 | 0 | 60 | 35 | 0 | |
Fundusz maszyn | 80000 | 0 | 22500 | 0 | 0 | 50000 | 0 | 37500 | 0 | 66000 | 45500 | 0 | |
Zużycie maszyn | 0 | 0 | 5 | 10 | 12 | 14 | 17 | 22 | 30 | 37 | 28 | 35 | |
Wydajność maszyn | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | |
Ilość maszyn | 80 | 80 | 100 | 90 | 78 | 114 | 97 | 105 | 75 | 98 | 105 | 70 | |
Moce produkcyjne | 2400 | 2400 | 3000 | 2700 | 2340 | 3420 | 2910 | 3150 | 2250 | 2940 | 3150 | 2100 | |
Zakup mat. A | 2400 | 2000 | 1000 | 2000 | 1700 | 3000 | 2500 | 3200 | 1800 | 2500 | 0 | 0 | |
Zakup mat. B | 4800 | 4000 | 2000 | 4000 | 3400 | 6000 | 5000 | 6400 | 3600 | 5000 | 0 | 0 | |
Zakup mat. C | 2400 | 2000 | 1000 | 2000 | 1700 | 3000 | 2500 | 3200 | 1800 | 2500 | 0 | 0 | |
Cena mat. A | 40 | 40 | 31 | 29 | 50 | 30 | 31 | 28 | 28 | 33 | 45 | 15 | |
Cena mat. B | 30 | 30 | 19 | 25 | 41 | 28 | 30 | 22 | 22 | 28 | 30 | 13 | |
Cena mat. C | 20 | 20 | 11 | 12 | 30 | 20 | 23 | 25 | 25 | 30 | 50 | 10 | |
Fundusz materiału | 288000 | 240000 | 80000 | 182000 | 275400 | 318000 | 285000 | 310400 | 174600 | 297500 | 0 | 0 | |
Wyroby gotowe | 0 | 0 | 2400 | 2000 | 1000 | 2000 | 1700 | 3000 | 2500 | 3200 | 1800 | 2500 | |
Koszt robocizny | 100 | 100 | 100 | 120 | 120 | 125 | 125 | 130 | 130 | 133 | 133 | 135 | |
Fundusz płac netto | 0 | 240000 | 240000 | 240000 | 120000 | 250000 | 212500 | 390000 | 325000 | 425600 | 239400 | 337500 | |
Fundusz marketingu | 0 | 0 | 0 | 12000 | 18000 | 18000 | 0 | 0 | 0 | 0 | 0 | 0 | |
Postęp techniczny | 0 | 0 | 0 | 20000 | 20000 | 10000 | 10000 | 0 | 0 | 0 | 0 | 0 | |
Koszty transportu | 0 | 0 | 48000 | 50000 | 25000 | 60000 | 51000 | 105000 | 87500 | 115200 | 64800 | 90000 | |
ZUS | 0 | 144000 | 144000 | 144000 | 72000 | 150000 | 127500 | 234000 | 195000 | 255360 | 143640 | 202500 | |
Akcyza | 0 | 0 | 0 | 480000 | 319000 | 117500 | 201000 | 188250 | 1337000 | 1100000 | 1294500 | 550500 | |
Wartość maszyn | 80000 | 80000 | 97500 | 87750 | 76050 | 112400 | 95639 | 111447 | 79605 | 106333 | 121452 | 80968 | |
Amortyzacja | 0 | 0 | 4875 | 4388 | 3803 | 5620 | 4782 | 5572 | 3980 | 5317 | 6073 | 4048 | |
Konsultacje | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100000 | |
Cena wyrobu: | |||||||||||||
Rynek 1 | 2000 | 2000 | 2000 | 1500 | 1200 | 1000 | 1000 | 4000 | 3850 | 3850 | 2900 | 1700 | |
Rynek 2 | 2000 | 2000 | 2000 | 1300 | 900 | 700 | 700 | 3900 | 4000 | 4000 | 3150 | 2000 | |
Rynek 3 | 2000 | 2000 | 2000 | 1450 | 1150 | 950 | 950 | 4500 | 4350 | 4350 | 3800 | 1950 | |
Rynek 4 | 2000 | 2000 | 2000 | 1850 | 1400 | 1300 | 1300 | 5000 | 5000 | 3950 | 2500 | 1580 | |
Ilość sprzedanych wyrobów: | |||||||||||||
Rynek 1 | 0 | 0 | 400 | 700 | 250 | 300 | 300 | 400 | 700 | 500 | 400 | 900 | |
Rynek 2 | 0 | 0 | 500 | 300 | 250 | 600 | 250 | 800 | 500 | 700 | 300 | 400 | |
Rynek 3 | 0 | 0 | 700 | 250 | 200 | 400 | 250 | 700 | 300 | 800 | 500 | 700 | |
Rynek 4 | 0 | 0 | 800 | 750 | 300 | 700 | 900 | 1100 | 1000 | 1200 | 600 | 500 | |
Wartość sprzedaży: | |||||||||||||
Rynek 1 | 0 | 0 | 800000 | 1050000 | 300000 | 300000 | 300000 | 1600000 | 2695000 | 1925000 | 1160000 | 1530000 | |
Rynek 2 | 0 | 0 | 1000000 | 390000 | 225000 | 420000 | 175000 | 3120000 | 2000000 | 2800000 | 945000 | 800000 | |
Rynek 3 | 0 | 0 | 1400000 | 362500 | 230000 | 380000 | 237500 | 3150000 | 1305000 | 3480000 | 1900000 | 1365000 | |
Rynek 4 | 0 | 0 | 1600000 | 1387500 | 420000 | 910000 | 1170000 | 5500000 | 5000000 | 4740000 | 1500000 | 790000 | |
Suma wydatków | 368000 | 624000 | 534500 | 1128000 | 849400 | 973500 | 887000 | 1265150 | 2119100 | 2259660 | 1787840 | 1280500 | SUMA |
Przychód | 0 | 0 | 4800000 | 3190000 | 1175000 | 2010000 | 1882500 | 13370000 | 11000000 | 12945000 | 5505000 | 4485000 | 60362500 |
Środki pieniężne na koniec m-ca | 1132000 | 508000 | 4773500 | 6835500 | 7161100 | 8197600 | 9193100 | 21297950 | 30178850 | 40864190 | 4458 350 | 47785850 | |
KUP | 368000 | 624000 | 539375 | 1132388 | 853203 | 979120 | 891782 | 1 270722 | 2123080 | 2264977 | 1793913 | 1284548 | 14125107 |
Dochód | 46 237 393 |
---|---|
Podatek | 20806827 |
Zysk netto | 25 430 566 |
Dywidenda | 375000 |
Zysk do podziału | 25 055 566 |