Link to the google excel file https://docs.google.com/file/d/15DysuotEwPcY9i0v76zuY4BWpMHUFdg2/edit?usp=docslist_api&filetype=msexcel Homework 4 Download the "Homework 4 Data" spreadsheet data. For the following tasks show your work in details (submit with excel file), so instructor can understand what steps of data manipulation you performed. If necessary, leave comments in the worksheet. The suggested templates are provided in the data file. Requires Part for all Students You are auditing the small bakery as the owner is applying for a loan to be used for a business expansion. As a part of auditing the revenue and collection cycle, you decided to run few analytical procedures. 1. Carefully learn structure of the provided data, try to deduce insights about accounting and recordkeeping practices of the client on revenues and receivables. Answer following questions: a. What is the product price per unit? Is the per unit price same for all product types. Explain your reasoning. b. Based on what, the delivery fee is charged? What is the delivery fee rate? Are there any exceptions on delivery fees? If yes what might be a possible reason for that? Show your reasoning. c. On the shipping report, how many Shipping #s do you find for each Sales Order #. Why do you think that is the case? 2. Perform a three-way match between sales orders, shipping report and sales invoice (compare dollar amount and quantity) for the year of 2021. If you find any problems, explore the problem and see if you can determine what happened to cause the problem. 3. If auditor expect the possible existence of following circumstances, explain what special considerations should be taken into account while performing a three-way match: a. Split or partial Invoices/Payments b. Incomplete Deliveries