In this case, the students help automate an existing manual process to bill customers for wood products sold by Wood’s Amazing Woods Inc. The case requirements include the completion of the overview case first. We strongly suggest this although the case can be completed without this requirement. This case has three parts, which increase with complexity. Each part has a unique, fictional data set of transactions. All parts use the same invoice template to complete the case:

Part I: Students are required to create an invoice for a single transaction in the data file. Part II: Students are required to create an invoice for each transaction in the data file (the bot loops). Part III: Students are required to create an invoice for each transaction in the data file that has not already been billed and update the master data file to indicate when the item was billed.

Suitable courses: AIS, Data Analytics

Link to download files (requires login)