A614 Final Exam The final is open book, open note

A614 Final Exam

The final is open book, open note.  However, you must not receive assistance from any current or former students of this course.   The final is due Saturday, August 6, at 11:59pm.

Problem 1 (IDEA)  (50 points) Using your IDEA audit software and workbook, walk through and complete the entire process described in Section 4, related to the analysis of inventory.  Create a document in MS Word that briefly documents the audit and/or data analysis processes that you employed using IDEA to arrive at each of your audit findings.  In your document, each audit finding should have a brief narrative section as well as a corresponding screenshot(s) to support the finding and/or your comments. You do not need to send me your IDEA files.

Problem 2 (50 points)

The Beach Dude (BD) employs a legion of current and former surfers as salespeople who push its surfing-oriented products to various customers (usually retail outlets). This case describes BD’s sales and collection process. 

Each BD salesperson works with a specific group of customers throughout the year. In fact, they often surf with their customers to try out the latest surf gear. The BD salespeople act laid-back, but they work hard for their sales. Each sale often involves hours of surfing with their customers while the customers sample all the latest surf wear. Since BD makes the best surfing products, the customers look forward to the visits from the BD salespeople. And, they often buy a lot of gear. Each sale is identified by unique invoice# and usually involves many different products. Customers pay for each sale in full within 30 days, but they can combine payments for multiple sales.

BD manages their clothing inventory by item (e.g., XL BD surfer logo t-shirts), identified by product #, but it also classifies the items by clothing line (the lines are differentiated by price points as well as the intended use of the clothing, e.g., surfing products, casual wear, etc.). 

a. Draw a business process model that describes the Beach Dudes sales and collection process.   Use either Powerpoint, Visio, or Word.   Your model should show resources, events, and agents as well as cardinalities. (25 points)

b. Using Microsoft Access, implement a relational database from your model.  Identify at least 3 fields per table.   Your database should have tables, forms and at least one query.  Please submit your Access files to the final exam folder (25 points).