Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Format Sensitivity Formatting as Table Styles v Filter Select Data E25 X V fx Male B E G N Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 2 750-67-8428 A fangon Member Female Health and beauty 74.69 522.83 26.14 548.97 5/1/19 13:08 Ewallet 226-31-3081 C Naypyitaw Normal Female Electronic accessories 15.28 76.40 3.82 80.22 8/3/15 10:29 Cash 631-41-3108 A Yangon Normal Male Home and lifestyle 46.33 324.3 16.22 340.53 3/3/19 13:23 Credit card 5 123-19-1176 A fangor Member Male Health and beauty 58.22 165.76 23.29 189.05 1/27/2019 20:33 Ewallet 6 373-73-7910 A fangon Normal Male Sports and travel 86.31 504.17 30.21 634.38 8/2/19 10:37 Ewallet 7 699-14-3026 C Naypyitaw Normal Male Electronic accessories 85.39 597.73 29.89 527.62 3/25/2019 18:30 Ewallet 8 355-53-5943 A Yangon Member Female Electronic accessories 68.84 413.04 20.65 433.69 2/25/2019 14:36 Ewallet 9 315-22-5665 C Naypyitaw Normal Female Home and lifestyle 73.56 735.6 36.78 772.38 2/24/2019 1:38 Ewallet 10 665-32-9167 Yangon Member Female Health and beauty 36.26 72.52 3.63 76.15 10/1/19 17:15 Credit card 11 692-92-5582 B Mandalay Member Female Food and beverages 54.84 164.52 8.23 172.75 2/20/2019 13:27 Credit card 12 351-62-0822 B Mandalay Member Female Fashion accessories 14.48 57.92 2.90 60.82 6/2/19 18:07 Ewallet 13 529-56-3974 B Mandalay Member Male Electronic accessories 25.51 102.04 5.10 107.14 9/3/19 17:03 Cash 14 365-64-0515 A Yangon Normal Female Electronic accessories 46.95 234.75 11.74 246.4 12/2/19 10:25 Ewallet 15 252-56-2699 fangon Normal Male Food and beverages 43.19 131.90 21.60 153.50 7/2/19 16:48 Ewallet 16 829-34-3910 A fangon Normal Female Health and beauty 71.38 713.80 35.69 749.49 3/29/2019 19:21 Cash 17 299-46-1805 B Mandalay Member Female Sports and travel 93.72 562.32 28.12 590.44 1/15/2019 16:19 Cash 18 656-95-9349 A Yangon Member Female Health and beauty 68.93 182.51 24.13 506.6 11/3/19 11:03 Credit card 19 765-26-6951 Yangon Normal Male Sports and travel 72.61 435.66 21.78 457.44 1/1/19 10:39 Credit card 20 329-62-1586 fangon Normal Male Food and beverages 54.67 164.01 8.20 72.21 1/21/2019 18:00 Credit card 21 319-50-3348 B Mandalay Normal Female Home and lifestyle 40.30 80.60 4.03 84.63 11/3/19 15:30 Ewallet 22 300-71-4605 C Naypyitaw Member Male Electronic accessories 86.04 30.20 21.51 51.71 2/25/2019 11:24 Ewallet 23 371-85-5789 B Mandalay Normal Male Health and beauty 87.98 263.94 13.20 277.14 5/3/19 10:40 Ewallet 24 273-16-6619 B Mandalay Normal Male Home and lifestyle 33.20 66.40 3.32 69.72 3/15/2019 12:20 Credit card 25 636-48-8204 fangor Normal Male Electronic accessories 34.56 172.80 8.64 181.44 2/17/201 11:15 Ewallet 26 549-59-1358 A fangon Member Male Sports and trave 88.63 265.89 13.29 279.18 2/3/19 17:36 Ewallet 27 227-03-5010 A fangon Member Female Home and lifestyle 52.59 420.72 21.04 441.76 3/22/2019 19:20 Credit card 28 649-29-6775 B Mandalay Normal Male Fashion accessories 33.52 33.52 1.6 35.20 8/2/19 15:31 Cash 29 189-17-4241 Yangon Normal Female Fashion accessories 87.67 175.34 8.77 184.11 10/3/1 12:17 Credit card 30 145-94-9061 B Mandalay Normal Female Food and beverages 88.36 141.80 22.09 163.89 1/25/201 19:48 Cash 31 848-62-7243 A Yangon Normal Male Health and beauty 24.89 224.01 11.20 235.21 3/15/2019 15:36 Cash 32 871-79-8483 B Mandalay Normal Male Fashion accessories 94.13 470.65 23.53 494.18 2/25/2019 19:39 Credit card 33 149-71-6266 B Mandalay Member Male Sports and travel 78.07 702.63 35.13 737.76 1/28/2019 12:43 Cash 34 640-49-2076 B Mandalay Normal Male Sports and travel 83.78 670.24 33.51 703.75 10/1/1 14:49 Cash 35 595-11-5460 fangon Norma Male Health and beauty 96.58 193.16 9.66 202.82 3/15/2019 10:12 Credit card 36 183-56-6882 Naypyitaw Member Female Food and beverages 99.42 97.68 19.88 17.56 6/2/19 10:42 Ewallet 37 232-16-2483 Naypyitaw Member Female Sports and travel 68.12 68.12 3.41 71.53 7/1/19 12:28 Ewallet 38 129-29-8530 A fangor Member Male Sports and travel 62.62 313.10 15.66 328.76 10/3/19 19:15 Ewallet 39 272-65-1806 A Yangon Normal Female Electronic accessories 60.88 547.92 27.40 575.32 1/15/2019 17:17 Ewallet 10 333-73-7901 Naypyitaw Norma Female Health and beauty 54.92 139.36 21.97 161.33 3/23/2019 13:24 Ewallet 41 777-82-7220 B Mandalay Member Male Home and lifestyle 30.12 240.96 12.05 253.01 3/3/19 13:01 Cash 42 280-35-5823 B Mandalay Member Female Home and lifestyle 86.72 86.72 4.34 91.06 1/17/2019 18:45 Ewallet 43 554-53-8700 c Naypyitaw Member Male Home and lifestyle 56.11 112.22 5.61 117.83 2/2/19 10:11 Cash 44 354-25-5821 B Mandalay Member Female Sports and travel 69.12 414.72 20.74 435.46 8/2/19 13:03 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male E G N Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 44 354-25-5821 B Mandalay Member Female Sports and travel 69.12 6 414.72 20.74 135.46 8/2/19 13:03 Cash 45 228-96-1411 C Naypyitaw Member Female Food and beverages 98.70 789.60 39.48 329.08 4/3/19 20:39 Cast 46 617-15-4209 C Naypyitaw Member Male Health and beauty 15.37 30.74 1.54 32.28 3/16/2019 19:47 Cash 47 132-32-9879 B Mandalay Member Female Electronic accessories 93.96 375.84 18.79 394.63 9/3/19 18:00 Cash 48 370-41-7321 B Mandalay Member Male Health and beauty 56.69 510.21 25.51 535.72 2/27/2019 17:24 Credit card 49 727-46-3608 B Mandalay Member Female Food and beverages 20.01 180.09 9.00 189.09 6/2/19 15:47 Ewallet 50 669-54-1719 B Mandalay Member Male Electronic accessories 18.93 113.58 5.68 119.26 10/2/19 12:45 Credit card 51 574-22-5561 C Naypyitaw Member Female Fashion accessories 82.63 826.30 41.32 867.62 3/19/2019 17:08 Ewallet 52 326-78-5178 C Naypyitaw Member Male Food and beverages 91.40 639.80 31.99 571.79 3/2/19 10:19 Cash 53 162-48-8011 A Yangon Member Female Food and beverages 44.59 222.95 11.15 234.10 10/2/1 15:10 Cash 54 616-24-2851 B Mandalay Member Female Fashion accessories 17.87 71.48 3.57 75.05 3/22/2019 14:42 Ewallet 55 778-71-5554 C Naypyitaw Member Male Fashion accessories 15.43 15.43 0.77 16.20 1/25/2019 15:46 Credit card 56 242-55-6721 B Mandalay Normal Male Home and lifestyle 16.16 32.32 1.62 33.94 7/3/19 11:49 Ewallet 57 399-46-5918 C Naypyitaw Normal Female Electronic accessories 85.98 587.84 34.39 722.23 2/28/2019 19:01 Cash 58 106-35-6779 A fangon Member Male Home and lifestyle 44.34 88.68 4.43 93.11 3/27/2019 11:26 Cash 59 635-40-6220 A fangor Norma Male Health and beauty 89.60 716.80 35.84 752.64 7/2/19 11:28 Ewallet 60 817-48-8732 A Yangon Member Female Home and lifestyle 72.35 723.50 36.18 759.68 1/20/2019 15:55 Cash 61 120-06-4233 C Naypyitaw Normal Male Electronic accessories 30.61 183.66 9.18 192.84 12/3/19 20:36 Cash 62 285-68-5083 C Naypyitaw Member Female Sports and travel 24.74 74.22 3.71 77.93 2/15/2019 17:47 Credit card 63 803-83-5989 Naypyitaw Norma Male Home and lifestyle 55.73 334.38 16.72 351.10 2/24/2019 10:55 Ewallet 54 347-34-2234 B Mandalay Member Female Sports and travel 55.07 495.63 24.78 520.41 3/2/19 13:40 Ewallet 65 199-75-8169 A Yangon Member Male Sports and travel 15.81 158.10 7.91 166.01 6/3/19 12:27 Credit card 66 853-23-2453 B Mandalay Member Male Health and beauty 75.74 302.96 15.15 318.11 2/14/201 14:35 Cash 67 877-22-3308 fangon Member Male Health and beauty 15.87 158.70 7.94 166.64 3/13/2019 16:40 Cash 68 838-78-4295 Naypyitaw Norma Female Health and beauty 33.47 66.94 3.35 70.29 10/2/19 15:43 Ewallet 69 109-28-2512 B Mandalay Member Female Fashion accessories 97.61 585.66 29.28 614.94 7/1/19 15:01 Ewallet 70 232-11-3025 A Yangon Normal Male Sports and travel 78.77 787.70 39.39 327.0 1/24/2019 10:04 Cash 71 382-03-4532 A fangon Member Female Health and beauty 18.33 18.33 0.92 19.25 2/2/19 18:50 Cash 72 393-65-2792 C Naypyitaw Normal Male Food and beverages 89.48 894.80 44.74 139.54 6/1/19 12:46 Credit card 73 796-12-2025 Naypyitaw Normal Male Fashion accessories 62.12 621.20 31.06 52.26 11/2/19 16:19 Cash 74 510-95-6347 B Mandalay Member Female Food and beverages 48.52 145.56 7.28 152.84 5/3/19 18:17 Ewallet 75 841-35-6630 C Naypyitaw Normal Female Electronic accessories 75.91 455.46 22.77 478.23 9/3/19 18:21 Cash 76 287-21-9091 A Yangon Normal Male Home and lifestyle 74.67 672.03 33.60 705.6 1/22/2019 10:55 Ewallet 77 732-94-0499 C Naypyitaw Normal Female Electronic accessories 41.65 $16.50 20.83 137.33 1/13/2019 17:04 Credit card 78 263-10-3913 Naypyitaw Member Male Fashion accessories 49.04 141.36 22.07 163.43 9/1/1 14:20 Credit card 79 381-20-0914 A Yangon Member Female Fashion accessories 20.01 180.09 9.00 189.0 12/1/19 15:48 Credit card 80 829-49-1914 C Naypyitaw Member Female Food and beverages 78.31 783.10 39.16 322.26 5/3/19 16:24 Ewallet 81 756-01-7507 c Naypyitaw Normal Female Health and beauty 20.38 101.90 5.10 107.00 1/22/2019 18:56 Cash 82 870-72-4431 C Naypyitaw Normal Female Health and beauty 99.19 595.14 29.76 524.90 1/21/2019 14:42 Credit card 83 847-38-7188 Mandalay Norma Female Food and beverages 96.68 290.04 14.50 304.5 1/26/2019 19:56 Ewallet 84 480-63-2856 Naypyitaw Normal Male Food and beverages 19.25 154.00 7.70 161.70 1/23/2019 18:37 Ewallet 85 787-56-0757 C Naypyitaw Member Female Food and beverages 80.36 321.44 16.07 337.51 2/23/2019 18:45 Credit card 86 360-39-5055 c Naypyitaw Member Male Sports and travel 48.91 244.55 12.23 256.78 9/3/19 10:17 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste Analyse BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E G N Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 86 360-39-5055 C Naypyitaw Member Male Sports and travel 48.91 244.55 12.23 256.78 9/3/19 10:17 Cash 87 730-50-9884 C Naypyitaw Normal Female Sports and travel 83.06 581.42 29.07 610.49 5/3/19 14:31 Ewallet 88 362-58-8315 C Naypyitaw Normal Male Fashion accessories 76.52 382.60 19.13 101.73 3/25/2019 10:23 Cash 89 633-44-8566 A fangor Member Male Food and beverages 49.38 345.66 17.28 362.94 3/27/2019 20:35 Credit card 90 504-35-8843 A Yangon Normal Male Sports and travel 42.47 42.47 2.12 44.59 2/1/19 16:57 Cash 91 318-68-5053 B Mandalay Normal Female Health and beauty 76.99 461.94 23.10 485.04 2/27/2019 17:55 Cash 2 565-80-5980 C Naypyitaw Member Female Home and lifestyle 17.38 189.52 9.48 199.00 1/23/2019 10:25 Cash 93 225-32-0908 C Naypyitaw Normal Female Sports and travel 44.86 448.6 22.43 171.03 1/26/2019 19:54 Ewallet 34 873-51-0671 A Yangon Member Female Sports and travel 21.98 153.8 7.69 161.55 10/1/1 16:42 Ewallet 95 152-08-9985 B Mandalay Member Male Health and beauty 64.36 579.24 28.96 08.20 12/3/19 12:09 Credit card 96 512-91-0811 C Naypyitaw Normal Male Health and beauty 89.75 89.75 4.49 94.24 6/2/19 20:05 Credit card 97 594-34-4444 Yangon Normal Male Electronic accessories 97.16 97.16 4.86 102.02 8/3/19 20:38 Ewallet 98 766-85-7061 B Mandalay Normal Male Health and beauty 87.87 878.70 13.94 322.6 3/29/2019 10:25 Ewallet 99 871-39-9221 C Naypyitaw Normal Female Electronic accessories 12.45 74.70 3.74 78.44 9/2/ 19 13:11 Cash 100 865-92-6136 A Yangon Normal Male Food and beverages 52.75 158.25 7.91 166.16 3/23/2019 10:16 Ewallet 101 733-01-9107 B Mandalay Normal Male Home and lifestyle 82.70 496.20 4.8 21.01 5/3/19 18:14 Cash 102 163-56-7055 C Naypyitaw Member Male Fashion accessories 48.71 48.71 2.44 51.15 3/26/2019 19:20 Cash 103 189-98-2939 Naypyitaw Normal Male Fashion accessories 78.55 706.95 35.35 42.30 1/3/19 13:22 Cash 104 551-21-3069 C Naypyitaw Normal Female Electronic accessories 23.07 207.63 10.38 218.01 1/2/19 11:27 Cash 105 212-62-1842 A Yangon Normal Male Food and beverages 58.26 349.56 17.48 367.04 3/28/2019 16:44 Cash 106 716-39-1409 B Mandalay Normal Male Health and beauty 30.35 212.45 10.62 223.07 3/19/2019 18:19 Cash 107 704-48-3927 Yangon Member Male Electronic accessories 88.67 886.70 44.34 931.04 12/1/19 14:50 Ewallet 108 628-34-3388 C Naypyitaw Normal Male Fashion accessories 27.38 164.28 8.21 172.49 5/1/19 20:54 Credit card 109 630-74-5166 A Yangon Normal Male Sports and travel 62.13 372.78 18.64 391.4 3/22/2019 20:19 Cash 110 588-01-7461 C Naypyitaw Normal Female Food and beverages 33.98 305.82 15.29 321.11 3/24/2019 10:43 Cash 111 861-77-0145 C Naypyitaw Member Male Electronic accessories 31.97 819.70 40.99 360.6 3/3/19 14:30 Cash 112 479-26-8945 B Mandalay Member Female Sports and travel 16.49 32.98 1.65 34.63 5/2/19 11:32 Ewallet 113 210-67-5886 C Naypyitaw Member Female Health and beauty 98.21 294.63 14.73 09.36 5/2/19 10:41 Credit card 114 227-78-1148 B Mandalay Norma Female Fashion accessories 72.84 509.88 25.49 535.37 2/15/20 12:44 Cash 115 645-44-1170 A Yangon Member Male Home and lifestyle 58.07 522.63 26.13 548.76 1/19/2019 20:07 Ewallet 116 237-01-6122 C Naypyitaw Member Female Home and lifestyle 80.79 727.11 36.36 763.47 1/2/19 20:31 Credit card 117 225-98-1496 C Naypyitaw Normal Female Fashion accessories 27.02 81.06 4.05 85.11 2/3/19 13:01 Credit card 118 291-32-1427 B Mandalay Member Male Fashion accessories 21.94 109.70 5.49 15.19 5/3/19 12:29 Ewallet 119 659-65-8956 B Mandalay Member Male Fashion accessories 51.36 51.36 2.57 53.93 1/16/201 15:26 Ewallet 120 642-32-2990 A Yangon Normal Female Food and beverages 10.96 109.60 5.48 115.08 2/2/19 20:48 Ewallet 121 378-24-2715 B Mandalay Normal Male Home and lifestyle 53.44 106.88 5.34 112.22 1/20/2019 20:38 Ewallet 122 638-60-7125 fangon Normal Female Electronic accessories 99.56 796.48 39.82 836.30 2/14/2019 17:03 Credit card 123 659-36-1684 Naypyitaw Member Male Sports and travel 57.12 399.84 19.99 $19.83 12/1/1 12:02 Credit 124 219-22-9386 B Mandalay Member Male Sports and travel 99.96 899.64 44.98 344.62 9/3/19 17:26 Credit card 125 336-78-2147 Naypyitaw Member Male Home and lifestyle 63.91 511.2 25.56 536.84 3/13/2019 19:52 Credit card 126 268-27-6179 Mandalay Member Female Fashion accessories 56.47 151.76 22.59 474.35 9/3/19 14:57 Ewallet 127 668-90-8900 Yangon Normal Female Home and lifestyle 3.69 $55.83 32.79 588.62 10/3/19 18:44 Credit card 128 870-54-3162 A Yangon Normal Female Sports and travel 32.25 161.25 8.06 169.31 1/27/2019 13:26 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v ZAY- O. Ex Delete Paste BIUV CvAv E Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Formatting as Table Styles Format Sensitivity v Filter Select Data E25 X V fx Male B E G N 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 128 870-54-3162 A fangon Normal Female Sports and travel 32.25 161.2 8.06 169.31 1/27/2019 13:26 Cash 129 189-08-9157 C Naypyitaw Normal Female Fashion accessories 31.73 285.57 14.28 299.85 8/1/19 16:17 Credit card 130 663-86-9076 C Naypyitaw Member Female Food and beverages 68.54 548.32 27.42 575.74 8/1/19 15:57 Ewallet 131 549-84-7482 B Mandalay Norma Female Sports and travel 90.28 312.52 40.63 353.15 8/2/19 11:15 Ewallet 132 191-10-6171 B Mandalay Normal Female Fashion accessories 39.62 277.34 13.87 291.21 1/25/2019 13:18 Cash 133 802-70-5316 A fangon Member Female Sports and trave 92.13 552.78 27.64 580.42 6/3/19 20:34 Cash 134 695-51-0018 B Mandalay Normal Female Sports and travel 34.84 139.36 6.97 146.33 10/2/19 18:36 Cash 135 590-83-4591 B Mandalay Member Male Electronic accessories 87.45 524.70 26.24 550.94 2/17/2019 14:40 Credit card 136 483-71-1164 Naypyitaw Normal Female Health and beauty 81.30 87.80 24.39 512.19 8/3/19 16:43 Ewallet 137 597-78-7908 Naypyitaw Normal Male Fashion accessories 90.22 270.66 13.53 284.19 2/18/2019 19:39 Cash 138 700-81-1757 A fangor Normal Female Electronic accessories 26.31 131.55 6.58 138.13 1/18/2019 20:59 Credit card 139 354-39-5160 A fangor Member Female Home and lifestyle 34.42 206.52 10.33 216.85 2/18/2019 15:39 Cash 140 241-72-9525 B Mandalay Normal Male Sports and travel 1.91 519.10 5.96 545.06 2/16/2019 12:21 Cash 141 575-30-8091 fangon Norma Male Sports and travel 72.50 580.00 29.00 509.00 3/16/201 19:25 Ewallet 142 731-81-9469 Naypyitaw Member Female Sports and travel 89.80 898.00 44.90 942.90 1/23/2019 13:00 Credit card 143 280-17-4359 Naypyitav Member Male Health and beauty 90.50 10 905.0 45.25 950.25 1/25/2019 13:48 Cash 144 338-65-2210 C Naypyitaw Member Female Health and beauty 68.60 586.00 34.30 20.30 5/2/19 19:57 Cash 145 488-25-4221 C Naypyitaw Member Female Food and beverages 30.41 30.41 1.57 31.93 2/22/2019 10:36 Credit card 146 239-10-7476 fangon Normal Female Home and lifestyle 77.95 167.70 23.39 191.09 1/21/2019 16:37 Ewallet 147 458-41-1477 Naypyitaw Normal Female Health and beauty 46.26 277.56 13.88 291.44 8/3/19 17:11 Credit card 148 685-64-1609 A fangon Member Female Fashion accessories 30.14 10 301.40 15.07 316.47 10/2/19 12:28 Ewallet 149 568-90-5112 C Naypyitaw Normal Male Health and beauty 66.14 264.56 13.23 277.7 3/19/2019 12:46 Credit card 150 262-47-2794 B Mandalay Member Male Home and lifestyle 71.86 574.88 28.74 603.62 6/3/19 15:07 Credit card 151 238-49-0436 fangon Norma Male Health and beauty 32.46 259.68 12.98 272.66 3/27/2019 13:48 Credit card 152 608-96-3517 B Mandalay Member Female Fashion accessories 91.54 366.16 18.31 384.47 3/23/2019 19:20 Credit card 153 584-86-7256 C Naypyitaw Member Male Sports and travel 34.56 241.92 12.10 254.02 11/3/19 16:07 Credit card 154 746-94-0204 A Yangon Normal Male Fashion accessories 83.24 749.16 37.46 786.62 1/29/2019 11:56 Credit card 155 214-17-6927 C Naypyitaw Normal Female Food and beverages 16.48 98.88 4.94 103.82 7/2/19 18:23 Ewallet 156 400-89-4171 Naypyitaw Norma Female Sports and travel 80.97 47.76 32.39 580.15 1/28/201 13:05 Cash 157 782-95-9291 A Yangon Member Male Food and beverages 92.29 161.45 23.07 184.52 2/20/2019 15:55 Credit card 158 279-74-2924 B Mandalay Member Male Electronic accessories 72.17 72.17 3.61 75.78 4/1/19 19:40 Cash 159 307-85-2293 B Mandalay Normal Male Home and lifestyle 50.28 251.40 12.57 263.97 7/3/19 13:58 Ewallet 160 743-04-1105 B Mandalay Member Male Health and beauty 97.22 374.98 13.7 918.73 3/30/2019 14:43 Ewallet 161 423-57-2993 B Mandalay Normal Male Sports and travel 93.39 560.34 28.02 588.36 3/27/201 19:18 Ewallet 162 894-41-5205 Naypyitaw Normal Female Food and beverages 43.18 345.44 17.27 362.71 1/19/2019 19:39 Credit card 163 275-28-0149 A fangor Normal Male Sports and travel 63.69 63.69 3.18 66.87 2/25/2019 16:21 Cash 164 101-17-6199 A Yangon Normal Male Food and beverages 45.79 320.53 16.03 336.56 3/13/2019 19:44 Credit card 165 423-80-0988 C Naypyitaw Normal Male Sports and travel 76.40 152.80 7.64 160.44 1/30/2019 19:42 Ewallet 166 548-46-9322 B Mandalay Normal Male Food and beverages 39.90 $99.00 19.95 $18.95 2/20/201 15:24 Credit card 167 505-02-0892 B Mandalay Member Male Health and beauty 42.57 340.56 17.03 357.59 2/25/2019 14:12 Ewallet 168 234-65-2137 Naypyitaw Normal Male Home and lifestyle 95.58 10 955.8 47.79 1,003.59 1/16/2019 13:32 Cash 169 687-47-8271 A Yangon Normal Male Fashion accessories 98.98 10 989.80 49.49 1,039.29 8/2/19 16:20 Credit card 170 796-32-9050 A Yangon Normal Male Food and beverages 51.28 307.68 15.38 $23.06 1/19/2019 16:31 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male E G 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 170 796-32-9050 A angon Normal Male Food and beverages 51.28 6 307.68 15.38 323.06 1/19/2019 16:31 Cash 171 105-31-1824 A Yangon Member Male Sports and travel 69.52 486.64 24.33 510.97 1/2/19 15:10 Credit card 172 249-42-3782 A Yangon Normal Male Health and beauty 70.01 350.05 17.50 367.5 3/1/19 11:36 Ewallet 173 316-55-4634 B Mandalay Member Male Food and beverages 80.05 400.25 20.01 420.26 1/26/2019 12:45 Credit card 174 733-33-4967 Naypyitaw Norma Male Electronic accessories 20.85 166.80 8.34 175.14 3/3/19 19:17 Cash 175 608-27-6295 B Mandalay Member Male Electronic accessories 52.89 317.3 15.87 333.21 1/19/2019 17:34 Credit card 176 414-12-7047 B Mandalay Normal Male Food and beverages 19.79 158.32 7.92 166.24 1/18/2019 12:04 Ewallet 177 827-26-2100 A fangor Member Male Home and lifestyle 33.84 304.56 15.23 319.79 3/21/2019 16:21 Ewallet 178 175-54-2529 fangon Member Male Food and beverages 22.17 177.36 8.87 186.23 3/3/19 17:01 Credit card 179 139-52-2867 Naypyitaw Normal Female Fashion accessories 22.51 157.57 7.88 165.45 2/13/2019 10:50 Credit card 180 407-63-8975 A Yangon Normal Male Food and beverages 73.88 143.28 22.16 465.44 3/23/2019 19:16 Ewallet 181 342-65-4817 Naypyitaw Member Male Health and beauty 86.80 260.40 13.02 273.42 1/28/2019 16:47 Ewallet 182 130-98-8941 Naypyitaw Normal Male Fashion accessories 64.26 449.82 22.49 472.31 9/2/19 10:00 Cash 183 434-83-9547 Naypyitaw Member Male Food and beverages 38.47 07.76 15.39 323.15 1/23/2019 1:51 Cash 184 851-28-6367 fangon Member Male Sports and travel 15.50 155.00 7.75 162.75 3/23/201 10:55 Ewallet 185 824-88-3614 Naypyitaw Normal Male Health and beauty 34.31 274.48 13.72 1/25/2019 15:00 Ewallet 186 586-25-0848 A Yangon Normal Female Sports and travel 12.34 86.38 4.32 90.70 4/3/19 11:19 Credit card 187 895-66-0685 B Mandalay Member Male Food and beverages 18.08 54.24 2.71 56.95 5/3/19 19:46 Ewallet 188 305-14-0245 B Mandalay Member Female Home and lifestyle 94.49 755.92 37.80 793.72 3/3/19 19:00 Ewallet 189 732-04-5373 B Mandalay Member Male Home and lifestyle 46.47 185.88 9.29 195.17 8/2/15 10:53 Cash 190 400-60-7251 A Yangon Normal Male Home and lifestyle 74.07 74.07 3.70 77.77 10/2/19 12:50 Ewallet 191 593-65-1552 C Naypyitaw Normal Female Home and lifestyle 69.81 279.24 13.96 293.20 1/28/2019 20:50 Credit card 192 284-34-9626 B Mandalay Normal Female Home and lifestyle 77.04 231.12 11.56 242.68 11/2/19 10:39 Credit card 193 437-58-8131 B Mandalay Normal Female Fashion accessories 73.52 147.04 7.35 154.39 1/15/2019 13:41 Ewallet 194 286-43-6208 Naypyitaw Norma Female Food and beverages 87.80 790.20 39.51 829.71 3/16/201 19:08 Cash 195 641-43-2399 B Mandalay Normal Male Home and lifestyle 25.55 102.20 5.11 107.31 1/26/2019 20:23 Ewallet 196 831-07-6050 A Yangon Normal Male Electronic accessories 32.71 163.55 8.18 171.73 3/19/2019 11:30 Credit card 197 556-86-3144 C Naypyitaw Member Female Fashion accessories 74.29 74.29 3.71 78.00 1/13/2019 19:30 Cash 198 848-24-9445 C Naypyitaw Member Male Health and beauty 43.70 87.40 4.37 91.77 3/26/2019 18:03 Cash 199 856-22-8149 Yangon Norma Female Home and lifestyle 25.29 25.29 1.26 26.55 3/23/2019 10:13 Ewallet 200 699-01-4164 Naypyitaw Normal Male Health and beauty 41.50 166.00 8.30 174.30 12/3/19 19:58 Credit card 201 420-11-4919 C Naypyitav Member Female Food and beverages 71.39 356.95 17.85 374.80 2/17/2019 19:57 Credit card 202 606-80-4905 C Naypyitaw Member Female Sports and travel 19.15 114.90 5.75 120.65 1/29/2019 10:01 Credit card 203 542-41-0513 B Mandalay Member Female Electronic accessories 57.49 229.96 11.50 241.46 3/15/2019 11:57 Cash 204 426-39-2418 Naypyitaw Normal Male Electronic accessories 61.41 429.87 21.49 151.36 1/14/2019 10:02 Cash 205 875-46-5808 B Mandalay Member Male Health and beauty 25.90 259.00 12.95 271.95 6/2/19 14:51 Ewallet 206 394-43-4238 B Mandalay Member Male Home and lifestyle 17.77 88.85 4.44 93.29 2/15/2019 12:42 Credit card 207 749-24-1565 A Yangon Normal Female Health and beauty 23.03 207.27 0.3 217.63 3/1/1 12:02 Ewallet 208 672-51-8681 C Naypyitaw Member Female Electronic accessories 66.65 99.85 29.99 529.84 4/1/19 18:19 Credit card 209 263-87-5680 Naypyitaw Member Female Home and lifestyle 28.53 85.30 14.27 299.5 3/18/2019 17:38 Ewallet 210 573-58-9734 B Mandalay Normal Female Fashion accessories 30.37 91.11 4.56 95.67 3/28/2019 13:41 Ewallet 211 817-69-8206 B Mandalay Normal Female Electronic accessories 99.73 897.57 44.88 942.45 2/3/19 19:42 Credit card 212 888-02-0338 A Yangon Normal Male Electronic accessories 26.23 236.07 11.80 247.87 1/25/2019 20:24 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Formatting as Table Styles Format Sensitivity v Filter Select Data E25 X V fx Male E G N 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 212 888-02-0338 A angon Normal Male Electronic accessories 26.23 236.07 11.80 247.87 1/25/2019 20:24 Ewallet 213 677-11-0152 C Naypyitaw Normal Female Food and beverages 93.26 839.34 41.97 881.31 1/16/2019 18:08 Cash 214 142-63-6033 B Mandalay Normal Male Home and lifestyle 92.36 161.80 23.09 484.89 3/20/2019 19:17 Ewallet 215 656-16-1063 B Mandalay Normal Male Sports and travel 46.42 139.26 6.96 146.27 4/1/19 13:24 Credit card 216 891-58-8335 B Mandalay Member Female Sports and travel 29.61 207.27 10.36 217.63 11/3/19 15:53 Cash 217 802-43-8934 A fangon Normal Male Home and lifestyle 18.28 18.28 0.91 19.19 3/22/2019 15:05 Credit card 218 560-30-5617 B Mandalay Normal Female Sports and travel 24.77 123.85 6.19 130.04 3/24/2019 18:27 Cash 219 319-74-2561 A Yangon Member Female Electronic accessories 94.64 283.92 14.20 298.12 2/21/2019 16:55 Cash 220 549-03-9315 B Mandalay Normal Male Fashion accessories 94.87 758.96 37.95 796.91 12/2/19 12:58 Ewallet 221 790-29-1172 B Mandalay Normal Female Food and beverages 57.34 172.02 8.60 180.62 10/3/19 18:59 Credit card 222 239-36-3640 B Mandalay Normal Male Electronic accessories 45.35 272.10 13.61 285.71 1/31/2019 13:44 Ewallet 223 468-01-2051 B Mandalay Normal Male Food and beverages 62.08 434.56 21.73 156.29 6/3/19 13:46 Ewallet 224 389-25-3394 C Naypyitaw Normal Male Electronic accessories 11.81 59.05 2.95 62.00 2/17/2019 18:06 Cash 225 279-62-1445 Naypyitaw Member Female Fashion accessories 12.54 12.54 0.63 13.17 2/21/201 12:38 Cash 226 213-72-6612 A Yangon Normal Male Food and beverages 43.25 86.50 4.33 90.83 3/20/2019 15:56 Cash 227 746-68-6593 Naypyitaw Member Female Sports and travel 87.16 174.32 8.72 183.04 11/1/19 14:29 Credit card 228 836-82-5858 B Mandalay Member Male Health and beauty 69.37 624.33 31.22 655.55 1/26/2019 19:14 Ewallet 229 583-72-1480 C Naypyitaw Member Male Electronic accessories 37.06 148.24 7.41 155.6 1/31/2019 16:24 Ewallet 230 466-61-5506 B Mandalay Member Female Electronic accessories 90.70 544.20 27.21 571.41 2/26/201 10:52 Cash 231 721-86-6247 A Yangon Normal Female Home and lifestyle 63.42 507.36 25.37 532.73 11/3/19 12:55 Ewallet 232 289-65-5721 B Mandalay Normal Female Fashion accessories 81.37 162.74 8.14 170.88 1/26/201 19:28 Cash 233 545-46-3100 B Mandalay Member Female Electronic accessories 10.59 31.77 1.59 33.36 12/3/19 13:52 Credit card 234 418-02-5978 B Mandalay Normal Female Health and beauty 84.09 756.81 37.84 794.65 11/2/1 10:54 Cash 235 269-04-5750 B Mandalay Member Male Fashion accessories 73.82 295.28 14.76 310.04 2/21/201 18:31 Cash 236 157-13-5295 A fangon Member Male Health and beauty 51.94 519.40 25.97 545.37 9/3/19 18:24 Ewallet 237 645-78-8093 A fangor Normal Female Sports and travel 93.14 186.28 9.31 195.59 1/20/2019 18:09 Ewallet 238 211-30-9270 C Naypyitaw Normal Male Health and beauty 17.41 87.05 4.35 91.40 1/28/2019 15:16 Credit card 239 755-12-3214 C Naypyitaw Member Female Fashion accessories 44.22 21.10 11.06 232.16 5/3/19 17:07 Credit card 240 346-84-3103 B Mandalay Member Female Electronic accessories 13.22 66.10 3.31 69.41 2/3/19 19:26 Cash 241 478-06-7835 A fangon Normal Male Fashion accessories 89.69 89.69 4.48 94.17 11/1/19 11:20 Ewallet 242 540-11-4336 A fangor Normal Male Food and beverages 24.94 224.46 11.22 235.68 11/1/19 16:49 Credit card 243 448-81-5016 A Yangon Normal Male Health and beauty 59.77 119.54 5.98 125.52 11/3/19 12:01 Credit card 244 142-72-4741 C Naypyitaw Member Male Fashion accessories 93.20 186.4 9.32 195.72 2/28/2019 18:37 Credit card 245 217-58-1179 Yangon Member Male Home and lifestyle 62.65 250.60 12.53 263.13 5/1/19 11:25 Cash 246 376-02-8238 B Mandalay Normal Male Home and lifestyle 93.87 50.96 17.55 788.51 2/2/19 18:42 Credit card 247 530-90-9855 A fangon Member Male Home and lifestyle 47.59 380.72 19.04 399.7 1/1/19 14:47 Cash 248 866-05-7563 B Mandalay Member Female Electronic accessories 81.40 244.20 12.21 256.41 9/2/19 19:43 Cash 249 604-70-6476 Yangon Member Male Fashion accessories 17.94 89.70 4.49 94.19 1/23/2019 14:04 Ewallet 250 799-71-1548 fangon Member Male Electronic accessories 77.72 10.88 15.54 326.42 7/1/19 16:11 Credit card 251 785-13-7708 B Mandalay Normal Male Food and beverages 73.06 511.42 25.57 536.99 1/14/2019 19:06 Credit card 252 845-51-0542 B Mandalay Member Male Food and beverages 46.55 418.95 :0.95 139.90 2/2/19 15:34 Ewallet 253 662-47-5456 C Naypyitaw Member Male Fashion accessories 35.19 351.90 17.60 369.50 3/17/2019 19:06 Credit card 254 883-17-4236 C Naypvitaw Normal Female Sports and travel 14.39 28.78 1.44 30.22 2/3/19 19:44 Credit card Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E G 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 254 883-17-4236 C Naypyitaw Normal Female Sports and travel 14.39 28.78 1.44 30.22 2/3/19 19:44 Credit card 255 290-68-2984 A Yangon Normal Male Home and lifestyle 23.75 95.00 4.75 99.75 3/16/2019 11:22 Cash 256 704-11-6354 A Yangon Member Male Home and lifestyle 58.90 71.20 23.56 494.76 6/1/19 11:23 Cash 257 110-48-7033 B Mandalay Member Male Fashion accessories 32.62 130.48 6.52 137.00 1/29/201 14:12 Cash 258 366-93-0948 A fangon Member Male Electronic accessories 66.35 66.35 3.32 69.67 1/31/2019 10:46 Credit card 259 729-09-9681 A fangor Member Male Home and lifestyle 25.91 155.4 7.77 163.2 5/2/19 10:16 Ewallet 260 151-16-1484 A Yangon Member Male Electronic accessories 32.25 129.00 6.45 135.49 2/13/2019 12:38 Ewallet 261 380-94-4661 C Naypyitaw Member Male Electronic accessories 65.94 63.76 13.19 276.95 7/2/19 13:05 Credit card 262 850-41-9669 fangon Normal Female Electronic accessories 75.06 675.54 33.78 709.32 3/19/201 13:25 Ewallet 263 821-07-3596 Naypyitaw Normal Female Fashion accessories 16.45 65.80 3.29 69.09 7/3/19 14:53 Ewallet 264 655-85-5130 B Mandalay Member Female Fashion accessories 38.30 153.20 7.66 160.8 3/13/2019 19:22 Cash 265 447-15-7839 A Yangon Member Female Sports and travel 22.24 222.40 11.12 233.52 9/2/19 11:00 Cash 266 154-74-7179 B Mandalay Normal Male Sports and trave 54.45 54.45 2.72 57.17 2/26/2019 19:24 Ewallet 267 253-12-6086 fangon Member Female Sports and travel 98.40 588.80 34.44 723.24 12/3/15 12:43 Credit card 268 808-65-0703 Naypyitaw Normal Male Home and lifestyle 35.47 141.88 7.09 148.97 3/14/2019 17:22 Credit card 269 571-94-0759 B Mandalay Member Female Food and beverages 74.60 746.00 37.30 783.30 8/1/19 20:55 Cash 270 144-51-6085 Yangon Member Male Home and lifestyle 70.74 282.96 14.15 297.11 5/1/19 16:05 Credit card 271 731-14-2199 Yangon Member Female Home and lifestyle 35.54 355.4 7.7 373.17 4/1/19 13:34 Ewallet 272 783-09-1637 Mandalay Norma Female Sports and travel 67.43 837.15 16.86 354.01 6/3/19 18:13 Ewallet 273 687-15-1097 Naypyitaw Member Female Health and beauty 21.12 42.24 2.11 44.35 3/1/19 19:17 Cash 274 126-54-1082 A fangor Member Female Home and lifestyle 21.54 193.86 9.69 203.55 7/1/19 11:44 Credit card 275 633-91-1052 A fangor Normal Female Home and lifestyle 12.03 24.06 1.20 25.26 1/27/2019 15:51 Cash 276 477-24-6490 B Mandalay Normal Female Health and beauty 99.71 598.26 29.91 528.17 2/26/2019 16:52 Ewallet 277 566-19-5475 B Mandalay Normal Male Fashion accessories 47.97 335.79 16.79 352.58 7/1/19 0:52 Cash 278 526-86-8552 Naypyitaw Member Female Home and lifestyle 21.82 218.20 10.91 229.11 7/1/19 17:36 Cash 279 376-56-3573 Naypyitav Norma Female Fashion accessories 95.42 4 81.68 19.08 400.76 2/2/19 13:23 Ewallet 280 537-72-0426 Naypyitaw Member Male Fashion accessories 70.99 10 709.90 35.50 745.40 3/20/2019 16:28 Cash 281 828-61-5674 A Yangon Member Male Sports and travel 44.02 440.20 22.01 462.21 3/20/2019 19:57 Credit card 282 136-08-6195 fangon Normal Female Home and lifestyle 69.96 559.68 27.98 87.66 2/15/2019 17:01 Credit card 283 523-38-0215 Naypyitaw Normal Male Home and lifestyle 37.00 37.00 1.85 38.85 6/3/19 13:29 Credit card 284 490-29-1201 A fangon Normal Female Sports and travel 15.34 15.34 0.77 16.11 6/1/19 11:09 Cash 285 667-92-0055 Yangon Member Male Health and beauty 99.83 598.98 29.95 528.9 4/3/19 15:02 Ewallet 286 565-17-3836 Yangon Member Female Health and beauty 47.67 190.68 9.53 200.2 12/3/19 14:21 Cash 287 498-41-1961 B Mandalay Norma Male Health and beauty 66.68 333.40 16.67 350.07 2/20/2019 18:01 Cash 288 593-95-4461 Naypyitaw Member Male Home and lifestyle 74.86 74.86 3.74 78.60 3/24/2019 14:49 Cash 289 226-71-3580 Naypyitaw Normal Female Sports and travel 23.75 213.75 10.69 224.44 1/31/2019 12:02 Cash 290 283-79-9594 B Mandalay Normal Female Food and beverages 48.51 339.57 16.98 356.59 1/25/2019 13:30 Credit card 291 430-60-3493 Yangon Member Female Home and lifestyle 94.88 564.16 33.21 597.37 3/2/19 14:38 Cash 292 139-20-0155 B Mandalay Member Male Electronic accessories 40.30 103.00 20.15 123.15 1/24/201 17:37 Credit card 293 558-80-4082 Naypyitaw Normal Male Electronic accessories 27.85 194.95 9.75 204.70 3/14/2019 17:20 Ewallet 294 278-97-7759 A fangor Member Female Electronic accessories 62.48 62.48 3.12 65.60 2/18/2019 20:29 Cash 295 316-68-6352 A Yangon Member Female Food and beverages 36.36 72.72 3.64 76.36 1/21/2019 10:00 Cash 296 585-03-5943 Mandalay Normal Male Health and beauty 18.11 9.06 190.16 3/13/2019 11:46 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male E G N Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 296 585-03-5943 B Mandalay Norma Male Health and beauty 18.11 181.10 9.06 190.16 3/13/2019 11:46 Ewallet 297 211-05-0490 C Naypyitaw Member Female Electronic accessories 51.92 259.60 12.98 272.58 3/3/19 13:42 Cas 298 727-75-6477 C Naypyitaw Normal Male Electronic accessories 28.84 115.36 5.77 121.1 3/29/2019 14:44 Cash 299 744-02-5987 Yangon Member Male Home and lifestyle 78.38 170.28 23.51 493.79 10/1/19 14:16 Ewallet 300 307-83-9164 Yangon Member Male Home and lifestyle 60.01 40.04 12.00 252.0 1/25/2019 15:54 Cash 301 779-06-0012 Naypyitaw Member Female Home and lifestyle 88.61 88.61 4.43 93.04 1/19/2019 10:21 Cash 302 446-47-6729 Naypyitaw Norma Male Fashion accessories 99.82 199.64 9.98 09.62 2/1/19 18:09 Credit card 303 573-10-3877 B Mandalay Member Male Health and beauty 39.01 39.01 1.95 40.96 12/3/19 16:46 Credit card 304 735-06-4124 C Naypyitaw Normal Male Food and beverages 48.61 48.61 2.43 51.04 2/25/2019 15:31 Cash 305 439-54-7422 A Yangon Norma Female Electronic accessories 51.19 204.76 10.24 215.0 3/18/2019 17:15 Credit card 306 396-90-2219 B Mandalay Normal Female Electronic accessories 14.96 119.68 5.98 125.66 2/23/2019 12:29 Cash 307 411-77-0180 A Yangon Member Male Electronic accessories 72.20 505.40 25.27 530.67 3/26/2019 20:14 Ewallet 308 286-01-5402 A fangor Normal Female Sports and travel 40.23 281.61 14.08 295.69 3/30/2019 13:22 Cash 309 803-17-8013 Yangon Member Female Home and lifestyle 88.79 710.32 35.52 745.84 2/17/2019 17:09 Cash 310 512-98-1403 A Yangon Member Female Electronic accessories 26.48 79.44 3.97 83.41 3/21/2019 10:40 Ewallet 311 848-42-2560 A fangon Norma Female Fashion accessories 81.91 163.82 8.19 172.01 5/3/19 17:43 Cash 312 532-59-7201 B Mandalay Member Male Sports and travel 79.93 479.58 23.98 503.56 1/31/2019 14:04 Cash 313 181-94-6432 C Naypyitaw Member Male Fashion accessories 69.33 138.66 6.93 145.5 5/2/19 19:05 Ewallet 314 870-76-1733 Yangon Member Female Food and beverages 14.23 71.15 3.56 74.71 1/2/19 10:08 Credit card SNOWNOBUNGNWO 315 423-64-4619 Yangon Membe Female Health and beauty 15.55 139.95 7.00 146.95 7/3/19 13:12 Cash 316 227-07-4446 Naypyitaw Member Female Electronic accessories 78.13 781.30 39.07 820.3 10/2/19 20:51 Cash 317 174-36-3675 c Naypyitaw Member Male Food and beverages 99.37 198.74 9.94 208.68 2/14/2019 17:29 Cash 318 428-83-5800 C Naypyitav Member Female Food and beverages 21.08 63.24 3.16 66.40 9/2/1 10:25 Cash 319 603-07-0961 Naypyitaw Member Male Electronic accessories 74.79 373.95 18.70 392.65 10/1/19 1:34 Cash 320 704-20-4138 Naypyitaw Member Female Health and beauty 29.67 207.69 10.38 218.07 11/3/1 18:58 Credit card 321 787-15-1757 Naypyitaw Member Male Health and beauty 44.07 176.28 8.81 2/18/201 16:28 Ewallet 322 649-11-3678 C Naypyitaw Normal Female Food and beverages 22.93 206.37 10.32 216.69 2/26/2019 20:26 Cash 323 622-20-1945 C Naypyitaw Normal Female Health and beauty 39.42 39.42 1.97 41.39 1/18/2019 15:08 Cash 324 372-94-8041 Yangon Normal Male Health and beauty 15.26 91.56 4.58 96.14 2/15/2019 18:03 Ewallet 325 563-91-7120 Yangon Normal Female Fashion accessories 61.77 308.85 15.44 324.29 8/3/19 13:21 Cash 326 746-54-5508 A fangon Normal Male Home and lifestyle 21.52 129.12 6.46 1/17/2019 12:48 Credit card 327 276-54-0879 B Mandalay Normal Male Sports and travel 97.74 390.96 19.55 410.51 12/3/19 19:53 Ewallet 328 815-11-1168 A Yangon Member Male Food and beverages 99.78 498.90 24.95 523.85 9/3/15 19:09 Cash 329 719-76-3868 C Naypyitaw Member Male Food and beverages 94.26 377.04 18.85 395.89 12/3/19 16:30 Cash 330 730-61-8757 B Mandalay Member Male Health and beauty 51.13 204.52 10.23 214.75 1/25/2019 10:11 Credit card 331 340-66-0321 A Yangon Member Male Electronic accessories 36.36 145.44 7.27 152.71 3/25/2019 13:07 Cash 332 868-81-1752 B Mandalay Normal Male Home and lifestyle 22.02 198.18 9.91 208.09 7/2/19 18:48 Cash 333 634-97-8956 Yangon Normal Male Food and beverages 32.90 98.70 4.94 103.64 2/17/2019 17:27 Credit card 334 566-71-1091 Yangon Normal Male Fashion accessories 77.02 $85.10 19.26 104.36 3/2/19 15:59 Cash 335 442-48-3607 fangon Member Male Food and beverages 23.48 46.96 2.35 49.31 3/14/2019 11:21 Credit card 336 835-16-0096 Naypyitaw Member Male Sports and travel 14.70 73.50 3.68 77.18 3/24/2019 13:48 Ewallet 337 527-09-6272 A Yangon Member Female Electronic accessories 28.45 142.25 7.11 149.36 3/21/2019 10:17 Credit card 338 898-04-2717 A Yangon Normal Male Fashion accessories 76.40 587.60 34.38 721.98 3/19/2019 15:49 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Formatting as Table Format Sensitivity Styles v Filter Select Data E25 X V fx Male E G N 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 338 898-04-2717 A Yangon Normal Male Fashion accessories 76.40 687.60 34.38 721.98 3/19/2019 15:49 Ewallet 339 692-27-8933 B Mandalay Normal Female Sports and travel 57.95 347.70 17.39 365.09 2/24/2019 13:02 Cash 340 633-09-3463 C Naypyitaw Normal Female Electronic accessories $7.65 142.95 7.15 150.10 3/28/2019 12:58 Credit card 341 374-17-3652 B Mandalay Member Female Food and beverages 42.82 385.38 19.27 104.65 5/2/19 15:26 Credit card 342 378-07-7001 B Mandalay Member Male Electronic accessories 48.09 144.27 7.21 151.48 10/2/19 18:23 Credit card 343 433-75-6987 B Mandalay Member Female Health and beauty 55.97 391.79 19.59 411.38 5/3/19 19:06 Ewallet 344 873-95-4984 B Mandalay Member Female Health and beauty 76.90 538.30 26.92 565.27 2/15/2019 20:21 Cash 345 416-13-5917 C Jaypyitaw Normal Female Food and beverages 97.03 185.15 24.26 509.41 1/30/2019 16:24 Ewallet 346 150-89-8043 fangor Normal Male Sports and travel 44.65 133.95 6.70 140.65 2/14/201 15:04 Cash 347 135-84-8019 A fangon Normal Female Fashion accessories 77.93 701.37 35.07 2/27/2019 16:10 Ewallet 348 441-94-7118 A fangon Member Male Electronic accessories 71.95 71.95 3.60 75.55 4/2/19 12:14 Cash 349 725-96-3778 Naypyitaw Member Female Home and lifestyle 89.25 714.00 35.70 749.70 1/20/2019 10:13 Cash 350 531-80-1784 Yangon Normal Male Electronic accessories 26.02 182.14 9.11 191.25 3/28/2019 17:38 Cash 351 400-45-1220 B Mandalay Normal Female Health and beauty 13.50 10 135.00 6.75 141.75 2/27/2015 11:06 Credit card 352 860-79-0874 C Naypyitaw Member Female Fashion accessories 99.30 10 993.00 49.65 1,042.65 2/15/2019 14:53 Credit card 353 834-61-8124 A fangon Norma Male Electronic accessories 51.69 361.83 18.09 379.92 1/26/2019 18:22 Cash 354 115-99-4379 B Mandalay Member Female Fashion accessories 54.73 383.11 19.16 402.27 3/14/2019 19:02 Credit card 355 565-67-6697 B Mandalay Member Male Home and lifestyle 27.00 243.0 12.15 255.15 2/3/19 14:16 Cash 356 320-49-6392 Naypyitav Norma Female Electronic accessories 30.24 30.24 1.51 31.75 4/3/19 15:44 Cash 357 889-04-9723 B Mandalay Member Female Food and beverages 89.14 356.56 17.83 374.39 7/1/19 12:20 Credit card 358 632-90-0281 C Naypyitav Normal Female Fashion accessories 37.55 375.5 18.78 394.28 8/3/19 20:01 Credit card 359 554-42-2417 Naypyitaw Normal Female Sports and travel 95.44 954.40 $7.72 1,002.12 9/1/19 13:45 Cash 360 453-63-6187 B Mandalay Normal Male Electronic accessories 27.50 C N DO CO WO O A B U 82.50 4.13 86.63 1/3/19 15:40 Ewallet 361 578-80-7669 B Mandalay Normal Male Sports and travel 74.97 74.97 3.75 78.72 3/16/2019 16:58 Cash 362 612-36-5536 A Yangon Member Male Food and beverages 80.96 ;47.68 32.38 580.06 2/17/2019 11:12 Credit card 363 605-72-4132 C Naypyitaw Normal Female Food and beverages 94.47 755.76 37.79 793.55 2/27/2019 15:12 Cash 364 471-41-2823 Naypyitaw Normal Male Food and beverages 99.79 199.58 9.98 209.56 7/3/19 20:37 Ewallet 365 462-67-9126 Yangon Normal Male Home and lifestyle 73.22 439.32 21.97 61.29 1/21/2019 17:44 Cash 366 272-27-9238 Naypyitaw Normal Female Food and beverages 41.24 164.96 8.25 173.21 2/19/201 16:23 Cash 367 834-25-9262 Naypyitaw Normal Female Fashion accessories 81.68 326.72 16.34 343.06 6/1/19 12:12 Cash 368 122-61-9553 Naypyitaw Normal Female Electronic accessories 51.32 161.88 23.09 184.97 3/14/2019 19:33 Cash 369 468-88-0009 A Yangon Member Male Home and lifestyle 65.94 263.76 13.19 276.9 3/24/2019 10:29 Cash 370 613-59-9758 C Naypyitaw Normal Female Sports and travel 14.36 143.60 7.18 150.78 1/27/2019 14:28 Cash 371 254-31-0042 Yangon Member Male Electronic accessories 21.50 193.50 9.68 203.18 6/3/19 12:46 Credit card 372 201-86-2184 B Mandalay Member Female Electronic accessories 26.26 183.82 9.19 2/2/19 19:40 Cash 373 261-12-8671 B Mandalay Normal Female Fashion accessories 60.96 121.92 6.10 128.02 1/25/2019 19:39 Credit card 374 730-70-9830 C Naypyitaw Normal Female Home and lifestyle 70.11 420.66 21.03 441.69 3/14/2019 17:54 Ewallet 375 382-25-8917 C Naypyitaw Normal Male Fashion accessories 42.08 252.48 12.6. 265.10 1/29/2019 12:25 Cash 376 422-29-8786 fangor Normal Female Home and lifestyle 67.09 335.45 16.77 352.22 3/1/19 16:47 Credit card 377 667-23-5919 A Yangon Member Female Fashion accessories 96.70 483.50 4.18 507.68 1/14/2019 12:52 Ewallet 378 843-01-4703 B Mandalay Member Female Home and lifestyle 35.38 318.42 15.92 34.34 5/1/19 19:50 Credit card 379 743-88-1662 C Naypyitaw Normal Male Sports and travel 95.49 568.43 33.42 701.85 2/22/2019 18:17 Ewallet 380 595-86-2894 C Naypvitaw Member Male Fashion accessories 96.98 387.92 19.40 407.32 6/2/19 17:20 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v ZAY - O. Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E G N 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 380 595-86-2894 C Naypyitaw Member Male Fashion accessories 96.98 387.92 19.40 107.32 6/2/19 17:20 Ewallet 381 182-69-8360 B Mandalay Normal Female Electronic accessories 23.65 94.60 4.73 99.33 1/30/2019 13:32 Credit card 382 289-15-7034 A Yangon Member Male Sports and travel 82.33 329.32 16.47 345.79 11/1/19 10:37 Credit card 383 462-78-5240 Naypyitaw Norma Female Electronic accessories 26.61 53.22 2.66 55.88 3/19/201 14:35 Cas 384 868-52-7573 B Mandalay Normal Female Food and beverages 99.69 498.45 24.92 523.37 1/14/2019 12:09 Cash 385 153-58-4872 C Naypyitaw Member Female Food and beverages 74.89 99.56 14.98 314.54 1/3/19 15:32 Ewallet 386 662-72-2873 Yangon Normal Female Food and beverages 40.94 204.70 10.24 214.9 6/1/19 13:58 Ewallet 387 525-88-7307 B Mandalay Member Male Sports and travel 75.82 75.82 3.79 79.61 1/31/2019 13:19 Cash 388 689-16-9784 Naypyitaw Norma Male Food and beverages 46.77 280.62 14.03 294.65 11/3/19 13:37 Cash 389 725-56-0833 A Yangon Normal Female Health and beauty 32.32 323.20 16.16 339.36 2/20/2019 16:49 Credit card 390 394-41-0748 C Naypyitaw Member Female Fashion accessories 54.07 486.63 24.33 510.96 1/27/2019 14:55 Ewallet 391 596-42-3999 B Mandalay Normal Male Food and beverages 18.22 127.54 6.38 133.9 10/3/19 14:04 Credit card 392 541-89-9860 C Naypyitaw Member Female Fashion accessories 80.48 241.4 2.0 253.51 2/15/2019 12:31 Cash 393 173-82-9529 B Mandalay Norma Female Fashion accessories 37.95 379.50 18.98 398.48 1/26/201 14:51 Cash 394 563-36-9814 A fangon Member Male Electronic accessories 76.82 76.82 3.84 80.66 2/13/2019 18:27 Ewallet 395 308-47-4913 A angon Member Female Sports and travel 52.26 522.6 26.13 548.73 9/3/19 12:45 Credit card 396 885-17-6250 Yangon Normal Female Health and beauty 79.74 79.74 3.99 83.73 6/3/19 10:36 Ewallet 397 726-27-2396 Yangon Normal Female Health and beauty 77.50 387.50 19.38 406.88 1/24/2019 0:36 Ewallet 398 316-01-3952 fangon Normal Female Food and beverages 54.27 271.35 13.57 284.92 3/13/201 14:16 Ewallet 399 760-54-1821 Mandalay Normal Male Home and lifestyle 13.59 122.31 6.12 128.43 3/15/2019 10:26 Cash 400 793-10-3222 B Mandalay Member Female Health and beauty 41.06 246.36 12.32 258.68 5/3/19 13:30 Credit card 401 346-12-3257 B Mandalay Member Male Electronic accessories 19.24 173.16 8.66 181.82 4/3/19 16:28 Cash 402 110-05-6330 c Naypyitaw Normal Female Food and beverages 39.43 236.58 11.83 248.41 3/25/2019 20:18 Credit card 403 651-61-0874 Naypyitaw Norma Male Home and lifestyle 46.22 184.88 9.24 194.12 12/3/19 20:04 Credit card 404 236-86-3015 Naypyitaw Member Male Home and lifestyle 13.98 13.98 0.70 14.68 4/2/19 13:38 Ewallet 405 831-64-0259 Mandalay Norma Female Fashion accessories 39.75 198.75 9.94 208.69 2/22/2019 10:43 Ewallet 406 587-03-7455 Naypyitaw Member Female Fashion accessories 97.79 684.53 34.23 718.76 2/16/2019 17:30 Ewallet 107 882-40-4577 Yangon Member Male Sports and travel 57.26 269.04 13.45 282.49 1/19/2019 15:28 Credit card 408 732-67-5346 fangon Norma Male Food and beverages 13.79 68.95 3.45 72.40 11/1/1 19:07 Credit card 409 725-32-9708 B Mandalay Member Female Fashion accessories 68.71 274.84 13.74 288.58 4/1/19 19:01 Cash 410 256-08-8343 A fangon Normal Female Home and lifestyle 56.53 226.12 11.31 237.43 4/3/19 19:48 Ewallet 411 372-26-1506 C Naypyitaw Normal Female Fashion accessories 23.82 119.10 5.96 125.06 1/28/2019 19:24 Ewallet 412 244-08-0162 B Mandalay Normal Female Health and beauty 34.21 $42.10 17.11 359.21 2/1/19 13:00 Cash 413 569-71-4390 B Mandalay Normal Male Sports and travel 21.87 43.74 2.19 45.93 1/25/2019 14:29 Ewallet HOWUNOUT A 414 132-23-6451 A fangon Member Male Health and beauty 20.97 104.85 5.24 110.09 4/1/19 13:21 Cash 415 696-90-2548 A fangor Normal Male Sports and travel 25.84 77.52 3.88 81.40 10/3/19 18:55 Ewallet 416 472-15-9636 A Yangon Normal Male Home and lifestyle 50.93 407.44 10.37 427.81 3/22/2019 19:36 Ewallet 417 268-03-6164 B Mandalay Normal Male Health and beauty 96.11 96.11 4.81 100.92 1/25/2019 16:28 Ewallet 418 750-57-9686 Naypyitaw Normal Female Home and lifestyle 45.38 181.52 9.08 190.60 8/1/19 13:48 Credit card 419 186-09-3669 Naypyitaw Member Female Health and beauty 81.51 81.51 4.08 85.59 1/22/2019 10:57 Ewallet 420 848-07-1692 B Mandalay Normal Female Health and beauty 57.22 114.44 5.72 120.16 12/1/19 17:13 Ewallet 421 745-71-3520 A Yangon Member Female Electronic accessories 25.22 176.5 8.83 185.37 4/2/19 10:23 Cash 422 266-76-6436 C Naypvitaw Member Female Food and beverages 38.60 15.80 5.79 121.59 3/28/2019 13:57 Ewallet Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E G 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 122 266-76-6436 C Naypyitaw Member Female Food and beverages 38.60 115.80 5.79 121.59 3/28/2019 13:57 Ewallet 423 740-22-2500 C Naypyitaw Normal Female Electronic accessories 84.05 252.15 12.61 264.76 1/23/2019 13:29 Cash 424 271-88-8734 C Naypyitaw Member Female Fashion accessories 7.21 72.10 18.6 1,020.71 8/2/19 13:00 Credit card 125 301-81-8610 B Mandalay Member Male Fashion accessories 25.42 03.36 10.17 213.53 3/19/2019 19:42 Credit card 126 489-64-4354 Naypyitaw Normal Male Fashion accessories 16.28 16.28 0.81 17.09 9/3/19 15:36 Cash 427 198-84-7132 B Mandalay Member Male Fashion accessories 40.61 365.4 18.27 383.76 2/1/19 13:40 Cash 428 269-10-8440 A Yangon Member Male Health and beauty 53.17 372.19 18.61 390.80 1/21/2019 18:01 Cash 429 650-98-6268 B Mandalay Member Female Food and beverages 20.87 62.61 3.13 65.74 3/20/2019 13:53 Credit card $30 741-73-3559 Mandalay Norma Male Sports and travel 67.27 836.35 16.82 353.17 2/27/2019 17:27 Cash 431 325-77-6186 A Yangon Member Female Home and lifestyle 90.65 906.50 15.33 951.83 8/3/19 10:53 Ewallet 432 286-75-7818 B Mandalay Normal Male Fashion accessories 69.08 138.16 6.91 145.07 1/31/2019 19:48 Credit card 433 574-57-9721 Naypyitaw Normal Male Food and beverages 43.27 86.54 1.33 90.87 8/3/19 16:53 Ewallet 434 459-50-7686 Yangon Normal Female Electronic accessories 23.46 140.76 7.04 147.80 1/13/201 19:14 Ewallet 435 616-87-0016 B Mandalay Normal Male Fashion accessories 95.54 568.78 33.44 702.22 9/3/15 14:36 Credit card 436 837-55-7229 B Mandalay Normal Female Fashion accessories 47.44 47.44 2.37 49.81 2/22/2019 18:19 Credit card 437 751-69-0068 C Naypyitaw Normal Male Sports and trave 99.24 393.16 14.6 937.82 3/19/2019 19:09 Ewallet 438 257-73-1380 Naypyitaw Member Male Sports and travel 82.93 331.72 16.59 348.31 1/20/2019 16:51 Ewallet 439 345-08-4992 rangon Normal Male Home and lifestyle 33.99 203.94 0.20 214.14 8/3/19 15:37 Credit card 440 549-96-4200 Naypyitaw Member Male Food and beverages 17.04 68.16 3.41 71.57 8/3/19 10:15 Ewallet 441 810-60-6344 Naypyitaw Normal Female Electronic accessories 40.86 326.88 16.34 343.22 7/2/19 14:38 Credit card 442 450-28-2866 Naypyitaw Member Male Food and beverages 17.44 87.20 4.36 91.56 1/15/2019 19:25 Cash 443 394-30-3170 B Mandalay Member Female Sports and travel 88.43 707.44 35.37 742.81 3/22/2019 19:35 Credit card 444 138-17-5109 Yangon Member Female Home and lifestyle 89.21 302.89 40.14 343.0 1/15/2019 15:42 Credit card 445 192-98-7397 Naypyitaw Norma Male Fashion accessories 12.78 12.78 0.64 13.42 8/1/19 14:11 Ewallet 446 301-11-9629 A Yangon Normal Female Sports and travel 19.10 133.70 6.69 140.39 1/15/2019 10:43 Cash 147 390-80-5128 B Mandalay Member Female Health and beauty 19.15 19.15 0.96 20.11 1/28/2019 17:58 Credit card 448 235-46-8343 c Naypyitaw Member Male Food and beverages 27.66 276.60 13.83 290.43 2/14/2019 11:26 Credit card 449 453-12-7053 C Naypyitaw Normal Male Fashion accessories 45.74 137.22 6.86 144.08 10/3/1 17:38 Credit card 450 296-11-7041 B Mandalay Member Female Health and beauty 27.07 27.07 1.35 28.42 2/1/19 20:07 Credit card 451 449-27-2918 B Mandalay Member Female Sports and travel 39.12 39.12 1.96 41.08 3/26/2019 11:02 Credit card 452 891-01-7034 B Mandalay Normal Female Electronic accessories 74.71 148.26 22.41 470.67 1/1/19 19:07 Cash 453 744-09-5786 B Mandalay Normal Male Electronic accessories 22.01 132.06 6.60 138.6 2/1/19 18:50 Cash 154 727-17-0390 Yangon Normal Female Food and beverages 63.61 18.0 15.90 33.9 3/16/2019 12:43 Ewallet 455 568-88-3448 fangon Normal Male Health and beauty 25.00 25.00 1.25 26.25 3/3/19 15:09 Ewallet 456 187-83-5490 A Yangon Member Male Electronic accessories 20.77 83.08 4.15 87.23 1/31/2019 13:47 Cash 457 767-54-1907 B Mandalay Member Female Fashion accessories 29.56 147.80 7.39 155.19 2/13/2019 16:59 Cash 458 710-46-4433 B Mandalay Member Female Food and beverages 77.40 596.60 34.83 731.43 2/15/2019 14:15 Credit card 459 533-33-5337 B Mandalay Normal Male Electronic accessories 79.39 793.90 39.70 833.60 7/2/19 20:24 Cash 460 325-90-8763 Naypyitaw Member Female Electronic accessories 46.57 465.70 23.29 188.99 1/27/201 13:58 Cash 461 729-46-7422 Naypyitaw Normal Male Food and beverages 35.89 35.89 1.79 37.68 2/23/2019 16:52 Credit card 462 639-76-1242 Naypyitaw Normal Male Food and beverages 40.52 202.6 10.13 212.73 3/2/19 15:19 Cash 463 234-03-4040 B Mandalay Member Female Food and beverages 73.05 730.50 36.53 767.03 3/3/15 12:25 Credit card 464 326-71-2155 C Naypvitaw Normal Female Sports and travel 73.95 95.80 14.79 310.59 3/2/19 10:02 Cash Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments ap Wrap Text v General Insert v Calibri (Body) * 11 AA Ex Delete Paste BIUV CvAv E Merge & Centre v ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male E G N B 1 Invoice ID Branch City Customer type Gender Product line Unit price Quantity Sales revenue Value added tax (5%) Cash received Date of transaction Time of transaction Payment method 464 326-71-2155 C Naypyitaw Norma Female Sports and travel 73.95 95.80 14.79 310.59 3/2/19 10:02 Cash 465 320-32-8842 c Naypyitaw Member Female Food and beverages 22.62 22.62 1.13 23.75 3/17/2019 18:58 Cash 466 470-32-9057 A Yangon Member Male Food and beverages 51.34 256.7 12.84 269.5 3/28/2019 15:31 Credit card 467 878-30-2331 C Naypyitaw Member Female Sports and travel 54.55 $45.50 27.28 $72.78 2/3/19 11:22 Credit card 468 440-59-5691 Naypyitaw Member Female Health and beauty 37.15 260.05 13.00 73.05 8/2/19 13:12 Credit card 469 554-53-3790 B Mandalay Normal Male Sports and travel 37.02 22.12 11.11 3/22/2019 18:33 Cash 470 746-19-0921 C Naypyitaw Normal Male Food and beverages 21.58 21.58 1.08 22.66 9/2/19 10:02 Ewallet 471 233-34-0817 C Naypyitaw Member Female Electronic accessories 98.84 98.84 4.94 103.78 2/15/201 1:21 Cash 472 767-05-1286 Naypyitaw Member Female Home and lifestyle 83.77 502.62 25.13 $27.75 1/23/2019 12:10 Ewallet 173 340-21-9136 A Yangor Member Female Sports and travel 40.05 160.2 8.01 168.21 1/25/2019 11:40 Cash 474 405-31-3305 A Yangon Member Male Fashion accessories 43.13 21.57 152.87 2/2/19 18:31 Credit card 475 731-59-7531 B Mandalay Member Male Health and beauty 72.57 580.56 29.03 509.5 3/30/2019 17:58 Cash 476 676-39-6028 A Yangon Member Female Electronic accessories 64.44 322.20 16.11 338.31 3/30/2019 17:04 Cash 477 502-05-1910 Yangon Normal Male Health and beauty 65.18 195.54 3.78 205.37 2/25/2019 20:35 Credit card 478 485-30-8700 fangon Norma Female Sports and travel 33.26 166.3 8.32 174.62 3/18/2019 16:10 Credit card 479 598-47-9715 Naypyitaw Normal Male Electronic accessories 84.07 336.28 16.81 353.09 7/3/19 16:54 Ewallet 480 701-69-8742 B Mandalay Normal Male Sports and travel 34.37 343.70 17.19 360.89 3/16/2019 10:11 Ewallet 481 575-67-1508 A Yangon Normal Male Electronic accessories 38.60 38.60 1.93 40.53 1/29/2019 1:26 Ewallet 482 541-08-3113 C Naypyitaw Normal Male Food and beverages 65.97 527.76 26.39 554.15 2/2/19 20:29 Cash 483 246-11-3901 Naypyitaw Norma Female Electronic accessories 32.80 328.00 16.40 344.40 2/15/2019 12:12 Cash 484 674-15-9296 A Yangon Normal Male Sports and travel 37.14 185.70 9.29 194.9 8/1/19 13:05 Ewallet 485 305-18-3552 B Mandalay Member Male Home and lifestyle 60.38 603.80 30.19 633.99 12/2/19 16:19 Cash 486 493-65-6248 C Naypyitaw Member Female Sports and travel 36.98 10 369.80 18.49 388.29 1/1/19 19:48 Credit card 487 438-01-4015 B Mandalay Member Female Sports and travel 49.49 197.96 9.90 207.86 3/21/2019 15:25 Ewallet 488 709-58-4068 B Mandalay Norma Female Fashion accessories 41.09 10.90 20.55 131.4 2/28/201 14:42 Cash 489 795-49-7276 A Yangon Normal Male Fashion accessories 37.15 148.60 7.43 156.03 3/23/2019 18:59 Ewallet 490 556-72-8512 C Naypyitaw Normal Male Home and lifestyle 22.96 22.96 1.15 24.11 1/30/2019 20:47 Cash 491 627-95-3243 B Mandalay Member Female Home and lifestyle 77.68 599.12 34.96 734.08 4/2/19 13:21 Ewallet 492 686-41-0932 B Mandalay Normal Female Fashion accessories 34.70 69.40 3.47 72.87 3/13/2019 19:48 Ewallet 493 510-09-5628 Yangon Member Female Fashion accessories 19.66 196.60 9.83 206.43 3/15/2019 18:20 Credit card ONCONOCO NUMA O 494 608-04-3797 B Mandalay Member Female Health and beauty 25.32 202.56 10.13 212.69 5/3/19 20:24 Ewallet 495 148-82-2527 C Naypyitaw Member Female Home and lifestyle 12.12 121.20 6.06 127.26 5/3/19 13:44 Credit card 496 437-53-3084 B Mandalay Normal Male Fashion accessories 99.89 199.78 9.99 209.7 2/26/201 11:48 Ewallet 497 632-32-4574 B Mandalay Normal Male Sports and travel 75.92 507.36 30.37 537.7 3/20/2019 14:14 Cash 498 556-97-7101 Naypyitaw Norma Female Electronic accessories 63.22 126.4 6.32 132.76 1/1/15 15:51 Cash 499 862-59-8517 Naypyitaw Normal Female Food and beverages 90.24 541.44 27.07 568.51 1/27/2019 11:17 Cash 500 401-18-8016 B Mandalay Member Female Sports and travel 98.13 98.13 4.91 103.04 1/21/2019 17:36 Cash 501 420-18-8989 A fangon Member Female Sports and trave 51.52 12.16 20.61 132.77 2/2/1 15:47 Cash 502 277-63-2961 B Mandalay Member Male Sports and travel 73.97 73.97 3.70 77.67 3/2/19 15:53 Credit card NNPROP 503 573-98-8548 Naypyitaw Member Female Fashion accessories 31.90 31.90 1.60 33.50 5/1/19 12:40 Ewallet 504 620-02-2046 Naypyitaw Normal Male Home and lifestyle 69.40 138.8 6.94 145.74 1/27/2019 19:48 Ewallet 505 282-35-2475 B Mandalay Normal Female Sports and travel 93.31 186.62 9.33 195.95 3/25/2019 17:53 Cash 506 511-54-3087 Mandalay Normal Male Sports and travel 88.45 88.45 4.42 92.87 2/25/2019 16:36 Credit card Walmart Myanmar (Burma) + Ready + 100%AutoSave . OFF 1 Walmart Myanmar (Burma) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA ap Wrap Text v General Insert v Ex Delete Paste BIUV CvAv E EE Merge & Centre v ~ % " Conditional Format Cell Sort & Find & Analyse Sensitivity Formatting as Table Styles Format v Filter Select Data E25 X V fx Male B E

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Fundamentals

Authors: John Wild

7th Edition

1260247864, 9781260247862

More Books

Students also viewed these Accounting questions