{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["DV","Combo","Scenario Mgr","Goal Seek","Data Table","BE goal seek","BE with Macro"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":4,"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":"DV","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Project Costings Analysis"]
[null,"Annual days","Tax","Project days"]
["Days Worked",260,0.1,60]
[]
["Costs","Ann Salary","Daily Rate","Project Costs"]
["Project Manager",240000,{"$f":"B6/$B$3*(1+IF($B$12=\"No\",0,$C$3))","v":1015.3846153846155},{"$f":"C6*$D$3","v":60923.076923076929}]
["Business Analyst",120000,{"$f":"B7/$B$3*(1+IF($B$12=\"No\",0,$C$3))","v":507.69230769230774},{"$f":"C7*$D$3","v":30461.538461538465}]
["Call Centre",56000,{"$f":"B8/$B$3*(1+IF($B$12=\"No\",0,$C$3))","v":236.92307692307693},14215.384615384615]
["Product Development",220000,{"$f":"B9/$B$3*(1+IF($B$12=\"No\",0,$C$3))","v":930.76923076923083},55846.153846153851]
["Total Cost",null,null,{"$f":"SUM(D6:D9)","v":161446.15384615384}]
[]
["Do these costings include Tax?","Yes"]

{"sheet":"Combo","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,3]
[]
[]
[]
[null,null,null,null,"Price"]
[null,null,null,"Best Case",120]
[null,null,null,"Base Case",100]
[null,null,null,"Worst Case",80]

{"sheet":"Scenario Mgr","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Budget 20X0"]
[]
["Income",36000]
[]
["Expenditure"]
["Mortgage",18000]
["Bills",8000]
["Travel",2500]
["Food",6000]
["Total Expenditure",{"$f":"SUM(B6:B9)","v":34500}]
[]
["Savings",{"$f":"B3-B10","v":1500}]

{"sheet":"Goal Seek","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Project Costings Analysis"]
[null,"Annual days",null,"Project days"]
["Days Worked",260,null,60]
[]
["Costs","Ann Salary","Daily Rate","Project Costs"]
["Project Manager",240000,{"$f":"B6/$B$3","v":923.07692307692309},{"$f":"C6*$D$3","v":55384.615384615383}]
["Business Analyst",120000,{"$f":"B7/$B$3","v":461.53846153846155},{"$f":"C7*$D$3","v":27692.307692307691}]
["Call Centre",56000,215.38461538461539,12923.076923076924]
["Product Development",220000,846.15384615384619,50769.230769230773]
["Total Cost",null,null,{"$f":"SUM(D6:D9)","v":146769.23076923078}]

{"sheet":"Data Table","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,3,11,3],[15,5,15,8],[17,3,22,3]]}
["INTEREST RATE CALCULATOR"]
[]
[]
[null,"Enter data here:",null,null,"Sensitivity of Monthly Repayment to one variable"]
[]
["Loan Amount",350000]
[null,null,null,"Interest Rate",0.06]
["Interest Rate",7.4999999999999997E-2,null,null,6.5000000000000002E-2]
[null,null,null,null,7.0000000000000007E-2]
["Term of Loan (Years)",25,null,null,7.4999999999999997E-2]
[null,null,null,null,0.08]
["Monthly Repayment",{"$f":"-PMT(B8/12,12*B10,B6)","v":2586.4691222911079},null,null,8.5000000000000006E-2]
[]
[]
[null,null,null,null,"Sensitivity of Monthly Repayment to two variables"]
[null,null,null,null,null,"Term of Loan"]
[null,null,null,null,null,20,25,30,35]
[null,null,null,"Interest Rate",0.06]
[null,null,null,null,6.5000000000000002E-2]
[null,null,null,null,7.0000000000000007E-2]
[null,null,null,null,7.4999999999999997E-2]
[null,null,null,null,0.08]
[null,null,null,null,8.5000000000000006E-2]

{"sheet":"BE goal seek","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Bob's Bird Cages Break Even Analysis"]
[]
[null,"Fixed Costs",250275]
[null,"Variable Costs/ Unit Produced:"]
[null,"Raw Material",5]
[null,"Labour",25]
[null,"Unit Overheads",10]
[null,"Total Variable Cost per Unit",{"$f":"SUM(C5:C7)","v":40}]
[null,"Selling Price",125]
[]
[null,"Cages produced / sold",5000]
[]
[null,"Total Revenue",{"$f":"C9*C11","v":625000}]
[null,"Total Variable Costs",{"$f":"C11*C8","v":200000},null,null," "]
[null,"Total Cost",{"$f":"C14+C3","v":450275}]
[null,"Total Profit/ Loss",{"$f":"C13-C15","v":174725}]

{"sheet":"BE with Macro","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Bob's Bird Cages Break Even Analysis"]
[]
[null,"Fixed Costs",250275]
[null,"Variable Costs/ Unit Produced:"]
[null,"Raw Material",5]
[null,"Labour",25]
[null,"Unit Overheads",10]
[null,"Total Variable Cost per Unit",{"$f":"SUM(C5:C7)","v":40}]
[null,"Selling Price",125]
[]
[null,"Cages produced / sold",5000]
[]
[null,"Total Revenue",{"$f":"C9*C11","v":625000}]
[null,"Total Variable Costs",{"$f":"C11*C8","v":200000},null,null," "]
[null,"Total Cost",{"$f":"C14+C3","v":450275}]
[null,"Total Profit/ Loss",{"$f":"C13-C15","v":174725}]