{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Product Profitability","Summary Metrics"],"not_rendered":{"charts":1,"macros":1,"external_links":1,"defined_names":24},"unopened":[{"sheet":"Summary Metrics","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Product Profitability","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Product Profitability Analysis"]
[null,"[Date]"]
[]
[null,"Dark gray cells will be calculated for you. You do not need to enter anything into them."]
[]
[null,"[Product Name]"," "," "," "," "," "]
[null,"Inventory Movement","Q1","Q2","Q3","Q4","Annual"]
[null,"Number of units in inventory—Beginning of period",{"v":1200,"d":"1,200 "},{"v":1100,"d":"1,100 "},{"v":1300,"d":"1,300 "},{"v":1600,"d":"1,600 "},{"v":1200,"d":"1,200 "}]
[null,"Production",{"v":700,"d":"700 "},{"v":800,"d":"800 "},{"v":800,"d":"800 "},{"v":600,"d":"600 "},{"v":2900,"d":"2,900 "}]
[null,"Units sold",{"v":800,"d":"800 "},{"v":600,"d":"600 "},{"v":500,"d":"500 "},{"v":750,"d":"750 "},{"v":2650,"d":"2,650 "}]
[null,"Number of units in inventory—End of period",{"v":1100,"d":"1,100 "},{"v":1300,"d":"1,300 "},{"v":1600,"d":"1,600 "},{"v":1450,"d":"1,450 "},{"v":1450,"d":"1,450 "}]
[]
[null,"Profitability Analysis","Q1   ","Q2   ","Q3   ","Q4   "]
[null,"Product revenue",{"v":400000,"d":"$400,000"},{"v":425000,"d":"$425,000"},{"v":285000,"d":"$285,000"},{"v":395000,"d":"$395,000"},{"v":1505000,"d":"$1,505,000"}]
[]
[null,"Cost of Goods Sold","Q1","Q2","Q3","Q4","Annual"]
[null,"Material costs",{"v":90000,"d":"$90,000"},{"v":80000,"d":"$80,000"},{"v":80000,"d":"$80,000"},{"v":75000,"d":"$75,000"},{"v":325000,"d":"$325,000"}]
[null,"Labor costs",{"v":120000,"d":"120,000 "},{"v":120000,"d":"120,000 "},{"v":115000,"d":"115,000 "},{"v":110000,"d":"110,000 "},{"v":465000,"d":"465,000 "}]
[null,"Logistics costs",{"v":45000,"d":"45,000 "},{"v":40000,"d":"40,000 "},{"v":35000,"d":"35,000 "},{"v":45000,"d":"45,000 "},{"v":165000,"d":"165,000 "}]
[null,"Other direct costs",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total cost of goods sold",{"v":255000,"d":"$255,000"},{"v":240000,"d":"$240,000"},{"v":230000,"d":"$230,000"},{"v":230000,"d":"$230,000"},{"v":955000,"d":"$955,000"}]
[]
[null,"Gross margin",{"v":145000,"d":"$145,000"},{"v":185000,"d":"$185,000"},{"v":55000,"d":"$55,000"},{"v":165000,"d":"$165,000"},{"v":550000,"d":"$550,000"}]
[null,"Margin contribution percentage",{"v":0.3625,"d":"36.3%"},{"v":0.43529411764705883,"d":"43.5%"},{"v":0.19298245614035087,"d":"19.3%"},{"v":0.4177215189873418,"d":"41.8%"},{"v":0.3654485049833887,"d":"36.5%"}]
[]
[null,"Indirect Product Costs","Q1","Q2","Q3","Q4","Annual"]
[null,"Product marketing",{"v":60000,"d":"$60,000"},{"v":60000,"d":"$60,000"},{"v":60000,"d":"$60,000"},{"v":60000,"d":"$60,000"},{"v":240000,"d":"$240,000"}]
[null,"Other indirect product costs",{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":30000,"d":"30,000 "},{"v":105000,"d":"105,000 "}]
[null,"Total other product costs",{"v":85000,"d":"$85,000"},{"v":85000,"d":"$85,000"},{"v":85000,"d":"$85,000"},{"v":90000,"d":"$90,000"},{"v":345000,"d":"$345,000"}]
[]
[null,"Quarterly product profit (loss)",{"v":60000,"d":"$60,000"},{"v":100000,"d":"$100,000"},{"v":-30000,"d":"($30,000)"},{"v":75000,"d":"$75,000"},{"v":205000,"d":"$205,000"}]
[]
[null,"Summary Metrics","Q1","Q2","Q3","Q4","Annual"]
[null,"Average sales price per unit sold",{"v":500,"d":"$500.00"},{"v":708.3333333333334,"d":"$708.33"},{"v":570,"d":"$570.00"},{"v":526.6666666666666,"d":"$526.67"},{"v":567.9245283018868,"d":"$567.92"}]
[null,"Material cost per unit produced",{"v":128.57142857142858,"d":"$128.57"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":125,"d":"$125.00"},{"v":112.06896551724138,"d":"$112.07"}]
[null,"Labor cost per unit produced",{"v":171.42857142857142,"d":"$171.43"},{"v":150,"d":"$150.00"},{"v":143.75,"d":"$143.75"},{"v":183.33333333333334,"d":"$183.33"},{"v":160.3448275862069,"d":"$160.34"}]