{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BEP"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":12,"comments":0,"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":"BEP","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
[]
["Таблица значений"]
["Отклонение от точки безубыточности (∆Q), %","Объем продаж  (Q), шт. ","Переменные затраты (VC), руб.","Постоянные затраты (FC), руб.","Общие затраты (TC), руб.","Выручка (S), руб.","Прибыль (Pr), руб.","Рентабельность продаж (ROS), %"]
["-"," = Qbep * (1+∆Q)"," = C * Q"," = FC"," = FC + C * Q"," = P * Q"," = S - TC"," = Pr / S"]
[{"$f":"A6-($A$13-$A$9)/(ROW($A$13)-ROW($A$9))","v":-0.28999999999999998},{"$f":"$B$9*(1+A5)","v":282.87128205128204},{"$f":"B5*$B$20","v":7920.3958974358975},{"$f":"$B$23","v":15538},{"$f":"D5+C5","v":23458.395897435897},{"$f":"B5*$B$17","v":18952.375897435897},{"$f":"F5-E5","v":-4506.0200000000004},{"$f":"IFERROR(G5/F5,)","v":-0.23775488753416021}]
[{"$f":"A7-($A$13-$A$9)/(ROW($A$13)-ROW($A$9))","v":-0.21749999999999997},{"$f":"$B$9*(1+A6)","v":311.75602564102564},8729.168717948718,15538,{"$f":"D6+C6","v":24267.16871794872},20887.653717948717,{"$f":"F6-E6","v":-3379.5150000000031},{"$f":"IFERROR(G6/F6,)","v":-0.16179485956797499}]
[{"$f":"A8-($A$13-$A$9)/(ROW($A$13)-ROW($A$9))","v":-0.14499999999999999},{"$f":"$B$9*(1+A7)","v":340.64076923076919},9537.9415384615368,15538,25075.941538461535,22822.931538461537,-2253.0099999999984,-9.8716941607750658E-2]
[{"$f":"A9-($A$13-$A$9)/(ROW($A$13)-ROW($A$9))","v":-7.2499999999999995E-2},{"$f":"$B$9*(1+A8)","v":369.5255128205128},10346.714358974359,15538,{"$f":"D8+C8","v":25884.714358974357},24758.209358974356,{"$f":"F8-E8","v":-1126.505000000001},{"$f":"IFERROR(G8/F8,)","v":-4.550026149575577E-2}]
[0,{"$f":"B23/(B17-B20)","v":398.41025641025641},11155.48717948718,15538,26693.48717948718,26693.48717948718,0,0]
[{"$f":"A9+($A$13-$A$9)/(ROW($A$13)-ROW($A$9))","v":7.2499999999999995E-2},{"$f":"$B$9*(1+A10)","v":427.29500000000002},11964.26,15538,27502.260000000002,28628.764999999999,1126.5049999999974,3.9348710990501946E-2]
[{"$f":"A10+($A$13-$A$9)/(ROW($A$13)-ROW($A$9))","v":0.14499999999999999},{"$f":"$B$9*(1+A11)","v":456.17974358974362},12773.032820512821,15538,{"$f":"D11+C11","v":28311.032820512821},30564.042820512823,{"$f":"F11-E11","v":2253.010000000002},{"$f":"IFERROR(G11/F11,)","v":7.3714397445089022E-2}]
[0.21749999999999997,485.06448717948717,13581.805641025641,15538,29119.805641025639,32499.320641025639,3379.5149999999994,0.10398725060528977]
[{"$f":"B26/100","v":0.28999999999999998},{"$f":"$B$9*(1+A13)","v":513.94923076923078},14390.578461538462,15538,29928.578461538462,34434.598461538466,4506.0200000000041,0.13085734120097198]
[]
[]
[null,"Цена реализации (P), руб/шт"]
[null,67,50,null,null,null,null,70]
[]
[null,"Себестоимость (С), руб/шт"]
[null,28,25,null,null,null,null,45]
[]
[null,"Постоянные затраты (FC), руб."]
[null,15538,14000,null,null,null,null,18000]
[]
[null,"Отклонение (∆Q), %"]
[null,29,0,null,null,null,null,200]
[]
[null,"Минимум",{"$f":"ROUNDDOWN(MIN(E5:F13)/1000,0)*1000","v":18000}]
[null,"Максимум",{"$f":"ROUNDUP(MAX(E5:F13)/1000,0)*1000","v":35000}]
[null,"Деление",{"$f":"MAX((C29-C28)/10,1)","v":1700}]