Gordon Company sponsors a defined benefit pension plan. The following information related to the pension plan is available for 2012 and 2013.
2012 2013
Plan assets (fair value), December 31 $1,041,510 $1,265,010
Projected benefit obligation, January 1 1,043,000 1,192,000
Pension asset/liability, January 1 208,600 Cr. ?
Prior service cost, January 1 372,500 357,600
Service cost 89,400 134,100
Actual and expected return on plan assets 35,760 44,700
Amortization of prior service cost 14,900 17,880
Contributions (funding) 171,350 178,800
Accumulated benefit obligation, December 31 745,000 819,500
Interest/settlement rate 8 % 8 %

(a) Compute pension expense for 2012 and 2013.
Pension expense for 2012 $
Pension expense for 2013 $

Cash
Other Comprehensive Income (G/L)
Other Comprehensive Income (PSC)
Pension Asset/Liability
Pension Expense
Postretirement Asset/Liability
Postretirement Expense
Question 3

A partial trial balance of Dickinson Corporation is as follows on December 31, 2012.
Dr. Cr.
Supplies $2,095
Salaries and Wages Payable $1,039
Interest Receivable 5,388
Prepaid Insurance 90,480
Unearned Rent 0
Interest Payable 17,270

1. A physical count of supplies on hand on December 31, 2012, totaled $1,214.
2. Through oversight, the Salaries and Wages Payable account was not changed during 2012. Accrued salaries and wages on December 31, 2012, amounted to $4,786.
3. The Interest Receivable account was also left unchanged during 2012. Accrued interest on investments amounts to $4,129 on December 31, 2012.
4. The unexpired portions of the insurance policies totaled $62,970 as of December 31, 2012.
5. $23,720 was received on January 1, 2012, for the rent of a building for both 2012 and 2013. The entire amount was credited to Rent Revenue.
6. Depreciation for equipment for the year was erroneously recorded as $4,814 rather than the correct figure of $48,140.
7. A further review of depreciation calculations of prior years revealed that depreciation of $7,178 was not recorded. It was decided that this oversight should be corrected by a prior period adjustment.

(a) Assuming that the books have not been closed, what are the adjusting entries necessary at December 31, 2012? (Ignore income tax considerations.) (Credit account titles are automatically indented when amount is entered. Do not indent manually.)
No. Account Titles and Explanation Debit Credit
1.
2.
3.
4.
5.
6.
7.

(b) Assuming that the books have been closed, what are the adjusting entries necessary at December 31, 2012? (Ignore income tax considerations.) (Credit account titles are automatically indented when amount is entered. Do not indent manually.)
No. Account Titles and Explanation Debit Credit
1.
2.
3.
4.
5.
6.
7.

Question 3
Accounts Receivable
Accumulated Depreciation – Buildings
Accumulated Depreciation – Equipment
Accumulated Depreciation – Machinery
Allowance for Doubtful Accounts
Amortization Expense
Bad Debt Expense
Buildings
Cash
Commission Expense
Commission Payable
Construction in Process
Copyrights
Cost of Goods Sold
Dealer’s Fund Reserve
Debt Investments
Deferred Tax Liability
Depreciation Expense
Dividend Revenue
Due to Customer
Equipment
Equity Investments
Equity Investments (Available-for-sale)
Equity Investments (Equity Method)
Fair Value Adjustment
Fair Value Adjustment (Available-for-Sale)
Finance Expense
Gain on Disposal of Plant Assets
Gain on Sale of Plant Assets
Income Summary
Insurance Expense
Interest Receivable
Interest Revenue
Inventory
Inventory on Consignment
Inventory Over and Short
Lawsuit Liability
Lawsuit Loss
Loss Due to Market Decline of Inventory
Machinery
Maintenance and Repairs Expense
No Entry
Prepaid Insurance
Rent Receivable
Rent Revenue
Retained Earnings
Revenue from Investment
Salaries and Wages Expense
Salaries and Wages Payable
Sales Commission Expense
Sales Commission Expense Payable
Sales Commissions Payable
Sales Revenue
Sales Tax Expense
Sales Taxes Payable
Supplies
Supplies Expense
Trademarks
Trucks
Unearned Rent Revenue
Unrealized Holding Gain or Loss – Equity
Unrealized Holding Gain or Loss – Income
Warranty Expense
Warranty Liability

Could these problems please be answered on an Excel Spreadsheet with the formulas for calculations?