Maple Construction Corp. has a defined benefit pension plan. Information concerning the 20X7 and 20X8 fiscal years is presented below:

From the Plan Actuary:

• Current service cost in 20X7 is $450,000 and in 20X8 is $538,000.
• The defined benefit obligation is $5,075,000 at the beginning of 20X7.
• The new past service cost in 20X8 is $55,000, a reduction in benefits.
• Accumulated OCI amounts are losses at the beginning of 20X7, amounting to $797,000.
• Benefits paid to retirees—at end of the year, $245,000 in 20X7, and $305,000 in 20X8.
• Actuarial revaluation in 20X7 showed a $416,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 20X7 were $3,755,000.
• 20X7 contributions at end of year were $520,000 and in 20X8, $545,000.
• Actual earnings were $296,000 in 20X7 and $90,000 in 20X8.

Other Information:

• Yield on long-term debt, stable in 20X7 and 20X8, 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 20X7 and 20X8 that determines pension expense and also the closing net defined benefit asset or liability account and accumulated OCI.