1. Miami Insights - MONDAY, July 31

1. Overall Creates

a. B2B creates on MONDAY, July 31 is lower as previous MONDAY, July 24 -(from 71 to 52). D2C creates on MONDAY, July 31 was higher to previous MONDAY, July 24 -(from 36 to 51).

b. Refrigerators had lower creates on MONDAY, July 31 than previous MONDAY, July 24 (from 50 to 47). This will result in lower refrigerators completes in future and consequently could result in lower revenue per call.

2. Overall Completes

a. The number of completes on MONDAY, July 31 dropped by 20.18% v/s previous MONDAY (87 vs 109). Completes dropped by 25.64% v/s the previous year's 4-week MONDAY average (87 vs 117).

i. B2B completes on MONDAY, July 31 = 36 (16 lower than previous MONDAY).

ii. D2C completes on MONDAY, July 31 = 26 (3 lower than previous MONDAY).

3.Financials

a. B2B

i. Revenue for MONDAY, July 31 was $6,503.00. It is lower by $3,318.00 (33.79%) than previous MONDAY, July 24 ($9,821.00).

i. Completes were 36.0 on MONDAY, July 31, lower than previous MONDAY July 24 (52.0). (from 52.0 to 36.0)

ii. Revenue per call was $180.63 on MONDAY July 31, lower than previous MONDAY July 24 ($188.86). (from $188.86 to $180.63))

ii. Top 2 B2B clients by revenue contribution are: Sears Home Warranty Plus ($4,099.00) and Choice Home Warranty ($1,786.00).

iii. Washer (19.44% ,7.0 completes) and Dishwasher (16.67% ,6.0 completes) had the most completes. Refrigerator (16.67%) and Dryers (8.33%) had the least.

b. D2C

i. Revenue for MONDAY, July 31 was $5,502.51. It is decrease by $1,871.67 (25.38%) v/s previous MONDAY, July 24 ($7,374.17).

i. Lower completes (26.0 completes on MONDAY, July 31 v/s 29.0 completes on previous MONDAY July 24) (from 29.0 to 26.0)

ii. Revenue per call on MONDAY, July 31 - $211.63 it’s Lower by $42.65 (16.77%) vs previous MONDAY ($254.28) D2C revenue was low due to low percentage of low parts installed.(from 31.03% to 23.08%)

ii. Refrigerator (34.62% ,9.0 completes) and Washer (19.23% ,5.0 completes) had the most completes. Oven (11.54%) and Dishwasher (3.85%) had the least.

c. Parts Payroll Truck Costs

i. Cost Per Call on MONDAY, July 31 ($82.04) is $19.86 higher v/s previous MONDAY, July 24 ($101.89).

ii. For B2B, parts payroll and truck Costs Per Call on MONDAY, July 31 ($97.10) is $16.29 higher v/s previous MONDAY ($113.39).

iii. For D2C, parts payroll and truck Costs Per Call on MONDAY, July 31 ($58.26) is $16.11 lower v/s previous MONDAY ($74.37).

d. Total Profit with parts payroll and truck Costs

i. Total Profit with parts payroll and truck Costs Per Call on MONDAY, July 31 ($112.82) is 14.75% lower than previous MONDAY, July 24 ($112.87).

ii. For B2B, Total Profit with parts payroll and truck Costs Per Call on MONDAY, July 31 ($83.53) is 14.75% higher to previous MONDAY, July 24 ($75.47).

iii. For D2C, Total Profit with part payroll and truck Costs Per Call on MONDAY, July 31 ($153.38) is14.75% lower v/s previous MONDAY, July 24 ($179.92).

2. Miami Summary Metrics MONDAY, 2023-07-31

Link to National Daily Report : https://searshc-my.sharepoint.com/:u:/g/personal/srinivasa_kandala_transformco_com/EUs_oHsUj2xKjhKHjwGc6tMBa1SbZqrsRDYmoSoPLLd2jA?e=r6uYQc

Creates by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	172	191	175	172	218	138	11,896	680
Assurant PA	63	77	50	62	77	51	2,521	206
B2B	52	71	65	67	80	55	5,288	271
D2C	51	36	50	40	54	32	3,918	189
IW	4	3	5	2	3	0	75	9
PA	2	4	4	2	4	0	94	5

Completes by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	87	109	136	124	142	110	6,399	439
B2B	36	52	60	55	60	50	3,238	206
D2C	26	29	27	30	34	25	1,616	106
Assurant PA	21	27	42	36	44	33	1,434	118
PA	3	0	2	1	1	1	72	8
IW	1	1	4	2	3	1	39	1

Completes by Parts Installed and Payment Type

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PARTS	PAYMENT_TYPE
Total		87	109	136	124	147	98	6,399	439
No Parts Installed	B2B	22	32	23	26	28	22	1,384	90
	D2C	20	20	20	22	28	16	1,052	63
	Assurant PA	16	16	22	23	27	21	851	75
	IW	1	1	2	1	2	1	19	1
	PA	1	0	0	0	0	0	37	2
Sub-Total		60	69	67	73	85	60	3,343	231
Parts Installed	B2B	14	20	37	28	32	23	1,854	116
	D2C	6	9	7	8	11	2	564	43
	Assurant PA	5	11	21	13	17	11	583	43
	PA	2	0	2	1	1	1	35	6
	IW	0	0	2	1	1	1	20	0
Sub-Total		27	40	69	52	62	38	3,056	208

Attempts by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	118	141	180	146	162	135	9,184	621
B2B	49	65	80	68	72	65	4,891	313
D2C	33	37	33	39	41	37	2,138	129
Assurant PA	31	37	58	38	46	32	1,965	161
PA	4	0	4	0	1	0	129	15
IW	1	2	6	2	2	1	61	3

Attempts by Parts Installed and Payment Type

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PARTS	PAYMENT_TYPE
Total		118	141	180	147	176	117	9,184	621
No Parts Installed	B2B	34	39	28	31	39	27	2,924	188
	D2C	27	26	24	29	31	26	1,552	86
	Assurant PA	26	24	24	23	25	19	1,325	114
	IW	1	2	2	2	2	1	41	3
	PA	1	0	0	0	0	0	89	8
Sub-Total		89	91	80	84	97	73	5,931	399
Parts Installed	B2B	15	26	51	36	44	26	1,967	125
	D2C	6	11	9	10	11	6	586	43
	Assurant PA	5	13	34	15	22	12	640	47
	PA	3	0	3	0	1	0	40	7
	IW	0	0	4	0	1	0	20	0
Sub-Total		29	50	100	62	79	44	3,253	222

Recall Rate by Payment Type

Recall Rate : Count of completed SOs that were created 90 days or less from the completion date of another SO with the same unit, customer ID, and item ID divided by the count of completes.

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	10.3%	13.8%	8.8%	14.2%	28.7%	3.9%	7.8%	8.4%
Assurant PA	19.0%	25.9%	11.8%	20.8%	25.9%	15.6%	12.6%	12.7%
B2B	8.3%	9.6%	6.7%	8.5%	10.9%	4.1%	6.1%	6.3%
D2C	7.7%	6.9%	4.6%	4.1%	6.9%	0.0%	6.1%	7.5%
IW	0.0%	100.0%	29.4%	37.5%	100.0%	0.0%	17.9%	0.0%
PA	0.0%		22.2%	0.0%	0.0%	0.0%	18.1%	12.5%

Recall Volume by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	9	15	12	13	18	7	496	37
Assurant PA	4	7	5	6	9	5	180	15
B2B	3	5	4	4	6	2	197	13
D2C	2	2	1	1	2	0	99	8
IW	0	1	1	0	1	0	7	0
PA	0	0	0	0	0	0	13	1

Reschedules Volume by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	45	65	50	52	74	37	5,147	269
B2B	20	30	24	25	30	23	2,881	136
Assurant PA	17	8	17	10	15	6	987	73
D2C	6	26	7	16	26	8	1,183	55
IW	2	1	2	1	2	0	33	3
PA	0	0	1	0	1	0	63	2

First Time Completes % by Payment Type

1. First Time Complete(FTC) : Count of service orders completed on 1st attempt

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		71.7%	74.5%	72.7%	84.5%	89.9%	72.1%	63.9%	67.5%
PAID	Assurant PA	66.7%	65.4%	75.3%	80.4%	86.7%	65.4%	70.5%	73.2%
	B2B	70.6%	76.6%	66.1%	72.9%	77.6%	67.3%	56.5%	60.5%
	D2C	78.6%	80.6%	82.8%	81.8%	85.3%	77.8%	72.3%	78.6%
UNPAID	IW	100.0%	50.0%	60.0%	87.5%	100.0%	50.0%	55.0%	33.3%
	PA	50.0%		42.9%	100.0%	100.0%	100.0%	48.4%	40.0%

First Time Completes Volume by Payment Type

1. First Time Complete(FTC) : Count of service orders completed on 1st attempt

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		66	79	88	90	106	76	3,973	299
PAID	B2B	24	36	32	36	38	33	1,678	124
	D2C	22	25	24	28	30	25	1,218	77
	Assurant PA	18	17	30	25	35	17	1,011	93
UNPAID	IW	1	1	2	1	2	1	22	1
	PA	1	0	1	0	1	0	44	4

Cancel Rate by Payment Type

Cancel Rate : Count of cancelled SOs divided by the count of creates.

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		18.6%	15.2%	12.7%	16.9%	24.2%	11.1%	19.2%	16.9%
PAID	Assurant PA	7.9%	1.3%	5.6%	3.0%	3.9%	1.3%	5.0%	4.9%
	B2B	9.6%	12.7%	5.7%	10.9%	18.2%	1.6%	14.0%	13.7%
	D2C	43.1%	52.8%	30.3%	59.6%	65.8%	52.8%	35.7%	36.0%
UNPAID	IW	0.0%	0.0%	4.8%	11.1%	33.3%	0.0%	12.0%	0.0%
	PA	0.0%	0.0%	5.6%	0.0%	0.0%	0.0%	7.4%	0.0%

Cancel Volume by Payment Type

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		32	29	22	33	44	21	2,282	115
PAID	D2C	22	19	15	24	31	19	1,398	68
	Assurant PA	5	1	3	2	2	1	126	10
	B2B	5	9	4	7	10	1	742	37
UNPAID	IW	0	0	0	0	1	0	9	0
	PA	0	0	0	0	0	0	7	0

Revenue (B2B)

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
B2B	$6,503	$9,821	$11,259	$11,395	$12,622	$10,128	$572,986	$42,523

Revenue per call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
B2B	$180.63	$188.86	$188.43	$209.00	$238.16	$173.34	$176.96	$206.42

Total Parts,Payroll and Truck Costs (B2B)

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
B2B	$3,496	$5,896	$7,490	$6,968	$7,779	$6,251	$376,958	$25,873

Parts Payroll Truck Cost Per Call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
B2B	$97.10	$113.39	$125.35	$127.79	$141.83	$105.40	$116.42	$125.60

Total D2C revenue by repair type (Please Note, C&M contains the number of C&M units, Not Service Orders)

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
REPAIR_TYPE
Total	$5,503	$7,374	$5,163	$6,322	$7,781	$3,446	$401,593	$26,243
REPAIR	$4,357	$6,299	$4,591	$4,935	$6,204	$2,244	$339,026	$22,036
ESTIMATE DECLINE	$1,145	$1,075	$548	$1,259	$1,450	$1,075	$61,510	$4,207
PM CHECK	$0	$0	$24	$127	$127	$127	$1,056	$0

D2C revenue per call by repair type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
REPAIR_TYPE
Total	$211.63	$254.28	$189.47	$170.60	$207.79	$117.65	$248.51	$247.58
REPAIR	$311.23	$331.55	$213.55	$287.85	$384.51	$149.57	$319.84	$314.80
ESTIMATE DECLINE	$95.44	$107.47	$99.62	$96.64	$111.53	$76.04	$111.63	$116.87
PM CHECK			$95.23	$127.32	$127.32	$127.32	$211.30

Total Parts,Payroll and Truck Costs

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$7,137	$11,107	$12,517	$12,349	$14,559	$10,165	$643,070	$45,864
B2B	$3,496	$5,896	$7,490	$6,968	$7,779	$6,251	$376,958	$25,873
Assurant PA	$1,672	$3,021	$2,899	$3,134	$3,922	$2,461	$137,708	$11,471
D2C	$1,515	$2,157	$1,775	$1,962	$2,427	$1,295	$120,179	$7,322
PA	$408	$0	$129	$136	$136	$136	$6,195	$1,151
IW	$47	$33	$226	$149	$294	$22	$2,030	$47

Parts Payroll Truck Cost Per Call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$82.04	$101.89	$92.04	$104.53	$148.63	$76.30	$100.50	$104.47
B2B	$97.10	$113.39	$125.35	$127.79	$141.83	$105.40	$116.42	$125.60
Assurant PA	$79.62	$111.90	$68.20	$87.56	$97.48	$74.58	$96.03	$97.21
D2C	$58.26	$74.37	$65.13	$64.27	$73.55	$43.16	$74.37	$69.07
PA	$135.98		$57.23	$136.12	$136.12	$136.12	$86.04	$143.87
IW	$47.03	$32.54	$53.09	$106.93	$294.17	$22.24	$52.04	$47.03

Total Profit with parts payroll and truck Costs

As revenue is considered only for B2B and D2C, profit will also be considered only for B2B and D2C

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$6,370	$9,142	$6,620	$8,691	$10,156	$6,198	$405,855	$31,069
D2C	$3,363	$5,218	$2,851	$4,264	$5,050	$2,321	$209,828	$14,419
B2B	$3,007	$3,925	$3,769	$4,427	$5,106	$3,877	$196,027	$16,650

Total Profit with parts payroll and truck Costs Per Call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$102.75	$112.87	$76.09	$111.66	$149.17	$72.66	$83.61	$99.58
D2C	$129.36	$179.92	$104.61	$142.10	$202.00	$77.38	$129.84	$136.02
B2B	$83.53	$75.47	$63.09	$81.21	$96.33	$67.94	$60.54	$80.83

3. Deep Dive

Daily Financials – based on completes on MONDAY, 2023-07-31

Weekly Actuals and Goals Dashboard: This dashboard contains weekly actual, goal, and forecasted completes and weekly by payment type and planning area for the overall 100,000 completes nationally per week

Link: https://prod-useast-a.online.tableau.com/#/site/transformhomeservices/views/SHSMetricsPlanningArea/SHSMetricsGoalwithPlanningArea?:iid=1Profitability

Dashboard (B2B and D2C calls): This dashboard provides a monthly view of Completes, KPIs, Revenue, Cost and Profit by planning area

Link: https://prod-useast-a.online.tableau.com/#/site/transformhomeservices/views/B2BProfitability/SummaryByMonth?:iid=1

Revenue for Completes

Total Revenue by Completes

1. Revenue is recorded only on D2C and B2B Calls. Hence, completes in revenue section is only for B2B and D2C. Completes for all payment methods are shown in Cost section as well as Daily Completes section.

2. D2C revenue below is actual revenue on the completes. B2B revenue is an estimated since B2B claims are only submitted up to 6-7 days after order is completed.

3. Average B2B revenue per call is applied based on revenue on past completed orders with submitted claims for each client – geography -- appliance type combination.

4. D2C revenue includes technician sold Clean and Maintenance.

5. D2C completes volume does not include technician sold C&M service orders as their revenue is already included in the parent repair order.

6. D2C is the actual revenue and B2B is the estimated revenue based on historical claims submitted.

7. Completes across all payment types are shown in later section.

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$12,005	$17,195	$16,422	$17,621	$19,967	$13,744	$974,579	$68,766
B2B	$6,503	$9,821	$11,259	$11,395	$12,622	$10,128	$572,986	$42,523
D2C	$5,503	$7,374	$5,163	$6,226	$7,344	$3,616	$401,593	$26,243

Revenue per call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$193.63	$212.28	$188.76	$207.68	$255.93	$146.94	$200.78	$220.40
B2B	$180.63	$188.86	$188.43	$209.00	$238.16	$173.34	$176.96	$206.42
D2C	$211.63	$254.28	$189.47	$206.37	$273.70	$120.54	$248.51	$247.58

Completes by Payment Type (only B2B and D2C)

Below table shows only D2C and B2B completes since revenue is recorded only on B2B and D2C calls

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	62	81	87	85	94	75	4,854	312
B2B	36	52	60	55	60	50	3,238	206
D2C	26	29	27	30	34	25	1,616	106

Cost(Parts,Payroll,Truck) for Completes

Total Parts,Payroll and Truck Costs

1.Overall costs are based on daily creates which are expected to get completed after cancels.
2.Cost considered are parts, payroll and truck as they are direct costs, and we can accurately attribute them to service orders.
3.Cost is based on prior month IHR financial data which is applied to daily completes based on client – geography – appliance type – repair difficulty level combination.
4.Cost is available for service orders for all payment types

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$7,137	$11,107	$12,517	$12,349	$14,559	$10,165	$643,070	$45,864
B2B	$3,496	$5,896	$7,490	$6,968	$7,779	$6,251	$376,958	$25,873
Assurant PA	$1,672	$3,021	$2,899	$3,134	$3,922	$2,461	$137,708	$11,471
D2C	$1,515	$2,157	$1,775	$1,962	$2,427	$1,295	$120,179	$7,322
PA	$408	$0	$129	$136	$136	$136	$6,195	$1,151
IW	$47	$33	$226	$149	$294	$22	$2,030	$47

Parts Payroll Truck Cost Per Call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$82.04	$101.89	$92.04	$104.53	$148.63	$76.30	$100.50	$104.47
B2B	$97.10	$113.39	$125.35	$127.79	$141.83	$105.40	$116.42	$125.60
Assurant PA	$79.62	$111.90	$68.20	$87.56	$97.48	$74.58	$96.03	$97.21
D2C	$58.26	$74.37	$65.13	$64.27	$73.55	$43.16	$74.37	$69.07
PA	$135.98		$57.23	$136.12	$136.12	$136.12	$86.04	$143.87
IW	$47.03	$32.54	$53.09	$106.93	$294.17	$22.24	$52.04	$47.03

Completes by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	87	109	136	124	142	110	6,399	439
B2B	36	52	60	55	60	50	3,238	206
D2C	26	29	27	30	34	25	1,616	106
Assurant PA	21	27	42	36	44	33	1,434	118
PA	3	0	2	1	1	1	72	8
IW	1	1	4	2	3	1	39	1

Profit w parts payroll truck for completes

Total Profit with parts payroll and truck Costs

As revenue is considered only for B2B and D2C, profit will also be considered only for B2B and D2C

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$6,370	$9,142	$6,620	$8,691	$10,156	$6,198	$405,855	$31,069
D2C	$3,363	$5,218	$2,851	$4,264	$5,050	$2,321	$209,828	$14,419
B2B	$3,007	$3,925	$3,769	$4,427	$5,106	$3,877	$196,027	$16,650

Total Profit with parts payroll and truck Costs Per Call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$102.75	$112.87	$76.09	$111.66	$149.17	$72.66	$83.61	$99.58
D2C	$129.36	$179.92	$104.61	$142.10	$202.00	$77.38	$129.84	$136.02
B2B	$83.53	$75.47	$63.09	$81.21	$96.33	$67.94	$60.54	$80.83

Completes by Payment Type (only B2B and D2C)

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	62	81	87	85	94	75	4,854	312
D2C	26	29	27	30	34	25	1,616	106
B2B	36	52	60	55	60	50	3,238	206

Revenue for B2B completes by client

Total B2B revenue by client

1.We are looking at top 11 clients based on their national value and representing their corresponding performance in Maimi.
2.These are estimated revenue based on claims to be submitted (typically take 6-7 days to be submitted by client)

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$6,503	$9,821	$11,259	$11,734	$15,865	$8,450	$572,986	$42,523
Sears Home Warranty Plus	$4,099	$5,051	$8,848	$7,150	$8,469	$5,922	$156,447	$17,218
Choice Home Warranty	$1,786	$1,815	$1,515	$1,915	$2,598	$1,467	$91,918	$6,958
American Home Shield	$338	$2,018	$657	$940	$1,850	$260	$79,510	$5,183
First American Home Buyers	$280	$262	$114	$396	$723	$231	$24,535	$2,137
Assurant	$0	$0	$45	$653	$1,239	$220	$66,723	$2,213
Other B2B Clients	$0	$529	$54	$446	$752	$115	$62,215	$4,757
AIG		$145	$0	$145	$145	$145	$1,508
Asurion			$0				$10,921	$2,758
EMA/Electrolux							$10,961
GE (General Electric)			$0	$89	$89	$89	$26,756	$838
LG			$0				$36,532	$462
Samsung		$0	$26				$4,958	$0

B2B revenue per call by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$180.63	$188.86	$188.43	$167.15	$226.16	$123.95	$176.96	$206.42
Sears Home Warranty Plus	$195.17	$210.46	$218.47	$236.32	$256.63	$205.23	$211.99	$235.86
Choice Home Warranty	$198.48	$121.01	$202.03	$161.08	$236.15	$125.36	$159.86	$173.94
American Home Shield	$84.41	$252.30	$154.63	$203.01	$330.73	$86.63	$165.30	$172.76
First American Home Buyers	$140.00	$261.74	$151.44	$197.86	$361.44	$115.50	$146.91	$178.12
Assurant			$180.16	$147.05	$206.54	$109.92	$177.46	$170.22
Other B2B Clients		$176.45	$53.70	$157.88	$183.81	$115.00	$144.69	$206.83
AIG		$145.00	$0.00	$145.00	$145.00	$145.00	$65.58
Asurion							$198.56	$275.82
EMA/Electrolux							$168.64
GE (General Electric)				$89.00	$89.00	$89.00	$170.42	$209.42
LG			$0.00				$251.95	$461.92
Samsung			$104.03				$190.70

Total B2B Completes by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	36	52	60	57	70	45	3,238	206
Sears Home Warranty Plus	21	24	40	30	33	25	738	73
Choice Home Warranty	9	15	8	12	14	11	575	40
American Home Shield	4	8	4	4	8	2	481	30
First American Home Buyers	2	1	1	2	2	2	167	12
Assurant	0	0	0	4	6	2	376	13
Other B2B Clients	0	3	1	3	5	1	430	23
AIG		1	4	1	1	1	23
Asurion			0				55	10
EMA/Electrolux							65
GE (General Electric)			0	1	1	1	157	4
LG			1				145	1
Samsung		0	0				26	0

Parts Payroll Truck Costs for Completes by Client

Total B2B parts truck payroll Costs by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$3,496	$5,896	$7,490	$7,158	$9,991	$4,835	$376,958	$25,873
Sears Home Warranty Plus	$2,065	$2,828	$5,899	$4,187	$4,837	$3,302	$101,037	$10,291
Choice Home Warranty	$1,073	$1,089	$988	$1,181	$1,487	$958	$57,779	$3,989
American Home Shield	$204	$1,599	$483	$745	$1,650	$168	$54,986	$3,621
First American Home Buyers	$154	$168	$52	$206	$458	$75	$15,128	$1,044
Assurant	$0	$0	$26	$623	$1,214	$227	$43,266	$1,650
Other B2B Clients	$0	$174	$34	$170	$300	$60	$41,319	$2,802
AIG		$38	$0	$38	$38	$38	$967
Asurion			$0				$7,372	$1,740
EMA/Electrolux							$8,297
GE (General Electric)			$0	$8	$8	$8	$16,527	$393
LG			$0				$25,873	$344
Samsung		$0	$9				$4,407	$0

B2B parts truck payroll Costs per call by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$97.10	$113.39	$125.35	$92.61	$132.95	$64.06	$116.42	$125.60
Sears Home Warranty Plus	$98.33	$117.83	$145.65	$138.06	$146.62	$126.99	$136.91	$140.97
Choice Home Warranty	$119.19	$72.62	$131.75	$99.25	$135.14	$79.82	$100.48	$99.72
American Home Shield	$51.00	$199.90	$113.67	$151.60	$237.11	$55.94	$114.32	$120.68
First American Home Buyers	$77.01	$167.60	$68.70	$103.11	$229.00	$37.50	$90.59	$86.99
Assurant			$102.66	$140.83	$202.35	$106.80	$115.07	$126.89
Other B2B Clients		$58.16	$33.59	$62.51	$67.82	$59.90	$96.09	$121.82
AIG		$37.54	$0.00	$37.54	$37.54	$37.54	$42.05
Asurion							$134.04	$173.99
EMA/Electrolux							$127.65
GE (General Electric)				$8.00	$8.00	$8.00	$105.27	$98.30
LG			$0.00				$178.44	$344.15
Samsung			$34.81				$169.49

Total B2B Completes by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	36	52	60	57	70	45	3,238	206
Sears Home Warranty Plus	21	24	40	30	33	25	738	73
Choice Home Warranty	9	15	8	12	14	11	575	40
American Home Shield	4	8	4	4	8	2	481	30
First American Home Buyers	2	1	1	2	2	2	167	12
Assurant	0	0	0	4	6	2	376	13
Other B2B Clients	0	3	1	3	5	1	430	23
AIG		1	4	1	1	1	23
Asurion			0				55	10
EMA/Electrolux							65
GE (General Electric)			0	1	1	1	157	4
LG			1				145	1
Samsung		0	0				26	0

Profit with parts truck payroll Costs for completes by client

Total profit w parts truck payroll Costs by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$3,007	$3,925	$3,769	$4,576	$6,095	$3,467	$196,027	$16,650
Sears Home Warranty Plus	$2,034	$2,223	$2,949	$2,964	$3,632	$2,504	$55,410	$6,927
Choice Home Warranty	$714	$726	$527	$734	$1,111	$479	$34,140	$2,969
American Home Shield	$134	$419	$174	$195	$374	$92	$24,524	$1,562
First American Home Buyers	$126	$94	$62	$190	$265	$156	$9,407	$1,094
Assurant	$0	$0	$19	$30	$72	$-7	$23,458	$563
Other B2B Clients	$0	$355	$20	$275	$452	$55	$20,896	$1,955
AIG		$107	$0	$107	$107	$107	$541
Asurion			$0				$3,549	$1,018
EMA/Electrolux							$2,664
GE (General Electric)			$0	$81	$81	$81	$10,228	$445
LG			$0				$10,659	$118
Samsung		$0	$17				$552	$0

Profit w parts truck payroll Costs per call by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$83.53	$75.47	$63.09	$74.54	$95.67	$58.06	$60.54	$80.83
Sears Home Warranty Plus	$96.85	$92.62	$72.82	$98.26	$110.07	$78.25	$75.08	$94.89
Choice Home Warranty	$79.29	$48.40	$70.28	$61.83	$101.01	$43.56	$59.37	$74.22
American Home Shield	$33.41	$52.40	$40.96	$51.41	$93.62	$24.99	$50.99	$52.07
First American Home Buyers	$62.99	$94.14	$82.74	$94.75	$132.44	$78.00	$56.33	$91.14
Assurant			$77.50	$6.23	$17.90	$-3.41	$62.39	$43.33
Other B2B Clients		$118.28	$20.10	$95.37	$121.83	$54.65	$48.60	$85.01
AIG		$107.46	$0.00	$107.46	$107.46	$107.46	$23.53
Asurion							$64.52	$101.83
EMA/Electrolux							$40.99
GE (General Electric)				$81.00	$81.00	$81.00	$65.15	$111.13
LG			$0.00				$73.51	$117.76
Samsung			$69.22				$21.21

Total B2B Completes by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	36	52	60	57	70	45	3,238	206
Sears Home Warranty Plus	21	24	40	30	33	25	738	73
Choice Home Warranty	9	15	8	12	14	11	575	40
American Home Shield	4	8	4	4	8	2	481	30
First American Home Buyers	2	1	1	2	2	2	167	12
Assurant	0	0	0	4	6	2	376	13
Other B2B Clients	0	3	1	3	5	1	430	23
AIG		1	4	1	1	1	23
Asurion			0				55	10
EMA/Electrolux							65
GE (General Electric)			0	1	1	1	157	4
LG			1				145	1
Samsung		0	0				26	0

D2C Revenue for Completes by Repair Type

Total D2C revenue by repair type (Please Note, C&M contains the number of C&M units, Not Service Orders)

1.D2C Repair: Completed repair call where the customer accepts the estimates and move ahead with the repair.
2.D2C Estimated Decline: Customer declines the estimated repair cost quoted by the technician.
3.D2C Clean and Maintain: Clean and Maintain job sold by the technician while at the customer house.
4.Home Warranty Initial (HW init): Customers are given a initial discount by the technician while visiting their home for the first time to get them enrolled into Sears Home Warranty Program.
5.D2C PM-Check: Standalone Clean and Maintain purchases by the customer from the website.

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
REPAIR_TYPE
Total	$5,503	$7,374	$5,163	$6,322	$7,781	$3,446	$401,593	$26,243
REPAIR	$4,357	$6,299	$4,591	$4,935	$6,204	$2,244	$339,026	$22,036
ESTIMATE DECLINE	$1,145	$1,075	$548	$1,259	$1,450	$1,075	$61,510	$4,207
PM CHECK	$0	$0	$24	$127	$127	$127	$1,056	$0

D2C revenue per call by repair type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
REPAIR_TYPE
Total	$211.63	$254.28	$189.47	$170.60	$207.79	$117.65	$248.51	$247.58
REPAIR	$311.23	$331.55	$213.55	$287.85	$384.51	$149.57	$319.84	$314.80
ESTIMATE DECLINE	$95.44	$107.47	$99.62	$96.64	$111.53	$76.04	$111.63	$116.87
PM CHECK			$95.23	$127.32	$127.32	$127.32	$211.30

Total D2C Completes by repair type (Please Note, C&M contains the number of C&M units, Not Service Orders)

1.D2C completes volume does not include technician sold C&M service orders as their revenue is already included in the parent repair order

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
REPAIR_TYPE
Total	26	29	27	31	35	26	1,616	106
REPAIR	14	19	22	17	19	15	1,060	70
ESTIMATE DECLINE	12	10	6	13	15	10	551	36
PM CHECK	0	0	0	1	1	1	5	0

C&M Units Sold by Technicians

1.C&M revenue displayed in the table below is already recorded in the overall D2C repair revenue

	1. MONDAY	8. Last Week MONDAY	Last 4 Weeks MONDAY Avg	Last Year 4 Weeks MONDAY Avg	National Total	District Total
C&M Revenue (Tech sold C&Ms) (in $)	200	480	460	538	23,270	1,360
C&M Units sold by Techs	4	10	10	12	489	26

Total D2C revenue by Appliance Type

Includes Estimate Declines

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	$5,503	$7,374	$5,163	$6,738	$10,678	$3,761	$401,593	$26,243
REFRIGERATOR	$1,946	$1,142	$2,213	$1,573	$3,076	$824	$145,069	$8,886
OTHER	$1,023	$1,724	$688	$1,242	$1,724	$759	$46,211	$4,454
OVEN	$929	$0	$149	$581	$753	$358	$23,579	$1,233
DRYERS	$895	$218	$626	$461	$1,035	$95	$54,798	$3,760
WASHER	$601	$2,571	$1,030	$1,810	$2,482	$1,127	$96,145	$6,666
DISHWASHER	$110	$1,231	$404	$582	$1,120	$109	$26,685	$1,146
COOKTOP	$0	$0	$54				$1,659	$99
FREEZER		$489	$0	$489	$489	$489	$7,447	$0

D2C revenue per call by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	$211.63	$254.28	$189.47	$277.07	$396.87	$181.00	$248.51	$247.58
REFRIGERATOR	$216.26	$142.70	$201.20	$145.49	$205.04	$82.42	$280.60	$253.88
OTHER	$255.63	$574.56	$550.69	$376.85	$574.56	$189.73	$243.21	$278.36
OVEN	$309.63		$297.25	$395.32	$630.33	$179.00	$280.70	$246.63
DRYERS	$223.64	$109.10	$208.59	$178.43	$344.87	$95.23	$233.18	$208.86
WASHER	$120.15	$285.62	$137.29	$192.54	$310.19	$122.56	$232.80	$266.63
DISHWASHER	$109.50	$205.18	$107.69	$161.79	$224.04	$108.99	$187.92	$191.05
COOKTOP			$214.33				$207.43	$99.00
FREEZER		$489.08		$489.08	$489.08	$489.08	$275.80

Total D2C Completes by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	26	29	27	32	43	22	1,616	106
REFRIGERATOR	9	8	11	10	15	7	517	35
OTHER	4	3	1	4	4	3	190	16
OVEN	3	0	0	2	2	1	84	5
DRYERS	4	2	3	2	4	1	235	18
WASHER	5	9	8	10	12	8	413	25
DISHWASHER	1	6	4	3	5	1	142	6
COOKTOP	0	0	0				8	1
FREEZER		1	0	1	1	1	27	0

Daily Financials – based on creates on MONDAY, 2023-07-31 expected to be completed after cancels

Revenue for Financial Creates

1. Revenue is realized on completed orders. Using current cancel rates, expected completes are estimated from daily creates.

2. Average revenue per call is applied based on revenue on past completed orders for each client – geography -- appliance type combination

Actual Creates

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	103	107	116	107	134	87	9,206	460
B2B	52	71	65	67	80	55	5,288	271
D2C	51	36	50	40	54	32	3,918	189

Total Revenue

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$16,894.7	$17,375.8	$18,466.2	$6,617.0	$9,403.6	$4,643.1	$1,403,967.3	$74,305.1
B2B	$10,123.9	$12,682.8	$12,078.9	$4,723.5	$6,592.4	$3,264.0	$906,223.6	$50,644.3
D2C	$6,770.8	$4,693.0	$6,387.2	$1,893.5	$2,811.2	$1,379.1	$497,743.6	$23,660.7

Revenue per call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$202.03	$194.99	$189.70	$196.72	$215.41	$181.24	$196.82	$200.57
B2B	$213.14	$200.04	$199.67	$214.88	$227.98	$200.13	$202.54	$214.52
D2C	$187.42	$182.53	$173.34	$178.56	$202.83	$162.34	$187.19	$176.07

Creates Expected To Get Completed (after cancels) - By Payment Type (only B2B and D2C)

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	84	89	97	33	46	24	7,133	370
B2B	47	63	60	22	30	16	4,474	236
D2C	36	26	37	11	16	8	2,659	134

Cost (Parts, Truck , Payroll Costs) for Creates

1. Costs is realized on completed orders. Using current cancel rates, expected completes are estimated from daily creates.

2. Average Costs per call is applied based on Costs on past completed orders for each client – geography -- appliance type combination

Total Parts,Payroll and Truck Costs

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$14,772	$16,868	$15,435	$6,413	$9,803	$4,041	$1,022,285	$58,599
Assurant PA	$6,053	$7,003	$4,657	$3,138	$5,167	$1,699	$243,060	$18,877
B2B	$5,726	$7,346	$7,849	$2,567	$3,553	$1,852	$572,940	$29,627
D2C	$2,587	$1,810	$2,483	$708	$1,082	$490	$191,753	$9,024
IW	$213	$270	$160	$0	$0	$0	$5,152	$436
PA	$193	$439	$285	$0	$0	$0	$9,380	$637

Parts Payroll Truck Cost Per Call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$98.64	$99.29	$103.18	$91.53	$95.36	$85.63	$106.63	$101.56
Assurant PA	$100.03	$94.70	$104.14				$105.14	$96.92
B2B	$120.55	$115.86	$129.75	$116.91	$118.26	$113.53	$128.05	$125.50
D2C	$71.61	$70.41	$67.40	$66.14	$72.46	$57.74	$72.11	$67.15
IW	$58.84	$92.83	$33.78				$85.36	$64.43
PA	$96.26	$112.24	$101.87				$115.46	$127.35

Creates Expected To Get Completed (after cancels) by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	150	170	150	65	100	42	9,587	577
Assurant PA	61	74	45	33	55	18	2,312	195
B2B	47	63	60	22	30	16	4,474	236
D2C	36	26	37	11	16	8	2,659	134
IW	4	3	5	0	0	0	60	7
PA	2	4	3	0	0	0	81	5

Profit w parts,truck,payroll for financial creates

Costs are taken across all Payment Types

Total Profit with parts payroll and truck Costs

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$11,875	$12,693	$10,682	$5,650	$8,708	$3,523	$730,844	$46,324
B2B	$4,398	$5,337	$4,230	$2,156	$3,039	$1,412	$333,284	$21,018
D2C	$4,184	$2,883	$3,904	$1,185	$1,729	$889	$305,991	$14,637
Assurant PA	$3,626	$4,948	$2,885	$2,308	$3,940	$1,222	$105,423	$11,546
IW	$-141	$-51	$-57	$0	$0	$0	$-4,532	$-241
PA	$-193	$-422	$-279	$0	$0	$0	$-9,322	$-637

Total Profit with parts payroll and truck Costs Per Call

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	$79.29	$74.72	$71.40	$105.19	$120.04	$95.26	$76.23	$80.28
B2B	$92.60	$84.18	$69.92	$97.97	$109.72	$86.60	$74.49	$89.03
D2C	$115.81	$112.12	$105.95	$112.41	$130.37	$103.92	$115.08	$108.92
Assurant PA	$59.92	$66.90	$64.51				$45.60	$59.28
IW	$-38.92	$-17.71	$-12.12				$-75.07	$-35.57
PA	$-96.26	$-108.02	$-99.66				$-114.75	$-127.35

Creates Expected To Get Completed (after cancels) by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	150	170	150	65	100	42	9,587	577
B2B	47	63	60	22	30	16	4,474	236
D2C	36	26	37	11	16	8	2,659	134
Assurant PA	61	74	45	33	55	18	2,312	195
IW	4	3	5	0	0	0	60	7
PA	2	4	3	0	0	0	81	5

Revenue for B2B creates by client

Total B2B revenue by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$10,124	$12,683	$12,079	$4,767	$7,125	$2,276	$906,224	$50,644
Sears Home Warranty Plus	$7,454	$7,398	$8,339	$3,558	$5,090	$1,981	$259,313	$23,789
Choice Home Warranty	$1,133	$3,464	$1,741	$521	$722	$170	$110,205	$5,302
First American Home Buyers	$856	$467	$0	$65	$259	$0	$69,963	$3,195
American Home Shield	$559	$654	$1,168	$0	$0	$0	$131,198	$6,296
Other B2B Clients	$121	$261	$211	$449	$759	$125	$127,982	$5,267
Assurant	$0	$335	$259	$176	$296	$0	$96,313	$3,959
AIG		$0	$262	$0	$0	$0	$2,736
Asurion			$0				$13,304	$1,498
EMA/Electrolux							$12,999
GE (General Electric)			$73	$0	$0	$0	$32,420	$959
LG			$0				$43,691	$378
Samsung		$104	$26				$6,099	$0

B2B revenue per call by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$213.14	$200.04	$199.67	$211.27	$221.93	$199.17	$202.54	$214.52
Sears Home Warranty Plus	$228.14	$220.00	$207.07	$223.15	$231.05	$210.87	$217.92	$237.86
Choice Home Warranty	$183.03	$180.66	$193.04	$196.82	$199.23	$193.58	$180.65	$190.26
First American Home Buyers	$171.22	$233.70		$258.53	$258.53	$258.53	$193.96	$196.33
American Home Shield	$212.31	$182.54	$188.63				$202.60	$206.92
Other B2B Clients	$121.44	$171.06	$153.31	$183.59	$189.63	$175.58	$192.41	$196.61
Assurant		$134.15	$165.00	$194.25	$231.20	$157.29	$207.52	$187.36
AIG			$209.34				$138.72
Asurion							$226.59	$234.68
EMA/Electrolux							$170.30
GE (General Electric)			$180.63				$192.39	$196.06
LG			$0.00				$251.39	$164.46
Samsung		$104.03	$104.03				$153.62

B2B Creates Expected To Get Completed (after cancels) by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	47	63	60	22	33	11	4,474	236
Sears Home Warranty Plus	33	34	40	16	22	9	1,190	100
Choice Home Warranty	6	19	9	3	4	1	610	28
First American Home Buyers	5	2	0	0	1	0	361	16
American Home Shield	3	4	6	0	0	0	648	30
Other B2B Clients	1	2	1	2	4	1	665	27
Assurant	0	2	2	1	2	0	464	21
AIG		0	1	0	0	0	20
Asurion			0				59	6
EMA/Electrolux							76
GE (General Electric)			0	0	0	0	169	5
LG			0				174	2
Samsung		1	0				40	0

Parts, truck and payroll cost for creates by client

Total B2B parts truck payroll Costs by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$5,726	$7,346	$7,849	$2,602	$3,896	$1,190	$572,940	$29,627
Sears Home Warranty Plus	$4,124	$4,258	$5,454	$1,928	$2,749	$1,029	$166,236	$13,120
Choice Home Warranty	$605	$2,003	$999	$317	$454	$114	$67,064	$3,063
First American Home Buyers	$499	$282	$0	$37	$146	$0	$40,017	$1,749
American Home Shield	$438	$462	$853	$0	$0	$0	$85,107	$4,055
Other B2B Clients	$60	$105	$100	$179	$306	$47	$77,907	$3,457
Assurant	$0	$195	$170	$141	$240	$0	$62,085	$2,479
AIG		$0	$230	$0	$0	$0	$1,399
Asurion			$0				$8,471	$1,017
EMA/Electrolux							$9,591
GE (General Electric)			$32	$0	$0	$0	$20,814	$485
LG			$0				$29,838	$202
Samsung		$39	$10				$4,410	$0

B2B parts truck payroll Costs per call by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$120.55	$115.86	$129.75	$123.60	$134.55	$111.39	$128.05	$125.50
Sears Home Warranty Plus	$126.21	$126.63	$135.44	$120.72	$130.54	$109.58	$139.70	$131.19
Choice Home Warranty	$97.67	$104.46	$110.85	$122.45	$133.23	$104.57	$109.93	$109.91
First American Home Buyers	$99.87	$141.18		$146.38	$146.38	$146.38	$110.94	$107.47
American Home Shield	$166.30	$129.09	$137.71				$131.42	$133.26
Other B2B Clients	$60.37	$69.02	$72.87	$72.96	$78.94	$69.09	$117.13	$129.03
Assurant		$78.34	$108.44	$155.51	$183.68	$127.34	$133.77	$117.31
AIG			$184.33				$70.91
Asurion							$144.27	$159.31
EMA/Electrolux							$125.64
GE (General Electric)			$78.71				$123.52	$99.21
LG			$0.00				$171.68	$87.66
Samsung		$39.47	$39.47				$111.09

B2B Creates Expected To Get Completed (after cancels) by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	47	63	60	22	33	11	4,474	236
Sears Home Warranty Plus	33	34	40	16	22	9	1,190	100
Choice Home Warranty	6	19	9	3	4	1	610	28
First American Home Buyers	5	2	0	0	1	0	361	16
American Home Shield	3	4	6	0	0	0	648	30
Other B2B Clients	1	2	1	2	4	1	665	27
Assurant	0	2	2	1	2	0	464	21
AIG		0	1	0	0	0	20
Asurion			0				59	6
EMA/Electrolux							76
GE (General Electric)			0	0	0	0	169	5
LG			0				174	2
Samsung		1	0				40	0

Profit with parts truck payroll cost for creates by client

Total profit w parts truck payroll Costs by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$3,007	$3,925	$3,769	$4,576	$6,095	$3,467	$196,027	$16,650
Sears Home Warranty Plus	$2,034	$2,223	$2,949	$2,964	$3,632	$2,504	$55,410	$6,927
Choice Home Warranty	$714	$726	$527	$734	$1,111	$479	$34,140	$2,969
First American Home Buyers	$126	$94	$62	$190	$265	$156	$9,407	$1,094
American Home Shield	$134	$419	$174	$195	$374	$92	$24,524	$1,562
Other B2B Clients	$0	$355	$20	$275	$452	$55	$20,896	$1,955
Assurant	$0	$0	$19	$30	$72	$-7	$23,458	$563
AIG		$107	$0	$107	$107	$107	$541
Asurion			$0				$3,549	$1,018
EMA/Electrolux							$2,664
GE (General Electric)			$0	$81	$81	$81	$10,228	$445
LG			$0				$10,659	$118
Samsung		$0	$17				$552	$0

Profit w parts truck payroll Costs per call by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	$63.31	$61.90	$62.31				$43.81	$70.53
Sears Home Warranty Plus	$62.25	$66.10	$73.24	$201.67	$266.55	$138.98	$46.56	$69.26
Choice Home Warranty	$115.23	$37.86	$58.46	$356.35	$641.09	$129.68	$55.96	$106.54
First American Home Buyers	$25.20	$47.07	$inf		$inf	$264.89	$26.08	$67.20
American Home Shield	$50.78	$117.09	$28.11		$inf	$inf	$37.87	$51.34
Other B2B Clients	$0.00	$232.87	$14.58	$181.39	$343.66	$15.94	$31.42	$72.99
Assurant		$0.00	$12.34	$inf	$inf	$-6.82	$50.54	$26.66
AIG		$inf	$0.00	$inf	$inf	$inf	$27.43
Asurion							$60.44	$159.50
EMA/Electrolux							$34.91
GE (General Electric)			$0.00	$inf	$inf	$inf	$60.70	$90.84
LG			$0.00				$61.33	$51.19
Samsung		$0.00	$69.22				$13.89

B2B Creates Expected To Get Completed (after cancels) by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	47	63	60	22	33	11	4,474	236
Sears Home Warranty Plus	33	34	40	16	22	9	1,190	100
Choice Home Warranty	6	19	9	3	4	1	610	28
First American Home Buyers	5	2	0	0	1	0	361	16
American Home Shield	3	4	6	0	0	0	648	30
Other B2B Clients	1	2	1	2	4	1	665	27
Assurant	0	2	2	1	2	0	464	21
AIG		0	1	0	0	0	20
Asurion			0				59	6
EMA/Electrolux							76
GE (General Electric)			0	0	0	0	169	5
LG			0				174	2
Samsung		1	0				40	0

Daily Service Not Set - based on opportunities for Creates on MONDAY, 2023-07-31

Service Not Set

		MONDAY	Last 4 Weeks Same Day Avg	Last Week Same Day	Last Year 4 Weeks Avg	Last Year Same Day	Last 4 Weeks Max	Last 4 Weeks Min
CHANNEL	SNS
PHONE	PRICE_SNS_CNT	3	2	1	2	3	3	1
	DATE_SNS_CNT	3	2	2	5	6	3	0
	OTHER_SNS	4	4	2	3	2	5	2

Total Creates

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min
D2C Creates	51	36	50	40	54	32

Daily Creates – Creates on MONDAY, 2023-07-31

Weekly Actuals and Goals Dashboard: This dashboard contains weekly actual, goal and forecasted completes and weekly by payment type and planning area for the overall 100,000 completes nationally per week

Link: https://prod-useast-a.online.tableau.com/#/site/transformhomeservices/views/SHSMetricsPlanningArea/SHSMetricsGoalwithPlanningArea?:iid=1Profitability

Creates by Payment Type

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		172	191	175	172	218	138	11,896	680
PAID	Assurant PA	63	77	50	62	77	51	2,521	206
	B2B	52	71	65	67	80	55	5,288	271
	D2C	51	36	50	40	54	32	3,918	189
UNPAID	IW	4	3	5	2	3	0	75	9
	PA	2	4	4	2	4	0	94	5

Creates by Appliance

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	172	191	175	172	214	145	11,896	680
OTHER	57	66	14	46	66	38	1,850	180
REFRIGERATOR	47	50	59	44	50	40	3,919	194
WASHER	34	34	41	36	41	32	2,729	134
DRYERS	19	21	27	24	28	21	1,575	70
DISHWASHER	9	8	16	10	12	8	1,065	62
COOKTOP	3	5	4	2	5	1	180	11
FREEZER	2	2	1	1	2	0	130	10
OVEN	1	5	13	8	10	5	448	19

Creates by Brand

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
MFG_BND_NM
Total	172	191	175	172	211	120	11,896	680
KENMORE	71	70	71	62	70	45	3,400	204
OTHER BRANDS	62	60	40	50	60	39	3,175	221
SAMSUNG	13	13	12	12	19	4	1,197	60
WHIRLPOOL	11	15	18	13	16	6	1,087	50
GE	7	16	16	16	19	14	1,420	72
LG	6	8	14	12	18	8	1,040	52
FRIGIDAIRE	2	9	5	7	9	4	577	21

Creates by B2B Client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	52	71	65	70	95	45	5,288	271
Sears Home Warranty Plus	35	36	42	35	45	26	1,314	109
Choice Home Warranty	8	23	10	15	23	9	765	37
First American Home Buyers	5	2	0	2	3	1	417	17
American Home Shield	3	4	7	4	7	1	743	33
Other B2B Clients	1	2	2	6	7	2	837	34
Assurant	0	3	2	5	6	3	532	24
AIG		0	1	0	0	0	27
Asurion			0	1	1	1	70	7
EMA/Electrolux							90
GE (General Electric)			1	0	1	0	227	6
LG			0	1	1	1	213	3
Samsung		1	0	1	1	1	53	1

B2B Creates by Appliance

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	52	71	65	67	88	50	5,288	271
OTHER	28	21	4	16	21	11	888	82
REFRIGERATOR	11	20	22	20	25	16	1,791	71
WASHER	7	12	14	13	15	10	1,094	53
DISHWASHER	3	2	6	3	4	2	560	31
DRYERS	2	8	11	10	14	8	576	16
COOKTOP	1	4	2	2	4	1	140	9
OVEN	0	4	6	4	5	2	223	8
FREEZER		0	0	0	0	0	16	1

B2B Creates by Brand

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
MFG_BND_NM
Total	52	71	65	67	92	46	5,288	271
OTHER BRANDS	35	23	17	21	29	15	1,421	110
KENMORE	7	15	18	15	18	11	697	30
SAMSUNG	6	7	6	6	10	2	693	33
GE	2	9	8	10	12	8	914	46
WHIRLPOOL	2	7	10	6	8	4	580	13
FRIGIDAIRE	0	6	2	4	6	2	375	10
LG	0	4	6	6	9	4	608	29

Creates by Appliance for Top B2B Client - Sears Home Warranty Plus

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	35	36	42	35	51	17	1,314	109
OTHER	20	14	2	12	15	6	333	54
REFRIGERATOR	6	10	13	9	15	3	366	18
WASHER	5	6	9	5	6	4	225	14
DISHWASHER	2	0	5	1	3	0	129	13
COOKTOP	1		1	0	0	0	11	2
DRYERS	1	3	6	5	7	3	165	4
OVEN	0	3	6	3	5	1	84	4
FREEZER							1

D2C (incl. HW Init) Creates by Appliance

Home Warranty Initial (HW init): Customers are given a initial discount by the technician while visiting their home for the first time to get them enrolled into Sears Home Warranty Program.

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	51	36	50	40	58	24	3,918	189
OTHER	11	8	4	6	8	4	498	28
REFRIGERATOR	18	10	16	10	13	4	1,296	69
WASHER	12	10	13	13	19	10	948	41
DISHWASHER	1	3	6	3	3	2	320	18
COOKTOP	0	1	1	0	1	0	23	0
DRYERS	9	4	8	7	10	4	656	29
OVEN	0	0	2	2	4	0	142	3
FREEZER		0	0	0	0	0	35	1

D2C (incl. HW Init) Creates by Brand

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
MFG_BND_NM
Total	51	36	50	40	62	22	3,918	189
KENMORE	24	13	20	16	21	12	1,265	70
OTHER BRANDS	12	10	12	10	16	5	1,156	49
WHIRLPOOL	5	3	6	3	6	1	346	25
GE	3	5	4	4	6	1	367	14
LG	3	1	4	3	7	1	292	13
SAMSUNG	3	3	2	2	3	1	375	17
FRIGIDAIRE	1	1	2	2	3	1	117	1

Daily Completes – Completes on MONDAY, 2023-07-31

Completes by Payment Type

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		87	109	136	117	131	106	6,399	439
PAID	B2B	36	52	60	52	55	49	3,238	206
	D2C	26	29	27	32	34	29	1,616	106
	Assurant PA	21	27	42	31	39	27	1,434	118
UNPAID	PA	3	0	2	0	1	0	72	8
	IW	1	1	4	2	2	1	39	1

Completes by Appliance

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	87	109	136	117	146	84	6,399	439
OTHER	24	32	13	30	32	23	1,090	120
REFRIGERATOR	24	22	48	35	44	22	2,002	131
WASHER	15	21	33	22	25	20	1,432	80
DRYERS	11	9	16	12	14	9	761	51
DISHWASHER	9	17	13	10	17	5	617	36
OVEN	4	4	8	6	8	4	275	16
COOKTOP	0	2	3	2	4	1	137	3
FREEZER	0	2	1	1	2	0	85	2

Completes by Brand

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
MFG_BND_NM
Total	87	109	136	117	141	89	6,399	439
KENMORE	33	31	52	39	42	31	1,757	131
OTHER BRANDS	23	32	30	36	42	32	1,670	121
GE	10	9	14	10	16	6	853	63
WHIRLPOOL	8	12	14	9	12	5	525	38
SAMSUNG	7	9	10	9	13	5	603	36
LG	5	9	10	8	9	6	631	36
FRIGIDAIRE	1	7	6	5	7	4	360	14

Completes by B2B Client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	36	52	60	53	67	39	3,238	206
Sears Home Warranty Plus	21	24	40	28	32	24	738	73
Choice Home Warranty	9	15	8	13	15	11	575	40
American Home Shield	4	8	4	4	8	2	481	30
First American Home Buyers	2	1	1	1	2	0	167	12
Assurant	0	0	0	3	5	0	376	13
Other B2B Clients	0	3	1	3	4	1	430	23
AIG		1	4	1	1	1	23
Asurion			0	0	0	0	55	10
EMA/Electrolux							65
GE (General Electric)			0	0	0	0	157	4
LG			1	0	0	0	145	1
Samsung		0	0	0	0	0	26	0

Parts Used in B2B Completes

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE	PARTS
B2B	No Parts Installed	22	32	23	26	32	22	1,384	90
	Parts Installed	14	20	37	26	33	20	1,854	116

B2B Completes by Appliance

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	62	81	87	84	111	58	4,854	312
OTHER	18	20	8	17	20	15	776	73
REFRIGERATOR	15	17	33	25	31	17	1,554	91
WASHER	12	16	18	18	21	16	1,080	64
DISHWASHER	7	17	10	8	17	2	515	28
DRYERS	7	5	10	8	9	5	554	40
OVEN	3	2	5	5	7	2	209	13
COOKTOP	0	2	2	2	4	1	127	3
FREEZER		2	0	1	2	0	39	0

B2B Completes by Brand

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
MFG_BND_NM
Total	62	81	87	84	106	59	4,854	312
KENMORE	17	16	28	23	27	16	941	65
OTHER BRANDS	17	28	20	25	28	23	1,287	82
GE	10	8	10	9	14	5	754	54
SAMSUNG	7	8	8	8	12	3	540	33
WHIRLPOOL	7	11	11	8	11	5	455	33
LG	3	4	7	5	8	3	563	34
FRIGIDAIRE	1	6	4	4	6	4	314	11

Completes by Appliance for Top B2B Client - Sears Home Warranty Plus

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	21	24	40	29	42	15	738	73
OTHER	9	15	5	11	15	7	209	25
DISHWASHER	4	2	4	1	3	0	76	10
WASHER	4	1	8	4	6	1	141	12
REFRIGERATOR	3	4	14	6	10	4	203	17
DRYERS	1	1	4	3	4	1	69	4
COOKTOP	0		0	1	1	1	7	1
OVEN	0	1	4	2	3	1	33	4
FREEZER							0

Parts Used in D2C Completes

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE	PARTS
D2C	No Parts Installed	20	20	20	24	28	20	1,052	63
	Parts Installed	6	9	7	8	11	2	564	43

D2C (incl. HW Init) Completes by Appliance

Home Warranty Initial (HW init): Customers are given a initial discount by the technician while visiting their home for the first time to get them enrolled into Sears Home Warranty Program.

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	26	29	27	32	44	22	1,616	106
REFRIGERATOR	9	8	11	10	15	8	517	35
WASHER	5	9	8	10	12	8	413	25
DRYERS	4	2	3	2	4	1	235	18
OTHER	4	3	1	3	4	3	190	16
OVEN	3	0	0	1	2	0	84	5
DISHWASHER	1	6	4	4	6	2	142	6
COOKTOP	0	0	0	0	0	0	8	1
FREEZER		1	0	0	1	0	27	0

D2C (incl. HW Init) Completes by Brand

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
MFG_BND_NM
Total	26	29	27	32	45	20	1,616	106
KENMORE	11	11	10	13	16	11	525	36
SAMSUNG	5	2	2	2	3	1	147	10
WHIRLPOOL	5	5	3	4	5	3	138	11
GE	3	1	2	2	3	1	157	16
FRIGIDAIRE	1	3	1	2	3	1	53	5
LG	1	1	2	2	5	1	144	10
OTHER BRANDS	0	6	7	7	10	2	452	18

First Time Completes (FTC) - Completes on MONDAY, 2023-07-31 done on first attempt

First Time Completes % by Payment Type

1. First Time Complete(FTC) : Count of service orders completed on 1st attempt

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		71.74%	74.53%	72.67%	84.51%	89.90%	72.09%	63.88%	67.49%
PAID	B2B	70.59%	76.60%	66.15%	72.92%	77.55%	67.31%	56.50%	60.49%
	D2C	78.57%	80.65%	82.76%	81.76%	85.29%	77.78%	72.33%	78.57%
	Assurant PA	66.67%	65.38%	75.32%	80.35%	86.67%	65.38%	70.50%	73.23%
UNPAID	IW	100.00%	50.00%	60.00%	87.50%	100.00%	50.00%	55.00%	33.33%
	PA	50.00%		42.86%	100.00%	100.00%	100.00%	48.35%	40.00%

First Time Completes Volume by Payment Type

1. First Time Complete(FTC) : Count of service orders completed on 1st attempt

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		66	79	88	90	106	76	3,973	299
PAID	B2B	24	36	32	36	38	33	1,678	124
	D2C	22	25	24	28	30	25	1,218	77
	Assurant PA	18	17	30	25	35	17	1,011	93
UNPAID	IW	1	1	2	1	2	1	22	1
	PA	1	0	1	0	1	0	44	4

First Time Completes % by Appliance

1.First Time Completes % per Repair: Measurement of how many attempts to drive a completed service order

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	71.74%	74.53%	72.67%	73.83%	87.93%	62.08%	63.88%	67.49%
REFRIGERATOR	76.00%	70.00%	73.33%	78.43%	85.00%	70.00%	59.43%	68.50%
OTHER	80.95%	71.79%	75.00%	78.26%	87.50%	66.67%	72.75%	80.67%
DRYERS	90.91%	100.00%	79.10%	88.01%	100.00%	78.57%	71.39%	75.93%
WASHER	52.94%	71.43%	68.64%	76.71%	80.95%	71.43%	61.55%	51.22%
DISHWASHER	80.00%	84.62%	71.70%	78.86%	87.50%	60.00%	62.32%	60.00%
OVEN	37.50%	60.00%	66.67%	57.01%	62.50%	50.00%	56.38%	45.45%
COOKTOP			77.78%	33.33%	100.00%	0.00%	47.29%	33.33%
FREEZER		100.00%	75.00%	100.00%	100.00%	100.00%	80.72%	100.00%

First Time Completes by Appliance

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	66	79	88	90	113	62	3,973	299
REFRIGERATOR	19	14	30	26	34	14	1,144	87
OTHER	17	28	8	26	28	20	809	96
DRYERS	10	7	13	10	11	7	539	41
WASHER	9	15	20	17	21	14	850	42
DISHWASHER	8	11	10	7	11	5	344	21
OVEN	3	3	4	4	5	2	159	10
COOKTOP	0	0	2	0	2	0	61	1
FREEZER	0	1	1	0	1	0	67	1

FTC % by B2B Client

1. First Time Complete(FTC) : Count of service orders completed on 1st attempt

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
AIG		100.00%	83.33%	100.00%	100.00%	100.00%	70.59%
American Home Shield	66.67%	100.00%	54.55%	67.08%	100.00%	33.33%	53.42%	43.33%
Assurant	0.00%		50.00%	100.00%	100.00%	100.00%	51.28%	61.54%
Asurion							36.11%	66.67%
Choice Home Warranty	85.71%	91.67%	88.24%	86.06%	91.67%	70.00%	59.01%	69.05%
EMA/Electrolux							62.50%
First American Home Buyers	100.00%	50.00%	50.00%	54.17%	100.00%	0.00%	48.43%	58.33%
GE (General Electric)							56.41%	50.00%
LG			60.00%				57.78%	50.00%
Other B2B Clients	0.00%	66.67%	50.00%	91.67%	100.00%	66.67%	62.60%	68.42%
Samsung			100.00%				61.54%
Sears Home Warranty Plus	70.00%	69.23%	63.97%	65.90%	75.86%	48.15%	57.16%	60.81%
Total	70.59%	76.60%	66.15%	80.70%	95.36%	59.74%	56.50%	60.49%

FTC Volume by B2B Client

1. First Time Complete(FTC) : Count of service orders completed on 1st attempt

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	24	36	32	36	45	23	1,678	124
Sears Home Warranty Plus	14	18	22	18	22	13	391	45
Choice Home Warranty	6	11	4	10	11	7	344	29
American Home Shield	2	3	2	2	3	1	211	13
First American Home Buyers	2	1	0	1	2	0	77	7
Assurant	0	0	0	2	3	0	180	8
Other B2B Clients	0	2	1	2	3	1	241	13
AIG		1	2	1	1	1	12
Asurion			0	0	0	0	13	6
EMA/Electrolux							35
GE (General Electric)			0	0	0	0	88	2
LG			1	0	0	0	78	1
Samsung		0	0	0	0	0	8	0

FTC% by Appliance for Top B2B Client - Sears Home Warranty Plus

1. First Time Complete(FTC) : Count of service orders completed on 1st attempt

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	70.59%	76.60%	66.15%	67.50%	91.28%	42.59%	56.50%	60.49%
OTHER	90.00%	76.19%	70.00%	78.12%	91.67%	60.00%	71.75%	78.18%
DISHWASHER	75.00%	87.50%	62.50%	44.79%	87.50%	0.00%	50.79%	52.38%
WASHER	50.00%	83.33%	58.06%	75.00%	83.33%	66.67%	52.58%	47.62%
REFRIGERATOR	100.00%	50.00%	69.12%	65.87%	76.47%	50.00%	52.19%	59.26%
DRYERS	66.67%	100.00%	69.23%	87.86%	100.00%	71.43%	62.20%	71.43%
OVEN	0.00%	100.00%	61.11%	70.83%	100.00%	50.00%	46.21%	30.00%
COOKTOP			75.00%	50.00%	100.00%	0.00%	45.19%	0.00%
FREEZER			100.00%				70.00%

FTC Volume by Appliance for top B2B Client - Sears Home Warranty Plus

1. First Time Complete(FTC) : Count of service orders completed on 1st attempt

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	24	36	32	36	53	22	1,678	124
OTHER	9	16	4	12	16	9	419	43
DISHWASHER	6	7	4	2	7	0	161	11
REFRIGERATOR	4	4	12	8	13	4	476	32
WASHER	3	5	4	6	6	5	326	20
DRYERS	2	3	4	4	6	3	181	15
COOKTOP	0	0	1	0	2	0	47	0
OVEN	0	1	3	2	3	1	61	3
FREEZER		0	0	0	0	0	7	0

Trips per Repair (TPR) - Average Tech Trips per repair on all completes

TPR by Payment Type

1.Trips per Repair (TPR): Measurement of how many attempts to drive a completed service order

$ TPR = (attempts / (completes - recall ) ) $

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		1.51	1.50	1.45			1.19	1.56	1.54
PAID	B2B	1.48	1.38	1.43	1.41	1.50	1.37	1.61	1.62
	D2C	1.38	1.37	1.28	1.29	1.37	1.21	1.41	1.32
	Assurant PA	1.82	1.85	1.55	1.55	1.85	1.37	1.57	1.56
UNPAID	PA	1.33		2.00	1.00	1.00	1.00	2.19	2.14
	IW	1.00	inf	1.83	inf	inf	1.00	1.91	3.00

Trips by Payment Type

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAID_FLAG	PAYMENT_TYPE
Total		118	141	180	146	162	135	9,184	621
PAID	B2B	49	65	80	68	72	65	4,891	313
	D2C	33	37	33	39	41	37	2,138	129
	Assurant PA	31	37	58	38	46	32	1,965	161
UNPAID	PA	4	0	4	0	1	0	129	15
	IW	1	2	6	2	2	1	61	3

TPR by Appliance

1.Trips per Repair (TPR): Measurement of how many attempts to drive a completed service order

$ TPR = (attempts / (completes - recall ) ) $

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	1.51	1.50	1.45	1.38	1.63	1.19	1.56	1.54
OTHER	1.30	1.57	1.29	1.46	1.70	1.24	1.41	1.39
REFRIGERATOR	1.60	1.61	1.44	1.43	1.61	1.24	1.67	1.58
WASHER	1.64	1.53	1.52	1.38	1.53	1.24	1.56	1.68
DISHWASHER	1.22	1.36	1.47	1.47	1.83	1.10	1.56	1.56
DRYERS	1.50	1.29	1.34	1.37	1.58	1.18	1.44	1.41
OVEN	2.50	1.75	1.59	1.58	1.75	1.50	1.63	2.07
COOKTOP		1.00	1.67	1.33	2.00	1.00	1.67	2.00
FREEZER		1.00	1.50	1.00	1.00	1.00	1.27	1.00

Trips by Appliance

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	118	141	180	146	182	114	9,184	621
REFRIGERATOR	32	29	63	42	51	29	2,969	185
OTHER	30	44	16	38	44	34	1,467	153
WASHER	23	29	46	28	31	26	2,082	126
DRYERS	12	9	20	14	19	9	1,022	65
DISHWASHER	11	19	17	12	19	8	892	53
OVEN	10	7	12	9	12	6	427	31
COOKTOP	0	2	4	3	4	2	222	6
FREEZER	0	2	2	1	2	0	103	2

TPR by B2B Client

1.Trips per Repair (TPR): Measurement of how many attempts to drive a completed service order

$ TPR = (attempts /( completes - recall ) ) $

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	1.48	1.38	1.43	1.29		1.12	1.61	1.62
Sears Home Warranty Plus	1.38	1.48	1.43	1.46	1.65	1.30	1.58	1.53
Choice Home Warranty	1.25	1.23	1.35	1.41	1.56	1.23	1.64	1.45
American Home Shield	2.50	1.33	1.60	1.81	2.50	1.33	1.66	2.39
First American Home Buyers	1.50	2.00	1.33		inf	1.00	1.78	1.82
Assurant	inf		2.00	1.00	1.00	1.00	1.66	1.80
Other B2B Clients	inf	1.33	1.75	1.08	1.33	1.00	1.48	1.35
AIG		1.00	1.20	1.00	1.00	1.00	1.45
Asurion			inf				1.67	1.40
EMA/Electrolux							1.59
GE (General Electric)							1.59	1.50
LG			1.40				1.60	2.00
Samsung			1.00				1.48

Trips Volume by B2B Client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	49	65	80	68	80	54	4,891	313
Sears Home Warranty Plus	29	34	55	39	43	34	1,118	112
Choice Home Warranty	10	16	9	14	16	13	875	55
American Home Shield	5	8	6	6	8	4	728	55
First American Home Buyers	3	2	1	2	3	1	272	20
Assurant	1	0	0	3	5	0	580	18
Other B2B Clients	1	4	2	3	4	1	613	31
AIG		1	4	1	1	1	32
Asurion			0	0	0	0	90	14
EMA/Electrolux							92
GE (General Electric)			0	0	0	0	240	6
LG			2	0	0	0	217	2
Samsung		0	0	0	0	0	34	0

TPR by Appliance for Top B2B Client

1.Trips per Repair (TPR): Measurement of how many attempts to drive a completed service order

$ TPR = (attempts /( completes - recall ) ) $

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	1.48	1.38	1.43	1.33		1.16	1.61	1.62
OTHER	1.14	1.29	1.35	1.29	1.55	1.15	1.39	1.35
WASHER	1.43	1.29	1.49	1.34	1.50	1.25	1.63	1.68
DISHWASHER	1.33	1.33	1.46		inf	1.25	1.67	1.62
REFRIGERATOR	1.60	2.00	1.39	1.64	2.00	1.44	1.71	1.76
DRYERS	4.00	1.50	1.40	1.52	2.00	1.20	1.55	1.61
OVEN	inf	1.00	1.56	1.30	1.60	1.00	1.72	2.12
COOKTOP		1.00	1.50	1.25	2.00	1.00	1.65	2.50
FREEZER		1.00	1.00	1.00	1.00	1.00	1.25

Trips Volume by Appliance for top B2B Client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	49	65	80	68	92	48	4,891	313
OTHER	16	22	9	17	22	15	798	74
WASHER	10	9	15	11	12	9	1,037	64
DISHWASHER	8	12	9	6	12	2	576	34
REFRIGERATOR	8	14	28	19	23	14	1,605	90
DRYERS	4	3	9	6	10	3	459	29
OVEN	3	2	7	5	8	2	210	17
COOKTOP	0	2	2	3	4	2	191	5
FREEZER		1	0	1	1	1	15	0

TPR by Appliance for D2C Completes

1.Trips per Repair (TPR): Measurement of how many attempts to drive a completed service order

$ TPR = (attempts /( completes - recall ) ) $

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	1.38	1.37	1.28				1.41	1.32
REFRIGERATOR	1.38	1.12	1.17	1.18	1.33	1.10	1.52	1.32
WASHER	1.75	1.38	1.28	1.22	1.38	1.09	1.31	1.35
OTHER	1.50	2.00	1.40	1.65	2.00	1.33	1.45	1.40
DRYERS	1.00	1.00	1.36	1.40	2.00	1.00	1.42	1.22
OVEN	1.33	inf	2.00	inf	inf	1.00	1.33	1.50
DISHWASHER	1.00	1.40	1.36	1.18	1.40	1.00	1.29	1.17
COOKTOP			2.00	inf	inf	inf	1.75	1.00
FREEZER		1.00		1.00	1.00	1.00	1.28

TPR Volume by Appliance for D2C Completes (includes Estimate Declines)

1.Trips per Repair (TPR): Measurement of how many attempts to drive a completed service order

$ TPR = (attempts /( completes - recall ) ) $

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	33	37	33	39	55	26	2,138	129
REFRIGERATOR	11	9	12	12	16	9	706	41
WASHER	7	11	9	12	14	9	519	31
OTHER	6	6	2	5	7	3	263	21
DRYERS	4	2	4	3	5	2	318	22
OVEN	4	1	1	2	4	1	109	6
DISHWASHER	1	7	5	4	7	2	177	7
COOKTOP	0	0	0	0	1	0	14	1
FREEZER		1	0	0	1	0	32	0

Repair Time per Call

Repair Time per Call (in mins) by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	43.68	55.91	65.63	56.86	61.62	51.06	55.72	56.22
B2B	49.83	63.38	69.59	66.43	71.76	59.60	57.40	62.42
D2C	35.15	42.52	56.95	47.30	51.48	42.52	52.37	44.18

Completes by Payment Type (only B2B and D2C)

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	62	81	87	84	89	78	4,854	312
B2B	36	52	60	52	55	49	3,238	206
D2C	26	29	27	32	34	29	1,616	106

B2B Repair Time per Call (in mins) by Client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
AIG		36.00	52.19	36.00	36.00	36.00	45.04
American Home Shield	24.25	41.00	62.53	74.59	135.50	41.00	54.47	65.57
Assurant	inf		63.00	59.37	72.60	35.50	54.06	42.92
Asurion			inf				64.15	86.70
Choice Home Warranty	46.56	47.47	67.77	54.05	74.31	44.50	59.93	59.10
EMA/Electrolux							55.11
First American Home Buyers	87.00	169.00	72.33		inf	49.00	55.84	64.17
GE (General Electric)							52.58	77.75
LG			76.20				56.63	117.00
Other B2B Clients	inf	57.67	103.00	60.69	77.33	32.75	52.54	54.13
Samsung			29.00				49.35
Sears Home Warranty Plus	49.71	78.25	71.02	74.35	83.59	61.91	63.76	63.82
Total	49.83	63.38	69.59	59.84		42.95	57.40	62.42

Total B2B Completes by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	36	52	60	53	67	39	3,238	206
Sears Home Warranty Plus	21	24	40	28	32	24	738	73
Choice Home Warranty	9	15	8	13	15	11	575	40
American Home Shield	4	8	4	4	8	2	481	30
First American Home Buyers	2	1	1	1	2	0	167	12
Assurant	0	0	0	3	5	0	376	13
Other B2B Clients	0	3	1	3	4	1	430	23
AIG		1	4	1	1	1	23
Asurion			0	0	0	0	55	10
EMA/Electrolux							65
GE (General Electric)			0	0	0	0	157	4
LG			1	0	0	0	145	1
Samsung		0	0	0	0	0	26	0

B2B Repair Time per Call (in mins) by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	49.83	63.38	69.59	58.46		46.25	57.40	62.42
OTHER	51.14	73.35	53.85	71.54	82.18	63.85	54.38	59.35
WASHER	46.00	65.00	78.82	63.98	68.00	60.78	56.89	69.15
DISHWASHER	40.50	60.00	73.81		inf	51.00	55.04	42.91
REFRIGERATOR	57.33	73.56	68.13	71.27	85.56	55.11	63.06	68.87
DRYERS	42.00	29.00	53.62	57.04	82.50	29.00	49.03	42.86
COOKTOP		34.00	76.14	42.40	67.00	29.25	58.62	130.00
OVEN	inf	36.00	91.68	58.02	68.40	36.00	52.94	96.75
FREEZER		45.00	57.00	45.00	45.00	45.00	74.00

Total B2B Completes by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	36	52	60	53	73	34	3,238	206
OTHER	14	17	7	14	17	11	586	57
WASHER	7	7	11	8	9	7	667	39
DISHWASHER	6	11	6	4	11	0	373	22
REFRIGERATOR	6	9	22	15	19	9	1,037	56
DRYERS	3	3	6	5	7	3	319	22
COOKTOP	0	2	2	2	4	1	119	2
OVEN	0	2	5	4	5	2	125	8
FREEZER		1	0	1	1	1	12	0

D2C Repair Time per Call (in mins) by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
COOKTOP			121.00	inf	inf	inf	46.12	29.00
DISHWASHER	3.00	27.33	46.33	37.98	54.75	20.50	47.73	33.83
DRYERS	15.50	21.50	42.92	50.52	71.00	21.50	55.02	46.17
FREEZER		85.00	inf		inf	85.00	34.48
OTHER	70.00	59.67	85.80	70.87	84.67	59.67	56.94	53.56
OVEN	34.33	inf	126.00	inf	inf	57.50	51.63	45.20
REFRIGERATOR	37.33	43.12	57.80	45.53	49.56	43.12	56.28	43.60
Total	35.15	42.52	56.95				52.37	44.18
WASHER	26.00	39.11	55.03	36.17	41.73	27.25	46.89	40.44

Total D2C Completes by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	26	29	27	32	44	22	1,616	106
REFRIGERATOR	9	8	11	10	15	8	517	35
WASHER	5	9	8	10	12	8	413	25
DRYERS	4	2	3	2	4	1	235	18
OTHER	4	3	1	3	4	3	190	16
OVEN	3	0	0	1	2	0	84	5
DISHWASHER	1	6	4	4	6	2	142	6
COOKTOP	0	0	0	0	0	0	8	1
FREEZER		1	0	0	1	0	27	0

Total Repair Time per Call (in mins) by Brand

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE	MFG_BND_NM
B2B	FRIGIDAIRE		80.33	66.45	48.67	80.33	5.00	51.81	66.00
	GE	47.86	66.43	78.16	66.77	84.00	56.50	56.59	57.47
	KENMORE	46.83	67.80	68.90	65.84	76.36	59.00	60.31	50.55
	LG	91.00	73.33	61.52	86.58	105.50	73.33	60.54	57.63
	OTHER BRANDS	51.82	64.64	72.35	70.95	78.87	64.64	56.11	67.67
	SAMSUNG	6.50	46.83	78.00	71.94	102.00	44.60	57.59	77.09
	WHIRLPOOL	51.00	54.67	59.09	52.79	58.00	42.00	58.70	60.23
D2C	FRIGIDAIRE	21.00	20.33	42.50	39.12	60.67	20.33	46.92	23.20
	GE	39.33	29.00	42.70	37.92	73.00	23.67	49.24	49.00
	KENMORE	47.64	40.18	55.02	44.86	47.69	40.18	49.23	49.53
	LG	24.00	90.00	45.83	47.70	90.00	27.00	48.59	42.50
	OTHER BRANDS	inf	71.50	69.62	67.94	79.00	53.60	60.08	56.11
	SAMSUNG	27.20	27.50	55.38	31.54	45.67	26.00	53.59	32.40
	WHIRLPOOL	17.20	25.40	56.18	49.35	65.67	25.40	47.30	21.91
Total		43.68	55.91	65.63	55.86	74.77	40.09	55.72	56.22

Travel Time per Attempt

Transit Time per Attempt (in mins) by Payment Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	48.81	48.58	36.29	40.51	49.75	34.19	49.17	49.34
B2B	54.58	45.46	36.50	35.45	45.46	29.01	47.31	49.01
D2C	40.24	54.05	35.77	45.56	54.05	39.38	53.42	50.11

Attempts by Payment Type (only B2B and D2C)

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE
Total	82	102	113	106	113	102	7,029	442
B2B	49	65	80	68	72	65	4,891	313
D2C	33	37	33	39	41	37	2,138	129

B2B Transit Time per Attempt (in mins) by Client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	54.58	45.46	36.50	34.90	43.10	25.87	47.31	49.01
Sears Home Warranty Plus	48.92	48.97	34.82	35.10	48.97	27.15	42.14	50.55
Choice Home Warranty	75.48	43.52	39.73	36.77	43.52	29.34	51.12	61.63
American Home Shield	60.15	40.46	43.07	35.77	40.46	30.58	46.08	44.41
First American Home Buyers	53.08	50.00	44.60	29.63	50.00	0.00	44.07	47.96
Assurant	41.17		26.38	31.83	35.33	26.69	48.67	28.49
Other B2B Clients	0.00	34.20	37.82	42.09	50.29	34.20	49.10	42.12
AIG		33.12	37.14	33.12	33.12	33.12	48.58
Asurion			30.50				48.16	39.53
EMA/Electrolux							49.46
GE (General Electric)							50.81	60.71
LG			46.17				51.22	75.97
Samsung			39.83				56.68

Total B2B Completes by client

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
CLIENT_NM
Total	49	65	80	68	80	54	4,891	313
Sears Home Warranty Plus	29	34	55	39	43	34	1,118	112
Choice Home Warranty	10	16	9	14	16	13	875	55
American Home Shield	5	8	6	6	8	4	728	55
First American Home Buyers	3	2	1	2	3	1	272	20
Assurant	1	0	0	3	5	0	580	18
Other B2B Clients	1	4	2	3	4	1	613	31
AIG		1	4	1	1	1	32
Asurion			0	0	0	0	90	14
EMA/Electrolux							92
GE (General Electric)			0	0	0	0	240	6
LG			2	0	0	0	217	2
Samsung		0	0	0	0	0	34	0

B2B Transit Time per Attempt (in mins) by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	54.58	45.46	36.50	36.15	46.03	27.91	47.31	49.01
OTHER	65.44	52.20	38.06	45.80	52.20	39.89	51.04	67.94
WASHER	34.62	46.78	35.16	29.62	46.78	20.89	45.67	40.13
DISHWASHER	32.78	35.41	41.36	33.45	38.21	25.94	46.52	37.60
REFRIGERATOR	95.65	43.74	35.73	33.08	43.74	24.22	47.21	45.46
DRYERS	20.59	38.90	35.47	26.41	38.90	18.26	47.12	50.39
OVEN	57.19	33.12	33.54	36.75	41.95	31.82	44.83	44.75
COOKTOP		58.87	44.35	36.46	58.87	14.65	46.31	30.82
FREEZER		47.62	30.17	47.62	47.62	47.62	55.75

Total B2B Attempts by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	49	65	80	68	92	48	4,891	313
OTHER	16	22	9	17	22	15	798	74
WASHER	10	9	15	11	12	9	1,037	64
DISHWASHER	8	12	9	6	12	2	576	34
REFRIGERATOR	8	14	28	19	23	14	1,605	90
DRYERS	4	3	9	6	10	3	459	29
OVEN	3	2	7	5	8	2	210	17
COOKTOP	0	2	2	3	4	2	191	5
FREEZER		1	0	1	1	1	15	0

D2C Transit Time per Attempt (in mins) by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	40.24	54.05	35.77	47.54		38.49	53.42	50.11
REFRIGERATOR	58.81	38.26	37.59	46.42	57.60	38.26	52.99	47.21
WASHER	21.79	58.32	31.47	40.37	58.32	26.98	50.40	54.73
OTHER	34.59	90.54	43.49	62.99	90.54	44.54	62.39	59.19
DRYERS	59.76	46.93	28.03	45.66	55.52	38.34	53.34	55.54
OVEN	20.51	71.30	49.78	42.57	71.30	28.05	51.88	24.78
DISHWASHER	0.00	37.03	35.32	36.13	48.67	26.91	52.65	25.47
COOKTOP			44.25	58.67	58.67	58.67	31.92	40.61
FREEZER		46.17	inf		inf	46.17	57.93

Total D2C Attempts by Appliance Type

	1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
INDUSTRY
Total	33	37	33	39	55	26	2,138	129
REFRIGERATOR	11	9	12	12	16	9	706	41
WASHER	7	11	9	12	14	9	519	31
OTHER	6	6	2	5	7	3	263	21
DRYERS	4	2	4	3	5	2	318	22
OVEN	4	1	1	2	4	1	109	6
DISHWASHER	1	7	5	4	7	2	177	7
COOKTOP	0	0	0	0	1	0	14	1
FREEZER		1	0	0	1	0	32	0

Total Transit Time per Attempt (in mins) by Brand

		1. MONDAY	8. Last Week MONDAY	Last Year 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Avg	Last 4 Weeks MONDAY Max	Last 4 Weeks MONDAY Min	National on MONDAY	District on MONDAY
PAYMENT_TYPE	MFG_BND_NM
B2B	FRIGIDAIRE		0.37	0.79	0.54	0.78	0.37	0.75	0.58
	GE	0.58	0.58	0.60	0.48	0.58	0.37	0.78	0.67
	KENMORE	0.83	0.94	0.56	0.60	0.94	0.40	0.73	0.69
	LG	1.92	0.64	0.68	0.54	0.69	0.29	0.79	1.04
	OTHER BRANDS	0.93	0.86	0.60	0.68	0.86	0.60	0.83	0.97
	SAMSUNG	0.69	0.85	0.60	0.56	0.85	0.20	0.80	0.64
	WHIRLPOOL	1.12	0.75	0.64	0.52	0.75	0.29	0.78	0.83
D2C	FRIGIDAIRE	0.52	0.45	0.64	0.71	1.04	0.45	1.01	0.41
	GE	0.39	1.09	0.55	0.78	1.09	0.66	0.87	0.69
	KENMORE	0.87	0.89	0.65	0.76	0.89	0.63	0.84	0.91
	LG	0.65	0.55	0.40	0.75	1.42	0.51	0.92	0.88
	OTHER BRANDS	1.18	1.11	0.60	0.78	1.11	0.55	0.94	0.92
	SAMSUNG	0.50	1.15	0.54	1.23	1.91	0.83	0.86	0.79
	WHIRLPOOL	0.42	0.57	0.58	0.57	0.70	0.43	0.87	0.82
Total		0.81	0.81	0.60	0.68	0.97	0.47	0.82	0.82

Miami Metrices Aggregated View– For MONDAY, 2023-07-31

	MONDAY	CURRENT WEEK AVG	LAST 4 WEEKS MONDAY AVG	LAST YEAR 4 WEEKS MONDAY AVG	MONDAY NATIONAL	MONDAY DISTRICT
METRICS
parts used which are truck stock (TSSL %)	21.4	21.4	21.9	14.5	19.7	20.5
Response Time	2.2	2.2	2.1	1.9	4.7	3.2
Repair time	70.2	70.2	nan	nan	nan	nan
Cycle Time	8.7	8.7	8.6	10.9	14.0	11.2
First_Time_Completes	72.6	72.6	79.1	73.8	66.6	68.3
Completes per Day	3.9	3.9	4.5	3.1	4.0	3.8
Handles per Day	5.3	5.3	5.5	4.0	5.6	5.2
Cancel_Rate (in %)	18.5	18.5	18.5	12.4	18.3	17.0
Cancels	32.0	32.0	nan	nan	12,327.0	764.0

Metrics Glossary

	KPIs	Description
0	% parts used which are truck stock (TSSL %)	% parts used which were stocked in truck
1	Arrive In Window	Arrived within the time window given to the customer (ETA Arrived On-time)
2	Attempts	Count of all Service Order attempts .
3	B2B %	Share of B2B completes per 100 completes
4	B2B Completes	Count of all completes which were B2B
5	Cancel Rate	Percentage of Created Service orders where Service order was cancelled.
6	Cancels	Count of service order with a service order status of cancelled (CA).
7	Clean & Maintain Conversion	Count of Non clean and maintain calls that were converted to clean and maintain
8	Completes	Count of all Service Order attempts having a completion call code .
9	Completes per day	orders completed by techs per day
10	Creates	Count of all Service Orders Created
11	Cycle Time	Count of days between Service order Creation and Service order completion.
12	Cycle Time	Count of days between Service order Creation and Service order completion.
14	D2C %	Share of D2C completes per 100 completes
15	D2C Completes	Count of all completes which were D2C
16	First Time Completes	Count of Service Orders completed on 1st Attempt
17	Handles per day	Tech attempts per day
18	Home Warranty Conversion	Count of Non home warrant calls that were converted to Home warranty
19	Net promoter Score/5* Rating	Net Promoter Score
20	3 Plus Attempts %	Service order completed requiring 3 or more attempts
21	PA Completes	Count of all completes which were Protection Agreements
22	PA%	Share of PA% completes per 100 completes
23	Parts installed	Count of parts installed
24	Parts Required	No. of parts required to service the order
25	Repair time	Amount of time the repair took. Represented in Hours
26	Repair Time	Amount of time the repair took. Represented in Hours
28	Reschedule Rate	Percent of all service orders that were rescheduled.
29	Reschedules	Count of Service Orders that have been rescheduled.
30	Response Time	Days between Service Order creation and first available date excluding Sunday and holidays.
31	Response Time	Days between Service Order creation and first available date excluding Sunday and holidays.
32	Travel Time	Approximate hours spent traveling to repair service order attempts.
33	Trips per repair	Measurement of how many attempts to drive a completed service order
34	Truck Stock Parts Required	no. of parts stored in truck used to service calls
37	Local parts %	Share of local parts in total parts used
38	Ordered parts %	Share of ordered parts in total parts used
39	W2 tech completes	Count of Completes serviced by W2s
40	1099 Tech completes	Count of Completes serviced by 1099s
42	Customer Decline Estimate	Count of calls closed where customer refused service after charge estimation.
43	Cancels at Door	Count of Attempt where Service order was cancelled at door