Difference between revisions of "Daily Management Report"

From ThermoGRID
Jump to: navigation, search
 
(72 intermediate revisions by 2 users not shown)
Line 1: Line 1:
= Setup =
+
<div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output">
 
<div class="mw-parser-output">
 
<div class="mw-parser-output">
== General Tab ==
+
<div class="mw-parser-output">
 +
<div class="mw-parser-output">
 +
<div class="mw-parser-output">
 +
<div class="mw-parser-output">
 +
<div class="mw-parser-output">
 +
= Setup - SOP =
 +
 
 +
&nbsp;
 +
 
 +
Full SOP&nbsp;
 +
 
 +
[https://help.thermogrid.com/images/e/e4/DMR_SOP_&_Training.docx DMR_SOP_&_Training.docx]&nbsp;‎
 +
 
 +
&nbsp;
 +
 
 +
[https://help.thermogrid.com/images/3/34/ThermoGRID_-_Administration_-_Set-Up_11_-_Daily_Management_Report.docx ThermoGRID_-_Administration_-_Set-Up_11_-_Daily_Management_Report.docx]&nbsp;‎
  
On this tab you can change the Category Name and the Budget Multiplier. The Budget Multiplier will take the budget you type in on the summary page and add this percentage to it. This will increase the budget to a goal and increase the jobs needed to achieve this goal. By having a goal it sets your sights a little higher making it more likely that you will achieve the&nbsp;budget.
+
&nbsp;
 
</div>
 
</div>
  
<div class="mw-parser-output">
+
= Screenshots =
== KPI Tab ==
+
 
 +
&nbsp;
 +
 
 +
[[File:Catagory department.png|1200px|RTENOTITLE]]
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
[[File:Date, tech.png|1200px|RTENOTITLE]]
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
[[File:Types good.png|1200px|RTENOTITLE]]
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
[[File:Types bad.png|1200px|RTENOTITLE]]
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
[[File:Job info and Order match up.png|1200px|RTENOTITLE]]
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
  
On this tab you can set certain KPI's that are expectations for the company as a whole. On the summary page it will display the revenue missed when the company is not achieving these numbers and will show you what you would&nbsp;be on track for if you would be at these numbers. When you are able to see this it will let you know if you have a marketing issue... meaning that there are not enough jobs to hit budget because the KPIs are where they should be. This will also show you if it is a performance issue because there maybe plenty of jobs and the company would be exceeding goal if the team was performing at the right numbers.
+
&nbsp;
 +
[[File:MAtch Job Order DMR.png|1200px|RTENOTITLE]]</div>
 +
&nbsp;
 
</div>
 
</div>
  
 +
= Change Names of category (Calls, job page) =
 +
 +
This drop dow area is strictly for the DMR and for the Call Center Department. To change these you would go to Reports, Daily Management, Settings, Choose a Category, then go to types. The ones that will change this area are in the Call Center Department.
 +
 +
&nbsp;
 +
 +
This drop down area is strictly for the DMR and for the Service, Install or Sales&nbsp;Department. To change these you would go to Reports, Daily Management, Settings, Choose a Category, then go to types. The ones that will change this area are in the&nbsp;Service, Install or Sales&nbsp;Department.
 +
 +
&nbsp;
 +
 +
&nbsp;
 +
 +
The&nbsp;drop down area to the right for the category and&nbsp;department can be changed in the DMR as well. This all can be done by following&nbsp;the steps above.
 +
 +
&nbsp;
 +
</div> <div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output"><div class="mw-parser-output">
 +
<div class="mw-parser-output">
 
<div class="mw-parser-output">
 
<div class="mw-parser-output">
== Department Tab ==
+
<div class="mw-parser-output">
 +
= History and Reconciling =
  
On this tab you can Create a department or separate tap on the DMR... Example:&nbsp;Sales Service Install, Call Center. Here you are also a Set Average Sale, Average Ticket, % of revenue (meaning what percentage of the total companies revenue is made up by this department). You can choose if it applies to the Budget or not.. make sure you do not double count your revenue. You are able to rename sections here as well on the DMR as well.
+
To get to your Data Sources and History, simply click on the DMR and You will see the options on the top right of the Departments tab list.
</div>
+
 
 +
[[File:DMR Data Sources and History.png]]
  
 +
&nbsp;
 
<div class="mw-parser-output">
 
<div class="mw-parser-output">
== Types Tab ==
+
== Data Sources ==
 +
 
 +
This Page will display all instances of Data transferring to the DMR or not transferring to the DMR.&nbsp; This will display&nbsp;an Orange Warning/Notification on the Call/Job/Order to ensure there is a simple way to view and rectify the instance.
 +
 
 +
[[File:DMR data sources overview.png|RTENOTITLE]]
 +
 
 +
Once you see that&nbsp;there may be objects that need to be rectified; you can select the Call, Jobs or Orders Tab to view all data.&nbsp; This allows you to easily View Primary Job Type, Category, Department and The Type/Opportunities that were available for that Instance.&nbsp;
  
''On this tab you can Setup the types of KPIs that you want to track.&nbsp;''
+
By clicking on the Job Number you can adjust Types/Opportunities for that Job.&nbsp; By using the Button on the right you can instantly run a detailed report in DMR History for that Object.&nbsp;
  
'''Dollars Per Lead:'''&nbsp;This is the total revenue brought in divided by the total number of jobs ran.&nbsp;
+
[[File:DMR data sources jobs.png|RTENOTITLE]]
  
'''Avg Ticket:'''&nbsp;This is&nbsp;the total revenue divided by the completed service/install jobs or sold sales jobs.
+
&nbsp;
 +
</div> <div class="mw-parser-output"><div class="mw-parser-output">
 +
== History ==
  
'''Fixed Call Number:'''&nbsp;This means total calls ran. Example: run 30 Calls/Jobs.&nbsp;
+
&nbsp;The History Option will allow you to Filter by:
  
'''Fixed Sales Number:'''&nbsp;This means number sold. Example: Sell 10 clubs.
+
*Month
 +
*User
 +
*Object
 +
*DMR Category
 +
*DMR Department
 +
*DMR Type<br/> <br/> This will give you the tools necessary to double check and rectify an inconsistencies you may find in your DMR or verifying your expectations of the functionality.&nbsp;<br/> <br/> &nbsp;  
  
'''Percentage of Sales Calls''': This means having a certain % to all jobs Example: 10% of all jobs ran.
+
You can see here that we have filtered by a Job Number.&nbsp; &nbsp;This has provided us with a timestamp of the interaction, the user it applies to, the Category, Department and Service; as well as the reason it was added and what changed in that instance.&nbsp;
  
'''Total Revenue''': This is the total revenue sold. Example Sell $100,000
+
You can use this tool to directly correlate the processes to the Report.&nbsp;
  
'''Include Summary''': means it will take jobs and revenue and add up in the summary if you have this set for no it will exclude it from the summary.
+
[[File:DMR History.png|RTENOTITLE]]
  
Track Runs: Will track if a job or lead has been ran if set to yes.
+
&nbsp;
  
Track Revenue: This will show any revenue tied to the job if set to yes.
+
''DMR Correlation from opportunities on&nbsp;the Job&nbsp;object above <span style="color:#bdc3c7;">(Dispatched Job was not Included, just the selected Opportunities from the Job)</span>''
  
Track Generated: This will track leads generated from service if set to yes.
+
[[File:DMR History connection.png|RTENOTITLE]]
</div>
+
</div> </div> </div>
  
== Tech Levels Tab ==
 
== DMR Summary Tab ==
 
== DMR Sales Tab ==
 
== DMR Service Tab ==
 
== DMR Install Tab ==
 
 
<div class="mw-parser-output">
 
<div class="mw-parser-output">
= Understanding How Numbers Flow in DMR =
+
<div class="mw-parser-output">
 +
= Common Challenges =
  
<u>'''First Column'''</u>
+
<span style="font-size:medium;">'''Data not showing&nbsp;up in the DMR.'''</span>
  
1. The first column for Sales, Service, and Install (for install it will also add the revenue) will have a number show up for the individual when a job is dispatched. The Job info must be setup correctly.&nbsp;[http://www.thermogrid.org/dmr2.html SEE HERE]
+
1. Check the job is dispatched on the proper tech or representative.
  
'''Example:'''&nbsp;If we have a job Scheduled for May and we dispatch it to a team member they will get an additional number in the first column of the DMR. If we want the number to be in April we would reschedule the job for April.
+
*If an order&nbsp;created already and submitted, unsubmit the order then assign the&nbsp;job to the tech.  
  
<u>'''Second Column & Revenue'''</u>
+
2. Check on&nbsp;the "Job info" page, make sure it has all info on the right. Category, Department, and Job type(s)
  
2. For sales and service the second column comes from an order being submitted and it will tie it to the month the job is scheduled for.
+
*If an order was already&nbsp;submitted, unsubmit the order then add the Category, Department, and Job type(s), now&nbsp;you can resubmit.  
  
'''Example:'''&nbsp;If We have a job scheduled in May and a tech adds an order to the job and submits it,&nbsp;there will be an additional number added to second column&nbsp;in May.
+
3. Check that the tech or Representative was the one that created the order.
  
<u>'''If we need to move the revenue from one month to another'''</u>
+
*You can have them recreate their own order or you can manually type te data into the DMR.
  
1. Go to the order and change the status to open, this will pull the revenue and the number in the second column out of the DMR for the month in question.&nbsp;
+
&nbsp;
  
2. Reschedule the job for the month you want the revenue to show up in and have the technician or sales rep resubmit the job.&nbsp;
+
<span style="font-size:large;">'''The Job didn't have the Type(s) on it when the tech or representative&nbsp; submitted their order.'''</span>
  
3. To move revenue of an install all you have to do is move the install job to the month you want you do not need to do anything with the orders.
+
*If an order was already&nbsp;submitted, unsubmit the order then add the Category, Department, and Job type(s), now&nbsp;you can resubmit.
 +
 
 +
&nbsp;
 +
 
 +
'''How to track down missing data that should be in the DMR:''' Use the History and Reconciliation Instruction above.&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 
</div>
 
</div>
 
= Change Names of category (Calls, job page) =
 
= Common Challenges =
 

Latest revision as of 08:41, 7 October 2021

Change Names of category (Calls, job page)

This drop dow area is strictly for the DMR and for the Call Center Department. To change these you would go to Reports, Daily Management, Settings, Choose a Category, then go to types. The ones that will change this area are in the Call Center Department.

 

This drop down area is strictly for the DMR and for the Service, Install or Sales Department. To change these you would go to Reports, Daily Management, Settings, Choose a Category, then go to types. The ones that will change this area are in the Service, Install or Sales Department.

 

 

The drop down area to the right for the category and department can be changed in the DMR as well. This all can be done by following the steps above.

 

History and Reconciling

To get to your Data Sources and History, simply click on the DMR and You will see the options on the top right of the Departments tab list.

DMR Data Sources and History.png

 

Data Sources

This Page will display all instances of Data transferring to the DMR or not transferring to the DMR.  This will display an Orange Warning/Notification on the Call/Job/Order to ensure there is a simple way to view and rectify the instance.

RTENOTITLE

Once you see that there may be objects that need to be rectified; you can select the Call, Jobs or Orders Tab to view all data.  This allows you to easily View Primary Job Type, Category, Department and The Type/Opportunities that were available for that Instance. 

By clicking on the Job Number you can adjust Types/Opportunities for that Job.  By using the Button on the right you can instantly run a detailed report in DMR History for that Object. 

RTENOTITLE

 

History

 The History Option will allow you to Filter by:

  • Month
  • User
  • Object
  • DMR Category
  • DMR Department
  • DMR Type

    This will give you the tools necessary to double check and rectify an inconsistencies you may find in your DMR or verifying your expectations of the functionality. 

     

You can see here that we have filtered by a Job Number.   This has provided us with a timestamp of the interaction, the user it applies to, the Category, Department and Service; as well as the reason it was added and what changed in that instance. 

You can use this tool to directly correlate the processes to the Report. 

RTENOTITLE

 

DMR Correlation from opportunities on the Job object above (Dispatched Job was not Included, just the selected Opportunities from the Job)

RTENOTITLE

Common Challenges

Data not showing up in the DMR.

1. Check the job is dispatched on the proper tech or representative.

  • If an order created already and submitted, unsubmit the order then assign the job to the tech.

2. Check on the "Job info" page, make sure it has all info on the right. Category, Department, and Job type(s)

  • If an order was already submitted, unsubmit the order then add the Category, Department, and Job type(s), now you can resubmit.

3. Check that the tech or Representative was the one that created the order.

  • You can have them recreate their own order or you can manually type te data into the DMR.

 

The Job didn't have the Type(s) on it when the tech or representative  submitted their order.

  • If an order was already submitted, unsubmit the order then add the Category, Department, and Job type(s), now you can resubmit.

 

How to track down missing data that should be in the DMR: Use the History and Reconciliation Instruction above.