Maple Construction Corp. has a defined benefit pension plan. Information concerning the $207$ and $208$ fiscal years is presented

below:

From the Plan Actuary:

Current service cost in $207$ is $$456,000$ and in $208$ is $$553,000.$

Defined benefit obligation is $$5,105,000$ at the beginning of $207.$

New past service cost in $208$ is $$58,000,$ a reduction in benefits at the beginning of the year.

Accumulated OCl amounts are losses at the beginning of $207,$ amounting to $$800,000.$

Benefits paid to retirees$-$at end of year, $$248,000$ in $207,$ and $$308,000$ in $208.$

Actuarial revaluation in $207$ showed a $$419,000$ increase in the obligation due to changes in mortality. Revaluations take place

every four years.

From the Plan Trustee:

Plan assets at market value at the beginning of $207$ were $$3,770,000.$

$207$ contributions at end of year were $$523,000$ and in $208,$$$551,000.$

Actual earnings were $$302,000$ in $207$ and $$93,000$ in $208.$

Other Information:

Yield on long$-$term debt, stable in $207$ and $208,6\%.$

The opening net defined benefit liability on the SFP is the opening net amount of the defined benefit obligation and opening fund

assets.

Required:

Prepare a spreadsheet for $207$ and $208$ that determines pension expense and also the closing net defined benefit asset or liability

account and accumulated OCl.