AutoSave O Off) BFA221 - Data Analytics Case Study Hoang Tu Anh Trinh 551097 - O Search Hoang Tu Anh Trinh HT X File Home Insert Page Layout Formulas Data Review View Help Share Comments Insert LO Calibri 11 YA* A ab Wrap Text General Ex AYO Delete * Paste BIU~ E Merge & Center $ ~ % " -20 Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting * Table Styles Format Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A24 X V B C D E F 11 12 13 14 Response to Task 2: 15 16 Sales Order Number Kilograms Discrepancy |Favourable or Unfavourable? Comment and Recommended Actions: 17 P084161922 (1,000) Unfavourable 18 P084183167 (300) Unfavourable 19 P084202930 8,222 Favourable 20 P084202932 (8,222) Unfavourable 21 22 23 24 Response to Task 3a: 25 Summarised Responses Price List 1, Goods Issued from Storage 1. Entries to 100000 - Sales Question 1 - Workings 2. Stock Received at DC Q ... + Ready + 140%AutoSave O Off) BFA221 - Data Analytics Case Study Hoang Tu Anh Trinh 551097 - Search Hoang Tu Anh Trinh HT X File Home Insert Page Layout Formulas Data Review View Help PivotTable Analyze Design Share Comments Insert Ex AY O LO Calibri 11 YA* A ab Wrap Text General Delete Paste BIU~ E Merge & Center $ ~ % " .00 Conditional Format as Cell Sort & Find & Analyze Sensitivity Formatting Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity K1 X V B C E G H M N P Goods Receipt Date Purchase Order Numb Ham Batch Product Code Product Description Kilograms Received Sum of Kilograms Rec Column Labels - 0/7/2021 P084128288 HBOO 150550 Double Smoked Leg Ham 8,154 Row Labels JIVA Stock received Difference 10/8/2021 P084129186 HBOOZ 150550 Double Smoked Leg Har 8,581 P084128288 8154 8154 10/8/2021 P084133703 HBO03 150550 Double Smoked Leg Ham 8,476 PO84129186 8581 8581 10/9/2021 P084135436 HBO04 150454 Double Smoked Ham Sho 4,316 P084133703 8476 3476 10/10/2021 P084136139 HBOOS 150550 Double Smoked Leg Harr 8.410 PO84135436 4316 4316 10/11/2021 P084140225 BOO6 150550 Double Smoked Leg Har 8,405 PO84136139 8410 8410 10/12/2021 P084144921 18007 150550 Double Smoked Leg Harr 3.487 PO84140225 3405 8405 10/13/2021 P084145888 HBOO 150454 Double Smoked Ham She 4,171 PO84144921 8487 8487 0 0 0 0 0 0 0 0 0 0 0 6 6 10/14/2021 P084148222 HBOO 150550 Double Smoked Leg Harr 8,367 PO84145888 4171 4171 10/15/2021 P084152586 HBOOS 150550 Double Smoked Leg Har 8,402 PO84148222 8367 8367 10/16/2021 P084154952 HBO10 150550 Double Smoked Leg Han 8,302 PO84152586 8402 8402 10/17/2021 P084158940 1B011 150454 Double Smoked Ham Sho 3,988 PO84154952 8302 8302 10/18/2021 P084159879 HBO12 150550 Double Smoked Leg Harr 8.280 PO84158940 3988 3988 10/18/2021 P084161922 B013 150550 Double Smoked Leg Har 8,331 PO84159879 8280 8280 10/19/2021 P084164580 B014 150550 Double Smoked Leg Harr 8,144 PO84161922 9331 8331 1000 10/20/2021 P084168419 HBO15 150454 Double Smoked Ham She 4,103 PO84164580 8144 8144 18 10/21/2021 P084172011 HBO16 150550 Double Smoked Leg Harr 8,114 PO84168419 4103 4103 10 0 0 0 10/22/2021 P084174670 B017 150550 Double Smoked Leg Har 8,492 PO84172011 8114 8114 20 10/23/2021 P084179076 HBO18 150550 Double Smoked Leg Har 8,522 PO84174670 3492 8492 21 10/24/2021 P084183167 HBO18 150454 Double Smoked Ham Sho 4,488 PO84179076 8522 8522 22 10/25/2021 P084185603 B019 150550 Double Smoked Leg Harr 8,210 PO84183167 4788 4488 300 23 10/26/2021 P084189853 B020 150550 Double Smoked Leg Har 8,524 PO84185603 8210 8210 24 10/27/2021 P084193093 HBO21 150550 Double Smoked Leg Harr 8,155 PO84189853 8524 52 25 10/28/2021 P084193690 HBO22 150454 Double Smoked Ham She 4,242 PO84193093 8155 8155 26 10/29/2021 P084198326 HBO23 150550 Double Smoked Leg Harr 8,238 PO84193630 4242 4242 27 10/30/2021 P084200069 1B024 150550 Double Smoked Leg Har 8,356 P084198326 8238 8238 28 10/31/2021 P084202930 HBO25 150550 Double Smoked Leg Harr B.222 PO84200069 8356 8356 29 0/7/2021 P084128288 150550 Double Smoked Leg Harr , 154 P084202930 8222 3222 30 10/8/2021 P084129186 150550 Double Smoked Leg Ham 8,581 PO84202932 8222 -8222 31 10/8/2021 P084133703 150550 Double Smoked Leg Ham 8,476 32 10/9/2021 P084135436 150454 Double Smoked Ham Sho 4,316 23 10/10/2021 P084136139 150550 Double SmokedLen Har 8 410 ... 1. Entries to 100000 - Sales Question 1 - Workings 2. Stock Received at DC Q4- Workings 2 3. Initiative Vendor Account Q2-Workings + + 70% Ready +