{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Budget Summary Report"],"read":"whole","date_system":"1900"}

{"sheet":"Budget Summary Report","index":0,"n_rows":45,"n_cols":8,"rows_kept":45}
[]
[]
["<Company Name>"]
["Monthly Budget Summary Report"]
["<Date>"]
[]
[]
["PROFIT AND LOSS SUMMARY","Actual Budget","Target Budget","Difference","YTD Actual Budget ","YTD Target Budget","YTD Difference","Notes"]
[]
["Revenue",null,null,{"$f":"C10-B10","v":0},null,null,{"$f":"F10-E10","v":0}]
["Gross margin",null,null,{"$f":"C11-B11","v":0},null,null,{"$f":"F11-E11","v":0}]
["Gross margin percentage",null,null,0,null,null,0]
["Sales from new products",null,null,0,null,null,0]
[{"$nulls":3},0,null,null,0]
["SG&A expenses",null,null,0,null,null,0]
["Pretax operating profit (loss)",null,null,0,null,null,0]
["Operating margin",null,null,0,null,null,0]
[]
[]
["BALANCE SHEET SUMMARY","Actual Budget","Target Budget","Difference","YTD Actual Budget ","YTD Target Budget","YTD Difference","Notes"]
[]
["Period end cash flow",null,null,{"$f":"C22-B22","v":0},null,null,{"$f":"F22-E22","v":0}]
["Accounts receivable",null,null,{"$f":"C23-B23","v":0},null,null,{"$f":"F23-E23","v":0}]
["Inventory",null,null,0,null,null,0]
["Total liquid assets",null,null,0,null,null,0]
["Assets required by debt covenants",null,null,0,null,null,0]
["Debt covenant buffer",null,null,0,null,null,0]
["Accounts payable",null,null,0,null,null,0]
["Long-term liabilities",null,null,0,null,null,0]
["Shareholder equity",null,null,0,null,null,0]
[]
[]
["OPERATING METRICS SUMMARY","Actual Budget","Target Budget","Difference","YTD Actual Budget ","YTD Target Budget","YTD Difference","Notes"]
[]
["Number of new orders",null,null,{"$f":"C35-B35","v":0},null,null,{"$f":"F35-E35","v":0}]
["Days of sales outstanding",null,null,{"$f":"C36-B36","v":0},null,null,{"$f":"F36-E36","v":0}]
["Production capacity- units per month",null,null,0,null,null,0]
[]
[]
["COMPETITIVE SUMMARY","Competitor 1","Competitor 2","Competitor 3","Competitor 4","Competitor 5","Competitor 6","Notes"]
[]
["Market share"]
["Revenue (YTD)"]
["New product introductions (YTD)"]
["Number of field salespeople (estimated)"]