{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Source Data","PivotTable Report","PivotChart Report"],"not_rendered":{"charts":1,"external_links":1,"defined_names":3},"unopened":[{"sheet":"PivotChart Report","index":2,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Source Data","index":0,"n_rows":152,"n_cols":13,"rows_kept":152,"merged":[[6,0,6,7]],"flags":["formulas_cached_only"]}
["[Company Name]"]
["Operating Expense Budget"]
["[Date]"]
[]
["Gray cells will be calculated for you. You do not need to enter anything in them."]
[]
["Operating Expense Budget"]
["Month","Qtr","Year","Category","Expenses","Budget","Actual","Variance",{"$nulls":3},"Category","Expenses"]
["Jan","Q1",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},{"v":21000,"d":"$21,000"},{"v":-1000,"d":"$(1,000)"},{"$nulls":3},"Overhead","Employee Benefits"]
["Feb","Q1",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},{"v":24000,"d":"$24,000"},{"v":-4000,"d":"$(4,000)"},{"$nulls":3},"Other","Advertising"]
["Mar","Q1",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},{"v":25000,"d":"$25,000"},{"v":-5000,"d":"$(5,000)"},{"$nulls":3},"Employee","Marketing"]
["Apr","Q2",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},{"v":22000,"d":"$22,000"},{"v":-2000,"d":"$(2,000)"},{"$nulls":3},"Program","Insurance"]
["May","Q2",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},{"v":19000,"d":"$19,000"},{"v":1000,"d":"$1,000"},{"$nulls":4},"Utilities"]
["Jun","Q2",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},{"v":20000,"d":"$20,000"},0,{"$nulls":4},"Rent / Leases"]
["Jul","Q3",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},0," ",{"$nulls":4},"Travel"]
["Aug","Q3",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},0," ",{"$nulls":4},"Other"]
["Sep","Q3",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},0," ",{"$nulls":4},"Supplies / Maintenance"]
["Oct","Q4",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},0," ",{"$nulls":4},"R&D"]
["Nov","Q4",2004,"Employee","Salaries and Wages",{"v":20000,"d":"$20,000"},0," ",{"$nulls":4},"Salaries and Wages"]
["Dec","Q4",2004,"Employee","Salaries and Wages",{"v":25000,"d":"$25,000"},0," ",{"$nulls":4},"Payroll Taxes"]
["Jan","Q1",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},{"v":7800,"d":"$7,800"},{"v":-300,"d":"$(300)"}]
["Feb","Q1",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},{"v":8200,"d":"$8,200"},{"v":-700,"d":"$(700)"}]
["Mar","Q1",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},{"v":8500,"d":"$8,500"},{"v":-1000,"d":"$(1,000)"}]
["Apr","Q2",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},{"v":7900,"d":"$7,900"},{"v":-400,"d":"$(400)"}]
["May","Q2",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},{"v":7400,"d":"$7,400"},{"v":100,"d":"$100"}]
["Jun","Q2",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},{"v":7000,"d":"$7,000"},{"v":500,"d":"$500"}]
["Jul","Q3",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},0," "]
["Aug","Q3",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},0," "]
["Sep","Q3",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},0," "]
["Oct","Q4",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},0," "]
["Nov","Q4",2004,"Employee","Payroll Taxes",{"v":7500,"d":"$7,500"},0," "]
["Dec","Q4",2004,"Employee","Payroll Taxes",{"v":8500,"d":"$8,500"},0," "]
["Jan","Q1",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},{"v":5500,"d":"$5,500"},{"v":-500,"d":"$(500)"}]
["Feb","Q1",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},{"v":6500,"d":"$6,500"},{"v":-1500,"d":"$(1,500)"}]
["Mar","Q1",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},{"v":7500,"d":"$7,500"},{"v":-2500,"d":"$(2,500)"}]
["Apr","Q2",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},{"v":6500,"d":"$6,500"},{"v":-1500,"d":"$(1,500)"}]
["May","Q2",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},0]
["Jun","Q2",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},0]
["Jul","Q3",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},0," "]
["Aug","Q3",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},0," "]
["Sep","Q3",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},0," "]
["Oct","Q4",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},0," "]
["Nov","Q4",2004,"Employee","Employee Benefits",{"v":5000,"d":"$5,000"},0," "]
["Dec","Q4",2004,"Employee","Employee Benefits",{"v":7500,"d":"$7,500"},0," "]
["Jan","Q1",2004,"Program","Advertising",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},0]
["Feb","Q1",2004,"Program","Advertising",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},0]
["Mar","Q1",2004,"Program","Advertising",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},0]
["Apr","Q2",2004,"Program","Advertising",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},0]
["May","Q2",2004,"Program","Advertising",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},0]
["Jun","Q2",2004,"Program","Advertising",{"v":1000,"d":"$1,000"},{"v":1500,"d":"$1,500"},{"v":-500,"d":"$(500)"}]
["Jul","Q3",2004,"Program","Advertising",{"v":2000,"d":"$2,000"},0," "]
["Aug","Q3",2004,"Program","Advertising",{"v":2000,"d":"$2,000"},0," "]
["Sep","Q3",2004,"Program","Advertising",{"v":2000,"d":"$2,000"},0," "]
["Oct","Q4",2004,"Program","Advertising",{"v":2000,"d":"$2,000"},0," "]
["Nov","Q4",2004,"Program","Advertising",{"v":2000,"d":"$2,000"},0," "]
["Dec","Q4",2004,"Program","Advertising",{"v":2000,"d":"$2,000"},0," "]
["Jan","Q1",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},0]
["Feb","Q1",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},0]
["Mar","Q1",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},0]
["Apr","Q2",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},0]
["May","Q2",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},0]
["Jun","Q2",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},{"v":3000,"d":"$3,000"},{"v":-500,"d":"$(500)"}]
["Jul","Q3",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},0," "]
["Aug","Q3",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},0," "]
["Sep","Q3",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},0," "]
["Oct","Q4",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},0," "]
["Nov","Q4",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},0," "]
["Dec","Q4",2004,"Program","Marketing",{"v":2500,"d":"$2,500"},0," "]
["Jan","Q1",2004,"Program","R&D",{"v":4000,"d":"$4,000"},{"v":4500,"d":"$4,500"},{"v":-500,"d":"$(500)"}]
["Feb","Q1",2004,"Program","R&D",{"v":4000,"d":"$4,000"},{"v":5000,"d":"$5,000"},{"v":-1000,"d":"$(1,000)"}]
["Mar","Q1",2004,"Program","R&D",{"v":4000,"d":"$4,000"},{"v":5000,"d":"$5,000"},{"v":-1000,"d":"$(1,000)"}]
["Apr","Q2",2004,"Program","R&D",{"v":4000,"d":"$4,000"},{"v":4000,"d":"$4,000"},0]
["May","Q2",2004,"Program","R&D",{"v":4000,"d":"$4,000"},{"v":4000,"d":"$4,000"},0]
["Jun","Q2",2004,"Program","R&D",{"v":4000,"d":"$4,000"},{"v":3500,"d":"$3,500"},{"v":500,"d":"$500"}]
["Jul","Q3",2004,"Program","R&D",{"v":5000,"d":"$5,000"},0," "]
["Aug","Q3",2004,"Program","R&D",{"v":5000,"d":"$5,000"},0," "]
["Sep","Q3",2004,"Program","R&D",{"v":5000,"d":"$5,000"},0," "]
["Oct","Q4",2004,"Program","R&D",{"v":5000,"d":"$5,000"},0," "]
["Nov","Q4",2004,"Program","R&D",{"v":5000,"d":"$5,000"},0," "]
["Dec","Q4",2004,"Program","R&D",{"v":5000,"d":"$5,000"},0," "]
["Jan","Q1",2004,"Overhead","Insurance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Feb","Q1",2004,"Overhead","Insurance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Mar","Q1",2004,"Overhead","Insurance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Apr","Q2",2004,"Overhead","Insurance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["May","Q2",2004,"Overhead","Insurance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Jun","Q2",2004,"Overhead","Insurance",{"v":500,"d":"$500"},{"v":600,"d":"$600"},{"v":-100,"d":"$(100)"}]
["Jul","Q3",2004,"Overhead","Insurance",{"v":650,"d":"$650"},0," "]
["Aug","Q3",2004,"Overhead","Insurance",{"v":650,"d":"$650"},0," "]
["Sep","Q3",2004,"Overhead","Insurance",{"v":650,"d":"$650"},0," "]
["Oct","Q4",2004,"Overhead","Insurance",{"v":650,"d":"$650"},0," "]
["Nov","Q4",2004,"Overhead","Insurance",{"v":650,"d":"$650"},0," "]
["Dec","Q4",2004,"Overhead","Insurance",{"v":650,"d":"$650"},0," "]
["Jan","Q1",2004,"Overhead","Utilities",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Feb","Q1",2004,"Overhead","Utilities",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Mar","Q1",2004,"Overhead","Utilities",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Apr","Q2",2004,"Overhead","Utilities",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["May","Q2",2004,"Overhead","Utilities",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Jun","Q2",2004,"Overhead","Utilities",{"v":500,"d":"$500"},{"v":550,"d":"$550"},{"v":-50,"d":"$(50)"}]
["Jul","Q3",2004,"Overhead","Utilities",{"v":650,"d":"$650"},0," "]
["Aug","Q3",2004,"Overhead","Utilities",{"v":650,"d":"$650"},0," "]
["Sep","Q3",2004,"Overhead","Utilities",{"v":650,"d":"$650"},0," "]
["Oct","Q4",2004,"Overhead","Utilities",{"v":650,"d":"$650"},0," "]
["Nov","Q4",2004,"Overhead","Utilities",{"v":650,"d":"$650"},0," "]
["Dec","Q4",2004,"Overhead","Utilities",{"v":650,"d":"$650"},0," "]
["Jan","Q1",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},{"v":1200,"d":"$1,200"},0]
["Feb","Q1",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},{"v":1200,"d":"$1,200"},0]
["Mar","Q1",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},{"v":1200,"d":"$1,200"},0]
["Apr","Q2",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},{"v":1200,"d":"$1,200"},0]
["May","Q2",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},{"v":1200,"d":"$1,200"},0]
["Jun","Q2",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},{"v":1200,"d":"$1,200"},0]
["Jul","Q3",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},0," "]
["Aug","Q3",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},0," "]
["Sep","Q3",2004,"Overhead","Rent / Leases",{"v":1200,"d":"$1,200"},0," "]
["Oct","Q4",2004,"Overhead","Rent / Leases",{"v":1500,"d":"$1,500"},0," "]
["Nov","Q4",2004,"Overhead","Rent / Leases",{"v":1500,"d":"$1,500"},0," "]
["Dec","Q4",2004,"Overhead","Rent / Leases",{"v":1500,"d":"$1,500"},0," "]
["Jan","Q1",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Feb","Q1",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Mar","Q1",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Apr","Q2",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["May","Q2",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Jun","Q2",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},{"v":400,"d":"$400"},{"v":100,"d":"$100"}]
["Jul","Q3",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},0," "]
["Aug","Q3",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},0," "]
["Sep","Q3",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},0," "]
["Oct","Q4",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},0," "]
["Nov","Q4",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},0," "]
["Dec","Q4",2004,"Overhead","Supplies / Maintenance",{"v":500,"d":"$500"},0," "]
["Jan","Q1",2004,"Other","Travel",{"v":750,"d":"$750"},{"v":750,"d":"$750"},0]
["Feb","Q1",2004,"Other","Travel",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},0]
["Mar","Q1",2004,"Other","Travel",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["Apr","Q2",2004,"Other","Travel",{"v":750,"d":"$750"},{"v":750,"d":"$750"},0]
["May","Q2",2004,"Other","Travel",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},0]
["Jun","Q2",2004,"Other","Travel",{"v":500,"d":"$500"},{"v":1000,"d":"$1,000"},{"v":-500,"d":"$(500)"}]
["Jul","Q3",2004,"Other","Travel",{"v":1000,"d":"$1,000"},0," "]
["Aug","Q3",2004,"Other","Travel",{"v":1000,"d":"$1,000"},0," "]
["Sep","Q3",2004,"Other","Travel",{"v":1000,"d":"$1,000"},0," "]
["Oct","Q4",2004,"Other","Travel",{"v":1000,"d":"$1,000"},0," "]
["Nov","Q4",2004,"Other","Travel",{"v":1000,"d":"$1,000"},0," "]
["Dec","Q4",2004,"Other","Travel",{"v":500,"d":"$500"},0," "]
["Jan","Q1",2004,"Other","Other",{"v":600,"d":"$600"},{"v":600,"d":"$600"},0]
["Feb","Q1",2004,"Other","Other",{"v":600,"d":"$600"},{"v":600,"d":"$600"},0]
["Mar","Q1",2004,"Other","Other",{"v":600,"d":"$600"},{"v":600,"d":"$600"},0]
["Apr","Q2",2004,"Other","Other",{"v":600,"d":"$600"},{"v":600,"d":"$600"},0]
["May","Q2",2004,"Other","Other",{"v":600,"d":"$600"},{"v":600,"d":"$600"},0]
["Jun","Q2",2004,"Other","Other",{"v":600,"d":"$600"},{"v":800,"d":"$800"},{"v":-200,"d":"$(200)"}]
["Jul","Q3",2004,"Other","Other",{"v":600,"d":"$600"},0," "]
["Aug","Q3",2004,"Other","Other",{"v":600,"d":"$600"},0," "]
["Sep","Q3",2004,"Other","Other",{"v":600,"d":"$600"},0," "]
["Oct","Q4",2004,"Other","Other",{"v":600,"d":"$600"},0," "]
["Nov","Q4",2004,"Other","Other",{"v":600,"d":"$600"},0," "]
["Dec","Q4",2004,"Other","Other",{"v":600,"d":"$600"},0," "]

{"sheet":"PivotTable Report","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"flags":["formulas_cached_only"]}
["[Company Name]"]
["Operating Expense Budget"]
["[Date]"]
[]
["Year","(All)"]
["Expenses","(All)"]
["Month","(All)"]
[]
[null,null,"Data"]
["Qtr","Category","Budget Plan","Actuals","Budget to Actual Variance"]
["Q1","Employee",{"v":97500,"d":"$97,500"},{"v":114000,"d":"$114,000"},{"v":-16500,"d":"$(16,500)"}]
[null,"Other",{"v":4050,"d":"$4,050"},{"v":4050,"d":"$4,050"},0]
[null,"Overhead",{"v":8100,"d":"$8,100"},{"v":8100,"d":"$8,100"},0]
[null,"Program",{"v":22500,"d":"$22,500"},{"v":25000,"d":"$25,000"},{"v":-2500,"d":"$(2,500)"}]
["Q1 Total",null,{"v":132150,"d":"$132,150"},{"v":151150,"d":"$151,150"},{"v":-19000,"d":"$(19,000)"}]
["Q2","Employee",{"v":97500,"d":"$97,500"},{"v":99800,"d":"$99,800"},{"v":-2300,"d":"$(2,300)"}]
[null,"Other",{"v":4050,"d":"$4,050"},{"v":4750,"d":"$4,750"},{"v":-700,"d":"$(700)"}]
[null,"Overhead",{"v":8100,"d":"$8,100"},{"v":8150,"d":"$8,150"},{"v":-50,"d":"$(50)"}]
[null,"Program",{"v":22500,"d":"$22,500"},{"v":23000,"d":"$23,000"},{"v":-500,"d":"$(500)"}]
["Q2 Total",null,{"v":132150,"d":"$132,150"},{"v":135700,"d":"$135,700"},{"v":-3550,"d":"$(3,550)"}]
["Q3","Employee",{"v":97500,"d":"$97,500"},0,0]
[null,"Other",{"v":4800,"d":"$4,800"},0,0]
[null,"Overhead",{"v":9000,"d":"$9,000"},0,0]
[null,"Program",{"v":28500,"d":"$28,500"},0,0]
["Q3 Total",null,{"v":139800,"d":"$139,800"},0,0]
["Q4","Employee",{"v":106000,"d":"$106,000"},0,0]
[null,"Other",{"v":4300,"d":"$4,300"},0,0]
[null,"Overhead",{"v":9900,"d":"$9,900"},0,0]
[null,"Program",{"v":28500,"d":"$28,500"},0,0]
["Q4 Total",null,{"v":148700,"d":"$148,700"},0,0]
["Grand Total",null,{"v":552800,"d":"$552,800"},{"v":286850,"d":"$286,850"},{"v":265950,"d":"$265,950"}]