RM : IMAM BURYANTO

AM : ANOR ADI SABEKTI

BULAN : JULI-22

STORE SALES PEMAKAIAN % LISTRIK

1 RC IMOGIRI BARAT1 Rp 202,227,355.00 Rp 133,245,652.00 65.9% Rp 1,744,268.00
2 #DIV/0!
3 #DIV/0!
4 #DIV/0!
5 #DIV/0!
6 #DIV/0!
7 #DIV/0!
8 #DIV/0!
9 #DIV/0!
10 #DIV/0!
11 #DIV/0!
12 #DIV/0!
13 #DIV/0!
14 #DIV/0!
15 #DIV/0!
16 #DIV/0!
17 #DIV/0!
18 #DIV/0!
19 #DIV/0!
20 #DIV/0!
21 #DIV/0!
22 #DIV/0!
23 #DIV/0!
24 #DIV/0!
25 #DIV/0!
26 #DIV/0!
27 #DIV/0!
28 #DIV/0!
29 #DIV/0!
30 #DIV/0!
Rp 202,227,355.00 Rp 133,245,652.00 65.9% Rp 1,744,268.00
 AIR ATK TELP TRANSPORT GAS

Rp 206,300.00 Rp 128,000.00 Rp 345,000.00 Rp 3,800,000.00

Rp - Rp 206,300.00 Rp 128,000.00 Rp 345,000.00 Rp 3,800,000.00

 %
% PEMBERSIH TOTAL % GAJI %

1.9% Rp 879,025.00 0.4% Rp 7,102,593.00 3.5% Rp 19,456,000.00 9.6%

#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
#DIV/0! #DIV/0! Rp - #DIV/0! #DIV/0!
1.9% Rp 879,025.00 0.4% Rp 7,102,593.00 3.5% Rp 19,456,000.00 9.6%
 setoran setoran
PAJAK % % % UTILITIES
OFFICE OWNER
4,374,178 2% 25,000,000 12.4% 25,000,000 12.4% 3,290,855
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
0% - 0.0%
 DATA MAN POWER
SPV casier seniocook seniorcasier traincook traingTOTAL
2 4 2 1 9
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2 4 2 0 1 9
 ROCKET CHICKEN

SALES CONTROL

MONTH TO DATE AVERAGE

TGL NET SALES CU TARGET %

Sales CU Net Sales

1 5,858,415 226 5,858,415 226 8,064,516 73% 5,858,415
2 8,300,537 271 14,158,952 497 16,129,032 88% 7,079,476
3 8,107,717 280 22,266,669 777 24,193,548 92% 7,422,223
4 6,413,171 233 28,679,840 1,010 32,258,064 89% 7,169,960
5 6,395,261 233 35,075,101 1,243 40,322,580 87% 7,015,020
6 7,664,641 253 42,739,742 1,496 48,387,096 88% 7,123,290
7 5,772,677 217 48,512,419 1,713 56,451,612 86% 6,930,346
8 8,320,469 273 56,832,888 1,986 64,516,128 88% 7,104,111
9 8,350,732 298 65,183,620 2,284 72,580,644 90% 7,242,624
10 6,679,084 254 71,862,704 2,538 80,645,160 89% 7,186,270
11 7,949,462 300 79,812,166 2,838 88,709,676 90% 7,255,651
12 6,713,996 256 86,526,162 3,094 96,774,192 89% 7,210,514
13 7,077,342 256 93,603,504 3,350 104,838,708 89% 7,200,270
14 6,741,789 259 100,345,293 3,609 112,903,224 89% 7,167,521
15 5,829,251 211 106,174,544 3,820 120,967,740 88% 7,078,303
16 6,137,585 203 112,312,129 4,023 129,032,256 87% 7,019,508
17 11,274,064 253 123,586,193 4,276 137,096,772 90% 7,269,776
18 5,218,478 211 128,804,671 4,487 145,161,288 89% 7,155,815
19 4,416,337 198 133,221,008 4,685 153,225,804 87% 7,011,632
20 5,363,514 215 138,584,522 4,900 161,290,320 86% 6,929,226
21 5,068,900 203 143,653,422 5,103 169,354,836 85% 6,840,639
22 5,747,731 213 149,401,153 5,316 177,419,352 84% 6,790,962
23 7,656,890 211 157,058,043 5,527 185,483,868 85% 6,828,611
24 6,395,311 228 163,453,354 5,755 193,548,384 84% 6,810,556
25 5,480,314 214 168,933,668 5,969 201,612,900 84% 6,757,347
26 4,719,472 181 173,653,140 6,150 209,677,416 83% 6,678,967
27 4,799,294 201 178,452,434 6,351 217,741,932 82% 6,609,349
 28 4,989,971 196 183,442,405 6,547 225,806,448 81% 6,551,514
29 6,032,394 233 189,474,799 6,780 233,870,964 81% 6,533,614
30 6,534,123 214 196,008,922 6,994 241,935,480 81% 6,533,631
31 6,218,433 227 202,227,355 7,221 250,000,000 81% 6,523,463

NB :
RUMUS PENGISIAN SALES CONTROL
1. NET SALES : PENJUALAN BERSIH HARI INI
2. CU : CUSTOMER HARI INI
3. SALES MTD : SALES HARI INI + SALES MTD
4. MTD CU : CUSTOMER HARI INI + CUSTOMER MTD
5. % : SALES MTD ......%
TARGET
6. AVERAGE SALES : SALES MTD : TANGGAL HARI INI
7. DAYA BELI : SALES HARI INI : CU HARI INI

Dibuat Oleh,
 Cabang : RC IMOGIRI BARAT1
Bulan : JULI-22
AVERAGE MTD PENJUALAN PAKET ROCKET KIDS
TERJUAL
HARI INI MTD HARGA
NOMINAL
(paket PAKET MAINAN
Daya Beli LAST MONTH 1,2,3)
25,922 4,773,667 1 1 12,000 12,000
30,629 11,479,784 1 2 12,000 24,000
28,956 18,173,461 1 3 12,000 36,000
27,524 24,591,857 3 12,000 36,000
27,447 32,132,813 1 4 12,000 48,000
30,295 37,997,733 4 12,000 48,000
26,602 42,476,463 4 12,000 48,000
30,478 48,038,051 4 12,000 48,000
28,023 54,586,470 2 6 12,000 72,000
26,296 60,290,193 6 12,000 72,000
26,498 66,758,413 6 12,000 72,000
26,227 73,716,546 6 12,000 72,000
27,646 79,278,951 1 7 12,000 84,000
26,030 85,384,446 1 8 12,000 96,000
27,627 90,863,139 2 10 12,000 120,000
30,234 95,838,108 10 12,000 120,000
44,562 102,668,176 10 12,000 120,000
24,732 109,645,344 10 12,000 120,000
22,305 116,853,260 10 12,000 120,000
24,947 123,942,680 10 12,000 120,000
24,970 129,795,380 1 11 12,000 132,000
26,985 135,724,812 11 12,000 132,000
36,289 141,650,193 11 12,000 132,000
28,050 149,561,745 11 12,000 132,000
25,609 157,322,900 11 12,000 132,000
26,074 165,568,284 11 12,000 132,000
23,877 171,579,892 11 12,000 132,000
 25,459 177,521,404 11 12,000 132,000
25,890 182,809,606 11 12,000 132,000
30,533 188,436,345 2 13 12,000 156,000
27,394 13 12,000 156,000

PENJUALAN PAKET ROCKET KIDS

TERJUAL HARI INI (paket
1,2,3) : TOTAL PAKET MAINAN YANG TERJUAL PADA HARI INI
MTD PAKET : PENJUALAN PAKET MAINAN HARI INI + MTD PAKET MAINAN
HARGA MAINAN : HARGA BELI MAINAN ( Rp. 12.000 )
NOMINAL : MTD MAIAN x HARGA MAINAN
 LAPORAN KAS

TANGGAL
22 23 24
HARI

Rp6,154,175 Rp8,018,525 Rp6,726,125

Penjualan Kotor

Koreksi / Pembatalan

Discount

Rp6,154,175 Rp8,018,525 Rp6,726,125

Penjualan Bersih

Rp57,063 Rp41,130 Rp56,527

Komisi Grab

Rp157,745 Rp96,411 Rp106,570

Komisi Gojek

Rp191,636 Rp224,094 Rp167,717

Komisi Shopee

PENJUALAN MAINAN

Tax ( PPN )

Selisih Kas

Rp5,747,731 Rp7,656,890 Rp6,395,311

Kas yang harus disetor

1279/1284 1280/1285 1281/1286

No.Rizet PLU / TTL

Penjualan Mikas

Penjualan Lain - lain

Setor Bank

Setor Pihak Gedung

Rp213 Rp211 Rp228

Jumlah Pembeli

NB : koreksi , discount dan no rizet dimasukan manual

LAPORAN KAS & PENJUALAN PER PERIODE

STORE: RC IMOGIRI BARAT1 Periode :

25 26 27 28 29

Rp5,716,675 Rp5,013,350 Rp4,989,025 Rp5,338,725 Rp6,368,200

Rp5,716,675 Rp5,013,350 Rp4,989,025 Rp5,338,725 Rp6,368,200

Rp39,061 Rp37,895 Rp27,356 Rp68,925 Rp43,481

Rp73,591 Rp119,527 Rp49,609 Rp126,136 Rp105,200

Rp123,709 Rp136,456 Rp112,766 Rp153,693 Rp187,125

Rp5,480,314 Rp4,719,472 Rp4,799,294 Rp4,989,971 Rp6,032,394

1282/1287 1283/1288 1284/1289 1285/1290 1286/1291

 Rp214 Rp181 Rp201 Rp196 Rp233

no rizet dimasukan manual

0
Periode : 22-30 JULI 2022

30 31 TOTAL

Rp6,897,000 Rp6,600,825 Rp61,822,625

Rp0

Rp0

Rp6,897,000 Rp6,600,825 Rp61,822,625

Rp29,887 Rp41,520 Rp442,845

Rp155,699 Rp183,209 Rp1,173,697

Rp177,291 Rp157,663 Rp1,632,150

Rp24,000 Rp24,000

Rp0

Rp0

Rp6,534,123 Rp6,218,433 Rp58,573,933

1287/1292

Rp0

Rp0
 Rp0

Rp214 Rp227 2118

Form2/Adm/10