Presupuesto Maestro

Enero
11% 7%
Presupuesto de Ingresos Presupuestado Real
Presupuesto de ventas Matriz 634,608.98 369,227.25
Sucursal 1 276,212.48 129,323.25
Sucursal 2 282,391.73 121,826.25
Total presupuesto de ventas 1,193,213.18 620,376.75
Presupuesto otros ingresos
Prestamo bancario 1
Prestamo bancario 2
Aumento de capital
Total presupuesto otros ingresos
Total presupuesto de ingresos 1,193,213.18 620,376.75
Presupuesto costo de producción matriz
Materia prima 52,100.00 57,873.00
Mano de obra 39,075.00 44,121.00
Gastos indirectos de fabricación 20,840.00 21,774.00
Total presupuesto costo de producción matriz 112,015.00 123,768.00
Presupuesto costo de producción Sucursal 1
Materia prima 20,900.00 19,998.00
Mano de obra 15,675.00 15,246.00
Total presupuesto costo de producción Sucursal 1 44,935.00 42,768.00
Presupuesto costo de producción Sucursal 2
Materia prima 20,700.00 16,665.00
Mano de obra 15,525.00 12,705.00
Total presupuesto costo de producción Sucursal 2 44,505.00 35,640.00
Total presupuesto de costo de producción 201,455.00 202,176.00
Presupuesto de Gastos de Ventas y Administración matriz
Sueldos 22,000.00 25,000.00
Renta 9,000.00 9,200.00
Previción social 4,100.00 3,800.00
Servicios 3,500.00 3,300.00
Combustible 1,000.00 1,200.00
Papeleria 1,300.00 1,260.00
Total presupuesto de Gastos de Venta y Administración matriz 40,900.00 43,760.00
Presupuesto de Gastos de Ventas y Administración Sucursal 1
Sueldos 11,000.00 12,000.00
Renta 3,500.00 3,700.00
Previción social 1,100.00 1,300.00
Servicios 3,000.00 2,800.00
Combustible 800.00 1,000.00
Papeleria 830.00 800.00
Total presupuesto de Gastos de Venta y Administración sucursal 1 20,230.00 21,600.00
Presupuesto de Gastos de Ventas y Administración Sucursal 2
Sueldos 9,000.00 10,000.00
Renta 3,000.00 3,000.00
Previción social 980.00 1,100.00
Servicios 3,000.00 3,100.00
Combustible 750.00 850.00
Papeleria 900.00 750.00
Total presupuesto de Gastos de Venta y Administración sucursal 2 17,630.00 18,800.00
Total presupuesto de Gastos de ventas y administración 78,760.00 84,160.00
Presupuesto de gastos financieros
Prestamo bancario 1
Prestamo bancario 2
Total presupuesto de gastos financieros
Utilidad antes de Impuestos
Presupuesto de ISR
Presupuesto de PTU
Utilidad del ejercicio
Enero Febrero
11% 8%
Acumulado presupuestado Acumulado real Variación Presupuestado Real
634,608.98 369,227.25 - 265,381.73 634,608.98 421,974.00
276,212.48 129,323.25 - 146,889.23 276,212.48 147,798.00
282,391.73 121,826.25 - 160,565.48 282,391.73 139,230.00
1,193,213.18 620,376.75 - 572,836.43 1,193,213.18 709,002.00
1,193,213.18 620,376.75 - 572,836.43 1,193,213.18 709,002.00
52,100.00 57,873.00 - 5,773.00 52,100.00 57,873.00

39,075.00 44,121.00 - 5,046.00 39,075.00 44,121.00
20,840.00 21,774.00 - 934.00 20,840.00 21,774.00
112,015.00 123,768.00 - 11,753.00 112,015.00 123,768.00
20,900.00 19,998.00 902.00 20,900.00 19,998.00

15,675.00 15,246.00 429.00 15,675.00 15,246.00
8,360.00 7,524.00 836.00 8,360.00 7,524.00
44,935.00 42,768.00 2,167.00 44,935.00 42,768.00
20,700.00 16,665.00 4,035.00 20,700.00 16,665.00

15,525.00 12,705.00 2,820.00 15,525.00 12,705.00
8,280.00 6,270.00 2,010.00 8,280.00 6,270.00
44,505.00 35,640.00 8,865.00 44,505.00 35,640.00
201,455.00 202,176.00 - 721.00 201,455.00 202,176.00
22,000.00 25,000.00 - 3,000.00 22,000.00 25,000.00

9,000.00 9,200.00 - 200.00 9,000.00 9,200.00
4,100.00 3,800.00 300.00 4,100.00 3,800.00
3,500.00 3,300.00 200.00 3,500.00 3,300.00
1,000.00 1,200.00 - 200.00 1,000.00 1,200.00
1,300.00 1,260.00 40.00 1,300.00 1,260.00
40,900.00 43,760.00 - 2,860.00 40,900.00 43,760.00
11,000.00 12,000.00 - 1,000.00 11,000.00 12,000.00

3,500.00 3,700.00 - 200.00 3,500.00 3,700.00
1,100.00 1,300.00 - 200.00 1,100.00 1,300.00
3,000.00 2,800.00 200.00 3,000.00 2,800.00
800.00 1,000.00 - 200.00 800.00 1,000.00
830.00 800.00 30.00 830.00 800.00
20,230.00 21,600.00 - 1,370.00 20,230.00 21,600.00
9,000.00 10,000.00 - 1,000.00 9,000.00 10,000.00
3,000.00 3,000.00 - 3,000.00 3,000.00
980.00 1,100.00 - 120.00 980.00 1,100.00
3,000.00 3,100.00 - 100.00 3,000.00 3,100.00
750.00 850.00 - 100.00 750.00 850.00
900.00 750.00 150.00 900.00 750.00
17,630.00 18,800.00 - 1,170.00 17,630.00 18,800.00
78,760.00 84,160.00 - 5,400.00 78,760.00 84,160.00
Febrero Marzo
6% 8%
1,269,217.95 791,201.25 - 478,016.70 346,150.35 421,974.00
552,424.95 277,121.25 - 275,303.70 150,661.35 147,798.00
564,783.45 261,056.25 - 303,727.20 154,031.85 139,230.00
2,386,426.35 1,329,378.75 - 1,057,047.60 650,843.55 709,002.00
500,000.00 700,000.00 200,000.00
500,000.00 700,000.00 200,000.00

2,886,426.35 2,029,378.75 - 857,047.60 650,843.55 709,002.00
104,200.00 115,746.00 - 11,546.00 52,100.00 57,873.00

78,150.00 88,242.00 - 10,092.00 39,075.00 44,121.00
41,680.00 43,548.00 - 1,868.00 20,840.00 21,774.00
224,030.00 247,536.00 - 23,506.00 112,015.00 123,768.00
41,800.00 39,996.00 1,804.00 20,900.00 19,998.00

31,350.00 30,492.00 858.00 15,675.00 15,246.00
16,720.00 15,048.00 1,672.00 8,360.00 7,524.00
89,870.00 85,536.00 4,334.00 44,935.00 42,768.00
41,400.00 33,330.00 8,070.00 20,700.00 16,665.00

31,050.00 25,410.00 5,640.00 15,525.00 12,705.00
16,560.00 12,540.00 4,020.00 8,280.00 6,270.00
89,010.00 71,280.00 17,730.00 44,505.00 35,640.00
402,910.00 404,352.00 - 1,442.00 201,455.00 202,176.00
44,000.00 50,000.00 - 6,000.00 22,000.00 25,000.00

18,000.00 18,400.00 - 400.00 9,000.00 9,200.00
8,200.00 7,600.00 600.00 4,100.00 3,800.00
7,000.00 6,600.00 400.00 3,500.00 3,300.00
2,000.00 2,400.00 - 400.00 1,000.00 1,200.00
2,600.00 2,520.00 80.00 1,300.00 1,260.00
81,800.00 87,520.00 - 5,720.00 40,900.00 43,760.00
22,000.00 24,000.00 - 2,000.00 11,000.00 12,000.00

7,000.00 7,400.00 - 400.00 3,500.00 3,700.00
2,200.00 2,600.00 - 400.00 1,100.00 1,300.00
6,000.00 5,600.00 400.00 3,000.00 2,800.00
1,600.00 2,000.00 - 400.00 800.00 1,000.00
1,660.00 1,600.00 60.00 830.00 800.00
40,460.00 43,200.00 - 2,740.00 20,230.00 21,600.00
18,000.00 20,000.00 - 2,000.00 9,000.00 10,000.00
6,000.00 6,000.00 - 3,000.00 3,000.00
1,960.00 2,200.00 - 240.00 980.00 1,100.00
6,000.00 6,200.00 - 200.00 3,000.00 3,100.00
1,500.00 1,700.00 - 200.00 750.00 850.00
1,800.00 1,500.00 300.00 900.00 750.00
35,260.00 37,600.00 - 2,340.00 17,630.00 18,800.00
157,520.00 168,320.00 - 10,800.00 78,760.00 84,160.00
14,166.67 17,500.00
14,166.67 17,500.00
Marzo Abril
6% 7%
1,615,368.30 1,213,175.25 - 402,193.05 346,150.35 369,227.25
703,086.30 424,919.25 - 278,167.05 150,661.35 129,323.25
718,815.30 400,286.25 - 318,529.05 154,031.85 121,826.25
3,037,269.90 2,038,380.75 - 998,889.15 650,843.55 620,376.75
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
900,000.00 900,000.00 -
3,937,269.90 2,938,380.75 - 998,889.15 650,843.55 620,376.75
156,300.00 173,619.00 - 17,319.00 52,100.00 57,873.00

117,225.00 132,363.00 - 15,138.00 39,075.00 44,121.00
62,520.00 65,322.00 - 2,802.00 20,840.00 21,774.00
336,045.00 371,304.00 - 35,259.00 112,015.00 123,768.00
62,700.00 59,994.00 2,706.00 20,900.00 19,998.00

47,025.00 45,738.00 1,287.00 15,675.00 15,246.00
25,080.00 22,572.00 2,508.00 8,360.00 7,524.00
134,805.00 128,304.00 6,501.00 44,935.00 42,768.00
62,100.00 49,995.00 12,105.00 20,600.00 16,665.00

46,575.00 38,115.00 8,460.00 15,450.00 12,705.00
24,840.00 18,810.00 6,030.00 8,240.00 6,270.00
133,515.00 106,920.00 26,595.00 44,290.00 35,640.00
604,365.00 606,528.00 - 2,163.00 201,240.00 202,176.00
66,000.00 75,000.00 - 9,000.00 22,000.00 25,000.00

27,000.00 27,600.00 - 600.00 9,000.00 9,200.00
12,300.00 11,400.00 900.00 4,100.00 3,800.00
10,500.00 9,900.00 600.00 3,500.00 3,300.00
3,000.00 3,600.00 - 600.00 1,000.00 1,200.00
3,900.00 3,780.00 120.00 1,300.00 1,260.00
122,700.00 131,280.00 - 8,580.00 40,900.00 43,760.00
33,000.00 36,000.00 - 3,000.00 11,000.00 12,000.00

10,500.00 11,100.00 - 600.00 3,500.00 3,700.00
3,300.00 3,900.00 - 600.00 1,100.00 1,300.00
9,000.00 8,400.00 600.00 3,000.00 2,800.00
2,400.00 3,000.00 - 600.00 800.00 1,000.00
2,490.00 2,400.00 90.00 830.00 800.00
60,690.00 64,800.00 - 4,110.00 20,230.00 21,600.00
27,000.00 30,000.00 - 3,000.00 9,000.00 10,000.00
9,000.00 9,000.00 - 3,000.00 3,000.00
2,940.00 3,300.00 - 360.00 980.00 1,100.00
9,000.00 9,300.00 - 300.00 3,000.00 3,100.00
2,250.00 2,550.00 - 300.00 750.00 850.00
2,700.00 2,250.00 450.00 900.00 750.00
52,890.00 56,400.00 - 3,510.00 17,630.00 18,800.00
236,280.00 252,480.00 - 16,200.00 78,760.00 84,160.00
14,166.67 17,500.00 - 3,333.33 14,166.67 17,500.00

11,333.33 5,000.00
14,166.67 17,500.00 - 3,333.33 25,500.00 22,500.00
Abril Mayo
7% 6%
1,961,518.65 1,582,402.50 - 379,116.15 403,842.08 316,480.50
853,747.65 554,242.50 - 299,505.15 175,771.58 110,848.50
872,847.15 522,112.50 - 350,734.65 179,703.83 104,422.50
3,688,113.45 2,658,757.50 - 1,029,355.95 759,317.48 531,751.50
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
900,000.00 900,000.00 -
4,588,113.45 3,558,757.50 - 1,029,355.95 759,317.48 531,751.50
208,400.00 231,492.00 - 23,092.00 52,100.00 57,873.00

156,300.00 176,484.00 - 20,184.00 39,075.00 44,121.00
83,360.00 87,096.00 - 3,736.00 20,840.00 21,774.00
448,060.00 495,072.00 - 47,012.00 112,015.00 123,768.00
83,600.00 79,992.00 3,608.00 20,800.00 19,998.00

62,700.00 60,984.00 1,716.00 15,600.00 15,246.00
33,440.00 30,096.00 3,344.00 8,320.00 7,524.00
179,740.00 171,072.00 8,668.00 44,720.00 42,768.00
82,700.00 66,660.00 16,040.00 20,600.00 16,665.00

62,025.00 50,820.00 11,205.00 15,450.00 12,705.00
33,080.00 25,080.00 8,000.00 8,240.00 6,270.00
177,805.00 142,560.00 35,245.00 44,290.00 35,640.00
805,605.00 808,704.00 - 3,099.00 201,025.00 202,176.00
88,000.00 100,000.00 - 12,000.00 22,000.00 25,000.00

36,000.00 36,800.00 - 800.00 9,000.00 9,200.00
16,400.00 15,200.00 1,200.00 4,100.00 3,800.00
14,000.00 13,200.00 800.00 3,500.00 3,300.00
4,000.00 4,800.00 - 800.00 1,000.00 1,200.00
5,200.00 5,040.00 160.00 1,300.00 1,260.00
163,600.00 175,040.00 - 11,440.00 40,900.00 43,760.00
44,000.00 48,000.00 - 4,000.00 11,000.00 12,000.00

14,000.00 14,800.00 - 800.00 3,500.00 3,700.00
4,400.00 5,200.00 - 800.00 1,100.00 1,300.00
12,000.00 11,200.00 800.00 3,000.00 2,800.00
3,200.00 4,000.00 - 800.00 800.00 1,000.00
3,320.00 3,200.00 120.00 830.00 800.00
80,920.00 86,400.00 - 5,480.00 20,230.00 21,600.00
36,000.00 40,000.00 - 4,000.00 9,000.00 10,000.00
12,000.00 12,000.00 - 3,000.00 3,000.00
3,920.00 4,400.00 - 480.00 980.00 1,100.00
12,000.00 12,400.00 - 400.00 3,000.00 3,100.00
3,000.00 3,400.00 - 400.00 750.00 850.00
3,600.00 3,000.00 600.00 900.00 750.00
70,520.00 75,200.00 - 4,680.00 17,630.00 18,800.00
315,040.00 336,640.00 - 21,600.00 78,760.00 84,160.00
28,333.33 35,000.00 - 6,666.67 14,166.67 17,500.00

11,333.33 5,000.00 6,333.33 11,333.33 5,000.00
39,666.67 40,000.00 - 333.33 25,500.00 22,500.00
Mayo Junio
7% 9%
2,365,360.73 1,898,883.00 - 466,477.73 403,842.08 474,720.75
1,029,519.23 665,091.00 - 364,428.23 175,771.58 166,272.75
1,052,550.98 626,535.00 - 426,015.98 179,703.83 156,633.75
4,447,430.93 3,190,509.00 - 1,256,921.93 759,317.48 797,627.25
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
900,000.00 900,000.00 -
5,347,430.93 4,090,509.00 - 1,256,921.93 759,317.48 797,627.25
260,500.00 289,365.00 - 28,865.00 52,100.00 57,873.00

195,375.00 220,605.00 - 25,230.00 39,075.00 44,121.00
104,200.00 108,870.00 - 4,670.00 20,840.00 21,774.00
560,075.00 618,840.00 - 58,765.00 112,015.00 123,768.00
104,400.00 99,990.00 4,410.00 20,800.00 19,998.00

78,300.00 76,230.00 2,070.00 15,600.00 15,246.00
41,760.00 37,620.00 4,140.00 8,320.00 7,524.00
224,460.00 213,840.00 10,620.00 44,720.00 42,768.00
103,300.00 83,325.00 19,975.00 20,600.00 16,665.00

77,475.00 63,525.00 13,950.00 15,450.00 12,705.00
41,320.00 31,350.00 9,970.00 8,240.00 6,270.00
222,095.00 178,200.00 43,895.00 44,290.00 35,640.00
1,006,630.00 1,010,880.00 - 4,250.00 201,025.00 202,176.00
110,000.00 125,000.00 - 15,000.00 22,000.00 25,000.00

45,000.00 46,000.00 - 1,000.00 9,000.00 9,200.00
20,500.00 19,000.00 1,500.00 4,100.00 3,800.00
17,500.00 16,500.00 1,000.00 3,500.00 3,300.00
5,000.00 6,000.00 - 1,000.00 1,000.00 1,200.00
6,500.00 6,300.00 200.00 1,300.00 1,260.00
204,500.00 218,800.00 - 14,300.00 40,900.00 43,760.00
55,000.00 60,000.00 - 5,000.00 11,000.00 12,000.00

17,500.00 18,500.00 - 1,000.00 3,500.00 3,700.00
5,500.00 6,500.00 - 1,000.00 1,100.00 1,300.00
15,000.00 14,000.00 1,000.00 3,000.00 2,800.00
4,000.00 5,000.00 - 1,000.00 800.00 1,000.00
4,150.00 4,000.00 150.00 830.00 800.00
101,150.00 108,000.00 - 6,850.00 20,230.00 21,600.00
45,000.00 50,000.00 - 5,000.00 9,000.00 10,000.00
15,000.00 15,000.00 - 3,000.00 3,000.00
4,900.00 5,500.00 - 600.00 980.00 1,100.00
15,000.00 15,500.00 - 500.00 3,000.00 3,100.00
3,750.00 4,250.00 - 500.00 750.00 850.00
4,500.00 3,750.00 750.00 900.00 750.00
88,150.00 94,000.00 - 5,850.00 17,630.00 18,800.00
393,800.00 420,800.00 - 27,000.00 78,760.00 84,160.00
42,500.00 52,500.00 - 10,000.00 14,166.67 17,500.00

22,666.67 10,000.00 12,666.67 11,333.33 5,000.00
65,166.67 62,500.00 2,666.67 25,500.00 22,500.00
Junio Julio
8% 10%
2,769,202.80 2,373,603.75 - 395,599.05 461,533.80 527,467.50
1,205,290.80 831,363.75 - 373,927.05 200,881.80 184,747.50
1,232,254.80 783,168.75 - 449,086.05 205,375.80 174,037.50
5,206,748.40 3,988,136.25 - 1,218,612.15 867,791.40 886,252.50
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
900,000.00 900,000.00 -
6,106,748.40 4,888,136.25 - 1,218,612.15 867,791.40 886,252.50
312,600.00 347,238.00 - 34,638.00 52,100.00 57,873.00

234,450.00 264,726.00 - 30,276.00 39,075.00 44,121.00
125,040.00 130,644.00 - 5,604.00 20,840.00 21,774.00
672,090.00 742,608.00 - 70,518.00 112,015.00 123,768.00
125,200.00 119,988.00 5,212.00 20,800.00 19,998.00

93,900.00 91,476.00 2,424.00 15,600.00 15,246.00
50,080.00 45,144.00 4,936.00 8,320.00 7,524.00
269,180.00 256,608.00 12,572.00 44,720.00 42,768.00
123,900.00 99,990.00 23,910.00 20,600.00 16,665.00

92,925.00 76,230.00 16,695.00 15,450.00 12,705.00
49,560.00 37,620.00 11,940.00 8,240.00 6,270.00
266,385.00 213,840.00 52,545.00 44,290.00 35,640.00
1,207,655.00 1,213,056.00 - 5,401.00 201,025.00 202,176.00
132,000.00 150,000.00 - 18,000.00 22,000.00 25,000.00

54,000.00 55,200.00 - 1,200.00 9,000.00 9,200.00
24,600.00 22,800.00 1,800.00 4,100.00 3,800.00
21,000.00 19,800.00 1,200.00 3,500.00 3,300.00
6,000.00 7,200.00 - 1,200.00 1,000.00 1,200.00
7,800.00 7,560.00 240.00 1,300.00 1,260.00
245,400.00 262,560.00 - 17,160.00 40,900.00 43,760.00
66,000.00 72,000.00 - 6,000.00 11,000.00 12,000.00

21,000.00 22,200.00 - 1,200.00 3,500.00 3,700.00
6,600.00 7,800.00 - 1,200.00 1,100.00 1,300.00
18,000.00 16,800.00 1,200.00 3,000.00 2,800.00
4,800.00 6,000.00 - 1,200.00 800.00 1,000.00
4,980.00 4,800.00 180.00 830.00 800.00
121,380.00 129,600.00 - 8,220.00 20,230.00 21,600.00
54,000.00 60,000.00 - 6,000.00 9,000.00 10,000.00
18,000.00 18,000.00 - 3,000.00 3,000.00
5,880.00 6,600.00 - 720.00 980.00 1,100.00
18,000.00 18,600.00 - 600.00 3,000.00 3,100.00
4,500.00 5,100.00 - 600.00 750.00 850.00
5,400.00 4,500.00 900.00 900.00 750.00
105,780.00 112,800.00 - 7,020.00 17,630.00 18,800.00
472,560.00 504,960.00 - 32,400.00 78,760.00 84,160.00
56,666.67 70,000.00 - 13,333.33 14,166.67 17,500.00

34,000.00 15,000.00 19,000.00 11,333.33 5,000.00
90,666.67 85,000.00 5,666.67 25,500.00 22,500.00
Julio Agosto
8% 8%
3,230,736.60 2,901,071.25 - 329,665.35 461,533.80 421,974.00
1,406,172.60 1,016,111.25 - 390,061.35 200,881.80 147,798.00
1,437,630.60 957,206.25 - 480,424.35 205,375.80 139,230.00
6,074,539.80 4,874,388.75 - 1,200,151.05 867,791.40 709,002.00
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
900,000.00 900,000.00 -
6,974,539.80 5,774,388.75 - 1,200,151.05 867,791.40 709,002.00
364,700.00 405,111.00 - 40,411.00 52,100.00 57,873.00

273,525.00 308,847.00 - 35,322.00 39,075.00 44,121.00
145,880.00 152,418.00 - 6,538.00 20,840.00 21,774.00
784,105.00 866,376.00 - 82,271.00 112,015.00 123,768.00
146,000.00 139,986.00 6,014.00 20,800.00 19,998.00

109,500.00 106,722.00 2,778.00 15,600.00 15,246.00
58,400.00 52,668.00 5,732.00 8,320.00 7,524.00
313,900.00 299,376.00 14,524.00 44,720.00 42,768.00
144,500.00 116,655.00 27,845.00 20,600.00 16,564.00

108,375.00 88,935.00 19,440.00 15,450.00 12,628.00
57,800.00 43,890.00 13,910.00 8,240.00 6,232.00
310,675.00 249,480.00 61,195.00 44,290.00 35,424.00
1,408,680.00 1,415,232.00 - 6,552.00 201,025.00 201,960.00
154,000.00 175,000.00 - 21,000.00 22,000.00 25,000.00

63,000.00 64,400.00 - 1,400.00 9,000.00 9,200.00
28,700.00 26,600.00 2,100.00 4,100.00 3,800.00
24,500.00 23,100.00 1,400.00 3,500.00 3,300.00
7,000.00 8,400.00 - 1,400.00 1,000.00 1,200.00
9,100.00 8,820.00 280.00 1,300.00 1,260.00
286,300.00 306,320.00 - 20,020.00 40,900.00 43,760.00
77,000.00 84,000.00 - 7,000.00 11,000.00 12,000.00

24,500.00 25,900.00 - 1,400.00 3,500.00 3,700.00
7,700.00 9,100.00 - 1,400.00 1,100.00 1,300.00
21,000.00 19,600.00 1,400.00 3,000.00 2,800.00
5,600.00 7,000.00 - 1,400.00 800.00 1,000.00
5,810.00 5,600.00 210.00 830.00 800.00
141,610.00 151,200.00 - 9,590.00 20,230.00 21,600.00
63,000.00 70,000.00 - 7,000.00 9,000.00 10,000.00
21,000.00 21,000.00 - 3,000.00 3,000.00
6,860.00 7,700.00 - 840.00 980.00 1,100.00
21,000.00 21,700.00 - 700.00 3,000.00 3,100.00
5,250.00 5,950.00 - 700.00 750.00 850.00
6,300.00 5,250.00 1,050.00 900.00 750.00
123,410.00 131,600.00 - 8,190.00 17,630.00 18,800.00
551,320.00 589,120.00 - 37,800.00 78,760.00 84,160.00
70,833.33 87,500.00 - 16,666.67 14,166.67 17,500.00

45,333.33 20,000.00 25,333.33 11,333.33 5,000.00
116,166.67 107,500.00 8,666.67 25,500.00 22,500.00
Agosto Septiembre
8% 9%
3,692,270.40 3,323,045.25 - 369,225.15 461,533.80 474,720.75
1,607,054.40 1,163,909.25 - 443,145.15 200,881.80 166,272.75
1,643,006.40 1,096,436.25 - 546,570.15 205,375.80 156,633.75
6,942,331.20 5,583,390.75 - 1,358,940.45 867,791.40 797,627.25
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
350,000.00 550,000.00 200,000.00
1,250,000.00 1,450,000.00 200,000.00
8,192,331.20 7,033,390.75 - 1,158,940.45 867,791.40 797,627.25
416,800.00 462,984.00 - 46,184.00 52,100.00 57,873.00

312,600.00 352,968.00 - 40,368.00 39,075.00 44,121.00
166,720.00 174,192.00 - 7,472.00 20,840.00 21,774.00
896,120.00 990,144.00 - 94,024.00 112,015.00 123,768.00
166,800.00 159,984.00 6,816.00 20,800.00 19,998.00

125,100.00 121,968.00 3,132.00 15,600.00 15,246.00
66,720.00 60,192.00 6,528.00 8,320.00 7,524.00
358,620.00 342,144.00 16,476.00 44,720.00 42,768.00
165,100.00 133,219.00 31,881.00 20,600.00 16,564.00

123,825.00 101,563.00 22,262.00 15,450.00 12,628.00
66,040.00 50,122.00 15,918.00 8,240.00 6,232.00
354,965.00 284,904.00 70,061.00 44,290.00 35,424.00
1,609,705.00 1,617,192.00 - 7,487.00 201,025.00 201,960.00
176,000.00 200,000.00 - 24,000.00 22,000.00 25,000.00

72,000.00 73,600.00 - 1,600.00 9,000.00 9,200.00
32,800.00 30,400.00 2,400.00 4,100.00 3,800.00
28,000.00 26,400.00 1,600.00 3,500.00 3,300.00
8,000.00 9,600.00 - 1,600.00 1,000.00 1,200.00
10,400.00 10,080.00 320.00 1,300.00 1,260.00
327,200.00 350,080.00 - 22,880.00 40,900.00 43,760.00
88,000.00 96,000.00 - 8,000.00 11,000.00 12,000.00

28,000.00 29,600.00 - 1,600.00 3,500.00 3,700.00
8,800.00 10,400.00 - 1,600.00 1,100.00 1,300.00
24,000.00 22,400.00 1,600.00 3,000.00 2,800.00
6,400.00 8,000.00 - 1,600.00 800.00 1,000.00
6,640.00 6,400.00 240.00 830.00 800.00
161,840.00 172,800.00 - 10,960.00 20,230.00 21,600.00
72,000.00 80,000.00 - 8,000.00 9,000.00 10,000.00
24,000.00 24,000.00 - 3,000.00 3,000.00
7,840.00 8,800.00 - 960.00 980.00 1,100.00
24,000.00 24,800.00 - 800.00 3,000.00 3,100.00
6,000.00 6,800.00 - 800.00 750.00 850.00
7,200.00 6,000.00 1,200.00 900.00 750.00
141,040.00 150,400.00 - 9,360.00 17,630.00 18,800.00
630,080.00 673,280.00 - 43,200.00 78,760.00 84,160.00
85,000.00 105,000.00 - 20,000.00 14,166.67 17,500.00

56,666.67 25,000.00 31,666.67 11,333.33 5,000.00
141,666.67 130,000.00 11,666.67 25,500.00 22,500.00
Septiembre Octubre
9% 7%
4,153,804.20 3,797,766.00 - 356,038.20 519,225.53 369,227.25
1,807,936.20 1,330,182.00 - 477,754.20 225,992.03 129,323.25
1,848,382.20 1,253,070.00 - 595,312.20 231,047.78 121,826.25
7,810,122.60 6,381,018.00 - 1,429,104.60 976,265.33 620,376.75
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
350,000.00 550,000.00 200,000.00
1,250,000.00 1,450,000.00 200,000.00
9,060,122.60 7,831,018.00 - 1,229,104.60 976,265.33 620,376.75
468,900.00 520,857.00 - 51,957.00 52,100.00 57,873.00

351,675.00 397,089.00 - 45,414.00 39,075.00 44,121.00
187,560.00 195,966.00 - 8,406.00 20,840.00 21,774.00
1,008,135.00 1,113,912.00 - 105,777.00 112,015.00 123,768.00
187,600.00 179,982.00 7,618.00 20,800.00 19,998.00

140,700.00 137,214.00 3,486.00 15,600.00 15,246.00
75,040.00 67,716.00 7,324.00 8,320.00 7,524.00
403,340.00 384,912.00 18,428.00 44,720.00 42,768.00
185,700.00 149,783.00 35,917.00 20,600.00 16,564.00

139,275.00 114,191.00 25,084.00 15,450.00 12,628.00
74,280.00 56,354.00 17,926.00 8,240.00 6,232.00
399,255.00 320,328.00 78,927.00 44,290.00 35,424.00
1,810,730.00 1,819,152.00 - 8,422.00 201,025.00 201,960.00
198,000.00 225,000.00 - 27,000.00 22,000.00 25,000.00

81,000.00 82,800.00 - 1,800.00 9,000.00 9,200.00
36,900.00 34,200.00 2,700.00 4,100.00 3,800.00
31,500.00 29,700.00 1,800.00 3,500.00 3,300.00
9,000.00 10,800.00 - 1,800.00 1,000.00 1,200.00
11,700.00 11,340.00 360.00 1,300.00 1,260.00
368,100.00 393,840.00 - 25,740.00 40,900.00 43,760.00
99,000.00 108,000.00 - 9,000.00 11,000.00 12,000.00

31,500.00 33,300.00 - 1,800.00 3,500.00 3,700.00
9,900.00 11,700.00 - 1,800.00 1,100.00 1,300.00
27,000.00 25,200.00 1,800.00 3,000.00 2,800.00
7,200.00 9,000.00 - 1,800.00 800.00 1,000.00
7,470.00 7,200.00 270.00 830.00 800.00
182,070.00 194,400.00 - 12,330.00 20,230.00 21,600.00
81,000.00 90,000.00 - 9,000.00 9,000.00 10,000.00
27,000.00 27,000.00 - 3,000.00 3,000.00
8,820.00 9,900.00 - 1,080.00 980.00 1,100.00
27,000.00 27,900.00 - 900.00 3,000.00 3,100.00
6,750.00 7,650.00 - 900.00 750.00 850.00
8,100.00 6,750.00 1,350.00 900.00 750.00
158,670.00 169,200.00 - 10,530.00 17,630.00 18,800.00
708,840.00 757,440.00 - 48,600.00 78,760.00 84,160.00
99,166.67 122,500.00 - 23,333.33 14,166.67 17,500.00

68,000.00 30,000.00 38,000.00 11,333.33 5,000.00
167,166.67 152,500.00 14,666.67 25,500.00 22,500.00
Octubre Noviembre
9% 11%
4,673,029.73 4,166,993.25 - 506,036.48 519,225.53 580,214.25
2,033,928.23 1,459,505.25 - 574,422.98 225,992.03 203,222.25
2,079,429.98 1,374,896.25 - 704,533.73 231,047.78 191,441.25
8,786,387.93 7,001,394.75 - 1,784,993.18 976,265.33 974,877.75
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
350,000.00 550,000.00 200,000.00
1,250,000.00 1,450,000.00 200,000.00
10,036,387.93 8,451,394.75 - 1,584,993.18 976,265.33 974,877.75
521,000.00 578,730.00 - 57,730.00 52,000.00 57,873.00

390,750.00 441,210.00 - 50,460.00 39,000.00 44,121.00
208,400.00 217,740.00 - 9,340.00 20,800.00 21,774.00
1,120,150.00 1,237,680.00 - 117,530.00 111,800.00 123,768.00
208,400.00 199,980.00 8,420.00 20,800.00 19,998.00

156,300.00 152,460.00 3,840.00 15,600.00 15,246.00
83,360.00 75,240.00 8,120.00 8,320.00 7,524.00
448,060.00 427,680.00 20,380.00 44,720.00 42,768.00
206,300.00 166,347.00 39,953.00 20,600.00 16,564.00

154,725.00 126,819.00 27,906.00 15,450.00 12,628.00
82,520.00 62,586.00 19,934.00 8,240.00 6,232.00
443,545.00 355,752.00 87,793.00 44,290.00 35,424.00
2,011,755.00 2,021,112.00 - 9,357.00 200,810.00 201,960.00
220,000.00 250,000.00 - 30,000.00 22,000.00 25,000.00

90,000.00 92,000.00 - 2,000.00 9,000.00 9,200.00
41,000.00 38,000.00 3,000.00 4,100.00 3,800.00
35,000.00 33,000.00 2,000.00 3,500.00 3,300.00
10,000.00 12,000.00 - 2,000.00 1,000.00 1,200.00
13,000.00 12,600.00 400.00 1,300.00 1,260.00
409,000.00 437,600.00 - 28,600.00 40,900.00 43,760.00
110,000.00 120,000.00 - 10,000.00 11,000.00 12,000.00

35,000.00 37,000.00 - 2,000.00 3,500.00 3,700.00
11,000.00 13,000.00 - 2,000.00 1,100.00 1,300.00
30,000.00 28,000.00 2,000.00 3,000.00 2,800.00
8,000.00 10,000.00 - 2,000.00 800.00 1,000.00
8,300.00 8,000.00 300.00 830.00 800.00
202,300.00 216,000.00 - 13,700.00 20,230.00 21,600.00
90,000.00 100,000.00 - 10,000.00 9,000.00 10,000.00
30,000.00 30,000.00 - 3,000.00 3,000.00
9,800.00 11,000.00 - 1,200.00 980.00 1,100.00
30,000.00 31,000.00 - 1,000.00 3,000.00 3,100.00
7,500.00 8,500.00 - 1,000.00 750.00 850.00
9,000.00 7,500.00 1,500.00 900.00 750.00
176,300.00 188,000.00 - 11,700.00 17,630.00 18,800.00
787,600.00 841,600.00 - 54,000.00 78,760.00 84,160.00
113,333.33 140,000.00 - 26,666.67 14,166.67 17,500.00

79,333.33 35,000.00 44,333.33 11,333.33 5,000.00
192,666.67 175,000.00 17,666.67 25,500.00 22,500.00
Noviembre Diciembre
10% 10%
5,192,255.25 4,747,207.50 - 445,047.75 576,917.25 527,467.50
2,259,920.25 1,662,727.50 - 597,192.75 251,102.25 184,747.50
2,310,477.75 1,566,337.50 - 744,140.25 256,719.75 174,037.50
9,762,653.25 7,976,272.50 - 1,786,380.75 1,084,739.25 886,252.50
500,000.00 700,000.00 200,000.00

400,000.00 200,000.00 - 200,000.00
350,000.00 550,000.00 200,000.00
1,250,000.00 1,450,000.00 200,000.00
11,012,653.25 9,426,272.50 - 1,586,380.75 1,084,739.25 886,252.50
573,000.00 636,603.00 - 63,603.00 52,000.00 57,772.00

429,750.00 485,331.00 - 55,581.00 39,000.00 44,044.00
229,200.00 239,514.00 - 10,314.00 20,800.00 21,736.00
1,231,950.00 1,361,448.00 - 129,498.00 111,800.00 123,552.00
229,200.00 219,978.00 9,222.00 20,800.00 19,897.00

171,900.00 167,706.00 4,194.00 15,600.00 15,169.00
91,680.00 82,764.00 8,916.00 8,320.00 7,486.00
492,780.00 470,448.00 22,332.00 44,720.00 42,552.00
226,900.00 182,911.00 43,989.00 20,600.00 16,564.00

170,175.00 139,447.00 30,728.00 15,450.00 12,628.00
90,760.00 68,818.00 21,942.00 8,240.00 6,232.00
487,835.00 391,176.00 96,659.00 44,290.00 35,424.00
2,212,565.00 2,223,072.00 - 10,507.00 200,810.00 201,528.00
242,000.00 275,000.00 - 33,000.00 22,000.00 25,000.00

99,000.00 101,200.00 - 2,200.00 9,000.00 9,200.00
45,100.00 41,800.00 3,300.00 4,100.00 3,800.00
38,500.00 36,300.00 2,200.00 3,500.00 3,300.00
11,000.00 13,200.00 - 2,200.00 1,000.00 1,200.00
14,300.00 13,860.00 440.00 1,300.00 1,260.00
449,900.00 481,360.00 - 31,460.00 40,900.00 43,760.00
121,000.00 132,000.00 - 11,000.00 11,000.00 12,000.00

38,500.00 40,700.00 - 2,200.00 3,500.00 3,700.00
12,100.00 14,300.00 - 2,200.00 1,100.00 1,300.00
33,000.00 30,800.00 2,200.00 3,000.00 2,800.00
8,800.00 11,000.00 - 2,200.00 800.00 1,000.00
9,130.00 8,800.00 330.00 830.00 800.00
222,530.00 237,600.00 - 15,070.00 20,230.00 21,600.00
99,000.00 110,000.00 - 11,000.00 9,000.00 10,000.00
33,000.00 33,000.00 - 3,000.00 3,000.00
10,780.00 12,100.00 - 1,320.00 980.00 1,100.00
33,000.00 34,100.00 - 1,100.00 3,000.00 3,100.00
8,250.00 9,350.00 - 1,100.00 750.00 850.00
9,900.00 8,250.00 1,650.00 900.00 750.00
193,930.00 206,800.00 - 12,870.00 17,630.00 18,800.00
866,360.00 925,760.00 - 59,400.00 78,760.00 84,160.00
127,500.00 157,500.00 - 30,000.00 14,166.67 17,500.00

90,666.67 40,000.00 50,666.67 11,333.33 5,000.00
218,166.67 197,500.00 20,666.67 25,500.00 22,500.00
Diciembre
Acumulado presupuestado Acumulado real Variación Formula de presupuesto de ventas matriz

5,769,172.50 5,274,675.00 - 494,497.50 5,769,
2,511,022.50 1,847,475.00 - 663,547.50
2,567,197.50 1,740,375.00 - 826,822.50 Formula de presupuesto de ventas sucursal 1
10,847,392.50 8,862,525.00 - 1,984,867.50 2,511,
500,000.00 700,000.00 200,000.00 Formula de presupuesto de ventas sucursal 2

400,000.00 200,000.00 - 200,000.00 2,567,
350,000.00 550,000.00 200,000.00
1,250,000.00 1,450,000.00 200,000.00 Presupuestado
12,097,392.50 10,312,525.00 - 1,784,867.50
Producción requerida
625,000.00 694,375.00 - 69,375.00 100.00 521 10 meses
468,750.00 529,375.00 - 60,625.00 75.00 520 2 meses
250,000.00 261,250.00 - 11,250.00 40.00
1,343,750.00 1,485,000.00 - 141,250.00
250,000.00 239,875.00 10,125.00 100.00 209 4 meses
187,500.00 182,875.00 4,625.00 75.00 208 8 meses
100,000.00 90,250.00 9,750.00 40.00
537,500.00 513,000.00 24,500.00
247,500.00 199,475.00 48,025.00 100.00 207 3 meses
185,625.00 152,075.00 33,550.00 75.00 206 9 meses
99,000.00 75,050.00 23,950.00 40.00
532,125.00 426,600.00 105,525.00
2,413,375.00 2,424,600.00 - 11,225.00
264,000.00 300,000.00 - 36,000.00

108,000.00 110,400.00 - 2,400.00
49,200.00 45,600.00 3,600.00
42,000.00 39,600.00 2,400.00
12,000.00 14,400.00 - 2,400.00
15,600.00 15,120.00 480.00
490,800.00 525,120.00 - 34,320.00
132,000.00 144,000.00 - 12,000.00

42,000.00 44,400.00 - 2,400.00
13,200.00 15,600.00 - 2,400.00
36,000.00 33,600.00 2,400.00
9,600.00 12,000.00 - 2,400.00
9,960.00 9,600.00 360.00
242,760.00 259,200.00 - 16,440.00
108,000.00 120,000.00 - 12,000.00
36,000.00 36,000.00 -
11,760.00 13,200.00 - 1,440.00
36,000.00 37,200.00 - 1,200.00
9,000.00 10,200.00 - 1,200.00
10,800.00 9,000.00 1,800.00
211,560.00 225,600.00 - 14,040.00
945,120.00 1,009,920.00 - 64,800.00
141,666.67 175,000.00 - 33,333.33

102,000.00 45,000.00 57,000.00
243,666.67 220,000.00 23,666.67
7,245,230.83 5,208,005.00 - 1,932,509.17
2,173,569.25 1,562,401.50 - 579,752.75
724,523.08 520,800.50 - 193,250.92
4,347,138.50 3,124,803.00 - 1,159,505.50
a de presupuesto de ventas matriz Formula de presupuesto de ventas matriz real
5,769,172.50 5,274,675.00
e presupuesto de ventas sucursal 1 Formula de presupuesto de ventas sucursal 1 real

2,511,022.50 1,847,475.00
e presupuesto de ventas sucursal 2 Formula de presupuesto de ventas sucursal 2 real

2,567,197.50 1,740,375.00
Real
101.00 573 11 meses
77.00 572 1 meses
38.00
101.00 198 11 meses
77.00 197 1 meses
38.00
101.00 165 7 meses
77.00 164 5 meses
38.00
Enero
Matriz 11% 7%
Presupuestado Real Acumulado presupuestado Acumulado real
Inventario Inicial 10000 10000 10000 10000
Producción requerida 521 573 521 573
10521 10573 10521 10573
Presupuesto de ventas 1238 831 1238 831
Inventario Final 9283 9742 9283 9742
Enero
Sucursal 1 11% 7%
2709 2698 2709 2698
Enero
Sucursal 1 11% 7%
2857 2815 2857 2815
sucursal 2
presupuestado real acumulado presupuestado acumulado real
inventario incial
produccion requerida
presupueso de ventas
inventario final
Febrero
11% 8%
Variación Presupuestado Real Acumulado presupuestado Acumulado real Variación
0 9283 9742 19283 19742 459
52 521 573 1042 1146 104
52 9804 10315 20325 20888 563
-407 1238 950 2476 1781 -695
459 8566 9365 17849 19107 1258
Febrero
11% 8%
0 2269 2427 4769 4927 158
-11 209 198 418 396 -22
-11 2478 2625 5187 5323 136
-169 440 310 880 581 -299
158 2038 2315 4307 4742 435
Febrero
11% 8%
0 2403 2561 5053 5211 158
-42 207 165 414 330 -84
-42 2610 2726 5467 5541 74
-200 454 290 908 544 -364
158 2156 2436 4559 4997 438
variacion presupuestado real acumulado presupuestado acumulado real variacion

Marzo
6% 8% 6%
Presupuestado Real Acumulado presupuestado Acumulado real Variación Presupuestado
8566 9365 27849 29107 1258 8412
521 573 1563 1719 156 521
9087 9938 29412 30826 1414 8933
675 950 3151 2731 -420 675
8412 8988 26261 28095 1834 8258
Marzo
6% 8% 6%
2038 2315 6807 7242 435 2007
209 198 627 594 -33 209
2247 2513 7434 7836 402 2216
240 310 1120 891 -229 240
2007 2203 6314 6945 631 1976
Marzo
6% 8% 6%
2156 2436 7209 7647 438 2116
207 165 621 495 -126 206
2363 2601 7830 8142 312 2322
247 290 1155 834 -321 247
2116 2311 6675 7308 633 2075
presupuestado real acumulado presupuestado acumulado real variacion presupuestado

Abril Mayo
7% 7% 6%
Real Acumulado presupuestado Acumulado real Variación Presupuestado Real
8988 36261 38095 1834 8258 8730
573 2084 2292 208 521 573
9561 38345 40387 2042 8779 9303
831 3826 3562 -264 788 713
8730 34519 36825 2306 7991 8590
Abril Mayo
7% 7% 6%
2203 8814 9445 631 1976 2130
198 836 792 -44 208 198
2401 9650 10237 587 2184 2328
271 1360 1162 -198 280 233
2130 8290 9075 785 1904 2095
Abril Mayo
7% 7% 6%
2311 9325 9958 633 2075 2222
165 827 660 -167 206 165
2476 10152 10618 466 2281 2387
254 1402 1088 -314 289 218
2222 8750 9530 780 1992 2169
real Acumulado presupuestado Acumulado real Variación Presupuestado Real

Mayo Junio
7% 9%
44519 46825 2306 7991 8590
2605 2865 260 521 573
47124 49690 2566 8512 9163
4614 4275 -339 788 1069
42510 45415 2905 7724 8094
Mayo Junio
7% 9%
10790 11575 785 1904 2095
1044 990 -54 208 198
11834 12565 731 2112 2293
1640 1395 -245 280 349
10194 11170 976 1832 1944
Mayo Junio
7% 9%
11400 12180 780 1992 2169
1033 825 -208 206 165
12433 13005 572 2198 2334
1691 1306 -385 289 326
10742 11699 957 1909 2008

Junio Julio
8% 10%
52510 55415 2905 7724 8094
3126 3438 312 521 573
55636 58853 3217 8245 8667
5402 5344 -58 900 1188
50234 53509 3275 7345 7479
Junio Julio
8% 10%
12694 13670 976 1832 1944
1252 1188 -64 208 198
13946 14858 912 2040 2142
1920 1744 -176 320 388
12026 13114 1088 1720 1754
Junio Julio
8% 10%
13392 14349 957 1909 2008
1239 990 -249 206 165
14631 15339 708 2115 2173
1980 1632 -348 330 363
12651 13707 1056 1785 1810
Acumulado presupuestado Acumulado real Variación

Julio Agosto
8% 8%
60234 63509 3275 7345 7479
3647 4011 364 521 573
63881 67520 3639 7866 8052
6302 6532 230 900 950
57579 60988 3409 6966 7102
Julio Agosto
8% 8%
14526 15614 1088 1720 1754
1460 1386 -74 208 198
15986 17000 1014 1928 1952
2240 2132 -108 320 310
13746 14868 1122 1608 1642
Julio Agosto
8% 8%
15301 16357 1056 1785 1810
1445 1155 -290 206 164
16746 17512 766 1991 1974
2310 1995 -315 330 290
14436 15517 1081 1661 1684
Agosto Septiembre
8% 9%
67579 70988 3409 6966 7102
4168 4584 416 521 573
71747 75572 3825 7487 7675
7202 7482 280 900 1069
64545 68090 3545 6587 6606
Agosto Septiembre
8% 9%
16246 17368 1122 1608 1642
1668 1584 -84 208 198
17914 18952 1038 1816 1840
2560 2442 -118 320 349
15354 16510 1156 1496 1491
Agosto Septiembre
8% 9%
17086 18167 1081 1661 1684
1651 1319 -332 206 164
18737 19486 749 1867 1848
2640 2285 -355 330 326
16097 17201 1104 1537 1522
Septiembre Octubre
9% 7%
74545 78090 3545 6587 6606
4689 5157 468 521 573
79234 83247 4013 7108 7179
8102 8551 449 1013 831
71132 74696 3564 6095 6348
Septiembre Octubre
9% 7%
17854 19010 1156 1496 1491
1876 1782 -94 208 198
19730 20792 1062 1704 1689
2880 2791 -89 360 271
16850 18001 1151 1344 1418
Septiembre Octubre
9% 7%
18747 19851 1104 1537 1522
1857 1483 -374 206 164
20604 21334 730 1743 1686
2970 2611 -359 371 254
17634 18723 1089 1372 1432
Octubre Noviembre
9% 11%
81132 84696 3564 6095 6348
5210 5730 520 520 573
86342 90426 4084 6615 6921
9115 9382 267 1010 1305
77227 81044 3817 5605 5616
Se ajusto tres unidades
Octubre Noviembre
9% 11%
19350 20501 1151 1344 1418
2084 1980 -104 208 198
21434 22481 1047 1552 1616
3240 3062 -178 360 425
18194 19419 1225 1192 1191
Octubre Noviembre
9% 11%
20284 21373 1089 1372 1432
2063 1647 -416 206 164
22347 23020 673 1578 1596
3341 2865 -476 371 397
19006 20155 1149 1207 1199
Noviembre Diciembre
10% 10%
87227 91044 3817 5605 5616
5730 6303 573 520 572
92957 97347 4390 6125 6188
10125 10687 562 1125 1188
82832 86660 3828 5000 5000
Se ajusto una unidad
e ajusto tres unidades
Noviembre Diciembre
10% 10%
20694 21919 1225 1192 1191
2292 2178 -114 208 197
22986 24097 1111 1400 1388
3600 3487 -113 400 388
19386 20610 1224 1000 1000
Se ajusto una unidad
Noviembre Diciembre
10% 10%
21656 22805 1149 1207 1199
2269 1811 -458 206 164
23925 24616 691 1413 1363
3712 3262 -450 413 363
20213 21354 1141 1000 1000
Se ajusto dos unidades

Diciembre
Inv. I 10000
Acumulado presupuestado Acumulado real Variación Inv. F 5000
92832 96660 3828 P. Unidad 400.00
6250 6875 625
99082 103535 4453 Excedente 5000
11250 11875 625
87832 91660 3828
Diciembre
Inv. I 2500
21886 23110 1224 P. Unidad 400.00
2500 2375 -125
24386 25485 1099 Excedente 1500
4000 3875 -125
20386 21610 1224
Diciembre
Inv. I 2650
22863 24004 1141 P. Unidad 400.00
2475 1975 -500
25338 25979 641 Excedente 1650
4125 3625 -500
21213 22354 1141
Presupuestado
V= 4,500,000.00 Unidades
11,250
400.00
6,250 Producción requerida anual

520.83 Producción requerida mensual
520 x 12 6240
10 meses 521
2 meses 520
Presupuestado
V= 1,600,000.00 Unidades
4,000
400.00

208 x 12 2496
4 meses 209
8 meses 208
Presupuestado
V= 1,650,000.00 Unidades
4,125
400.00

206 x 12 2472
3 meses 207
9 meses 206
Real
Inv. I 10000 V= 4,750,000.00 Unidades
11,875
Inv. F 5000 400.00
P. Unidad 400.00
Excedente 5000 572.92 Producción requerida mensual
572 x 12
11 meses 573
1 meses 572
Real
Inv. I 2500 V= 1,550,000.00 Unidades
3,875
Inv. F 1000 400.00
P. Unidad 400.00
197 x 12
11 meses 198
1 meses 197
Real
Inv. I 2650 V= 1,450,000.00 Unidades
3,625
Inv. F 1000 400.00
P. Unidad 400.00
164 x 12
7 meses 165
5 meses 164
erida mensual
6864
erida mensual
2364
erida mensual
1968

Presupuesto Maestro

Cargado por

Copyright:

Formatos disponibles

Presupuesto Maestro

Cargado por

Información del documento

Título original

Derechos de autor

Formatos disponibles

Compartir este documento

Compartir o incrustar documentos

Opciones para compartir

¿Le pareció útil este documento?

¿Este contenido es inapropiado?

Copyright:

Formatos disponibles

Presupuesto Maestro

Cargado por

Copyright:

Formatos disponibles

Enero

1,193,213.18 620,376.75 - 572,836.43 1,193,213.18 709,002.00

52,100.00 57,873.00 - 5,773.00 52,100.00 57,873.00

20,900.00 19,998.00 902.00 20,900.00 19,998.00

20,700.00 16,665.00 4,035.00 20,700.00 16,665.00

22,000.00 25,000.00 - 3,000.00 22,000.00 25,000.00

11,000.00 12,000.00 - 1,000.00 11,000.00 12,000.00

500,000.00 700,000.00 200,000.00

500,000.00 700,000.00 200,000.00

104,200.00 115,746.00 - 11,546.00 52,100.00 57,873.00

41,800.00 39,996.00 1,804.00 20,900.00 19,998.00

41,400.00 33,330.00 8,070.00 20,700.00 16,665.00

44,000.00 50,000.00 - 6,000.00 22,000.00 25,000.00

22,000.00 24,000.00 - 2,000.00 11,000.00 12,000.00

500,000.00 700,000.00 200,000.00

156,300.00 173,619.00 - 17,319.00 52,100.00 57,873.00

62,700.00 59,994.00 2,706.00 20,900.00 19,998.00

62,100.00 49,995.00 12,105.00 20,600.00 16,665.00

66,000.00 75,000.00 - 9,000.00 22,000.00 25,000.00

33,000.00 36,000.00 - 3,000.00 11,000.00 12,000.00

14,166.67 17,500.00 - 3,333.33 14,166.67 17,500.00

500,000.00 700,000.00 200,000.00

208,400.00 231,492.00 - 23,092.00 52,100.00 57,873.00

83,600.00 79,992.00 3,608.00 20,800.00 19,998.00

82,700.00 66,660.00 16,040.00 20,600.00 16,665.00

88,000.00 100,000.00 - 12,000.00 22,000.00 25,000.00

44,000.00 48,000.00 - 4,000.00 11,000.00 12,000.00

28,333.33 35,000.00 - 6,666.67 14,166.67 17,500.00

500,000.00 700,000.00 200,000.00

260,500.00 289,365.00 - 28,865.00 52,100.00 57,873.00

104,400.00 99,990.00 4,410.00 20,800.00 19,998.00

103,300.00 83,325.00 19,975.00 20,600.00 16,665.00

110,000.00 125,000.00 - 15,000.00 22,000.00 25,000.00

55,000.00 60,000.00 - 5,000.00 11,000.00 12,000.00

42,500.00 52,500.00 - 10,000.00 14,166.67 17,500.00

500,000.00 700,000.00 200,000.00

312,600.00 347,238.00 - 34,638.00 52,100.00 57,873.00

125,200.00 119,988.00 5,212.00 20,800.00 19,998.00

123,900.00 99,990.00 23,910.00 20,600.00 16,665.00

132,000.00 150,000.00 - 18,000.00 22,000.00 25,000.00

66,000.00 72,000.00 - 6,000.00 11,000.00 12,000.00

56,666.67 70,000.00 - 13,333.33 14,166.67 17,500.00

500,000.00 700,000.00 200,000.00

364,700.00 405,111.00 - 40,411.00 52,100.00 57,873.00

146,000.00 139,986.00 6,014.00 20,800.00 19,998.00

144,500.00 116,655.00 27,845.00 20,600.00 16,564.00

154,000.00 175,000.00 - 21,000.00 22,000.00 25,000.00

77,000.00 84,000.00 - 7,000.00 11,000.00 12,000.00

70,833.33 87,500.00 - 16,666.67 14,166.67 17,500.00

500,000.00 700,000.00 200,000.00

416,800.00 462,984.00 - 46,184.00 52,100.00 57,873.00

166,800.00 159,984.00 6,816.00 20,800.00 19,998.00

165,100.00 133,219.00 31,881.00 20,600.00 16,564.00

176,000.00 200,000.00 - 24,000.00 22,000.00 25,000.00

88,000.00 96,000.00 - 8,000.00 11,000.00 12,000.00

85,000.00 105,000.00 - 20,000.00 14,166.67 17,500.00

500,000.00 700,000.00 200,000.00

468,900.00 520,857.00 - 51,957.00 52,100.00 57,873.00

187,600.00 179,982.00 7,618.00 20,800.00 19,998.00