{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Vendor Instructions","Promotional Funding Form","Drop Down Lists","Supporting Documentation"],"not_rendered":{"charts":0,"images":9,"macros":0,"external_links":1,"defined_names":9,"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":"Vendor Instructions","index":0,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Promotional Funding Form'!V1","v":"ver.2025.04.04"}]

{"sheet":"Promotional Funding Form","index":1,"n_rows":57,"n_cols":26,"rows_kept":57,"cut":false,"hidden":false,"merged":[[36,22,36,24],[37,22,37,24],[38,22,38,24],[39,22,39,24],[40,22,40,24],[41,22,41,24],[42,22,42,24],[43,22,43,24],[44,22,44,24],[52,10,52,11],[52,20,52,21],[47,2,47,4],[47,6,47,8],[47,10,47,12],[48,14,48,16],[47,14,47,16],[47,18,47,20],[48,2,48,4],[48,6,48,8],[48,10,48,12],[4,20,4,25],[4,18,4,19],[5,20,5,25],[0,18,0,20],[0,21,0,25],[3,1,3,2],[3,3,3,6],[4,1,4,2],[51,14,51,15],[49,1,49,25],[38,2,38,4],[38,6,38,8],[38,10,38,12],[51,17,51,19],[38,14,38,16],[38,18,38,20],[39,2,39,4],[39,6,39,8],[39,10,39,12],[39,14,39,16],[32,22,32,24],[33,22,33,24],[34,22,34,24],[35,22,35,24],[46,10,46,12],[46,18,46,20],[44,2,44,4],[44,6,44,8],[44,10,44,12],[46,14,46,16],[36,18,36,20],[41,18,41,20],[0,1,0,17],[1,18,1,19],[1,20,1,25],[5,3,5,6],[3,9,3,11],[2,9,2,11],[2,13,2,14],[3,15,3,16],[2,15,2,16],[3,13,3,14],[2,18,2,19],[2,20,2,25],[3,18,3,19],[3,20,3,25],[2,1,2,2],[2,3,2,6],[4,3,4,6],[42,10,42,12],[43,2,43,4],[43,6,43,8],[43,10,43,12],[36,2,36,4],[36,6,36,8],[30,5,30,14],[33,14,33,16],[8,15,8,16],[5,1,5,2],[5,10,5,11],[5,12,5,15],[33,2,33,4],[33,6,33,8],[35,2,35,4],[36,14,36,16],[36,10,36,12],[37,10,37,12],[37,14,37,16],[34,2,34,4],[34,6,34,8],[34,10,34,12],[34,14,34,16],[9,18,9,19],[9,20,9,21],[6,15,6,16],[6,17,6,18],[6,19,6,20],[6,21,6,25],[5,18,5,19],[7,1,7,25],[57,1,57,25],[32,2,32,4],[32,6,32,8],[32,10,32,12],[32,14,32,16],[32,18,32,20],[51,1,52,4],[39,18,39,20],[41,14,41,16],[40,14,40,16],[40,18,40,20],[43,18,43,20],[33,10,33,12],[43,14,43,16],[42,2,42,4],[42,6,42,8],[54,19,54,21],[54,15,54,18],[50,15,50,16],[50,17,50,18],[50,19,50,20],[50,21,50,25],[51,20,51,21],[52,17,52,19],[42,14,42,16],[42,18,42,20],[48,18,48,20],[45,18,45,20],[44,18,44,20],[52,14,52,15],[45,22,45,24],[46,22,46,24],[47,22,47,24],[48,22,48,24],[35,18,35,20],[44,14,44,16],[45,14,45,16],[40,2,40,4],[40,6,40,8],[40,10,40,12],[41,2,41,4],[41,6,41,8],[41,10,41,12],[45,2,45,4],[45,6,45,8],[45,10,45,12],[37,18,37,20],[35,6,35,8],[35,10,35,12],[35,14,35,16],[53,3,53,7],[37,2,37,4],[37,6,37,8],[30,1,30,4],[46,2,46,4],[46,6,46,8],[56,1,56,2],[8,21,8,25],[10,15,10,16],[10,17,10,18],[10,19,10,20],[56,3,56,25],[15,20,15,21],[14,20,14,21],[12,15,12,16],[12,19,12,20],[12,21,12,25],[14,7,14,9],[13,7,13,9],[13,10,13,14],[13,16,13,19],[13,20,13,21],[11,1,11,25],[34,18,34,20],[8,17,8,18],[8,19,8,20],[15,16,15,19],[54,3,54,11],[53,17,53,25],[52,5,52,9],[12,17,12,18],[9,1,9,2],[13,1,14,4],[17,2,17,3],[17,8,17,11],[17,12,17,13],[28,1,28,25],[14,10,14,14],[14,16,14,19],[10,21,10,25],[9,3,9,17],[15,7,15,9],[15,10,15,12],[17,14,17,16],[17,17,17,18],[27,1,27,2],[27,3,27,25],[33,18,33,20]]}
[null,"WEGMANS PROMOTIONAL FUNDING FORM - SINGLE RETAIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Wegmans Office Use only:",null,null,"ver.2025.04.04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUPON # "]
[null,"Dept ",null,"",null,null,null,null,null,"Fiscal Week # Start ",null,null,null,"Start Date ",null,null,null,null,"POS \nBill Back # "]
[null,"Vendor ",null,null,null,null,null,null,null,"# Weeks on Sale ",null,null,null,"End Date ",null,null,null,null,"Merchant "]
[null,"Vendor # ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin "]
[null,"BBR# ",null,null,null,null,null,null,null,null,"Rep Name ",null,null,null,null,null,null,null,"Date "]
[]
[]
[]
[null,"Item Description ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Size"]
[]
[]
[]
[null,"PROMOTION\nSPECIFICS",null,null,null,null,null,"Type of Promotion ",null,null,"",null,null,null,null,null,"Max Cpns/Customer ",null,null,null,9]
[null,null,null,null,null,null,null,"Payment Method ",null,null,"",null,null,null,null,null,"Enforced Qty ",null,null,null,"NO"]
[null,null,null,null,null,null,null,"A/R Vendor Number \n(Only For Promo Fund) ",null,null,null,null,null,null,null,null,"Min Purchase/Customer ",null,null,null,0]
[]
[null,null,"Buy Qty. ",null,null,null,"Sale Price ",null,"Unit Vendor Allowance ",null,null,null,null,null,"Total Allowance ",null,null,{"$f":"IF($M18=\"\",\"\",($E18*$M18))","v":""}]
[]
[null,"Price Zone ","ALL",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,"Retail Price "]
[null,"Sale Price ",{"$f":"IF($E$18=\"\",\"\",IF(H18=\"\",\"\",($H$18/$E$18)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A","N/A","N/A"]
[null,"Cost "]
[null,"GP % ",{"$f":"IF(C$23=\"\",\"\",((C$21-C$23)/C$21))","v":""},"","","","","","","","","","","","","","","","","","","","","","",""]
[null,"New Cost ",{"$f":"IF(C$23=\"\",\"\",(C$23-$M$18-$K$53))","v":""},"","","","","","","","","","","","","","","","","","","","","","",""]
[null,"New GP %",{"$f":"IF(C$25=\"\",\"\",((C$22-C$25)/C$22))","v":""},{"$f":"IF(D$25=\"\",\"\",((D$22-D$25)/D$22))","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Comments "]
[]
[]
[null,"WEGMANS ITEM #",null,null,null,"** Include all individual item codes (regardless of retail families)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Display",null,null,null,"Quantity"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"POS BILL BACK\nINFORMATION",null,null,null,null,"Bill Back Type:  P - Store Point of Sale Movement",null,null,null,null,null,null,null,"STOR List",null,null,"Buyer Approval "]
[null,null,null,null,null,"UNIT POS Bill Back Allowance ",null,null,null,null,null,null,null,null,null,null,null,"Deduct Weekly "]
[null,null,null,"Receivable Deduction Code",null,null,null,null,null,null,null,null,null,null,null,null,null,"Can only deduct weekly using Code D and F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A/R Vendor Number \n(Only For Promo Fund) "]
[]
[null,"Comments "]

{"sheet":"Drop Down Lists","index":2,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Type of Promotion"]
[]
["Shopper's Club"]
["TPR"]
["CLP"]
["Markdown"]
["Clearance"]
[]
["Payment Method"]
[]
["Deduct from Vendor"]
["Future Fund"]
["No Funding"]
["Promo Fund (Internal Use Only)"]
[]
["Department"]
[]
["Bulk"]
["Dairy"]
["Frozen"]
["Grocery"]
["Health & Wellness"]
["Home & Entertaining"]
[]
["Receivable Deduction Code"]
[]
["D - Deduct off invoice immediately at end of deal"]
["F - Pay from vendors Future Fund account at the end of deal"]
["E - At end of deal, deduct off invoice in 12 days"]
["M - Multiple Monthly Billing  (JFM   AMJ   JAS   OND)"]
["N - Do not deduct, wait for payment"]
[]
["Deduct_Weekly"]
[]
["YES"]
["NO"]

{"sheet":"Supporting Documentation","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}