- Use Data Table to determine the effect on the NET INCOME AFTER DIVIDENDS for year 2018 by varying the price from $5 to $20 in steps of $1.00 and advertising expenses (in the unit of thousand) from $50 to $250 in steps of 10. (Format the data with 0 decimals.) Print the data table (with row and column headings) for each division option. Decide the best PRICE and ADV combination for cach division option. - Create and print 3D pie graphs of the breakdown of the SALES dollars (i.e., Cost of Goods Sold, Selling, General, and Administrative Expense, Taxes, Dividends, and Net Income After Dividends) for the year 2018 for each of the division addition options. Explode NET INCOME AFTER DIVIDENDS on the 3D pie chart. Each 3D pie graph must include the label and percentage for each component, and the percentage figure must contain two decimals. (If there is any negative component, copy these five components to any available range of cells and convert that negative number to 0 before creating your pie chart.) - Create and print 2D line graphs showing PROFIT MARGIN, RETURN ON TOTAL ASSETS and RETURN ON TOTAL EQUITY for the years 2017 through 2022 for each of the division addition options. - Based on each of the division addition options with its corresponding best PRICE and ADV combination. The figures in your worksheet (except financial ratios) must be in the format of ", " with 0 decimal places. The formats for the financial ratios: CURRENT is in two decimals (i.e., xx.xx ), while PROFIT MARGIN, RETURN ON TOTAL ASSETS, and RETURN ON TOTAL EQUTTY are all in % with two decimals (i.e., xx.xx% ). - Note that formulas must be shown in at least 12-point. Totally, you will have seventeen printouts. Due to economic recession, Joy Appliance Corporation is considering diversifying its operations by introducing cither one, two or three new divisions. Please note that this company can also consider the option of maintaining its current structure (i.c., no new divisions). Before drawing his plan, the owner likes to understand the effects of the pricing and advertising expenditure strategies on the profit after dividends. After analyzing past five years' data, the owner obtained the following price-advertising-sales relationships for openers for year 2017: (ADV denotes advertising budget, and PRICE denotes the unit price. We assume the Quantity Sold yielded from the following formula is in the unit of thousand.) Quantity Sold for Opencrs e761100 PRICE 219+200PRICEADV1/22100(2LN(ADV))1.92+0.4ADV; however, if the Quantity Sold for Openers