{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Budget Scenario Analysis","Scenario Chart"],"not_rendered":{"charts":1,"external_links":1,"defined_names":1},"unopened":[{"sheet":"Scenario Chart","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Budget Scenario Analysis","index":0,"n_rows":26,"n_cols":4,"rows_kept":26,"flags":["formulas_cached_only"]}
["<Company Name>"]
["Budget Scenario Analysis"]
["<Date>"]
[]
["Gray cells will be calculated for you. You do not need to enter anything in them."]
["Budget Drivers","Scenario 1\n(Best case)","Scenario 2\n(Average case)","Scenario 3\n(Worst case)"]
["Probability of shipping on time",{"v":0.98,"d":"98%"},{"v":0.95,"d":"95%"},{"v":0.9,"d":"90%"}]
["Number of building permits released within last 6 months",{"v":25000,"d":"25,000 "},{"v":30000,"d":"30,000 "},{"v":35000,"d":"35,000 "}]
["Regional economic growth",{"v":0.035,"d":"3.50%"},{"v":0.032,"d":"3.20%"},{"v":0.02,"d":"2.00%"}]
["Competitive strength (products, pricing, promotion, placement)",{"v":7,"d":"7 "},{"v":8,"d":"8 "},{"v":9,"d":"9 "}]
["Probability of key supplier performance",{"v":0.99,"d":"99%"},{"v":0.95,"d":"95%"},{"v":0.9,"d":"90%"}]
[]
[]
["Revenue Impact","Scenario 1\n(Best case)","Scenario 2\n(Average case)","Scenario 3\n(Worst case)"]
["Probability of shipping on time",{"v":0.02,"d":"2.0%"},{"v":0,"d":"0.0%"},{"v":-0.05,"d":"-5.0%"}]
["Number of building permits released within last 6 months",{"v":0.05,"d":"5.0%"},{"v":0,"d":"0.0%"},{"v":-0.05,"d":"-5.0%"}]
["Regional economic growth",{"v":0.02,"d":"2.0%"},{"v":0,"d":"0.0%"},{"v":-0.04,"d":"-4.0%"}]
["Competitive strength (products, pricing, promotion, placement)",{"v":0.02,"d":"2.0%"},{"v":0,"d":"0.0%"},{"v":-0.05,"d":"-5.0%"}]
["Probability of key supplier performance",{"v":0.02,"d":"2.0%"},{"v":0,"d":"0.0%"},{"v":-0.05,"d":"-5.0%"}]
[]
["Budgeted Annual Revenue Using Base Case Scenario",{"v":32000000,"d":"$32,000,000"}]
[]
["Budget Scenarios","Results","Base Case Variance","Variance Percentage"]
["Scenario 1: Best case",{"v":36160000,"d":"$36,160,000"},{"v":4160000,"d":"$4,160,000"},{"v":0.11504424778761058,"d":"11.50%"}]
["Scenario 2: Average case",{"v":32000000,"d":"$32,000,000"},"—","—"]
["Scenario 3: Worst case",{"v":24320000,"d":"$24,320,000"},{"v":-7680000,"d":"($7,680,000)"},{"v":-0.3157894736842105,"d":"-31.58%"}]