Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    Perencanaan Agregat Dengan Perhitungan Manual

    Uploaded by

    Oki Rizkiyanto
    1. The document contains production cost planning calculations for a product with a price of Rp. 400,000. It includes direct labor costs of Rp. 20,000 for regular time and Rp. 30,000 for overtime. 2. Aggregate demand forecasts and production plans are presented for 12 periods, with calculations of regular time, overtime, and total costs by period. 3. Disaggregation of demand into item categories is shown by percentage and quantity, with cut-and-fit allocation of demand across 8 periods presented.

    Copyright:

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

    Perencanaan Agregat Dengan Perhitungan Manual

    Uploaded by

    Oki Rizkiyanto
    37 views8 pages
    1. The document contains production cost planning calculations for a product with a price of Rp. 400,000. It includes direct labor costs of Rp. 20,000 for regular time and Rp. 30,000 for overtime. 2. Aggregate demand forecasts and production plans are presented for 12 periods, with calculations of regular time, overtime, and total costs by period. 3. Disaggregation of demand into item categories is shown by percentage and quantity, with cut-and-fit allocation of demand across 8 periods presented.

    Original Description:

    excel agregat

    Original Title

    Excel Agregat

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document contains production cost planning calculations for a product with a price of Rp. 400,000. It includes direct labor costs of Rp. 20,000 for regular time and Rp. 30,000 for overtime. 2. Aggregate demand forecasts and production plans are presented for 12 periods, with calculations of regular time, overtime, and total costs by period. 3. Disaggregation of demand into item categories is shown by percentage and quantity, with cut-and-fit allocation of demand across 8 periods presented.

    Copyright:

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

    Perencanaan Agregat Dengan Perhitungan Manual

    Uploaded by

    Oki Rizkiyanto
    1. The document contains production cost planning calculations for a product with a price of Rp. 400,000. It includes direct labor costs of Rp. 20,000 for regular time and Rp. 30,000 for overtime. 2. Aggregate demand forecasts and production plans are presented for 12 periods, with calculations of regular time, overtime, and total costs by period. 3. Disaggregation of demand into item categories is shown by percentage and quantity, with cut-and-fit allocation of demand across 8 periods presented.

    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 8

    harga produk 400000

    Biaya RT 20000
    Biaya OT 30000

    Perencanaan agregat dengan perhitungan manual

    Demand
    1 2 3 4
    ramalan
    20000 40000
    1 ~ 12
    352.91 RT 153.12 20000 40000 60000
    352.91 1 OT 38.28 30000 50000 70000
    352.91 SK
    352.91 RT 145.46 20000 40000
    352.91 2 OT 36.365 30000 50000
    352.91 SK
    352.91 RT 153.12 20000
    352.91 3 OT 38.28 30000
    352.91 SK
    352.91 RT 153.12
    352.91 4 OT 38.28
    352.91 SK
    RT
    5 OT
    SK
    RT
    6 OT
    SK
    RT
    7 OT
    SK
    RT
    8 OT
    SK
    RT
    9 OT
    SK
    RT
    10 OT
    SK
    RT
    11 OT
    SK
    RT
    12 OT
    SK
    191.40 181.83 191.40 191.40

    Perhitungan Biaya Produksi


    Periode RT OT Total
    1 3062400 1148400 4210800
    2 2909200 1090950 4000150
    3 3062400 1148400 4210800
    4 3062400 1148400 4210800
    5 3062400 1205850 4268250
    6 3215600 1205850 4421450
    7 3062400 1148400 4210800
    8 3062400 1148400 4210800
    9 3062400 1148400 4210800
    10 3062400 1148400 4210800
    11 3062400 1148400 4210800
    12 3062400 1148400 4210800
    Total 36748800 13838250 50587050
    4 5 6 7 8 9 10

    60000 80000 100000 120000 140000 160000


    80000 100000 120000 140000 160000 180000
    90000 110000 130000 150000 170000 190000

    60000 80000 100000 120000 140000 160000


    70000 90000 110000 130000 150000 170000

    40000 60000 80000 100000 120000 140000


    50000 70000 90000 110000 130000 150000

    20000 40000 60000 80000 100000 120000


    30000 50000 70000 90000 110000 130000

    153.12 20000 40000 60000 80000 100000


    38.28 30000 50000 70000 90000 110000

    160.78 20000 40000 60000 80000


    40.195 30000 50000 70000 90000

    153.12 20000 40000 60000


    38.28 30000 50000 70000

    153.12 20000 40000


    38.28 30000 50000

    153.12 20000
    38.28 30000

    153.12
    38.28
    191.40 200.98 191.40 191.40 191.40 191.40
    10 11 12 KTTP KTP

    180000 200000 220000


    200000 220000 240000
    210000 230000 250000

    180000 200000 220000


    190000 210000 230000

    160000 180000 200000


    170000 190000 210000

    140000 160000 180000


    150000 170000 190000

    120000 140000 160000


    130000 150000 170000

    100000 120000 140000


    110000 130000 150000

    80000 100000 120000


    90000 110000 130000

    60000 80000 100000


    70000 90000 110000

    40000 60000 80000


    50000 70000 90000

    20000 40000 60000


    30000 50000 70000

    153.12 20000 40000


    38.28 30000 50000
    153.12 20000
    38.28 30000

    191.40 191.40
    Data Inventory
    Periode Kel 5 Kel 10 Kel 16
    1 84.87 123.9 144.14
    2 84.87 123.9 144.14
    3 84.87 123.9 144.14
    4 84.87 123.9 144.14
    5 84.87 123.9 144.14
    6 84.87 123.9 144.14
    7 84.87 123.9 144.14
    8 84.87 123.9 144.14
    9 84.87 123.9 144.14
    10 84.87 123.9 144.14
    11 84.87 123.9 144.14
    12 84.87 123.9 144.14
    Jumlah 1018.44 1486.8 1729.68
    Jumlah
    Demand 4234.92
    Family

    Persentase Masing-Masing Item


    Kelompok 5 0.240486
    Kelompok 10 0.351081
    Kelompok 16 0.408433 352.91 352.91

    Data Hasil Ramalan


    Periode 1 2 3 4 5 6 7 8
    Demand 353 353 353 353 353 353 353 353

    Permintaan Masing-Masing Item(Satuan Agregat)


    Item 1 2 3 4 5 6 7 8
    Kelompok 5 84.89164 84.89164 84.89164 84.89164 84.89164 84.89164 84.89164 84.89164
    Kelompok 10 123.9316 123.9316 123.9316 123.9316 123.9316 123.9316 123.9316 123.9316
    Kelompok 16 144.1768 144.1768 144.1768 144.1768 144.1768 144.1768 144.1768 144.1768

    Disagregaasi Metode Cut and Fit


    Periode
    item 1 2 3 4 5 6 7 8
    Kelompok 5 42.44582 42.44582 42.44582 42.44582 42.44582 42.44582 42.44582 42.44582
    Kelompok 10 61.9658 61.9658 61.9658 61.9658 61.9658 61.9658 61.9658 61.9658
    Kelompok 16 72.08838 72.08838 72.08838 72.08838 72.08838 72.08838 72.08838 72.08838
    352.91 352.91 352.91 352.91 352.91 352.91 352.91 352.91 352.91 352.91

    9 10 11 12
    353 353 353 353

    Agregat)
    9 10 11 12
    84.89164 84.89164 84.89164 84.89164
    123.9316 123.9316 123.9316 123.9316
    144.1768 144.1768 144.1768 144.1768

    9 10 11 12
    42.44582 42.44582 42.44582 42.44582
    61.9658 61.9658 61.9658 61.9658
    72.08838 72.08838 72.08838 72.08838

    You might also like