{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Timing","Inventory Example","Error Checks","Change Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":32,"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":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"SumProduct Training"}]
[null,null,{"$f":"Model_Name","v":"Example Generic Inventory Model.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple template to illustrate how inventory might work."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"Example Generic Inventory Model.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,{"$f":"Overall_Error_Check","v":0}]
[]
[]
[null,1,"Table of Contents"]
[]
[null,null,null,null,null,"Cover"]
[null,null,null,null,null,"Style Guide"]
[null,null,null,null,null,"Model Parameters"]
[null,null,null,null,null,"Timing"]
[null,null,null,null,null,"Inventory Example"]
[null,null,null,null,null,"Error Checks"]
[null,null,null,null,null,"Change Log"]

{"sheet":"Style Guide","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[16,2,16,6],[2,0,2,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Style Guide"}]
[{"$f":"Model_Name","v":"Example Generic Inventory Model.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Formatting of Headers / Dividers"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Sheet Title",null,null,null,null,null,{"$f":"C10","v":"Sheet Title"},null,"Sheet Title"]
[null,null,"Model Name",null,null,null,null,null,{"$f":"C11","v":"Model Name"},null,"Model Name"]
[]
[null,null,"Header 1",null,null,null,null,null,{"$f":"C13","v":"Header 1"},null,"Header 1"]
[null,null,"Header 2",null,null,null,null,null,{"$f":"C14","v":"Header 2"},null,"Header 2"]
[null,null,"Header 3",null,null,null,null,null,{"$f":"C15","v":"Header 3"},null,"Header 3"]
[null,null,"Header 4",null,null,null,null,null,{"$f":"C16","v":"Header 4"},null,"Header 4"]
[]
[null,null,"Notes",null,null,null,null,null,{"$f":"C18","v":"Notes"},null,"Notes"]
[]
[null,null,"Table Heading",null,null,null,null,null,{"$f":"C20","v":"Table Heading"},null,"Table Heading"]
[]
[]
[null,{"$f":"MAX($B$5:$B22)+1","v":2},"Individual Cell Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Assumption",null,null,null,null,null,"Assumption",null,{"$f":"C27","v":"Assumption"}]
[]
[null,null,"Constraint",null,null,null,null,null,{"$f":"C29","v":"Constraint"},null,{"$f":"C29","v":"Constraint"}]
[]
[null,null,"Empty",null,null,null,null,null,null,null,{"$f":"C31","v":"Empty"}]
[]
[null,null,"Error Check",null,null,null,null,null,0,null,{"$f":"C33","v":"Error Check"}]
[]
[null,null,"Hyperlink",null,null,null,null,null,"Hyperlink",null,{"$f":"C35","v":"Hyperlink"}]
[]
[null,null,"Internal Reference",null,null,null,null,null,{"$f":"'Error Checks'!E12","v":"Purchases OK"},null,{"$f":"C37","v":"Internal Reference"}]
[]
[null,null,"Line Calculation",null,null,null,null,null,77,null,"Line Calc"]
[]
[null,null,"Line Total",null,null,null,null,null,{"$f":"I39","v":77},null,{"$f":"C41","v":"Line Total"}]
[]
[null,null,"Parameter",null,null,null,null,null,365,null,{"$f":"C43","v":"Parameter"}]
[]
[null,null,"Range Name Description",null,null,null,null,null,"Not_Named",null,{"$f":"C45","v":"Range Name Description"}]
[]
[null,null,"Row Reference",null,null,null,null,null,{"$f":"ROW(C47)","v":47},null,"Row Ref"]
[]
[null,null,"Row Summary",null,null,null,null,null,{"$f":"I41","v":77},null,{"$f":"C49","v":"Row Summary"}]
[]
[null,null,"Units",null,null,null,null,null,"A$",null,{"$f":"C51","v":"Units"}]
[]
[null,null,"WIP",null,null,null,null,null,null,null,{"$f":"C53","v":"WIP"}]
[]
[]
[null,{"$f":"MAX($B$5:$B55)+1","v":3},"Numerical Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Comma",null,null,null,null,null,123456.789,null,{"$f":"C60","v":"Comma"}]
[]
[null,null,"Comma [0]",null,null,null,null,null,-123456.789,null,"Comma [0]"]
[]
[null,null,"Currency",null,null,null,null,null,123456.789,null,"Currency"]
[]
[null,null,"Currency [0]",null,null,null,null,null,123456.789,null,"Currency [0]"]
[]
[null,null,"Date",null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-23"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-23"},null,{"$f":"C70","v":"Date Heading"}]
[]
[null,null,"Numbers 0",null,null,null,null,null,-123456.789,null,{"$f":"C72","v":"Numbers 0"}]
[]
[null,null,"Percent",null,null,null,null,null,0.5,null,{"$f":"C74","v":"Percent"}]

{"sheet":"Model Parameters","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4],[10,6,10,13],[11,6,11,13]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Model Parameters"}]
[{"$f":"Model_Name","v":"Example Generic Inventory Model.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"General"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[null,null,null,null,"Model Name",null,{"$f":"IF(ISERROR(OR(FIND(\"[\",CELL(\"filename\",A1)),FIND(\"]\",CELL(\"filename\",A1)))),\"\",MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1))","v":"Example Generic Inventory Model.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct Training"]
[]
[]
[null,{"$f":"MAX($B$5:$B14)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365]
[null,null,null,null,"Months in Month",null,1]
[null,null,null,null,"Months in Quarter",null,3]
[null,null,null,null,"Months in Half Yr",null,6]
[null,null,null,null,"Months in Year",null,12]
[null,null,null,null,"Quarters in Year",null,4]
[]
[null,null,null,null,"Rounding Accuracy",null,5]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98]
[null,null,null,null,"Very Small Number",null,1E-8]
[]
[null,null,null,null,"Thousand",null,1000]

{"sheet":"Timing","index":4,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Timing"}]
[{"$f":"Model_Name","v":"Example Generic Inventory Model.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J$7","v":"2017-06-30"},{"$f":"K$7","v":"2018-06-30"},{"$f":"L$7","v":"2019-06-30"},{"$f":"M$7","v":"2020-06-30"},{"$f":"N$7","v":"2021-06-30"}]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2016-07-01"},{"$f":"IF(K$9=1,Model_Start_Date,J$7+1)","v":"2017-07-01"},{"$f":"IF(L$9=1,Model_Start_Date,K$7+1)","v":"2018-07-01"},{"$f":"IF(M$9=1,Model_Start_Date,L$7+1)","v":"2019-07-01"},{"$f":"IF(N$9=1,Model_Start_Date,M$7+1)","v":"2020-07-01"}]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"EOMONTH(J$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(J$6),Periodicity))","v":"2017-06-30"},{"$f":"EOMONTH(K$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(K$6),Periodicity))","v":"2018-06-30"},{"$f":"EOMONTH(L$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(L$6),Periodicity))","v":"2019-06-30"},{"$f":"EOMONTH(M$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(M$6),Periodicity))","v":"2020-06-30"},{"$f":"EOMONTH(N$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(N$6),Periodicity))","v":"2021-06-30"}]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":365},{"$f":"K7-K6+1","v":365},365,366,365]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"N(I$9)+1","v":1},{"$f":"N(J$9)+1","v":2},3,4,5]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Timing Assumptions"]
[]
[null,null,"Data (do not change once modelling has commenced)"]
[]
[null,null,null,"Model Start Date",null,null,null,"2016-07-01"]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,12]
[]
[null,null,null,"Example Reporting Month",null,null,null,6,{"$f":"\"e.g. \"&TEXT(DATE(YEAR(Model_Start_Date)+IF(Example_Reporting_Month<MONTH(Model_Start_Date),1,0),Example_Reporting_Month+1,1)-1,\"dd-Mmm-yy\")","v":"e.g. 30-Jun-17"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":6}]
[]
[null,null,null,"Months per Year",null,null,null,12]

{"sheet":"Inventory Example","index":5,"n_rows":197,"n_cols":15,"rows_kept":197,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Inventory Example"}]
[{"$f":"Model_Name","v":"Example Generic Inventory Model.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2017-06-30"},{"$f":"Timing!K5","v":"2018-06-30"},{"$f":"Timing!L5","v":"2019-06-30"},{"$f":"Timing!M5","v":"2020-06-30"},{"$f":"Timing!N5","v":"2021-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2016-07-01"},{"$f":"Timing!K6","v":"2017-07-01"},{"$f":"Timing!L6","v":"2018-07-01"},{"$f":"Timing!M6","v":"2019-07-01"},{"$f":"Timing!N6","v":"2020-07-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2017-06-30"},{"$f":"Timing!K7","v":"2018-06-30"},{"$f":"Timing!L7","v":"2019-06-30"},{"$f":"Timing!M7","v":"2020-06-30"},{"$f":"Timing!N7","v":"2021-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":365},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":366},{"$f":"Timing!N8","v":365}]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,null,{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":4},{"$f":"Timing!N9","v":5}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Notes"]
[]
[null,null,"Please read"]
[]
[null,null,null,"This example assumes inventory is stored with heteropricing, i.e. inventory prices vary over time."]
[null,null,null,"Inventory is valued on an average cost."]
[]
[]
[null,{"$f":"MAX($B$10:$B18)+1","v":2},"Assumptions"]
[]
[null,null,"Revenue"]
[]
[null,null,null,{"$f":"C19","v":"Assumptions"}]
[]
[null,null,null,null,"Sales"]
[null,null,null,null,"Projected Sales","#",null,null,null,100,200,300,400,500]
[null,null,null,null,"Unit Price","$",null,null,null,15]
[null,null,null,null,"Inflation","Index",null,null,null,null,0.03,0.04,0.05,0.06]
[]
[null,null,null,null,"Inventory"]
[null,null,null,null,"Purchases","kg",null,null,null,400,775,325,550,1000]
[null,null,null,null,"Price","$/kg",null,null,null,3.99,4.75,2.8,4.16,5]
[null,null,null,null,"Amount Used Per Sale","kg",null,null,null,2,2,2,2,2]
[null,null,null,null,"Wastage","%",null,null,null,0.03,0.02,0.02,0.01,0.01]
[]
[null,null,null,null,"Working Capital Assumptions"]
[null,null,null,null,"Days Receivable","# days",null,null,null,60,60,60,60,60]
[null,null,null,null,"Days Payable","# days",null,null,null,30,30,30,30,30]
[]
[]
[null,{"$f":"MAX($B$10:$B40)+1","v":3},{"$f":"E25","v":"Sales"}]
[]
[null,null,"Revenue"]
[]
[null,null,null,"Referred Values"]
[]
[null,null,null,null,{"$f":"E26","v":"Projected Sales"},"#",null,{"$f":"\"Row \"&ROW(A26)","v":"Row 26"},null,{"$f":"J26","v":100},200,300,400,500]
[null,null,null,null,{"$f":"E27","v":"Unit Price"},"$",null,{"$f":"\"Row \"&ROW(A27)","v":"Row 27"},null,{"$f":"J27","v":15}]
[null,null,null,null,"Inflation","Index",null,"Row 28",null,null,{"$f":"K28","v":0.03},{"$f":"L28","v":0.04},0.05,0.06]
[]
[null,null,null,null,{"$f":"E37","v":"Days Receivable"},"# days",null,{"$f":"\"Row \"&ROW(A37)","v":"Row 37"},null,{"$f":"J37","v":60},{"$f":"K37","v":60},60,60,60]
[]
[]
[null,null,null,"Calculations"]
[]
[null,null,null,null,"Price Per Unit","$",null,null,null,{"$f":"IF(J$9=1,$J$48,I56*(1+J49))","v":15},{"$f":"IF(K$9=1,$J$48,J56*(1+K49))","v":15.450000000000001},16.068000000000001,16.871400000000001,17.883684000000002]
[null,null,null,null,{"$f":"E47","v":"Projected Sales"},"#",null,null,null,{"$f":"J47","v":100},{"$f":"K47","v":200},300,400,500]
[null,null,null,null,{"$f":"C43","v":"Revenue"},"$",null,null,null,{"$f":"J56*J57","v":1500},{"$f":"K56*K57","v":3090},{"$f":"L56*L57","v":4820.4000000000005},{"$f":"M56*M57","v":6748.56},{"$f":"N56*N57","v":8941.8420000000006}]
[]
[]
[null,null,null,null,{"$f":"E51","v":"Days Receivable"},"# days",null,null,null,{"$f":"J$51","v":60},{"$f":"K$51","v":60},60,60,60]
[null,null,null,null,"Days in Period","# days",null,null,null,{"$f":"J$8","v":365},{"$f":"K$8","v":365},365,366,365]
[null,null,null,null,"Closing Receivables","$",null,null,null,{"$f":"J58*J61/J62","v":246.57534246575344},{"$f":"K58*K61/K62","v":507.94520547945206},{"$f":"L58*L61/L62","v":792.39452054794538},{"$f":"M58*M61/M62","v":1106.3213114754099},{"$f":"N58*N61/N62","v":1469.8918356164384}]
[]
[]
[null,null,null,"Control Account"]
[]
[null,null,null,null,"Opening Receivables","$",null,null,null,{"$f":"I71","v":0},{"$f":"J71","v":246.57534246575344},507.94520547945206,792.39452054794538,1106.3213114754099,"BS"]
[null,null,null,null,{"$f":"E58","v":"Revenue"},"$",null,null,null,{"$f":"J58","v":1500},{"$f":"K58","v":3090},{"$f":"L58","v":4820.4000000000005},{"$f":"M58","v":6748.56},{"$f":"N58","v":8941.8420000000006},"IS"]
[null,null,null,null,"Cash Receipts","$",null,null,null,{"$f":"J71-SUM(J68:J69)","v":-1253.4246575342465},{"$f":"K71-SUM(K68:K69)","v":-2828.6301369863013},-4535.9506849315076,-6434.6332090725364,-8578.2714758589736,"CFS"]
[null,null,null,null,{"$f":"E63","v":"Closing Receivables"},"$",null,null,null,{"$f":"J63","v":246.57534246575344},{"$f":"K63","v":507.94520547945206},792.39452054794538,1106.3213114754099,1469.8918356164384,"BS"]
[]
[]
[null,{"$f":"MAX($B$10:$B73)+1","v":4},"Inventory"]
[]
[null,null,"Purchases"]
[]
[null,null,null,"Referred Values"]
[]
[null,null,null,null,{"$f":"E31","v":"Purchases"},"kg",null,{"$f":"\"Row \"&ROW(A31)","v":"Row 31"},null,{"$f":"J31","v":400},{"$f":"K31","v":775},325,550,1000]
[null,null,null,null,{"$f":"E32","v":"Price"},"$/kg",null,{"$f":"\"Row \"&ROW(A32)","v":"Row 32"},null,{"$f":"J32","v":3.99},{"$f":"K32","v":4.75},2.8,4.16,5]
[]
[]
[null,null,null,"Calculations"]
[]
[null,null,null,null,{"$f":"E80","v":"Purchases"},"kg",null,null,null,{"$f":"J80","v":400},{"$f":"K80","v":775},325,550,1000]
[null,null,null,null,{"$f":"E81","v":"Price"},"$/kg",null,null,null,{"$f":"J81","v":3.99},{"$f":"K81","v":4.75},2.8,4.16,5]
[null,null,null,null,{"$f":"E86","v":"Purchases"},"$",null,null,null,{"$f":"J86*J87","v":1596},{"$f":"K86*K87","v":3681.25},909.99999999999989,2288,5000]
[]
[]
[null,null,null,null,{"$f":"E38","v":"Days Payable"},"# days",null,null,null,{"$f":"J$38","v":30},{"$f":"K$38","v":30},30,30,30]
[null,null,null,null,"Days in Period","# days",null,null,null,{"$f":"J$8","v":365},{"$f":"K$8","v":365},365,366,365]
[null,null,null,null,"Closing Payables","$",null,null,null,{"$f":"J88*J91/J92","v":131.17808219178082},{"$f":"K88*K91/K92","v":302.56849315068496},74.794520547945197,187.54098360655738,410.95890410958901]
[]
[]
[null,null,null,"Control Account"]
[]
[null,null,null,null,"Opening Payables","$",null,null,null,{"$f":"I101","v":0},{"$f":"J101","v":131.17808219178082},302.56849315068496,74.794520547945197,187.54098360655738,"BS"]
[null,null,null,null,{"$f":"E88","v":"Purchases"},"$",null,{"$f":"\"Opposite of row \"&ROW(A149)","v":"Opposite of row 149"},null,{"$f":"J88","v":1596},{"$f":"K88","v":3681.25},{"$f":"L88","v":909.99999999999989},{"$f":"M88","v":2288},{"$f":"N88","v":5000},"Excluded"]
[null,null,null,null,"Cash Payments","$",null,null,null,{"$f":"J101-SUM(J98:J99)","v":-1464.8219178082193},{"$f":"K101-SUM(K98:K99)","v":-3509.8595890410961},{"$f":"L101-SUM(L98:L99)","v":-1137.7739726027396},{"$f":"M101-SUM(M98:M99)","v":-2175.2535369413877},{"$f":"N101-SUM(N98:N99)","v":-4776.5820794969686},"CFS"]
[null,null,null,null,{"$f":"E93","v":"Closing Payables"},"$",null,null,null,{"$f":"J93","v":131.17808219178082},{"$f":"K93","v":302.56849315068496},74.794520547945197,187.54098360655738,410.95890410958901,"BS"]
[]
[]
[null,null,"Inventory at Hand (kg)"]
[]
[null,null,null,"Referred Values"]
[]
[null,null,null,null,{"$f":"E31","v":"Purchases"},"kg",null,{"$f":"\"Row \"&ROW(A31)","v":"Row 31"},null,{"$f":"J31","v":400},775,325,550,1000]
[null,null,null,null,{"$f":"E88","v":"Purchases"},"$",null,{"$f":"\"Row \"&ROW(A88)","v":"Row 88"},null,{"$f":"J88","v":1596},{"$f":"K88","v":3681.25},909.99999999999989,2288,5000]
[null,null,null,null,{"$f":"E33","v":"Amount Used Per Sale"},"kg",null,{"$f":"\"Row \"&ROW(A33)","v":"Row 33"},null,{"$f":"J33","v":2},2,2,2,2]
[null,null,null,null,{"$f":"E34","v":"Wastage"},"%",null,{"$f":"\"Row \"&ROW(A34)","v":"Row 34"},null,0.03,0.02,0.02,0.01,0.01]
[]
[null,null,null,null,{"$f":"E26","v":"Projected Sales"},"#",null,{"$f":"\"Row \"&ROW(A26)","v":"Row 26"},null,{"$f":"J26","v":100},{"$f":"K26","v":200},{"$f":"L26","v":300},{"$f":"M26","v":400},{"$f":"N26","v":500}]
[]
[]
[null,null,null,"Calculations"]
[]
[null,null,null,null,{"$f":"E110","v":"Amount Used Per Sale"},"kg",null,null,null,{"$f":"J110","v":2},{"$f":"K110","v":2},2,2,2]
[null,null,null,null,{"$f":"E113","v":"Projected Sales"},"#",null,{"$f":"\"Row \"&ROW(A113)","v":"Row 113"},null,{"$f":"J113","v":100},{"$f":"K113","v":200},300,400,500]
[null,null,null,null,"COGS","kg",null,null,null,{"$f":"J118*J119","v":200},{"$f":"K118*K119","v":400},600,800,1000]
[]
[null,null,null,null,"Inventory Balance Pre-Wastage","kg",null,null,null,{"$f":"SUM(J139:J141)","v":200},{"$f":"SUM(K139:K141)","v":569},282.62,26.967599999999948,26.697924000000057]
[null,null,null,null,{"$f":"E111","v":"Wastage"},"%",null,{"$f":"\"Row \"&ROW(A111)","v":"Row 111"},null,{"$f":"J111","v":0.03},{"$f":"K111","v":0.02},0.02,0.01,0.01]
[null,null,null,null,{"$f":"E123","v":"Wastage"},"kg",null,null,null,{"$f":"J122*J123","v":6},{"$f":"K122*K123","v":11.38},{"$f":"L122*L123","v":5.6524000000000001},{"$f":"M122*M123","v":0.26967599999999947},{"$f":"N122*N123","v":0.26697924000000056}]
[]
[null,null,null,null,"Inventory Balance Pre-COGS Transfer","kg",null,null,null,{"$f":"SUM(J139:J140)","v":400},{"$f":"SUM(K139:K140)","v":969},882.62,826.96759999999995,1026.6979240000001]
[null,null,null,null,"Inventory Balance Pre-COGS Transfer","$",null,null,null,{"$f":"SUM(J148:J149)","v":1596},{"$f":"SUM(K148:K149)","v":4455.3099999999995},3473.8492901960781,3378.0995906135272,5109.0589838521255]
[null,null,null,null,{"$f":"E120","v":"COGS"},"kg",null,{"$f":"\"Row \"&ROW(A120)","v":"Row 120"},null,{"$f":"J120","v":200},{"$f":"K120","v":400},600,800,1000]
[null,null,null,null,{"$f":"E120","v":"COGS"},"$",null,null,null,{"$f":"IF(J126,J127*J128/J126,)","v":798},{"$f":"IF(K126,K127*K128/K126,)","v":1839.1372549019604},2361.5027691618666,3267.9390008639057,4976.2046502902303]
[]
[null,null,null,null,"Inventory Balance Pre-Wastage","kg",null,null,null,{"$f":"J126-J128","v":200},{"$f":"K126-K128","v":569},282.62,26.967599999999948,26.697924000000057]
[null,null,null,null,"Inventory Balance Pre-COGS Transfer","$",null,null,null,{"$f":"J127-J129","v":798},{"$f":"K127-K129","v":2616.1727450980388},1112.3465210342115,110.16058974962152,132.85433356189515]
[null,null,null,null,{"$f":"E123","v":"Wastage"},"kg",null,{"$f":"\"Row \"&ROW(A46)","v":"Row 46"},null,{"$f":"J124","v":6},{"$f":"K124","v":11.38},5.6524000000000001,0.26967599999999947,0.26697924000000056]
[null,null,null,null,{"$f":"E123","v":"Wastage"},"$",null,null,null,{"$f":"IF(J131,J132*J133/J131,)","v":23.94},{"$f":"IF(K131,K132*K133/K131,)","v":52.32345490196078},{"$f":"IF(L131,L132*L133/L131,)","v":22.24693042068423},{"$f":"IF(M131,M132*M133/M131,)","v":1.1016058974962153},{"$f":"IF(N131,N132*N133/N131,)","v":1.3285433356189513}]
[]
[]
[null,null,null,{"$f":"C104","v":"Inventory at Hand (kg)"}]
[]
[null,null,null,null,"Opening Inventory","kg",null,null,null,{"$f":"I143","v":0},{"$f":"J143","v":194},557.62,276.9676,26.697923999999947]
[null,null,null,null,"Purchases","kg",null,null,null,{"$f":"J108","v":400},{"$f":"K108","v":775},{"$f":"L108","v":325},{"$f":"M108","v":550},{"$f":"N108","v":1000}]
[null,null,null,null,{"$f":"E120","v":"COGS"},"kg",null,null,null,{"$f":"-J120","v":-200},{"$f":"-K120","v":-400},{"$f":"-L120","v":-600},{"$f":"-M120","v":-800},{"$f":"-N120","v":-1000}]
[null,null,null,null,"Wastage","kg",null,null,null,{"$f":"-J124","v":-6},{"$f":"-K124","v":-11.38},{"$f":"-L124","v":-5.6524000000000001},{"$f":"-M124","v":-0.26967599999999947},{"$f":"-N124","v":-0.26697924000000056}]
[null,null,null,null,"Closing Inventory","kg",null,null,null,{"$f":"SUM(J139:J142)","v":194},{"$f":"SUM(K139:K142)","v":557.62},276.9676,26.697923999999947,26.430944760000056]
[]
[]
[null,null,null,"Inventory ($)"]
[]
[null,null,null,null,{"$f":"E139","v":"Opening Inventory"},"$",null,null,null,{"$f":"I152","v":0},{"$f":"J152","v":774.06},2563.8492901960781,1090.0995906135272,109.05898385212531,"BS"]
[null,null,null,null,{"$f":"E140","v":"Purchases"},"$",null,{"$f":"\"Opposite of row \"&ROW(A99)","v":"Opposite of row 99"},null,{"$f":"J109","v":1596},{"$f":"K109","v":3681.25},909.99999999999989,2288,5000,"Excluded"]
[null,null,null,null,"COGS","$",null,null,null,{"$f":"-J129","v":-798},{"$f":"-K129","v":-1839.1372549019604},{"$f":"-L129","v":-2361.5027691618666},{"$f":"-M129","v":-3267.9390008639057},{"$f":"-N129","v":-4976.2046502902303},"IS"]
[null,null,null,null,"Wastage","$",null,null,null,{"$f":"-J134","v":-23.94},{"$f":"-K134","v":-52.32345490196078},{"$f":"-L134","v":-22.24693042068423},{"$f":"-M134","v":-1.1016058974962153},{"$f":"-N134","v":-1.3285433356189513},"IS"]
[null,null,null,null,"Closing Inventory","$",null,null,null,{"$f":"SUM(J148:J151)","v":774.06},{"$f":"SUM(K148:K151)","v":2563.8492901960781},{"$f":"SUM(L148:L151)","v":1090.0995906135272},{"$f":"SUM(M148:M151)","v":109.05898385212531},{"$f":"SUM(N148:N151)","v":131.5257902262762},"BS"]
[]
[]
[null,null,null,null,"Purchases OK","[1,0]",null,null,{"$f":"MIN(SUM(J155:N155),1)","v":0},{"$f":"IFERROR((ROUND(J99-J149,Rounding_Accuracy)<>0)*1,1)","v":0},{"$f":"IFERROR((ROUND(K99-K149,Rounding_Accuracy)<>0)*1,1)","v":0},{"$f":"IFERROR((ROUND(L99-L149,Rounding_Accuracy)<>0)*1,1)","v":0},{"$f":"IFERROR((ROUND(M99-M149,Rounding_Accuracy)<>0)*1,1)","v":0},{"$f":"IFERROR((ROUND(N99-N149,Rounding_Accuracy)<>0)*1,1)","v":0}]
[]
[]
[null,{"$f":"MAX($B$10:$B157)+1","v":5},"Extracts from Financial Statements"]
[]
[null,null,"Income Statement"]
[]
[null,null,null,null,{"$f":"E69","v":"Revenue"},"$",null,null,null,{"$f":"J69","v":1500},{"$f":"K69","v":3090},4820.4000000000005,6748.56,8941.8420000000006]
[null,null,null,null,{"$f":"E150","v":"COGS"},"$",null,null,null,{"$f":"J150","v":-798},{"$f":"K150","v":-1839.1372549019604},-2361.5027691618666,-3267.9390008639057,-4976.2046502902303]
[null,null,null,null,"Gross Profit","$",null,null,null,{"$f":"SUM(J162:J163)","v":702},{"$f":"SUM(K162:K163)","v":1250.8627450980396},2458.897230838134,3480.6209991360947,3965.6373497097702]
[null,null,null,null,"Wastage","$",null,null,null,{"$f":"J151","v":-23.94},{"$f":"K151","v":-52.32345490196078},-22.24693042068423,-1.1016058974962153,-1.3285433356189513]
[null,null,null,null,"Profit c/f","$",null,null,null,{"$f":"SUM(J164:J165)","v":678.06},{"$f":"SUM(K164:K165)","v":1198.5392901960788},{"$f":"SUM(L164:L165)","v":2436.6503004174497},{"$f":"SUM(M164:M165)","v":3479.5193932385987},{"$f":"SUM(N164:N165)","v":3964.3088063741511}]
[]
[]
[null,null,"Balance Sheet"]
[]
[null,null,null,null,"Cash","$",null,null,null,{"$f":"MAX(SUM($J197:J197),)","v":0},{"$f":"MAX(SUM($J197:K197),)","v":0},{"$f":"MAX(SUM($J197:L197),)","v":2505.5500000000006},{"$f":"MAX(SUM($J197:M197),)","v":6764.9296721311493},{"$f":"MAX(SUM($J197:N197),)","v":10566.619068493153}]
[null,null,null,null,"Inventory","$",null,null,null,{"$f":"J152","v":774.06},{"$f":"K152","v":2563.8492901960781},1090.0995906135272,109.05898385212531,131.5257902262762]
[null,null,null,null,{"$f":"E71","v":"Closing Receivables"},"$",null,null,null,{"$f":"J71","v":246.57534246575344},{"$f":"K71","v":507.94520547945206},792.39452054794538,1106.3213114754099,1469.8918356164384]
[null,null,null,null,"Current Assets","$",null,null,null,{"$f":"SUM(J171:J173)","v":1020.6353424657534},{"$f":"SUM(K171:K173)","v":3071.79449567553},4388.0441111614728,7980.3099674586847,12168.036694335868]
[]
[null,null,null,null,"Bank Overdraft","$",null,null,null,{"$f":"-MIN(SUM($J197:J197),)","v":211.39726027397273},{"$f":"-MIN(SUM($J197:K197),)","v":892.62671232876755},{"$f":"-MIN(SUM($J197:L197),)","v":0},{"$f":"-MIN(SUM($J197:M197),)","v":0},{"$f":"-MIN(SUM($J197:N197),)","v":0}]
[null,null,null,null,{"$f":"E101","v":"Closing Payables"},"$",null,null,null,{"$f":"J101","v":131.17808219178082},{"$f":"K101","v":302.56849315068496},{"$f":"L101","v":74.794520547945197},{"$f":"M101","v":187.54098360655738},{"$f":"N101","v":410.95890410958901}]
[null,null,null,null,"Current Liabilities","$",null,null,null,{"$f":"SUM(J176:J177)","v":342.57534246575358},{"$f":"SUM(K176:K177)","v":1195.1952054794524},74.794520547945197,187.54098360655738,410.95890410958901]
[]
[null,null,null,null,"Net Assets","$",null,null,null,{"$f":"J174-J178","v":678.05999999999983},{"$f":"K174-K178","v":1876.5992901960776},4313.2495906135273,7792.7689838521273,11757.077790226278]
[]
[]
[null,null,null,null,"Total Equity","$",null,null,null,{"$f":"SUM($J166:J166)","v":678.06},{"$f":"SUM($J166:K166)","v":1876.5992901960788},{"$f":"SUM($J166:L166)","v":4313.2495906135282},{"$f":"SUM($J166:M166)","v":7792.7689838521273},{"$f":"SUM($J166:N166)","v":11757.077790226278}]
[]
[]
[null,null,null,"Checks"]
[null,null,null,null,"Prima Facie Error","[1,0]",null,null,{"$f":"MIN(SUM(J187:N187),1)","v":0},{"$f":"IF(ISERROR(J180-J183),1,)","v":0},{"$f":"IF(ISERROR(K180-K183),1,)","v":0},0,0,0]
[null,null,null,null,"Balance Check","[1,0]",null,null,{"$f":"MIN(SUM(J188:N188),1)","v":0},{"$f":"IF(J187<>0,,(ROUND(J180-J183,Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(K187<>0,,(ROUND(K180-K183,Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(L187<>0,,(ROUND(L180-L183,Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(M187<>0,,(ROUND(M180-M183,Rounding_Accuracy)<>0)*1)","v":0},{"$f":"IF(N187<>0,,(ROUND(N180-N183,Rounding_Accuracy)<>0)*1)","v":0}]
[null,null,null,null,"Insolvency Check","[1,0]",null,null,0,{"$f":"IF(AND(J187=0,J188=0),(J180<0)*1,)","v":0},{"$f":"IF(AND(K187=0,K188=0),(K180<0)*1,)","v":0},0,0,0]
[null,null,null,null,"Overall","[1,0]",null,null,{"$f":"MIN(SUM(I187:I189),1)","v":0}]
[]
[]
[null,null,"Cash Flow Statement"]
[]
[null,null,null,null,{"$f":"E70","v":"Cash Receipts"},"$",null,null,null,{"$f":"-J70","v":1253.4246575342465},{"$f":"-K70","v":2828.6301369863013},4535.9506849315076,6434.6332090725364,8578.2714758589736]
[null,null,null,null,{"$f":"E100","v":"Cash Payments"},"$",null,null,null,{"$f":"J100","v":-1464.8219178082193},{"$f":"K100","v":-3509.8595890410961},-1137.7739726027396,-2175.2535369413877,-4776.5820794969686]
[null,null,null,null,"Cash Movement","$",null,null,null,{"$f":"SUM(J195:J196)","v":-211.39726027397273},{"$f":"SUM(K195:K196)","v":-681.22945205479482},3398.1767123287682,4259.3796721311483,3801.689396362005]

{"sheet":"Error Checks","index":6,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Error Checks"}]
[{"$f":"Model_Name","v":"Example Generic Inventory Model.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Error Checks"]
[]
[null,null,"Summary of Errors"]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"Purchases OK",null,null,null,{"$f":"HL_Purchases","v":0}]
[null,null,null,null,"Balance Sheet OK",null,null,null,{"$f":"HL_Balance","v":0}]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]

{"sheet":"Change Log","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Change Log"}]
[{"$f":"Model_Name","v":"Example Generic Inventory Model.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Change Log"}]
[]
[null,null,"Summary"]
[]
[null,null,null,null,null,"Date","Model Version ","Details of change","Worksheet Reference","Row, column, cell reference","Author"]