Helados de frutas con Royal Cream .xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2						HELADO DE CREMA ROYAL CON FRESAS FRESAS 38%								INSUMO Soles x kg	TOTAL INSUMOS S/
3	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	1000
4						AGUA	31.80%	-	0	0	0	0	318.00		S/.0.00
5		100		100	100	AZUCAR BLANCA	11.30%	-	11.3	0	11.3	11.3	113.00	S/.3.50	S/.0.40
6	19.8	7.7	69.7	100	30.6	ROYAL CREAM 50	3.30%	0.65	0.2541	2.3001	3.3	1.0098	33.00	S/.73.90	S/.2.44
7	27	9.72	70	100	35	LECHE EN POLVO ENTERA	12.50%	3.38	1.215	8.75	12.5	4.375	125.00	S/.25.42	S/.3.18
8		70		100	190	DEXTROZA	3.00%	-	2.1	0	3	5.7	30.00	S/.8.47	S/.0.25
9		8		19	8	FRESAS	38.00%	-	3.04	0	7.22	3.04	380.00	S/.6.00	S/.2.28
10						SAL	0.10%						1.00
11						TOTALES	100.00%	4.03	17.9091	11.0501	37.32	25.4248	999.00	Costo / kg de	S/.8.55
12
13						HELADO DE CREMA ROYAL CON FRESAS								INSUMO Soles x kg	TOTAL INSUMOS S/
14	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	1750
15						AGUA	32.50%	-	0	0	0	0	568.75		S/.0.00
16		100		100	100	AZUCAR BLANCA	10.00%	-	10	0	10	10	175.00	S/.3.50	S/.0.35
17	19.8	7.7	69.7	100	30.6	ROYAL CREAM 50	3.30%	0.65	0.2541	2.3001	3.3	1.0098	57.75	S/.73.90	S/.2.44
18	27	9.72	70	100	35	LECHE EN POLVO ENTERA	12.00%	3.24	1.1664	8.4	12	4.2	210.00	S/.25.42	S/.3.05
19		70		100	190	DEXTROZA	3.00%	-	2.1	0	3	5.7	52.50	S/.8.47	S/.0.25
20		85.8		67	85.54	PASTA AROMATIZANTE DE FRESAS	1.20%	-	1.0296	0	0.804	1.02648	21.00	S/.70.83	S/.0.85
21		8		19	8	FRESAS	38.00%	-	3.04	0	7.22	3.04	665.00	S/.6.00	S/.2.28
22						TOTALES	100.00%	3.89	17.5901	10.7001	36.324	24.97628	1,750.00	Costo / kg de	S/.9.22
23
24						HELADOS DE FRUTOS ROJOS JOYBASE ROYAL CREAM								INSUMO Soles x kg	TOTAL INSUMOS S/
25	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	1500
26						AGUA	32.10%	-	0	0	0	0	481.50		S/.0.00
27		100		100	100	AZUCAR BLANCA	9.00%	-	9	0	9	9	135.00	S/.3.50	S/.0.32
28	19.8	7.7	69.7	100	30.6	ROYAL CREAM 50	3.30%	0.65	0.2541	2.3001	3.3	1.0098	49.50	S/.73.90	S/.2.44
29	27	9.72	70	100	35	LECHE EN POLVO ENTERA	12.00%	3.24	1.1664	8.4	12	4.2	180.00	S/.25.42	S/.3.05
30		70		100	190	DEXTROSA	3.00%	-	2.1	0	3	5.7	45.00	S/.8.47	S/.0.25
31		85.8		67	85.54	PASTA DE FRAMBUESAS JOYGELATO	2.50%	-	2.145	0	1.675	2.1385	37.50	S/.70.83	S/.1.77
32		9		18	9	ARANDANOS	7.60%	-	0.684	0	1.368	0.684	114.00	S/.15.00	S/.1.14
33		8		15	8	FRAMBUESAS	11.40%	-	0.912	0	1.71	0.912	171.00	S/.50.00	S/.5.70
34		8		19	8	FRESAS	19.00%	-	1.52	0	3.61	1.52	285.00	S/.6.00	S/.1.14
35						SAL	0.10%						1.50
36						TOTALES	100.00%	3.89	17.7815	10.7001	35.663	25.1643	1,500.00	Costo / kg de	S/.15.81
37						* PASSION CREAM PARA ESTA RECETA 58 gr
38						*SEMBRAR 150 gr DE CEREZAS CONFITADAS
39
40						HELADO DE CREMA ROYAL DE CHIRIMOYA								INSUMO Soles x kg	TOTAL INSUMOS S/
41	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	1000
42						AGUA	35.70%	-	0	0	0	0	357.00		S/.0.00
43		100		100	100	AZUCAR BLANCA	12.00%	-	12	0	12	12	120.00	S/.2.58	S/.0.31
44	19.8	7.7	69.7	100	30.6	ROYAL CREAM 50	3.30%	0.65	0.2541	2.3001	3.3	1.0098	33.00	S/.73.90	S/.2.44
45	27	9.72	70	100	35	LECHE EN POLVO ENTERA	12.00%	3.24	1.1664	8.4	12	4.2	120.00	S/.25.42	S/.3.05
46		70		100	190	DEXTROZA	2.00%	-	1.4	0	2	3.8	20.00	S/.8.47	S/.0.17
47		8		19	8	CHIRIMOYA	35.00%	-	2.8	0	6.65	2.8	350.00		S/.0.00
48						TOTALES	100.00%	3.89	17.6205	10.7001	35.95	23.8098	1,000.00	Costo / kg de	S/.5.97
49
50						HELADO DE CREMA ROYAL DE LUCUMA LUCUMA 38%								INSUMO Soles x kg	TOTAL INSUMOS S/
51	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	1000
52						AGUA	39.80%	-	0	0	0	0	398.00		S/.0.00
53		100		100	100	AZUCAR BLANCA	5.00%	-	5	0	5	5	50.00	S/.2.58	S/.0.13
54	19.8	7.7	69.7	100	30.6	ROYAL CREAM 50	3.30%	0.65	0.2541	2.3001	3.3	1.0098	33.00	S/.73.90	S/.2.44
55	28.8	9.72	70	100	35	LECHE EN POLVO ENTERA	10.90%	3.14	1.05948	7.63	10.9	3.815	109.00	S/.25.42	S/.2.77
56		70		100	190	DEXTROZA	3.00%	-	2.1	0	3	5.7	30.00	S/.8.47	S/.0.25
57		24		29	24	LUCUMA	38.00%	-	9.12	0	11.02	9.12	380.00	S/.8.00	S/.3.04
58						TOTALES	100.00%	3.79	17.53358	9.9301	33.22	24.6448	1,000.00	Costo / kg de	S/.8.63
59		67.9
60						HELADO DE CREMA ROYAL DE LUCUMA LUCUMA 40%								INSUMO Soles x kg	TOTAL INSUMOS S/
61	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	1000
62						AGUA	37.70%	-	0	0	0	0	377.00
63		100		100	100	AZUCAR BLANCA	4.50%	-	4.5	0	4.5	4.5	45.00	S/.2.58
64	19.8	7.7	69.7	100	30.6	ROYAL CREAM 50	3.30%	0.65	0.2541	2.3001	3.3	1.0098	33.00	S/.73.90
65	28.8	9.72	70	100	35	LECHE EN POLVO ENTERA	11.50%	3.31	1.1178	8.05	11.5	4.025	115.00	S/.25.42
66		70		100	190	AZUCAR INVERTIDA	3.00%	-	2.1	0	3	5.7	30.00	S/.11.02
67		24		29	24	LUCUMA	40.00%	-	9.6	0	11.6	9.6	400.00
68						TOTALES	100.00%	3.97	17.5719	10.3501	33.9	24.8348	1,000.00	Costo / kg de
69
70						HELADO DE CREMA ROYAL DE ARANDANOS								INSUMO Soles x kg	TOTAL INSUMOS S/
71	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	1300
72						AGUA	38.50%	-	-	-	-	-	500.50		S/.0.00
73		100		100	100	AZUCAR BLANCA	12.20%	-	12.20	-	12.20	12.20	158.60	S/.2.58	S/.0.31
74	19.8	7.7		100	30.6	ROYAL CREAM 50	3.30%	0.65	0.25	-	3.30	1.01	42.90	S/.73.90	S/.2.44
75	27	9.72	70	100	35	LECHE EN POLVO ENTERA	10.00%	2.70	0.97	7.00	10.00	3.50	130.00	S/.25.42	S/.2.54
76		70		100	190	DEXTROZA	2.00%	-	1.40	-	2.00	3.80	26.00	S/.8.47	S/.0.17
77		8		15	10	ARANDANOS	34.00%	-	2.72	-	5.10	3.40	442.00	S/.10.00	S/.3.40
78						TOTALES	100.00%	3.35	17.55	7.00	32.60	23.91	1,300.00	Costo / kg de	S/.8.86
79
80						HELADO DE CREMA ROYAL DE ARANDANOS								INSUMO Soles x kg	TOTAL INSUMOS S/
81	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	1500
82						AGUA	37.70%	-	0	0	0	0	565.50		S/.0.00
83		100		100	100	AZUCAR BLANCA	11.00%	-	11	0	11	11	165.00	S/.2.58	S/.0.28
84	19.8	7.7		100	30.6	ROYAL CREAM 50	3.30%	0.65	0.2541	0	3.3	1.0098	49.50	S/.73.90	S/.2.44
85	27	9.72	70	100	35	LECHE EN POLVO ENTERA	10.00%	2.70	0.972	7	10	3.5	150.00	S/.25.42	S/.2.54
86		70		100	190	DEXTROZA	2.00%	-	1.4	0	2	3.8	30.00	S/.8.47	S/.0.17
87		8		15	10	ARANDANOS	34.00%	-	2.72	0	5.1	3.4	510.00	S/.10.00	S/.3.40
88		65		65	65	JOYPASTE FRESAS o FRUTOS DEL BOSQUE	2.00%	-	1.3	0	1.3	1.3	30.00	S/.67.00	S/.1.34
89						TOTALES	100.00%	3.35	17.65	7.00	32.70	24.01	1,500.00	Costo / kg de	S/.10.17
90
91
92						HELADO DE CREMA ROYAL DE MARACUYA MARACUYA 20%								INSUMO Soles x kg	TOTAL INSUMOS S/
93	MG	POD	LPD	ST	PAC	PRODUCIR ( gr ) >>>>>	%	MG	DULZOR	LPD	ST	PAC	2000
94						AGUA	51.70%	-	0	0	0	0	1,034.00		S/.0.00
95		100		100	100	AZUCAR BLANCA	13.00%	-	13	0	13	13	260.00	S/.2.58	S/.0.34
96	19.8	7.7		100	30.6	ROYAL CREAM 50	3.30%	0.65	0.2541	0	3.3	1.0098	66.00	S/.73.90	S/.2.44
97	27	9.72	70	100	35	LECHE EN POLVO ENTERA	10.00%	2.70	0.972	7	10	3.5	200.00	S/.25.42	S/.2.54
98		70		100	190	DEXTROZA	2.00%	-	1.4	0	2	3.8	40.00	S/.8.47	S/.0.17
99													-		S/.0.00
100		10		20	10	MARACUYA	20.00%	-	2	0	4	2	400.00	S/.10.00	S/.2.00