Docstoc

Contoh Proposal Bisnis Mikro dan Kecil

Document Sample
Contoh Proposal Bisnis Mikro dan Kecil Powered By Docstoc
					Perhitungan Rumus Ramalan
    Bulan        X              Y         X2         XY
       1         -3        30,000,000     9     (90,000,000)
       2         -2        45,000,000     4     (90,000,000)
       3         -1        55,000,000     1     (55,000,000)
       4         0         70,000,000     0          0
       5         1         90,000,000     1      90,000,000
       6         2        100,000,000     4     200,000,000
       7         3        120,000,000     9     360,000,000
       8         4        150,000,000     16    600,000,000
Total            4         660,000,000    44   1,015,000,000


Tabel Perhitungan Ramalan
   Bulan           X             Y
  Historikal
      1            -3       15,000,000
      2            -2       17,500,000
      3            -1       25,000,000
      4            0        35,000,000
      5            1        40,000,000
      6            2        42,500,000
      7            3        45,000,000
      8            4        50,000,000
  Proyeksi
      1            5        197,840,909   2         98,920,455
      2            6        220,909,091   3         73,636,364
      3            7        243,977,273   3         81,325,758
      4            8        267,045,455   3         89,015,152
      5            9        290,113,636   3         96,704,545
      6           10        313,181,818   4         78,295,455
      7           11        336,250,000   4         84,062,500
      8           12        359,318,182   4         89,829,545
      9           13        382,386,364   4         95,596,591
      10          14        405,454,545   4        101,363,636
      11          15        428,522,727   4        107,130,682
      12          16        451,590,909   4        112,897,727
a=  82,500,000
b = 23,068,182


Y = a+bX
Y=   82,500,000 +   23,068,182 X

				
DOCUMENT INFO
Shared By:
Stats:
views:0
posted:8/1/2013
language:Unknown
pages:2