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!


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
Get step-by-step solutions from verified subject matter experts
