Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    Simulasi

    Uploaded by

    Welmince Bala
    The document contains financial data for an Indonesian company across 12 months. It includes employee costs like salaries and allowances, office costs, marketing costs, and training costs. The total monthly costs range from Rp9.3 million to Rp10.7 million with salaries as the highest individual cost.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Simulasi

    Uploaded by

    Welmince Bala
    24 views10 pages
    The document contains financial data for an Indonesian company across 12 months. It includes employee costs like salaries and allowances, office costs, marketing costs, and training costs. The total monthly costs range from Rp9.3 million to Rp10.7 million with salaries as the highest individual cost.

    Original Title

    simulasi - Copy.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains financial data for an Indonesian company across 12 months. It includes employee costs like salaries and allowances, office costs, marketing costs, and training costs. The total monthly costs range from Rp9.3 million to Rp10.7 million with salaries as the highest individual cost.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    24 views10 pages

    Simulasi

    Uploaded by

    Welmince Bala
    The document contains financial data for an Indonesian company across 12 months. It includes employee costs like salaries and allowances, office costs, marketing costs, and training costs. The total monthly costs range from Rp9.3 million to Rp10.7 million with salaries as the highest individual cost.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 10

    Row1

    Mean 88916.67
    Standard E 932.2369
    Median 87500
    Mode 92400
    Standard D 3229.363
    Sample Var10428788
    Kurtosis -1.920619
    Skewness 0.063832
    Range 7400
    Minimum 85000
    Maximum 92400
    Sum 1067000
    Count 12
    Row1

    Mean 751666.666666667
    Standard Error 20229.1169287533
    Median 750000
    Mode 750000
    Standard Deviation 70075.7166257049
    Sample Variance 4910606060.60609
    Kurtosis -0.7913306932801
    Skewness -0.2704616272321
    Range 225000
    Minimum 625000
    Maximum 850000
    Sum 9020000
    Count 12
    EMPLOYJANUARY FEBRUARY MARCH APRIL MAY JUNE JULY
    Tunjan Rp 22,950 Rp 22,950 Rp 22,950 Rp 23,625 Rp 23,625 Rp 23,625 Rp 23,625

    Tunjangan
    Rp25,500

    Rp25,000

    Rp24,500

    Rp24,000
    Rp23,625 Rp23,625 Rp23,625 Rp23,625
    Rp23,500

    Rp23,000 Rp22,950 Rp22,950 Rp22,950

    Rp22,500

    Rp22,000

    Rp21,500
    JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY

    EMPLOYJANUARY FEBRUARY MARCH APRIL MAY JUNE JULY


    Upah Rp 750,000 Rp 625,000 Rp 710,000 Rp 820,000 Rp 675,000 Rp 760,000 Rp 750,000

    Upah
    Rp900,000
    Rp820,000
    Rp800,000 Rp750,000 Rp760,000 Rp750,000
    Rp710,000
    Rp700,000 Rp675,000
    Rp625,000
    Rp600,000
    Rp500,000
    Rp400,000
    Rp300,000
    Rp200,000
    Rp100,000
    Rp-
    JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY
    Rp200,000
    Rp100,000
    Rp-
    JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY
    AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER
    Rp 24,948 Rp 24,948 Rp 24,948 Rp 24,948 Rp 24,948

    Tunjangan

    Rp24,948 Rp24,948 Rp24,948 Rp24,948 Rp24,948

    Rp23,625 Rp23,625
    Tunjangan

    JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER

    AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER


    Rp 680,000 Rp 750,000 Rp 820,000 Rp 830,000 Rp 850,000

    Upah
    Rp820,000 Rp830,000 Rp850,000
    Rp760,000 Rp750,000 Rp750,000
    00 Rp680,000

    Upah

    JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER


    JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER
    Tunjangan
    PT. MAJU JAYA

    RENCANA BIAYA (Rp Juta)

    January February March April May


    BIAYA TENAGA KERJAErr:522 Err:522 Err:522 Err:522 Err:522
    EMPLOYEE COSTS JANUARY FEBRUARY MARCH APRIL MAY
    Upah Rp 750,000 Rp 625,000 Rp 710,000 Rp 820,000 Rp 675,000
    Tunjangan Rp 22,950 Rp 22,950 Rp 22,950 Rp 23,625 Rp 23,625

    BIAYA KANTOR Err:522 Err:522 Err:522 Err:522 Err:522


    OFFICE COSTS JANUARY FEBRUARY MARCH APRIL MAY
    Sewa Kantor Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800
    Gas dan BBM Rp - Rp 400 Rp 400 Rp 100 Rp 100
    Listrik Rp 300 Rp 300 Rp 300 Rp 300 Rp 300
    Air Rp 40 Rp 40 Rp 40 Rp 40 Rp 40
    Telephone Rp 250 Rp 250 Rp 250 Rp 250 Rp 250
    Internet access Rp 180 Rp 180 Rp 180 Rp 180 Rp 180
    Keperluan Kantor Lainnya Rp 200 Rp 200 Rp 200 Rp 200 Rp 200
    Security Rp 600 Rp 600 Rp 600 Rp 600 Rp 600

    BIAYA PEMASARAN Err:522 Err:522 Err:522 Err:522 Err:522


    MARKETING COSTS JANUARY FEBRUARY MARCH APRIL MAY
    Biaya Pembuatan Website Rp 500 Rp 500 Rp 500 Rp 500 Rp 500
    Biaya Desain Web Rp 200 Rp 200 Rp 200 Rp 200 Rp 200
    Biaya Promosi Rp 5,000 Rp - Rp - Rp 5,000 Rp -
    Biaya Cetak Bahan Promosi Rp 200 Rp 200 Rp 200 Rp 200 Rp 200
    Biaya promosi Lainnya Rp 2,000 Rp 2,000 Rp 2,000 Rp 5,000 Rp 2,000
    Biaya Ijin dll Rp 200 Rp 200 Rp 200 Rp 200 Rp 200

    BIAYA TRAINING Err:522 Err:522 Err:522 Err:522 Err:522


    TRAINING/TRAVEL JANUARY FEBRUARY MARCH APRIL MAY
    Pelatihan Staff Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000
    Biaya Perjalanan Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000

    TOTAL BIAYA BULANAN


    June July August September October November
    Err:522 Err:522 Err:522 Err:522 Err:522 Err:522
    JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER
    Rp 760,000 Rp 750,000 Rp 680,000 Rp 750,000 Rp 820,000 Rp 830,000
    Rp 23,625 Rp 23,625 Rp 24,948 Rp 24,948 Rp 24,948 Rp 24,948

    Err:522 Err:522 Err:522 Err:522 Err:522 Err:522


    JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER
    Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800
    Rp 100 Rp 100 Rp 100 Rp 100 Rp 100 Rp 400
    Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300
    Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40
    Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250
    Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180
    Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200
    Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600

    Err:522 Err:522 Err:522 Err:522 Err:522 Err:522


    JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER
    Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500
    Rp 1,000 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200
    Rp - Rp 5,000 Rp - Rp - Rp 5,000 Rp -
    Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200
    Rp 2,000 Rp 2,000 Rp 5,000 Rp 2,000 Rp 2,000 Rp 2,000
    Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200

    Err:522 Err:522 Err:522 Err:522 Err:522 Err:522


    JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER
    Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000
    Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000
    December Total
    #NAME?
    DECEMBER Column1
    Rp 850,000 Rp 9,308,090
    Rp 24,948 Rp 9,308,090

    #NAME?
    DECEMBER Column1
    Rp 9,800
    Rp 400
    Rp 300
    Rp 40
    Rp 250
    Rp 180
    Rp 200
    Rp 600

    #NAME?
    DECEMBER Column1
    Rp 500
    Rp 1,000
    Rp -
    Rp 200
    Rp 5,000
    Rp 200

    #NAME?
    DECEMBER Column1
    Rp 2,000
    Rp 2,000

    You might also like