90.2K

Verified Solution

Link Copied!

- Accurate to three decimal places, use data file INVENTORY_TURNOVER_DATAFILE.XLS

determine the inventory turnover for part number 95-0132-NT (or 95-0132-OS or 95-

0132-AS or 95-0132-MS or 95-0132-MD or 95-0132-PS)

Excel File Edit View Insert Format Tools Data Window Help 12% IN AutoSave OFF ... Sequoia_Inventory Turnover_Datafile_DISTRIBUTION_TO_STUDENTS(1).xls - Compatibility Mode Review View Acrobat Solver Table TreePlan Tell me Home Insert Draw Page Layout Formulas Data M34 x fx A A B D E F G E H 1 J K L M N o R S T U 38.3% ICC $18.86 Part Unit Cost $21.31 Part Sales Price $83.34 Ordering Cost 439 Order Quantity 1 2 2 3 4 4 5 B 7 8 . 10 11 12 13 14 15 16 17 19 19 20 21 22 23 24 25 ac 26 27 28 29 30 31 32 33 34 2 95 28 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Order Order Inventory Date Quantity Demand Receipts Status 1-Jan 218 2-Jan 7 calculate mal 3-Jan 138 calculate mel 4 Jan 18 calculate mel 5-Jan calculate me! 6-Jan 2 calculate me 7 Jan 28 calculate mal 9-Jan 12 calculate ma 9-Jan 1 calculate ma! 10-Jan 40 calculate mo 11-Jan calculate mo! 12-Jan 18 calculate mal 13-Jan 439 12 calculate mal 14-Jan 15 caloulate met 15-Jan 12 calolate mel 16-Jan 9 calculate mel 17 Jan 20 calculate me! 18 Jan calculate me! 19-Jan 7 calculata me 20-Jan 15 439 Calculata mel 21 Jan 5 calculate me! 22-Jan 53 calculate mel 23-Jan calculate mel 24-Jan caloulete mel 26-Jan 2 calculate mal 26 Jan 117 calculate mal 27-Jan calaulale mal 28-Jan 16 calculate mal 29-Jan 22 calculate mel 30-Jan calculate me 31 Jan 82 calculate me 1-Feb 1 calculele me! 2-Feb 17 calculate mo 3-Feb 38 calculate mel 4-Feb 439 18 calculate me 5-Feb calculata mel 6 Feb - 22 calculate me 7 Feb 29 calculate mel 8-Fab 12 439 calculate mol calculate mel 9-Feb 11 10-Feb 29 calculate mel 11-Feb calculate mel 95-0132-NT 95-0132-OS 95-0132-AZ 95-0132-MS 4 95-0132-MD 95-0132-PS + Ready 09 113 Excel File Edit View Insert Format Tools Data Window Help 12% IN AutoSave OFF ... Sequoia_Inventory Turnover_Datafile_DISTRIBUTION_TO_STUDENTS(1).xls - Compatibility Mode Review View Acrobat Solver Table TreePlan Tell me Home Insert Draw Page Layout Formulas Data M34 x fx A A B D E F G E H 1 J K L M N o R S T U 38.3% ICC $18.86 Part Unit Cost $21.31 Part Sales Price $83.34 Ordering Cost 439 Order Quantity 1 2 2 3 4 4 5 B 7 8 . 10 11 12 13 14 15 16 17 19 19 20 21 22 23 24 25 ac 26 27 28 29 30 31 32 33 34 2 95 28 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Order Order Inventory Date Quantity Demand Receipts Status 1-Jan 218 2-Jan 7 calculate mal 3-Jan 138 calculate mel 4 Jan 18 calculate mel 5-Jan calculate me! 6-Jan 2 calculate me 7 Jan 28 calculate mal 9-Jan 12 calculate ma 9-Jan 1 calculate ma! 10-Jan 40 calculate mo 11-Jan calculate mo! 12-Jan 18 calculate mal 13-Jan 439 12 calculate mal 14-Jan 15 caloulate met 15-Jan 12 calolate mel 16-Jan 9 calculate mel 17 Jan 20 calculate me! 18 Jan calculate me! 19-Jan 7 calculata me 20-Jan 15 439 Calculata mel 21 Jan 5 calculate me! 22-Jan 53 calculate mel 23-Jan calculate mel 24-Jan caloulete mel 26-Jan 2 calculate mal 26 Jan 117 calculate mal 27-Jan calaulale mal 28-Jan 16 calculate mal 29-Jan 22 calculate mel 30-Jan calculate me 31 Jan 82 calculate me 1-Feb 1 calculele me! 2-Feb 17 calculate mo 3-Feb 38 calculate mel 4-Feb 439 18 calculate me 5-Feb calculata mel 6 Feb - 22 calculate me 7 Feb 29 calculate mel 8-Fab 12 439 calculate mol calculate mel 9-Feb 11 10-Feb 29 calculate mel 11-Feb calculate mel 95-0132-NT 95-0132-OS 95-0132-AZ 95-0132-MS 4 95-0132-MD 95-0132-PS + Ready 09 113

Answer & Explanation Solved by verified expert

See Answer