Bảng kê nghiệp vụ phát sinh

B¶ng ke nghiÖp vô ph¸t sinh
TuÇn 1 Th¸ng 3- 2000

Ngµy Kh¸ch Hµng SL­îng §¬n gi¸ TrÞ gi¸ ThuÕ Céng
01-03 MISA KEO 520 160 83200 0.03 80704
01-03 SUKA SUA 650 200 130000 0.025 126750
01-03 YAMA BAP 255 100 25500 0.012 25194
01-03 BOVA BIA 254 600 152400 0.055 144018
01-03 CEB NEP 230 150 34500 0.012 34086
02-03 MISA GAO 190 120 22800 0.01 22572
02-03 SUKA KEO 260 160 41600 0.03 40352
02-03 YAMA NEP 230 150 34500 0.012 34086
02-03 MISA SUA 400 200 80000 0.025 78000
02-03 SUKA BAP 590 100 59000 0.012 58292
02-03 MISA GAO 800 120 96000 0.01 95040
02-03 SUKA NEP 765 150 114750 0.012 113373
02-03 YAMA BIA 320 600 192000 0.055 181440
02-03 BOVA SUA 350 200 70000 0.025 68250
02-03 CEB BAP 650 100 65000 0.012 64220
05-03 YAMA BAP 580 100 58000 0.012 57304
05-03 BOVA GAO 850 120 102000 0.01 100980
05-03 CEB BIA 950 600 570000 0.055 538650
05-03 MISA NEP 650 150 97500 0.012 96330
05-03 SUCA KEO 500 160 80000 0.03 77600
06-03 YAMA SUA 400 200 80000 0.025 78000
06-03 BOVA KEO 650 160 104000 0.03 100880
06-03 CEB GAO 750 120 90000 0.01 89100
06-03 SUCA NEP 500 150 75000 0.012 74100

B¶ng gi¸ Tæng hîp sè liÖu doanh thu
Lo¹i §¬n gi¸ ThuÕ Hµng Céng Kh¸ch Céng
GAO 120 1.00% GAO 307692 MISA 372646
NEP 150 1.20% NEP 351975 SUKA 338767
KEO 160 3.00% KEO 299536 BOVA 414128
SUA 200 2.50% SUA 351000 CEB 726056
BIA 600 5.50% BIA 864108 YAMA 376024
BAP 100 1.20% BAP 205010 0

BiÕt: TrÞ gi¸= §¬n gi¸* Sè l­îng
Céng = TrÞ gi¸ - ThuÕ * TrÞ gi¸
"VÏ biÓu ®ß Pie cho sè liÖu tæng h¬pù doanh thu theo mÆt hµng, vµ kiÓu Column theo kh¸ch"