Prepare consolidation spreadsheet for continuous sale of inventory$-$Cost method

A parent company acquired $100$ percent of the stock of a subsidiary company on January $1,2013,$ for $$800,000.$ On this date, the balances of the subsidiary's stockholders' equity accounts were Common Stock, $$50,000,$ Additional Paid$-$in Capital, $$55,000,$ and Retained Earnings, $$195,000.$ On the acquisition date, the excess was assigned to the following AAP assets:

$\backslash$table$[[,$Original Amount,Original Useful Life,$],[$Property$,$ plant & equipment,$250,000,10,$years$],[$Customer list,$150,000,8,$years$],[$Royalty agreement,$130,000,8,$years$],[$Goodwill$,120,000,$Indefinite,$]]$

The Goodwill asset has been tested annually for impairment, and has not been found to be impaired.

Assume that the parent company sells inventory to its wholly owned subsidiary. The subsidiary, ultimately, sells the inventory to customers outside of the consolidated group. You have compiled the following data for the years ending $2015$ and $2016$:

$\backslash$table$[[\backslash$table$[[$Inventory$],[$Sales$]],\backslash$table$[[$Gross Profit Remaining in$],[$Unsold Inventory$]],\backslash$table$[[$Recelvable$],[($Payable$)]]],[2016,$$$42,000,$$$10,000,$$$30,000$