{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Break-Even","BE Analysis","BE Calculations"],"not_rendered":{"charts":4,"images":0,"macros":0,"external_links":0,"defined_names":28,"comments":2,"pivot_tables":0},"unopened":[],"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"}

{"sheet":"Break-Even","index":0,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,2,4,6],[46,2,46,6]]}
[]
[]
[]
[]
[null,null,"Break-Even Analysis"]
[]
[]
[null,null,null,2007,{"$f":"D8+1","v":2008},{"$f":"E8+1","v":2009},{"$f":"F8+1","v":2010}]
[]
[null,null,"Sales",2010000,2060000,2121800,2391800]
[]
[null,null,"Less Variable Expenses"]
[null,null,"Materials",320000,329600,339488,389088]
[null,null,"Labor",500000,515000,530450,545450]
[null,null,"Variable overhead",125000,128750,132612.5,186362.5]
[null,null,"Other",0,0,0,0]
[null,null,"Contribution Margin",{"$f":"D10-(D13+D14+D15+D16)","v":1065000},{"$f":"E10-(E13+E14+E15+E16)","v":1086650},{"$f":"F10-(F13+F14+F15+F16)","v":1119249.5},{"$f":"G10-(G13+G14+G15+G16)","v":1270899.5}]
[null,null,"Contribution Margin Ratio",{"$f":"D17/D10","v":0.52985074626865669},{"$f":"E17/E10","v":0.52749999999999997},{"$f":"F17/F10","v":0.52749999999999997},{"$f":"G17/G10","v":0.53135692783677568}]
[]
[null,null,"Fixed Expenses"]
[null,null,"Salaries and wages",190000,190000,190000,190000]
[null,null,"Employee benefits",50000,51500,53045,54545]
[null,null,"Payroll taxes",30000,30900,31827,32727]
[null,null,"Rent",5000,5150,5304.5,5454.5]
[null,null,"Utilities",3000,3090,3182.7,3272.7]
[null,null,"Repairs and maintenance",1000,1030,1060.9000000000001,1060.9000000000001]
[null,null,"Insurance",1000,1030,1060.9000000000001,1060.9000000000001]
[null,null,"Travel",2133,2196.9899999999998,2262.8996999999999,2262.8996999999999]
[null,null,"Telephone",11000,11330,11669.9,12669.9]
[null,null,"Postage",4000,4120,4243.6000000000004,4243.6000000000004]
[null,null,"Office supplies",6000,6180,6365.4,6365.4]
[null,null,"Advertising",1000,1030,1060.9000000000001,1060.9000000000001]
[null,null,"Marketing/promotion",3000,3090,3182.7,3182.7]
[null,null,"Professional fees",1000,1030,1060.9000000000001,1060.9000000000001]
[null,null,"Training and development",1000,1030,1060.9000000000001,1060.9000000000001]
[null,null,"Bank charges",1000,1030,1060.9000000000001,1060.9000000000001]
[null,null,"Depreciation",1000,1030,1060.9000000000001,1060.9000000000001]
[null,null,"Interest Expense",6000,6000,6000,6000]
[null,null,"Other",0,0,0,0]
[null,null,"Total Fixed Expenses",{"$f":"SUM(D21:D38)","v":317133},{"$f":"SUM(E21:E38)","v":320766.99},{"$f":"SUM(F21:F38)","v":324509.99970000022},{"$f":"SUM(G21:G38)","v":328149.99970000022}]
[null,null,"Total Fixed Expenses Ratio",{"$f":"D40/D10","v":0.15777761194029852},{"$f":"E40/E10","v":0.15571213106796117},{"$f":"F40/F10","v":0.15294089909510802},{"$f":"G40/G10","v":0.13719792612258558}]
[null,null,"Break-Even Sales",{"$f":"D10*D43","v":598532.70422535215},{"$f":"E10*E43","v":608089.08056872035},{"$f":"F10*F43","v":615184.83355450281},{"$f":"G10*G43","v":617569.81514467555}]
[null,null,"Break-Even %",{"$f":"(D40/(D40+D44))","v":0.2977774647887324},{"$f":"(E40/(E40+E44))","v":0.29518887406248562},{"$f":"(F40/(F40+F44))","v":0.28993535373480195},{"$f":"(G40/(G40+G44))","v":0.25820294972183105}]
[null,null,"Operating Profit",{"$f":"(D17-D40)","v":747867},{"$f":"(E17-E40)","v":765883.01},{"$f":"(F17-F40)","v":794739.50029999972},{"$f":"(G17-G40)","v":942749.50029999972}]

{"sheet":"BE Analysis","index":1,"n_rows":41,"n_cols":25,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,10,31,24]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Break-Even Analysis"]
[]
[null,null,null,null,null,null,null,null,null,null,"Current BE Chart",null,null,null,"Current Pie",null,null,null,"Projected BE Chart",null,null,null,"Projected Pie"]
[null,null,null,null,null,null,null,null,null,null,null,"Sales $",{"$f":"Q23","v":2010000},null,null,"Fixed %",{"$f":"Q24/$Q$23","v":0.15777761194029852},null,null,"Sales $",{"$f":"S23","v":2391800},null,null,"Fixed %",{"$f":"S24/S23","v":0.13259177188728155}]
[null,null,null,null,null,null,null,null,null,null,null,"Fixed $",{"$f":"Q24","v":317133},null,null,"Total Variable %",{"$f":"Q26","v":0.52985074626865669},null,null,"Fixed $",{"$f":"S24","v":317133},null,null,"Total Variable %",{"$f":"S26","v":0.39509992474287148}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Variable $",{"$f":"Q25","v":1065000},null,null,"Profit %",{"$f":"Q27/$Q$23","v":0.31237164179104476},null,null,"Total Variable $",{"$f":"S25","v":945000},null,null,"Profit %",{"$f":"S27/S23","v":0.47230830336984697}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current",null,"Projected",null,{"$f":"IF(Q30>365,\"THE B/E POINT IS IN NEXT YEAR\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales $",{"$f":"'Break-Even'!$D$10","v":2010000},null,2391800,null,{"$f":"IF(Q30>365,\"BECAUSE PROFIT IS NEGATIVE.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed $",{"$f":"'Break-Even'!$D$40","v":317133},null,317133,null,{"$f":"IF(S30>365,\"THE B/E POINT IS IN NEXT YEAR\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Variable $",{"$f":"'Break-Even'!$D$17","v":1065000},null,945000,null,{"$f":"IF(S30>365,\"BECAUSE PROFIT IS NEGATIVE.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Variable %",{"$f":"Q25/Q23","v":0.52985074626865669},null,{"$f":"S25/S23","v":0.39509992474287148}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Profit $",{"$f":"Q23-(Q24+Q25)","v":627867},null,{"$f":"S23-(S24+S25)","v":1129667}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Break-Even %",{"$f":"(Q24/(Q24+Q27))","v":0.33559047619047622},null,{"$f":"(S24/(S24+S27))","v":0.21919615703621786}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BE Dollars",{"$f":"Q23*Q28","v":674536.85714285716},null,{"$f":"S23*S28","v":524273.36839922587}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BE Date",{"$f":"Q28*365","v":"1900-05-01T11:46:21.257"},null,{"$f":"S28*365","v":"1900-03-20T00:09:30.008"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"© Copyright, 2002, JaxWorks, All Rights Reserved"]

{"sheet":"BE Calculations","index":2,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"MONTHS","REVENUE","FIXED\nCOSTS","VARIABLE\nCOSTS","TOTAL\nCOSTS","TOTAL\nPROFIT","X AXIS"]
[null,0,{"$f":"B4*'BE Analysis'!$Q$29","v":0},{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"'BE Analysis'!$Q$24*B4","v":0},{"$f":"E4+D4","v":317133},{"$f":"C4-F4","v":-317133}]
[null,1,{"$f":"'BE Analysis'!Q23/$B$16","v":167500},{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C5*'BE Analysis'!$Q$26","v":88750},405883,-238383,0]
[null,2,{"$f":"$C$5*B6","v":335000},{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C6*'BE Analysis'!$Q$26","v":177500},494633,-159633,10]
[null,3,502500,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C7*'BE Analysis'!$Q$26","v":266250},583383,-80883,20]
[null,4,670000,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C8*'BE Analysis'!$Q$26","v":355000},672133,-2133,30]
[null,5,837500,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C9*'BE Analysis'!$Q$26","v":443750},760883,76617,40]
[null,6,1005000,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C10*'BE Analysis'!$Q$26","v":532500},849633,155367,50]
[null,7,1172500,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C11*'BE Analysis'!$Q$26","v":621250},938383,234117,60]
[null,8,1340000,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C12*'BE Analysis'!$Q$26","v":710000},1027133,312867,70]
[null,9,1507500,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C13*'BE Analysis'!$Q$26","v":798750},1115883,391617,80]
[null,10,1675000,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C14*'BE Analysis'!$Q$26","v":887500},1204633,470367,90]
[null,11,1842500,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C15*'BE Analysis'!$Q$26","v":976250},1293383,549117,100]
[null,12,2010000,{"$f":"'BE Analysis'!$Q$24","v":317133},{"$f":"C16*'BE Analysis'!$Q$26","v":1065000},1382133,627867,110]
[]
[null,"MONTHS","REVENUE","FIXED\nCOSTS","VARIABLE\nCOSTS","TOTAL\nCOSTS","TOTAL\nPROFIT","X AXIS"]
[null,0,{"$f":"B19*'BE Analysis'!$S$29","v":0},{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"'BE Analysis'!$S$24*B19","v":0},{"$f":"E19+D19","v":317133},{"$f":"C19-F19","v":-317133}]
[null,1,{"$f":"'BE Analysis'!S23/$B$16","v":199316.66666666666},{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C20*'BE Analysis'!$S$26","v":78750},395883,-196566.33333333334,0]
[null,2,{"$f":"$C$20*B21","v":398633.33333333331},{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C21*'BE Analysis'!$S$26","v":157500},474633,-75999.666666666686,10]
[null,3,597950,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C22*'BE Analysis'!$S$26","v":236250},553383,44567,20]
[null,4,797266.66666666663,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C23*'BE Analysis'!$S$26","v":315000},632133,165133.66666666663,30]
[null,5,996583.33333333326,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C24*'BE Analysis'!$S$26","v":393749.99999999994},710883,285700.33333333326,40]
[null,6,1195900,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C25*'BE Analysis'!$S$26","v":472500},789633,406267,50]
[null,7,1395216.6666666665,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C26*'BE Analysis'!$S$26","v":551249.99999999988},868382.99999999988,526833.66666666663,60]
[null,8,1594533.3333333333,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C27*'BE Analysis'!$S$26","v":630000},947133,647400.33333333326,70]
[null,9,1793850,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C28*'BE Analysis'!$S$26","v":708750},1025883,767967,80]
[null,10,1993166.6666666665,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C29*'BE Analysis'!$S$26","v":787499.99999999988},1104633,888533.66666666651,90]
[null,11,2192483.333333333,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C30*'BE Analysis'!$S$26","v":866249.99999999988},1183383,1009100.333333333,100]
[null,12,2391800,{"$f":"'BE Analysis'!$S$24","v":317133},{"$f":"C31*'BE Analysis'!$S$26","v":945000},1262133,1129667,110]