Week 5 Data Analysis:
Please play the IDEA videos and review the handout again from week 3 if needed on how to modify a field type
Please click on the link above to access the discussion question.
IDEA Videos:
Gap Detection
Joins:
Appending a Field:
Week 5 Data Analysis Discussion Question:
· You have been asked to analyze the Cash Disbursements spreadsheet provided.
. Week 5 Cash_Disbursemt.xlsx
. The company policy is that checks are only processed on the 15th and 30th of each month (Hint: Using IDEA modify/append the file and use @day formula for the 15th or 30th then set the criteria) and payments over $10,000 need to be authorized by the CFO, Albert Booth.
· Based on what you found during your analysis, discuss the controls you feel are needed for cash disbursements at this company. Design a spreadsheet (using advanced features of Excel) or a flowchart (using Lucidchart) demonstrating the implementation of the controls you feel are needed based on your analysis–upload a copy. Be sure to identify specific ways to improve the cash disbursements process.
