0% found this document useful (0 votes)
27 views20 pages

Rekapitulasi Danish Raisin 25 GR: Kebutuhan Material

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 20

Rekapitulasi

Danish Raisin 25 gr

No Uraian Banyaknya Unit

1 Kebutuhan Material:
1 Terigu Cakra KE 3.5 kg
2 Yeast Instant 0.0875 kg
3 Gula 0.28 kg
4 Garam 0.07 kg
5 Improver S-500 0.0525 kg
7 Milk Flavoured 0.0245 kg
8 Butter Unsalted 0.175 kg
9 Water 1.05 kg
10 Ice 0.945 kg

TOTAL 6.1845 kg
Bi. Bahan Baku Dough 1 pcs

10 Butter Lactic 25 kg
11 Butter Lactic 25 kg
12 Opal 4 10 kg
13 Butter Australia 4 kg
14 Orlando 0 kg

TOTAL 64 kg
Bi. Bahan Baku Butter 43 pcs

Total Bahan Baku 7 kg

Cost/kg 6.3 kg
Cost/gr 1000 gr

Food Cost Dough 20 gr


Food Cost Fla Olahan 2 gr
Food Cost raisin 3 gr
Total Food Cost 25 gr
Total Food Cost/ Carton 43 Pcs

2 Packaging:
1 Karton Duplex 1.00 pcs
2 Spidol @ 100 x 0.01 pcs
3 Lakban @ 50 x 0.02 pcs
4 Kertas 2.00 pcs
5 Plastik 1.00 pcs
6 Label 3.00 pcs

TOTAL
Bi. Bahan Packaging 1 Pcs

3 Biaya Lain-Lain:

1 Tenaga Kerja: Banyaknya Unit


Polyline 6 Org
Packaging Frozen: 2 Org
Management 3 Org
All Employee 63 Org

TOTAL 74 Org

2 OHP: Banyaknya
Listrik 25 kwh
Promo, dll 267000 /hr
ATK, Dapur, Mntc 500000 /hr
Depresiasi 16000000 /hr

TOTAL

3 Transportasi:

Rp 250.000 / 8 cust./20 Ctn 20 Ctn

GRAND TOTAL PRODUKSI

(Rp)

Harga Jual : 46,750 /kg

Margin 5,430 /kg

Net Margin 13 %
ekapitulasi
h Raisin 25 gr
Kapasitas Optimal / hr

Biaya /kg

(Rp)

(Rp) 20 Ctn
8,600 30,100
50,000 4,375
7,700 2,156
1,800 126
51,000 2,678
205,000 5,023
60,000 10,500
150 158
600 567

384,850 55,682
49,519

85,000 2,125,000
85,000 2,125,000
35,000 350,000
70,000 280,000
13,500 -

288,500 4,880,000
114,375

163,894

26,015
26.0

520
48
72
640
27,532.8

(Rp) PCS
857
7
29
63
214
-

1,170
1,170 229,320

Biaya / Ctn
1,066
310
9,923
2,321

2,724 533,893

Biaya / Ctn
4,095
1,720
860
2,580

9255 1,814,027

Biaya / Ctn
1,042 Pcs

41,320 1,653

(Rp/Ctn) (Rp) / Bulan


7 kg
327,250 9,163,000

38,008 1,064,216
Rekapitulasi
Danish Raisin 35 gr

No Uraian Banyaknya Unit

1 Kebutuhan Material:
1 Terigu Cakra Kembar Emas 50 kg
2 Yeast Instant 1.25 kg
3 Gula 4 kg
4 Garam 1 kg
5 Improver 0.75 kg
6 Butter Unsalted 2.5 kg
7 Water 15 kg
8 Ice 22.5 kg

TOTAL 97 kg
Bi. Bahan Baku Dough 19 pcs

10 Butter Lactic 25 kg
11 Butter Lactic 25 kg
12 Opal 4 10 kg
13 Butter Australia 4 kg
14 Orlando 0 kg

TOTAL 64 kg
Bi. Bahan Baku Butter 43 pcs

Total Bahan Baku 6.5 kg

Cost/kg 8 kg
Cost/gr 1000 gr

Food Cost Dough 22 gr


Food Cost Fla Olahan 2 gr
Food Cost raisin 3 gr
Total Food Cost 27 gr

Total Food Cost/ Carton 200 Pcs


2 Packaging:
1 Karton Duplex 1.00 pcs
2 Spidol @ 100 x 0.01 pcs
3 Lakban @ 50 x 0.02 pcs
4 Kertas 2.00 pcs
5 Plastik 1.00 pcs
6 Label 2.00 pcs

TOTAL
Bi. Bahan Packaging 1 Pcs

3 Biaya Lain-Lain:

1 Tenaga Kerja: Banyaknya Unit


Polyline 6 Org
Oven 2 Org
Packaging Frozen: 2 Org
Management 3 Org
All Employee 63 Org

TOTAL 76 Org

2 OHP: Banyaknya
Listrik 25 kwh
Gas 35 mnt
Promo, dll 267000 /hr
ATK, Dapur, Mntc 500000 /hr
Depresiasi 16000000 /hr

TOTAL

3 Transportasi:

Rp 250.000 / 8 cust./10 Ctn 10 Ctn

GRAND TOTAL PRODUKSI

(Rp) / Ctn

Harga Jual : 299,000 /Ctn


Margin 114,540 /Ctn
Net Margin 62 %
ekapitulasi
sh Raisin 35 gr
Kapasitas Optimal / hr

Biaya /kg

(Rp)

(Rp) 20 Ctn
8,400 420,000
50,000 62,500
7,700 30,800
1,800 1,800
51,000 38,250
52,000 130,000
100 1,500
500 11,250

171,500 696,100
36,637

85,000 2,125,000
85,000 2,125,000
35,000 350,000
70,000 280,000
12,000 -

287,000 4,880,000
114,375

151,012

18,876 151,012
18.9 18,876

415 9,136
40 80
72 216
527 14,237

105,456.5 193,557
(Rp)
8,000
50
200
440
1,500
40

10,230
10,230

Biaya / Ctn
8,267
3,000
2,400
7,692
1,799

23,158

Biaya / Ctn
12,698
6,319
13,333
2,222
6,667

41,240

Biaya / Ctn
4,375

184,460 922

(Rp) / pcs (Rp) / Month

1495 14,950,000

573 5,727,025
Rekapitulasi
Danish Raisin 25 gr

No Uraian Banyaknya Unit

1 Kebutuhan Material:
1 Terigu Cakra Kembar Emas 50 kg
2 Yeast Instant 1.25 kg
3 Gula 4 kg
4 Garam 1 kg
5 Improver 0.75 kg
6 Butter Unsalted 2.5 kg
7 Water 15 kg
8 Ice 22.5 kg

TOTAL 97 kg
Bi. Bahan Baku Dough 19 pcs

10 Butter Lactic 25 kg
11 Butter Lactic 25 kg
12 Opal 4 10 kg
13 Butter Australia 4 kg
14 Orlando 0 kg

TOTAL 64 kg
Bi. Bahan Baku Butter 43 pcs

Total Bahan Baku 6.5 kg

Cost/kg 8 kg
Cost/gr 1000 gr

Food Cost Dough 22 gr


Food Cost Fla Olahan 2 gr
Food Cost raisin 3 gr
Total Food Cost 27 gr

Total Food Cost/ Carton 200 Pcs


2 Packaging:
1 Karton Duplex 1.00 pcs
2 Spidol @ 100 x 0.01 pcs
3 Lakban @ 50 x 0.02 pcs
4 Kertas 2.00 pcs
5 Plastik 1.00 pcs
6 Label 2.00 pcs

TOTAL
Bi. Bahan Packaging 1 Pcs

3 Biaya Lain-Lain:

1 Tenaga Kerja: Banyaknya Unit


Polyline 6 Org
Oven 2 Org
Packaging Frozen: 2 Org
Management 3 Org
All Employee 63 Org

TOTAL 76 Org

2 OHP: Banyaknya
Listrik 25 kwh
Gas 35 mnt
Promo, dll 267000 /hr
ATK, Dapur, Mntc 500000 /hr
Depresiasi 16000000 /hr

TOTAL

3 Transportasi:

Rp 250.000 / 8 cust./10 Ctn 10 Ctn

GRAND TOTAL PRODUKSI

(Rp) / Ctn

Harga Jual : 299,000 /Ctn


Margin 114,540 /Ctn
Net Margin 62 %
ekapitulasi
sh Raisin 25 gr
Kapasitas Optimal / hr

Biaya /kg

(Rp)

(Rp) 20 Ctn
8,400 420,000
50,000 62,500
7,700 30,800
1,800 1,800
51,000 38,250
52,000 130,000
100 1,500
500 11,250

171,500 696,100
36,637

85,000 2,125,000
85,000 2,125,000
35,000 350,000
70,000 280,000
12,000 -

287,000 4,880,000
114,375 76,250

151,012

18,876 151,012
18.9 18,876

415 9,136
40 80
72 216
527 14,237

105,456.5 193,557
(Rp)
8,000
50
200
440
1,500
40

10,230
10,230

Biaya / Ctn
8,267
3,000
2,400
7,692
1,799

23,158

Biaya / Ctn
12,698
6,319
13,333
2,222
6,667

41,240

Biaya / Ctn
4,375

184,460 922

(Rp) / pcs (Rp) / Month

1495 14,950,000

573 5,727,025
Rekapitulasi
Danish Coklat Frozen 25 gr

No Uraian Banyaknya Unit

1 Kebutuhan Material:
1 Terigu Cakra Kembar Emas 50 kg
2 Yeast Instant 1.25 kg
3 Gula 4 kg
4 Garam 1 kg
5 Improver 0.75 kg
6 Butter Unsalted 2.5 kg
7 Water 15 kg
8 Ice 22.5 kg

TOTAL 97 kg
Bi. Bahan Baku Dough 19 pcs

9 Butter Lactic 25 kg
10 Butter Lactic 25 kg
11 Opal 4 10 kg
12 Butter Australia 4 kg

TOTAL 64 kg
Bi. Bahan Baku Butter 43 pcs

Total Bahan Baku 6.5 kg

Cost/kg 6.5 kg
Cost/gr 8000 gr

Food Cost Dough 24 gr


Food Cost choc. Stick 4 gr
Total Food Cost 28 gr

Total Food Cost/ Carton 200 Pcs

2 Packaging:
1 Karton Duplex 1.00 pcs
2 Spidol @ 100 x 0.01 pcs
3 Lakban @ 50 x 0.02 pcs
4 Kertas 30.00 pcs
5 Plastik 1.00 pcs
6 Label 2.00 pcs

TOTAL
Bi. Bahan Packaging 1 Pcs

3 Biaya Lain-Lain:

1 Tenaga Kerja: Banyaknya Unit


Polyline 6 Org
Packaging Frozen: 2 Org
Management 3 Org
All Employee 63 Org

TOTAL 74 Org

2 OHP: Banyaknya
Listrik 25 kwh
Promo, dll 267000 /hr
ATK, Dapur, Mntc 500000 /hr
Depresiasi 16000000 /hr

TOTAL

3 Transportasi:

Rp 250.000 / 8 cust./20 Ctn 10 Ctn

GRAND TOTAL PRODUKSI

(Rp)

Harga Jual : 306,130 /Ctn


Margin 101,067 /Ctn
Net Margin 49 %
Rekapitulasi
h Coklat Frozen 25 gr
Kapasitas Optimal / hr

Biaya /kg

(Rp)

(Rp) 20 Ctn
8,400 420,000
50,000 62,500
7,700 30,800
1,800 1,800
51,000 38,250
52,000 130,000
100 1,500
500 11,250

171,500 696,100
36,599

85,000 2,125,000
85,000 2,125,000
35,000 350,000
70,000 280,000

275,000 4,880,000
114,375

150,974

23,227 150,974
23.2 185,814

557 13,379
260 1,040
817 22,888

163,488.5 374,095

(Rp)
9,000
50
200
6,600
1,500
40

17,390
17,390

Biaya / Ctn
7,200
358
1,456
5,896

14,910

Biaya / Ctn
953
445
834
2,667

4,899

Biaya / Ctn
4,375

205,063

(Rp)
Harga Disc. 25%
229,598

24,535

12
Rekapitulasi
Danish Coklat Frozen 25 gr

No Uraian Banyaknya Unit Biaya /kg

1 Kebutuhan Material: (Rp)


1 TELUR AYAM 187,5 kg 1,188
2 ROYCO 0,02 KG 500
AIR 10,54 527
TEPUNG 0,04 8,000

TOTAL 0 kg 10,215
Bi. Bahan Baku Dough 0 pcs #DIV/0!

9 Butter Lactic 25 kg 85,000


10 Butter Lactic 25 kg 85,000
11 Opal 4 10 kg 35,000
12 Butter Australia 4 kg 70,000
TOTAL 64 kg 275,000
Bi. Bahan Baku Butter 43 pcs 114,375
Total Bahan Baku 6.5 kg #DIV/0!

Cost/kg 6.5 kg #DIV/0!


Cost/gr 8000 gr #DIV/0!
Food Cost Dough 24 gr #DIV/0!
Food Cost choc. Stick 4 gr 260
Total Food Cost 28 gr #DIV/0!
Total Food Cost/ Carton 200 Pcs #DIV/0!
2 Packaging: (Rp)
1 Karton Duplex 1.00 pcs 9,000
2 Spidol @ 100 x 0.01 pcs 50
3 Lakban @ 50 x 0.02 pcs 200
4 Kertas 30.00 pcs 6,600
5 Plastik 1.00 pcs 1,500
6 Label 2.00 pcs 40
TOTAL 17,390
Bi. Bahan Packaging 1 Pcs 17,390
3 Biaya Lain-Lain:
1 Tenaga Kerja: Banyaknya Unit Biaya / Ctn
Polyline 6 Org 7,200
Packaging Frozen: 2 Org 358
Management 3 Org 1,456
All Employee 63 Org 5,896
TOTAL 74 Org 14,910

2 OHP: Banyaknya Biaya / Ctn


Listrik 25 kwh 953
Promo, dll 267000 /hr 445
ATK, Dapur, Mntc 500000 /hr 834
Depresiasi 16000000 /hr 2,667
TOTAL 4,899

3 Transportasi:
Biaya / Ctn
Rp 250.000 / 8 cust./20 Ctn 10 Ctn 4,375
GRAND TOTAL PRODUKSI #DIV/0!

(Rp)
Harga Disc. 25%
Harga Jual : 306,130 /Ctn 229,598
Margin #DIV/0! /Ctn #DIV/0!
Net Margin #DIV/0! % #DIV/0!
5 gr

Kapasitas Optimal / hr
(Rp)
20 Ctn
222,750
#VALUE!
#VALUE! 10,215*12
#VALUE! =

228,635

2,125,000
2,125,000
350,000
280,000
4,880,000

#DIV/0!
#DIV/0!
#DIV/0!
1,040
#DIV/0!
#DIV/0!
Ø

(Rp)

You might also like