need the two questions and table 3 answered :)

Table 1 Item# Rank 1 2 3 4 5 6 7 8 9 10 Average Usage Quantity (Units) 17 50 15 25 5 50 153 21 19 15 Unit Cost (5) Annual Usage (5) 25 22.5 17 850 15 225 17 425 17 85 5950 5 765 25 52 5 2 38 25 375 119 8 2 5 4 5 + 3 7 9 10 1 Table 2 Rank Item Annual usage Cumulative Category Annual Usage assigned A B 1 2 3 4 5 6 7 8 9 10 6 2 7 4 3 5 8 1 9 10 Total Annual Usage Cumulative 15) (5) 5950 5950 850 6800 765 7565 425 7990 225 8275 85 3300 5725 83925 8395 38 830 BATOO 8470,5 7024 80.27 89 3 9432 96 98 97498 986 99 99.55 TOD Questions: Answer the following 2 questions: Q1) Imagine that the listed inventory items are part of the BMW mini production Based on your understanding of inventory management, complete Table 3, outlining the level of Control, Ordering and Inventory (safely stock). Quantity and Annual Usage should be provided as percentage) How did you arrive at these options? Hint these variables (level of control, ordering schedule and Inventory) are subjective Clarify your thinking in setting the variables for each class of inventory items Quantity is the % of inventory items. Not the Quantity of individual inventory item Meaning that for example for Class A items if you have 4 Inventory items defined Class A And there are a total of 10 Inventory items (as in the above scenario) It would be 40% Annual Usage (in %) relates to the Cumulative Annual Usage (%) for each category D'Focus Hint these variables (level of control, ordering schedule and Inventory) are subjective Clarify your Thinking in setting the variables for each class of inventory items Quantity is the % of Inventory items. Not the Quantity of individual inventory itom. Meaning that for example, for Class A items if you have 4 inventory items defined Class A. And there are a total of 10 inventory items (as in the above scenario). It would be 40% Annual Usage (in %) relates to the Cumulative Annual sage (%) for each category Options for level of Control, limited (Low), Moderate, Strict Options for Ordering Schedule: Daily, Weekly, Monthly Options for Inventory (Safety Stock) volume: Low, Moderate, High Table 3 Class A Class B Class C I Criteria Quantity (in %) Annual Usage (in %) Level of Control Ordering Schedule Inventory (Safety Stock) 02) What is the value and the limitation of the ABC classification