{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["STOCK ANALYSIS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"STOCK ANALYSIS","index":0,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12]]}
["MONTHLY KITCHEN STOCK DIFFERENCE (WEEKLY)"]
[]
["OUTLET :          CCS"]
["MONTH :","2013-07-01"]
[]
["STOCK DIFFERENCE "]
[]
["NO","MATERIAL ","UOM","01.07.13-07.07.13","08.07.13-14.07.13","15.07.13-21.07.13","22.07.13-28.07.13","29.07.13-31.07.13","TOTAL "]
[null,null,null,null,null,null,null,null,"STOCK DIFFERENCE"]
[]
[null,"MAIN COURSE MATERIAL"]
[1,"CHICKEN CHOP (MARINATED)","PCS",0.2,-28.1,-15.44,21,-8.26,{"$f":"SUM(D12:H12)","v":-30.6}]
[{"$f":"+A12+1","v":2},"CHICKEN WINGS (MARINATED)","PCS",52,24,52,76,30,{"$f":"SUM(D13:H13)","v":234}]
[{"$f":"+A13+1","v":3},"CHICKEN WINGS (NON-MARINATED)","PCS",-52,277,-351,-79,-30,{"$f":"SUM(D14:H14)","v":-235}]
[4,"FISH & CHIP ","PCS",63,-10,-1,-3,1,{"$f":"SUM(D15:H15)","v":50}]
[]
["USAGE DIFFERENCE "]
[]
[]
["NO","MATERIAL ","UOM","01.07.13-07.07.13",null,"08.07.13-14.07.13",null,"15.07.13-21.07.13",null,"22.07.13-28.07.13",null,{"$f":"+H8","v":"29.07.13-31.07.13"}]
[]
[null,null,null,"USAGE-POS","BASED ON KTICHEN WEEKLY RECORD","USAGE-POS","BASED ON KTICHEN WEEKLY RECORD","USAGE-POS","BASED ON KTICHEN WEEKLY RECORD","USAGE-POS","BASED ON KTICHEN WEEKLY RECORD","USAGE-POS","BASED ON KTICHEN WEEKLY RECORD"]
[]
[null,"MAIN COURSE MATERIAL"]
[1,"CHICKEN CHOP (MARINATED)","PCS",403.2,403,350.9,379,396.56,412,466,445,97.74,106]
[{"$f":"+A25+1","v":2},"CHICKEN WINGS (MARINATED)","PCS",177,72,108,84,153,101,183,107,72,42]
[null,"CHICKEN WINGS (NON-MARINATED)","PCS",0,52,0,-277,0,351,0,79,0,30]
[{"$f":"+A26+1","v":3},"FISH & CHIP ","PCS",64,1,60,70,71,72,61,64,20,19]
[]
[]
["USAGE DIFFERENCE BETWEEN USAGE (POS) AND BASED ON  KITCHEN WEEKLY RECORD"]
[]
[null,"MAIN COURSE MATERIAL",null,null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE",null,"DIFFERENCE"]
[1,"CHICKEN CHOP (MARINATED)",null,null,{"$f":"+E25-D25","v":-0.19999999999998863},null,{"$f":"+G25-F25","v":28.100000000000023},null,{"$f":"+I25-H25","v":15.439999999999998},null,{"$f":"+K25-J25","v":-21},null,{"$f":"+M25-L25","v":8.2600000000000051}]
[{"$f":"+A34+1","v":2},"CHICKEN WINGS (MARINATED)",null,null,{"$f":"+E26-D26","v":-105},null,{"$f":"+G26-F26","v":-24},null,-52,null,-76,null,-30]
[4,"CHICKEN WINGS (NON-MARINATED)",null,null,52,null,-277,null,351,null,79,null,30]
[{"$f":"+A35+1","v":3},"FISH & CHIP ",null,null,-63,null,10,null,1,null,3,null,-1]
[]
["In Week 2 , Ckn. Wings Non Marinated  , the Physical Stock have 374 pcs  ,  ( Opening Stock 49 + Purchase 48 should be  97 pcs ) "]
["In Week 3 , Ckn. Wings Non Marinated  , there is No Sales , but the closing stock decreased from 431 pcs to  80 pcs. "]