Two Discussions

acruzma
W5-DataAnalysis.docx

Discussion #1

You have been asked to analyze the Cash Disbursements spreadsheet provided.  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 your observations about the controls you feel are needed for cash disbursements.  Design a spreadsheet (using advanced features of Excel) or a flowchart (using Lucidchart) demonstrating the implementation of controls you feel were needed.

 

Idea Results