Problem : Ces Estima Caribbean Adventure specializes in flights between Toronto, Canada and George Town, Cayman Islands books passengers on a variety of airlines which have apreed to charge 5700 per person for a roundtrip ticket Caribbean get a 15% commission ($105.00) from the airline for each ticket old. Last year, Caribbean Adventures undertask an advertising campaign to increase besiness Jim Smith, the president of Caribbean Adventures wants to know if the advertising campaign was successful. Caribbean advertising and revenue date from last year is presented below advertising TEY jan 54.400 550.295 feb 55.300 558,695 $3.900 5-49,770 $1,400 may 54.900 551 450 jun 54.100 555.965 jul $1,300 53.180 aug 55.700 551,765 SS.800 563.735 52.200 546,095 $1,700 530,870 dec 53.200 $35.850 average 53.675 547.725 Caribbean Adventures operates out of an office in a strip mall in optown Toronto. Monthly costs are 58.290 for Tomt. 5845 for utilities, $1.250 for high speed internet access, and 6.500 for management salaries. The company employ nine customer service representatives who cach cam a monthly salary (including benefits of S1,260 The customer service representatives aloget pand a commission of 2 (40% of Caribbean revenue) per ticket sold TO 58.290 5845 internet access $1.250 management salaries 56.500 $11,340 employee salaries employee sales commission per ticket $42.00 40.0 reve per ticket $105.00 (1) What is the incremental revenue from spending and additional $1,000 on advertising? You will have to hard code that number into cell G30 below. (2 points) incremental revenue for $100 of advertising (2) What is expected revenue without advertising? You will have to hard code that number into cell G47 below. (2 points) revenue without advertising (3) Calculate the incremental profit due to $1,000 of advertising. You will have to create your own income statement for this purpose. (4 points) (4) What is the minimum incremental revenue per dollar of advertising that makes the advertising worthwhile? (4 points) min incremental revenue per dollar of advertising Problem : Ces Estima Caribbean Adventure specializes in flights between Toronto, Canada and George Town, Cayman Islands books passengers on a variety of airlines which have apreed to charge 5700 per person for a roundtrip ticket Caribbean get a 15% commission ($105.00) from the airline for each ticket old. Last year, Caribbean Adventures undertask an advertising campaign to increase besiness Jim Smith, the president of Caribbean Adventures wants to know if the advertising campaign was successful. Caribbean advertising and revenue date from last year is presented below advertising TEY jan 54.400 550.295 feb 55.300 558,695 $3.900 5-49,770 $1,400 may 54.900 551 450 jun 54.100 555.965 jul $1,300 53.180 aug 55.700 551,765 SS.800 563.735 52.200 546,095 $1,700 530,870 dec 53.200 $35.850 average 53.675 547.725 Caribbean Adventures operates out of an office in a strip mall in optown Toronto. Monthly costs are 58.290 for Tomt. 5845 for utilities, $1.250 for high speed internet access, and 6.500 for management salaries. The company employ nine customer service representatives who cach cam a monthly salary (including benefits of S1,260 The customer service representatives aloget pand a commission of 2 (40% of Caribbean revenue) per ticket sold TO 58.290 5845 internet access $1.250 management salaries 56.500 $11,340 employee salaries employee sales commission per ticket $42.00 40.0 reve per ticket $105.00 (1) What is the incremental revenue from spending and additional $1,000 on advertising? You will have to hard code that number into cell G30 below. (2 points) incremental revenue for $100 of advertising (2) What is expected revenue without advertising? You will have to hard code that number into cell G47 below. (2 points) revenue without advertising (3) Calculate the incremental profit due to $1,000 of advertising. You will have to create your own income statement for this purpose. (4 points) (4) What is the minimum incremental revenue per dollar of advertising that makes the advertising worthwhile? (4 points) min incremental revenue per dollar of advertising