{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Service Business.","Manufacturing Business"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Service Business.","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"merged":[[1,1,3,2],[5,1,6,6],[7,4,8,5],[8,1,8,2],[9,5,9,6],[10,5,10,6],[16,5,17,5],[24,5,25,5],[24,6,25,6]],"flags":["formulas_cached_only"]}
[]
[null,{"$error":"#VALUE!"}]
[{"$nulls":4},"Service business costing and pricing"]
[]
[]
[null,"Calculate your projected monthly charge out hours. Ensure that you take into consideration that as a small business owner some of your time will be spent doing other things bsides just selling time. Be realistic when you calculate how many hours you can charge out every month."]
[]
[{"$nulls":4},"Insert your projected monthly business expenses in this table"]
[null,"Monthly Fixed Expenses"]
[null,"Accounting fees","…………",{"v":50,"d":"$50"},null,"Total fixed expenses ÷ Number of charge out hours"]
[null,"Advertising","…………",{"v":200,"d":"$200"},null,"= Mininimum Charge Out Rate"]
[null,"Bank charges","…………",{"v":45,"d":"$45"}]
[null,"Owner's drawings","…………",{"v":10000,"d":"$10,000"},null,"Number of projected charge out hours ……….",120]
[null,"Hydro","…………",{"v":100,"d":"$100"}]
[null,"Internet","…………",{"v":85,"d":"$85"},null,"Minimum Hourly Rate …………………………..",{"v":95.5,"d":"$96"}]
[null,"Employee benefits","…………",{"v":0,"d":"$0"},null,"Market Price …………………………………….",{"v":60,"d":"$60"}]
[null,"Petty cash","…………",{"v":100,"d":"$100"},null,"Note: If you increase your charge out rate your break even number of hours will come down."]
[null,"Insurance","…………",{"v":175,"d":"$175"}]
[null,"Rent","…………",{"v":400,"d":"$400"},null,"My Price per Hour ………………………………",{"v":100,"d":"$100"}]
[null,"Stationery","…………",{"v":30,"d":"$30"}]
[null,"Telephone and cell phone","…………",{"v":230,"d":"$230"},null,"Monthly Survival Break Even"]
[null,"Salaries","…………",{"v":0,"d":"$0"}]
[null,"Depreciation","…………",{"v":45,"d":"$45"},null,"Charge out rate ………………………………….",{"v":100,"d":"$100"}]
[null,"Interest on loan","…………",{"v":0,"d":"$0"}]
[null,"Other expenses","…………",{"v":0,"d":"$0"},null,"Number of hours to need to sell each month to survive:",{"v":114.6,"d":"115"}]
[null,"Other expenses","…………",{"v":0,"d":"$0"}]
[null,null,"Total fixed expenses:",{"v":11460,"d":"$11,460"}]

{"sheet":"Manufacturing Business","index":1,"n_rows":50,"n_cols":8,"rows_kept":50,"merged":[[1,2,3,2],[5,2,6,7],[8,2,8,4],[8,6,8,7],[29,1,29,8],[43,1,43,8]],"flags":["formulas_cached_only"]}
[]
[null,null,"logo"]
[{"$nulls":4},"Manufacturing business costing and pricing"]
[]
[]
[null,null,"Use this table to calculate a fair price for your products. To ensure these numbers are accurate do as much research as possible. Speak to business owners in similar industries to assist you in doing your projections."]
[]
[{"$nulls":3},"List your projected expenses"]
[null,null,"Monthly Fixed Expenses",{"$nulls":3},"Variable Expenses Per Unit"]
[null,null,"Bookkeeper",null,{"v":100,"d":"$100.00"},null,"Chocolate",{"v":0.05,"d":"$0.05"}]
[null,null,"Advertising & promotion",null,{"v":300,"d":"$300.00"},null,"Nuts",{"v":0.05,"d":"$0.05"}]
[null,null,"Bank charges",null,{"v":30,"d":"$30.00"},null,"Labels",{"v":0.1,"d":"$0.10"}]
[null,null,"Owner's salary",null,{"v":3000,"d":"$3,000.00"},null,"Packaging",0]
[null,null,"Employees' salaries & wages",null,{"v":2800,"d":"$2,800.00"},null,"Other expenses",0]
[null,null,"Utilities (heat, hydro & water)",null,{"v":400,"d":"$400.00"},null,"Other expenses",0]
[null,null,"Vehicle expenses",null,{"v":300,"d":"$300.00"},null,"Other expenses",0]
[null,null,"Insurance",null,{"v":160,"d":"$160.00"},null,"Other expenses",0]
[null,null,"Leases",null,{"v":100,"d":"$100.00"},null,"Other expenses",0]
[null,null,"Repairs & maintenance",null,{"v":100,"d":"$100.00"},null,"Other expenses",0]
[null,null,"Rent",null,{"v":1200,"d":"$1,200.00"},null,"Other expenses",0]
[null,null,"Telephone & cell phone",null,{"v":125,"d":"$125.00"},null,"Other expenses",0]
[null,null,"Equipment depreciation",null,{"v":100,"d":"$100.00"},null,"Other expenses",0]
[null,null,"Interest on loans",null,{"v":10,"d":"$10.00"},null,"Other expenses",0]
[null,null,"Other expenses",null,0,null,"Other expenses",0]
[null,null,"Other expenses",null,0,null,"Other expenses",0]
[null,null,"Other expenses",null,0,null,"Other expenses",0]
[null,null,"Other expenses",null,0,null,"Other expenses",0]
[null,null,"Total Fixed Expenses:",null,{"v":8725,"d":"$8,725.00"},null,"Total Variable Expenses:",{"v":0.2,"d":"$0.20"}]
[]
[null,"Gross Margin Calculation"]
[]
[{"$nulls":3},"Projected number of production units:",{"v":10000,"d":"10,000"},null,"Fixed expense per product:",{"v":0.8725,"d":"$0.87"}]
[]
[null,null,"Insert your projected production capacity",{"$nulls":3},"Fixed expense per product = Total Fixed Expenses ÷ Production Units"]
[]
[{"$nulls":3},"Selling price per unit:",{"v":1.25,"d":"$1.25"},null,"Total variable cost:",{"v":0.2,"d":"$0.20"}]
[]
[{"$nulls":3},"Gross margin:",{"v":1.05,"d":"$1.05"}]
[{"$nulls":4},"Note: Gross margin = Selling price - Variable cost per unit",null,"True cost of each product:",{"v":1.0725,"d":"$1.07"}]
[{"$nulls":3},"Gross Margin %:",{"v":0.8400000000000001,"d":"84%"}]
[{"$nulls":4},"(Selling Price  - Cost Price) / Selling Price X 100 = Gross Margin %",null,"This is the minimum price you can charge for each product provided you produce the projected number of units"]
[]
[]
[null,"Break Even Analysis","Break even"]
[]
[null,null,"Fixed Expenses ÷ Gross Margin % =",null,"Break Even Point"]
[]
[{"$nulls":3},"Break even revenue:",{"v":10386.904761904761,"d":"$10,386.90"}]
[]
[{"$nulls":3},"Break even number of products:",{"v":8309.52380952381,"d":"8,310"},null,"Need to be sold to break-even"]