Informe de Ventas Mensual1

Descargar como xls, pdf o txt
Descargar como xls, pdf o txt
Está en la página 1de 3

730

MENSUAL ENTRADA DATOS Informe de ventas Previsin de ventas

TOTALES PREVISIN

FECHA COMPAA CANTIDAD PLANEADA COSTE INGRESOS MES TRIMESTRE AO MES TRIMESTRE ANUAL MES TRIMESTRE AO
4/23/2013 A. Datum Corporation 6,400.00 6,200.00 4,450.00 1,950.00 April Trimestre 2 2013 #ADDIN? 50,800.00 143,800.00

4/25/2013 Contoso Pharmaceuticals 8,200.00 8,000.00 6,400.00 1,800.00 April Trimestre 2 2013 #ADDIN? 50,800.00 143,800.00

5/7/2013 Consolidated Messenger 4,400.00 4,200.00 2,600.00 1,800.00 May Trimestre 2 2013 #ADDIN? 50,800.00 143,800.00

5/14/2013 Proseware, Inc. 5,400.00 5,500.00 4,500.00 900.00 May Trimestre 2 2013 #ADDIN? 50,800.00 143,800.00

5/14/2013 School of Fine Art 5,800.00 6,000.00 4,500.00 1,300.00 May Trimestre 2 2013 #ADDIN? 50,800.00 143,800.00

5/29/2013 Trey Research 6,200.00 6,000.00 4,500.00 1,700.00 May Trimestre 2 2013 #ADDIN? 50,800.00 143,800.00

6/10/2013 A. Datum Corporation 6,900.00 7,500.00 5,400.00 1,500.00 June Trimestre 2 2013 #ADDIN? 50,800.00 143,800.00

6/21/2013 Contoso Pharmaceuticals 7,500.00 7,200.00 6,500.00 1,000.00 June Trimestre 2 2013 #ADDIN? 50,800.00 143,800.00

7/6/2013 Consolidated Messenger 8,700.00 8,500.00 7,250.00 1,450.00 July Trimestre 3 2013 #ADDIN? 49,100.00 143,800.00 47,400.00

8/5/2013 Proseware, Inc. 8,500.00 8,300.00 7,100.00 1,400.00 August Trimestre 3 2013 #ADDIN? 49,100.00 143,800.00 47,400.00

8/19/2013 School of Fine Art 7,900.00 7,700.00 6,600.00 1,300.00 August Trimestre 3 2013 #ADDIN? 49,100.00 143,800.00 47,400.00

9/4/2013 Trey Research 9,100.00 8,900.00 7,900.00 1,200.00 September Trimestre 3 2013 #ADDIN? 49,100.00 143,800.00 47,400.00

9/20/2013 Contoso Pharmaceuticals 5,600.00 5,800.00 4,500.00 1,100.00 September Trimestre 3 2013 #ADDIN? 49,100.00 143,800.00 47,400.00

9/25/2013 Consolidated Messenger 9,300.00 9,100.00 7,500.00 1,800.00 September Trimestre 3 2013 #ADDIN? 49,100.00 143,800.00 47,400.00

10/15/2013 Proseware, Inc. 8,800.00 9,350.00 7,100.00 1,700.00 October Trimestre 4 2013 #ADDIN? 43,900.00 143,800.00 43,258.14

11/5/2013 School of Fine Art 9,100.00 9,200.00 7,850.00 1,250.00 November Trimestre 4 2013 #ADDIN? 43,900.00 143,800.00 42,312.90

11/26/2013 Trey Research 9,000.00 10,000.00 7,575.00 1,425.00 November Trimestre 4 2013 #ADDIN? 43,900.00 143,800.00 41,811.11

11/30/2013 Trey Research 7,500.00 8,000.00 5,850.00 1,650.00 November Trimestre 4 2013 #ADDIN? 43,900.00 143,800.00 41,500.00

12/11/2013 Contoso Pharmaceuticals 9,500.00 9,200.00 8,500.00 1,000.00 December Trimestre 4 2013 #ADDIN? 43,900.00 143,800.00 41,288.24
MENSUAL INFORME VENTAS Entrada datos Previsin de ventas

AO TRIMESTRE MES COMPAA VENTAS TOTALES


2013 Trimestre 2 April A. Datum Corporation 6,400.00

Contoso Pharmaceuticals 8,200.00

May Consolidated Messenger 4,400.00

Proseware, Inc. 5,400.00

School of Fine Art 5,800.00

Trey Research 6,200.00

June A. Datum Corporation 6,900.00

Contoso Pharmaceuticals 7,500.00

Total Trimestre 2 50,800.00

Trimestre 3 July Consolidated Messenger 8,700.00

August Proseware, Inc. 8,500.00

School of Fine Art 7,900.00

September Consolidated Messenger 9,300.00

Contoso Pharmaceuticals 5,600.00

Trey Research 9,100.00

Total Trimestre 3 49,100.00

Trimestre 4 October Proseware, Inc. 8,800.00

November School of Fine Art 9,100.00


Trey Research 16,500.00
December Contoso Pharmaceuticals 9,500.00

Total Trimestre 4 43,900.00


Total 2013 143,800.00
Total general 143,800.00
MENSUAL PREVISIONES VENTAS Entrada datos Informe de ventas

FECHA ACTUAL: 1 TEVET, TUE #VALUE!

ESTE MES REALES PLANEADAS VARIACIN % REALES HASTA LA FECHA PLANEADAS HASTA AL FECHA VARIACIN HASTA LA FECHA Hasta la fecha %
Cantidad #VALUE! #ADDIN?
Ventas #VALUE! #VALUE! #VALUE! - #ADDIN? #ADDIN? #ADDIN?
Ingresos #VALUE! #VALUE! #VALUE! - #ADDIN? #ADDIN? #ADDIN?
Margen - - -
Nmero de pedidos #VALUE! #ADDIN?
Valor medio de pedidos - -

PREVISIN PRX. MES PRX. TRIMESTRE PRX. AO


Ventas #VALUE! #VALUE! #VALUE!

HISTORIAL DE VENTAS
CANTIDAD PLANEADA COSTE INGRESOS
12,000.00

10,000.00

8,000.00

6,000.00

4,000.00

2,000.00

0.00
4/23/2013 5/23/2013 6/23/2013 7/23/2013 8/23/2013 9/23/2013 10/23/2013 11/23/2013

PREVISIN MES PREVISIN TRIMESTRE

15.00 48,000.00
46,000.00
10.00 44,000.00
5.00 42,000.00
40,000.00
0.00 38,000.00

PREVISIN AO FLUJO DE INGRESOS

15.00 2,500.00
2,000.00
10.00 1,500.00
5.00 1,000.00
500.00
0.00 0.00

También podría gustarte