{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Chart BE","break-even","break-even-ana","break-even price increase","Profit max"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Chart BE","index":0,"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"}

{"sheet":"break-even","index":1,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"variable","value","description",null,"volume","cost","revenue",null,"element","from","to"]
[null,"cf=",10000,"fixed cost per month",null,0,{"$f":"$C$2+$C$3*F2","v":10000},{"$f":"$C$4*F2","v":0},null,"volume",0,1200]
[null,"cv=",8,"variable cost per unit",null,1200,{"$f":"$C$2+$C$3*F3","v":19600},{"$f":"$C$4*F3","v":27600},null,"cost",{"$f":"$C$2+$C$3*K2","v":10000},{"$f":"$C$2+$C$3*L2","v":19600}]
[null,"p=",23,"price per unit",null,null,null,null,null,"revenue",{"$f":"$C$4*K2","v":0},{"$f":"$C$4*L2","v":27600}]
[null,"v=",600,"current volume"]
[]
[null,"vb=",{"$f":"C2/(C4-C3)","v":666.66666666666663},"break-even point"]

{"sheet":"break-even-ana","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"variable","value","description",null,"volume","cost","revenue"]
[null,"cf=",10000,"fixed cost per month",null,0,{"$f":"$C$2+$C$3*F2","v":10000},{"$f":"$C$4*F2","v":0}]
[null,"cv=",8,"variable cost per unit",null,1200,{"$f":"$C$2+$C$3*F3","v":19600},{"$f":"$C$4*F3","v":27600}]
[null,"p=",23,"price per unit"]
[null,"v=",600,"current volume"]
[]
[null,"vb=",{"$f":"C2/(C4-C3)","v":666.66666666666663},"break-even point"]
[]
["lower cost",null,-0.1]
[null,"variable","value","description"]
[null,"cf=",{"$f":"C2*(1+C9)","v":9000},"fixed cost per month"]
[null,"cv=",{"$f":"C3*(1+C9)","v":7.2},"variable cost per unit"]
[null,"p=",23,"price per unit"]
[null,"v=",600,"current volume"]
[]
[null,"vb=",{"$f":"C11/(C13-C12)","v":569.62025316455697},"break-even point",{"$f":"C16/$C$7","v":0.85443037974683556},{"$f":"1-E16","v":0.14556962025316444}]
[]
["higher cost",null,0.1]
[null,"variable","value","description"]
[null,"cf=",{"$f":"C2*(1+C18)","v":11000},"fixed cost per month"]
[null,"cv=",{"$f":"C3*(1+C18)","v":8.8000000000000007},"variable cost per unit"]
[null,"p=",23,"price per unit"]
[null,"v=",600,"current volume"]
[]
[null,"vb=",{"$f":"C20/(C22-C21)","v":774.64788732394368},"break-even point",{"$f":"C25/$C$7","v":1.1619718309859155},{"$f":"E25-1","v":0.1619718309859155}]

{"sheet":"break-even price increase","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"variable","value","description",null,"percentage","price","break-even points"]
[null,"cf=",10000,"fixed cost per month",null,0,{"$f":"$C$4*(1+F2)","v":23},{"$f":"C2/(C4-C3)","v":666.66666666666663}]
[null,"cv=",8,"variable cost per unit",null,0.1,{"$f":"$C$4*(1+F3)","v":25.3},{"$f":"breakEvenPoint($C$2,$C$3,G3)","v":578.03468208092488}]
[null,"p=",23,"price per unit",null,0.2,27.599999999999998,{"$f":"breakEvenPoint($C$2,$C$3,G4)","v":510.20408163265301}]
[null,"v=",600,"current volume",null,0.3,29.900000000000002,456.62100456621005]
[null,null,null,null,null,0.4,32.199999999999996,413.22314049586777]
[null,"vb=",{"$f":"C2/(C4-C3)","v":666.66666666666663},"break-even point",null,0.5,34.5,377.35849056603774]
[null,null,null,null,null,0.6,36.800000000000004,347.22222222222223]
[null,null,null,null,null,0.7,39.1,321.54340836012858]
[null,null,null,null,null,0.8,41.4,299.40119760479041]
[null,null,null,null,null,0.9,43.699999999999996,280.11204481792714]
[null,null,null,null,null,1,46,263.15789473684208]

{"sheet":"Profit max","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,5,2,8],[6,5,6,8]]}
[]
["Motor-cycle"]
[null,"var","value","description",null,"Ojbective"]
[null,"c=",5,"cost per item",null,"profit/item","profit"]
[null,"p=",20,"price per item",null,{"$f":"C5-C4","v":15},{"$f":"F5*G9","v":375}]
[null,"a=",4,"material required per item"]
[null,"b=",100,"material limit",null,"Constraint-material"]
[null,null,null,null,null,"required","volume","used","limit"]
[null,"v=",{"$f":"C7/C6","v":25},"items",null,{"$f":"C6","v":4},25,{"$f":"F9*G9","v":100},{"$f":"C7","v":100}]