need help on the last part thank you!

Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported the following condensed data (dollars in millions) $460 $ 114 90 1110 Research and development expense Income tax expense Loss on disposal of plant assets Cost of goods sold 9,830 Salaries and wages expenses Depreciation expense Sales revenue Interest expense Advertising expense Sales returns and allowances 46 161 4.800 499 Rent expense 105 230 Utilities expense 80 Assume a tax rate of 34% The Clorox Company Income Statement For the Year Ended June 30, 2022 (amounts in millions) Sales Sales Revenue 9830 Less : Sales Returns and Allowances 230 i Net Sales 9600 Cost of Goods Sold 4800 Gross Pront 4B0C Operating Expenses Salaries and Wages Expense 460 Depreciation Expense 90 Advertising Expense 499 Research and Development Expense 114 Rent Expense 105 Utilities Expense 60 Total Operating Expenses 1328 Income From Operations 3470 Other Experises and Losses Interest Expense 161 Loss on Disposal of Plant Assets 46 20 Income Before Income Taxes ncome Tax Expense 1110 Net Income/(Loss) 2150 eTextbook and Media List of Accounts Attempts: 1 of 3 used (b) Your answer is correct Calculate the gross prot rate and the proht margin, (Round answers to 1 decimal place, . 15.2%) Gross profit rate 50 Assume the marketing department has presented a plan to increase advertising expenses by $340 million. It expects this plan to result in an increase in both net sales and cost of goods sold of 25%. (Hint: Increase both sales revenue and sales returns and allowances by 25%) Redo parts (a) and (b) and discuss whether this plan has merit. (Assume a tax rate of 34%, and round all amounts to whole dollars) Prepare a multiple-step income statement. (Round answers to decimal places, es. 15,222) The Clorox Company Income Statement For the Year Ended June 30, 2022 (amounts in millions) Sales Sales Revenues 5