Consider the data of the following companies which use the periodic inventory system: (Click the icon to view the data.) i Data Table Read the requirements. Requirement 1. Supply the missing amounts for each of the following companies: Beginning Ending Net Sales Merchandise Net Cost of Merchandise Cost of Gross Beginning Merchandise Ending Merchandise Net Sales Net Cost of Cost of Gross Company Revenue Inventory Purchases Inventory Goods Sold Profit Company Revenue Inventory Purchases Inventory Goods Sold Profit Red 101,000 $ 63,000 $ 15,000 29,000 Red $ 101,000 $ 24,000 $ 63,000 $ 15,000 $ 29,000 Yellow 95,000 (c) (b) 94,000 24,000 $ 28,000 (d) 11,000 (a) $ 90,000 60,000 43,000 (e) Orange 21,000 52,000 (f) Green 82,000 8,000 51,000 i Requirements Print Done 1. Supply the missing amounts in the preceding table. 2. Prepare the income statement for the year ended December 31, 2019, for Red Company, which uses the periodic inventory system. Include a complete heading, and show the full computation of cost of goods sold. Red's operating expenses for the year were $16,000