1 Summerize what you learned about the status of inventory from this exercise and present the screenshots related to your answer 2 The items flagged as 'obsolete Y' are client identified obsolete inventory Based on what you learned from the IDEA analysis of the company's inventory, discuss whether you agree with the client's classification or believe the client should flag more inventory as obsolete Explain your conclusion Home Data Analysis View Macros SmartAnalyzer IDEA Lab PDF ect view New Open Archive Properties Import Export Publish Send by to PDF Email Export Manage Passport Cloud Share License CaseWare Projects Source Data ry Properties 1 Database Size Mo Data History Field Statistics Control Total 626,824 139 (TOTALCOST) E Criteria me cal Library urrent Project Library Custom Functions Equations Exports Import Definitions Macros Other Results Source Files Acc rec2015 accdb Inventory 2015 asc Visualization Inventory at Dec 31 2015 IMD PRODCODE DEPOT QTY AV COST TOTALCOST OBSOLETE MFA 1 111201103 OTTAWA 125 3 511 438 875 2 111601902 QUEBEC 670 0 690 462 300 3 111807059 QUEBEC 684 0 591 404 244 4 111807558 QUEBEC 61 1 877 114497 5 111813056 TORONTO 990 0 548 542 520 6 111815558 QUEBEC 140 0 571 79 940 111821608 OTTAWA 360 0 482 173 520 8 111821703 QUEBEC 380 0 401 152 380 9 111821809 TORONTO 250 0 460 115 000 10 111824705 QUEBEC 320 0 652 208 640 11 113219101 QUEBEC 9 3 299 29 691 Y 12 113401101 TORONTO 63 0 850 53 550 13 113401704 OTTAWA 60 0 970 58 200 14 113411019 QUEBEC 20 2 830 56 600 116003054 TORONTO 240 0 505 121 200 16 116003551 OTTAWA 360 0 899 323 640 4 116030109 QUEBEC 17 5 190 20 760 Y 35 116030904 OTTAWA 2 245 18 78 575 Y 70 116035403 QUEBEC 0 949 19 66 430 117202655 QUEBEC 900 0 350 315 000 117208754 QUEBEC 300 0 403 120 900 117231008 QUEBEC 100 0 978 22 97 800 315 120250100 QUEBEC 3 014 949 410 23 60 120254902 QUEBEC 5 320 319 200 24 133 90 839 123202607 QUEBEC 25 0 683 80 123418809 QUEBEC 0 976 78 080 26 133006658 QUEBEC 5 402 82 27 442 964 59 133007087 TORONTO 7 155 422 145 28 108 1 790 193 320 135215507 QUEBEC 29 Results 15 11 Indices 332 4 20 No index 68 4 21 1 Comments Add comment plorer Library Source Data Export License CaseWare Inventory at Dec 31 2015 IMD X 1 Properties Database o Field Type DELDAT 0 e Moi Data History Numeric Character Date Time 0 Date Statistics of Valid Val of Zero Ite of Records of Data Err Earliest Date 766 766 Date Fields Field Statistics Control Total 626,824 139 (TOTALCOST) DELDATE 0 B Criteria Latest Date Record of Record of Most Comm 0 Results al 0 Indices 0 No index 2 4 8 4 9 0 0 Comments Most Comm Items in Jan Items in Febr Items in March Items in April items in May Items in June Items in July Items in Aug Items in Sept 0 Add comment 0 0 0 0 Key Value Statistics La Chart 4 Visual Connector Sample Visualization Compare Direct Extraction X Records to extract All Starting record 1 OK Range Ending record 766 Create Fields Libr Database order No index Fields ent P File Name Criteria Delete ston uatic 1 Obsolete Inventory Items OBSOLETE Y Cancel N QTY L Limit CU Limit Records MONTHS 0 00 766 0 00 0 00 ( ) MONTHS 0 00 0 00 1 2 3 0 6 00 12 00 0 6 00 12 00 18 00 24 00 30 00 36 00 ( ) Records 100 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Field Statistics Control Total 626,824 139 (TOTALCOST Criteria 4 0 00 0 00 0 00 0 00 0 0 18 00 24 00 30 00 0 00 5 0 0 00 6 Results 0 000 Lower limit exceptions Upper limit exceptions 0 00 0 00 0 00 0 00 0 0 00 Inventory Usage Aging 766 100 00 0 00 Totals 0 00 Indices No index Case IDEA Inverely at Dec 31 2015 IDEA Lab Home Data Analysis Macros SmartAnalye Project New Open Archive Properties Import Export Publish Send by Manage Passport Goud Overview to PDF Email Project Source Date Export Library Inventory at Dec 31 2015 MD X X Properties PRODCODE DEPOT OTY AV COST TOTALCOST OBSOLETE MAX MIN DELOTY ORDERNO DELDATED CURSELLPRI CUREFPOATE PREVSELLPRI USAGE A Database German olary WINE 43 GET Cument Project Library TORONTO Custom functions Control Total Equations 626961915 Exports SOME (TOTALCOST Import Definition TO Macies Team 25 16 TORONTO Source Files THCS Indices Inventory 2015 THROOM TIGE Gweite Comments OK Add comment 10 15 17 19 INC TO explore Library Inventory at Dec 31 2015 IMD X Field Type Numec Character Date Time Numeric Fields PRODCODE QTY AV COST TOTALCOST MAX MN DELQTY ORDERNO CURSELLPRI Numeric Net Value Absolute Val of Records of Zero lte Positive Value Negative Val of Positive of Negative of Data Err of Valid Val Average Value Minimum Vol Maximum Va Record of Record of Sample Sid Sample Vari Pop Std Dev Pop Variance Pop Skewness Pop Kurtosis QTY TOTALCI 214,954 626 963 915 214,984 627,159 615 767 767 68 09 214,969 627,0617 15 97850 696 3 3 0 0 767 767 280 25 817424 67 000 10,800 70 555 641 202 90 576 653 53 3,863 12 427,098 71 14,923,69 653 10 3,860 60 426,54187 14,904 24 8 798206 13 500307 112 051908 212 937655 Home Data Analysis View Macros SmartAnalyzer IDEA Lab PDF ect view New Open Archive Properties Import Export Publish Send by to PDF Email Export Manage Passport Cloud Share License CaseWare Projects Source Data ry Properties 1 Database Size Mo Data History Field Statistics Control Total 626,824 139 (TOTALCOST) E Criteria me cal Library urrent Project Library Custom Functions Equations Exports Import Definitions Macros Other Results Source Files Acc rec2015 accdb Inventory 2015 asc Visualization Inventory at Dec 31 2015 IMD PRODCODE DEPOT QTY AV COST TOTALCOST OBSOLETE MFA 1 111201103 OTTAWA 125 3 511 438 875 2 111601902 QUEBEC 670 0 690 462 300 3 111807059 QUEBEC 684 0 591 404 244 4 111807558 QUEBEC 61 1 877 114497 5 111813056 TORONTO 990 0 548 542 520 6 111815558 QUEBEC 140 0 571 79 940 111821608 OTTAWA 360 0 482 173 520 8 111821703 QUEBEC 380 0 401 152 380 9 111821809 TORONTO 250 0 460 115 000 10 111824705 QUEBEC 320 0 652 208 640 11 113219101 QUEBEC 9 3 299 29 691 Y 12 113401101 TORONTO 63 0 850 53 550 13 113401704 OTTAWA 60 0 970 58 200 14 113411019 QUEBEC 20 2 830 56 600 116003054 TORONTO 240 0 505 121 200 16 116003551 OTTAWA 360 0 899 323 640 4 116030109 QUEBEC 17 5 190 20 760 Y 35 116030904 OTTAWA 2 245 18 78 575 Y 70 116035403 QUEBEC 0 949 19 66 430 117202655 QUEBEC 900 0 350 315 000 117208754 QUEBEC 300 0 403 120 900 117231008 QUEBEC 100 0 978 22 97 800 315 120250100 QUEBEC 3 014 949 410 23 60 120254902 QUEBEC 5 320 319 200 24 133 90 839 123202607 QUEBEC 25 0 683 80 123418809 QUEBEC 0 976 78 080 26 133006658 QUEBEC 5 402 82 27 442 964 59 133007087 TORONTO 7 155 422 145 28 108 1 790 193 320 135215507 QUEBEC 29 Results 15 11 Indices 332 4 20 No index 68 4 21 1 Comments Add comment plorer Library Source Data Export License CaseWare Inventory at Dec 31 2015 IMD X 1 Properties Database o Field Type DELDAT 0 e Moi Data History Numeric Character Date Time 0 Date Statistics of Valid Val of Zero Ite of Records of Data Err Earliest Date 766 766 Date Fields Field Statistics Control Total 626,824 139 (TOTALCOST) DELDATE 0 B Criteria Latest Date Record of Record of Most Comm 0 Results al 0 Indices 0 No index 2 4 8 4 9 0 0 Comments Most Comm Items in Jan Items in Febr Items in March Items in April items in May Items in June Items in July Items in Aug Items in Sept 0 Add comment 0 0 0 0 Key Value Statistics La Chart 4 Visual Connector Sample Visualization Compare Direct Extraction X Records to extract All Starting record 1 OK Range Ending record 766 Create Fields Libr Database order No index Fields ent P File Name Criteria Delete ston uatic 1 Obsolete Inventory Items OBSOLETE Y Cancel N QTY L Limit CU Limit Records MONTHS 0 00 766 0 00 0 00 ( ) MONTHS 0 00 0 00 1 2 3 0 6 00 12 00 0 6 00 12 00 18 00 24 00 30 00 36 00 ( ) Records 100 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Field Statistics Control Total 626,824 139 (TOTALCOST Criteria 4 0 00 0 00 0 00 0 00 0 0 18 00 24 00 30 00 0 00 5 0 0 00 6 Results 0 000 Lower limit exceptions Upper limit exceptions 0 00 0 00 0 00 0 00 0 0 00 Inventory Usage Aging 766 100 00 0 00 Totals 0 00 Indices No index Case IDEA Inverely at Dec 31 2015 IDEA Lab Home Data Analysis Macros SmartAnalye Project New Open Archive Properties Import Export Publish Send by Manage Passport Goud Overview to PDF Email Project Source Date Export Library Inventory at Dec 31 2015 MD X X Properties PRODCODE DEPOT OTY AV COST TOTALCOST OBSOLETE MAX MIN DELOTY ORDERNO DELDATED CURSELLPRI CUREFPOATE PREVSELLPRI USAGE A Database German olary WINE 43 GET Cument Project Library TORONTO Custom functions Control Total Equations 626961915 Exports SOME (TOTALCOST Import Definition TO Macies Team 25 16 TORONTO Source Files THCS Indices Inventory 2015 THROOM TIGE Gweite Comments OK Add comment 10 15 17 19 INC TO explore Library Inventory at Dec 31 2015 IMD X Field Type Numec Character Date Time Numeric Fields PRODCODE QTY AV COST TOTALCOST MAX MN DELQTY ORDERNO CURSELLPRI Numeric Net Value Absolute Val of Records of Zero lte Positive Value Negative Val of Positive of Negative of Data Err of Valid Val Average Value Minimum Vol Maximum Va Record of Record of Sample Sid Sample Vari Pop Std Dev Pop Variance Pop Skewness Pop Kurtosis QTY TOTALCI 214,954 626 963 915 214,984 627,159 615 767 767 68 09 214,969 627,0617 15 97850 696 3 3 0 0 767 767 280 25 817424 67 000 10,800 70 555 641 202 90 576 653 53 3,863 12 427,098 71 14,923,69 653 10 3,860 60 426,54187 14,904 24 8 798206 13 500307 112 051908 212 937655

Question

1  Summerize what you learned about the status of inventory from this exercise and present the screenshots related to your answer  2  The items flagged as 'obsolete Y' are client identified obsolete inventory  Based on what you learned from the IDEA analysis of the company's inventory, discuss whether you agree with the client's classification or believe the client should flag more inventory as obsolete  Explain your conclusion  Home Data Analysis View Macros SmartAnalyzer IDEA Lab PDF ect view New Open Archive Properties Import Export Publish Send by to PDF Email Export Manage Passport Cloud Share License CaseWare Projects Source Data ry   Properties 1   Database Size Mo Data History   Field Statistics Control Total  626,824 139 (TOTALCOST) E Criteria me cal Library urrent Project Library Custom Functions Equations Exports Import Definitions Macros Other Results Source Files Acc rec2015 accdb Inventory 2015 asc Visualization Inventory at Dec 31 2015 IMD PRODCODE DEPOT QTY AV COST TOTALCOST OBSOLETE MFA 1 111201103 OTTAWA 125 3 511 438 875 2 111601902 QUEBEC 670 0 690 462 300 3 111807059 QUEBEC 684 0 591 404 244 4 111807558 QUEBEC 61 1 877 114497 5 111813056 TORONTO 990 0 548 542 520 6 111815558 QUEBEC 140 0 571 79 940 111821608 OTTAWA 360 0 482 173 520 8 111821703 QUEBEC 380 0 401 152 380 9 111821809 TORONTO 250 0 460 115 000 10 111824705 QUEBEC 320 0 652 208 640 11 113219101 QUEBEC 9 3 299 29 691 Y 12 113401101 TORONTO 63 0 850 53 550 13 113401704 OTTAWA 60 0 970 58 200 14 113411019 QUEBEC 20 2 830 56 600 116003054 TORONTO 240 0 505 121 200 16 116003551 OTTAWA 360 0 899 323 640 4 116030109 QUEBEC 17 5 190 20 760 Y 35 116030904 OTTAWA 2 245 18 78 575 Y 70 116035403 QUEBEC 0 949 19 66 430 117202655 QUEBEC 900 0 350 315 000 117208754 QUEBEC 300 0 403 120 900 117231008 QUEBEC 100 0 978 22 97 800 315 120250100 QUEBEC 3 014 949 410 23 60 120254902 QUEBEC 5 320 319 200 24 133 90 839 123202607 QUEBEC 25 0 683 80 123418809 QUEBEC 0 976 78 080 26 133006658 QUEBEC 5 402 82 27 442 964 59 133007087 TORONTO 7 155 422 145 28 108 1 790 193 320 135215507 QUEBEC 29 Results 15 11   Indices 332 4 20 No index 68 4 21 1 Comments Add comment plorer Library Source Data Export License CaseWare Inventory at Dec 31 2015 IMD X 1   Properties Database o Field Type DELDAT    0 e Moi Data History Numeric Character Date Time 0 Date Statistics   of Valid Val      of Zero Ite      of Records   of Data Err    Earliest Date 766 766 Date Fields Field Statistics Control Total  626,824 139 (TOTALCOST) DELDATE 0 B Criteria Latest Date Record   of     Record   of     Most Comm    0 Results al 0 Indices 0 No index 2 4  8 4 9 0 0 Comments Most Comm    Items in Jan    Items in Febr    Items in March Items in April items in May Items in June Items in July Items in Aug    Items in Sept    0 Add comment 0 0 0 0 Key Value Statistics La Chart 4  Visual Connector Sample Visualization Compare Direct Extraction X Records to extract  All Starting record    1 OK Range Ending record    766 Create Fields Libr Database order  No index Fields ent P File Name Criteria Delete ston uatic 1 Obsolete Inventory Items OBSOLETE  Y  Cancel N QTY L Limit CU Limit  Records MONTHS 0 00 766 0 00 0 00 ( ) MONTHS 0 00 0 00 1 2 3 0 6 00 12 00 0 6 00 12 00 18 00 24 00 30 00 36 00 ( )   Records 100 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Field Statistics Control Total  626,824 139 (TOTALCOST Criteria 4 0 00 0 00 0 00 0 00 0 0 18 00 24 00 30 00 0 00 5 0 0 00 6 Results 0 000 Lower limit exceptions  Upper limit exceptions  0 00 0 00 0 00 0 00 0 0 00 Inventory Usage Aging 766 100 00 0 00 Totals 0 00   Indices No index Case IDEA Inverely at Dec 31 2015 IDEA Lab Home Data Analysis Macros SmartAnalye Project New Open Archive Properties Import Export Publish Send by Manage Passport Goud Overview to PDF Email Project Source Date Export Library   Inventory at Dec 31 2015 MD X X Properties PRODCODE DEPOT OTY AV COST TOTALCOST OBSOLETE MAX MIN DELOTY ORDERNO DELDATED CURSELLPRI CUREFPOATE PREVSELLPRI USAGE A Database German olary WINE 43 GET Cument Project Library TORONTO Custom functions Control Total Equations 626961915 Exports SOME (TOTALCOST Import Definition TO Macies Team 25 16 TORONTO Source Files THCS   Indices Inventory 2015 THROOM TIGE Gweite   Comments OK Add comment 10 15 17 19 INC TO explore Library Inventory at Dec 31 2015 IMD X Field Type Numec Character Date Time Numeric Fields PRODCODE QTY AV COST TOTALCOST MAX MN DELQTY ORDERNO CURSELLPRI Numeric Net Value Absolute Val   of Records   of Zero lte    Positive Value Negative Val   of Positive of Negative      of Data Err    of Valid Val    Average Value Minimum Vol  Maximum Va  Record of Record of Sample Sid  Sample Vari   Pop Std Dev Pop Variance Pop Skewness Pop Kurtosis QTY TOTALCI 214,954 626 963 915 214,984 627,159 615 767 767 68 09 214,969 627,0617  15  97850 696 3 3 0 0 767 767 280 25 817424  67 000 10,800 70 555 641 202 90 576 653 53 3,863 12 427,098 71 14,923,69 653 10 3,860 60 426,54187 14,904 24 8 798206 13 500307 112 051908 212 937655 Home Data Analysis View Macros SmartAnalyzer IDEA Lab PDF ect view New Open Archive Properties Import Export Publish Send by to PDF Email Export Manage Passport Cloud Share License CaseWare Projects Source Data ry   Properties 1   Database Size Mo Data History   Field Statistics Control Total  626,824 139 (TOTALCOST) E Criteria me cal Library urrent Project Library Custom Functions Equations Exports Import Definitions Macros Other Results Source Files Acc rec2015 accdb Inventory 2015 asc Visualization Inventory at Dec 31 2015 IMD PRODCODE DEPOT QTY AV COST TOTALCOST OBSOLETE MFA 1 111201103 OTTAWA 125 3 511 438 875 2 111601902 QUEBEC 670 0 690 462 300 3 111807059 QUEBEC 684 0 591 404 244 4 111807558 QUEBEC 61 1 877 114497 5 111813056 TORONTO 990 0 548 542 520 6 111815558 QUEBEC 140 0 571 79 940 111821608 OTTAWA 360 0 482 173 520 8 111821703 QUEBEC 380 0 401 152 380 9 111821809 TORONTO 250 0 460 115 000 10 111824705 QUEBEC 320 0 652 208 640 11 113219101 QUEBEC 9 3 299 29 691 Y 12 113401101 TORONTO 63 0 850 53 550 13 113401704 OTTAWA 60 0 970 58 200 14 113411019 QUEBEC 20 2 830 56 600 116003054 TORONTO 240 0 505 121 200 16 116003551 OTTAWA 360 0 899 323 640 4 116030109 QUEBEC 17 5 190 20 760 Y 35 116030904 OTTAWA 2 245 18 78 575 Y 70 116035403 QUEBEC 0 949 19 66 430 117202655 QUEBEC 900 0 350 315 000 117208754 QUEBEC 300 0 403 120 900 117231008 QUEBEC 100 0 978 22 97 800 315 120250100 QUEBEC 3 014 949 410 23 60 120254902 QUEBEC 5 320 319 200 24 133 90 839 123202607 QUEBEC 25 0 683 80 123418809 QUEBEC 0 976 78 080 26 133006658 QUEBEC 5 402 82 27 442 964 59 133007087 TORONTO 7 155 422 145 28 108 1 790 193 320 135215507 QUEBEC 29 Results 15 11   Indices 332 4 20 No index 68 4 21 1 Comments Add comment plorer Library Source Data Export License CaseWare Inventory at Dec 31 2015 IMD X 1   Properties Database o Field Type DELDAT    0 e Moi Data History Numeric Character Date Time 0 Date Statistics   of Valid Val      of Zero Ite      of Records   of Data Err    Earliest Date 766 766 Date Fields Field Statistics Control Total  626,824 139 (TOTALCOST) DELDATE 0 B Criteria Latest Date Record   of     Record   of     Most Comm    0 Results al 0 Indices 0 No index 2 4  8 4 9 0 0 Comments Most Comm    Items in Jan    Items in Febr    Items in March Items in April items in May Items in June Items in July Items in Aug    Items in Sept    0 Add comment 0 0 0 0 Key Value Statistics La Chart 4  Visual Connector Sample Visualization Compare Direct Extraction X Records to extract  All Starting record    1 OK Range Ending record    766 Create Fields Libr Database order  No index Fields ent P File Name Criteria Delete ston uatic 1 Obsolete Inventory Items OBSOLETE  Y  Cancel N QTY L Limit CU Limit  Records MONTHS 0 00 766 0 00 0 00 ( ) MONTHS 0 00 0 00 1 2 3 0 6 00 12 00 0 6 00 12 00 18 00 24 00 30 00 36 00 ( )   Records 100 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 Field Statistics Control Total  626,824 139 (TOTALCOST Criteria 4 0 00 0 00 0 00 0 00 0 0 18 00 24 00 30 00 0 00 5 0 0 00 6 Results 0 000 Lower limit exceptions  Upper limit exceptions  0 00 0 00 0 00 0 00 0 0 00 Inventory Usage Aging 766 100 00 0 00 Totals 0 00   Indices No index Case IDEA Inverely at Dec 31 2015 IDEA Lab Home Data Analysis Macros SmartAnalye Project New Open Archive Properties Import Export Publish Send by Manage Passport Goud Overview to PDF Email Project Source Date Export Library   Inventory at Dec 31 2015 MD X X Properties PRODCODE DEPOT OTY AV COST TOTALCOST OBSOLETE MAX MIN DELOTY ORDERNO DELDATED CURSELLPRI CUREFPOATE PREVSELLPRI USAGE A Database German olary WINE 43 GET Cument Project Library TORONTO Custom functions Control Total Equations 626961915 Exports SOME (TOTALCOST Import Definition TO Macies Team 25 16 TORONTO Source Files THCS   Indices Inventory 2015 THROOM TIGE Gweite   Comments OK Add comment 10 15 17 19 INC TO explore Library Inventory at Dec 31 2015 IMD X Field Type Numec Character Date Time Numeric Fields PRODCODE QTY AV COST TOTALCOST MAX MN DELQTY ORDERNO CURSELLPRI Numeric Net Value Absolute Val   of Records   of Zero lte    Positive Value Negative Val   of Positive of Negative      of Data Err    of Valid Val    Average Value Minimum Vol  Maximum Va  Record of Record of Sample Sid  Sample Vari   Pop Std Dev Pop Variance Pop Skewness Pop Kurtosis QTY TOTALCI 214,954 626 963 915 214,984 627,159 615 767 767 68 09 214,969 627,0617  15  97850 696 3 3 0 0 767 767 280 25 817424  67 000 10,800 70 555 641 202 90 576 653 53 3,863 12 427,098 71 14,923,69 653 10 3,860 60 426,54187 14,904 24 8 798206 13 500307 112 051908 212 937655

Accepted Answer

The Answer is in the image, click to view ...

Question

1. Summerize what you learned about the status of inventory from this exercise and present the screenshots related to your answer. 2. The items flagged

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Investing With Stock Options

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question