Building_Health_Report_Sample-1.xlsx

	A	B
1	Building Health Report
2	Sample workbook by Kianna Ford. All locations and figures are fictional; the structure mirrors a real 16-location report.
3
4	WHO USES WHICH TAB
5	Leadership	Dashboard: one page with KPIs, every location's status and three plain-English insights.
6	Regional leads	Regional Trend: month-by-month occupancy, revenue and margin by region.
7	Location managers	Their own location tab (Site A to Site H): enter the month's numbers in the blue cells; everything else calculates.
8
9	HOW TO READ IT
10	Blue numbers	Entered by the location manager from the monthly reporting package.
11	Shaded rows	Formulas. They calculate automatically, so don't type over them.
12	Yellow column	Half-year totals or averages.
13	Red text	Below standard, such as a call answer rate under 70% or a negative margin.
14
15	STATUS LABELS
16	Needs attention	Losing money with flat or falling occupancy.
17	Improving	Losing money, but occupancy is rising.
18	Watch	Margin under 10%.
19	Strong	Margin of 10% or more.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100