January 1, 2017, Heckert Company purchases a controlling interest in Aker Company. The following information is available:

a. Heckert Company purchases 1,600 shares of Aker Company outstanding stock on January 1, 2016, for $48,000 and purchases an additional 1,400 shares on January 1, 2017, for $51,800.

b. An analysis of the stockholders' equity accounts at December 31, 2016, and 2015, follows:

c. Aker Company's marketable securities consist of 1,500 shares of Heckert Company stock purchased on June 15, 2017, in the open market for $18,000. The securities are purchased as a temporary investment and are sold on January 15, 2018, for $25,000.
d. On December 10, 2017, Heckert Company declares a cash dividend of $0.50 per share, payable January 10, 2018, to stockholders of record on December 20, 2017. Aker Company pays a cash dividend of $1 per share on June 30, 2017, and distributes a 10% stock dividend on September 30, 2017. The stock is selling for $15 per share ex-dividend on September 30, 2017. Aker Company pays no dividends in 2016.
e. Aker Company sells machinery, with a book value of $4,000 and a remaining life of five years, to Heckert Company for $4,800 on December 31, 2017. The gain on the sale is credited to the other income account.
f. Aker Company includes all intercompany receivables and payables in its trade accounts receivable and trade accounts payable accounts.
g. During 2017, the following intercompany sales are made:

Heckert Company sells merchandise to Aker Company at cost. Aker Company sells merchandise to Heckert at the regular selling price to make a normal profit margin of 30%. There were no intercompany sales in prior years.
The trial balances of the two companies at December 31, 2017, are as follows:

Required
Prepare the worksheet necessary to produce the consolidated financial statements of Heckert Company and its subsidiary for the year ended December 31, 2017. Include the determination and distribution of excess and income distribution schedules. Assume any excess of cost over book value is attributable to goodwill.

Heckert Company December 31 , Aker Company December 31 2016 2015 2016 2015 Common stock ($10 par)... . Common stock ($5 par) Paid-in capital in excess of par $150,000 $150,000 $ 20,000 20,000 10,000 82,000 $564,000 $471,000 $142,000 $112,000 36,000 378,000 36,000 285,000 10,000 112,000 . . . Included in Purchaser's Inventory aft December 31, 2017 $24,300 18,000 $42,300 Net Sales 04,000 182,000 Heckert Compan Compan Cash Marketable Securities Trade Accounts Receivable Allowance for Doubtful Accounts Intercompany Receivables... 38,100 33,000 210,000 (6,800] 24,000 275,000 29,050 18,000 88,000 2,300) 135,000 514,000 279,000 298,200)(196,700) Machinery and Equipment Investment in Aker Company (at cost) Patents 99,800 35,000 7,00] 5 Trade Accounts Payable (195,00)174,050) (8,000) (150,000 Common Stock ($5 par).. (22,000) 36,000 14,000) 378,000 106,000) 4,000 (850,000 (530,000) Paid-In Capital in Excess of Par Dividends Declared (cash).. . 7,500 Sales and Services. _ _ _ _ . . . . Other Income Depreciation Expense (3,000) (9,000) (3,700) 510,000 374,000 11,200 110,500 65,600 130,000 Totals..._ . _ _ _ . .