{"text_format":"1","workbook":"xls","n_sheets":5,"sheets":["Planned Expenses","Actual Expenses","Expense Variances","Expense Analysis","Total Expenses"],"not_rendered":{"charts":3,"images":4,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Total Expenses","index":4,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Planned Expenses","index":0,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,1]],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Expense Estimates"]
[]
[]
["Planned Expenses","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
["Employee Costs"]
["Wages",85000,85000,85000,87500,87500,87500,87500,92400,92400,92400,92400,92400,1067000]
["Benefits",22950,22950,22950,23625,23625,23625,23625,24948,24948,24948,24948,24948,288090]
["Subtotal",107950,107950,107950,111125,111125,111125,111125,117348,117348,117348,117348,117348,1355090]
[]
["Office Costs"]
["Office lease",9800,9800,9800,9800,9800,9800,9800,9800,9800,9800,9800,9800,117600]
["Gas",null,400,400,100,100,100,100,100,100,100,400,400,2300]
["Electric",300,300,300,300,300,300,300,300,300,300,300,300,3600]
["Water",40,40,40,40,40,40,40,40,40,40,40,40,480]
["Telephone",250,250,250,250,250,250,250,250,250,250,250,250,3000]
["Internet access",180,180,180,180,180,180,180,180,180,180,180,180,2160]
["Office supplies",200,200,200,200,200,200,200,200,200,200,200,200,2400]
["Security",600,600,600,600,600,600,600,600,600,600,600,600,7200]
["Subtotal",11370,11770,11770,11470,11470,11470,11470,11470,11470,11470,11770,11770,138740]
[]
["Marketing Costs"]
["Web site hosting",500,500,500,500,500,500,500,500,500,500,500,500,6000]
["Web site updates",200,200,200,200,200,1000,200,200,200,200,200,1000,4000]
["Collateral preparation",5000,0,0,5000,0,0,5000,0,0,5000,0,0,20000]
["Collateral printing",200,200,200,200,200,200,200,200,200,200,200,200,2400]
["Marketing events",2000,2000,2000,5000,2000,2000,2000,5000,2000,2000,2000,5000,33000]
["Miscellaneous expenses",200,200,200,200,200,200,200,200,200,200,200,200,2400]
["Subtotal",8100,3100,3100,11100,3100,3900,8100,6100,3100,8100,3100,6900,67800]
[]
["Training/Travel"]
["Training classes",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,24000]
["Training-related travel costs",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,24000]
["Subtotal",4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,48000]
[]
["TOTALS"]
["Monthly Planned Expenses",131420,126820,126820,137695,129695,130495,134695,138918,135918,140918,136218,140018,1609630]
["TOTAL Planned Expenses",131420,258240,385060,522755,652450,782945,917640,1056558,1192476,1333394,1469612,1609630]

{"sheet":"Actual Expenses","index":1,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Expense Estimates"]
[]
[]
["Actual Expenses","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
["Employee Costs"]
["Wages",85000,85000,85000,88000,88000,88000,0,0,0,0,0,0,519000]
["Benefits",22950,22950,22950,23760,23760,23760,0,0,0,0,0,0,140130]
["Subtotal",107950,107950,107950,111760,111760,111760,0,0,0,0,0,0,659130]
[]
["Office Costs"]
["Office lease",9800,9800,9800,9800,9800,9800,0,0,0,0,0,0,58800]
["Gas",4,430,385,230,87,88,0,0,0,0,0,0,1224]
["Electric",288,278,268,299,306,290,0,0,0,0,0,0,1729]
["Water",35,33,34,36,34,36,0,0,0,0,0,0,208]
["Telephone",224,235,265,245,245,220,0,0,0,0,0,0,1434]
["Internet access",180,180,180,180,180,180,0,0,0,0,0,0,1080]
["Office supplies",256,142,160,221,256,240,0,0,0,0,0,0,1275]
["Security",600,600,600,600,600,600,0,0,0,0,0,0,3600]
["Subtotal",11387,11698,11692,11611,11508,11454,0,0,0,0,0,0,69350]
[]
["Marketing Costs"]
["Web site hosting",500,500,500,500,500,500,0,0,0,0,0,0,3000]
["Web site updates",200,200,200,200,200,1500,0,0,0,0,0,0,2500]
["Collateral preparation",4800,0,0,5500,0,0,0,0,0,0,0,0,10300]
["Collateral printing",100,500,100,100,600,180,0,0,0,0,0,0,1580]
["Marketing events",1800,2200,2200,4700,1500,2300,0,0,0,0,0,0,14700]
["Miscellaneous expenses",145,156,123,223,187,245,0,0,0,0,0,0,1079]
["Subtotal",7545,3556,3123,11223,2987,4725,0,0,0,0,0,0,33159]
[]
["Training/Travel"]
["Training classes",1600,2400,1400,1600,1200,2800,0,0,0,0,0,0,11000]
["Training-related travel costs",1200,2200,1400,1200,800,3500,0,0,0,0,0,0,10300]
["Subtotal",2800,4600,2800,2800,2000,6300,0,0,0,0,0,0,21300]
[]
["TOTAL Planned Expenses"]
["Monthly Actual Expenses",129682,127804,125565,137394,128255,134239,0,0,0,0,0,0,782939]
["TOTAL Actual Expenses",129682,257486,383051,520445,648700,782939,782939,782939,782939,782939,782939,782939]

{"sheet":"Expense Variances","index":2,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Expense Estimates"]
[]
[]
["Expense Variances","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
["Employee Costs"]
["Wages",0,0,0,-500,-500,-500,87500,92400,92400,92400,92400,92400,548000]
["Benefits",0,0,0,-135,-135,-135,23625,24948,24948,24948,24948,24948,147960]
["Subtotal",0,0,0,-635,-635,-635,111125,117348,117348,117348,117348,117348,695960]
[]
["Office Costs"]
["Office lease",0,0,0,0,0,0,9800,9800,9800,9800,9800,9800,58800]
["Gas",-4,-30,15,-130,13,12,100,100,100,100,400,400,1076]
["Electric",12,22,32,1,-6,10,300,300,300,300,300,300,1871]
["Water",5,7,6,4,6,4,40,40,40,40,40,40,272]
["Telephone",26,15,-15,5,5,30,250,250,250,250,250,250,1566]
["Internet access",0,0,0,0,0,0,180,180,180,180,180,180,1080]
["Office supplies",-56,58,40,-21,-56,-40,200,200,200,200,200,200,1125]
["Security",0,0,0,0,0,0,600,600,600,600,600,600,3600]
["Subtotal",-17,72,78,-141,-38,16,11470,11470,11470,11470,11770,11770,69390]
[]
["Marketing Costs"]
["Web site hosting",0,0,0,0,0,0,500,500,500,500,500,500,3000]
["Web site updates",0,0,0,0,0,-500,200,200,200,200,200,1000,1500]
["Collateral preparation",200,0,0,-500,0,0,5000,0,0,5000,0,0,9700]
["Collateral printing",100,-300,100,100,-400,20,200,200,200,200,200,200,820]
["Marketing events",200,-200,-200,300,500,-300,2000,5000,2000,2000,2000,5000,18300]
["Miscellaneous expenses",55,44,77,-23,13,-45,200,200,200,200,200,200,1321]
["Subtotal",555,-456,-23,-123,113,-825,8100,6100,3100,8100,3100,6900,34641]
[]
["Training/Travel"]
["Training classes",400,-400,600,400,800,-800,2000,2000,2000,2000,2000,2000,13000]
["Training-related travel costs",800,-200,600,800,1200,-1500,2000,2000,2000,2000,2000,2000,13700]
["Subtotal",1200,-600,1200,1200,2000,-2300,4000,4000,4000,4000,4000,4000,26700]
[]
["TOTALS"]
["Monthly Expense Variances",1738,-984,1255,301,1440,-3744,134695,138918,135918,140918,136218,140018,826691]
["TOTAL Expense Variances",1738,754,2009,2310,3750,6,134701,273619,409537,550455,686673,826691]

{"sheet":"Expense Analysis","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Expense Estimates"]
[]
[]
["Expense Category","Planned Expenses","Actual Expenses","Expense Variances","Variance Percentage"]
["Employee Costs",1355090,659130,695960,0.5135895032802249]
["Office Costs",138740,69350,69390,0.5001441545336601]
["Marketing Costs",67800,33159,34641,0.510929203539823]
["Training/Travel",48000,21300,26700,0.55625]
["TOTALS",1609630,782939,826691,0.5135907009685455]