5a. Open a new worksheet, call it "absorptionandvariablecosting". Your income statement should show revenues, costs, and net operating income for each of the three product lines. Use the component product costs for each model directly from the pivot table (use the GetPivotData function) in the cost of goods sold calculations. Check to see that the total product costs for the absorption costing method agree with the grand totals from the pivot table. Assume production stated in the Business Issue occurred and is equal to sales