30 Rumus Yang Wajib Diketahui PPIC [PDF]

Citation preview

A. RUMUS DASAR UMUM 1 SUM 2 SUMIF 3 SUMIFS 4 SUBTOTAL 5 AVERAGE 6 ROUND 7 VLOOKUP 8 INDEX & MATCH 9 IF 10 AND 11 OR 12 IFERROR 13 TRIM 14 LEFT 15 MID 16 RIGHT 17 MIN & MAX B. RUMUS WAJIB PRODUCTION PLANNING CONTROL (PPC) 1 DATE 2 TEXT 3 EOMONTH 4 WORKDAY 5 NETWORKDAYS 6 NETWORKDAYS.INTL C. RUMUS WAJIB DIKETAHUI INVENTORY CONTROL (IC) 1 FORECAST.ETS 2 FORECAST.LINEAR 3 ABS 4 AVEDEV 5 SLOPE 6 INTERCEPT 7 FORECAST.ets.SEASONALITY



A. RUMUS DASAR UMUM 1 SUM 2 SUMIF



3 SUMIFS



4 SUBTOTAL 5 AVERAGE 6 ROUND 7 VLOOKUP 8 INDEX & MATCH 9 IF 10 AND 11 OR 12 IFERROR 13 TRIM 14 LEFT 15 MID 16 RIGHT 17 MIN



Data



Data



Data 100



Malang Jakarta Palembang Serang Ambon Palembang



Malang USA



200 60 83 140 80 40 170 60 140 155 97 40 170



Apple Mango Durians Durians Bananas Durians Apple Mango Durians Durians Bananas Durians



Durians Durians Durians Apple Apple Pizza Bananas DRIVE CHAIN KIT DRIVE CHAIN KIT DRIVE CHAIN KIT PACKAGING



GOODS 80



40



Data



Formula 500



800 60 Apple



325 Durians



1435 102.92 100.00 140 140 Tinggalkan Beli Beli Bananas DRIVE CHAIN CHAIN CHAIN KIT SET 40



Palembang



B. RUMUS WAJIB PRODUCTION PLANNING CONTROL (PPC) 1 DATE 2 TEXT 3 EOMONTH 4 WORKDAY 5 NETWORKDAYS 6 NETWORKDAYS.INTL



Data Date 25



From 18-Oct-21 From 1-Oct-21 From 1-Oct-21



Data Month 10



Lead Time 10 To 31-Oct-21 To 31-Oct-21



Data Year 2021



Holidays 20-Oct-21 Holidays 20-Oct-21 Holidays 20-Oct-21



Data



Laporan Penjualan 11/7/2021 Holidays 25-Dec-21 Holidays 25-Dec-21 Remark Sunday only Holiday



Formula 25-Oct-21 Laporan Penjualan 25-10-21 31-Dec-21 02-Nov-21 20 25



C. RUMUS WAJIB DIKETAHUI INVENTORY CONTROL (IC) 1 FORECAST.ETS



Data Period 1 2 3 4 5 6



2 FORECAST.LINEAR



Period 1 2 3 4 5 6



3 ABS



Period 7 8 9 10 11 12



4 AVEDEV



Period 1 2 3 4 5 6



5 SLOPE 6 INTERCEPT 7 FORECAST.ets.SEASONALITY



y = m + bx y = m + bx



Data Months



Data



Data



Sales



1000 1000



Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Months



Period



1300 1300 1600 1600 Sales



Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Forecast



Period 1000 1300 1600 1900 2200 2500



Actual Sales 2800 3100 3400 3700 4000 4300



Months



2850 3102 3452 3660 3900 3720 Sales



Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21



Average 1,000 1,000 1,300 1,300 1,600 1,600



Formula Forecast.ETS 7 1,900 8 1,900 9 2,200 10 2,200 11 2,500 12 2,500 Forecast.Linear 7 2,800 8 3,100 9 3,400 10 3,700 11 4,000 12 4,300 Abs Error 50 2 52 40 100 580 Abs Error Avedev 1,300 300 200 1,300 300 1,300 0 1,300 0 1,300 300 1,300 300 300 700 2