Question: Please I need help with the question asap. Thank you! Situation A client in the hospitality industry with a focus on driving increased conversion rates

Please I need help with the question asap. Thank you!

Please I need help with the question asap. Thank you! Situation A

client in the hospitality industry with a focus on driving increased conversion

Situation

A client in the hospitality industry with a focus on driving increased conversion rates and revenue generation has recently launched a sales channel with an external BPO vendor to challenge the internal sales team performance. After a 2 month trial period, our client must decide on a long term strategy for leveraging the vendor while maximizing revenue potential and cost, based on performance results.

What does this data represent? What does this data tell you?

"What action would you take?

What levers would you pull?"

"What questions or follow up data would you ask for?"

Date Internal Revenue Vendor Revenue Internal Conversion Rate Vendor Conversion Rate
01-Mar-21 $144,602.88 $67,019.32 25% 16%
02-Mar-21 $191,063.70 $72,925.97 27% 18%
03-Mar-21 $181,999.60 $70,211.27 24% 18%
04-Mar-21 $161,601.99 $73,895.04 21% 22%
05-Mar-21 $157,752.12 $58,377.43 21% 19%
06-Mar-21 $108,311.17 $63,789.99 23% 15%
07-Mar-21 $131,705.23 $70,224.28 24% 19%
08-Mar-21 $161,688.37 $80,221.06 25% 17%
09-Mar-21 $157,947.69 $61,217.50 22% 15%
10-Mar-21 $164,699.18 $75,863.21 23% 18%
11-Mar-21 $173,020.54 $60,692.27 21% 14%
12-Mar-21 $157,246.35 $74,907.40 20% 16%
13-Mar-21 $94,980.65 $87,132.95 16% 13%
14-Mar-21 $103,376.54 $74,986.16 22% 15%
15-Mar-21 $179,163.61 $120,384.09 25% 19%
16-Mar-21 $143,848.81 $63,323.43 18% 13%
17-Mar-21 $275,987.30 $126,314.77 31% 25%
18-Mar-21 $190,272.17 $51,781.58 20% 14%
19-Mar-21 $188,860.85 $49,365.13 18% 13%
20-Mar-21 $91,147.13 $65,946.02 14% 11%
21-Mar-21 $107,121.01 $86,622.89 24% 18%
22-Mar-21 $148,098.17 $86,954.54 22% 15%
23-Mar-21 $158,651.22 $69,869.17 25% 18%
24-Mar-21 $373,517.32 $58,339.60 51% 14%
25-Mar-21 $195,570.26 $59,169.52 27% 16%
26-Mar-21 $167,584.09 $43,837.86 19% 14%
27-Mar-21 $108,648.43 $62,696.45 17% 13%
28-Mar-21 $126,450.35 $52,523.62 24% 16%
29-Mar-21 $163,927.05 $85,048.21 21% 18%
30-Mar-21 $170,915.65 $52,787.17 21% 18%
31-Mar-21 $159,574.51 $66,916.52 23% 14%
01-Apr-21 $131,375.08 $55,345.62 19% 14%
02-Apr-21 $107,285.88 $49,116.87 17% 13%
03-Apr-21 $58,549.14 $56,368.32 21% 18%
04-Apr-21 $72,377.73 $47,201.47 32% 22%
05-Apr-21 $118,871.94 $90,707.63 25% 20%
06-Apr-21 $143,044.23 $60,741.69 26% 19%
07-Apr-21 $167,019.44 $58,519.30 24% 17%
08-Apr-21 $133,599.98 $54,602.46 23% 16%
09-Apr-21 $123,574.20 $44,868.76 19% 19%
10-Apr-21 $77,473.48 $58,750.09 22% 13%
11-Apr-21 $84,962.52 $74,540.89 30% 24%
12-Apr-21 $115,511.47 $79,747.23 31% 26%
13-Apr-21 $163,954.14 $51,827.27 37% 24%
14-Apr-21 $132,421.03 $69,634.03 31% 33%
15-Apr-21 $140,699.95 $74,046.47 32% 26%
16-Apr-21 $121,772.78 $44,813.91 28% 19%
17-Apr-21 $68,871.54 $56,661.31 21% 16%
18-Apr-21 $90,540.85 $54,422.37 31% 23%
19-Apr-21 $143,643.63 $69,275.95 36% 28%
20-Apr-21 $138,434.52 $44,310.85 34% 24%
21-Apr-21 $136,938.79 $45,306.61 33% 27%
22-Apr-21 $94,433.16 $32,491.15 15% 9%
23-Apr-21 $123,983.56 $48,048.73 24% 17%
24-Apr-21 $59,324.61 $44,566.67 25% 15%
25-Apr-21 $90,648.44 $71,114.87 28% 31%
26-Apr-21 $98,059.98 $50,915.34 30% 24%
27-Apr-21 $113,850.44 $49,106.23 28% 25%
28-Apr-21 $144,399.14 $39,710.99 32% 24%
29-Apr-21 $101,519.02 $43,006.65 24% 19%
30-Apr-21 $92,882.79 $56,688.38 22% 21%

Revenue Performance $400,000.00 $350,000.00 $300,000.00 $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 $0.00 uli 21-M-21 04-Apr-21 20-Apr-21 24-Apr-21 22-Apr-21 26-Apr-21 28-Apr-21 30-Apr-21 Internal Revenue Vendor Revenue 01-Mar-21 03-Mar-21 OS-Mar-21 07-Mar-21 09-Mar-21 11-Mar-21 13-Mar-21 15-Mar-21 17-Mar-21 19-Mar-21 23-Mar-21 25-Mar-21 27-Mar-21 29-Mar-21 31-Mar-21 02-Apr-21 06-Apr-21 08-Apr-21 10-Apr-21 12-Apr-21 14-Apr-21 16-Apr-21 18-Apr-21 Internal Conversion Rate 01-Mar-21 02-Mar-21 03-Mar-21 04-Mar-21 05-Mar-21 06-Mar-21 07-Mar-21 08-Mar-21 09-Mar-21 10-Mar-21 11-Mar-21 12-Mar-21 13-Mar-21 14-Mar-21 15-Mar-21 16-Mar-21 17-Mar-21 18-Mar-21 19-Mar-21 20-Mar-21 21-Mar-21 22-Mar-21 23-Mar-21 24-Mar-21 25-Mar-21 26-Mar-21 27-Mar-21 28-Mar-21 29-Mar-21 30-Mar-21 31-Mar-21 01-Apr-21 02-Apr-21 03-Apr-21 04-Apr-21 05-Apr-21 06-Apr-21 07-Apr-21 08-Apr-21 09-Apr-21 10-Apr-21 11-Apr-21 12-Apr-21 13-Apr-21 14-Apr-21 15-Apr-21 16-Apr-21 17-Apr-21 18-Apr-21 19-Apr-21 20-Apr-21 21-Apr-21 22-Apr-21 23-Apr-21 24-Apr-21 25-Apr-21 26-Apr-21 27-Apr-21 28-Apr-21 29-Apr-21 30-Apr-21 Conversion Vendor Conversion Rate Revenue Performance $400,000.00 $350,000.00 $300,000.00 $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 $0.00 uli 21-M-21 04-Apr-21 20-Apr-21 24-Apr-21 22-Apr-21 26-Apr-21 28-Apr-21 30-Apr-21 Internal Revenue Vendor Revenue 01-Mar-21 03-Mar-21 OS-Mar-21 07-Mar-21 09-Mar-21 11-Mar-21 13-Mar-21 15-Mar-21 17-Mar-21 19-Mar-21 23-Mar-21 25-Mar-21 27-Mar-21 29-Mar-21 31-Mar-21 02-Apr-21 06-Apr-21 08-Apr-21 10-Apr-21 12-Apr-21 14-Apr-21 16-Apr-21 18-Apr-21 Internal Conversion Rate 01-Mar-21 02-Mar-21 03-Mar-21 04-Mar-21 05-Mar-21 06-Mar-21 07-Mar-21 08-Mar-21 09-Mar-21 10-Mar-21 11-Mar-21 12-Mar-21 13-Mar-21 14-Mar-21 15-Mar-21 16-Mar-21 17-Mar-21 18-Mar-21 19-Mar-21 20-Mar-21 21-Mar-21 22-Mar-21 23-Mar-21 24-Mar-21 25-Mar-21 26-Mar-21 27-Mar-21 28-Mar-21 29-Mar-21 30-Mar-21 31-Mar-21 01-Apr-21 02-Apr-21 03-Apr-21 04-Apr-21 05-Apr-21 06-Apr-21 07-Apr-21 08-Apr-21 09-Apr-21 10-Apr-21 11-Apr-21 12-Apr-21 13-Apr-21 14-Apr-21 15-Apr-21 16-Apr-21 17-Apr-21 18-Apr-21 19-Apr-21 20-Apr-21 21-Apr-21 22-Apr-21 23-Apr-21 24-Apr-21 25-Apr-21 26-Apr-21 27-Apr-21 28-Apr-21 29-Apr-21 30-Apr-21 Conversion Vendor Conversion Rate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!