{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Budget Summary","Profit & Loss Chart","Balance Sheet Chart"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":1,"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","formulas":"cached_only"}

{"sheet":"Budget Summary","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Budget Summary Report"]
["<Date>"]
[]
["Gray cells are calculated for you and generally should not be altered."]
[]
["Profit and Loss Summary","May Actuals","May Targets","Monthly Variance","YTD Actuals","YTD Targets","YTD Variance","Notes"]
["Revenue",1200000,1100000,100000,6200000,6000000,200000,"We exceeded our May revenue target by 9%, due to stronger execution in the West region."]
["Gross margin",150000,160000,-10000,640000,750000,-110000]
["Gross margin percentage",0.125,0.14545454545454545,-0.020454545454545447,0.1032258064516129,0.125,-0.021774193548387097]
["Sales from new products",200000,150000,50000,900000,750000,150000]
["Regional Sales Breakdown:"]
["Northeast region",400000,400000,0,2200000,2000000,200000]
["Central region",400000,400000,0,2400000,2000000,400000]
["West region",400000,300000,100000,1600000,2000000,-400000]
["Expenses & Margin:"]
["SG&A expenses",100000,120000,20000,500000,600000,100000]
["Pretax operating profit (loss)",50000,40000,10000,140000,150000,-10000]
["Operating margin",0.041666666666666664,0.03636363636363636,0.0053030303030303025,0.02258064516129032,0.025,-0.00241935483870968]
[]
["Balance Sheet Summary","May Actuals","May Targets","Monthly Variance","YTD Actuals","YTD Targets","YTD Variance","Notes"]
["Period end cash flow",35000,50000,-15000,35000,50000,-15000,"Cash flow differential was due to cash settlement of legal dispute with Litware, Inc. on May 8."]
["Accounts receivable",20000,22000,-2000,20000,22000,-2000]
["Inventory",25000,30000,-5000,25000,30000,-5000]
["Total liquid assets",75000,90000,-15000,75000,90000,-15000]
["Assets required by debt covenants",25000,25000,0,25000,25000,0]
["Debt covenant buffer",50000,65000,-15000,50000,65000,-15000]
["Other Balance Sheet Items:"]
["Property, plant, and equipment",80000,78000,2000,80000,78000,2000,"Differential due to purchase of new bursting machine in Plant B."]
["Accounts payable",60000,60000,0,60000,60000,0]
["Long-term liabilities",30000,31000,1000,30000,31000,1000]
["Shareholder equity",300000,297500,2500,300000,297500,2500]
[]
["Operating Metrics Summary","May Actuals","May Targets","Monthly Variance","YTD Actuals","YTD Targets","YTD Variance","Notes"]
["Number of defects per 1,000 widgets produced",2.3,1,-1.2999999999999998,1.46,1,0.45999999999999996,"Quality issues were from incorrect paint applied on prod. line 3; manager implemented new detective controls."]
["Production capacity—units per month",200000,220000,-20000,1100000,1150000,-50000]
["Days of sales outstanding",35,25,-10,33,25,-8]
["Number of new orders",19,15,4,83,75,8]
[]
["Competitive Summary","Contoso, Ltd.","Competitor 1","Competitor 2","Competitor 3","Competitor 4","Other","Notes"]
["Market share",0.2,0.25,0.15,0.05,0.15,0.2,"Market share increased due to strength of new product sales."]
["Revenue (YTD)",6200000,7000000,4000000,1500000,4000000,6000000]
["New product introductions (YTD)",900000,500000,0,100000,500000,0]
["Number of field salespeople (estimated)",15,20,15,10,15,"N/A"]

{"sheet":"Profit & Loss Chart","index":1,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Profit and Loss Summary Chart"]
["<Date>"]

{"sheet":"Balance Sheet Chart","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Balance Sheet Summary Chart"]
["<Date>"]