ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Office Space Optimization Template ๐Ÿ‘ฉโ€๐Ÿ’ปHOW TO USE THIS RESOURCE:

First,
go to lines 24, 30, or 36 to choose either a maximum, medium or minimum savings estimate.

Second, choose the appropriate amount of square feet in your office from columns B through H.

Third, choose the estimated cost of rent for your area below your selected savings estimate.

For example, let's calculate the medium savings estimate (line 30) for an office with 5,000 sq. ft (column C) in Boston. Our estimated medium cost for rent (line 32) would bring us to $94,500 per year (line 32, column C)
2
by inspace
3
4
Assumptions
5
Extra space per office, max80%
6
Extra space per office, med50%*https://www.squarefoot.com/office-space/ma/boston. Boston Office Space. Lease Data and Trends. Average asking rent varies depending on building class. Boston office space in Class A properties lease for around $65-70 per square foot, Class B around $45-50 and Class C properties rent for closer to $30 per square foot.
7
Extra space per office, min20%
8
9
Boston*
10
Rent cost per sq foot, Class A$69
11
Rent cost per sq foot, Class B$54
12
Rent cost per sq foot, Class C$30
13
14
Office space
15
Square feet1,0005,00010,00050,000100,000500,0001,000,000
16
Extra space, max8004,0008,00040,00080,000400,000800,000
17
Extra space, med5002,5005,00025,00050,000250,000500,000
18
Extra space, min2001,0002,00010,00020,000100,000200,000
19
Rent cost, max$69,000$345,000$690,000$3,450,000$6,900,000$34,500,000$69,000,000
20
Rent cost, med$54,000$270,000$540,000$2,700,000$5,400,000$27,000,000$54,000,000
21
Rent cost, min$30,000$150,000$300,000$1,500,000$3,000,000$15,000,000$30,000,000
22
23
Savings estimate, maxArea, sq feet
24
1,0005,00010,00050,000100,000500,0001,000,000
25
Rent cost, max$55,200$276,000$552,000$2,760,000$5,520,000$27,600,000$55,200,000
26
Rent cost, med$43,200$216,000$432,000$2,160,000$4,320,000$21,600,000$43,200,000
27
Rent cost, min$24,000$120,000$240,000$1,200,000$2,400,000$12,000,000$24,000,000
28
29
Savings, medArea, sq feet
30
1,0005,00010,00050,000100,000500,0001,000,000
31
Rent cost, max$34,500$172,500$345,000$1,725,000$3,450,000$17,250,000$34,500,000
32
Rent cost, med$27,000$135,000$270,000$1,350,000$2,700,000$13,500,000$27,000,000
33
Rent cost, min$15,000$75,000$150,000$750,000$1,500,000$7,500,000$15,000,000
34
35
Savings, minArea, sq feet
36
1,0005,00010,00050,000100,000500,0001,000,000
37
Rent cost, max$13,800$69,000$138,000$690,000$1,380,000$6,900,000$13,800,000
38
Rent cost, med$10,800$54,000$108,000$540,000$1,080,000$5,400,000$10,800,000
39
Rent cost, min$6,000$30,000$60,000$300,000$600,000$3,000,000$6,000,000
40
41
checksum
42
Customer size mix10%20%40%10%10%5%5%100%
43
Customer type mix
44
Class A50%50%50%33%25%25%25%
45
Class B25%25%25%33%50%50%50%
46
Class C25%25%25%34%25%25%25%
47
Checksum100%100%100%100%100%100%100%
48
Total End value to customer of $6.2 - $23.9 per sq.ft.
49
Customer Savings($/ft), max$2.8$5.5$11.0$1.8$1.4$0.7$0.7$23.9
50
Customer Savings ($/ft), med$1.1$2.2$4.3$1.4$2.2$1.1$1.1$13.3
51
Customer Savings ($/ft), min$0.6$1.2$2.4$0.8$0.6$0.3$0.3$6.2
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