This is a work sheet that we will look at in class:

1. If the category is A and the department is 12 and the budget is greater than 500000, you need to add 1 to CT.
2. If the category is A, you want to add 1 to CTA. If category is B, you want to add 1 to CTB. For all other categories you want to add 1 to CTOTHER.
3. If the category is A and either onhand is less than 100 or onorder is less than 100, you want to move the word ORDER to MSG.
4. If the category is A or the category is B and the budget is greater than 250000.
5. If the person on the record either makes over 50000 OR has a house code of Own and it is worth over 500000, move ELIGIBLE to msg otherwise move NOT ELIGIBLE to msg.