{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Macros Required","Scratch","Welcome","Form","Table","Template"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":208,"comments":1,"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":"Macros Required","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Macros Required - \" & title","v":"Macros Required - Product Supplier Profitability"}]
[]
[null," Macros must be enabled for this application to function."]
[]
[null,"Please refer to your spreadsheet Help for details on how to enable macros."]
[]
[null,"Suitability must be independently assessed and use indicates acceptance of any and all associated risk."]

{"sheet":"Scratch","index":1,"n_rows":107,"n_cols":10,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E42:E46)","v":678}]
[null,{"$f":"1","v":1},"p",{"$f":"IFERROR(CODE(C42),0)","v":112},{"$f":"B42*D42","v":112}]
[null,{"$f":"B42+1","v":2},"s",{"$f":"IFERROR(CODE(C43),0)","v":115},{"$f":"B43*D43","v":230}]
[null,3,"p",112,336]
[null,4,null,0,0]
[null,5,null,0,0]
[]
[]
[]
[null," In evaluation mode functionality is limited."]
[]
[null,"Locked",500000]
[null,{"$f":"IFERROR(AND(ISTEXT(Welcome!C18),LEN(Welcome!C18)>6),FALSE)","v":false},null,"emall len >6"]
[null,{"$f":"IFERROR(AND(ISNUMBER(INT(Welcome!C19)),LEN(Welcome!C19)>8),FALSE)","v":false},{"$f":"IFERROR(Welcome!C19/Scratch!E57/E41,FALSE)","v":0},"code len>8","yyyymmdd=code/emailchsum/i"]
[null,{"$f":"IFERROR(AND(ISNUMBER(C54),LEN(C54)=8,TODAY()<C55+7),FALSE)","v":false},{"$f":"IFERROR(DATE(MID(C54,1,4),MID(C54,5,2),MID(C54,7,2)),FALSE)","v":false},null,"yyyymmdd len=8",null,"IF(ISNUMBER(C55),IF(C55>TODAY()+3650,2,IF(C55>TODAY()-2,1,0)),0)"]
[null,null,{"$f":"IF(ISNUMBER(C55),IF(C55>TODAY()+3650,2,IF(C55>TODAY()-2,1,0)),0)","v":0},"status",">today+36500days=2",null,null,null,20211112,{"$f":"I56*J57*E41","v":0}]
[null,null,null,null,{"$f":"SUM(E58:E107)","v":28180},null,null,null,null,{"$f":"SUM(J58:J107)","v":0}]
[null,{"$f":"1","v":1},"b",{"$f":"IFERROR(CODE(C58),0)","v":98},{"$f":"B58*D58","v":98},null,{"$f":"1","v":1},{"$f":"MID($G$56,G58,1)","v":""},{"$f":"IFERROR(CODE(H58),0)","v":0},{"$f":"G58*I58","v":0}]
[null,{"$f":"B58+1","v":2},"u",117,234,null,{"$f":"G58+1","v":2},{"$f":"MID($G$56,G59,1)","v":""},0,0]
[null,3,"y",121,363,null,3,"",0,0]
[null,4,"e",101,404,null,4,"",0,0]
[null,5,"r",114,570,null,5,"",0,0]
[null,6,"@",64,384,null,6,"",0,0]
[null,7,"p",112,784,null,7,"",0,0]
[null,8,"a",97,776,null,8,"",0,0]
[null,9,"y",121,1089,null,9,"",0,0]
[null,10,"p",112,1120,null,10,"",0,0]
[null,11,"a",97,1067,null,11,"",0,0]
[null,12,"l",108,1296,null,12,"",0,0]
[null,13,"s",115,1495,null,13,"",0,0]
[null,14,"a",97,1358,null,14,"",0,0]
[null,15,"n",110,1650,null,15,"",0,0]
[null,16,"d",100,1600,null,16,"",0,0]
[null,17,"b",98,1666,null,17,"",0,0]
[null,18,"o",111,1998,null,18,"",0,0]
[null,19,"x",120,2280,null,19,"",0,0]
[null,20,".",46,920,null,20,"",0,0]
[null,21,"c",99,2079,null,21,"",0,0]
[null,22,"o",111,2442,null,22,"",0,0]
[null,23,"m",109,2507,null,23,"",0,0]
[null,24,"",0,0,null,24,"",0,0]
[null,25,"",0,0,null,25,"",0,0]
[null,26,"",0,0,null,26,"",0,0]
[null,27,"",0,0,null,27,"",0,0]
[null,28,"",0,0,null,28,"",0,0]
[null,29,"",0,0,null,29,"",0,0]
[null,30,"",0,0,null,30,"",0,0]
[null,31,"",0,0,null,31,"",0,0]
[null,32,"",0,0,null,32,"",0,0]
[null,33,"",0,0,null,33,"",0,0]
[null,34,"",0,0,null,34,"",0,0]
[null,35,"",0,0,null,35,"",0,0]
[null,36,"",0,0,null,36,"",0,0]
[null,37,"",0,0,null,37,"",0,0]
[null,38,"",0,0,null,38,"",0,0]
[null,39,"",0,0,null,39,"",0,0]
[null,40,"",0,0,null,40,"",0,0]
[null,41,"",0,0,null,41,"",0,0]
[null,42,"",0,0,null,42,"",0,0]
[null,43,"",0,0,null,43,"",0,0]
[null,44,"",0,0,null,44,"",0,0]
[null,45,"",0,0,null,45,"",0,0]
[null,46,"",0,0,null,46,"",0,0]
[null,47,"",0,0,null,47,"",0,0]
[null,48,"",0,0,null,48,"",0,0]
[null,49,"",0,0,null,49,"",0,0]
[null,50,"",0,0,null,50,"",0,0]

{"sheet":"Welcome","index":2,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,1,5,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[22,1,22,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[6,1,8,2],[12,1,12,2],[13,1,13,2],[14,1,15,2],[20,1,20,2],[21,1,21,2]]}
[null,"Product Supplier Profitability"]
[]
[null,"Build: 20211117 by bizpep.com"]
[]
[]
[]
[null,"Input is via the Form sheet. Use the tabs at the bottom of the window to select the Form sheet to start. On the form sheet mouseover the red cell markers for Help."]
[]
[]
[]
[null,{"$f":"IF(Scratch!B55=TRUE,\"Current license subscriptions can be managed directly from your PayPal account.\",\"In evaluation mode functionality is restriced.\")","v":"In evaluation mode functionality is restriced."}]
[null,{"$f":"IF(Scratch!B55=TRUE,\"On renewal new License Details will be emailed. You can purchase at new license at:\",\"To fully enable this application please purchase a license at:\")","v":"To fully enable this application please purchase a license at:"}]
[null,"https://bizpep.com/productsupplierprofitability.html?display=license"]
[null,{"$f":"IF(Scratch!B55=TRUE,\"Current license details fully enable your application\",\"License Details are sent by email, on reciept input license details to fully enable your application.\")","v":"License Details are sent by email, on reciept input license details to fully enable your application."}]
[]
[]
[null,"Application License Details:"]
[null,"Licensed Email Address:"]
[null,"License Code:"]
[null,"License Valid to Date:",{"$f":"IF(Scratch!B55=TRUE,Scratch!C55,\"Not Licensed, for Evaluation Only.\")","v":"Not Licensed, for Evaluation Only."}]
[]
[null,"Suitability must be independently assessed and use indicates acceptance of any and all associated risk."]

{"sheet":"Form","index":3,"n_rows":57,"n_cols":27,"rows_kept":57,"cut":false,"hidden":false,"merged":[[32,1,32,2],[20,1,20,2],[19,1,19,2],[12,10,13,10],[7,1,7,2],[7,3,7,6],[13,1,13,2],[13,4,13,5],[12,9,13,9],[22,1,22,2],[20,4,20,5],[61,1,61,11],[62,1,62,11],[46,4,46,5],[44,1,44,2],[54,5,54,6],[49,1,49,2],[50,1,50,2],[48,1,48,2],[67,1,67,11],[26,1,26,2],[43,1,43,2],[58,1,58,11],[52,1,52,6],[64,1,64,11],[65,1,65,11],[66,1,66,11],[42,1,42,2],[56,5,56,6],[63,1,63,11],[50,4,50,5],[36,5,36,6],[32,4,32,5],[59,1,59,11],[60,1,60,11],[1,4,1,10],[2,4,2,10],[29,1,29,6],[38,1,38,6],[35,1,35,2],[34,3,34,5],[24,1,24,2],[9,8,9,10],[9,2,9,4],[23,1,23,2],[27,1,27,2],[12,8,13,8],[36,1,36,2],[18,1,18,2],[18,4,18,5],[21,1,21,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Profile Template - "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Business Profile"]
[]
[]
[]
[null,"Mouseover for Help",null,null,null,null,null,null,"Form View",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Business Profile"]
[]
[null,"Select Profile from list ",null,"Base Profile Template - ",null,null,null,null,"to","or","."]
[]
[null,"Supplier","Base Profile Template",null,null,null,"Product"]
[]
[]
[null,"Sales",null,null,null,null,null,null,"Unit","Total for Profile","Percentage of Sales"]
[null,"Average Unit Selling Price",null,null,"Breakeven Selling Price",null,{"$f":"+costs_unit","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,"Sales",null,{"$f":"+selling","v":0},{"$f":"+sales_unit*units","v":0},{"$f":"+sales_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[]
[null,"Purchase"]
[null,"Number of Units Purchased",null,null,"Unit Purchase Cost",null,null,null,{"$f":"+purchase","v":0},{"$f":"+purchase_unit*units","v":0},{"$f":"+purchase_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[null,"Transport"]
[null,"Number of Units per Shipment",null,null,"Number of Shipments",null,{"$f":"+units/shipment_units","v":{"$error":"#DIV/0!"}}]
[null,"Cost per Shipment",null,null,null,null,null,null,{"$f":"+shipment_cost/shipment_units","v":{"$error":"#DIV/0!"}},{"$f":"+transport_unit*units","v":{"$error":"#DIV/0!"}},{"$f":"+transport_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[null,"Receiving"]
[null,"Unpacking Cost per Shipment",null,null,null,null,null,null,{"$f":"IF(ISERROR((pick_pallet_costf/units_per_palletf)*((100-direct_deliveryf)/100)),\"\",(pick_pallet_costf/units_per_palletf)*((100-direct_deliveryf)/100))","v":""},{"$f":"IF(ISERROR(pick_pallet_costf*(total_palletsf*((100-direct_deliveryf)/100))),\"\",pick_pallet_costf*(total_palletsf*((100-direct_deliveryf)/100)))","v":""},{"$f":"IF(ISERROR(total_pickf/(unitsf*sellingf)),\"\",total_pickf/(unitsf*sellingf))","v":""}]
[null,"Inspection Cost per Shipment",null,null,null,null,null,null,{"$f":"(+inspection+unpacking)/shipment_units","v":{"$error":"#DIV/0!"}},{"$f":"+receiving_unit*units","v":{"$error":"#DIV/0!"}},{"$f":"+receiving_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[null,"Reject"]
[null,"Rejected and Returned",null,null,"%","Number Rejected",{"$f":"+reject/100*units","v":0}]
[null,"Return Cost per Unit",null,null,null,null,null,null,{"$f":"+reject_total/units","v":{"$error":"#DIV/0!"}},{"$f":"+return*reject_number","v":0},{"$f":"+reject_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[]
[null,"Initial Costs",null,null,null,null,null,null,{"$f":"+purchase_unit+transport_unit+receiving_unit+reject_unit","v":{"$error":"#DIV/0!"}},{"$f":"+reject_total+receiving_total+transport_total+purchase_total","v":{"$error":"#DIV/0!"}},{"$f":"+initial_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[]
[null,"Storage"]
[null,"Shipment Storage Cost per Week",null,null,"Stockturn per Annum"]
[null,null,null,null,null,"Sensitivity",0,"%"]
[null,null,null,"Stockturn Adjusted",null,null,{"$f":"stockturn_in*(1+stockturn_sensitivity/100)","v":0},null,{"$f":"+storage_total/units","v":{"$error":"#DIV/0!"}},{"$f":"shipment_number*storage*52/stockturn","v":{"$error":"#DIV/0!"}},{"$f":"+storage_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[null,"Overheads"]
[null,"Contribution to fixed overheads",null,null,"%","as a percentage of selling price.",null,null,{"$f":"+overheads/100*selling","v":0},{"$f":"+overheads_unit*units","v":0},{"$f":"+overheads_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[]
[null,"On-going Costs",null,null,null,null,null,null,{"$f":"+storage_unit+overheads_unit","v":{"$error":"#DIV/0!"}},{"$f":"+storage_total+overheads_total","v":{"$error":"#DIV/0!"}},{"$f":"+on_going_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[]
[null,"Finance"]
[null,null,"Debtor Days",null,null,"Creditor Days"]
[null,"Annual Interest Rate",null,null,"%","Financed Days",{"$f":"365/stockturn+debtor-creditor","v":{"$error":"#DIV/0!"}},null,{"$f":"+financed_days*interest/100/365*(initial_unit+on_going_unit/2)","v":{"$error":"#DIV/0!"}},{"$f":"+finance_unit*units","v":{"$error":"#DIV/0!"}},{"$f":"+finance_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[null,"Customer Returns"]
[null,"Administration Cost per Return",null,null,null,"Returns",null,"%"]
[null,null,null,null,null,"Sensitivity",0,"%"]
[null,null,null,null,"Returns Adjusted",null,{"$f":"+customer_returns_in*(1+customer_returns_sensitivity/100)","v":0},"%"]
[null,null,null,null,null,"Number Returned",{"$f":"+customer_returns/100*units","v":0}]
[null,"Returns Written Off",null,null,"%","Number Written Off",{"$f":"+written_off/100*customer_returns/100*units","v":0}]
[null,"Repair Cost per Unit",null,null,null,"Number Repaired",{"$f":"customer_returns/100*units-written_off_number","v":0}]
[null,"Storage Weeks per Unit Repaired",null,null,"Storage Cost per Repair",null,{"$f":"+storage/shipment_units*repair_weeks","v":{"$error":"#DIV/0!"}},null,{"$f":"+customer_returns_total/units","v":{"$error":"#DIV/0!"}},{"$f":"customer_returns_number*customer_returns_admin+written_off_number*selling+(repair+repair_storage)*repair_number","v":{"$error":"#DIV/0!"}},{"$f":"+customer_returns_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[]
[null,"Other Costs",null,null,null,null,null,null,{"$f":"customer_returns_unit+finance_unit","v":{"$error":"#DIV/0!"}},{"$f":"+customer_returns_total+finance_total","v":{"$error":"#DIV/0!"}},{"$f":"+other_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Total Costs",null,null,{"$f":"+other_unit+on_going_unit+initial_unit","v":{"$error":"#DIV/0!"}},{"$f":"+other_total+on_going_total+initial_total","v":{"$error":"#DIV/0!"}},{"$f":"+costs_unit/selling*100","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Profit/Loss",null,null,{"$f":"+sales_unit-costs_unit","v":{"$error":"#DIV/0!"}},{"$f":"+sales_total-costs_total","v":{"$error":"#DIV/0!"}},{"$f":"+profit_unit/selling*100","v":{"$error":"#DIV/0!"}}]

{"sheet":"Table","index":4,"n_rows":8,"n_cols":83,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[]
[null,"Table View",null,{"$f":"+Form!G16","v":"Sales"},null,null,null,null,{"$f":"+Form!B18","v":"Purchase"},null,null,null,null,{"$f":"+Form!B20","v":"Transport"},null,null,null,null,null,{"$f":"+Form!B23","v":"Receiving"},null,null,null,null,null,null,{"$f":"+Form!B26","v":"Reject"},null,null,null,null,null,{"$f":"+Form!B30","v":"Initial Costs"},null,null,{"$f":"+Form!B32","v":"Storage"},null,null,null,null,null,{"$f":"+Form!B36","v":"Overheads"},null,null,null,{"$f":"+Form!B39","v":"On-going Costs"},null,null,{"$f":"+Form!B41","v":"Finance"},null,null,null,null,null,null,null,null,null,{"$f":"+Form!B44","v":"Customer Returns"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Form!B53","v":"Other Costs"},null,null,{"$f":"+Form!F55","v":"Total Costs"},null,null,{"$f":"+Form!F57","v":"Profit/Loss"}]
[null,{"$f":"+Form!B10","v":"Supplier"},{"$f":"+Form!G10","v":"Product"},{"$f":"+Form!B14","v":"Average Unit Selling Price"},{"$f":"+Form!E14","v":"Breakeven Selling Price"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!B19","v":"Number of Units Purchased"},{"$f":"+Form!E19","v":"Unit Purchase Cost"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!B21","v":"Number of Units per Shipment"},{"$f":"+Form!E21","v":"Number of Shipments"},{"$f":"+Form!B22","v":"Cost per Shipment"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!B24","v":"Unpacking Cost per Shipment"},"Unpacking Cost Total",{"$f":"+Form!B25","v":"Inspection Cost per Shipment"},"Inspection Cost Total",{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!B27","v":"Rejected and Returned"},{"$f":"+Form!F27","v":"Number Rejected"},{"$f":"+Form!B28","v":"Return Cost per Unit"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!B33","v":"Shipment Storage Cost per Week"},{"$f":"+Form!E33","v":"Stockturn per Annum"},"Storage Weeks",{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!B37","v":"Contribution to fixed overheads"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!C42","v":"Debtor Days"},"Debtor Days Total",{"$f":"+Form!F42","v":"Creditor Days"},"Creditor Days Total",{"$f":"+Form!B43","v":"Annual Interest Rate"},{"$f":"+Form!F43","v":"Financed Days"},"Financed Days Total",{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!B45","v":"Administration Cost per Return"},{"$f":"+Form!F45","v":"Returns"},{"$f":"+Form!F48","v":"Number Returned"},"Administration Cost Total",{"$f":"+Form!B49","v":"Returns Written Off"},{"$f":"+Form!F49","v":"Number Written Off"},{"$f":"+Form!B50","v":"Repair Cost per Unit"},{"$f":"+Form!F50","v":"Number Repaired"},"Repair Cost Total",{"$f":"+Form!B51","v":"Storage Weeks per Unit Repaired"},"Storage Weeks Total",{"$f":"+Form!E51","v":"Storage Cost per Repair"},"Repair Storage Cost Total",{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"},{"$f":"+Form!$I13","v":"Unit"},{"$f":"+Form!$J13","v":"Total for Profile"},{"$f":"+Form!$K13","v":"Percentage of Sales"}]
[null,null,null,"Revenue","Revenue","Revenue","Revenue","%","#","Cost","Cost","Cost",{"$f":"+$H5","v":"%"},"#","#",{"$f":"$J5","v":"Cost"},{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},{"$f":"$J5","v":"Cost"},{"$f":"$J5","v":"Cost"},{"$f":"$J5","v":"Cost"},{"$f":"$J5","v":"Cost"},{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},"%","#",{"$f":"$J5","v":"Cost"},{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},{"$f":"$J5","v":"Cost"},"#","#",{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},"%",{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},"#","X Units","#","X Units","%","#","X Units",{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},{"$f":"$J5","v":"Cost"},"%","#",{"$f":"$J5","v":"Cost"},"%","#",{"$f":"$J5","v":"Cost"},"#",{"$f":"$J5","v":"Cost"},"#","#",{"$f":"$J5","v":"Cost"},{"$f":"$J5","v":"Cost"},{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},{"$f":"$K5","v":"Cost"},{"$f":"$L5","v":"Cost"},{"$f":"$M5","v":"%"},"Profit","Profit",{"$f":"+$H5","v":"%"}]
[]
[]
[null,"Total Business Profile",null,{"$f":"+salestb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"+coststb_unit","v":{"$error":"#DIV/0!"}},{"$f":"+salestb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",G6:G7)","v":0},{"$f":"+salestb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",I6:I7)","v":0},{"$f":"+purchasetb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"+purchasetb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",L6:L7)","v":0},{"$f":"+purchasetb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+unitstb/shipment_numbertb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",O6:O7)","v":0},{"$f":"+transporttb_total/shipment_numbertb","v":{"$error":"#DIV/0!"}},{"$f":"+transporttb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",R6:R7)","v":0},{"$f":"+transporttb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+unpackingtb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",U6:U7)","v":0},{"$f":"+inspectiontb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",W6:W7)","v":0},{"$f":"+receivingtb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",Y6:Y7)","v":0},{"$f":"+receivingtb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+reject_numbertb/unitstb*100","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AB6:AB7)","v":0},{"$f":"+rejecttb_total/reject_numbertb","v":{"$error":"#DIV/0!"}},{"$f":"+rejecttb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AE6:AE7)","v":0},{"$f":"rejecttb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+initialtb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AH6:AH7)","v":0},{"$f":"+initialtb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"storagetb_total/storage_weekstb","v":{"$error":"#DIV/0!"}},{"$f":"52*shipment_numbertb/storage_weekstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AL6:AL7)","v":0},{"$f":"+storagetb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AN6:AN7)","v":0},{"$f":"+storagetb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+overheadstb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+overheadstb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AR6:AR7)","v":0},{"$f":"+overheadstb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+on_goingtb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AU6:AU7)","v":0},{"$f":"+on_goingtb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+debtor_days_unitstb/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AX6:AX7)","v":0},{"$f":"+creditor_days_unitstb/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",AZ6:AZ7)","v":0},{"$f":"+financetb_unit/financed_daystb/(initialtb_unit+on_goingtb_unit/2)*365*100","v":{"$error":"#DIV/0!"}},{"$f":"financed_days_unitstb/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BC6:BC7)","v":0},{"$f":"+financetb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BE6:BE7)","v":0},{"$f":"+financetb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+customer_returns_admin_totaltb/customer_returns_numbertb","v":{"$error":"#DIV/0!"}},{"$f":"+customer_returns_numbertb/unitstb*100","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BI6:BI7)","v":0},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BJ6:BJ7)","v":0},{"$f":"+written_off_numbertb/unitstb*100","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BL6:BL7)","v":0},{"$f":"+repair_cost_totaltb/repair_numbertb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BN6:BN7)","v":0},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BO6:BO7)","v":0},{"$f":"+repair_weeks_totaltb/repair_numbertb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BQ6:BQ7)","v":0},{"$f":"+repair_storage_totaltb/repair_weeks_totaltb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BS6:BS7)","v":0},{"$f":"+customer_returnstb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BU6:BU7)","v":0},{"$f":"+customer_returnstb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+othertb_total/unitstb","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(Include_in_Total,\"TRUE\",BX6:BX7)","v":0},{"$f":"+othertb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+othertb_unit+on_goingtb_unit+initialtb_unit","v":{"$error":"#DIV/0!"}},{"$f":"+othertb_total+on_goingtb_total+initialtb_total","v":0},{"$f":"+coststb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}},{"$f":"+salestb_unit-coststb_unit","v":{"$error":"#DIV/0!"}},{"$f":"+salestb_total-coststb_total","v":0},{"$f":"+profittb_unit/sellingtb*100","v":{"$error":"#DIV/0!"}}]

{"sheet":"Template","index":5,"n_rows":7,"n_cols":83,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[]
[null,"Template",null,{"$f":"Table!D3","v":"Sales"},null,null,null,null,{"$f":"Table!I3","v":"Purchase"},null,null,null,null,{"$f":"Table!N3","v":"Transport"},null,null,null,null,null,{"$f":"Table!T3","v":"Receiving"},null,null,null,null,null,null,{"$f":"Table!AA3","v":"Reject"},null,null,null,null,null,{"$f":"Table!AG3","v":"Initial Costs"},null,null,{"$f":"Table!AJ3","v":"Storage"},null,null,null,null,null,{"$f":"Table!AP3","v":"Overheads"},null,null,null,{"$f":"Table!AT3","v":"On-going Costs"},null,null,{"$f":"Table!AW3","v":"Finance"},null,null,null,null,null,null,null,null,null,{"$f":"Table!BG3","v":"Customer Returns"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table!BW3","v":"Other Costs"},null,null,{"$f":"Table!BZ3","v":"Total Costs"},null,null,{"$f":"Table!CC3","v":"Profit/Loss"}]
[null,{"$f":"Table!B4","v":"Supplier"},{"$f":"Table!C4","v":"Product"},{"$f":"Table!D4","v":"Average Unit Selling Price"},{"$f":"Table!E4","v":"Breakeven Selling Price"},{"$f":"Table!F4","v":"Unit"},{"$f":"Table!G4","v":"Total for Profile"},{"$f":"Table!H4","v":"Percentage of Sales"},{"$f":"Table!I4","v":"Number of Units Purchased"},{"$f":"Table!J4","v":"Unit Purchase Cost"},{"$f":"Table!K4","v":"Unit"},{"$f":"Table!L4","v":"Total for Profile"},{"$f":"Table!M4","v":"Percentage of Sales"},{"$f":"Table!N4","v":"Number of Units per Shipment"},{"$f":"Table!O4","v":"Number of Shipments"},{"$f":"Table!P4","v":"Cost per Shipment"},{"$f":"Table!Q4","v":"Unit"},{"$f":"Table!R4","v":"Total for Profile"},{"$f":"Table!S4","v":"Percentage of Sales"},{"$f":"Table!T4","v":"Unpacking Cost per Shipment"},{"$f":"Table!U4","v":"Unpacking Cost Total"},{"$f":"Table!V4","v":"Inspection Cost per Shipment"},{"$f":"Table!W4","v":"Inspection Cost Total"},{"$f":"Table!X4","v":"Unit"},{"$f":"Table!Y4","v":"Total for Profile"},{"$f":"Table!Z4","v":"Percentage of Sales"},{"$f":"Table!AA4","v":"Rejected and Returned"},{"$f":"Table!AB4","v":"Number Rejected"},{"$f":"Table!AC4","v":"Return Cost per Unit"},{"$f":"Table!AD4","v":"Unit"},{"$f":"Table!AE4","v":"Total for Profile"},{"$f":"Table!AF4","v":"Percentage of Sales"},{"$f":"Table!AG4","v":"Unit"},{"$f":"Table!AH4","v":"Total for Profile"},{"$f":"Table!AI4","v":"Percentage of Sales"},{"$f":"Table!AJ4","v":"Shipment Storage Cost per Week"},{"$f":"Table!AK4","v":"Stockturn per Annum"},{"$f":"Table!AL4","v":"Storage Weeks"},{"$f":"Table!AM4","v":"Unit"},{"$f":"Table!AN4","v":"Total for Profile"},{"$f":"Table!AO4","v":"Percentage of Sales"},{"$f":"Table!AP4","v":"Contribution to fixed overheads"},{"$f":"Table!AQ4","v":"Unit"},{"$f":"Table!AR4","v":"Total for Profile"},{"$f":"Table!AS4","v":"Percentage of Sales"},{"$f":"Table!AT4","v":"Unit"},{"$f":"Table!AU4","v":"Total for Profile"},{"$f":"Table!AV4","v":"Percentage of Sales"},{"$f":"Table!AW4","v":"Debtor Days"},{"$f":"Table!AX4","v":"Debtor Days Total"},{"$f":"Table!AY4","v":"Creditor Days"},{"$f":"Table!AZ4","v":"Creditor Days Total"},{"$f":"Table!BA4","v":"Annual Interest Rate"},{"$f":"Table!BB4","v":"Financed Days"},{"$f":"Table!BC4","v":"Financed Days Total"},{"$f":"Table!BD4","v":"Unit"},{"$f":"Table!BE4","v":"Total for Profile"},{"$f":"Table!BF4","v":"Percentage of Sales"},{"$f":"Table!BG4","v":"Administration Cost per Return"},{"$f":"Table!BH4","v":"Returns"},{"$f":"Table!BI4","v":"Number Returned"},{"$f":"Table!BJ4","v":"Administration Cost Total"},{"$f":"Table!BK4","v":"Returns Written Off"},{"$f":"Table!BL4","v":"Number Written Off"},{"$f":"Table!BM4","v":"Repair Cost per Unit"},{"$f":"Table!BN4","v":"Number Repaired"},{"$f":"Table!BO4","v":"Repair Cost Total"},{"$f":"Table!BP4","v":"Storage Weeks per Unit Repaired"},{"$f":"Table!BQ4","v":"Storage Weeks Total"},{"$f":"Table!BR4","v":"Storage Cost per Repair"},{"$f":"Table!BS4","v":"Repair Storage Cost Total"},{"$f":"Table!BT4","v":"Unit"},{"$f":"Table!BU4","v":"Total for Profile"},{"$f":"Table!BV4","v":"Percentage of Sales"},{"$f":"Table!BW4","v":"Unit"},{"$f":"Table!BX4","v":"Total for Profile"},{"$f":"Table!BY4","v":"Percentage of Sales"},{"$f":"Table!BZ4","v":"Unit"},{"$f":"Table!CA4","v":"Total for Profile"},{"$f":"Table!CB4","v":"Percentage of Sales"},{"$f":"Table!CC4","v":"Unit"},{"$f":"Table!CD4","v":"Total for Profile"},{"$f":"Table!CE4","v":"Percentage of Sales"}]
[null,null,null,{"$f":"Table!D5","v":"Revenue"},{"$f":"Table!E5","v":"Revenue"},{"$f":"Table!F5","v":"Revenue"},{"$f":"Table!G5","v":"Revenue"},{"$f":"Table!H5","v":"%"},{"$f":"Table!I5","v":"#"},{"$f":"Table!J5","v":"Cost"},{"$f":"Table!K5","v":"Cost"},{"$f":"Table!L5","v":"Cost"},{"$f":"Table!M5","v":"%"},{"$f":"Table!N5","v":"#"},{"$f":"Table!O5","v":"#"},{"$f":"Table!P5","v":"Cost"},{"$f":"Table!Q5","v":"Cost"},{"$f":"Table!R5","v":"Cost"},{"$f":"Table!S5","v":"%"},{"$f":"Table!T5","v":"Cost"},{"$f":"Table!U5","v":"Cost"},{"$f":"Table!V5","v":"Cost"},{"$f":"Table!W5","v":"Cost"},{"$f":"Table!X5","v":"Cost"},{"$f":"Table!Y5","v":"Cost"},{"$f":"Table!Z5","v":"%"},{"$f":"Table!AA5","v":"%"},{"$f":"Table!AB5","v":"#"},{"$f":"Table!AC5","v":"Cost"},{"$f":"Table!AD5","v":"Cost"},{"$f":"Table!AE5","v":"Cost"},{"$f":"Table!AF5","v":"%"},{"$f":"Table!AG5","v":"Cost"},{"$f":"Table!AH5","v":"Cost"},{"$f":"Table!AI5","v":"%"},{"$f":"Table!AJ5","v":"Cost"},{"$f":"Table!AK5","v":"#"},{"$f":"Table!AL5","v":"#"},{"$f":"Table!AM5","v":"Cost"},{"$f":"Table!AN5","v":"Cost"},{"$f":"Table!AO5","v":"%"},{"$f":"Table!AP5","v":"%"},{"$f":"Table!AQ5","v":"Cost"},{"$f":"Table!AR5","v":"Cost"},{"$f":"Table!AS5","v":"%"},{"$f":"Table!AT5","v":"Cost"},{"$f":"Table!AU5","v":"Cost"},{"$f":"Table!AV5","v":"%"},{"$f":"Table!AW5","v":"#"},{"$f":"Table!AX5","v":"X Units"},{"$f":"Table!AY5","v":"#"},{"$f":"Table!AZ5","v":"X Units"},{"$f":"Table!BA5","v":"%"},{"$f":"Table!BB5","v":"#"},{"$f":"Table!BC5","v":"X Units"},{"$f":"Table!BD5","v":"Cost"},{"$f":"Table!BE5","v":"Cost"},{"$f":"Table!BF5","v":"%"},{"$f":"Table!BG5","v":"Cost"},{"$f":"Table!BH5","v":"%"},{"$f":"Table!BI5","v":"#"},{"$f":"Table!BJ5","v":"Cost"},{"$f":"Table!BK5","v":"%"},{"$f":"Table!BL5","v":"#"},{"$f":"Table!BM5","v":"Cost"},{"$f":"Table!BN5","v":"#"},{"$f":"Table!BO5","v":"Cost"},{"$f":"Table!BP5","v":"#"},{"$f":"Table!BQ5","v":"#"},{"$f":"Table!BR5","v":"Cost"},{"$f":"Table!BS5","v":"Cost"},{"$f":"Table!BT5","v":"Cost"},{"$f":"Table!BU5","v":"Cost"},{"$f":"Table!BV5","v":"%"},{"$f":"Table!BW5","v":"Cost"},{"$f":"Table!BX5","v":"Cost"},{"$f":"Table!BY5","v":"%"},{"$f":"Table!BZ5","v":"Cost"},{"$f":"Table!CA5","v":"Cost"},{"$f":"Table!CB5","v":"%"},{"$f":"Table!CC5","v":"Profit"},{"$f":"Table!CD5","v":"Profit"},{"$f":"Table!CE5","v":"%"}]
[]
[true,"Base Profile Template",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+unpackingtb*shipment_numbertb","v":0},null,{"$f":"+inspectiontb*shipment_numbertb","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"52/stockturntb*shipment_numbertb","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+debtortb*unitstb","v":0},null,{"$f":"+creditortb*unitstb","v":0},null,null,{"$f":"financed_daystb*unitstb","v":0},null,null,null,null,null,null,{"$f":"+customer_returns_admintb*customer_returnstb/100*unitstb","v":0},null,null,null,null,{"$f":"+repairtb*repair_numbertb","v":0},null,{"$f":"+repair_weekstb*repair_numbertb","v":0},null,{"$f":"+repair_weeks_totaltb*repair_storagetb","v":0}]