Scribd
Upload
20 views3 pages

Mutia

The document is a stock report from Toko Sumber Makmur store for December 2021. It shows the initial stock, sales, remaining stock and profit analysis for food, drinks and stationery items. Overall, the initial stock was worth Rp14,770,200,000 with sales of Rp16,678,000,000 for the month, leaving a remaining stock of Rp1,289,805,000. The profit achieved was Rp463,100,000 or 27% of the cost of goods sold. Most items sold reasonably well with only a few being slow moving.

Uploaded by

mutiarasrr24
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
20 views3 pages

Mutia

The document is a stock report from Toko Sumber Makmur store for December 2021. It shows the initial stock, sales, remaining stock and profit analysis for food, drinks and stationery items. Overall, the initial stock was worth Rp14,770,200,000 with sales of Rp16,678,000,000 for the month, leaving a remaining stock of Rp1,289,805,000. The profit achieved was Rp463,100,000 or 27% of the cost of goods sold. Most items sold reasonably well with only a few being slow moving.

Uploaded by

mutiarasrr24
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

KODE HARGA POKOK HARGA JUAL PERSEDIAAN AWAL

NO RINCIAN BARANG SATUAN


BARANG SATUAN SATUAN JML
MAKANAN
1 AA201 Tango Wafer Vanila Pax Rp 2,700.00 Rp 3,500.00 22
2 AA202 Hello Panda Cookies Box Rp 18,000.00 Rp 21,000.00 53
3 AA203 Biskuit Roma Pax Rp 1,200.00 Rp 1,500.00 25
4 AA204 Biskuit Khong Guan Kaleng Rp 20,000.00 Rp 27,500.00 47
5 AA205 Brownies Pax Rp 27,500.00 Rp 32,500.00 24
Total Makanan Rp 69,400.00 Rp 86,000.00 171
MINUMAN
1 AB206 Fruit Tea Pcs Rp 1,500.00 Rp 2,000.00 22
2 AB207 Pocari Sweat Kaleng Rp 3,200.00 Rp 4,000.00 53
3 AB208 Teh Botol Sosro Btl Rp 3,100.00 Rp 4,000.00 25
Total Minuman Rp 7,800.00 Rp 10,000.00 100
STATIONERY
1 BB400 Amplop 1/2 Folio Pcs Rp 3,600.00 Rp 4,500.00 23
2 BB401 Pulpen Pilot Box Rp 1,600.00 Rp 2,000.00 30
3 BB402 Kertas HVS 50 lbr Box Rp 7,000.00 Rp 8,000.00 25
4 BB403 Penghapus Steadier Pax Rp 1,200.00 Rp 1,500.00 20
5 BB404 Rautan Kecil Pax Rp 4,000.00 Rp 5,000.00 24
Total Stationery Rp 17,400.00 Rp 21,000.00 122
TOTAL Rp 94,600.00 Rp 117,000.00 393
TOKO SUMBER MAKMUR
LAPORAN STOCK OPNAME
PER DESEMBER 2021

PERSEDIAAN AWAL PENJUALAN PERSEDIAAN AKHIR


NILAI JML NILAI % PENJUALAN JML NILAI

Rp 59,400.00 20 Rp 70,000.00 91% 2 Rp 5,400.00


Rp 954,000.00 34 Rp 714,000.00 64% 19 Rp 342,000.00
Rp 30,000.00 23 Rp 34,500.00 92% 2 Rp 2,400.00
Rp 940,000.00 12 Rp 330,000.00 26% 35 Rp 700,000.00
Rp 660,000.00 21 Rp 682,500.00 88% 3
Rp 11,867,400.00 171 Rp 14,706,000.00 100% 0 Rp 1,049,800.00

Rp 33,000.00 20 Rp 40,000.00 91% 2 Rp 3,000.00


Rp 169,600.00 24 Rp 96,000.00 45% 29 Rp 92,800.00
Rp 77,500.00 23 Rp 92,000.00 92% 2 Rp 6,200.00
Rp 780,000.00 67 Rp 670,000.00 67% 33 Rp 102,000.00

Rp 82,800.00 19 Rp 85,500.00 83% 4 Rp 14,400.00


Rp 48,000.00 14 Rp 28,000.00 47% 16 Rp 25,600.00
Rp 175,000.00 20 Rp 140,000.00 80% 16 Rp 5.00
Rp 24,000.00 5 Rp 7,500.00 25% 15 Rp 18,000.00
Rp 96,000.00 4 Rp 20,000.00 17% 20 Rp 80,000.00
Rp 2,122,800.00 62 Rp 1,302,000.00 51% 60 Rp 138,005.00
Rp 14,770,200.00 300 Rp 16,678,000.00 73% 93 Rp 1,289,805.00
HARGA POKOK PROFIT
% STOCK KETERANGAN
PENJUALAN NILAI %

9% Rp 54,000.00 Rp 16,000.00 23% barang laku


36% Rp 612,000.00 Rp 102,000.00 14% cukup laku
8% Rp 27,600.00 Rp 6,900.00 20% laku
74% Rp 240,000.00 Rp 90,000.00 27% tidak laku
13% Rp 577,500.00 Rp 105,000.00 15% cukup laku
25% Rp 11,867,400.00 Rp 319,900.00 20% cukup laku

9% Rp 30,000.00 Rp 10,000.00 25% laku


55% Rp 76,800.00 Rp 19,200.00 20% cukup laku
8% Rp 6,200.00 Rp 85,800.00 93% laku
0% Rp 522,600.00 Rp 115,000.00 46% cukup laku

17% Rp 68,400.00 Rp 17,100.00 20% cukup laku


53% Rp 22,400.00 Rp 5,600.00 20% laku
64% Rp 140,000.00 Rp - 0% tidak laku
75% Rp 6,000.00 Rp 1,500.00 20% tidak laku
83% Rp 16,000.00 Rp 4,000.00 20% cukup laku
0% Rp 1,078,800.00 Rp 28,200.00 16% cukup laku
8% Rp 13,468,800.00 Rp 463,100.00 27% Barang Cukup Laku

You might also like