This is how it is presented. However, I did get this from your archive hoping that copying and pasting it would be easier since it is from your site. For problem 1, I do not understand the "hint" to use the criteria equation under the property tab and how to see the result. I was putting "shipping date< purchase order date" in the criteria box, but how do I get the result.

For problem, I just do not understand how to go about finding the answers. Is there a page in the book that I can follow? The one I see is not about shipping.

Chapter 7 Tutorial Exercises: 1-7There are seven exercises (3 within the chapter and 4 at the end) in Chapter 7 tutorial from theACL in Practicefile(ACL_in_Practice.pdf),in the folder where ACL manuals are saved onyour hard drive (e.g., C:\ACLManualsV9). Your instructor will inform you which, if any, of theexercises to complete and submit.Messier/Glover/Prawitt End-of-Chapter 7, ACL ProblemsAs introduced above in theACL problemsfor Chapter 3, Roger Company is a mid-sizecompany located in the Midwest that handles the distribution of various home and gardenproducts. You are part of the engagement team assigned to audit the financial statements ofRoger Company. Roger Company has been a client of your firm for many years, and your firmhas rarely encountered any problems with them. However, the engagement partner has made itvery clear to you that there is no room for mistakes. Your tasks as one of the auditors on theengagement are outlined below and in other problems of the remaining chapters.Please download the Roger Company ACL files, if you haven't already.They are found inthe ACL Content folder under Course-Wide Content on the Student Edition of your text'sOnline Learning Center. See instructions for opening the Roger Company files in theChapter 3 assignment above.

Problem 1. Roger Company's policy is to not ship goods unless a valid purchase order has been received.However, based on information obtained during your walk through to confirm yourunderstanding of processes and controls, you learned that occasionally a rush order is receivedvia telephone and the goods are shipped before receiving the purchase order. Rush orders areonly processed for existing customers. When rush orders are received the sales person taking the

order completes a "Rush Order" form which is then approved by the sales department supervisor.The "Rush Order" form is then attached to the purchase order when it is received and the detailsof the two forms (i.e., product and quantity) are compared.To test the effectiveness of thecontrols around rush orders, you want to identify all instances where product is shipped before apurchase order is received. Using the Roger Company shipping file, determine the number ofinvoices related to orders that were shipped before a purchase order was received.

Problem 2.

In discussions with the order fulfillment and shipping departments, you learn that it is commonfor a partial or "split" shipment to go out because of an insufficient quantity of items in stock tofulfill the customer order. However, controls should prohibit shipping a higher quantity than wasordered. Using information from Roger Company'sShippingfile, determine how many records contain fields where the quantity shipped exceeds the quantity ordered.