Problem Three - Chapter 9: You are the senior auditor with WCSU LLC CPAs and have been assigned to an inventory observation for the Accell Picnic Table Company, Inc., specifically for the Picnic Table inventory, its major product. Accell has two types of picnic tables, each with a different assigned inventory cost and description: (a) wooden picnie tables and (b) metal and composite plastic picnic tables. Accell has a main location in Danbury CT where the picnic table parts are ordered and then the two types of picnic tables are assembled by Accell's assemblers. The assemblers are full-time employees of Accell. Because the picnic tables are assembled continuously throughout the fiscal year, there is normally an inventory of parts on hand throughout the year. Approximately 40% of the total value of the finished picnic tables are located in the Danbury location, as well as the unassembled parts. Because of space limitations, however, the remaining 60% of the finished picnic tables are sent to three warehouses located in Connecticut, New Hampshire and Pennsylvania. Accell staff plans to count inventory at all their locations on the same day at the company's fiscal year end. It appears the shared warehouses all have equal amounts of finished picnic tables. You're concerned there is not enough audit staff at WCSU to cover all the inventory observations at the four different locations. You have been provided with the following information at the audit planning meeting: . A detailed Picnie Table inventory record detailing all picnic tables expected to be at each location on the date of the inventory observation. • The client's Picnic Table manual describing the two types of tables, their descriptions and their standard costs. • A map of cach location showing the expected area where the inventories are located. Required: (a) What evidence would you expect to find indicating that the observation of Accell's physical count of inventory was well planned and that Accell's staff were properly supervised? (b) What substantive procedures should you find in the audit documentation of Accell management's assertions about existence and completeness of inventory quantities at year end? You may use Appendix 98 of your McGraw Hill textbook for the audit plan's procedures. (c) If WCSU LLC does not have sufficient audit staff to observe inventories at all locations, what strategies could you use to possibly compensate for the shortfall in audit staffing?



Problem Three - Chapter 9: You are the senior auditor with WCSU LLC CPAs and have...
Problem Three - Chapter 9: You are the senior auditor with WCSU LLC CPAs and have been assigned to an inventory observation for the Accell Picnic Table Company, Inc., specifically for the Picnic Table inventory, its major product. Accell has two types of picnic tables, each with a different assigned inventory cost and description: (a) wooden picnic tables and (b) metal and composite plastic picnic tables. Accell has a main location in Danbury CT where the picnic table parts are...
Problem One - Chapter 7: Part. A: You are the lead auditor for the Bella Luna Tree Company, Inc. in Bethel, CT. The company has a June 30" year end, and the audit team is discussing strategies for confirming year end accounts receivable. The composition of the accounts receivable is as follows: Total Accounts Receivable (before any Allowance for Doubtful Accounts): $4,584,600 Aged Composition: $ 3.667.680 Zero - 30 days 687,690 Thirty-60 days 183,390 Sixty - 90 Days 45,840 Over...
You are a senior on the audit for the year ended 30 June 2018 of Office Supplies Ltd, A Perth-based manufacturer of customised office furniture. You are carrying out audit checks on cut-off at year end. Office Supplies maintains details of stock quantities on its computer and conducts a ‘wall-to-wall’ count of inventory when all operations cease at 30 June, and all inventory is counted in a single stocktake. The bulk of inventory is held in two adjoining warehouses owned...
(15 points) 1, Alan Fallon was recently promoted to senior accountant. He was put in charge of the Mellow Markets audit because of his experience with other grocery clients. Mellow Markets has a small, but growing, chain of natural food stores. This is the first year Mellow Markets has been audited. Because of their growth, Mellow Markets needs additional capital and intend to use their audited financial statements to secure a loan. Alan has been assigned two inexperienced staff assistants...
Lily Window Glass Co. (Lily) is a glass manufacturer that operates from a large production facility, where it undertakes continuous production 24 hours a day, seven days a week. Also on this site are two warehouses where the company’s raw materials and finished goods are stored. Lily’s year end is December 31. Lily is finalizing the arrangements for the year-end inventory count, which is to be undertaken on December 31, 2020. The finished windows are stored in 20 aisles of...
Answer all the question 1. Warehousing provides time and place utility for three types of inventory (raw materials-semi finished items-stocks), allowing firms to provide customer service and optimize costs. Classify the factors affecting a company's decisions on the number of warehouses to be used, and give two examples. (6 marks) 2. The function of Warehousing aims typically to satisfy customers' needs and requirements while utilizing space, equipment, and labor effectively. Discuss the role of Warehouse operations in satisfying customers? (Minimum...
The following are independent situations for which you will recommend an appropriate audit report Subsequent to the date of the financial statements as part of his post-balance sheet date audit procedures, a CPA learned that a recent fire caused heavy damage to one of a client's two plants; the loss will not be reimbursed by insurance. The newspapers described the event in detail. The financial statements and footnotes as prepared by the client did not disclose the loss caused by...
*Please only answer #3* Jupiler Inc. (A Business Risk Case) You are a senior auditor at Zales and Brook LLP, a CPA firm. Jupiler Drinks Inc. is a large publicly traded firm based in California and has been audited by your firm for years. You are assigned to lead the FY2007 audit of Jupiler Drinks (DB). You read previous year working papers, BD’s quarterly reports and have learned the following facts. BD is a large multinational non-alcoholic drink producer, selling...
124 Excel for Accounting Chapter 4: Inventory Costing and Analysis Extend Your Skills EA4-E1 Edit an Inventory Listing and Create a Pivot Table for Gameroom Suppliers In this exercise, you will compile summary data based on an inventory listing for Gameroom Suppliers. You will determine the inventory balance for a product category using three methods, and you will create a Pivot Table based on the inventory listing. Open EA4-E1-Inventory. Use one of Excel's built-in functions to enter the total number...
Instructions Try to answer all the questions using what you have learned in class. Please make your query general not data related This schema is used for inventory management for an OEM Part Inventory p_id Name Cost Supplier Location 1 Traction motor 200 Melco Japan 2 Alternator 400 kato USA 3 HVAC 300 Melco Japan p_id Warehouse_id quantity 1 A1 100 2 A2 250 3 B1 300 Customer Model c_id Name Location CN Canada National Canada UP Union Pacific USA...