ROI by huanghengdong

VIEWS: 3 PAGES: 4

									                    MetaPack ROI Modeller         V2010s




Sales                            Current                        %
Sales conversion                 6.00%                         100
Orders per week                   1500                 300 equiv. per day

Carrier Charges
Carrier charge (outbound)           £2.80                      100
Carrier charge (return)             £5.00                      100
On Time Deliveries                  95%                        100
Carded Deliveries                   4.7%                       100
Call Centre
WISMO calls                         6.7%                       100
Average call duration (mins)         3.5                       100
Customer Retention
Customer retention rate             40%                        100
SUMMARY OF BENEFITS                         Year 1           Year 2
Improved sales conversion                     0                0
Reduction in carrier spend                    0                0
Improvement in on-time deliveries             0                0
Reduction in carded deliveries                0                0
Reduction in WISMO calls                      0                0
Improved customer retention                   0                0
Total                                         0                0
                                              0                0
Forecast   Constants
 6.00%     Site traffic per week            25,000
  1500     Annual Growth in site traffic     15%
           Average Transaction Value         £46

 £2.80     Margin                           17%
 £5.00     Returns rate                     3.4%
 95%       Ave. Contact Centre Salary pa    £15,000
 4.7%      No of Contact Centre Seats        2
           WhereIsMyOrder? Calls per day     20

0.06667
  3.5      Contact centre cost per minute   £0.25


  40%

 Year 3
   0
   0
   0
   0
   0
   0
   0       * User Amendable Fields shown in Red
   0
     Improved customer retention




       Reduction in WISMO calls




   Reduction in carded deliveries

                                                                                Year 3
                                                                                Year 2
                                                                                Year 1

Improvement in on-time deliveries




       Reduction in carrier spend




      Improved sales conversion



                                    0   0   0   0   0   1   1   1   1   1   1
                                                                                     Input cell
                  MetaPack ROI Modeller           v2010s                             Linked to Main sheet (do not change)
                                                                                     Calculated Cell


SUMMARY OF BENEFITS                         YEAR 1          YEAR 2         YEAR 3            ASSUMPTIONS
Improved sales conversion                        0               0              0
Reduction in carrier spend                       0               0              0
Improvement in on-time deliveries                0               0              0
Reduction in carded deliveries                   0               0              0
Reduction in WISMO calls                         0               0              0
Improved customer retention                      0               0              0
Total                                            0               0              0

BASIC DATA                                  YEAR 1           YEAR 2        YEAR 3            ASSUMPTIONS
Website Traffic per week                     25,000           28,750        33,063          Yearly online sales growth 15.0%
Annual orders                                78,000           89,700       103,155                                              0.1621622
Average transaction value (£)                   £46              £46           £46
Gross revenue (£)                         3,588,000        4,126,200     4,745,130   Cost per order calculation - call centre
Gross margin                                   17%              17%           17%    charge + outbound charge + return
Contact centre cost per minute                £0.25            £0.25         £0.25   charge * return rate + cost of goods +
Carrier charge (outbound)                     £2.80            £2.80         £2.80   carded cancel(margin) + late cancel
Carrier charge (return)                       £5.00            £5.00         £5.00
Returns rate                                  3.4%             3.4%          3.4%    Customer doesn’t pay for returns
Cost per order                               £41.21           £41.21        £41.21

SALES CONVERSION                            YEAR 1          YEAR 2         YEAR 3            ASSUMPTIONS
Current sales conversion                     6.00%           6.00%          6.00%
Annual orders                                78,000          89,700        103,155

MetaPack sales conversion                   6.00%            6.00%          6.00%
Annual orders                               78,000           89,700        103,155

Additional orders                                0                0              0
Revenue Gain (£)                                 0                0              0
Cost of additional orders (£)                    0                0              0

Additional Contribution to profit (£)            0                0              0

CARRIER SPEND                               YEAR 1        YEAR 2           YEAR 3            ASSUMPTIONS
Current carrier charge (outbound)             £2.80         £2.80            £2.80
Current carrier charge (return)               £5.00         £5.00            £5.00
Total carrier charge                    £231,660.00   £266,409.00      £306,370.35


MetaPack carrier charge (outbound)            £2.80         £2.80            £2.80
MetaPack carrier charge (return)              £5.00         £5.00            £5.00
Total carrier charge                    £231,660.00   £266,409.00      £306,370.35

Saving (£)                                       0                0              0

ON-TIME DELIVERIES                          YEAR 1          YEAR 2         YEAR 3            ASSUMPTIONS
Current performance                            95%             95%            95%
# of late deliveries                          3,900           4,485          5,158
Cost of contact centre enquiries (£)          3,413           3,924          4,513
Cost of refunds on cancellations (£)          1,218           1,401          1,611      Refund rate for late deliveries 2.0%

MetaPack performance                           95%             95%            95%
# of late deliveries                          3,900           4,485          5,158
Cost of contact centre enquiries (£)          3,413           3,924          4,513
Cost of refunds on cancellations (£)          1,218           1,401          1,611

Saving (£)                                       0                0              0

CARDED DELIVERIES                           YEAR 1          YEAR 2         YEAR 3            ASSUMPTIONS
Current performance                             5%              5%             5%
# of carded deliveries                        3,643           4,189          4,817
Cost of contact centre enquiries (£)            319             367            422 Number of calls per carded delivery 10%
Cost of refunds on cancellations (£)          2,845           3,272          3,762Cancellation rate for carded deliveries 5%

MetaPack performance                            5%              5%             5%
# of carded deliveries                        3,643           4,189          4,817
Cost of contact centre enquiries (£)            319             367            422
Cost of refunds on cancellations (£)          2,845           3,272          3,762

Saving (£)                                       0                0              0

WISMO CALLS                                 YEAR 1          YEAR 2         YEAR 3            ASSUMPTIONS
Current # of calls per order                    0.1             0.1            0.1
Total # of calls                              5,200           5,980          6,877
Average call duration (minutes)                 3.5             3.5            3.5
Cost of handling calls (£)                    4,550           5,233          6,017

MetaPack # of calls per order          0.066666667    0.066666667      0.066666667
Total # of calls                             5,200          5,980            6,877
Average call duration (minutes)                3.5            3.5              3.5
Cost of handling calls (£)                   4,550          5,233            6,017

Saving (£)                                       0                0              0

CUSTOMER RETENTION                          YEAR 1          YEAR 2         YEAR 3            ASSUMPTIONS
Current retention rate                        40%             40%            40%

MetaPack retention rate                                        40%            40%
Additional orders                                0               0              0
Gross revenue gain (£)                           0               0              0
Cost of additional orders                        0               0              0

Additional contribution to profit (£)                             0              0




Increase repeat custom by x% per year, all converting at 100% and increasing revenue by x * ATV
On time deliveries reduces calls per order?

								
To top