BC 266: EXCEL PROBLEM PR 17-2A:VERTICAL ANALYSIS   For 2016, Indigo Corp. initiated a sales promotion campaign that included an expenditure of $39,000 for advertising. At year end the company President is presented with the following condensed Comparative Income Statement:     20162015   Sales revenue $820,000 $600,000 COGS [Cost of Goods Sold]311,600240,000 Gross profit508,400360,000 Selling expenses 164,000 108,000 Administrative expenses 57,40054,000 Total operating expenses 221,400162,000 Income from operations [NOI] 287,000 198,000 Other income 65,600 48,000 Income before income tax 352,600 246,000 Income tax expense246,000180,000 Net Income [NI] 106,600 66,000 Prepare a Comparative Income Statement using Vertical Analysis for the two-year period. Present each item as a % of sales for the given year and round your values to one decimal place.

need help

90 Marston Corporation Statement of Income for the Year Ending December 31, 2022 Using Sales Agents Using Own Sales Force $26,000,000 Sales Cost of goods sold Variable Fixed Gross margin Marketing costs Commissions Fixed costs Operating income $11,700,000 2,870,000 4,680,000 3,420,000 $26,000,000 14,570,000 11,430,000 8,100,000 $ 3,330,000 $11,700,000 2,870,000 2,600,000 5,500,000 14,570,000 11,430,000 8,100,000 $ 3,330,000 Marston is considering hiring its own sales staff to replace the network of agents. Marston will pay its salespeople a commission of 10% and incur additional fixed costs of $2,080,000. 4 Required 1. Calculate Marston Corporation's 2022 contribution margin percentage, breakeven revenues, and degree of operating leverage under each of the two scenarios. (You will first have to recast the 2022 statement of income assuming Marston had hired its own sales staff.) 2. Describe the advantages and disadvantages of each type of sales alternative. 3. In 2023, Marston uses its…

Operating results for department B of Shaw Company during 2016 are as follows: Sales   $755,000 Cost of goods sold   480,000 Gross profit   275,000 Direct expenses   215,000 Common expenses   123,000 Total expenses   338,000 Net loss   $(63,000)   If department B could maintain the same physical volume of product sold while raising selling prices an average of 10% and making an additional advertising expenditure of $35,000, what would be the effect on the department's net income or net loss? (Ignore income tax in your calculations.) Use a negative sign with your answer to indicate if the effect increases the company's net loss. If Department B increased its selling price by 10%, the effect on net income (loss) would be $Answer

Ramos Company Ramos Company included the following information in its annual report:   2011 2010 2009 Sales $178,400 $162,500 $155,500 Cost of goods sold 115,000 102,500 100,000 Operating expenses 50,000 50,000 45,000 Net income 13,400 10,000 10,500  Refer to the information for Ramos Company. In a common size income statement for 2011, the operating expenses are expressed as:  Group of answer choices 100 % 50.6 % 30.3 % 28.0 %

A 191.need answer with explanation

14-19 Customer profitability, customer-cost hierarchy. Enviro-Tech has only two retail and two wholesale customers. Information relating to each customer for 2017 follows (in thousands):Wholesale Customers Retail CustomersNorth AmericaWholesalerSouth AmericaWholesaler Green Energy Global PowerRevenues at list prices $375,000 $590,000 $175,000 $130,000Discounts from list prices 25,800 47,200 8,400 590Cost of goods sold 285,000 510,000 144,000 95,000Delivery costs 4,550 6,710 2,230 2,145Order processing costs 3,820 5,980 2,180 1,130Cost of sales visit 6,300 2,620 2,620 1,575Enviro-Tech’s annual distribution-channel costs are $33 million for wholesale customers and $12 million forretail customers. The company’s annual corporate-sustaining costs, such as salary for top managementand general-administration costs are $48 million. There is no cause-and-effect or benefits-received relationship between any cost-allocation base and corporate-sustaining costs. That is, Enviro-Tech could…

Analyzing Operational ChangesOperating results for department B of Shaw Company during 2016 are as follows: Sales   $755,000 Cost of goods sold   480,000 Gross profit   275,000 Direct expenses   215,000 Common expenses   123,000 Total expenses   338,000 Net loss   $(63,000)   If department B could maintain the same physical volume of product sold while raising selling prices an average of 10% and making an additional advertising expenditure of $35,000, what would be the effect on the department's net income or net loss? (Ignore income tax in your calculations.) Use a negative sign with your answer to indicate if the effect increases the company's net loss. If Department B increased its selling price by 10%, the effect on net income (loss) would be $Answer

Analyzing Operational ChangesOperating results for department B of Delta Company during 2016 are as follows: Sales   $550,000 Cost of goods sold   378,000 Gross profit   172,000 Direct expenses   120,000 Common expenses   66,000 Total expenses   186,000 Net loss   $(14,000)   If department B could maintain the same physical volume of product sold while raising selling prices an average of 15% and making an additional advertising expenditure of $60,000, what would be the effect on the department's net income or net loss? (Ignore income tax in your calculations.) Use a negative sign with your answer to indicate if the effect increases the company's net loss. If Department B increased its selling price by 15%, the effect on net income (loss) would be $______

Analyzing Operational ChangesOperating results for department B of Delta Company during 2016 are as follows: Sales   $530,000 Cost of goods sold   378,000 Gross profit   152,000 Direct expenses   120,000 Common expenses   66,000 Total expenses   186,000 Net loss   $(34,000)   If department B could maintain the same physical volume of product sold while raising selling prices an average of 15% and making an additional advertising expenditure of $40,000, what would be the effect on the department's net income or net loss? (Ignore income tax in your calculations.) Use a negative sign with your answer to indicate if the effect increases the company's net loss. If Department B increased its selling price by 15%, the effect on net income (loss) would be $Answer.