Mẫu Báo cáo doanh số theo sản phẩm

Chia sẻ: Châu Kiệt Luân | Ngày: | Loại File: XLSX | Số trang:6

Thêm vào BST

Báo xấu

29
lượt xem 2
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Mẫu Báo cáo doanh số theo sản phẩm giúp bạn thống kê các loại sản phẩm khác nhau, lưu trữ thông tin khách hàng qua từng quý trong năm kinh doanh. Mời các bạn cùng tham khảo và tải về biểu mẫu!

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Mẫu Báo cáo doanh số theo sản phẩm

DƯ LIÊU NHÂP ̃ ̣ ̣ NGAY ̀ ̉ ̉ SAN PHÂM KHACH HANG ́ ̀ SÔ TIÊN ́ ̀ QUÝ 1/1/2012 ̉ ̉ San phâm 14 Fabrikam, Inc. 39,228,800.00 ₫ QUY 1 ́ 1/3/2012 ̉ ̉ San phâm 23 Alpine Ski House 83,657,600.00 ₫ QUY 1 ́ 1/4/2012 ̉ ̉ San phâm 18 Coho Winery 169,395,200.00 ₫ QUY 1 ́ 1/7/2012 ̉ ̉ San phâm 10 Southridge Video 166,441,600.00 ₫ QUY 1 ́ 1/11/2012 ̉ ̉ San phâm 7 Coho Winery 132,953,600.00 ₫ QUY 1 ́ 1/25/2012 ̉ ̉ San phâm 1 Contoso, Ltd 134,035,200.00 ₫ QUY 1 ́ 1/30/2012 ̉ ̉ San phâm 27 Southridge Video 57,657,600.00 ₫ QUY 1 ́ 2/4/2012 ̉ ̉ San phâm 30 City Power & Light 180,419,200.00 ₫ QUY 1 ́ 2/5/2012 ̉ ̉ San phâm 16 A. Datum Corporation 48,505,600.00 ₫ QUY 1 ́ 2/8/2012 ̉ ̉ San phâm 21 Alpine Ski House 111,696,000.00 ₫ QUY 1 ́ 2/10/2012 ̉ ̉ San phâm 6 City Power & Light 36,774,400.00 ₫ QUY 1 ́ 2/17/2012 ̉ ̉ San phâm 24 Coho Winery 113,859,200.00 ₫ QUY 1 ́ 2/22/2012 ̉ ̉ San phâm 28 Fabrikam, Inc. 72,675,200.00 ₫ QUY 1 ́ 2/24/2012 ̉ ̉ San phâm 22 City Power & Light 30,867,200.00 ₫ QUY 1 ́ 2/29/2012 ̉ ̉ San phâm 26 Humongous Insurance 113,443,200.00 ₫ QUY 1 ́ 3/1/2012 ̉ ̉ San phâm 15 City Power & Light 47,964,800.00 ₫ QUY 1 ́ 3/8/2012 ̉ ̉ San phâm 9 A. Datum Corporation 179,961,600.00 ₫ QUY 1 ́ 3/14/2012 ̉ ̉ San phâm 16 Alpine Ski House 74,755,200.00 ₫ QUY 1 ́ 3/31/2012 ̉ ̉ San phâm 28 City Power & Light 189,904,000.00 ₫ QUY 1 ́ 4/3/2012 ̉ ̉ San phâm 28 Southridge Video 207,708,800.00 ₫ QUY 2 ́ 4/9/2012 ̉ ̉ San phâm 2 Fabrikam, Inc. 172,016,000.00 ₫ QUY 2 ́ 4/10/2012 ̉ ̉ San phâm 30 A. Datum Corporation 107,827,200.00 ₫ QUY 2 ́ 4/11/2012 ̉ ̉ San phâm 25 Contoso, Ltd 196,060,800.00 ₫ QUY 2 ́ 4/11/2012 ̉ ̉ San phâm 15 Humongous Insurance 83,449,600.00 ₫ QUY 2 ́ 4/15/2012 ̉ ̉ San phâm 28 Coho Winery 160,659,200.00 ₫ QUY 2 ́ 5/3/2012 ̉ ̉ San phâm 21 Northwind Traders 47,091,200.00 ₫ QUY 2 ́ 5/4/2012 ̉ ̉ San phâm 30 Coho Winery 194,979,200.00 ₫ QUY 2 ́ 5/5/2012 ̉ ̉ San phâm 17 Humongous Insurance 76,793,600.00 ₫ QUY 2 ́ 5/5/2012 ̉ ̉ San phâm 28 Humongous Insurance 189,779,200.00 ₫ QUY 2 ́ 5/19/2012 ̉ ̉ San phâm 22 Humongous Insurance 103,209,600.00 ₫ QUY 2 ́ 5/22/2012 ̉ ̉ San phâm 8 A. Datum Corporation 190,652,800.00 ₫ QUY 2 ́ 5/31/2012 ̉ ̉ San phâm 16 Coho Winery 116,688,000.00 ₫ QUY 2 ́ 6/2/2012 ̉ ̉ San phâm 8 City Power & Light 69,097,600.00 ₫ QUY 2 ́ 6/2/2012 ̉ ̉ San phâm 3 Humongous Insurance 53,913,600.00 ₫ QUY 2 ́ Page 1 of 6
NGAY ̀ ̉ ̉ SAN PHÂM KHACH HANG ́ ̀ SÔ TIÊN ́ ̀ QUÝ 6/4/2012 ̉ ̉ San phâm 13 Contoso, Ltd 92,435,200.00 ₫ QUY 2 ́ 6/9/2012 ̉ ̉ San phâm 10 Southridge Video 149,052,800.00 ₫ QUY 2 ́ 6/12/2012 ̉ ̉ San phâm 13 Fabrikam, Inc. 104,166,400.00 ₫ QUY 3 ́ 6/26/2012 ̉ ̉ San phâm 2 Contoso, Ltd 74,422,400.00 ₫ QUY 3 ́ 6/29/2012 ̉ ̉ San phâm 22 Southridge Video 23,795,200.00 ₫ QUY 3 ́ 7/2/2012 ̉ ̉ San phâm 14 Alpine Ski House 76,876,800.00 ₫ QUY 3 ́ 7/6/2012 ̉ ̉ San phâm 14 Coho Winery 147,347,200.00 ₫ QUY 3 ́ 7/6/2012 ̉ ̉ San phâm 2 City Power & Light 96,553,600.00 ₫ QUY 3 ́ 7/8/2012 ̉ ̉ San phâm 5 Fabrikam, Inc. 126,422,400.00 ₫ QUY 3 ́ 7/10/2012 ̉ ̉ San phâm 9 Alpine Ski House 49,795,200.00 ₫ QUY 3 ́ 7/15/2012 ̉ ̉ San phâm 13 Southridge Video 114,732,800.00 ₫ QUY 3 ́ 7/16/2012 ̉ ̉ San phâm 8 Fabrikam, Inc. 40,518,400.00 ₫ QUY 3 ́ 7/19/2012 ̉ ̉ San phâm 28 Contoso, Ltd 151,424,000.00 ₫ QUY 3 ́ 7/29/2012 ̉ ̉ San phâm 26 A. Datum Corporation 193,273,600.00 ₫ QUY 3 ́ 8/19/2012 ̉ ̉ San phâm 26 Fabrikam, Inc. 122,054,400.00 ₫ QUY 3 ́ 8/19/2012 ̉ ̉ San phâm 6 Northwind Traders 85,238,400.00 ₫ QUY 3 ́ 8/20/2012 ̉ ̉ San phâm 13 A. Datum Corporation 26,416,000.00 ₫ QUY 3 ́ 8/20/2012 ̉ ̉ San phâm 23 A. Datum Corporation 161,075,200.00 ₫ QUY 3 ́ 8/24/2012 ̉ ̉ San phâm 2 Humongous Insurance 114,150,400.00 ₫ QUY 3 ́ 8/24/2012 ̉ ̉ San phâm 5 Southridge Video 144,435,200.00 ₫ QUY 3 ́ 8/25/2012 ̉ ̉ San phâm 20 Fabrikam, Inc. 92,643,200.00 ₫ QUY 3 ́ 8/27/2012 ̉ ̉ San phâm 13 City Power & Light 147,680,000.00 ₫ QUY 3 ́ 8/30/2012 ̉ ̉ San phâm 8 Humongous Insurance 90,396,800.00 ₫ QUY 3 ́ 9/1/2012 ̉ ̉ San phâm 25 Alpine Ski House 42,265,600.00 ₫ QUY 3 ́ 9/17/2012 ̉ ̉ San phâm 20 Contoso, Ltd 48,422,400.00 ₫ QUY 3 ́ 9/22/2012 ̉ ̉ San phâm 18 Humongous Insurance 126,672,000.00 ₫ QUY 3 ́ 9/25/2012 ̉ ̉ San phâm 19 Coho Winery 173,555,200.00 ₫ QUY 3 ́ 9/29/2012 ̉ ̉ San phâm 11 Alpine Ski House 122,137,600.00 ₫ QUY 3 ́ 9/30/2012 ̉ ̉ San phâm 25 Humongous Insurance 32,822,400.00 ₫ QUY 3 ́ 10/2/2012 ̉ ̉ San phâm 29 City Power & Light 35,651,200.00 ₫ QUY 4 ́ 10/5/2012 ̉ ̉ San phâm 11 Fabrikam, Inc. 118,892,800.00 ₫ QUY 4 ́ 10/6/2012 ̉ ̉ San phâm 21 Coho Winery 171,475,200.00 ₫ QUY 4 ́ 10/14/2012 ̉ ̉ San phâm 11 A. Datum Corporation 184,870,400.00 ₫ QUY 4 ́ 10/14/2012 ̉ ̉ San phâm 23 City Power & Light 196,310,400.00 ₫ QUY 4 ́ 11/9/2012 ̉ ̉ San phâm 14 Southridge Video 129,584,000.00 ₫ QUY 4 ́ 11/13/2012 ̉ ̉ San phâm 17 A. Datum Corporation 88,982,400.00 ₫ QUY 4 ́ Page 2 of 6
NGAY ̀ ̉ ̉ SAN PHÂM KHACH HANG ́ ̀ SÔ TIÊN ́ ̀ QUÝ 11/17/2012 ̉ ̉ San phâm 6 Alpine Ski House 113,110,400.00 ₫ QUY 4 ́ 11/22/2012 ̉ ̉ San phâm 1 Coho Winery 139,942,400.00 ₫ QUY 4 ́ 11/25/2012 ̉ ̉ San phâm 30 Fabrikam, Inc. 207,833,600.00 ₫ QUY 4 ́ 11/25/2012 ̉ ̉ San phâm 26 Northwind Traders 176,009,600.00 ₫ QUY 4 ́ 11/27/2012 ̉ ̉ San phâm 11 Contoso, Ltd 164,944,000.00 ₫ QUY 4 ́ 11/30/2012 ̉ ̉ San phâm 30 Northwind Traders 169,228,800.00 ₫ QUY 4 ́ 12/2/2012 ̉ ̉ San phâm 13 Humongous Insurance 129,209,600.00 ₫ QUY 4 ́ 12/5/2012 ̉ ̉ San phâm 3 Contoso, Ltd 102,876,800.00 ₫ QUY 4 ́ 12/5/2012 ̉ ̉ San phâm 3 Southridge Video 177,923,200.00 ₫ QUY 4 ́ 12/10/2012 ̉ ̉ San phâm 24 Northwind Traders 93,766,400.00 ₫ QUY 4 ́ 12/21/2012 ̉ ̉ San phâm 7 Humongous Insurance 151,840,000.00 ₫ QUY 4 ́ 12/24/2012 ̉ ̉ San phâm 17 Fabrikam, Inc. 172,473,600.00 ₫ QUY 4 ́ 12/26/2012 ̉ ̉ San phâm 26 Alpine Ski House 203,465,600.00 ₫ QUY 4 ́ 1/3/2013 ̉ ̉ San phâm 19 Fabrikam, Inc. 166,899,200.00 ₫ QUY 1 ́ 1/4/2013 ̉ ̉ San phâm 22 A. Datum Corporation 78,166,400.00 ₫ QUY 1 ́ Page 3 of 6
MEO: ̣ BAO CAO KINH DOANH ́ ́ ̉ Tùy chinh PivotTable na PivotTable đê ki ̉ ̣ ̉ ̣ ̀y cho phù hợp với nhu cầu cua ban! Chon môt ô trong ̉ ́ch hoat ngăn Danh sa ̣ kéo đê thêm, loai bo hoăc să ̉ ̣ ̣ ̣ ́ch Trường PivotTable. Sau đó ở ngăn tác vu, ̣ ̣ ́c trường. Ví du, ke ́p xếp lai ca ̣ ́o trường San phâm lên ̉ ̉ trên trường Khách hàng đê co ̉ ́ cái nhìn khác. Đê câp nhât d ̉ ̣ ̣ ữ liêu PivotTable, ha ̣ ̃y Sum - SỐ TIỀN Years QUÝ ̉ ̣ bấm phai chuôt trong PivotTable sau đo ́ bấm Là m mớ i. 2012 2013 Total Result SẢN PHẨM KHÁCH HÀNG QÚY 1 QUÝ 2 QUÝ 3 QUÝ 4 QÚY 1 Sản phẩm 1 Coho Winery ### 139,942,400.00 ₫ Contoso, Ltd ### 134,035,200.00 ₫ Sản phẩm 10 Southridge Video ### ### 315,494,400.00 ₫ Sản phẩm 11 A. Datum Corporation ### 184,870,400.00 ₫ Alpine Ski House ### 122,137,600.00 ₫ Contoso, Ltd ### 164,944,000.00 ₫ Fabrikam, Inc. ### 118,892,800.00 ₫ Sản phẩm 13 A. Datum Corporation 26,416,000.00 ₫ 26,416,000.00 ₫ City Power & Light ### 147,680,000.00 ₫ Contoso, Ltd 92,435,200.00 ₫ 92,435,200.00 ₫ Fabrikam, Inc. ### 104,166,400.00 ₫ Humongous Insurance ### 129,209,600.00 ₫ Southridge Video ### 114,732,800.00 ₫ Sản phẩm 14 Alpine Ski House 76,876,800.00 ₫ 76,876,800.00 ₫ Coho Winery ### 147,347,200.00 ₫ Fabrikam, Inc. 39,228,800.00 ₫ 39,228,800.00 ₫ Southridge Video ### 129,584,000.00 ₫ Sản phẩm 15 City Power & Light 47,964,800.00 ₫ 47,964,800.00 ₫ Humongous Insurance 83,449,600.00 ₫ 83,449,600.00 ₫ Sản phẩm 16 A. Datum Corporation 48,505,600.00 ₫ 48,505,600.00 ₫ Alpine Ski House 74,755,200.00 ₫ 74,755,200.00 ₫ Coho Winery ### 116,688,000.00 ₫ Sản phẩm 17 A. Datum Corporation 88,982,400.00 ₫ 88,982,400.00 ₫ Fabrikam, Inc. ### 172,473,600.00 ₫ Humongous Insurance 76,793,600.00 ₫ 76,793,600.00 ₫ Sản phẩm 18 Coho Winery ### 169,395,200.00 ₫ Humongous Insurance ### 126,672,000.00 ₫ Sản phẩm 19 Coho Winery ### 173,555,200.00 ₫ Fabrikam, Inc. ### 166,899,200.00 ₫ Sản phẩm 2 City Power & Light 96,553,600.00 ₫ 96,553,600.00 ₫ Contoso, Ltd 74,422,400.00 ₫ 74,422,400.00 ₫ Fabrikam, Inc. ### 172,016,000.00 ₫ Humongous Insurance ### 114,150,400.00 ₫ Sản phẩm 20 Contoso, Ltd 48,422,400.00 ₫ 48,422,400.00 ₫ Fabrikam, Inc. 92,643,200.00 ₫ 92,643,200.00 ₫ Sản phẩm 21 Alpine Ski House ### 111,696,000.00 ₫ Coho Winery ### 171,475,200.00 ₫ Northwind Traders 47,091,200.00 ₫ 47,091,200.00 ₫ Sản phẩm 22 A. Datum Corporation 78,166,400.00 ₫ 78,166,400.00 ₫ City Power & Light 30,867,200.00 ₫ 30,867,200.00 ₫ Humongous Insurance ### 103,209,600.00 ₫ Page 4 of 6
MEO: ̣ ̉ Tùy chinh PivotTable na ̀y cho phù hợp với nhu cầu cua ban! Chon môt ô trong ̉ ̣ ̣ ̣ ̉ ́ch hoat ngăn Danh sa PivotTable đê ki ̣ ́ch Trường PivotTable. Sau đó ở ngăn tác vu, ̣ ̉ ̣ ̉ ̣ kéo đê thêm, loai bo hoăc să ̣ ́c trường. Ví du, ke ́p xếp lai ca ̣ ́o trường San phâm lên ̉ ̉ trên trường Khách hàng đê co ̉ ́ cái nhìn khác. Đê câp nhât d ̉ ̣ ̣ ữ liêu PivotTable, ha ̣ ̃y Sum - SỐ TIỀN Years QUÝ ̉ ̣ bấm phai chuôt trong PivotTable sau đo ́ bấm Là m mớ i. 2012 2013 Total Result Southridge Video 23,795,200.00 ₫ 23,795,200.00 ₫ Sản phẩm 23 A. Datum Corporation ### 161,075,200.00 ₫ Alpine Ski House 83,657,600.00 ₫ 83,657,600.00 ₫ City Power & Light ### 196,310,400.00 ₫ Sản phẩm 24 Coho Winery ### 113,859,200.00 ₫ Northwind Traders 93,766,400.00 ₫ 93,766,400.00 ₫ Sản phẩm 25 Alpine Ski House 42,265,600.00 ₫ 42,265,600.00 ₫ Contoso, Ltd ### 196,060,800.00 ₫ Humongous Insurance 32,822,400.00 ₫ 32,822,400.00 ₫ Sản phẩm 26 A. Datum Corporation ### 193,273,600.00 ₫ Alpine Ski House ### 203,465,600.00 ₫ Fabrikam, Inc. ### 122,054,400.00 ₫ Humongous Insurance ### 113,443,200.00 ₫ Northwind Traders ### 176,009,600.00 ₫ Sản phẩm 27 Southridge Video 57,657,600.00 ₫ 57,657,600.00 ₫ Sản phẩm 28 City Power & Light ### 189,904,000.00 ₫ Coho Winery ### 160,659,200.00 ₫ Contoso, Ltd ### 151,424,000.00 ₫ Fabrikam, Inc. 72,675,200.00 ₫ 72,675,200.00 ₫ Humongous Insurance ### 189,779,200.00 ₫ Southridge Video ### 207,708,800.00 ₫ Sản phẩm 29 City Power & Light 35,651,200.00 ₫ 35,651,200.00 ₫ Sản phẩm 3 Contoso, Ltd ### 102,876,800.00 ₫ Humongous Insurance 53,913,600.00 ₫ 53,913,600.00 ₫ Southridge Video ### 177,923,200.00 ₫ Sản phẩm 30 A. Datum Corporation ### 107,827,200.00 ₫ City Power & Light ### 180,419,200.00 ₫ Coho Winery ### 194,979,200.00 ₫ Fabrikam, Inc. ### 207,833,600.00 ₫ Northwind Traders ### 169,228,800.00 ₫ Sản phẩm 5 Fabrikam, Inc. ### 126,422,400.00 ₫ Southridge Video ### 144,435,200.00 ₫ Sản phẩm 6 Alpine Ski House ### 113,110,400.00 ₫ City Power & Light 36,774,400.00 ₫ 36,774,400.00 ₫ Northwind Traders 85,238,400.00 ₫ 85,238,400.00 ₫ Sản phẩm 7 Coho Winery ### 132,953,600.00 ₫ Humongous Insurance ### 151,840,000.00 ₫ Sản phẩm 8 A. Datum Corporation ### 190,652,800.00 ₫ City Power & Light 69,097,600.00 ₫ 69,097,600.00 ₫ Fabrikam, Inc. 40,518,400.00 ₫ 40,518,400.00 ₫ Humongous Insurance 90,396,800.00 ₫ 90,396,800.00 ₫ Sản phẩm 9 A. Datum Corporation ### 179,961,600.00 ₫ Alpine Ski House 49,795,200.00 ₫ 49,795,200.00 ₫ Total Result ### ### ### ### ### ### Page 5 of 6
DANH SACH D ́ Ư LIÊU ̃ ̣ SAN PHÂM ̉ ̉ KHACH HANG ́ ̀ MEO: ̣ ̉ ̣ ̉ ̉ ̣ Đê thêm môt san phâm hoăc kha ́ch hàng mới, hãy bắt ̉ ̉ San phâm 1 A. Datum Corporation ̣ ̉ đầu nhâp bang d ưới đây và nó sẽ tự đông m ̣ ở rông khi ̣ ̉ ̉ San phâm 2 Adventure Works ̣ ban nhâ ̣ ́n phím Enter hoăc phi ́m Tab. ̉ ̉ San phâm 3 Alpine Ski House ̉ ̉ San phâm 4 Blue Yonder Airlines ̉ ̉ San phâm 5 City Power & Light ̉ ̉ San phâm 6 Coho Vineyard ̉ ̉ San phâm 7 Coho Winery ̉ ̉ San phâm 8 Coho Vineyard & Winery ̉ ̉ San phâm 9 Contoso, Ltd ̉ ̉ San phâm 10 Contoso Pharmaceuticals ̉ ̉ San phâm 11 Consolidated Messenger ̉ ̉ San phâm 12 Fabrikam, Inc. ̉ ̉ San phâm 13 Fourth Coffee ̉ ̉ San phâm 14 ̣ ́ ́ ̀ ̣ Viên Thiêt kê Đô hoa ̉ ̉ San phâm 15 Humongous Insurance ̉ ̉ San phâm 16 Litware, Inc. ̉ ̉ San phâm 17 Lucerne Publishing ̉ ̉ San phâm 18 Margie's Travel ̉ ̉ San phâm 19 Northwind Traders ̉ ̉ San phâm 20 Proseware, Inc. ̉ ̉ San phâm 21 Trương My thuât ̀ ̃ ̣ ̉ ̉ San phâm 22 Southridge Video ̉ ̉ San phâm 23 Tailspin Toys ̉ ̉ San phâm 24 Trey Research ̉ ̉ San phâm 25 ̣ ̣ Công ty Điên thoai ̉ ̉ San phâm 26 Wide World Importers ̉ ̉ San phâm 27 Wingtip Toys ̉ ̉ San phâm 28 Woodgrove Bank ̉ ̉ San phâm 29 ̉ ̉ San phâm 30 Page 6 of 6