{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["CVP Calculator, BUS599"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"CVP Calculator, BUS599","index":0,"n_rows":18,"n_cols":9,"rows_kept":18}
[]
[null,"R&D Total Budget",{"v":22000000,"d":"$22,000,000"}]
[null,"R&D% Allocation"]
[]
[null,"R&D Costs",{"$f":"C2*C3","v":0}]
[null,"Fixed Costs"]
[null,"Total Fixed Costs",{"$f":"C5+C6","v":0}]
[]
[null,"Target Profit"]
[]
[null,"Variable Cost/Unit"]
[{"$nulls":4},"Price",null,null,"Volume"]
[]
[{"$nulls":4},"Volume",{"$f":"IF(F12-C11 = 0, \"\",(C7+C9)/(F12-C11))","v":""},null,"Price",{"$f":"IF(I12=0, \"\",C11+(C7+C9)/I12)","v":""}]
[]
[{"$nulls":4},"Sales Revenue",{"$f":"IF(F14=\"\", \"\", F12*F14)","v":""},null,"Sales Revenue",{"$f":"IF(I14=\"\", \"\", I12*I14)","v":""}]
[]
[{"$nulls":4},"ROS",{"$f":"IF( F16=\"\", \"\", C9/F16)","v":""},null,"ROS",{"$f":"IF( I16=\"\", \"\", C9/I16)","v":""}]