See attached file.

Laramie Wire Manufacturing Case and analytical procedures

Using Analytical Procedures in Risk Assessment Laramie Wire Manufacturing Case You are an in-charge auditor assigned to the Laramie Wire Manufacturing (Laramie) audit. This is the first year your firm has conducted the audit for this particular client. In fact, although Laramie has previously engaged accountants to perform limited review services for the purpose of obtaining bank loans, this is the first year Laramie has contracted for a full-scale audit of its financial statements. The company has engaged your firm to conduct its first financial statement audit in preparation for a planned IPO. Laramie is a medium-sized company which buys copper rod and plastic materials used to make insulated copper wiring. Laramie operates out of a single building complex totaling 500,000 square feet, which includes office space (3%), production area (57%), shipping and receiving (15%), and finished goods and raw materials inventory warehousing (25%.) Laramie supplies insulated copper wiring in the northeastern part of the U.S. The company has a good reputation for quality products and has had a good working relationship with its outside accountants over the past 10 years. You are in the risk assessment stage of the audit and are preparing to conduct some analytical procedures to help identify areas which may represent heightened risk and thus affect the nature, timing, and extent of further audit procedures. Your staff assistant has assembled information relating to inventories and other items, including a brief description of Laramie's production and inventory areas. Because your assistant is new, he is not very good about weeding out irrelevant information, so you may not need to use every piece of information he has provided. Certain company information and two ratios are listed below. 2014 2013 Sales $8,450,000 $8,150,000 Cost of Sales $6,242,500 $6,080,000 Finished Goods Inventory $1,654,500 $1,175,500 $2,625,000 $1,650,000 (app. 300 million feet) Copper Rod Inventory (app. 5.9 million pounds) Plastics Inventory $224,500 $182,000 $450,000 $425,000 Days Purchases in A/P 43.6 44.2 Days Sales in Receivables 56.3 48.4 Market Price of Insulated Wire (per foot) $0.008 $0.009 Market Price of Copper Rod (per pound) $0.48 $0.48 $0.120 $0.190 (app. 1.1 million pounds) Accounts Payable (for inventory purchases) Market Price of Plastics (per pound) Laramie makes several different gauges and types of insulated copper wire for use in applications ranging from residential telephone and electrical wiring to industrial-grade, high-voltage power cables. The production area is divided into three areas, with each area specializing in a particular product group, including residential products, industrial products, and special-order products. Production is done in batches according to orders placed with the company. For each batch, machinery is adjusted and calibrated according to the type and size of product to be manufactured, and the size of the batch depends on the amounts of product needed. Average machine setup time from start to finish is approximately six hours, which is slightly below the industry average. The different types of products Laramie manufactures all use similar raw materials, so raw materials inventory is stored in a single location, divided into copper and plastics. Finished goods (insulated copper wire) are stored on large stackable spools of various sizes, with approximately 500,000 feet of wire per spool. Copper rod inventory is stored on pallets, which are not stackable. Each pallet measures 6 feet by 6 feet, 5 feet tall, and holds 1,500 pounds of copper rod. Plastics inventory is stored in 4-feet -tall stackable barrels, with approximately 350 lbs. of plastic per barrel. The raw materials inventory storage area is located near the shipping and receiving area for convenience. Inbound and outbound shipments of inventory are trucked to the nearest rail yard, from which they are distributed around the northeastern region of the U.S. A single 18-wheeler can carry up to 15 pallets of copper rod, 40 barrels of plastics, or 24 spools of finished insulated copper wire. Laramie's production process includes some automation but still requires a relatively large amount of labor. Thus, Laramie's conversion costs are fairly evenly divided between direct labor and factory overhead. Overhead consist primarily of the costs of the production facilities and depreciation and maintenance on the machinery. Laramie uses a hybrid product costing system (a system that combines characteristics of both job-order and process costing systems) to accommodate both the continuous and homogeneous nature of the manufacturing process and the fact that production runs are performed in separately identifiable batches. In accordance with the relatively homogeneous nature of Laramie's products, overhead is allocated from a single cost pool based on a combination of machine and direct labor hours. As the insulated copper wire product is completed, it is rolled into large spools of various sizes, usually in lengths of about 500,000 linear feet. These spools of finished goods inventory are stored next to the raw materials inventory near the facility's eight loading and unloading docks. In many cases, the inventory is produced in response to specific customer orders received. The spools are tagged for shipment to customers according to date requested. Inventory that has been produced to provide a \"cushion\" for rush orders is stored toward the far end of the finished goods storage area, away from the shipping area. The inventory and production areas are well organized and seem to flow smoothly. Machines appear to be well maintained. A cursory visual examination of inventories reveals no problems. Two spools in the finished goods area were tagged as being of a type of residential wiring recently banned by federal safety guidelines. These spools are clearly marked, and the inventory supervisor indicated they are to be destroyed within the next week. Procedures and records for tracking materials upon arrival, through the production process, and into finished goods and shipping, appear to be well designed. 1. Perform analytical procedures (including any non-financial measures as appropriate, such as warehouse space) using the information and table provided to help identify areas of high risk. A number of procedures should be computed or used, particularly for inventory (including lower-of-cost-or-market analysis.) The analytical procedures should include percentage and amount changes for relevant accounts between the two years, aging, and turnover. Document all your computations to be used to support your responses in \"2\" below. 2. Based on your analysis, determine what management assertions have a high risk of material misstatement for inventory, accounts receivable, and accounts payable and support your decisions with specific references to analytical procedures performed in \"1\" above to provide support for your conclusions