This step requires you to complete some exceptions testing for the Employee p-card expenditures for the year ended 12/31/2020. 

Required: 

a. How many unique employees exceeded their annual authorized transaction limit (AUTHLIMIT)? 

b. How many unique employees exceeded their individual transaction limit at least once (TRANLIMIT)? 

c. How many total expenditures were above the CATLIMIT authorized for the transaction category? 

d. How many employees made purchases with p-cards after their termination date (TERMDATE)? 

e. How many employees made purchases with p-cards before the ISSUEDATE?

Mini-Bullseye Discount (MBD) is a medium-size national retailer with thousands of stores across the United States. MBD sells all types of products, ranging from groceries to pet foods and automotive supplies. Many of MBD’s corporate employees are required as part of their jobs to travel, as well as purchase items on behalf of the company when they are out on jobs. To help with the processing of employee purchases, corporate-level employees are assigned a sequentially numbered purchasing card. Each purchasing card has both an authorized transaction limit, which is set based on the typical expenditures made by the employee, and single transaction limit. Employees are told what their limits are and they know the company policies, but the issuing bank is unable to limit individual transactions beyond a maximum balance placed on the card, which is set to the authorized total annual purchase limit for an employee. Management monitors the use of the cards regularly and follows up on any unusual expenses found.