{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Item Template","U of M Template","Vendor Item Template","Stock Count Template","Item Locations Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":5,"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":"Item Template","index":0,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,1,2],[0,3,1,4],[0,6,1,7],[0,5,1,5]]}
["Red Font is a required field",null,null,null,null," "]
[]
["Name","Number","Description","Vendor","Cost Update Method","Per Inventory Unit Cost","Case Cost","Cost Account Name","Inventory Account Name","Inventory U of M","Default Purchase U of M"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BREAD 9 Grain Loaf",12271658,"BREAD LOAF 9 GRAIN OPEN TOP","Sysco","Manual",{"$f":"G13/6","v":1.2},7.2,"COGS Bread","Bread Inventory","Loaf (14 Slices)","Case - 6/Loaf(14 Slice)"]
["BEEF Ground",12345678,"GRND BEEF CHUCK CS 20#","Sysco","Auto Update Avg Last 3 Invoices",68.48,68.48,"COGS Meat","Meat Inventory","lb","lb"]
["FLOUR All Purpose",68419295,"FLOUR BLEACHED WHT 50LBS","Sysco","Auto Update From Invoice",32.89,32.89,"COGS Dry Goods","Dry Goods Inventory","lb","Bag - 50/lb"]
["VEG Cabbage",56215848,"Cabbage CS/24 HEADS Prpl","Sysco","Auto Update From Invoice",0.79,19.04,"COGS Produce","Produce Inventory","Head","Case - 24/Head"]
["MILK 2%",85642156,"MILK 2% 4/1 GA","US Foods","Auto Update From Invoice",{"$f":"G17/4","v":3.625},14.5,"COGS Dairy","Dairy Inventory","Gallon","Case - 4/Gallon"]
["DRY Shortening",14518403,"Shortening Fry Liq Clr Zt","US Foods","Auto Update From Invoice",{"$f":"G18/3","v":6.8500000000000005},20.55,"COGS Misc","Misc Inventory","Container (5lb)","Case - 3/Container (5lb)"]
["BEEF Ground",85489522,"GROUND BEEF CHUCK 85% 4/5#","Sysco","Auto Update From Invoice",3.55,71,"COGS Meat","Meat Inventory","lb","Case - 20/lb"]
["BEEF Ground",48224856,"GROUND BEEF PREMIUM 85/15","US Foods","Auto Update From Invoice",3.55,124.25,"COGS Meat","Meat Inventory","lb","Case - 30/lb"]
["Name","Number","Description","Vendor","Cost Update Method","Inventory Cost","Case Cost","Cost Account Name","Inventory Account Name","Inventory U of M","Default Purchase U of M"]

{"sheet":"U of M Template","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,2,1,4]]}
["Red Font is a required field"]
[]
["Name","Equivalent U of M","Equivalent Qty"]
[]
[]
[]
[]
[]
[]
["Name","Equivalent U of M","Equivalent Qty"]
["Dozen","Each",12]
["Gallon","OZ-fl",128]
["1/2 Gallon","OZ-fl",64]
["Liter","OZ-fl",33.814]
["Quart","OZ-fl",32]
["mL","OZ-fl",3.3813999999999997E-2]
["Kilo","OZ-wt",35.274000000000001]
["lb","OZ-wt",16]
["#10 Can","OZ-fl",109]
["Gram","OZ-wt",3.5274E-2]
["Pint","OZ-fl",16]
["Cup","OZ-fl",8]
["Tbsp","OZ-fl",0.5]
["tsp","OZ-fl",0.16666700000000001]
["1/2 Keg","Gallon",15.5]
["Bottle","Each",1]

{"sheet":"Vendor Item Template","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,1,2]]}
["Red Font is a required field"]
[]
["Item","Vendor","Purchase U of M","Vendor Item Number","Vendor Item Name","Split U of M","Contract Price","Split Contract Price","Contract Expiration","Acceptable Variance %"]
[]
[]
[]
[]
[]
[]
[]
["BEEF Ground","Sysco","Case = 20/lb",85489522,"GROUND BEEF CHUCK 85% 4/5#","Chub = 5/lb",71,17.75,"2017-06-30",5]
["BEEF Ground","US Foods","Case = 35/lb",48224856,"GROUND BEEF PREMIUM 85/15",null,124.25,null,"2018-02-28",5]
["BREAD 9 Grain Loaf","Sysco","Case = 6/Loaf (14 Slices)",2271658,"BREAD LOAF 9 GRAIN OPEN TOP","Loaf (14 Slices)",7.2,{"$f":"G13/3","v":2.4},"2017-06-30",3]
["Item","Vendor","Purchase U of M","Vendor Item Number","Vendor Item Name","Split U of M","Contract Price","Split Contract Price","Contract Expiration","Acceptable Variance %"]

{"sheet":"Stock Count Template","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,2,1,3]]}
["Red Font is a required field"]
[]
["Name","Frequency","Location","Storage Location","Item"]
[]
[]
[]
[]
[]
[]
[]
["Full Inventory","Weekly",100,"Walk In","MILK 2%"]
["Full Inventory","Weekly",100,"Walk In","EGGS"]
["Full Inventory","Weekly",100,"Walk In","DAIRY Sour Cream"]
["Full Inventory","Weekly",100,"Dry Storage","FLOUR All Purpose"]
["Full Inventory","Weekly",100,"Dry Storage","BEANS Pinto"]
["Full Inventory","Weekly",100,"Dry Storage","FLOUR Gluten Free"]
["Full Inventory","Weekly",100,"Dry Storage","DRY Oats Quick"]
["Name","Frequency","Location","Storage Location","Item"]

{"sheet":"Item Locations Template","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,1,3]]}
["Red Font is a required field"]
[]
["Location","Item","Inventory U of M","Cost","Par Qty"]
[]
[]
[]
[]
[]
[]
[]
["Location 100","BREAD 9 Grain Loaf","Loaf (14 Slices)",1.2]
["Location 200","BREAD 9 Grain Loaf","Loaf (14 Slices)",1.55]
["Location 300","BREAD 9 Grain Loaf","Loaf (14 Slices)",1.39]
["Location","Item","Inventory U of M","Cost","Par Qty"]