Caribbean Adventure specializes in flights between Toronto, Canada and George Town, Cayman Islands. It books passengers on a variety of airlines which have agreed to charge $700 per person for a roundtrip ticket. Caribbean gets a 15% commission ($105.00) from the airline for each ticket sold. Last year, Caribbean Adventures undertook an advertising campaign to increase business. Jim Smith, the president of Caribbean Adventures wants to know if the advertising campaign was successful. Caribbean advertising and revenue data from last year is presented below. month 3 9 10 advertising revenue A jan $4,400 $50,295 feb $5,500 $58,695 mar 11 $3,900 $49,770 12 apri $1,400 $42,630 13 may $4,900 $51,450 jun $4,100 $55,965 14 15 jul $1,300 $33,180 16 aug $5,700 $51,765 17 sep $5,800 $63,735 oct $2,200 $46,095 18 nov $1,700 530,870 19 dec 53,200 538,850 20 $38,850 average $3,675 $47,775 Caribbean Adventures operates out of an office in a strip mall in uptown Toronto. Monthly costs are $8,290 for rent, $845 for utilities, $1,250 for high speed internet access, and $6,500 for management salaries. The company employs nine customer service representatives who each earn a monthly salary (including benefits) of $1,260. The customer service representatives also get paid a commission of $42 (40% of Caribbean revenuel per ticket sold. rent $8,290 utilities internet access $845 $1,250 management salaries $6,500 employee salaries $11,340 employee sales commission per ticket $42.00 40.0% revenue per ticket $105.00 (1) (2) (3) 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. incremental revenue for $100 of advertising What is expected revenue without advertising? You will have to hard code that number into cell G47 below. revenue without advertising Calculate the incremental profit due to $1,000 of advertising. You will have to create your own income statement for this purpose. + (4) What is the minimum incremental revenue per dollar of advertising that makes the advertising worthwhile? + min incremental revenue per dollar of advert