Office Space Optimization Template 👩‍💻

	A	B	C	D	E	F	G	H	J	K	M
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, max	80%
6	Extra space per office, med	50%									*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, min	20%
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 feet	1,000	5,000	10,000	50,000	100,000	500,000	1,000,000
16	Extra space, max	800	4,000	8,000	40,000	80,000	400,000	800,000
17	Extra space, med	500	2,500	5,000	25,000	50,000	250,000	500,000
18	Extra space, min	200	1,000	2,000	10,000	20,000	100,000	200,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, max	Area, sq feet
24	Savings estimate, max	1,000	5,000	10,000	50,000	100,000	500,000	1,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, med	Area, sq feet
30	Savings, med	1,000	5,000	10,000	50,000	100,000	500,000	1,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, min	Area, sq feet
36	Savings, min	1,000	5,000	10,000	50,000	100,000	500,000	1,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 mix	10%	20%	40%	10%	10%	5%	5%	100%
43	Customer type mix
44	Class A	50%	50%	50%	33%	25%	25%	25%
45	Class B	25%	25%	25%	33%	50%	50%	50%
46	Class C	25%	25%	25%	34%	25%	25%	25%
47	Checksum	100%	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