Data Perhitungan Kurir

	A	B	C	D	E	F	H	I	J	K	L	M	O	P	Q	R	S	T
1	TUKAD PETANU				ESTIMASI DROP OFF	SELISIH	NANGKA				ESTIMASI DROP OFF	SELISIH	TUKAD BADUNG				ESTIMASI DROP OFF	SELISIH
2	EXPRESS	CUCI KOMPLIT	KG	Rp46	Rp694,500	Rp231,500	EXPRESS	CUCI KOMPLIT	KG	41.9	Rp628,500	Rp209,500	EXPRESS	CUCI KOMPLIT	KG
3			OMSET	Rp926,000					OMSET	Rp838,000					OMSET
4		CUCI LIPAT	KG	Rp10	Rp120,000	Rp50,000		CUCI LIPAT	KG	5.9	Rp70,800	Rp29,500		CUCI LIPAT	KG
5			OMSET	Rp170,000					OMSET	Rp100,300					OMSET
6		SETRIKA	KG	Rp5	Rp60,000	Rp15,000		SETRIKA	KG	5	Rp60,000	Rp15,000		SETRIKA	KG
7			OMSET	Rp75,000					OMSET	Rp75,000					OMSET
8	ONE DAY	CUCI KOMPLIT	KG	Rp364	Rp3,637,000	Rp1,818,500	ONE DAY	CUCI KOMPLIT	KG	195	Rp1,950,000	Rp975,000	ONE DAY	CUCI KOMPLIT	KG
9			OMSET	Rp5,455,500					OMSET	Rp2,925,000					OMSET
10		CUCI LIPAT	KG	Rp75	Rp600,800	Rp300,400		CUCI LIPAT	KG	5	Rp40,000	Rp20,000		CUCI LIPAT	KG	5	Rp40,000	Rp20,000
11			OMSET	Rp901,200					OMSET	Rp60,000					OMSET	Rp60,000
12		SETRIKA	KG	Rp5	Rp50,000	Rp10,000		SETRIKA	KG	7.5	Rp75,000	Rp15,000		SETRIKA	KG
13			OMSET	Rp60,000					OMSET	Rp90,000					OMSET
14	REGULAR	CUCI KOMPLIT	KG	Rp818	Rp6,542,400	Rp1,635,600	REGULAR	CUCI KOMPLIT	KG	628.3	Rp5,026,400	Rp1,256,600	REGULAR	CUCI KOMPLIT	KG	45.5	Rp364,000	Rp91,000
15			OMSET	Rp8,178,000					OMSET	Rp6,283,000					OMSET	Rp455,000
16		CUCI LIPAT	KG	Rp72	Rp430,200	Rp215,100		CUCI LIPAT	KG	41.4	Rp248,400	Rp124,200		CUCI LIPAT	KG
17			OMSET	Rp645,300					OMSET	Rp372,600					OMSET
18		SETRIKA	KG	Rp64	Rp381,600	Rp127,200		SETRIKA	KG	114.7	Rp688,200	Rp229,400		SETRIKA	KG
19			OMSET	Rp508,800					OMSET	Rp917,600					OMSET
20	OMSET JASA ANTAR JEMPUT			Rp200,000			OMSET JASA ANTAR JEMPUT			Rp370,000			OMSET JASA ANTAR JEMPUT
21	TOTAL			Rp16,919,800	Rp12,516,500	Rp4,403,300	TOTAL			Rp11,661,500	Rp8,787,300	Rp2,874,200	TOTAL			Rp515,000	Rp404,000	Rp111,000
22				Gaji Kurir		Rp2,185,228				Gaji Kurir		Rp2,185,228
23				Biaya Bensin		Rp1,235,000				Biaya Bensin		Rp500,000
24				Keuntungan		Rp983,072				Keuntungan		Rp188,972
25
26	TOTAL OMSET	Rp29,096,300
27	TOTAL ESTIMASI	Rp21,707,800
28	TOTAL JASA	Rp570,000
29	SELISIH	Rp7,388,500
30
31	PriceList Dropoff	Cuci Komplit	Cuci Lipat	Setrika
32	Express	15,000.00	Rp12,000	Rp12,000
33	One Day	Rp10,000	Rp8,000	Rp10,000
34	Reguler	8,000.00	Rp6,000	Rp6,000
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100