ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Company:Open Austin
3
Objective:Operating Plan
4
Confidental:Yes
5
Created by:Jonathan Placa
6
Email:jonathanplaca@gmail.com
7
Last updated:09/24/2017
8
Update descriptionsee: "Appendix: Changelog"
9
10
Main Workbook
11
Table of Contents:
Table of Contents, outlining "Open Austin - Finance and Operating Plan.xlsx" workbook.
12
(not present) Comps & KPIs:
Summary tab highlighting basic financial comparisons (e.g MTD, YTD performance). Pulls from "Operating Plan", "Appendix: Profit & Loss", "Appendix: Balance Sheet"; "Appendix: Cashflows".
13
Operating Plan:
Transformation of data, pulled from financial statements listed in "Appendix". Additional data transformation pulled from "Sales Projections", "Headcount", and "Cashflow Projections". "Operating Plan" is used to assist with projections and budgeting.
14
Sales Projections:
Estimated sales; Contract values are accrued on a month-to-month basis; sheet contains functions enabling user to modify contract terms accordingly.
15
Revenue Cashflows
Based off of 'Sales Projections" data; Although accruing revenue each month, Cashflow projections are based on inflows of quarterly invoices with Net 60 terms.
16
Headcount:
Similar to "Sales Projections", "Headcount" is a worksheet that forecasts hiring expenses. Worksheet contains functions to modify/analyze hiring effects based on salary terms.
17
18
Appendix
19
(not present) Appedix: Profit Loss
Profit Loss data exported on a month-by-month basis from Accounting software.
20
(not present) Appendix: Balance Sheet
Balance Sheet data exported on a month-by-month basis from Accounting Software.
21
(not present) Appendix: Cashflow
Cashflow data exported on month-by-month basis from Accounting Software.
22
Appendix: Budget
Budget, as approved by the Board of Directors.
23
Appendix: Changelog
History of modifications made to "Open Austin - Finance and Operating Plan.xlsx" workbook.
24
25
Definitions (see: Operating Plan)
26
"Revenue"
Accrued Revenue based on Omnibuild's services. Services are rendered at the each of each month, but billed quarterly.
27
"COGs"
Open Austin classifies COGs as client-facing infrastructure that is necessary for NarrativeDx's product to be functional. Direct Labor (Sales & Marketing efforts) are not currently recognized as COGs.
28
"Salaries & Benefits"
Salaries & Benefits include Payroll, Payroll Taxes, Healthcare, Bonuses, Commissions, etc..
29
"Recruiting"
Recruiting includes Interview logistics (i.e flights for remote candidates), Meals & Entertainment - 3rd party, Relocation Costs, and Recruiter Fess (including online Job Board fees).
30
"Contracting"
Third-party vendors such as, but not limited to; Legal, Financial Advisors, Engineering & Design, etc..
31
"Travel & Entertainment"
Costs associated with out-of-town logistics. T&E includes Transportation, Lodging, Meals, and extended Temporary Work Assignments (>1 month).
32
"Facitilites"
On-premise costs including, but not limited to; office rent, maintenance, software & software subscriptions, etc..
33
"Marketing"
Costs associated with advertising, publications, and collateral.
34
"Other"
Includes, but not limited to; bank fees, conference fees, membership fees, office supplies, etc..
35
"Depreciation & Amortization"
Depreciation and Amortization costs present in Operating Expenses (Open Austin currently does not have any Depreciation/Amortization costs in COGs).
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