{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INFO","INPUT","OUTPUT","ESTIMATE","EXAMPLE1","EXAMPLE2","CALC'S"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"INFO","index":0,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"RETAIL INDICATOR ANALYSER"]
[]
[]
[null,"Purpose"]
[]
[null,"Retailers generally make losses in one area and profits in another.  This analysis enables you to"]
[null,"locate problems in the period, the store, the product, or the department and take remedial action."]
[]
[null,"This worksheet also contains an estimator to assist in displaying new profit and loss outcomes for"]
[null,"different percentages of change."]
[]
[]
[null,"Steps"]
[]
[null,1,null,"Select the INPUT tab and enter the various products / stores / period / department etc."]
[]
[null,2,null,"Input the sales, opening stock, purchases and closing stock figures for each category."]
[]
[null,3,null,"Enter amounts for wages and contributions."]
[]
[null,4,null,"Enter the number of persons, hours, number of customers and the number of items."]
[]
[null,5,null,"Select the OUTPUT tab and print the indicators."]
[]
[null,6,null,"To use the estimator select the \"Results Estimator\" button on the INPUT tab and enter details"]
[null,null,null,"into the unshaded areas (i.e. Enter the \"before\" figures and the estimated percentages of change)."]
[]
[null,7,null,"The ESTIMATE results are now ready to print.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Retail Ind.xls"]

{"sheet":"INPUT","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"RETAIL INDICATOR ANALYSER"]
[null,"INPUT FORM"]
[]
[null,"PERIOD/STORE/PROD./DEPT.","DEPT1",null,"DEPT2",null,"DEPT3",null,"DEPT4"]
[]
[null,"SALES",0,null,0,null,0,null,0]
[null,"OPENING STOCK",0,null,0,null,0,null,0]
[null,"PURCHASES",0,null,0,null,0,null,0]
[null,"CLOSING STOCK",0,null,0,null,0,null,0]
[null,"GROSS PROFIT",{"$f":"C6-(C7+C8-C9)","v":0},null,{"$f":"E6-(E7+E8-E9)","v":0},null,{"$f":"G6-(G7+G8-G9)","v":0},null,{"$f":"I6-(I7+I8-I9)","v":0}]
[]
[null,"WAGES",0,null,0,null,0,null,0]
[null,"CONTRIBUTION",0,null,0,null,0,null,0]
[null,"NUMBER OF PERSONS",0,null,0,null,0,null,0]
[null,"HOURS",0,null,0,null,0,null,0]
[null,"NUMBER OF CUSTOMERS",0,null,0,null,0,null,0]
[null,"NUMBER OF ITEMS",0,null,0,null,0,null,0]

{"sheet":"OUTPUT","index":2,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"RETAIL INDICATOR ANALYSER"]
[]
[null,"PERIOD/STORE/PRODUCT/DEPARTMENT",null,{"$f":"INPUT!C4","v":"DEPT1"},null,{"$f":"INPUT!E4","v":"DEPT2"},null,{"$f":"INPUT!G4","v":"DEPT3"},null,{"$f":"INPUT!I4","v":"DEPT4"}]
[]
[null,"GROSS PROFIT %"]
[]
[]
[]
[]
[null,"MARK UP %"]
[]
[]
[]
[]
[null,"WAGES %"]
[]
[]
[]
[]
[null,"CONTRIBUTION %"]
[]
[]
[]
[]
[null,"SALES PER PERSON"]
[]
[]
[]
[]
[null,"SALES PER PERSON HOUR"]
[]
[]
[]
[]
[null,"SALES PER $ WAGE"]
[]
[]
[]
[]
[null,"GROSS PROFIT PER $ WAGE"]
[]
[]
[]
[]
[null,"AVERAGE SALE $ PER CUSTOMER"]
[]
[]
[]
[]
[null,"AVERAGE SALE $ PER ITEM"]
[]
[]
[]
[]
[null,"AVERAGE ITEMS PER CUSTOMER"]
[]
[]
[]
[]
[null,"STOCKTURN"]

{"sheet":"ESTIMATE","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,"FUTURE RESULTS ESTIMATOR"]
[null," "]
[null,null,null,null,"% INCREASE"]
[null,null,null,"BEFORE","(DECREASE)","AFTER"]
[null,null,"NUMBER OF CUSTOMERS",0,0,{"$f":"IF(E5=\"\",\"\",D5*(1+E5))","v":0}]
[null,null,"TRANSACTIONS PER CUSTOMER",0,0,{"$f":"IF(E6=\"\",\"\",D6*(1+E6))","v":0}]
[null,null,"VALUE OF TRANSACTION",0,0,{"$f":"IF(E7=\"\",\"\",D7*(1+E7))","v":0}]
[null,null,"SALES",{"$f":"IF(D7=\"\",\"\",D5*D6*D7)","v":0},null,{"$f":"IF(F7=\"\",\"\",F5*F6*F7)","v":0}]
[]
[null,null,"% COST OF GOODS SOLD",0,0,{"$f":"IF(E10=\"\",\"\",D10*(1+E10))","v":0}]
[null,null,"=",{"$f":"IF(D10=\"\",\"\",$D$8*D10)","v":0},null,{"$f":"IF(F10=\"\",\"\",F8*F10)","v":0}]
[null,null,"GROSS PROFIT",{"$f":"IF(D11=\"\",\"\",D8-D11)","v":0},null,{"$f":"IF(F11=\"\",\"\",F8-F11)","v":0}]
[null,null,null,null,-10]
[null,null,"% OPERATING EXPENSES",0,0,{"$f":"IF(E14=\"\",\"\",D14*(1+E14))","v":0}]
[null,null,"=",{"$f":"IF(D14=\"\",\"\",$D$8*D14)","v":0},null,{"$f":"IF(F14=\"\",\"\",$D$8*F14)","v":0},null,{"$f":"IF(F16=0,0,F16/D16-1)","v":0}]
[null,null,"NET PROFIT",{"$f":"IF(D15=\"\",\"\",D12-D15)","v":0},null,{"$f":"IF(F15=\"\",\"\",F12-F15)","v":0},null,{"$f":"IF(H15=\"\",\"\",IF(H15>0,\"INCREASE\",IF(H15<0,\"DECREASE\",\"\")))","v":""}]

{"sheet":"EXAMPLE1","index":4,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"RETAIL INDICATOR ANALYSER"]
[null,"(SAMPLE REPORT ONLY)"]
[null,"PERIOD/STORE/PRODUCT/DEPARTMENT",null,"NSW",null,"QLD",null,"ACT",null,"VIC"]
[]
[null,"GROSS PROFIT %"]
[]
[]
[]
[]
[null,"MARK UP %"]
[]
[]
[]
[]
[null,"WAGES %"]
[]
[]
[]
[]
[null,"CONTRIBUTION %"]
[]
[]
[]
[]
[null,"SALES PER PERSON"]
[]
[]
[]
[]
[null,"SALES PER PERSON HOUR"]
[]
[]
[]
[]
[null,"SALES PER $ WAGE"]
[]
[]
[]
[]
[null,"GROSS PROFIT PER $ WAGE"]
[]
[]
[]
[]
[null,"AVERAGE SALE $ PER CUSTOMER"]
[]
[]
[]
[]
[null,"AVERAGE SALE PER ITEM"]
[]
[]
[]
[]
[null,"AVERAGE ITEMS PER CUSTOMER"]
[]
[]
[]
[]
[null,"STOCKTURN"]

{"sheet":"EXAMPLE2","index":5,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,"FUTURE RESULTS ESTIMATOR"]
[null," ","(SAMPLE REPORT ONLY)"]
[null,null,null,null,"% INCREASE"]
[null,null,null,"BEFORE","(DECREASE)","AFTER"]
[null,null,"NUMBER OF CUSTOMERS",30,0.1,33]
[null,null,"TRANSACTIONS PER CUSTOMER",1,0.15,1.1499999999999999]
[null,null,"VALUE OF TRANSACTION",769.23,0.3,999.99900000000002]
[null,null,"SALES",23077,null,37950]
[]
[null,null,"% COST OF GOODS SOLD",0.41499999999999998,-0.1,0.3735]
[null,null,"=",9577,null,14174]
[null,null,"GROSS PROFIT",13500,null,23776]
[null,null,null,null,-10]
[null,null,"% OPERATING EXPENSES",0.25,0.05,0.26250000000000001]
[null,null,"=",5769,null,6058,null,1.29]
[null,null,"NET PROFIT",7731,null,17718,null,"INCREASE"]

{"sheet":"CALC'S","index":6,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["CALCULATIONS"]
[]
["PERIOD/STORE/PROD./DEPT.",{"$f":"INPUT!C4","v":"DEPT1"},null,{"$f":"INPUT!E4","v":"DEPT2"},null,{"$f":"INPUT!G4","v":"DEPT3"},null,{"$f":"INPUT!I4","v":"DEPT4"}]
[]
["GROSS PROFIT %",{"$f":"IF(INPUT!C6=0,0,(INPUT!C10*100)/INPUT!C6)","v":0},null,{"$f":"IF(INPUT!E6=0,0,(INPUT!E10*100)/INPUT!E6)","v":0},null,{"$f":"IF(INPUT!G6=0,0,(INPUT!G10*100)/INPUT!G6)","v":0},null,{"$f":"IF(INPUT!I6=0,0,(INPUT!I10*100)/INPUT!I6)","v":0}]
[]
["MARK UP %",{"$f":"ROUND(IF(INPUT!C7=0,IF(INPUT!C8=0,IF(INPUT!C9=0,0,(INPUT!C10*100)/(INPUT!C7+INPUT!C8-INPUT!C9)),(INPUT!C10*100)/(INPUT!C7+INPUT!C8-INPUT!C9)),(INPUT!C10*100)/(INPUT!C7+INPUT!C8-INPUT!C9)),2)","v":0},null,{"$f":"ROUND(IF(INPUT!E7=0,IF(INPUT!E8=0,IF(INPUT!E9=0,0,(INPUT!E10*100)/(INPUT!E7+INPUT!E8-INPUT!E9)),(INPUT!E10*100)/(INPUT!E7+INPUT!E8-INPUT!E9)),(INPUT!E10*100)/(INPUT!E7+INPUT!E8-INPUT!E9)),2)","v":0},null,{"$f":"ROUND(IF(INPUT!G7=0,IF(INPUT!G8=0,IF(INPUT!G9=0,0,(INPUT!G10*100)/(INPUT!G7+INPUT!G8-INPUT!G9)),(INPUT!G10*100)/(INPUT!G7+INPUT!G8-INPUT!G9)),(INPUT!G10*100)/(INPUT!G7+INPUT!G8-INPUT!G9)),2)","v":0},null,{"$f":"ROUND(IF(INPUT!I7=0,IF(INPUT!I8=0,IF(INPUT!I9=0,0,(INPUT!I10*100)/(INPUT!I7+INPUT!I8-INPUT!I9)),(INPUT!I10*100)/(INPUT!I7+INPUT!I8-INPUT!I9)),(INPUT!I10*100)/(INPUT!I7+INPUT!I8-INPUT!I9)),2)","v":0}]
[]
["WAGES %",{"$f":"ROUND(IF(INPUT!C6=0,0,(INPUT!C12*100)/INPUT!C6),2)","v":0},{"$f":"ROUND(IF(INPUT!D6=0,0,(INPUT!D12*100)/INPUT!D6),2)","v":0},{"$f":"ROUND(IF(INPUT!E6=0,0,(INPUT!E12*100)/INPUT!E6),2)","v":0},{"$f":"ROUND(IF(INPUT!F6=0,0,(INPUT!F12*100)/INPUT!F6),2)","v":0},{"$f":"ROUND(IF(INPUT!G6=0,0,(INPUT!G12*100)/INPUT!G6),2)","v":0},{"$f":"ROUND(IF(INPUT!H6=0,0,(INPUT!H12*100)/INPUT!H6),2)","v":0},{"$f":"ROUND(IF(INPUT!I6=0,0,(INPUT!I12*100)/INPUT!I6),2)","v":0}]
[]
["CONTRIBUTION %",{"$f":"ROUND(IF(INPUT!C6=0,0,(INPUT!C13*100)/INPUT!C6),2)","v":0},{"$f":"ROUND(IF(INPUT!D6=0,0,(INPUT!D13*100)/INPUT!D6),2)","v":0},{"$f":"ROUND(IF(INPUT!E6=0,0,(INPUT!E13*100)/INPUT!E6),2)","v":0},{"$f":"ROUND(IF(INPUT!F6=0,0,(INPUT!F13*100)/INPUT!F6),2)","v":0},{"$f":"ROUND(IF(INPUT!G6=0,0,(INPUT!G13*100)/INPUT!G6),2)","v":0},{"$f":"ROUND(IF(INPUT!H6=0,0,(INPUT!H13*100)/INPUT!H6),2)","v":0},{"$f":"ROUND(IF(INPUT!I6=0,0,(INPUT!I13*100)/INPUT!I6),2)","v":0}]
[]
["SALES PER PERSON",{"$f":"ROUND(IF(INPUT!C14=0,0,INPUT!C6/INPUT!C14),2)","v":0},{"$f":"ROUND(IF(INPUT!D14=0,0,INPUT!D6/INPUT!D14),2)","v":0},{"$f":"ROUND(IF(INPUT!E14=0,0,INPUT!E6/INPUT!E14),2)","v":0},{"$f":"ROUND(IF(INPUT!F14=0,0,INPUT!F6/INPUT!F14),2)","v":0},{"$f":"ROUND(IF(INPUT!G14=0,0,INPUT!G6/INPUT!G14),2)","v":0},{"$f":"ROUND(IF(INPUT!H14=0,0,INPUT!H6/INPUT!H14),2)","v":0},{"$f":"ROUND(IF(INPUT!I14=0,0,INPUT!I6/INPUT!I14),2)","v":0}]
[]
["SALES PER PERSON HOUR",{"$f":"ROUND(IF(INPUT!C14=0,IF(INPUT!C15=0,0,INPUT!C6/(INPUT!C14*INPUT!C15)),INPUT!C6/(INPUT!C14*INPUT!C15)),2)","v":0},{"$f":"ROUND(IF(INPUT!D14=0,IF(INPUT!D15=0,0,INPUT!D6/(INPUT!D14*INPUT!D15)),INPUT!D6/(INPUT!D14*INPUT!D15)),2)","v":0},{"$f":"ROUND(IF(INPUT!E14=0,IF(INPUT!E15=0,0,INPUT!E6/(INPUT!E14*INPUT!E15)),INPUT!E6/(INPUT!E14*INPUT!E15)),2)","v":0},{"$f":"ROUND(IF(INPUT!F14=0,IF(INPUT!F15=0,0,INPUT!F6/(INPUT!F14*INPUT!F15)),INPUT!F6/(INPUT!F14*INPUT!F15)),2)","v":0},{"$f":"ROUND(IF(INPUT!G14=0,IF(INPUT!G15=0,0,INPUT!G6/(INPUT!G14*INPUT!G15)),INPUT!G6/(INPUT!G14*INPUT!G15)),2)","v":0},{"$f":"ROUND(IF(INPUT!H14=0,IF(INPUT!H15=0,0,INPUT!H6/(INPUT!H14*INPUT!H15)),INPUT!H6/(INPUT!H14*INPUT!H15)),2)","v":0},{"$f":"ROUND(IF(INPUT!I14=0,IF(INPUT!I15=0,0,INPUT!I6/(INPUT!I14*INPUT!I15)),INPUT!I6/(INPUT!I14*INPUT!I15)),2)","v":0}]
[]
["SALES PER $ WAGE",{"$f":"ROUND(IF(INPUT!C12=0,0,INPUT!C6/INPUT!C12),2)","v":0},{"$f":"ROUND(IF(INPUT!D12=0,0,INPUT!D6/INPUT!D12),2)","v":0},{"$f":"ROUND(IF(INPUT!E12=0,0,INPUT!E6/INPUT!E12),2)","v":0},{"$f":"ROUND(IF(INPUT!F12=0,0,INPUT!F6/INPUT!F12),2)","v":0},{"$f":"ROUND(IF(INPUT!G12=0,0,INPUT!G6/INPUT!G12),2)","v":0},{"$f":"ROUND(IF(INPUT!H12=0,0,INPUT!H6/INPUT!H12),2)","v":0},{"$f":"ROUND(IF(INPUT!I12=0,0,INPUT!I6/INPUT!I12),2)","v":0}]
[]
["GROSS PROFIT PER $ WAGE",{"$f":"ROUND(IF(INPUT!C12=0,0,INPUT!C10/INPUT!C12),2)","v":0},{"$f":"ROUND(IF(INPUT!D12=0,0,INPUT!D10/INPUT!D12),2)","v":0},{"$f":"ROUND(IF(INPUT!E12=0,0,INPUT!E10/INPUT!E12),2)","v":0},{"$f":"ROUND(IF(INPUT!F12=0,0,INPUT!F10/INPUT!F12),2)","v":0},{"$f":"ROUND(IF(INPUT!G12=0,0,INPUT!G10/INPUT!G12),2)","v":0},{"$f":"ROUND(IF(INPUT!H12=0,0,INPUT!H10/INPUT!H12),2)","v":0},{"$f":"ROUND(IF(INPUT!I12=0,0,INPUT!I10/INPUT!I12),2)","v":0}]
[]
["AVE. SALE $ PER CUSTOMER",{"$f":"ROUND(IF(INPUT!C16=0,0,INPUT!C6/INPUT!C16),2)","v":0},{"$f":"ROUND(IF(INPUT!D16=0,0,INPUT!D6/INPUT!D16),2)","v":0},{"$f":"ROUND(IF(INPUT!E16=0,0,INPUT!E6/INPUT!E16),2)","v":0},{"$f":"ROUND(IF(INPUT!F16=0,0,INPUT!F6/INPUT!F16),2)","v":0},{"$f":"ROUND(IF(INPUT!G16=0,0,INPUT!G6/INPUT!G16),2)","v":0},{"$f":"ROUND(IF(INPUT!H16=0,0,INPUT!H6/INPUT!H16),2)","v":0},{"$f":"ROUND(IF(INPUT!I16=0,0,INPUT!I6/INPUT!I16),2)","v":0}]
[]
["AVE. SALE $ PER ITEM",{"$f":"ROUND(IF(INPUT!C17=0,0,INPUT!C6/INPUT!C17),2)","v":0},{"$f":"ROUND(IF(INPUT!D17=0,0,INPUT!D6/INPUT!D17),2)","v":0},{"$f":"ROUND(IF(INPUT!E17=0,0,INPUT!E6/INPUT!E17),2)","v":0},{"$f":"ROUND(IF(INPUT!F17=0,0,INPUT!F6/INPUT!F17),2)","v":0},{"$f":"ROUND(IF(INPUT!G17=0,0,INPUT!G6/INPUT!G17),2)","v":0},{"$f":"ROUND(IF(INPUT!H17=0,0,INPUT!H6/INPUT!H17),2)","v":0},{"$f":"ROUND(IF(INPUT!I17=0,0,INPUT!I6/INPUT!I17),2)","v":0}]
[]
["AVE. ITEMS PER CUSTOMER",{"$f":"ROUND(IF(INPUT!C16=0,0,INPUT!C17/INPUT!C16),2)","v":0},{"$f":"ROUND(IF(INPUT!D16=0,0,INPUT!D17/INPUT!D16),2)","v":0},{"$f":"ROUND(IF(INPUT!E16=0,0,INPUT!E17/INPUT!E16),2)","v":0},{"$f":"ROUND(IF(INPUT!F16=0,0,INPUT!F17/INPUT!F16),2)","v":0},{"$f":"ROUND(IF(INPUT!G16=0,0,INPUT!G17/INPUT!G16),2)","v":0},{"$f":"ROUND(IF(INPUT!H16=0,0,INPUT!H17/INPUT!H16),2)","v":0},{"$f":"ROUND(IF(INPUT!I16=0,0,INPUT!I17/INPUT!I16),2)","v":0}]
[]
["STOCKTURN",{"$f":"ROUND(IF(INPUT!C7=0,IF(INPUT!C9=0,0,(INPUT!C7+INPUT!C8-INPUT!C9)/((INPUT!C7+INPUT!C9)/2)),(INPUT!C7+INPUT!C8-INPUT!C9)/((INPUT!C7+INPUT!C9)/2)),2)","v":0},{"$f":"ROUND(IF(INPUT!D7=0,IF(INPUT!D9=0,0,(INPUT!D7+INPUT!D8-INPUT!D9)/((INPUT!D7+INPUT!D9)/2)),(INPUT!D7+INPUT!D8-INPUT!D9)/((INPUT!D7+INPUT!D9)/2)),2)","v":0},{"$f":"ROUND(IF(INPUT!E7=0,IF(INPUT!E9=0,0,(INPUT!E7+INPUT!E8-INPUT!E9)/((INPUT!E7+INPUT!E9)/2)),(INPUT!E7+INPUT!E8-INPUT!E9)/((INPUT!E7+INPUT!E9)/2)),2)","v":0},{"$f":"ROUND(IF(INPUT!F7=0,IF(INPUT!F9=0,0,(INPUT!F7+INPUT!F8-INPUT!F9)/((INPUT!F7+INPUT!F9)/2)),(INPUT!F7+INPUT!F8-INPUT!F9)/((INPUT!F7+INPUT!F9)/2)),2)","v":0},{"$f":"ROUND(IF(INPUT!G7=0,IF(INPUT!G9=0,0,(INPUT!G7+INPUT!G8-INPUT!G9)/((INPUT!G7+INPUT!G9)/2)),(INPUT!G7+INPUT!G8-INPUT!G9)/((INPUT!G7+INPUT!G9)/2)),2)","v":0},{"$f":"ROUND(IF(INPUT!H7=0,IF(INPUT!H9=0,0,(INPUT!H7+INPUT!H8-INPUT!H9)/((INPUT!H7+INPUT!H9)/2)),(INPUT!H7+INPUT!H8-INPUT!H9)/((INPUT!H7+INPUT!H9)/2)),2)","v":0},{"$f":"ROUND(IF(INPUT!I7=0,IF(INPUT!I9=0,0,(INPUT!I7+INPUT!I8-INPUT!I9)/((INPUT!I7+INPUT!I9)/2)),(INPUT!I7+INPUT!I8-INPUT!I9)/((INPUT!I7+INPUT!I9)/2)),2)","v":0}]