1. Look at the Status column (column E) for the first few items on the inventory report. Does the output of the function created by the analyst make sense given the companys guidelines for managing inventory? Document your observation in the AnswerSheet worksheet.

2. Evaluate the construction of the IF function in the Status column for the first item. Does the function accurately evaluate the Sell Through percentages in column D? Document your observation in the AnswerSheet worksheet.

3. The company suggests that if the unit sales for an item are greater than 100 and the sell through rate is greater than or equal to 20% that a rush priority be placed on any orders. Does the IF function in the Status column accurately account for this condition? Document your observation in the AnswerSheet worksheet.

4. Enter a new IF function in the Status column to accurately assess the inventory for each item based on the companys inventory policies. Make any other adjustments to the worksheet so that it is easy to see all items that require Rush Priorities as well Cancel Warnings.

A F e Product 3 Item 1 4 Item 2 5 Item 3 5 Item 4 - Item 5 3 Item 6 Item 7 o Item 8 1 Item 9 2 Item 10 3 Item 11 4 Item 12 5 Item 13 6 Item 14 7 Item 15 8 Item 16 9 Item 17 o Item 18 1 Item 19 2 Item 20 3 Item 21 4 Item 22 5 Item 23 6 Item 24 7 Item 25 Current Inventory 3,540 1,142 12,600 5,040 5,939 1,404 16,727 16,184 2,430 428 11,673 5,800 187 3,098 5,058 3,226 3,663 9,356 8,720 1.458 1,181 8,454 6,367 13,122 1,335 DE Unit Sales Sell Last Week Through Status 590 16.7% Rush Priority 48 4.2% Cancel Warning 1050 8.3% Rush Priority 1793 35.6% Rush Priority 371 6.2% Rush Priority 176 12.5% Rush Priority 797 4.8% Rush Priority 952 5.9% Rush Priority 270 11.1% Rush Priority 86 20.1% Cancel Warning 834 7.1% Rush Priority 580 10.0% Rush Priority 471 25.1% Cancel Warning 1033 33.3% Rush Priority 298 5.9% Rush Priority 358 11.1% Rush Priority 167 4.6% Rush Priority 965 10.3% Rush Priority 872 10.0% Rush Priority 486 33.3% Rush Priority 79 6.7% Cancel Warning 769 9.1% Rush Priority 1220 19.2% Rush Priority 729 5.6% Rush Priority 267 20.0% Rush Priority AnswerSheet Inventory Report