tem reporting dashboard
TRANSCRIPT
-
8/6/2019 TEM Reporting Dashboard
1/21
Telecom Cost Reduction Report
Instruction:
A
B
C
D
Purpose: This tool assists in organizing and monitoring TEM activities. By using the vsections, project milestones and tasks can accurately be planned out. Users are encorecord their actual telecom expenses and use historical data. A dashboard will be ma
for viewing useful information regarding TEM.
Please answer a series of questions regarding your voice, data and wirEnsure that everything is answered.
Record TEM staffing information on "2. Staffing Information" tab. The tausers to track projects by staff assigned.
"3. Expense Records" is where users can record ongoing and one-timerelated expenses. Expenses will be tracked and displayed in "6. View Rsection.
Please record TEM activities and telecom cost reduction projects underActivities". Progress will be tracked and displayed in "6. View Report" s
Info-Tech Research Group tools and template documents are provided for the free anunrestricted use of subscribers to Info-Tech Research Group services. These documeintended to supply general information only, not specific professional or personal advinot intended to be used as a substitute for any kind of professional advice. Use this deither in whole or in part as a basis and guide for document creation. To customize thwith corporate marks and titles, simply replace the Info-Tech Information in the Headfields of this document.
-
8/6/2019 TEM Reporting Dashboard
2/21
riousuraged toe available
less plans.
b will allow
elecom-eport"
"4. TEMction.
dts areice, and areocumentis documenter and Footer
-
8/6/2019 TEM Reporting Dashboard
3/21
Current Voice, Data & Wireless
Please answer the following questions.
Voice
A.
Data and Internet Connectivity
B.
Wireless and Mobile Services
C.
Other Questions
D. What was your total operationing expense from last year?
E. What was your total telecom expense from last year?
How much is your average monthly expense relating to voice? Please insert the
actual amount from last monthly billing cycle if you do not have this number.
How much is your average monthly expense relating to data and Internetconnectivity? Please insert the actual amount from last monthly billing cycle if youdo not have this number.
How much is your average monthly expense relating to wireless and mobiledevices? If you do not have this number, please use the amount from last monthlybilling cycle.
-
8/6/2019 TEM Reporting Dashboard
4/21
-
8/6/2019 TEM Reporting Dashboard
5/21
Staffing Information
Please use the table below to record and keep track of employees responsible for TEM activities. Ensure that inform
Specialty and TEM expertiseProject Team Members, Stakeholders,
and Task Groups
-
8/6/2019 TEM Reporting Dashboard
6/21
ation is updated regularly.
Assigned TEM activity(ies)
-
8/6/2019 TEM Reporting Dashboard
7/21
Expense Records
Bill Bank for Voice Bill
E.g. - Rogers for Landline E.g.Bell for DataE.g. - VoIP from Nortel E.g. Bell for E10 Data lines
Other Bills Not listed Other Bills Not listed
Voice Related Bills Data
Please record all telecom-related expenses going forward. If a non-periodic expenspecific bill under "Bill Type" column. Please delete all entries to begin recording.
Date (Please write theexact date)
Bill Type (Drop-Down)
Amount ($)Date (Please write the
exact date)
-
8/6/2019 TEM Reporting Dashboard
8/21
-
8/6/2019 TEM Reporting Dashboard
9/21
Bank for Data Bill Bank for Wireless
E.g. - Blackberry bill sfrom TelusE.g. - Mobile Internet Bills
box before
Other Bills Not listed
Related Bills Wirelesse Related Bills
e was made, record it under Other Bills and Expenses. You can add different types of expennsure that you record the date on the bill or date of expense entry.
Bill Type (Drop-Down)
Amount ($)
Date (Please write theexact date)
Bill Type (Drop-Down)
Amount ($)
-
8/6/2019 TEM Reporting Dashboard
10/21
-
8/6/2019 TEM Reporting Dashboard
11/21
Bill Bank for Other Bills
E.g. - Device maint. from 3rd party
Other Bills Not listed
Other Bills and Expenses
ses to "Bill Banks" for your convinience and choose a
Date (Please write theexact date)
Bill Type (Drop-Down)
Amount ($)
-
8/6/2019 TEM Reporting Dashboard
12/21
-
8/6/2019 TEM Reporting Dashboard
13/21
Telecom Expense Management Acti
Please record TEM initiatives in this section and r
# Start Date Activity
-
8/6/2019 TEM Reporting Dashboard
14/21
ities
gularly update progress. Ensure that every item in a line is complete.
Description Task Owner Category of
Savings (Drop-Down)
-
8/6/2019 TEM Reporting Dashboard
15/21
Completed Projects 0 Total # of Projects 0
End Date #Complete? (Drop-
Down)
Savings ($)
Achieved
Type (Drop-Down)
-
8/6/2019 TEM Reporting Dashboard
16/21
Issues & Important Notes
Please make note of any important point or issue that arise. Be sure to resolve
# Date Issue
-
8/6/2019 TEM Reporting Dashboard
17/21
ll issues and record details around how and when the issue was resolved.
Comments Resolution Date
-
8/6/2019 TEM Reporting Dashboard
18/21
Breakdown of Telecom Expense
Voice $0
Data $0
Wireless $0
Others $0
$0
$0
$0
$0
$0
$0
$1
$1
$1
$1
$1
Total S
Note: 0 projects were cancelled.000
Overall Project Status
Breakdown of Accumulated Telecom Expense to Date
-
8/6/2019 TEM Reporting Dashboard
19/21
Accumulat
Accumulat
Accumulat
Sum of All Costs Saved is $0$0$0$0
vings Achieved To Date (Annualized)
On-Going: Annual
On-Going: Monthly
One-Time
#VALUE!
$0.00
#VALUE!
$0.00
#VALUE!
$0.00
-
8/6/2019 TEM Reporting Dashboard
20/21
ed Voice Expense to Date: $0.
ed Data Expense to Date: $0.
ed Data Expense to Date: $0.
$0.10 $0.20 $0.30 $0.40 $0.50 $0.60 $0.70
Accumulated Data Expense to Date
$0.10 $0.20 $0.30 $0.40 $0.50 $0.60 $0.70
Accumulated Voice Expense to Date
$0.10 $0.20 $0.30 $0.40 $0.50 $0.60 $0.70
Accumulated Wireless Expense
-
8/6/2019 TEM Reporting Dashboard
21/21
0
0
0
$0.80 $0.90 $1.00
Accumulated Data Expense
$0.80 $0.90 $1.00
Accumulated Voice Expense
$0.80 $0.90 $1.00
Accumulated Wireless Expense