6a. Open a new worksheet, call it "youriastnameStmts". 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 (Requirement #5) 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. 7 Prepare a projected income statement for 2019 (in good form) using the variable costing approach. 7a. Place this income statement right below the absorption costing statement. Also show revenues, costs, and net operating income for each of the three product lines. Using cost-volumeprot analysis, determine what total number of units must be sold in order to earn a company-wide prot of $450,000. Add a comment by your calculation to draw attention to this gure. When you have nished these two income statements, remove the gridlines so they are easier to read