Idea week 2 assignment
maiezymq12
IDEAWeek2ACG46514.docxIDEA Problem 3
There is technical assistance available for the educational version of IDEA, please contact technical support: 1-888-641-2800 Option#4 or email the help desk at [email protected]
Review the samples in the IDEA Manual , Section 2-Accounts Receivable for this week. NOTE: the page numbers will vary depending on the manual you are using due to operating system differences in your computers.
Hint : Staying actively involved while reviewing the tutorial assignment will help you to complete the IDEA problems more efficiently.
Please submit your answers to the following problems to your instructor in a Word document. You may need to take a screen shot of your results and copy them into the Word document to upload if asked to perform any analysis using the software
Problem 3a
Watch the video in this section called "CaseWare IDEA Tutorials: Importing An Excel Spreadsheet" You are going to import the Excel file called Ames_AR into the IDEA program. Hint: Be sure to check the box so that the first row is the field names. Open the file and answer the following:
· How many records are in this database?
· List 2 ways to obtain this information.
Close the file
Problem 3b
Reopen the file called Ames_AR. Answer the following:
· What is the average amount of the invoices in this file? Hint: Use Field Statistics in the Properties window. Print screen the results to submit in with your answer for this problem.
Hint: click back on Data in the Properties Window to go back to the original data set.
· The company has a policy that invoices over $5,000 need approval by two managers. You want to quickly find all of the invoices in this database that are over $5,000 to check to make sure the approvals are in place. Hint: Watch the video called "IDEA 10: Direct Extraction" and/or use Criteria in the Properties window. In the Equation box create an expression that should read AMOUNT>5000 Print screen the results to submit in with your answer for this problem.
· How many invoices are over $5,000 that you need to check?
Problem 3c
Print the history log for this problem Hint: Use History in the Properties window and be sure to expand all sections by clicking on the + sign. Print screen the results to submit in with your answer for this problem.
IDEA Problem 4
There is technical assistance available for the educational version of IDEA, please contact technical support: 1-888-641-2800 Option#4 or email the help desk at [email protected]
Review the samples in the IDEA Manual , Section 3-Inventory Analysis for this week. NOTE: the page numbers will vary depending on the manual you are using due to operating system differences in your computers.
Hint : Staying actively involved while reviewing the tutorial assignment will help you to complete the IDEA problems more efficiently.
Please submit your answers to the following problems to your instructor in a Word document. You may need to take a screen shot of your results and copy them into the Word document to upload if asked to perform any analysis using the software
Import and open the file called Ames_Inventory. You may want to watch the videos again.
Problem 4a
You want to see if anything looks out of line with inventory. With the Ames_Inventory file open, Create an expression in the criteria section to determine if and inventory items have a quantity on hand less than 0. Hint: Review the handout "How to Modify a Field Type", since this activity is asking for a numeric calculation the field must also be numeric to perform this operation. To check the field status, right-click on the first number in the database under QTY_ON_HAND and select field manipulation. Change the field type from Character to Numeric and make sure the decimal places are at 0 then click ok. Create your expression using Criteria similar to what you did in problem 3 to display the results. Print screen the results to submit in with your answer for this problem.
· How many items did you find less than 0?
· Why do you think the quantity on hand would be less than 0?
Problem 4b
Clear the criteria. Hint: Right-click Criteria in the Properties window and select clear.
You now want to check to make sure the unit cost UNIT_COST is less than the unit market price UNIT_MKT. Hint: This activity is asking for a numeric calculation so be sure the field types are correct, if not be sure to adjust the fields. Remember the decimal places would be 2 in this case. Print screen the results to submit in with your answer for this problem.
· How many items did you find where the unit cost was more than the unit market price?
· Why do you think the cost would be less than the market price?
Problem 4c
Print the history log for this problem Hint: Use History in the Properties window and be sure to expand all sections by clicking on the + sign. Print screen the results to submit in with your answer for this problem.
-----------------------------------------------------------------------------------------------------------------
Submit your answers to Problems 3 and 4 in the same Word document. Be sure to label your answers clearly with the problem numbers and clearly identify the print screens of your results.
Adapted from: McGraw Hill Companies, In 2016 IDEA S-1 Solutions Manual, IDEA Assignments
