Work Sheet Extensions for Merchandise Inventory Adjustments: Periodic Inventory System
1. Complete the Adjustments columns for the merchandise inventory.
2. Extend the merchandise inventory to the Adjusted Trial Balance and Balance Sheet columns.
3. Extend the remaining accounts to the Adjusted Trial Balance and Income Statement columns.
4. Prepare a cost of goods sold section from the partial worksheet.
The following partial worksheet is taken from Kevin's Gift Shop for the year ended December 31, 20--. The ending merchandise inventory is $51,330.
Merchandising Inventory:
1. Complete the Adjustments columns for the merchandise inventory.
2. Extend the merchandise inventory to the Adjusted Trial Balance and Balance Sheet columns.
3. Extend the remaining accounts to the Adjusted Trial Balance and Income Statement columns.
Kevin's Gift Shop | ||||||||||
Work Sheet (Partial) | ||||||||||
For Year Ended December 31, 20-- | ||||||||||
Account Title | Trial Balance | Adjustments | Adjusted Trial Balance | Income Statement | Balance Sheet | |||||
Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | |
Merchandise Inventory | 40870 | 51330 | 40870 | 51330 | 51330 | |||||
Income Summary | 40870 | 51330 | 40870 | 51330 | 40870 | 51330 | ||||
Purchases | 88875 | 88875 | 88875 | |||||||
Purchases Returns and Allowances | 2045 | 2045 | 2045 | |||||||
Purchases Discounts | 2900 | 2900 | 2900 | |||||||
Freight-In | 415 | 415 | 415 |
4.
Kevin's Gift Shop | ||||
Cost of Goods Sold Section | ||||
Cost of goods sold: | ||||
Beginning inventory | 40870 | |||
Purchases | 88875 | |||
Purchases Returns and Allowances | 2045 | |||
Purchases Discounts | 2900 | 4945 | ||
Net purchases | 83930 | |||
Freight-In | 415 | |||
Total purchases | 84345 | |||
Cost of goods available for sale | 125215 | |||
Ending inventory | 51330 | |||
Cost of goods sold | 73885 |
Note: Kindly use minus signs if required in the cost of goods sold section since no instructions have been given regarding the same.
Work Sheet Extensions for Merchandise Inventory Adjustments:Periodic Inventory System1. Complete the Adjustments columns for...
2. Use the following adjustment Information to complete the Adjustments columns of the work sheet. a. Depreciation on equipment, $3 b. Accrued salarles, $6 c. The $12 of unearned revenue has been earned d. Supplies available at December 31, $15 e. Explred Insurance, $15 3. Extend the balances in the Adjusted Trial Balance columns of the work sheet to the proper financial statement columns. Compute totals for those columns Including net Income. WESTCOTT COMPANY Partial Work Sheet For the year...
2. Use the following adjustment information to complete the Adjustments columns of the work sheet. a. Depreciation on equipment. $19 b. Accrued salaries, $22 C. The $28 of unearned revenue has been earned d. Supplies available at December 31, $95 e. Expired insurance, $31 3. Extend the balances in the Adjusted Trial Balance columns of the work sheet to the proper financial statement columns. Compute totals for those columns including net income. WESTCOTT COMPANY Partial Work Sheet For the year...
Completion of a Work Sheet Showing a Net Loss 1. Complete the Adjustments columns. 2. Complete the work sheet. 3. Enter the adjustments in a general journal. If an amount box does not require an entry, leave it blank. The trial balance for Cascade Bicycle Shop, a business owned by David Lamond, is shown below. Cascade Bicycle Shop Trial Balance December 31, 20 -- ACCOUNT TITLE DEBIT BALANCE CREDIT BALANCE Cash 23,105 Accounts Receivable 15,325 Merchandise Inventory 30,635 Supplies 7,000...
2. Use the following adjustment information to complete the Adjustments columns of the work sheet.a. Depreciation on equipment, $8b. Accrued salaries, $11C. The $17 of unearned revenue has been earnedd. Supplies available at December 31, $40e. Expired insurance, $203. Extend the balances in the Adjusted Trial Balance columns of the work sheet to the proper financial statement columns. Compute totals for those columns including net income.
Complete the Adjustments column of the work sheet represented below. Ending merchandise inventory is $92,000. If an amount box does not require an entry, leave it blank. Complete the Adjustments column of the work sheet represented below. Ending merchandise inventory is $92,000. If an amount box does not require an entry, leave it blank. Work Sheet (partial) Trial Balance Debit Credit Adjustments Debit Credit Account Title Merchandise Inventory 81,000 Income Summary Purchases 273,000 Purchases Returns and Allowances 12.100 Purchases Discounts...
Completion of a Work Sheet Showing a Net Loss 1. Complete the Adjustments columns. 2. Complete the work sheet. 3. Enter the adjustments in a general journal. If an amount box does not require an entry, leave it blank. The trial balance for Cascade Bicycle Shop, a business owned by David Lamond, is shown below. Cascade Bicycle Shop Trial Balance December 31, 20 ACCOUNT TITLE DEBIT BALANCE CREDIT BALANCE Cash Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Land Building Accumulated...
22. Use the following information to complete the partial worksheet for Bill's Company. Record the appropriate adjusting entries using the data below and extend the balances over to the adjusted trial balance columns. Please Note: because this is a partial trial balance, your adjusted trial balance columns will not equal. (15 pts) $10 3 Merchandise inventory-ending Store supplies on hand Depreciation on store equipment Accrued salaries Bill's Company Partial Worksheet For the Year Ended December 31, 200x Trial Balance Adjustments...
The adjusted trial balance columns of the worksheet for Bridgeport Company are as follows. Complete the worksheet. Exercise 4-02 The adjusted trial balance columns of the worksheet for Bridgeport Company are as follows. Complete the worksheet. Bridgeport Company Worksheet (Partial) Balance Sheet Adjusted Trial Balance Cr. Income Statement Dr. Cr. Account Titles Dr. Cash 10,600 Accounts Receivable 7,100 Prepaid Rent 2,200 Equipment 23,200 Accumulated Depreciation-Equip. 4,600 Notes Payable 5,900 Accounts Payable 4,800 Common Stock 20,400 Retained Earnings 7,750 Dividends 3,400...
Following are the adjustment data for Bruno Company: a-b. Merchandise inventory (ending), $1,045. c. Professional fees earned, $32,100. d. Supplies inventory (on hand), $1,415. e. Insurance expired, $750. f. Depreciation of office equipment, $300. g. Wages accrued, $630. Record these data in the Adjustments column of the following work sheet. If an amount is zero, enter "0". Bruno Company Worksheet TRIAL BALANCE ADJUSTMENTS ACCOUNT NAME DEBIT CREDIT DEBIT CREDIT Cash 32,725 Accounts Receivable 960 Merchandise Inventory 1,250 Supplies 1,525 Prepaid...
a. c. a. 1. The adjustments entered in the adjustments columns of a worksheet are not journalized. b. posted to the ledger but not journalized. not journalized until after the financial statements are prepared. d. journalized before the worksheet is completed. 2. The information for preparing a trial balance on a worksheet is obtained from financial statements. b. general ledger accounts. general journal entries. d. business documents. 3. After the adjusting entries are journalized and posted to the accounts in...