{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Monthly Budget"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Monthly Budget","index":0,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[15,7,15,11],[9,7,9,11],[29,1,29,3],[2,11,2,12]]}
[]
[null,"COMPANY NAME"]
[null,"MONTHLY BUDGET",null,null,null,null,null,null,null,null,null,"2011-03-01"]
[]
[null,"BUDGET TOTALS","ESTIMATED","ACTUAL","DIFFERENCE",null,null,"INCOME","ESTIMATED","ACTUAL","TOP 5 AMOUNT","DIFFERENCE"]
[null,"Income",{"$f":"IncomeTable[[#Totals],[ESTIMATED]]","v":63300},{"$f":"IncomeTable[[#Totals],[ACTUAL]]","v":57450},{"$f":"TotalsTable[[#This Row],[ACTUAL]]-TotalsTable[[#This Row],[ESTIMATED]]","v":-5850},null,null,"Net sales",60000,54000,{"$f":"IncomeTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(IncomeTable[[#This Row],[ACTUAL]])","v":54000.000006000002},{"$f":"IncomeTable[[#This Row],[ACTUAL]]-IncomeTable[[#This Row],[ESTIMATED]]","v":-6000}]
[null,"Expenses",{"$f":"OperatingExpensesTable[[#Totals],[ESTIMATED]]+PersonnelExpensesTable[[#Totals],[ESTIMATED]]","v":54500},{"$f":"OperatingExpensesTable[[#Totals],[ACTUAL]]+PersonnelExpensesTable[[#Totals],[ACTUAL]]","v":49630},{"$f":"TotalsTable[[#This Row],[ESTIMATED]]-TotalsTable[[#This Row],[ACTUAL]]","v":4870},null,null,"Interest income",3000,3000,{"$f":"IncomeTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(IncomeTable[[#This Row],[ACTUAL]])","v":3000.0000070000001},{"$f":"IncomeTable[[#This Row],[ACTUAL]]-IncomeTable[[#This Row],[ESTIMATED]]","v":0}]
[null,"Balance (Income minus Expenses)",{"$f":"C6-C7","v":8800},{"$f":"D6-D7","v":7820},{"$f":"TotalsTable[[#Totals],[ACTUAL]]-TotalsTable[[#Totals],[ESTIMATED]]","v":-980},null,null,"Asset sales (gain/loss)",300,450,{"$f":"IncomeTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(IncomeTable[[#This Row],[ACTUAL]])","v":450.00000799999998},{"$f":"IncomeTable[[#This Row],[ACTUAL]]-IncomeTable[[#This Row],[ESTIMATED]]","v":150}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUBTOTAL(109,IncomeTable[ESTIMATED])","v":63300},{"$f":"SUBTOTAL(109,IncomeTable[ACTUAL])","v":57450},null,{"$f":"SUBTOTAL(109,IncomeTable[DIFFERENCE])","v":-5850}]
[]
[null,null,null,null,null,null,null,"PERSONNEL EXPENSES","ESTIMATED","ACTUAL","Top 5 Amount","DIFFERENCE"]
[null,null,null,null,null,null,null,"Wages",9500,9600,{"$f":"PersonnelExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(PersonnelExpensesTable[[#This Row],[ACTUAL]])","v":9600.0000120000004},{"$f":"PersonnelExpensesTable[[#This Row],[ESTIMATED]]-PersonnelExpensesTable[[#This Row],[ACTUAL]]","v":-100}]
[null,null,null,null,null,null,null,"Employee benefits",4000,null,{"$f":"PersonnelExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(PersonnelExpensesTable[[#This Row],[ACTUAL]])","v":1.2999999999999999E-5},{"$f":"PersonnelExpensesTable[[#This Row],[ESTIMATED]]-PersonnelExpensesTable[[#This Row],[ACTUAL]]","v":4000}]
[null,null,null,null,null,null,null,"Commission",5000,4500,{"$f":"PersonnelExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(PersonnelExpensesTable[[#This Row],[ACTUAL]])","v":4500.0000140000002},{"$f":"PersonnelExpensesTable[[#This Row],[ESTIMATED]]-PersonnelExpensesTable[[#This Row],[ACTUAL]]","v":500}]
[null,null,null,null,null,null,null,"Total Personnel",{"$f":"SUBTOTAL(109,PersonnelExpensesTable[ESTIMATED])","v":18500},{"$f":"SUBTOTAL(109,PersonnelExpensesTable[ACTUAL])","v":14100},null,{"$f":"SUBTOTAL(109,PersonnelExpensesTable[DIFFERENCE])","v":4400}]
[]
[null,null,null,null,null,null,null,"OPERATING EXPENSES","ESTIMATED","ACTUAL","Top 5 Amount","DIFFERENCE"]
[null,null,null,null,null,null,null,"Advertising",3000,2500,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":2500.0000180000002},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":500}]
[null,null,null,null,null,null,null,"Bad debts",2000,2000,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":2000.0000190000001},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":0}]
[null,null,null,null,null,null,null,"Cash discounts",1500,2175,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":2175.0000199999999},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":-675}]
[null,null,null,null,null,null,null,"Delivery costs",2000,1500,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":1500.0000210000001},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":500}]
[null,null,null,null,null,null,null,"Depreciation",1000,1000,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":1000.0000219999999},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":0}]
[null,null,null,null,null,null,null,"Dues and subscriptions",500,525,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":525.00002300000006},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":-25}]
[null,null,null,null,null,null,null,"Insurance",1300,1275,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":1275.0000239999999},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":25}]
[null,null,null,null,null,null,null,"Interest",2000,2200,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":2200.0000249999998},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":-200}]
[null,null,null,null,null,null,null,"Legal and auditing",1000,800,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":800.00002600000005},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":200}]
[null,null,null,null,null,null,null,"Maintenance and repairs",4500,4600,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":4600.000027},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":-100}]
[null,null,null,null,null,null,null,"Office supplies",800,750,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":750.00002800000004},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":50}]
[null,null,null,null,null,null,null,"Postage",400,350,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":350.00002899999998},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":50}]
[null,null,null,null,null,null,null,"Rent or mortgage",4100,4500,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":4500.0000300000002},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":-400}]
[null,"WHAT ARE MY TOP 5 HIGHEST OPERATING EXPENSES?",null,null,null,null,null,"Sales expenses",350,400,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":400.00003099999998},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":-50}]
[null,"EXPENSE","AMOUNT","% OF EXPENSES","15% REDUCTION",null,null,"Shipping and storage",900,840,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":840.00003200000003},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":60}]
[null,{"$f":"INDEX(OperatingExpensesTable[],MATCH(Top5Expenses[[#This Row],[AMOUNT]],OperatingExpensesTable[Top 5 Amount],0),1)","v":"Maintenance and repairs"},{"$f":"LARGE(OperatingExpensesTable[Top 5 Amount],1)","v":4600.000027},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]/$D$7","v":9.268587602256699E-2},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]*0.15","v":690.00000405000003},null,null,"Supplies",5000,4500,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":4500.0000330000003},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":500}]
[null,{"$f":"INDEX(OperatingExpensesTable[],MATCH(Top5Expenses[[#This Row],[AMOUNT]],OperatingExpensesTable[Top 5 Amount],0),1)","v":"Supplies"},{"$f":"LARGE(OperatingExpensesTable[Top 5 Amount],2)","v":4500.0000330000003},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]/$D$7","v":9.0670965806971593E-2},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]*0.15","v":675.00000495000006},null,null,"Taxes",3000,3200,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":3200.0000340000001},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":-200}]
[null,{"$f":"INDEX(OperatingExpensesTable[],MATCH(Top5Expenses[[#This Row],[AMOUNT]],OperatingExpensesTable[Top 5 Amount],0),1)","v":"Rent or mortgage"},{"$f":"LARGE(OperatingExpensesTable[Top 5 Amount],3)","v":4500.0000300000002},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]/$D$7","v":9.0670965746524279E-2},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]*0.15","v":675.00000450000005},null,null,"Telephone",250,280,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":280.00003500000003},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":-30}]
[null,{"$f":"INDEX(OperatingExpensesTable[],MATCH(Top5Expenses[[#This Row],[AMOUNT]],OperatingExpensesTable[Top 5 Amount],0),1)","v":"Taxes"},{"$f":"LARGE(OperatingExpensesTable[Top 5 Amount],4)","v":3200.0000340000001},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]/$D$7","v":6.4477131452750358E-2},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]*0.15","v":480.00000510000001},null,null,"Utilities",1400,1385,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":1385.0000359999999},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":15}]
[null,{"$f":"INDEX(OperatingExpensesTable[],MATCH(Top5Expenses[[#This Row],[AMOUNT]],OperatingExpensesTable[Top 5 Amount],0),1)","v":"Advertising"},{"$f":"LARGE(OperatingExpensesTable[Top 5 Amount],5)","v":2500.0000180000002},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]/$D$7","v":5.0372758774934516E-2},{"$f":"Top5Expenses[[#This Row],[AMOUNT]]*0.15","v":375.00000270000004},null,null,"Other",1000,750,{"$f":"OperatingExpensesTable[[#This Row],[ACTUAL]]+(10^-6)*ROW(OperatingExpensesTable[[#This Row],[ACTUAL]])","v":750.00003700000002},{"$f":"OperatingExpensesTable[[#This Row],[ESTIMATED]]-OperatingExpensesTable[[#This Row],[ACTUAL]]","v":250}]
[null,"Total",{"$f":"SUBTOTAL(109,Top5Expenses[AMOUNT])","v":19300.000142000001},{"$f":"SUBTOTAL(109,Top5Expenses[% OF EXPENSES])","v":0.38887769780374776},{"$f":"SUBTOTAL(109,Top5Expenses[15% REDUCTION])","v":2895.0000213000003},null,null,"Total Operating",{"$f":"SUBTOTAL(109,OperatingExpensesTable[ESTIMATED])","v":36000},{"$f":"SUBTOTAL(109,OperatingExpensesTable[ACTUAL])","v":35530},null,{"$f":"SUBTOTAL(109,OperatingExpensesTable[DIFFERENCE])","v":470}]
[null," ",null,null,null,null,null," "]