- + Fit to page D Pa PURCHASE AND SALES DATA DATE QUANTITY PRICE/COST 1,000 $20 1/1 500 SCENARIO #1 TRANSACTION Beginning Inventory Sale Purchase Sale Sale Purchase Sale 4/2 5/1 7/17 10/5 11/2 12/8 $23 2,000 1,400 600 1,950 1,670 S24 DATE 1/1 4/2 SCENARIO #2 TRANSACTION Beginning Inventory Sale Purchase Sale Sale Purchase Sale 5/1 7/17 10/5 11/2 12/8 $18 QUANTITY PRICE/COST 1,000 $20 500 2,000 1,400 600 1,950 $17 1,670 DE L u Elt to page Credit $ SPARE PARTS, INC. Adjusted Trial Balance December 31, 2016 SCENARIO #2 Debit CASH 450,000 ACCOUNTS RECEIVABLE 28,000 INVENTORY 20,000 SUPPLIES 12,000 EQUIPMENT 352,000 ACCUMULATED DEPRECIATION-EQUIPMENT ACCOUNTS PAYABLE NOTES PAYABLE (DUE IN 3 YEARS) INTEREST PAYABLE SALARIES AND WAGES PAYABLE UTILITIES PAYABLE COMMON STOCK PAID IN CAPITAL IN EXCESS OF PAR RETAINED EARNINGS DIVIDENDS 10,000 SALES REVENUE PURCHASES 69,150 RENT EXPENSE 16,000 INSURANCE EXPENSE 5,000 INTEREST EXPENSE 250 SALARIES AND WAGES EXPENSE 80,000 SUPPLIES EXPENSE 8,000 UTILITIES EXPENSE 6,000 DEPRECIATION EXPENSE 2.500 PHONE/INTERNET EXPENSE 1,200 ADVERTISING EXPENSE 16,000 $ 1,076,100 10,000 1,000 5,000 450 4,500 150 40,000 10,000 25,000 980,000 S 1,076,100 Mini-Project #3 Inventory STUDENT ROLE: You are employed with Johnson Accounting Firm as an entry-level accountant. Today you have been assigned to work with Spare Parts, Inc. to help answer some of their inventory questions. CLIENT PROFILE: Spare Parts, Inc. is a regional retail chain that sells repair parts for vehicles, tractors, and yard equipment. They have been in business since 2010, and are a publicly traded company. Spare Parts, Inc. recently hired a new CEO and he is reviewing the accounting practices related to Inventory. His company currently uses LIFO for tax reporting and financial reporting and wants to understand the impact of switching to FIFO for financial reporting. The company uses a periodic inventory method, and has a 28% tax rate. The client has 80,000 shares of common stock outstanding, with a par value of $0.50 per share. ASSIGNMENT: To help him make this decision, your supervisor has asked you to complete several tasks. In Blackboard you have been provided a PURCHASE AND SALES DATA table, with two scenarios. Under Scenario #1, purchase prices are increasing. In Scenario #2, purchase prices are decreasing. You have also been provided with a Trial Balance for December 31, 2016. All account balances are current and adjusted except for the Inventory account and Cost of Goods Sold, which are at beginning balances. Because the company uses the periodic method, these accounts have not been adjusted yet. SCENARIO #2 CALCULATIONS Task 3: Using the PURCHASE AND SALES DATA table and TRIAL BALANCE for Scenario #2: Apply the FIFO method to calculate Ending Inventory and Cost of Goods Sold for Scenario #2. Show your work in either Excel or Word. Prepare the year-end adjusting entry to record Inventory and Cost of Goods Sold for both scenarios. HINT: Beginning Inventory is $20,000. The PURCHASE account does have a balance, but the company did not have any purchase returns, purchase discounts or freight-in. Prepare a Multiple-Step Income Step and a Balance Sheet for both scenarios. The client has a 28% tax rate. Task 4: Using the PURCHASE AND SALES DATA table and TRIAL BALANCE for Scenario #2: Apply the LIFO method to calculate Ending Inventory and Cost of Goods Sold for Scenario #2. Show your work in either Excel or Word. Prepare the year-end adjusting entry to record Inventory and Cost of Goods Sold for both scenarios. HINT: Beginning Inventory is $20,000. The PURCHASE account does have a balance, but the company did not have any purchase returns, purchase discounts or freight-in. Prepare a Multiple-Step Income Step and a Balance Sheet for both scenarios. The client has a 28% tax rate. - + Fit to page D Pa PURCHASE AND SALES DATA DATE QUANTITY PRICE/COST 1,000 $20 1/1 500 SCENARIO #1 TRANSACTION Beginning Inventory Sale Purchase Sale Sale Purchase Sale 4/2 5/1 7/17 10/5 11/2 12/8 $23 2,000 1,400 600 1,950 1,670 S24 DATE 1/1 4/2 SCENARIO #2 TRANSACTION Beginning Inventory Sale Purchase Sale Sale Purchase Sale 5/1 7/17 10/5 11/2 12/8 $18 QUANTITY PRICE/COST 1,000 $20 500 2,000 1,400 600 1,950 $17 1,670 DE L u Elt to page Credit $ SPARE PARTS, INC. Adjusted Trial Balance December 31, 2016 SCENARIO #2 Debit CASH 450,000 ACCOUNTS RECEIVABLE 28,000 INVENTORY 20,000 SUPPLIES 12,000 EQUIPMENT 352,000 ACCUMULATED DEPRECIATION-EQUIPMENT ACCOUNTS PAYABLE NOTES PAYABLE (DUE IN 3 YEARS) INTEREST PAYABLE SALARIES AND WAGES PAYABLE UTILITIES PAYABLE COMMON STOCK PAID IN CAPITAL IN EXCESS OF PAR RETAINED EARNINGS DIVIDENDS 10,000 SALES REVENUE PURCHASES 69,150 RENT EXPENSE 16,000 INSURANCE EXPENSE 5,000 INTEREST EXPENSE 250 SALARIES AND WAGES EXPENSE 80,000 SUPPLIES EXPENSE 8,000 UTILITIES EXPENSE 6,000 DEPRECIATION EXPENSE 2.500 PHONE/INTERNET EXPENSE 1,200 ADVERTISING EXPENSE 16,000 $ 1,076,100 10,000 1,000 5,000 450 4,500 150 40,000 10,000 25,000 980,000 S 1,076,100 Mini-Project #3 Inventory STUDENT ROLE: You are employed with Johnson Accounting Firm as an entry-level accountant. Today you have been assigned to work with Spare Parts, Inc. to help answer some of their inventory questions. CLIENT PROFILE: Spare Parts, Inc. is a regional retail chain that sells repair parts for vehicles, tractors, and yard equipment. They have been in business since 2010, and are a publicly traded company. Spare Parts, Inc. recently hired a new CEO and he is reviewing the accounting practices related to Inventory. His company currently uses LIFO for tax reporting and financial reporting and wants to understand the impact of switching to FIFO for financial reporting. The company uses a periodic inventory method, and has a 28% tax rate. The client has 80,000 shares of common stock outstanding, with a par value of $0.50 per share. ASSIGNMENT: To help him make this decision, your supervisor has asked you to complete several tasks. In Blackboard you have been provided a PURCHASE AND SALES DATA table, with two scenarios. Under Scenario #1, purchase prices are increasing. In Scenario #2, purchase prices are decreasing. You have also been provided with a Trial Balance for December 31, 2016. All account balances are current and adjusted except for the Inventory account and Cost of Goods Sold, which are at beginning balances. Because the company uses the periodic method, these accounts have not been adjusted yet. SCENARIO #2 CALCULATIONS Task 3: Using the PURCHASE AND SALES DATA table and TRIAL BALANCE for Scenario #2: Apply the FIFO method to calculate Ending Inventory and Cost of Goods Sold for Scenario #2. Show your work in either Excel or Word. Prepare the year-end adjusting entry to record Inventory and Cost of Goods Sold for both scenarios. HINT: Beginning Inventory is $20,000. The PURCHASE account does have a balance, but the company did not have any purchase returns, purchase discounts or freight-in. Prepare a Multiple-Step Income Step and a Balance Sheet for both scenarios. The client has a 28% tax rate. Task 4: Using the PURCHASE AND SALES DATA table and TRIAL BALANCE for Scenario #2: Apply the LIFO method to calculate Ending Inventory and Cost of Goods Sold for Scenario #2. Show your work in either Excel or Word. Prepare the year-end adjusting entry to record Inventory and Cost of Goods Sold for both scenarios. HINT: Beginning Inventory is $20,000. The PURCHASE account does have a balance, but the company did not have any purchase returns, purchase discounts or freight-in. Prepare a Multiple-Step Income Step and a Balance Sheet for both scenarios. The client has a 28% tax rate
