on january 1 2011 100 of the outstanding stock of sand company was purchased by plant corporation for 3200000

Throughout 2011, sales to Plant Corporation made up 40% of Sand revenue and produced a 25% gross profit rate. At year-end, Plant Corporation had sold $250,000 of the goods purchased from Sand Company and still owed Sand $30,000. None of the Sand products were in Plant January 1, 2011, beginning inventory.
Required
Prepare the worksheet necessary to produce the consolidated income statement and balance sheet of Plant Corporation and its subsidiary for the year ended December 31, 2011. Include the determination and distribution of excess schedule.