{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Inputs","Fixed Costs","Product 1","Product 2","Product 3","Product 4","Summary Results","Summary Results - Charts"],"not_rendered":{"charts":10,"images":3,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":"1904"}

{"sheet":"Inputs","index":0,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Inputs Worksheet"]
[]
[null,"= Manual Input"]
[null,"= Formula"]
[]
[]
[]
[null,null,"Percent of Sales \n(Must Equal 100% Exactly)","Product Name"]
[null,"Product 1:",0.2,"Widgets"]
[null,"Product 2:",0.3,"Bangles"]
[null,"Product 3:",0.4,"Notions"]
[null,"Product 4:",0.1,"Potions"]
[null,"Total",{"$f":"IF(SUM(C11:C14)<>1,\"Product Mix Above Doesn't Add to 100%\",SUM(C11:C14))","v":1}]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS:","Enter values and names in the yellow cells on each of the worksheets.  \nThere is no information to enter on the \"Summary Results\" worksheet. Worksheets protected, but no password required."]
[]
[]
[null,"Version Date:","2014-10-15"]

{"sheet":"Fixed Costs","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Fixed Costs Worksheet"]
[]
[null,"INSTRUCTIONS:"]
[null,"Use this sheet to enter in estimated monthly fixed costs for the business."]
[null,"Add rows if necessary above the \"TOTAL FIXED COSTS\" row."]
[]
[null,"= Manual Input"]
[null,"= Formula"]
[]
[null,"MONTHLY FIXED COSTS:"]
[null,"Rent"]
[null,"Utilities"]
[null,"Advertising"]
[null,"Insurance"]
[null,"Bank Fees"]
[null,"Auto"]
[null,"Loan Payment"]
[null,"Owner Draw"]
[null,"Miscellaneous"]
[null,"Other - 1"]
[null,"Other - 2"]
[null,"Other - 3"]
[null,"Other - 4"]
[null,"TOTAL FIXED COSTS",{"$f":"SUM(C13:C25)","v":0}]

{"sheet":"Product 1","index":2,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Product 1 Break-Even Analysis"]
[]
[null,"BREAK-EVEN ANALYSIS"]
[null,"Gross Profit = Price - Total Variable Cost",null,null,"= Manual Input"]
[null,"Gross Profit Margin = Gross Profit ÷ Price",null,null,"= Formula"]
[null,"Break-even = Total Fixed Costs ÷ Gross Profit Margin"]
[null,"ONLY ENTER DATA IN HIGHLIGHTED FIELDS"]
[null,"% Contribution means:  what percentage does this product contribute to overall sales?"]
[]
[null,"PRODUCT 1 NAME:",{"$f":"IF(Prod1Name=\"\",\"Enter Product 1 Name on Inputs Worksheet\",Prod1Name)","v":"Widgets"}]
[]
[null,"PRODUCT 1 SALES PRICE:",null,"% CONTRIBUTION PRODUCT 1:",{"$f":"Prod1MixPercent","v":0.2}]
[null,null,null,"(will total 100% among all prods)"]
[null,"VARIABLE COSTS PRODUCT 1:"]
[null,"Cost #1 (enter specifics)"]
[null,"Cost #2 (enter specifics)"]
[null,"Cost #3 (enter specifics)"]
[null,"Cost #4 (enter specifics)"]
[null,"Cost #5 (enter specifics)"]
[null,"Cost #6 (enter specifics)"]
[null,"TOTAL VARIABLE COSTS",{"$f":"SUM(C17:C22)","v":0}]
[]
[null,"GROSS PROFIT",{"$f":"IFERROR(C14-C23,\"Enter a Price for Product 1 Above\")","v":0}]
[null,"GROSS PROFIT MARGIN",{"$f":"IF(ISERROR(C25/C14),\"Missing Data Above\",C25/C14)","v":"Missing Data Above"}]
[]
[null,"TOTAL FIXED COSTS",{"$f":"FixedCostTotal","v":0}]
[null,"% Contribution",{"$f":"E14","v":0.2}]
[null,"PORTION OF FIXED COSTS",{"$f":"C29*C28","v":0}]
[]
[null,"BREAK EVEN (in Total Dollars)",{"$f":"IF(C26=\"Missing Data Above\",\"Missing Data Above\",C30/C26)","v":"Missing Data Above"}]
[]
[null,"BREAK EVEN (in units)",{"$f":"IF(C26=\"Missing Data Above\",\"Missing Data Above\",C32/C14)","v":"Missing Data Above"}]

{"sheet":"Product 2","index":3,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Product 2 Break-Even Analysis"]
[]
[null,"BREAK-EVEN ANALYSIS"]
[null,"Gross Profit = Price - Total Variable Cost",null,null,"= Manual Input"]
[null,"Gross Profit Margin = Gross Profit ÷ Price",null,null,"= Formula"]
[null,"Break-even = Total Fixed Costs ÷ Gross Profit Margin"]
[null,"ONLY ENTER DATA IN HIGHLIGHTED FIELDS"]
[null,"% Contribution means:  what percentage does this product contribute to overall sales?"]
[]
[null,"PRODUCT 2 NAME:",{"$f":"IF(Prod2Name=\"\",\"Enter Product 2 Name on Inputs Worksheet\",Prod2Name)","v":"Bangles"}]
[]
[null,"PRODUCT 2 SALES PRICE:",null,"% CONTRIBUTION PRODUCT 2:",{"$f":"Prod2MixPercent","v":0.3}]
[null,null,null,"(will total 100% among all prods)"]
[null,"VARIABLE COSTS PRODUCT 2:"]
[null,"Cost #1 (enter specifics)"]
[null,"Cost #2 (enter specifics)"]
[null,"Cost #3 (enter specifics)"]
[null,"Cost #4 (enter specifics)"]
[null,"Cost #5 (enter specifics)"]
[null,"Cost #6 (enter specifics)"]
[null,"TOTAL VARIABLE COSTS",{"$f":"SUM(C17:C22)","v":0}]
[]
[null,"GROSS PROFIT",{"$f":"IFERROR(C14-C23,\"Enter a Price for Product 1 Above\")","v":0}]
[null,"GROSS PROFIT MARGIN",{"$f":"IF(ISERROR(C25/C14),\"Missing Data Above\",C25/C14)","v":"Missing Data Above"}]
[]
[null,"TOTAL FIXED COSTS",{"$f":"FixedCostTotal","v":0}]
[null,"% Contribution",{"$f":"E14","v":0.3}]
[null,"PORTION OF FIXED COSTS",{"$f":"C29*C28","v":0}]
[]
[null,"BREAK EVEN (in Total Dollars)",{"$f":"IF(C26=\"Missing Data Above\",\"Missing Data Above\",C30/C26)","v":"Missing Data Above"}]
[]
[null,"BREAK EVEN (in units)",{"$f":"IF(C26=\"Missing Data Above\",\"Missing Data Above\",C32/C14)","v":"Missing Data Above"}]

{"sheet":"Product 3","index":4,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Product 3 Break-Even Analysis"]
[]
[null,"BREAK-EVEN ANALYSIS"]
[null,"Gross Profit = Price - Total Variable Cost",null,null,"= Manual Input"]
[null,"Gross Profit Margin = Gross Profit ÷ Price",null,null,"= Formula"]
[null,"Break-even = Total Fixed Costs ÷ Gross Profit Margin"]
[null,"ONLY ENTER DATA IN HIGHLIGHTED FIELDS"]
[null,"% Contribution means:  what percentage does this product contribute to overall sales?"]
[]
[null,"PRODUCT 3 NAME:",{"$f":"IF(Prod3Name=\"\",\"Enter Product 3 Name on Inputs Worksheet\",Prod3Name)","v":"Notions"}]
[]
[null,"PRODUCT 3 SALES PRICE:",null,"% CONTRIBUTION PRODUCT 3:",{"$f":"Prod3MixPercent","v":0.4}]
[null,null,null,"(will total 100% among all prods)"]
[null,"VARIABLE COSTS PRODUCT 3:"]
[null,"Cost #1 (enter specifics)"]
[null,"Cost #2 (enter specifics)"]
[null,"Cost #3 (enter specifics)"]
[null,"Cost #4 (enter specifics)"]
[null,"Cost #5 (enter specifics)"]
[null,"Cost #6 (enter specifics)"]
[null,"TOTAL VARIABLE COSTS",{"$f":"SUM(C17:C22)","v":0}]
[]
[null,"GROSS PROFIT",{"$f":"IFERROR(C14-C23,\"Enter a Price for Product 1 Above\")","v":0}]
[null,"GROSS PROFIT MARGIN",{"$f":"IF(ISERROR(C25/C14),\"Missing Data Above\",C25/C14)","v":"Missing Data Above"}]
[]
[null,"TOTAL FIXED COSTS",{"$f":"FixedCostTotal","v":0}]
[null,"% Contribution",{"$f":"E14","v":0.4}]
[null,"PORTION OF FIXED COSTS",{"$f":"C29*C28","v":0}]
[]
[null,"BREAK EVEN (in Total Dollars)",{"$f":"IF(C26=\"Missing Data Above\",\"Missing Data Above\",C30/C26)","v":"Missing Data Above"}]
[]
[null,"BREAK EVEN (in units)",{"$f":"IF(C26=\"Missing Data Above\",\"Missing Data Above\",C32/C14)","v":"Missing Data Above"}]

{"sheet":"Product 4","index":5,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Product 4 Break-Even Analysis"]
[]
[null,"BREAK-EVEN ANALYSIS"]
[null,"Gross Profit = Price - Total Variable Cost",null,null,"= Manual Input"]
[null,"Gross Profit Margin = Gross Profit ÷ Price",null,null,"= Formula"]
[null,"Break-even = Total Fixed Costs ÷ Gross Profit Margin"]
[null,"ONLY ENTER DATA IN HIGHLIGHTED FIELDS"]
[null,"% Contribution means:  what percentage does this product contribute to overall sales?"]
[]
[null,"PRODUCT 4 NAME:",{"$f":"IF(Prod4Name=\"\",\"Enter Product 4 Name on Inputs Worksheet\",Prod4Name)","v":"Potions"}]
[]
[null,"PRODUCT 4 SALES PRICE:",null,"% CONTRIBUTION PRODUCT 4:",{"$f":"Prod4MixPercent","v":0.1}]
[null,null,null,"(will total 100% among all prods)"]
[null,"VARIABLE COSTS PRODUCT 4:"]
[null,"Cost #1 (enter specifics)"]
[null,"Cost #2 (enter specifics)"]
[null,"Cost #3 (enter specifics)"]
[null,"Cost #4 (enter specifics)"]
[null,"Cost #5 (enter specifics)"]
[null,"Cost #6 (enter specifics)"]
[null,"TOTAL VARIABLE COSTS",{"$f":"SUM(C17:C22)","v":0}]
[]
[null,"GROSS PROFIT",{"$f":"IFERROR(C14-C23,\"Enter a Price for Product 1 Above\")","v":0}]
[null,"GROSS PROFIT MARGIN",{"$f":"IF(ISERROR(C25/C14),\"Missing Data Above\",C25/C14)","v":"Missing Data Above"}]
[]
[null,"TOTAL FIXED COSTS",{"$f":"FixedCostTotal","v":0}]
[null,"% Contribution",{"$f":"E14","v":0.1}]
[null,"PORTION OF FIXED COSTS",{"$f":"C29*C28","v":0}]
[]
[null,"BREAK EVEN (in Total Dollars)",{"$f":"IF(C26=\"Missing Data Above\",\"Missing Data Above\",C30/C26)","v":"Missing Data Above"}]
[]
[null,"BREAK EVEN (in units)",{"$f":"IF(C26=\"Missing Data Above\",\"Missing Data Above\",C32/C14)","v":"Missing Data Above"}]

{"sheet":"Summary Results","index":6,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Summary Results"]
[]
[null,null,"= Formula"]
[]
[null,null,null,"Product","Selling Price per Unit","Gross Profit per Unit Sold","Gross Profit Margin %","Percent Contribution","Break-Even Sales in Units"]
[null,null,null,{"$f":"'Product 1'!C12","v":"Widgets"},{"$f":"'Product 1'!C14","v":0},{"$f":"'Product 1'!C25","v":0},{"$f":"'Product 1'!C26","v":"Missing Data Above"},{"$f":"'Product 1'!E14","v":0.2},{"$f":"'Product 1'!C34","v":"Missing Data Above"}]
[null,null,null,{"$f":"'Product 2'!C12","v":"Bangles"},{"$f":"'Product 2'!C14","v":0},{"$f":"'Product 2'!C25","v":0},{"$f":"'Product 2'!C26","v":"Missing Data Above"},{"$f":"'Product 2'!E14","v":0.3},{"$f":"'Product 2'!C34","v":"Missing Data Above"}]
[null,null,null,{"$f":"'Product 3'!C12","v":"Notions"},{"$f":"'Product 3'!C14","v":0},{"$f":"'Product 3'!C25","v":0},{"$f":"'Product 3'!C26","v":"Missing Data Above"},{"$f":"'Product 3'!E14","v":0.4},{"$f":"'Product 3'!C34","v":"Missing Data Above"}]
[null,null,null,{"$f":"'Product 4'!C12","v":"Potions"},{"$f":"'Product 4'!C14","v":0},{"$f":"'Product 4'!C25","v":0},{"$f":"'Product 4'!C26","v":"Missing Data Above"},{"$f":"'Product 4'!E14","v":0.1},{"$f":"'Product 4'!C34","v":"Missing Data Above"}]
[]
[]
[null,null,null,null,"Total Fixed Costs:",{"$f":"FixedCostTotal","v":0}]
[null,null,null,null,"Total Contribution:",{"$f":"(F8*I8)+(F9*I9)+(F10*I10)+(F11*I11)","v":{"$error":"#VALUE!"}},"NOTE: Value will likely not exactly match total fixed costs total due to whole number rounding on break-even unit sales."]
[null,null,null,null,"Rounding Error:",{"$f":"F14-F15","v":{"$error":"#VALUE!"}}]

{"sheet":"Summary Results - Charts","index":7,"n_rows":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Click Button to Print Results"]
[null,null,"= Formula"]
[]
[]
[]
[null,"Summary Results - Charts"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Product","Selling Price per Unit","Gross Profit per Unit Sold","Gross Profit Margin %","Percent Contribution","Break-Even Sales in Units"]
[null,{"$f":"'Product 1'!C12","v":"Widgets"},{"$f":"'Product 1'!C14","v":0},{"$f":"'Product 1'!C25","v":0},{"$f":"'Product 1'!C26","v":"Missing Data Above"},{"$f":"'Product 1'!E14","v":0.2},{"$f":"'Product 1'!C34","v":"Missing Data Above"}]
[null,{"$f":"'Product 2'!C12","v":"Bangles"},{"$f":"'Product 2'!C14","v":0},{"$f":"'Product 2'!C25","v":0},{"$f":"'Product 2'!C26","v":"Missing Data Above"},{"$f":"'Product 2'!E14","v":0.3},{"$f":"'Product 2'!C34","v":"Missing Data Above"}]
[null,{"$f":"'Product 3'!C12","v":"Notions"},{"$f":"'Product 3'!C14","v":0},{"$f":"'Product 3'!C25","v":0},{"$f":"'Product 3'!C26","v":"Missing Data Above"},{"$f":"'Product 3'!E14","v":0.4},{"$f":"'Product 3'!C34","v":"Missing Data Above"}]
[null,{"$f":"'Product 4'!C12","v":"Potions"},{"$f":"'Product 4'!C14","v":0},{"$f":"'Product 4'!C25","v":0},{"$f":"'Product 4'!C26","v":"Missing Data Above"},{"$f":"'Product 4'!E14","v":0.1},{"$f":"'Product 4'!C34","v":"Missing Data Above"}]