Inventory Cutoff

1. This is an in" rel="nofollow">individual project. You should not discuss it with anyone, livin" rel="nofollow">ing or dead, other than Dr. Pitman. Students are expected to follow the UTSA Honor Pledge: “As a UTSA Roadrunner I live with honor and in" rel="nofollow">integrity.” 2. There are several parts of this project that you must complete. 3. You have been assigned to the Namtip, Ltd.’s December 31, 2015 audit and will be assistin" rel="nofollow">ing in" rel="nofollow">in several areas of the audit. Accordin" rel="nofollow">ingly, you may fin" rel="nofollow">ind it useful to review the appropriate chapters in" rel="nofollow">in an in" rel="nofollow">intermediate accountin" rel="nofollow">ing textbook and your auditin" rel="nofollow">ing textbook. 4. All of your answers should be in" rel="nofollow">included in" rel="nofollow">in the attached PC Word® file named Project 2 Answers.docx. Do Not change the file name. 5. You should submit your file by attachin" rel="nofollow">ing it through the assignment page of Blackboard Learn. (For help in" rel="nofollow">in submittin" rel="nofollow">ing your assignment see: https://help.blackboard.com/en-us/Learn/9.1_2014_04/Student/060_Assignments/010_Submit_Assignments). Students are responsible for ensurin" rel="nofollow">ing that they have attached the appropriate file and submitted the assignment. 6. There will be no “pregradin" rel="nofollow">ing” of any project. Once you have submitted the file to Blackboard Learn, it is considered to be fin" rel="nofollow">inal and will be graded accordin" rel="nofollow">ingly. 7. If you have any questions about the assignment, please contact Dr. Pitman. 8. Only projects submitted through Blackboard Learn will be graded. Unreadable or corrupt files will be treated as a nonsubmission. 9. Failure to follow the in" rel="nofollow">instructions will result in" rel="nofollow">in a loss of poin" rel="nofollow">ints. 10. No late assignments will be accepted nor graded. 2 Consider Each Part Independently Part I—Inventory Cutoff Only merchandise shipped by the Namtip to customers up to and in" rel="nofollow">includin" rel="nofollow">ing on December 30, 2015, has been elimin" rel="nofollow">inated from its in" rel="nofollow">inventory in" rel="nofollow">in its accountin" rel="nofollow">ing records. The annual physical in" rel="nofollow">inventory count was taken on December 30, 2015 after the close of busin" rel="nofollow">iness has been recorded on the books by the company’s controller. No perpetual in" rel="nofollow">inventory records for fin" rel="nofollow">inished goods are main" rel="nofollow">intain" rel="nofollow">ined. All sales are made on an FOB–shippin" rel="nofollow">ing poin" rel="nofollow">int basis. You are to assume that all purchase in" rel="nofollow">invoices have been correctly recorded. The followin" rel="nofollow">ing lists of sales in" rel="nofollow">invoices are entered in" rel="nofollow">in the sales journal for the last part of December 2015 and first part of January 2016, respectively. Sale Sales Invoice Amount Sales Invoice Date Cost of Merchandise Sold Date Shipped December 2015 A $ 3,000 Dec 21 $ 2,000 Dec 31 B 2,000 Dec 31 800 Dec 13 C 1,000 Dec 29 600 Dec 30 D 4,000 Dec 31 2,400 Jan 9 E 10,000 Dec 30 5,600 Dec 29* January 2016 F 6,000 Dec 31 4,000 Dec 30 G 4,000 Jan 2 2,300 Jan 2 H 8,000 Jan 3 5,500 Dec 31 *sent to a consignee Prepare the necessary proposed adjustin" rel="nofollow">ing journal entry, in" rel="nofollow">in proper form, for each of the Sales (A through H). If no adjustin" rel="nofollow">ing journal entry is necessary, you should write NO ADJUSTING ENTRY NEEDED in" rel="nofollow">in the space for that sale. Part II—Inventory Costin" rel="nofollow">ing (Pricin" rel="nofollow">ing) Now you are performin" rel="nofollow">ing costin" rel="nofollow">ing (pricin" rel="nofollow">ing) tests on a sample of the endin" rel="nofollow">ing in" rel="nofollow">inventory. One of the items you selected for cost (price) testin" rel="nofollow">ing is the orange widget, a significant part in" rel="nofollow">in the manufacture of Namtip’s main" rel="nofollow">in products. You noted that the 12/31/15 in" rel="nofollow">inventory record of the orange widgets consisted of 1,263 units (you previously verified that this agreed to the quantity in" rel="nofollow">indicated from the physical in" rel="nofollow">inventory) at $782 each for a total of $987,666. Part II A. When you look at the in" rel="nofollow">invoices for the November and December purchases of the orange widgets, you see the followin" rel="nofollow">ing: Date Quantity Unit Price Total 11/03/15 1,000 $765 $ 765,000 11/22/15 500 770 385,000 12/03/15 800 777 621,600 12/28/15 600 782 469,200 Prepare the adjustin" rel="nofollow">ing entry, in" rel="nofollow">in proper form, for the proper cost of orange widgets at December 31, 2015, assumin" rel="nofollow">ing Namtip Ltd. uses the periodic FIFO method of in" rel="nofollow">inventory. Show supportin" rel="nofollow">ing calculations as necessary. 3 Part II B—Ignore part A. above. Assume you determin" rel="nofollow">ined that the net realizable value for an orange widget is $775 per unit, while the net realizable value less a normal margin" rel="nofollow">in is $745 per unit. Prepare the adjustin" rel="nofollow">ing entry, in" rel="nofollow">in proper form, for the proper presentation of orange widgets at December 31, 2015 assumin" rel="nofollow">ing you examin" rel="nofollow">ined a vendor in" rel="nofollow">invoice dated December 31, 2015 for 500 orange widgets at $750 each for a total of $375,000. The units were ordered on December 29, 2015 and received on January 4, 2016. Show supportin" rel="nofollow">ing calculations as necessary. Part III— Accounts Receivable—Allowance for Doubtful Accounts Another area you have been assigned on the audit is Accounts Receivable—more specifically the Allowance for Doubtful Accounts. You performed the followin" rel="nofollow">ing analysis for the Allowance for Doubtful Accounts: Description Amount Tick Mark Begin" rel="nofollow">innin" rel="nofollow">ing Balance $ 154,000 £ Increase (2% of $10,000,000 credit sales) 200,000 √ Write offs (95,000) ᴓ Recovery of previously written off accounts 15,000 € Endin" rel="nofollow">ing Balance $ 274,000 μ ¥ Tick Mark Legend: £ Traced to prior year’s audit documentation. √ Calculated. ᴓ Reviewed authorization memorandum from the Treasurer. € Traced to cash receipts and reviewed supportin" rel="nofollow">ing documentation. μ Footed. ¥ Traced to the 12/31/15 general ledger. After several discussions with Namtip’s controller, it has was determin" rel="nofollow">ined that Namtip should adopt the agin" rel="nofollow">ing method for estimatin" rel="nofollow">ing the Allowance for Doubtful Accounts. A summary of the agin" rel="nofollow">ing is as follows: Classification by Month of Sale Balance Estimated % Uncollectible November-December 2015 $ 1,080,000 2% July-October 2015 650,000 10% January-June 2015 420,000 25% Prior years’* 150,000 70% Total $ 2,300,000 *$60,000 of the balance is totally uncollectible and should be written off prior to the yearend adjustment. Prepare the proposed necessary adjustin" rel="nofollow">ing journal entries, in" rel="nofollow">in proper form, to ensure that the Allowance for Uncollectible Accounts is in" rel="nofollow">in accordance with generally accepted accountin" rel="nofollow">ing prin" rel="nofollow">inciples as of December 31, 2015. Show supportin" rel="nofollow">ing calculations as necessary. 4 Part IV—Plant, Property and Equipment The accompanyin" rel="nofollow">ing analyses of the Property, Plant, and Equipment and related Accumulated Depreciation accounts have been prepared by the chief accountant of the Namtip. You have traced the begin" rel="nofollow">innin" rel="nofollow">ing balances to your prior year’s audit workin" rel="nofollow">ing papers. Namtip Ltd. Analyses of Property, Plant, and Equipment and Related Accumulated Depreciation Accounts For the Year Endin" rel="nofollow">ing December 31, 2015 Assets Per Ledger 12/31/14 Additions Retirements Per Ledger 12/31/15 Land 422,500 5,000 427,000 Buildin" rel="nofollow">ings 120,000 17,500 137,500 Machin" rel="nofollow">inery and Equipment 385,000 40,400 26,000 399,400 Total 927,500 62,900 26,000 964,400 Accumulated Depreciation Buildin" rel="nofollow">ings 60,000 5,150 65,150 Machin" rel="nofollow">inery and Equipment 173,250 39,220 -0- 212,470 Total 233,250 44,370 -0- 277,620 All plant assets are depreciated on the straight-lin" rel="nofollow">ine basis (no residual value taken in" rel="nofollow">into consideration) based on the followin" rel="nofollow">ing estimated service lives: buildin" rel="nofollow">ing, 25 years; and all other items, 10 years. The company’s policy is to take one half-year’s depreciation on all asset additions and disposals durin" rel="nofollow">ing the year. Your audit revealed the followin" rel="nofollow">ing in" rel="nofollow">information: 1. On April 1, the company entered in" rel="nofollow">into a 10-year lease contract for a die castin" rel="nofollow">ing machin" rel="nofollow">ine, with annual payments of $5,000 payable in" rel="nofollow">in advance every April 1. The lease is cancelable by either party (60 days’ written notice is required), and there is no option to renew the lease or buy the equipment at the end of the lease. The estimated service life of the machin" rel="nofollow">ine is 20 years with no residual value. The company recorded the die castin" rel="nofollow">ing machin" rel="nofollow">ine in" rel="nofollow">in the Machin" rel="nofollow">inery and Equipment account at $40,400, the present value at the date of the lease, and $2,020 applicable to the machin" rel="nofollow">ine has been in" rel="nofollow">included in" rel="nofollow">in depreciation expense for the year. 2. The company completed the construction of a win" rel="nofollow">ing on the plant buildin" rel="nofollow">ing on June 30. The service life of the buildin" rel="nofollow">ing was not extended by this addition. The lowest construction bid received was $17,500, the amount recorded in" rel="nofollow">in the Buildin" rel="nofollow">ings account. Company personnel constructed the addition at a cost of $16,000 (materials, $7,500; labor, $5,500; and overhead, $3,000). 3. On August 18, $5,000 was paid for pavin" rel="nofollow">ing and fencin" rel="nofollow">ing a portion of land owned by the company and used as a parkin" rel="nofollow">ing lot for employees. The expenditure was charged to the Land account. 4. The amount shown in" rel="nofollow">in the machin" rel="nofollow">inery and equipment asset retirement column represents cash received on September 5 upon disposal of a machin" rel="nofollow">ine purchased in" rel="nofollow">in July 2011 for $48,000. The chief accountant recorded depreciation expense of $3,500 on this machin" rel="nofollow">ine in" rel="nofollow">in 2015. 5. Harbor City donated land and a buildin" rel="nofollow">ing appraised at $100,000 and $400,000, respectively, to Namtip, Ltd. for a plant. On September 1, the company began operatin" rel="nofollow">ing the plant. Sin" rel="nofollow">ince no costs were in" rel="nofollow">involved, the chief accountant made no entry for the above transaction. Prepare the adjustin" rel="nofollow">ing journal entries, in" rel="nofollow">in proper form, that you would propose at December 31, 2015, to adjust the accounts for each the above transactions (1-5). Disregard in" rel="nofollow">income tax implications. The accounts have not been closed. Computations should be rounded off to the nearest dollar. If no adjustin" rel="nofollow">ing journal entry is necessary, you should write NO ADJUSTING ENTRY NEEDED in" rel="nofollow">in the appropriate space. Show supportin" rel="nofollow">ing calculations as necessary.