please provide an answer using excel formulas!
thanks:)
Royal Raptors operates in two locations - Toronto & Vancouver The following information has been recorded for the previous year Sales Variable expenses at of sales) Thraceable fined expenses Average Operating Assets Minimum Required Rate of Return ROI Toronto 150 DOO 30 78.000 1.200.000 10% 11% Vancouver 6000 60 90.000 2.500X0 1546 224 The company's total fixed costs are $288.000 1. Complete the segment income statement below: Total Company Toronto Vancouver Sales Variable expenses Contribution margin Segment margin Operating income 2. Management would like to increase volumes in Toronto and thus are suggesting an advertising campaign For a cost of $15,000, management can implement a marketing campaign that would increase sales by S45,000 Given that Toronto has a 70% contribution margin how much would overall operating income increase? complete the segment income statement below: 19 Total Company Toronto Vancouver Sales Variable expensee 23 Segment margin 25 26 27 Operating income 30 31 J2 33 2. Management would like to increase volumes in Toronto and thus are suggesting an advertising campaign For a cost of $15,000, management can implement a marketing campaign that would increase sales by $45.00. Given that Toronto has a 70% contribution margin how much would overall operating income increase? Incremental sales 35 36 97 Incremental operating income Should the company move forward with this advertising campaign? 2. Each city has been offered an project that has a ROI of 17% which city will accept this project? Refer to the ROI and RI figures from the above chart If they are evaluated on ROI? If they are evaluated on RI? Vanco TO D Torne 130 03 7.DOO 1.200.000 10 Varihle expense of a Traceable and expenses Avere Operating Assets Minimum Required Rate of Reha 12 2.SO 15 RO 15 The company's total fixed costs are $288.000 16 12 18 19 1. Complete the segment income statement below! 20 Sales Variable expenses Contribution martin Total Company $ 750.00 405.000 345.000 Toronto $150XXO 45 SKO 1050 Vancouver $600 30000 240300 Segment margin Operating income 25 26 27 28 29 30 31 32 33 34 35 6 7 2. Management would like to increase volumes in Toronto and thus are suggesting an advertising campaign For a cost of $15,000, management can implement a marketing campaign that would increase sales by 545.000 Given that Toronto has a 70% contribution margin how much would overall operating income increase? Incremental sales Incremental operating income New