Difference between revisions of "Daily Management Report"

From ThermoGRID
Jump to: navigation, search
 
(68 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">
 
<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">
 +
= 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;‎
 +
 
 +
&nbsp;
 +
</div>
  
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;
+
= Screenshots =
  
 
&nbsp;
 
&nbsp;
  
http://nebula.wsimg.com/ee597f270c698e525539fbde211415c8?AccessKeyId=AA19C13E8A4EF537D068&disposition=0&alloworigin=1
+
[[File:Catagory department.png|1200px|RTENOTITLE]]
<div class="mw-parser-output">&nbsp;</div> </div>
 
  
== KPI Tab ==
+
&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;
</div>
+
 
 +
&nbsp;
 +
 
 +
[[File:Date, tech.png|1200px|RTENOTITLE]]
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
[[File:Types good.png|1200px|RTENOTITLE]]
 +
 
 +
&nbsp;
  
<div class="mw-parser-output">
+
&nbsp;
== Department Tab ==
 
  
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.
+
&nbsp;
</div>
 
  
<div class="mw-parser-output">
+
&nbsp;
== Types Tab ==
 
  
''On this tab you can Setup the types of KPIs that you want to track.&nbsp;''
+
[[File:Types bad.png|1200px|RTENOTITLE]]
  
'''Dollars Per Lead:'''&nbsp;This is the total revenue brought in divided by the total number of jobs ran.&nbsp;
+
&nbsp;
  
'''Avg Ticket:'''&nbsp;This is&nbsp;the total revenue divided by the completed service/install jobs or sold sales jobs.
+
&nbsp;
  
'''Fixed Call Number:'''&nbsp;This means total calls ran. Example: run 30 Calls/Jobs.&nbsp;
+
&nbsp;
  
'''Fixed Sales Number:'''&nbsp;This means number sold. Example: Sell 10 clubs.
+
&nbsp;
  
'''Percentage of Sales Calls''': This means having a certain % to all jobs Example: 10% of all jobs ran.
+
&nbsp;
  
'''Total Revenue''': This is the total revenue sold. Example Sell $100,000
+
[[File:Job info and Order match up.png|1200px|RTENOTITLE]]
  
'''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.
+
&nbsp;
  
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.
+
&nbsp;
  
Track Generated: This will track leads generated from service if set to yes.
+
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
[[File:MAtch Job Order DMR.png|1200px|RTENOTITLE]]</div>
 +
&nbsp;
 
</div>
 
</div>
  
<div class="mw-parser-output">
+
= Change Names of category (Calls, job page) =
== Tech Levels Tab ==
+
 
 +
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;
  
''You are able to set different expectations and goals for each person in the company based on experience and ability. You will be able to set minimum expectations and goals to all "Types" of goals you entered. The system comes with 8 levels by default with different expectations at each level. All you need to do is click the drop down next to "Techs" and add all team members in to a level that you would dispatch any type of job to and anyone you want to show up on the DMR.''
+
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.
</div>
 
  
 +
&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">
== DMR Summary Tab ==
+
<div class="mw-parser-output">
 +
<div class="mw-parser-output">
 +
= 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.
  
Type in your budget at the top in the cell monthly budget. Click the link next to "Working Days" and make sure all working days are grey and non working days and holidays are white. This will give you a summary of the entire company and what is needed per day to achieve the goal.
+
[[File:DMR Data Sources and History.png]]
  
 
&nbsp;
 
&nbsp;
 +
<div class="mw-parser-output">
 +
== Data Sources ==
  
The indicator will track what you would be on track for if the performance was at the expectation.
+
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.
</div>
+
 
 +
[[File:DMR data sources overview.png|RTENOTITLE]]
  
<div class="mw-parser-output">
+
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;
== DMR Sales Tab ==
 
  
In the picture "Total Sales Calls" is actually the number of jobs dispatched to the individual.
+
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;
  
History will give you a history of everything booked, dispatched, moved etc.
+
[[File:DMR data sources jobs.png|RTENOTITLE]]
  
If the numbers do not add up you can click "recalculate"
+
&nbsp;
 +
</div> <div class="mw-parser-output"><div class="mw-parser-output">
 +
== History ==
  
Red is below expectation, Yellow is above expectation but below goal, and green is above goal.
+
&nbsp;The History Option will allow you to Filter by:
  
Next call means sell it at that amount to get back on track to achieve your goal... then it goes to next 2 and 3 Calls/Jobs.&nbsp;
+
*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;  
  
Run rate is calculating what revenue will be in the end of the month if everything continues the way it is currently.
+
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;
  
'''''*To ensure all info shows up where it needs to make sure you check the items properly on the order submit page. For more info click Which boxes should I check.'''''
+
You can use this tool to directly correlate the processes to the Report.&nbsp;
  
http://nebula.wsimg.com/3819d570de4739308843da1fc9b5bed0?AccessKeyId=AA19C13E8A4EF537D068&disposition=0&alloworigin=1
+
[[File:DMR History.png|RTENOTITLE]]
  
 
&nbsp;
 
&nbsp;
</div>
 
  
== DMR Service Tab ==
+
''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>''
== DMR Install Tab ==
+
 
 +
[[File:DMR History connection.png|RTENOTITLE]]
 +
</div> </div> </div>
 +
 
 
<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.