ROI - Excel

Document Sample
ROI - Excel Powered By Docstoc
					                                                                   TANDBERG ROI CALCULATOR
Enter your data:                                                                                                                              Savings:
STEP 1: Select Currency                                 US$                    US$          Reduced cost per month                                          2,184                             US$
                                                                                            Time saved per month                                              32                             Hours
STEP 2:   Length of each meeting (Hours)                            2        Hours
STEP 3:   Number of traveling participants              4                    People                                Time to pay for TANDBERG purchase:
STEP 4:   Average yearly salary                         40000                 US$           Step 10: Number of Endpoints                      2
STEP 5:   Number of Meetings/Month                                 4.0       Meetings       Number of meetings                              39.9                                           Meetings
                                                                                            Number of months                                 5.0                                            Months
STEP 6: Enter Total travel time round-trip per person               2         Hours         Depreciation over 3 years                       303                                           per month
STEP 7: Enter Total travel costs                                   100         US$
                                                                                            Cost per meeting:                                        Videoconference Personal attendance
Network:                                                                                    Time spent                                                       8                 16            Hours
STEP 8: Select Type of network                          IP                                  Salary cost                                                    176                352             US$
                                                                                            Travel cost                                                      0                400             US$
                                                                                            Network cost                                                    30                  0             US$



                                                                                            Total cost per meeting                                            206                  752         US$
                                                                                            Total cost per month                                              824                 3,008        US$

                                                                                             ****This file is meant for directional use only to demonstrate the general
                                                                                                                 cost benefit of visual communications***
    STEP 9: Clear Current Selection and Select One
      TANDBERG Product From Specified Group*            TANDBERG ENDPOINTS
                                                               FALSE
                                                          150 MXP
                                                          150 MXP                       1
                                                                  FALSE
                                                             1000 MXP
                                                             1000 MXP                   2
                                                                  FALSE
                                                             1700 MXP
                                                             1700 MXP
                                                                  FALSE
                                                             2000 MXP
                                                             2000 MXP                   3
                                                                  FALSE
                                                             75 EDGE
                                                             75 EDGE                    4 Assumptions




                                         →
                                                                   TRUE
                                                             85 EDGE
                                                             85 EDGE                    5 - Q2 2007 Global Pricing
                                                                  FALSE
                                                             95 EDGE
                                                             95 EDGE                        - Currency Exchange Rates as of 4/4/2007
                                                                  FALSE
                                                             770 MXP
                                                             770 MXP                        - ISDN Costs Estimated 2x more than IP
                                                                  FALSE
                                                             880 MXP
                                                             880 MXP                        - Depreciation Calculated at 3 yr straight line
                                                                  FALSE
                                                             990 MXP
                                                             990 MXP                    6 - Meetings are grouped in Individual (1), Small (2-4), Large (5-10), Very Large (>10)
                                                                  FALSE
                                                             3000 MXP
                                                             3000 MXP                   7
                                                                  FALSE
                                                             6000 MXP
                                                             6000 MXP                   8

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:117
posted:4/1/2010
language:Norwegian
pages:1