{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Overview","Reporting Period","LCB 2413","LCB 2414","LCB 2415","Remittance Summary","Calculator","Distillery","MRP"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":11,"comments":2,"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":"Overview","index":0,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,6,4,9],[7,1,17,9],[58,1,63,9]]}
["Distillery Reporting Template Overview /Instructions"]
[]
["Expose Cells"]
[null,"Enter \"y\" to highlight cells that require information to be entered in all forms. For printing purposes, the \"y\" must be cleared since figures in highlighted cells may not be legible when the forms are printed. Press the \"Tab\" key to move between input cells on each form.",null,null,null,null,"\nPlease note that the email feature will only work if you have a locally installed email client such as Outlook."]
[]
["Monthly Distillery Reporting Forms"]
[]
[null,"All three report categories evident within each tab of this form, LCB 2413, LCB 2414, and LCB 2415, are required to be completed in full where applicable and the entire file is to be submitted to distilleryreporting@lcbo.com, in Excel format, no later than 20 days following the applicable month/quarter being reported upon. All submissions received by this mailbox are automatically forwarded, internally, to accounts.receivable@lcbo.com for invoicing, accounting, and receipt of payment purposes. Nil/Zero report categories, where the category may not be applicable to your organization, and nil/zero reports, in months/quarters where there may not be any sales transaction activity, are also required to be submitted. A copy of the submitted report must be retained by the Distillery for audit purposes.\n\nWithin this authorized program and sales relationship, the Distillery is acting as an agent of the LCBO, directly carrying out sales to the customer while collecting fees on behalf of the LCBO and subsequently remitting them to the LCBO. A such, the sales based on the Selling Price seen within the Calculator tab would be considered the LCBO’s revenue, while there would be a deemed wholesale sale from the Distillery to the LCBO mainly based on the LCBO’s Landed Cost, which would be considered the Distillery’s revenue. *NEW*\n\nQuestions regarding the completion/content of the report? Contact distilleryreporting@lcbo.com"]
[]
[]
[]
["SUMMARY"]
[]
[]
[]
[]
[]
[]
[]
[null,"LCB 2413 (Distillery Container Deposit Statement)"]
[null,"1. When doing the monthly reporting, it is recommended that you complete forms with the most detailed information first,"]
[null,"    such as the Direct Delivery Sales Report. Sales information from this form will auto-populate the delivered direct to"]
[null,"     licensee sections of the LCB D10 and therefore, manual input is not required."]
[null,"2. Select your distillery name from the dropdown list and enter the reporting month and year at the top of the statement."]
[null,"     The distillery name and reporting month will automatically be populated in all of the other forms in the reporting template."]
[]
[null,"LCB 2414 (Distillery Direct Delivery Sales Report)"]
[null,"1. Distilleries must complete columns preceding Basic Price per bottle (Column G). All columns to the right are calculated fields."]
[null,"2. Please note that spirits cannot be sold the minimum retail price (MRP). If you enter a basic price below the acceptable MRP,"]
[null,"    you will get a \"below MRP\" notification in the Total Litres column."]
[null,"3. In order for the Print form button to work correctly, you must enter consecutive product descriptions up to the last product."]
[null,"4. Product # has now been replaced with Alcohol %. Please enter the alcohol % to ensure proper calculations. *NEW*"]
[null,"5. The Net HST [(Q) 13% HST on Sales - (R) 13% HST on COGS] is remitted to the LCBO *NEW*"]
[null,"6. (R) 13% HST on COGS represents the HST the LCBO is deemed to have paid the Distillery on the wholesale sale *NEW*"]
[]
[null,"LCB 2415 (Ontario Distillery Duty Free Sales Report)"]
[null,"1. Distilleries must complete columns preceding Costs per bottle (Column I). All columns to the right are calculated fields."]
[null,"2. Please note that spirits sold to duty free operators must be by the case and not individual bottles."]
[null,"3. In order for the Print form button to work correctly, you must enter consecutive product descriptions up to the last product."]
[]
[null,"Calculator and Revenue Distribution"]
[null,"1. Products sold in Ontario are subject to uniform pricing as per the Liquor Control Act, which means, prices shall be the same"]
[null,"    at all government stores. For spirits, government stores include LCBO stores and distillery retail stores."]
[null,"2. The calculator provides a pricing component breakdown of the retail price of spirits. The distillery must enter product attributes"]
[null,"    and based on this information, the calculator will produce the amounts for each pricing component."]
[null,"3. The calculator also provides a revenue distribution comparison through the various sales channels."]
[null,"4. The worksheet also contains all of the pricing components and the rates that are used to determine the retail price of spirits"]
[null,"    in Ontario."]
[]
[null,"Minimum Retail Prices (MRP)"]
[null,"1. Products sold in Ontario are also subject to minimum pricing as per Ontario Regulation 750/21, which means that products"]
[null,"    cannot be retailed below the established MRP/floor price."]
[null,"2. MRPs/floor prices are indexed annually based on the Ontario Consumer Price Index (CPI) to maintain social responsibility."]
[null,"3. The MRP varies based on the product category and the size of the product."]
[null,"4. Generally, products may not retail below the MRP/floor price, although, there are exceptions made for some products. Please"]
[null,"    refer to section 20 of Ontario Regulation 750/21 for more information on allowable exemptions."]
[]
[]
[null,"Payment Remittance\nA single payment is required to be made in the amount of the Total LCBO Payment evident within the Remittance Summary tab, no later than 20 days following the applicable month/quarter being reported upon. The Total LCBO Payment includes levies, mark-up, and applicable taxes on licensee sales (LCB 2414 tab), mark-up on Duty Free sales (LCB 2415 tab), and Container Deposits (LCB 2413 tab), all of which are collected on behalf of the LCBO. Payment is required to be made electronically, as per the LCBO Banking Instructions included within the welcome package, or by cheque."]

{"sheet":"Reporting Period","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"Format 1","Format 2","Frequency",null,"Calculator - DF Operator"]
[null,"2022-04-01","2022-04-01","MONTHLY REPORTING STARTING",null,"Non-Pearson"]
[null,"2022-05-01","2022-05-01","MONTHLY REPORTING STARTING",null,"Pearson"]
[null,"2022-06-01","2022-06-01","MONTHLY REPORTING STARTING"]
[null,"Q1 FY 2022-23","2022-06-30","QUARTERLY REPORTING ENDING"]
[null,"2022-07-01","2022-07-01","MONTHLY REPORTING STARTING"]
[null,"2022-08-01","2022-08-01","MONTHLY REPORTING STARTING"]
[null,"2022-09-01","2022-09-01","MONTHLY REPORTING STARTING"]
[null,"Q2 FY 2022-23","2022-09-30","QUARTERLY REPORTING ENDING"]
[null,"2022-10-01","2022-10-01","MONTHLY REPORTING STARTING"]
[null,"2022-11-01","2022-11-01","MONTHLY REPORTING STARTING"]
[null,"2022-12-01","2022-12-01","MONTHLY REPORTING STARTING"]
[null,"Q3 FY 2022-23","2022-12-31","QUARTERLY REPORTING ENDING"]
[null,"2023-01-01","2023-01-01","MONTHLY REPORTING STARTING"]
[null,"2023-02-01","2023-02-01","MONTHLY REPORTING STARTING"]
[null,"2023-03-01","2023-03-01","MONTHLY REPORTING STARTING"]
[null,"Q4 FY 2022-23","2023-03-31","QUARTERLY REPORTING ENDING"]

{"sheet":"LCB 2413","index":2,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[30,3,30,5],[1,1,1,2]]}
["Distillery Container Deposit Statement"]
[null,null,null,{"$f":"IF(Overview!$A$4=\"y\",1,0)","v":0}]
[null,"Distillery Name",null,null,null,{"$f":"IFERROR(VLOOKUP('LCB 2413'!$F$2,'Reporting Period'!$C$1:$D$17,2,0),\"Select MONTH Starting or QUARTER Ending Date From List\")","v":"Select MONTH Starting or QUARTER Ending Date From List"}]
[null,"Deposits Collected by Channel",null,"Containers",null,"Deposit Value"]
[null,"Less than or equal to 100 ml ($0.00 deposit)"]
[null,"Distillery Retail Store",null,null,null,{"$f":"IF(ISNUMBER(D6),D6*0,\"\")","v":""}]
[null,"Delivered Direct to Licensees",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$15),SUMPRODUCT(('LCB 2414'!$E$21:$E$54<=0.1)*('LCB 2414'!$D$21:$D$54<>\"TH\")*('LCB 2414'!$D$21:$D$54<>\"BTG\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,0]
[null,"Tied-House sales",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$16),SUMPRODUCT(('LCB 2414'!$E$21:$E$54<=0.1)*('LCB 2414'!$D$21:$D$54=\"TH\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,0]
[null,"By the Glass",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$17),SUMPRODUCT(('LCB 2414'!$E$21:$E$54<=0.1)*('LCB 2414'!$D$21:$D$54=\"BTG\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,0]
[null,"Other (e.g. drs, promotional, tastings)",null,null,null,""]
[null,"Less: Refilled Containers",null,null,null,""]
[null,"Subtotal",null,{"$f":"IF((SUM(D6:D10)-D11)<>0,SUM(D6:D10)-D11,0)","v":0},null,{"$f":"IF(ISNUMBER(D12),D12*0,0)","v":0}]
[null,"Greater than 100 ml and less than or equal to 630 ml ($0.10 deposit)"]
[null,"Distillery Retail Store",null,null,null,{"$f":"IF(D14<>0,ROUNDUP(D14,0)*0.1,\"\")","v":""}]
[null,"Delivered Direct to Licensees",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$15),SUMPRODUCT(('LCB 2414'!$E$21:$E$54>0.1)*('LCB 2414'!$E$21:$E$54<=0.63)*('LCB 2414'!$D$21:$D$54<>\"TH\")*('LCB 2414'!$D$21:$D$54<>\"BTG\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,{"$f":"IF(ISNUMBER(D15),ROUNDUP(D15,0)*0.1,\"\")","v":0}]
[null,"Tied-House sales",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$16),SUMPRODUCT(('LCB 2414'!$E$21:$E$54>0.1)*('LCB 2414'!$E$21:$E$54<=0.63)*('LCB 2414'!$D$21:$D$54=\"TH\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,{"$f":"IF(ISNUMBER(D16),ROUNDUP(D16,0)*0.1,\"\")","v":0}]
[null,"By the Glass",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$16),SUMPRODUCT(('LCB 2414'!$E$21:$E$54>0.1)*('LCB 2414'!$E$21:$E$54<=0.63)*('LCB 2414'!$D$21:$D$54=\"BTG\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,{"$f":"IF(ISNUMBER(D17),ROUNDUP(D17,0)*0.1,\"\")","v":0}]
[null,"Other (e.g. drs, promotional, tastings)",null,null,null,{"$f":"IF(ISNUMBER(D18),ROUNDUP(D18,0)*0.1,\"\")","v":""},null,null,null,"`"]
[null,"Less: Refilled Containers"]
[null,"Subtotal",null,{"$f":"IF((SUM(D14:D18)-D19)<>0,SUM(D14:D18)-D19,0)","v":0},null,{"$f":"IF(ISNUMBER(D20),D20*0.1,0)","v":0}]
[null,"Greater than 630 ml ($0.20 deposit)"]
[null,"Distillery Retail Store",null,null,null,{"$f":"IF(ISNUMBER(D22),ROUNDUP(D22,0)*0.2,\"\")","v":""}]
[null,"Delivered Direct to Licensees",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$15),SUMPRODUCT(('LCB 2414'!$E$21:$E$54>0.63)*('LCB 2414'!$D$21:$D$54<>\"TH\")*('LCB 2414'!$D$21:$D$54<>\"BTG\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,0]
[null,"Tied-House sales",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$16),SUMPRODUCT(('LCB 2414'!$E$21:$E$54>0.63)*('LCB 2414'!$D$21:$D$54=\"TH\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1)))-SUMPRODUCT(('LCB 2414'!$E$21:$E$54>=18)*('LCB 2414'!$D$21:$D$54=\"TH\")*('LCB 2414'!$C$21:$C$54=\"B\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,0]
[null,"By the Glass",null,{"$f":"IF(ISNUMBER('LCB 2414'!$I$16),SUMPRODUCT(('LCB 2414'!$E$21:$E$54>0.63)*('LCB 2414'!$D$21:$D$54=\"BTG\")*(('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54)+('LCB 2414'!$F$21:$F$54)*('LCB 2414'!$G$21:$G$54<1))),\"\")","v":0},null,0]
[null,"Other (e.g. drs, promotional, tastings)",null,null,null,{"$f":"IF(ISNUMBER(D26),ROUNDUP(D26,0)*0.2,\"\")","v":""}]
[null,"Less: Refilled Containers",null,null,null,""]
[null,"Subtotal",null,{"$f":"IF((SUM(D22:D26)-D27)<>0,SUM(D22:D26)-D27,0)","v":0},null,{"$f":"IF(ISNUMBER(D28),D28*0.2,0)","v":0}]
[null,"Total Containers and Deposits",null,{"$f":"IF(SUM(D12,D20,D28)<>0,SUM(D12,D20,D28),0)","v":0},null,{"$f":"IF(SUM(F12,F20,F28)<>0,SUM(F12,F20,F28),0)","v":0}]
[null,"Note: Unless specified, container types include glass, aluminum cans, ceramic, Tetra Pak and PET."]
[null,null,null,{"$f":"IF(ISBLANK('LCB 2413'!$B$2),\"\",'LCB 2413'!$B$2)","v":""},{"$f":"IF(ISBLANK('LCB 2413'!$B$2),\"\",'LCB 2413'!$B$2)","v":""}]
[null,"(Name & Title)",null,"(Name of Distillery)"]
[null,"do hereby certify that the information set out in this report is true and correct to the best of my knowledge and belief"]
[]
[null,"(Date)"]
[]
[]
[]
[]
[]
[null,"LCB 2413 (V2.0)",null,null,null,"Page 1 of 1"]

{"sheet":"LCB 2414","index":3,"n_rows":54,"n_cols":35,"rows_kept":54,"cut":false,"hidden":false,"merged":[[6,1,6,5],[7,1,7,5],[7,21,7,22]]}
[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,null,null,"Pricing Components","Rate","Metric",null,"Pricing Components","Rate","Metric"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCB 2414",null,null,null,null,null,{"$f":"Calculator!J3","v":"Whisky, Rum, Gin, Vodka, Liqueurs, Brandy"},{"$f":"Calculator!K3","v":1.397},"ad valorem",2,{"$f":"Calculator!J26","v":"Excise"},{"$f":"Calculator!K26","v":13.042},{"$f":"Calculator!L26","v":"per LAA"}]
["Distillery Direct Delivery Sales Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05-21",null,null,null,null,null,{"$f":"Calculator!J4","v":"One Pour / Pre-Mixed Cocktails"},{"$f":"Calculator!K4","v":0.96699999999999997},"ad valorem",3,{"$f":"Calculator!J25","v":"Cooler Excise"},{"$f":"Calculator!K25","v":0.33},"per litre"]
[null,null,null,null,null,{"$f":"'LCB 2413'!D2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculator!K5","v":0.68500000000000005},"ad valorem",4]
["Summary of Spirit Sales to Licensees on behalf of the LCBO",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,null,{"$f":"Calculator!J5","v":"Spirit Coolers"},{"$f":"Calculator!K5","v":0.68500000000000005},"ad valorem",5,"Cooler MRP",{"$f":"Calculator!K21","v":3.7789999999999999},"per litre"]
[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,null,null,{"$f":"Calculator!J10","v":"Volume Levy"},{"$f":"Calculator!K10","v":0.38},"per litre",6,"Cooler MRP",{"$f":"Calculator!K22","v":3.8340000000000001},"per litre"]
["Ontario Distillery Name",{"$f":"IF(ISBLANK('LCB 2413'!B2:C2),\"\",'LCB 2413'!B2:C2)","v":""},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,"Cooler Bottle Levy",{"$f":"Calculator!K11","v":0.28000000000000003},"per litre",7,"Cooler MRP",{"$f":"Calculator!K23","v":3.9350000000000001},"per litre"]
["HST Registration#",null,null,null,null,null,null,null,null,{"$f":"'LCB 2413'!D2","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('LCB 2413'!$F$2),\"\",'LCB 2413'!$F$3)","v":""},{"$f":"IF(ISBLANK('LCB 2413'!$F$2),\"\",'LCB 2413'!$F$2)","v":""},null,null,null,null,null,null,"Environmental Fee",{"$f":"Calculator!K12","v":8.9300000000000004E-2},"per bottle",8,"Cooler MRP",{"$f":"Calculator!K24","v":73.064999999999998},"per litre"]
[null,null,null,null,null,null,null,null,"Note: Print form button must be used if entries exceed one page (row 41).",null,null,null,null,null,null,null,null,null,null,null,null,"REPORTING PERIOD",null,null,null,null,null,null,"Bottle Deposit <=630ml",{"$f":"Calculator!K13","v":0.1},"per bottle",9]
["Product Categories:","Licensee Type:",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,"Bottle Deposit >630ml",{"$f":"Calculator!K14","v":0.2},"per bottle",10]
["Whisky = W             Liqueur = L","Licensees = Blank or Any Value ≠ TH or BTG",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,{"$f":"Calculator!J15","v":"Direct Delivery Rebate"},{"$f":"Calculator!K15","v":0.2},"ad valorem",11]
["Rum = R                   Vodka = V","Tied-House  = TH",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,"Licensee Markup",{"$f":"Calculator!K16","v":0},"ad valorem",12]
["Gin = G                     Brandy = B","By the Glass = BTG",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,{"$f":"Calculator!J17","v":"Licensee Discount"},{"$f":"Calculator!K17","v":0.1},"ad valorem",13]
["One Pour / Pre-Mix Cocktails = P","Grand Total",null,null,null,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(SUM(F$21:F$54),0),0)","v":0},null," ",{"$f":"IF(SUM($I$21:$I$54)<>0,ROUND(SUM(I$21:I$54),0),0)","v":0},{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(SUM(J$21:J$54),2),0)","v":0},null,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(SUM(L$21:L$54),2),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"ISNUMBER(Z14)","v":false},null,{"$f":"Calculator!J18","v":"HST (GST Portion)"},{"$f":"Calculator!K18","v":0.05},"ad valorem",14]
["Coolers = C","Licensees Subtotal",null,null,null,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(F14-F16-F17,0),0)","v":0},null,null,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(I14-I16-I17,0),0)","v":0},{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(J14-J16-J17,2),0)","v":0},null,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(L14-L16-L17,2),0)","v":0},{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(M14-M16-M17,2),0)","v":0},0,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(O14-O16,2),0)","v":0},{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(P14-P16-P17,2),0)","v":0},{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(Q14-Q16-Q17,2),0)","v":0},0,0,0,0,0,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(W14-W16-W17,2),0)","v":0},null,null,null,null,null,{"$f":"Calculator!J19","v":"HST (PST Portion)"},{"$f":"Calculator!K19","v":0.08},"ad valorem",15]
[null,"Tied-House Subtotal",null,null,null,{"$f":"IF(SUM(F$21:F$54)<>0,SUMIF($D$21:$D$54,\"TH\",F$21:F$54),0)","v":0},null,null,{"$f":"IF(SUM(I$21:I$54)<>0,SUMIF($D$21:$D$54,\"TH\",I$21:I$54),0)","v":0},{"$f":"IF(SUM(J$21:J$54)<>0,SUMIF($D$21:$D$54,\"TH\",J$21:J$54),0)","v":0},null,{"$f":"IF(SUM(L$21:L$54)<>0,SUMIF($D$21:$D$54,\"TH\",L$21:L$54),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,"Enviro Surcharge",0.04,"ad valorem",16]
[null,"By the Glass Subtotal",null,null,null,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(SUMIF($D$21:$D$54,\"BTG\",F$21:F$54),0),0)","v":0},null,null,{"$f":"IF(SUM($I$21:$I$54)<>0,ROUND(SUMIF($D$21:$D$54,\"BTG\",I$21:I$54),0),0)","v":0},{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(SUMIF($D$21:$D$54,\"BTG\",J$21:J$54),2),0)","v":0},null,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(SUMIF($D$21:$D$54,\"BTG\",L$21:L$54),2),0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF(SUM($F$21:$F$54)<>0,ROUND(SUMIF($D$21:$D$54,\"BTG\",W$21:W$54),2),0)","v":0},null,null,null,null,null,"Rebate",0.2,"ad valorem",17]
["(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)","(L)","(M)","(N)","(O)","(P)","(Q)","(R)","(S)","(T)","(U)","(V)","(W)"]
[" Product Description","Product Alcohol %"," Product Category (See Above)","Licensee Type","Bottle Size (L)","Units Sold","# of Bottles per Unit (Req'd for Product Category 'C')","Basic Price per Unit (Retail price less HST and Deposit)","Total # of Bottles","Total litres","Landed Cost","Cost of Goods Sold to LCBO","Total Basic Sales","10% Discount  ","0% Licensee Markup","Net Sales","13% HST on Sales","13% HST on COGS","Refundable Container Deposit","Total Collected","Rebate","Supplier Portion (excluding container deposit)","Total Remittance (excluding container deposit)"]
[null," ",null,null,null,null,null,null,"(F or F x G)","(E x I)",null,"(F x K)","(F x H)","(10% of M)","(0% of (M-N))","(M-N)","(13% of P)","(13% of L)",null,"(P+Q+S)","(20% of M)",null,"(T-L-R-S-U)",null,"MRP Check","NON BULK","BULK",null,"Class A","Class B","Coolers/Pre-Mix","Enviro Fee","Price","MRP"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($C21),\"\",IF(OR($Y21=\"below MRP\",$Y21=\"btl size error\"),$Y21,IF(ISNONTEXT($C21),\"\",IF(OR($C21=\" \",$Y21=\"\"),\"\",IF(AND($C21=\"c\",ISBLANK($G21)),\"\",IF(AND(OR($C21=\"C\",$C21=\"w\",$C21=\"r\",$C21=\"g\",$C21=\"l\",$C21=\"v\",$C21=\"b\",$C21=\"p\"),$F21<>0,$G21<>0),$F21*$G21,$F21))))))","v":""},{"$f":"IF(ISBLANK(C21),\"\",IF(ISNONTEXT(C21),\"\",IF(C21=\" \",\"-\",IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),E21*I21,\"category?\"))))","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),$Z21,IF(ISBLANK(C21),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),F21*K21,IF(ISBLANK(C21),\"\",\"category?\"))","v":""},{"$f":"IF(ISNONTEXT($J21),H21*F21,\"\")","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),M21*$AD$13,IF(ISBLANK(C21),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),$AD$12*($M21-$N21),IF(ISBLANK(C21),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),M21-N21,IF(ISBLANK(C21),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),($AD$14+$AD$15)*($P21),IF(ISBLANK(C21),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),($AD$14+$AD$15)*$L21,IF(ISBLANK(C21),\"\",\"category?\"))","v":""},{"$f":"IF(AND(E21>=16,C21<>\"c\",C21<>\"d\"),0,IF(AND(E21>=18,OR(C21=\"c\",C21=\"d\")),0,IF(AND(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),E21<=0.1),0,IF(AND(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),E21<=0.63),$AD$9*I21,IF(AND(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),E21>0.63),$AD$10*I21,IF(ISBLANK(C21),\"\",\"category?\"))))))","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),P21+Q21+S21,IF(ISBLANK(C21),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),M21*$AD$17,\"\")","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),T21-S21-W21,\"\")","v":""},{"$f":"IF(OR(C21=\"W\",C21=\"R\",C21=\"G\",C21=\"L\",$C21=\"V\",$C21=\"B\",$C21=\"P\",$C21=\"C\"),$T21-$L21-$R21-$S21-$U21,IF(J21=\"below MRP\",J21,\"\"))","v":""},null,{"$f":"IFERROR(IF(C21=\"l\",AD21,IF(OR(C21=\"c\",C21=\"P\"),AE21,AC21)),\"Okay\")","v":"Okay"},{"$f":"IF(AND(ISNUMBER(H21),OR($C21=\"W\",$C21=\"R\",$C21=\"G\",$C21=\"L\",$C21=\"V\",$C21=\"B\")),(H21-($AD$6*$E21)-$AD$8)/(1+$AD$2),IF(AND(ISNUMBER(H21),$C21=\"P\"),(H21-($AD$6*$E21)-$AD$8)/(1+$AD$3),IF(AND(ISNUMBER(H21),$C21=\"c\"),(H21-$AD$7*$E21*$G21-$AD$8*$G21)/(1+$AD$5),\"0\")))","v":"0"},null,null,{"$f":"IF(ROUND($H21*(1+$AD$14+$AD$15),2)+IF($E21>0.63,$AD$10,IF(AND($E21>=0.1,$E21<0.63),$AD$9,0))<CEILING(VLOOKUP($E21*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E21*1000,MRP!$A$3:$C$43,1)*$E21*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H21*(1+$AD$14+$AD$15)+IF($E21>0.63,$AD$10,IF(AND($E21>=0.1,$E21<0.63),$AD$9,0))<CEILING(VLOOKUP($E21*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E21*1000,MRP!$A$3:$C$43,1)*$E21*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(OR($C21=\"c\",$C21=\"p\"),$B21<4.1%,ROUND(H21*(1+$AD$14+$AD$15),2)<CEILING($AH$5*$E21*$G21+$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16),0.05)),\"Below MRP\",IF(AND(OR($C21=\"c\",$C21=\"p\"),$B21>=4.1%,$B21<4.9%,ROUND(H21*(1+$AD$14+$AD$15),2)<CEILING($AH$6*$E21*$G21+$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16),0.05)),\"Below MRP\",IF(AND(OR($C21=\"c\",$C21=\"p\"),$B21>=4.9%,$B21<5.6%,ROUND(H21*(1+$AD$14+$AD$15),2)<CEILING($AH$7*$E21*$G21+$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16),0.05)),\"Below MRP\",IF(AND(OR($C21=\"c\",$C21=\"p\"),$B21>=5.6%,ROUND(H21*(1+$AD$14+$AD$15),2)<CEILING($AH$8*$E21*$B21*$G21+$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16),0.05)),\"Below MRP\",\"Okay\"))))","v":"Okay"},{"$f":"IF(E21>=16,0,$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16))","v":0},{"$f":"H21*(1+$AD$14+$AD$15)","v":0},{"$f":"IF(B21<4.1%,CEILING($AH$5*$E$21*$G$21+$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16),0.05),IF(AND(B21>=4.1%,B21<4.9%),CEILING($AH$6*$E$21*$G$21+$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16),0.05),IF(AND(B21>=4.9%,B21<5.6%),CEILING($AH$7*$E$21*$G$21+$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16),0.05),IF(B21>=5.6%,CEILING($AH$8*$E$21*$B$21*$G$21+$AD$8*$G21*(1+$AD$14+$AD$15+$AD$16),0.05)))))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($C22),\"\",IF(OR($Y22=\"below MRP\",$Y22=\"btl size error\"),$Y22,IF(ISNONTEXT($C22),\"\",IF(OR($C22=\" \",$Y22=\"\"),\"\",IF(AND($C22=\"c\",ISBLANK($G22)),\"\",IF(AND(OR($C22=\"C\",$C22=\"w\",$C22=\"r\",$C22=\"g\",$C22=\"l\",$C22=\"v\",$C22=\"b\",$C22=\"p\"),$F22<>0,$G22<>0),$F22*$G22,$F22))))))","v":""},{"$f":"IF(ISBLANK(C22),\"\",IF(ISNONTEXT(C22),\"\",IF(C22=\" \",\"-\",IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),E22*I22,\"?category\"))))","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),$Z22,IF(ISBLANK(C22),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),F22*K22,IF(ISBLANK(C22),\"\",\"category?\"))","v":""},{"$f":"IF(ISNONTEXT($J22),H22*F22,\"\")","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),M22*$AD$13,IF(ISBLANK(C22),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),$AD$12*($M22-$N22),IF(ISBLANK(C22),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),M22-N22,IF(ISBLANK(C22),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),($AD$14+$AD$15)*($P22),IF(ISBLANK(C22),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),($AD$14+$AD$15)*$L22,IF(ISBLANK(C22),\"\",\"category?\"))","v":""},{"$f":"IF(AND(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),E22<=0.1),0,IF(AND(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),E22<=0.63),$AD$9*I22,IF(AND(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),E22>0.63),$AD$10*I22,IF(ISBLANK(C22),\"\",\"category?\"))))","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),P22+Q22+S22,IF(ISBLANK(C22),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),M22*$AD$17,\"\")","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),T22-S22-W22,\"\")","v":""},{"$f":"IF(OR(C22=\"W\",C22=\"R\",C22=\"G\",C22=\"L\",$C22=\"V\",$C22=\"B\",$C22=\"P\",$C22=\"C\"),$T22-$L22-$R22-$S22-$U22,IF(J22=\"below MRP\",J22,\"\"))","v":""},null,{"$f":"IFERROR(IF(C22=\"l\",AD22,IF(OR(C22=\"c\",C22=\"P\"),AE22,AC22)),\"Okay\")","v":"Okay"},{"$f":"IF(AND(ISNUMBER(H22),OR($C22=\"W\",$C22=\"R\",$C22=\"G\",$C22=\"L\",$C22=\"V\",$C22=\"B\")),(H22-($AD$6*$E22)-$AD$8)/(1+$AD$2),IF(AND(ISNUMBER(H22),$C22=\"P\"),(H22-($AD$6*$E22)-$AD$8)/(1+$AD$3),IF(AND(ISNUMBER(H22),$C22=\"c\"),(H22-$AD$7*$E22*$G22-$AD$8*$G22)/(1+$AD$5),\"0\")))","v":"0"},null,null,{"$f":"IF($H22*(1+$AD$14+$AD$15)+IF($E22>0.63,$AD$10,IF(AND($E22>=0.1,$E22<0.63),$AD$9,0))<CEILING(VLOOKUP($E22*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E22*1000,MRP!$A$3:$C$43,1)*$E22*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H22*(1+$AD$14+$AD$15)+IF($E22>0.63,$AD$10,IF(AND($E22>=0.1,$E22<0.63),$AD$9,0))<CEILING(VLOOKUP($E22*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E22*1000,MRP!$A$3:$C$43,1)*$E22*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(OR($C22=\"c\",$C22=\"p\"),$B22<4.1%,ROUND(H22*(1+$AD$14+$AD$15),2)<CEILING($AH$5*$E22*$G22+$AD$8*$G22*(1+$AD$14+$AD$15+$AD$16),0.05)),\"Below MRP\",IF(AND(OR($C22=\"c\",$C22=\"p\"),$B22>=4.1%,$B22<4.9%,ROUND(H22*(1+$AD$14+$AD$15),2)<CEILING($AH$6*$E22*$G22+$AD$8*$G22*(1+$AD$14+$AD$15+$AD$16),0.05)),\"Below MRP\",IF(AND(OR($C22=\"c\",$C22=\"p\"),$B22>=4.9%,$B22<5.6%,ROUND(H22*(1+$AD$14+$AD$15),2)<CEILING($AH$7*$E22*$G22+$AD$8*$G22*(1+$AD$14+$AD$15+$AD$16),0.05)),\"Below MRP\",IF(AND(OR($C22=\"c\",$C22=\"p\"),$B22>=5.6%,ROUND(H22*(1+$AD$14+$AD$15),2)<CEILING($AH$8*$E22*$B22*$G22+$AD$8*$G22*(1+$AD$14+$AD$15+$AD$16),0.05)),\"Below MRP\",\"Okay\"))))","v":"Okay"}]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H23*(1+$AD$14+$AD$15)+IF($E23>0.63,$AD$10,IF(AND($E23>=0.1,$E23<0.63),$AD$9,0))<CEILING(VLOOKUP($E23*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E23*1000,MRP!$A$3:$C$43,1)*$E23*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H23*(1+$AD$14+$AD$15)+IF($E23>0.63,$AD$10,IF(AND($E23>=0.1,$E23<0.63),$AD$9,0))<CEILING(VLOOKUP($E23*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E23*1000,MRP!$A$3:$C$43,1)*$E23*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H24*(1+$AD$14+$AD$15)+IF($E24>0.63,$AD$10,IF(AND($E24>=0.1,$E24<0.63),$AD$9,0))<CEILING(VLOOKUP($E24*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E24*1000,MRP!$A$3:$C$43,1)*$E24*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H24*(1+$AD$14+$AD$15)+IF($E24>0.63,$AD$10,IF(AND($E24>=0.1,$E24<0.63),$AD$9,0))<CEILING(VLOOKUP($E24*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E24*1000,MRP!$A$3:$C$43,1)*$E24*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H25*(1+$AD$14+$AD$15)+IF($E25>0.63,$AD$10,IF(AND($E25>=0.1,$E25<0.63),$AD$9,0))<CEILING(VLOOKUP($E25*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E25*1000,MRP!$A$3:$C$43,1)*$E25*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H25*(1+$AD$14+$AD$15)+IF($E25>0.63,$AD$10,IF(AND($E25>=0.1,$E25<0.63),$AD$9,0))<CEILING(VLOOKUP($E25*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E25*1000,MRP!$A$3:$C$43,1)*$E25*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H26*(1+$AD$14+$AD$15)+IF($E26>0.63,$AD$10,IF(AND($E26>=0.1,$E26<0.63),$AD$9,0))<CEILING(VLOOKUP($E26*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E26*1000,MRP!$A$3:$C$43,1)*$E26*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H26*(1+$AD$14+$AD$15)+IF($E26>0.63,$AD$10,IF(AND($E26>=0.1,$E26<0.63),$AD$9,0))<CEILING(VLOOKUP($E26*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E26*1000,MRP!$A$3:$C$43,1)*$E26*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H27*(1+$AD$14+$AD$15)+IF($E27>0.63,$AD$10,IF(AND($E27>=0.1,$E27<0.63),$AD$9,0))<CEILING(VLOOKUP($E27*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E27*1000,MRP!$A$3:$C$43,1)*$E27*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H27*(1+$AD$14+$AD$15)+IF($E27>0.63,$AD$10,IF(AND($E27>=0.1,$E27<0.63),$AD$9,0))<CEILING(VLOOKUP($E27*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E27*1000,MRP!$A$3:$C$43,1)*$E27*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H28*(1+$AD$14+$AD$15)+IF($E28>0.63,$AD$10,IF(AND($E28>=0.1,$E28<0.63),$AD$9,0))<CEILING(VLOOKUP($E28*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E28*1000,MRP!$A$3:$C$43,1)*$E28*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H28*(1+$AD$14+$AD$15)+IF($E28>0.63,$AD$10,IF(AND($E28>=0.1,$E28<0.63),$AD$9,0))<CEILING(VLOOKUP($E28*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E28*1000,MRP!$A$3:$C$43,1)*$E28*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H29*(1+$AD$14+$AD$15)+IF($E29>0.63,$AD$10,IF(AND($E29>=0.1,$E29<0.63),$AD$9,0))<CEILING(VLOOKUP($E29*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E29*1000,MRP!$A$3:$C$43,1)*$E29*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H29*(1+$AD$14+$AD$15)+IF($E29>0.63,$AD$10,IF(AND($E29>=0.1,$E29<0.63),$AD$9,0))<CEILING(VLOOKUP($E29*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E29*1000,MRP!$A$3:$C$43,1)*$E29*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H30*(1+$AD$14+$AD$15)+IF($E30>0.63,$AD$10,IF(AND($E30>=0.1,$E30<0.63),$AD$9,0))<CEILING(VLOOKUP($E30*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E30*1000,MRP!$A$3:$C$43,1)*$E30*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H30*(1+$AD$14+$AD$15)+IF($E30>0.63,$AD$10,IF(AND($E30>=0.1,$E30<0.63),$AD$9,0))<CEILING(VLOOKUP($E30*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E30*1000,MRP!$A$3:$C$43,1)*$E30*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H31*(1+$AD$14+$AD$15)+IF($E31>0.63,$AD$10,IF(AND($E31>=0.1,$E31<0.63),$AD$9,0))<CEILING(VLOOKUP($E31*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E31*1000,MRP!$A$3:$C$43,1)*$E31*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H31*(1+$AD$14+$AD$15)+IF($E31>0.63,$AD$10,IF(AND($E31>=0.1,$E31<0.63),$AD$9,0))<CEILING(VLOOKUP($E31*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E31*1000,MRP!$A$3:$C$43,1)*$E31*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H32*(1+$AD$14+$AD$15)+IF($E32>0.63,$AD$10,IF(AND($E32>=0.1,$E32<0.63),$AD$9,0))<CEILING(VLOOKUP($E32*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E32*1000,MRP!$A$3:$C$43,1)*$E32*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H32*(1+$AD$14+$AD$15)+IF($E32>0.63,$AD$10,IF(AND($E32>=0.1,$E32<0.63),$AD$9,0))<CEILING(VLOOKUP($E32*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E32*1000,MRP!$A$3:$C$43,1)*$E32*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H33*(1+$AD$14+$AD$15)+IF($E33>0.63,$AD$10,IF(AND($E33>=0.1,$E33<0.63),$AD$9,0))<CEILING(VLOOKUP($E33*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E33*1000,MRP!$A$3:$C$43,1)*$E33*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H33*(1+$AD$14+$AD$15)+IF($E33>0.63,$AD$10,IF(AND($E33>=0.1,$E33<0.63),$AD$9,0))<CEILING(VLOOKUP($E33*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E33*1000,MRP!$A$3:$C$43,1)*$E33*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H34*(1+$AD$14+$AD$15)+IF($E34>0.63,$AD$10,IF(AND($E34>=0.1,$E34<0.63),$AD$9,0))<CEILING(VLOOKUP($E34*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E34*1000,MRP!$A$3:$C$43,1)*$E34*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H34*(1+$AD$14+$AD$15)+IF($E34>0.63,$AD$10,IF(AND($E34>=0.1,$E34<0.63),$AD$9,0))<CEILING(VLOOKUP($E34*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E34*1000,MRP!$A$3:$C$43,1)*$E34*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H35*(1+$AD$14+$AD$15)+IF($E35>0.63,$AD$10,IF(AND($E35>=0.1,$E35<0.63),$AD$9,0))<CEILING(VLOOKUP($E35*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E35*1000,MRP!$A$3:$C$43,1)*$E35*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H35*(1+$AD$14+$AD$15)+IF($E35>0.63,$AD$10,IF(AND($E35>=0.1,$E35<0.63),$AD$9,0))<CEILING(VLOOKUP($E35*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E35*1000,MRP!$A$3:$C$43,1)*$E35*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H36*(1+$AD$14+$AD$15)+IF($E36>0.63,$AD$10,IF(AND($E36>=0.1,$E36<0.63),$AD$9,0))<CEILING(VLOOKUP($E36*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E36*1000,MRP!$A$3:$C$43,1)*$E36*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H36*(1+$AD$14+$AD$15)+IF($E36>0.63,$AD$10,IF(AND($E36>=0.1,$E36<0.63),$AD$9,0))<CEILING(VLOOKUP($E36*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E36*1000,MRP!$A$3:$C$43,1)*$E36*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H37*(1+$AD$14+$AD$15)+IF($E37>0.63,$AD$10,IF(AND($E37>=0.1,$E37<0.63),$AD$9,0))<CEILING(VLOOKUP($E37*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E37*1000,MRP!$A$3:$C$43,1)*$E37*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H37*(1+$AD$14+$AD$15)+IF($E37>0.63,$AD$10,IF(AND($E37>=0.1,$E37<0.63),$AD$9,0))<CEILING(VLOOKUP($E37*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E37*1000,MRP!$A$3:$C$43,1)*$E37*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H38*(1+$AD$14+$AD$15)+IF($E38>0.63,$AD$10,IF(AND($E38>=0.1,$E38<0.63),$AD$9,0))<CEILING(VLOOKUP($E38*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E38*1000,MRP!$A$3:$C$43,1)*$E38*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H38*(1+$AD$14+$AD$15)+IF($E38>0.63,$AD$10,IF(AND($E38>=0.1,$E38<0.63),$AD$9,0))<CEILING(VLOOKUP($E38*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E38*1000,MRP!$A$3:$C$43,1)*$E38*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H39*(1+$AD$14+$AD$15)+IF($E39>0.63,$AD$10,IF(AND($E39>=0.1,$E39<0.63),$AD$9,0))<CEILING(VLOOKUP($E39*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E39*1000,MRP!$A$3:$C$43,1)*$E39*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H39*(1+$AD$14+$AD$15)+IF($E39>0.63,$AD$10,IF(AND($E39>=0.1,$E39<0.63),$AD$9,0))<CEILING(VLOOKUP($E39*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E39*1000,MRP!$A$3:$C$43,1)*$E39*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H40*(1+$AD$14+$AD$15)+IF($E40>0.63,$AD$10,IF(AND($E40>=0.1,$E40<0.63),$AD$9,0))<CEILING(VLOOKUP($E40*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E40*1000,MRP!$A$3:$C$43,1)*$E40*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H40*(1+$AD$14+$AD$15)+IF($E40>0.63,$AD$10,IF(AND($E40>=0.1,$E40<0.63),$AD$9,0))<CEILING(VLOOKUP($E40*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E40*1000,MRP!$A$3:$C$43,1)*$E40*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H41*(1+$AD$14+$AD$15)+IF($E41>0.63,$AD$10,IF(AND($E41>=0.1,$E41<0.63),$AD$9,0))<CEILING(VLOOKUP($E41*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E41*1000,MRP!$A$3:$C$43,1)*$E41*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H41*(1+$AD$14+$AD$15)+IF($E41>0.63,$AD$10,IF(AND($E41>=0.1,$E41<0.63),$AD$9,0))<CEILING(VLOOKUP($E41*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E41*1000,MRP!$A$3:$C$43,1)*$E41*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H42*(1+$AD$14+$AD$15)+IF($E42>0.63,$AD$10,IF(AND($E42>=0.1,$E42<0.63),$AD$9,0))<CEILING(VLOOKUP($E42*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E42*1000,MRP!$A$3:$C$43,1)*$E42*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H42*(1+$AD$14+$AD$15)+IF($E42>0.63,$AD$10,IF(AND($E42>=0.1,$E42<0.63),$AD$9,0))<CEILING(VLOOKUP($E42*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E42*1000,MRP!$A$3:$C$43,1)*$E42*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H43*(1+$AD$14+$AD$15)+IF($E43>0.63,$AD$10,IF(AND($E43>=0.1,$E43<0.63),$AD$9,0))<CEILING(VLOOKUP($E43*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E43*1000,MRP!$A$3:$C$43,1)*$E43*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H43*(1+$AD$14+$AD$15)+IF($E43>0.63,$AD$10,IF(AND($E43>=0.1,$E43<0.63),$AD$9,0))<CEILING(VLOOKUP($E43*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E43*1000,MRP!$A$3:$C$43,1)*$E43*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H44*(1+$AD$14+$AD$15)+IF($E44>0.63,$AD$10,IF(AND($E44>=0.1,$E44<0.63),$AD$9,0))<CEILING(VLOOKUP($E44*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E44*1000,MRP!$A$3:$C$43,1)*$E44*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H44*(1+$AD$14+$AD$15)+IF($E44>0.63,$AD$10,IF(AND($E44>=0.1,$E44<0.63),$AD$9,0))<CEILING(VLOOKUP($E44*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E44*1000,MRP!$A$3:$C$43,1)*$E44*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H45*(1+$AD$14+$AD$15)+IF($E45>0.63,$AD$10,IF(AND($E45>=0.1,$E45<0.63),$AD$9,0))<CEILING(VLOOKUP($E45*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E45*1000,MRP!$A$3:$C$43,1)*$E45*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H45*(1+$AD$14+$AD$15)+IF($E45>0.63,$AD$10,IF(AND($E45>=0.1,$E45<0.63),$AD$9,0))<CEILING(VLOOKUP($E45*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E45*1000,MRP!$A$3:$C$43,1)*$E45*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H46*(1+$AD$14+$AD$15)+IF($E46>0.63,$AD$10,IF(AND($E46>=0.1,$E46<0.63),$AD$9,0))<CEILING(VLOOKUP($E46*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E46*1000,MRP!$A$3:$C$43,1)*$E46*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H46*(1+$AD$14+$AD$15)+IF($E46>0.63,$AD$10,IF(AND($E46>=0.1,$E46<0.63),$AD$9,0))<CEILING(VLOOKUP($E46*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E46*1000,MRP!$A$3:$C$43,1)*$E46*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H47*(1+$AD$14+$AD$15)+IF($E47>0.63,$AD$10,IF(AND($E47>=0.1,$E47<0.63),$AD$9,0))<CEILING(VLOOKUP($E47*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E47*1000,MRP!$A$3:$C$43,1)*$E47*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H47*(1+$AD$14+$AD$15)+IF($E47>0.63,$AD$10,IF(AND($E47>=0.1,$E47<0.63),$AD$9,0))<CEILING(VLOOKUP($E47*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E47*1000,MRP!$A$3:$C$43,1)*$E47*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H48*(1+$AD$14+$AD$15)+IF($E48>0.63,$AD$10,IF(AND($E48>=0.1,$E48<0.63),$AD$9,0))<CEILING(VLOOKUP($E48*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E48*1000,MRP!$A$3:$C$43,1)*$E48*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H48*(1+$AD$14+$AD$15)+IF($E48>0.63,$AD$10,IF(AND($E48>=0.1,$E48<0.63),$AD$9,0))<CEILING(VLOOKUP($E48*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E48*1000,MRP!$A$3:$C$43,1)*$E48*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H49*(1+$AD$14+$AD$15)+IF($E49>0.63,$AD$10,IF(AND($E49>=0.1,$E49<0.63),$AD$9,0))<CEILING(VLOOKUP($E49*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E49*1000,MRP!$A$3:$C$43,1)*$E49*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H49*(1+$AD$14+$AD$15)+IF($E49>0.63,$AD$10,IF(AND($E49>=0.1,$E49<0.63),$AD$9,0))<CEILING(VLOOKUP($E49*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E49*1000,MRP!$A$3:$C$43,1)*$E49*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(C50),\"\",IF(ISNONTEXT(C50),\"\",IF(C50=\" \",\"-\",IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),E50*I50,\"?category\"))))","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),$Z50,IF(ISBLANK(C50),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),F50*K50,IF(ISBLANK(C50),\"\",\"category?\"))","v":""},{"$f":"IF(ISNONTEXT($J50),H50*F50,\"\")","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),M50*$AD$13,IF(ISBLANK(C50),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),$AD$12*($M50-$N50),IF(ISBLANK(C50),\"\",\"category?\"))","v":""},"",{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),($AD$14+$AD$15)*($P50),IF(ISBLANK(C50),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),($AD$14+$AD$15)*$L50,IF(ISBLANK(C50),\"\",\"category?\"))","v":""},{"$f":"IF(AND(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),E50<=0.1),0,IF(AND(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),E50<=0.63),$AD$9*I50,IF(AND(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),E50>0.63),$AD$10*I50,IF(ISBLANK(C50),\"\",\"category?\"))))","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),P50+Q50+S50,IF(ISBLANK(C50),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),M50*$AD$17,\"\")","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),T50-S50-W50,\"\")","v":""},{"$f":"IF(OR(C50=\"W\",C50=\"R\",C50=\"G\",C50=\"L\",$C50=\"V\",$C50=\"B\",$C50=\"P\",$C50=\"C\"),$T50-$L50-$R50-$S50-$U50,IF(J50=\"below MRP\",J50,\"\"))","v":""},null,"Okay","0",null,null,{"$f":"IF($H50*(1+$AD$14+$AD$15)+IF($E50>0.63,$AD$10,IF(AND($E50>=0.1,$E50<0.63),$AD$9,0))<CEILING(VLOOKUP($E50*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E50*1000,MRP!$A$3:$C$43,1)*$E50*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H50*(1+$AD$14+$AD$15)+IF($E50>0.63,$AD$10,IF(AND($E50>=0.1,$E50<0.63),$AD$9,0))<CEILING(VLOOKUP($E50*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E50*1000,MRP!$A$3:$C$43,1)*$E50*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(C51),\"\",IF(ISNONTEXT(C51),\"\",IF(C51=\" \",\"-\",IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),E51*I51,\"?category\"))))","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),$Z51,IF(ISBLANK(C51),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),F51*K51,IF(ISBLANK(C51),\"\",\"category?\"))","v":""},{"$f":"IF(ISNONTEXT($J51),H51*F51,\"\")","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),M51*$AD$13,IF(ISBLANK(C51),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),$AD$12*($M51-$N51),IF(ISBLANK(C51),\"\",\"category?\"))","v":""},"",{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),($AD$14+$AD$15)*($P51),IF(ISBLANK(C51),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),($AD$14+$AD$15)*$L51,IF(ISBLANK(C51),\"\",\"category?\"))","v":""},{"$f":"IF(AND(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),E51<=0.1),0,IF(AND(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),E51<=0.63),$AD$9*I51,IF(AND(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),E51>0.63),$AD$10*I51,IF(ISBLANK(C51),\"\",\"category?\"))))","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),P51+Q51+S51,IF(ISBLANK(C51),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),M51*$AD$17,\"\")","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),T51-S51-W51,\"\")","v":""},{"$f":"IF(OR(C51=\"W\",C51=\"R\",C51=\"G\",C51=\"L\",$C51=\"V\",$C51=\"B\",$C51=\"P\",$C51=\"C\"),$T51-$L51-$R51-$S51-$U51,IF(J51=\"below MRP\",J51,\"\"))","v":""},null,"Okay","0",null,null,{"$f":"IF($H51*(1+$AD$14+$AD$15)+IF($E51>0.63,$AD$10,IF(AND($E51>=0.1,$E51<0.63),$AD$9,0))<CEILING(VLOOKUP($E51*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E51*1000,MRP!$A$3:$C$43,1)*$E51*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H51*(1+$AD$14+$AD$15)+IF($E51>0.63,$AD$10,IF(AND($E51>=0.1,$E51<0.63),$AD$9,0))<CEILING(VLOOKUP($E51*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E51*1000,MRP!$A$3:$C$43,1)*$E51*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(C52),\"\",IF(ISNONTEXT(C52),\"\",IF(C52=\" \",\"-\",IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),E52*I52,\"?category\"))))","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),$Z52,IF(ISBLANK(C52),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),F52*K52,IF(ISBLANK(C52),\"\",\"category?\"))","v":""},{"$f":"IF(ISNONTEXT($J52),H52*F52,\"\")","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),M52*$AD$13,IF(ISBLANK(C52),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),$AD$12*($M52-$N52),IF(ISBLANK(C52),\"\",\"category?\"))","v":""},"",{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),($AD$14+$AD$15)*($P52),IF(ISBLANK(C52),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),($AD$14+$AD$15)*$L52,IF(ISBLANK(C52),\"\",\"category?\"))","v":""},{"$f":"IF(AND(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),E52<=0.1),0,IF(AND(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),E52<=0.63),$AD$9*I52,IF(AND(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),E52>0.63),$AD$10*I52,IF(ISBLANK(C52),\"\",\"category?\"))))","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),P52+Q52+S52,IF(ISBLANK(C52),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),M52*$AD$17,\"\")","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),T52-S52-W52,\"\")","v":""},{"$f":"IF(OR(C52=\"W\",C52=\"R\",C52=\"G\",C52=\"L\",$C52=\"V\",$C52=\"B\",$C52=\"P\",$C52=\"C\"),$T52-$L52-$R52-$S52-$U52,IF(J52=\"below MRP\",J52,\"\"))","v":""},null,"Okay","0",null,null,{"$f":"IF($H52*(1+$AD$14+$AD$15)+IF($E52>0.63,$AD$10,IF(AND($E52>=0.1,$E52<0.63),$AD$9,0))<CEILING(VLOOKUP($E52*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E52*1000,MRP!$A$3:$C$43,1)*$E52*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H52*(1+$AD$14+$AD$15)+IF($E52>0.63,$AD$10,IF(AND($E52>=0.1,$E52<0.63),$AD$9,0))<CEILING(VLOOKUP($E52*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E52*1000,MRP!$A$3:$C$43,1)*$E52*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(C53),\"\",IF(ISNONTEXT(C53),\"\",IF(C53=\" \",\"-\",IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),E53*I53,\"?category\"))))","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),$Z53,IF(ISBLANK(C53),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),F53*K53,IF(ISBLANK(C53),\"\",\"category?\"))","v":""},{"$f":"IF(ISNONTEXT($J53),H53*F53,\"\")","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),M53*$AD$13,IF(ISBLANK(C53),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),$AD$12*($M53-$N53),IF(ISBLANK(C53),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),M53-N53,IF(ISBLANK(C53),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),($AD$14+$AD$15)*($P53),IF(ISBLANK(C53),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),($AD$14+$AD$15)*$L53,IF(ISBLANK(C53),\"\",\"category?\"))","v":""},{"$f":"IF(AND(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),E53<=0.1),0,IF(AND(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),E53<=0.63),$AD$9*I53,IF(AND(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),E53>0.63),$AD$10*I53,IF(ISBLANK(C53),\"\",\"category?\"))))","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),P53+Q53+S53,IF(ISBLANK(C53),\"\",\"category?\"))","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),M53*$AD$17,\"\")","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),T53-S53-W53,\"\")","v":""},{"$f":"IF(OR(C53=\"W\",C53=\"R\",C53=\"G\",C53=\"L\",$C53=\"V\",$C53=\"B\",$C53=\"P\",$C53=\"C\"),$T53-$L53-$R53-$S53-$U53,IF(J53=\"below MRP\",J53,\"\"))","v":""},null,{"$f":"IFERROR(IF(C53=\"l\",AD53,IF(OR(C53=\"c\",C53=\"P\"),AE53,AC53)),\"Okay\")","v":"Okay"},{"$f":"IF(AND(ISNUMBER(H53),OR($C53=\"W\",$C53=\"R\",$C53=\"G\",$C53=\"L\",$C53=\"V\",$C53=\"B\")),(H53-($AD$6*$E53)-$AD$8)/(1+$AD$2),IF(AND(ISNUMBER(H53),$C53=\"P\"),(H53-($AD$6*$E53)-$AD$8)/(1+$AD$3),IF(AND(ISNUMBER(H53),$C53=\"c\"),(H53-$AD$7*$E53*$G53-$AD$8*$G53)/(1+$AD$5),\"0\")))","v":"0"},null,null,{"$f":"IF($H53*(1+$AD$14+$AD$15)+IF($E53>0.63,$AD$10,IF(AND($E53>=0.1,$E53<0.63),$AD$9,0))<CEILING(VLOOKUP($E53*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E53*1000,MRP!$A$3:$C$43,1)*$E53*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H53*(1+$AD$14+$AD$15)+IF($E53>0.63,$AD$10,IF(AND($E53>=0.1,$E53<0.63),$AD$9,0))<CEILING(VLOOKUP($E53*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E53*1000,MRP!$A$3:$C$43,1)*$E53*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]
[null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",null,"Okay","0",null,null,{"$f":"IF($H54*(1+$AD$14+$AD$15)+IF($E54>0.63,$AD$10,IF(AND($E54>=0.1,$E54<0.63),$AD$9,0))<CEILING(VLOOKUP($E54*1000,MRP!$A$3:$C$43,2)/VLOOKUP($E54*1000,MRP!$A$3:$C$43,1)*$E54*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},{"$f":"IF($H54*(1+$AD$14+$AD$15)+IF($E54>0.63,$AD$10,IF(AND($E54>=0.1,$E54<0.63),$AD$9,0))<CEILING(VLOOKUP($E54*1000,MRP!$A$3:$C$43,3)/VLOOKUP($E54*1000,MRP!$A$3:$C$43,1)*$E54*1000,0.05),\"Below MRP\",\"Okay\")","v":{"$error":"#N/A"}},"Okay"]

{"sheet":"LCB 2415","index":4,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,1,8,5],[8,18,8,19]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCB 2415"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'LCB 2414'!W3","v":"05-21"}]
["Distillery Duty Free Sales Report"]
[]
["Summary of Ontario spirit sales made to Duty Free Operators on behalf of the LCBO"]
[]
["Ontario Winery Name",{"$f":"IF(ISBLANK('LCB 2413'!B2:C2),\"\",'LCB 2413'!B2:C2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('LCB 2413'!$F$2),\"\",'LCB 2413'!$F$3)","v":""},{"$f":"IF(ISBLANK('LCB 2413'!$F$2),\"\",'LCB 2413'!$F$2)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REPORTING PERIOD"]
[null,{"$f":"'LCB 2413'!D2","v":0},null,"Note: Print form button must be used if entries exceed one page (row 44)."]
["Product Categories:"]
["Whisky = W, Rum = R, Gin = G, Vodka = V, Liqueur = L,"]
["Brandy = B, One Pour/Pre-Mix Cocktails = P, Coolers = C"]
[null,null,null,"Totals",null,null,{"$f":"J15","v":0},{"$f":"IF(SUM(H19:H52)<>0,SUM(H19:H52),0)","v":0},null,{"$f":"IF(SUM(J19:J52)<>0,SUM(J19:J52),0)","v":0},null,{"$f":"IF(SUM(L19:L52)<>0,ROUND(SUM(L19:L52),3),0)","v":0},null,null,{"$f":"IF(SUM(O19:O52)<>0,ROUND(SUM(O19:O52),2),0)","v":0},{"$f":"IF(SUM(P19:P52)<>0,SUM(P19:P52),0)","v":0},{"$f":"IF(SUM(Q19:Q52)<>0,ROUND(SUM(Q19:Q52),2),0)","v":0},{"$f":"IF(SUM(R19:R52)<>0,ROUND(SUM(R19:R52),2),0)","v":0},{"$f":"IF(SUM(S19:S52)<>0,ROUND(SUM(S19:S52),2),0)","v":0}]
["(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)",null,null,"(J)",null,null,"(K)","(L)","(M)","(N)","(O)"]
["Product Description","Product #","Product Category","Duty Free Operator (Req'd for 'Pearson')","Bottle Size (L)","Number of Bottles per Selling Unit","Selling Units per Case","Number of Cases Sold","Cost per Selling Unit","Total Bottles ","check NDRP","Total litres","Excise","Unit Costs","Cost of Goods Sold","LCBO  Mark-up","Total Collected","Unassigned","Total Remittance"]
[null," ",null,null,null,null,null,null,null,null,null,"(E*F*G*H)",null,null,"(F*G*H*I)",null,"(K+L)","($0.1567 per L)","(L-N)"]
[null,null,null,null,null,null,null,null,null,{"$f":"H19*G19*F19","v":0},{"$f":"IF(OR($C19=\"t\",$C19=\"s\",$C19=\"u\"),+#REF!,IF($C19=\"l\",+#REF!,IF($C19=\"f\",+#REF!,IF($C19=\"m\",+#REF!,IF(OR($C19=\"c\",$C19=\"d\"),+#REF!,\"-\")))))","v":"-"},{"$f":"IF(OR(C19=\"w\",C19=\"r\",C19=\"g\",C19=\"v\",C19=\"l\",C19=\"b\",C19=\"p\",C19=\"c\"),E19*F19*G19*H19,IF(ISBLANK(C19),\"\",IF(ISNONTEXT(C19),\"\",IF(C19=\" \",\"\",\"category?\"))))","v":""},null,null,{"$f":"IF(OR($C19=\"w\",$C19=\"r\",$C19=\"g\",$C19=\"v\",$C19=\"l\",$C19=\"b\",$C19=\"p\",$C19=\"c\"),I19*G19*H19,IF(ISBLANK(C19),\"\",\"category?\"))","v":""},{"$f":"IF(OR(AND(D19=\"Pearson\",OR($C19=\"w\",$C19=\"r\",$C19=\"g\",$C19=\"v\",$C19=\"l\",$C19=\"b\",$C19=\"p\")),AND(ISNUMBER(SEARCH(\"30%\",A19)),OR($C19=\"w\",$C19=\"r\",$C19=\"g\",$C19=\"v\",$C19=\"l\",$C19=\"b\",$C19=\"p\"))),O19*0.3,IF(OR($C19=\"w\",$C19=\"r\",$C19=\"g\",$C19=\"v\",$C19=\"l\",$C19=\"b\",$C19=\"p\"),O19*0.2,IF($C19=\"c\",O19*0.15,IF(ISBLANK(C19),\"\",\"category?\"))))","v":""},{"$f":"IF(OR(C19=\"c\",C19=\"d\"),O19+P19,IF(ISNONTEXT($P19),P19+O19,IF(ISBLANK(C19),\"\",\"category?\")))","v":""},{"$f":"IF(OR($C19=\"w\",$C19=\"r\",$C19=\"g\",$C19=\"v\",$C19=\"l\",$C19=\"b\",$C19=\"p\",$C19=\"c\"),L19*0.1567,IF(ISBLANK(C19),\"\",\"category?\"))","v":""},{"$f":"IF(OR($C19=\"w\",$C19=\"r\",$C19=\"g\",$C19=\"v\",$C19=\"l\",$C19=\"b\",$C19=\"p\",$C19=\"c\"),P19-R19,IF(ISBLANK(C19),\"\",\"category?\"))","v":""}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C20=\"t\",$C20=\"s\",$C20=\"u\"),+#REF!,IF($C20=\"l\",+#REF!,IF($C20=\"f\",+#REF!,IF($C20=\"m\",+#REF!,IF(OR($C20=\"c\",$C20=\"d\"),+#REF!,\"-\")))))","v":"-"},{"$f":"IF(OR(C20=\"w\",C20=\"r\",C20=\"g\",C20=\"v\",C20=\"l\",C20=\"b\",C20=\"p\",C20=\"c\"),E20*F20*G20*H20,IF(ISBLANK(C20),\"\",IF(ISNONTEXT(C20),\"\",IF(C20=\" \",\"\",\"category?\"))))","v":""},null,null,{"$f":"IF(OR($C20=\"w\",$C20=\"r\",$C20=\"g\",$C20=\"v\",$C20=\"l\",$C20=\"b\",$C20=\"p\",$C20=\"c\"),I20*G20*H20,IF(ISBLANK(C20),\"\",\"category?\"))","v":""},{"$f":"IF(OR(AND(D20=\"Pearson\",OR($C20=\"w\",$C20=\"r\",$C20=\"g\",$C20=\"v\",$C20=\"l\",$C20=\"b\",$C20=\"p\")),AND(ISNUMBER(SEARCH(\"30%\",A20)),OR($C20=\"w\",$C20=\"r\",$C20=\"g\",$C20=\"v\",$C20=\"l\",$C20=\"b\",$C20=\"p\"))),O20*0.3,IF(OR($C20=\"w\",$C20=\"r\",$C20=\"g\",$C20=\"v\",$C20=\"l\",$C20=\"b\",$C20=\"p\"),O20*0.2,IF($C20=\"c\",O20*0.15,IF(ISBLANK(C20),\"\",\"category?\"))))","v":""},{"$f":"IF(OR(C20=\"c\",C20=\"d\"),O20+P20,IF(ISNONTEXT($P20),P20+O20,IF(ISBLANK(C20),\"\",\"category?\")))","v":""},{"$f":"IF(OR($C20=\"w\",$C20=\"r\",$C20=\"g\",$C20=\"v\",$C20=\"l\",$C20=\"b\",$C20=\"p\",$C20=\"c\"),L20*0.1567,IF(ISBLANK(C20),\"\",\"category?\"))","v":""},{"$f":"IF(OR($C20=\"w\",$C20=\"r\",$C20=\"g\",$C20=\"v\",$C20=\"l\",$C20=\"b\",$C20=\"p\",$C20=\"c\"),P20-R20,IF(ISBLANK(C20),\"\",\"category?\"))","v":""}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C21=\"t\",$C21=\"s\",$C21=\"u\"),+#REF!,IF($C21=\"l\",+#REF!,IF($C21=\"f\",+#REF!,IF($C21=\"m\",+#REF!,IF(OR($C21=\"c\",$C21=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C22=\"t\",$C22=\"s\",$C22=\"u\"),+#REF!,IF($C22=\"l\",+#REF!,IF($C22=\"f\",+#REF!,IF($C22=\"m\",+#REF!,IF(OR($C22=\"c\",$C22=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C23=\"t\",$C23=\"s\",$C23=\"u\"),+#REF!,IF($C23=\"l\",+#REF!,IF($C23=\"f\",+#REF!,IF($C23=\"m\",+#REF!,IF(OR($C23=\"c\",$C23=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C24=\"t\",$C24=\"s\",$C24=\"u\"),+#REF!,IF($C24=\"l\",+#REF!,IF($C24=\"f\",+#REF!,IF($C24=\"m\",+#REF!,IF(OR($C24=\"c\",$C24=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C25=\"t\",$C25=\"s\",$C25=\"u\"),+#REF!,IF($C25=\"l\",+#REF!,IF($C25=\"f\",+#REF!,IF($C25=\"m\",+#REF!,IF(OR($C25=\"c\",$C25=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C26=\"t\",$C26=\"s\",$C26=\"u\"),+#REF!,IF($C26=\"l\",+#REF!,IF($C26=\"f\",+#REF!,IF($C26=\"m\",+#REF!,IF(OR($C26=\"c\",$C26=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C27=\"t\",$C27=\"s\",$C27=\"u\"),+#REF!,IF($C27=\"l\",+#REF!,IF($C27=\"f\",+#REF!,IF($C27=\"m\",+#REF!,IF(OR($C27=\"c\",$C27=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C28=\"t\",$C28=\"s\",$C28=\"u\"),+#REF!,IF($C28=\"l\",+#REF!,IF($C28=\"f\",+#REF!,IF($C28=\"m\",+#REF!,IF(OR($C28=\"c\",$C28=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C29=\"t\",$C29=\"s\",$C29=\"u\"),+#REF!,IF($C29=\"l\",+#REF!,IF($C29=\"f\",+#REF!,IF($C29=\"m\",+#REF!,IF(OR($C29=\"c\",$C29=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C30=\"t\",$C30=\"s\",$C30=\"u\"),+#REF!,IF($C30=\"l\",+#REF!,IF($C30=\"f\",+#REF!,IF($C30=\"m\",+#REF!,IF(OR($C30=\"c\",$C30=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C31=\"t\",$C31=\"s\",$C31=\"u\"),+#REF!,IF($C31=\"l\",+#REF!,IF($C31=\"f\",+#REF!,IF($C31=\"m\",+#REF!,IF(OR($C31=\"c\",$C31=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C32=\"t\",$C32=\"s\",$C32=\"u\"),+#REF!,IF($C32=\"l\",+#REF!,IF($C32=\"f\",+#REF!,IF($C32=\"m\",+#REF!,IF(OR($C32=\"c\",$C32=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C33=\"t\",$C33=\"s\",$C33=\"u\"),+#REF!,IF($C33=\"l\",+#REF!,IF($C33=\"f\",+#REF!,IF($C33=\"m\",+#REF!,IF(OR($C33=\"c\",$C33=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C34=\"t\",$C34=\"s\",$C34=\"u\"),+#REF!,IF($C34=\"l\",+#REF!,IF($C34=\"f\",+#REF!,IF($C34=\"m\",+#REF!,IF(OR($C34=\"c\",$C34=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C35=\"t\",$C35=\"s\",$C35=\"u\"),+#REF!,IF($C35=\"l\",+#REF!,IF($C35=\"f\",+#REF!,IF($C35=\"m\",+#REF!,IF(OR($C35=\"c\",$C35=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C36=\"t\",$C36=\"s\",$C36=\"u\"),+#REF!,IF($C36=\"l\",+#REF!,IF($C36=\"f\",+#REF!,IF($C36=\"m\",+#REF!,IF(OR($C36=\"c\",$C36=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C37=\"t\",$C37=\"s\",$C37=\"u\"),+#REF!,IF($C37=\"l\",+#REF!,IF($C37=\"f\",+#REF!,IF($C37=\"m\",+#REF!,IF(OR($C37=\"c\",$C37=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C38=\"t\",$C38=\"s\",$C38=\"u\"),+#REF!,IF($C38=\"l\",+#REF!,IF($C38=\"f\",+#REF!,IF($C38=\"m\",+#REF!,IF(OR($C38=\"c\",$C38=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C39=\"t\",$C39=\"s\",$C39=\"u\"),+#REF!,IF($C39=\"l\",+#REF!,IF($C39=\"f\",+#REF!,IF($C39=\"m\",+#REF!,IF(OR($C39=\"c\",$C39=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C40=\"t\",$C40=\"s\",$C40=\"u\"),+#REF!,IF($C40=\"l\",+#REF!,IF($C40=\"f\",+#REF!,IF($C40=\"m\",+#REF!,IF(OR($C40=\"c\",$C40=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C41=\"t\",$C41=\"s\",$C41=\"u\"),+#REF!,IF($C41=\"l\",+#REF!,IF($C41=\"f\",+#REF!,IF($C41=\"m\",+#REF!,IF(OR($C41=\"c\",$C41=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C42=\"t\",$C42=\"s\",$C42=\"u\"),+#REF!,IF($C42=\"l\",+#REF!,IF($C42=\"f\",+#REF!,IF($C42=\"m\",+#REF!,IF(OR($C42=\"c\",$C42=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C43=\"t\",$C43=\"s\",$C43=\"u\"),+#REF!,IF($C43=\"l\",+#REF!,IF($C43=\"f\",+#REF!,IF($C43=\"m\",+#REF!,IF(OR($C43=\"c\",$C43=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C44=\"t\",$C44=\"s\",$C44=\"u\"),+#REF!,IF($C44=\"l\",+#REF!,IF($C44=\"f\",+#REF!,IF($C44=\"m\",+#REF!,IF(OR($C44=\"c\",$C44=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C45=\"t\",$C45=\"s\",$C45=\"u\"),+#REF!,IF($C45=\"l\",+#REF!,IF($C45=\"f\",+#REF!,IF($C45=\"m\",+#REF!,IF(OR($C45=\"c\",$C45=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"H46*G46*F46","v":0},{"$f":"IF(OR($C46=\"t\",$C46=\"s\",$C46=\"u\"),+#REF!,IF($C46=\"l\",+#REF!,IF($C46=\"f\",+#REF!,IF($C46=\"m\",+#REF!,IF(OR($C46=\"c\",$C46=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C47=\"t\",$C47=\"s\",$C47=\"u\"),+#REF!,IF($C47=\"l\",+#REF!,IF($C47=\"f\",+#REF!,IF($C47=\"m\",+#REF!,IF(OR($C47=\"c\",$C47=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C48=\"t\",$C48=\"s\",$C48=\"u\"),+#REF!,IF($C48=\"l\",+#REF!,IF($C48=\"f\",+#REF!,IF($C48=\"m\",+#REF!,IF(OR($C48=\"c\",$C48=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C49=\"t\",$C49=\"s\",$C49=\"u\"),+#REF!,IF($C49=\"l\",+#REF!,IF($C49=\"f\",+#REF!,IF($C49=\"m\",+#REF!,IF(OR($C49=\"c\",$C49=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C50=\"t\",$C50=\"s\",$C50=\"u\"),+#REF!,IF($C50=\"l\",+#REF!,IF($C50=\"f\",+#REF!,IF($C50=\"m\",+#REF!,IF(OR($C50=\"c\",$C50=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C51=\"t\",$C51=\"s\",$C51=\"u\"),+#REF!,IF($C51=\"l\",+#REF!,IF($C51=\"f\",+#REF!,IF($C51=\"m\",+#REF!,IF(OR($C51=\"c\",$C51=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($C52=\"t\",$C52=\"s\",$C52=\"u\"),+#REF!,IF($C52=\"l\",+#REF!,IF($C52=\"f\",+#REF!,IF($C52=\"m\",+#REF!,IF(OR($C52=\"c\",$C52=\"d\"),+#REF!,\"-\")))))","v":"-"},"",null,null,"","","","",""]

{"sheet":"Remittance Summary","index":5,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Remittance Summary"]
[]
[]
[{"$f":"IF(ISBLANK('LCB 2413'!B2),\"\",'LCB 2413'!B2)","v":""},null,{"$f":"IF(ISBLANK('LCB 2413'!F2),\"\",'LCB 2413'!F2)","v":""}]
["Distillery Name",null,{"$f":"IF(ISBLANK('LCB 2413'!$F$2),\"REPORTING PERIOD\",'LCB 2413'!$F$3)","v":"REPORTING PERIOD"}]
[]
["LCBO Remittances:",null,"$ Amount"]
["Direct Delivery Sales Report (LCB 2414)",null,{"$f":"'LCB 2414'!W14","v":0}]
["Duty Free Sales Report (LCB 2415)",null,{"$f":"'LCB 2415'!S15","v":0}]
["Container Deposit Statement (LCB 2413)",null,{"$f":"'LCB 2413'!F29","v":0}]
["Total LCBO Payment",null,{"$f":"SUM(C8:C10)","v":0}]
[]
["HST on Direct Delivery to Licensee Sales:",null,"$ Amount"]
["HST on LCBO's Sales administered by Distillery (LCB 2414)",null,{"$f":"'LCB 2414'!$Q$14","v":0}]
["HST Collected on Distillery's Deemed Wholesale Sale to LCBO (LCB 2414)",null,{"$f":"'LCB 2414'!$R$14","v":0}]
["Total HST Remittance (included within Total LCBO Payment above)",null,{"$f":"C14-C15","v":0}]
[]
[]
["MAILING ADDRESS & CONTACT INFORMATION:"]
[]
["NOTE: Hardcopies of report are NOT to be submitted along with payment or at all"]
["ONLY electronic copies should be submitted to distilleryreporting@lcbo.com"]
[]
["LCBO (New Address effective Nov. 1, 2021)"]
["LCBO Financial Services, Dept. 0884"]
["100 Queens Quay East, 9th floor"]
["Toronto, ON M5E 0C7"]
[]
["Contact: accounts.receivables@lcbo.com"]

{"sheet":"Calculator","index":6,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,3,1]]}
[]
["Whisky, Rum, Gin, Vodka, Brandy = Blank; Liqueur = L ; Cooler = C; One Pour/Pre-Mix Cocktails = P",null,null,null,null,null,null,null,null,"Pricing Components","Rate","Metric"]
[null,null,null,null,null,null,null,null,null,"Whisky, Rum, Gin, Vodka, Liqueurs, Brandy",1.397,"ad valorem"]
[null,null,null,null,null,null,null,null,null,"One Pour / Pre-Mixed Cocktails",0.96699999999999997,"ad valorem"]
["Bottle Size (L)",0.75,null,null,null,null,null,null,null,"Spirit Coolers",0.68500000000000005,"ad valorem"]
["Alcohol Content %",0.4,null,null,null,null,null,null,null,"Pearson Duty Free Spirits (Excluding coolers)",0.3,"ad valorem"]
["Bottles per Selling Unit",1,null,null,null,null,null,null,null,"Non-Pearson Duty Free Spirits (Excluding coolers)",0.2,"ad valorem"]
["Retail selling price (including deposit)",28.2,null,null,null,null,null,null,null,"Duty Free Spirit Coolers",0.15,"ad valorem"]
["Minimum Retail Price Check",{"$f":"IF(AND(B2=\"L\",$B$13<CEILING(VLOOKUP(B5*1000,MRP!$A$3:$C$43,3)/VLOOKUP(B5*1000,MRP!$A$3:$C$43,1)*B5*1000,0.05)),\"Below MRP\",IF(AND(ISBLANK(B2),B13<CEILING(VLOOKUP(B5*1000,MRP!$A$3:$C$43,2)/VLOOKUP(B5*1000,MRP!$A$3:$C$43,1)*B5*1000,0.05)),\"Below MRP\",IF(OR(B2=\"c\",B2=\"p\"),D9,\"Okay\")))","v":"Below MRP"},null,{"$f":"IF(AND(OR($B$2=\"c\",$B$2=\"p\"),$B$6<4.1%,D13-D14<CEILING($K$21*$B$5*$B$7+$B$7*$K$12*(1+$K$18+$K$19+$K$20),0.05)),\"Below MRP\",IF(AND(OR($B$2=\"c\",$B$2=\"p\"),$B$6>=4.1%,$B$6<4.9%,D13-D14<CEILING($K$22*$B$5*$B$7+$B$7*$K$12*(1+$K$18+$K$19+$K$20),0.05)),\"Below MRP\",IF(AND(OR($B$2=\"c\",$B$2=\"p\"),$B$6>=4.9%,$B$6<5.6%,D13-D14<CEILING($K$23*$B$5*$B$7+$B$7*$K$12*(1+$K$18+$K$19+$K$20),0.05)),\"Below MRP\",IF(AND(OR($B$2=\"c\",$B$2=\"p\"),$B$6>=5.6%,D13-D14<CEILING($K$24*$B$5*$B$6*$B$7+$B$7*$K$12*(1+$K$18+$K$19+$K$20),0.05)),\"Below MRP\",\"Okay\"))))","v":"Okay"},null,null,null,null,null,"Spirits Basic Tax",0.61499999999999999,"ad valorem"]
["Duty Free Operator","Non-Pearson",null,null,null,null,null,null,null,"Volume Levy",0.38,"per litre"]
[{"$f":"IF(Overview!$A$4=\"y\",1,0)","v":0},"LCBO",null,"Distillery Retail Store (DRS)",null,"Direct Delivery to Licensee",null,"Direct Delivery to Duty Free",null,"Cooler Volume Levy",0.28000000000000003,"per litre"]
[null,null,null,null,null,null,null,null,null,"Environmental Fee",8.9300000000000004E-2,"per container"]
["Selling Price",{"$f":"B8","v":28.2},null,{"$f":"B13","v":28.2},null,{"$f":"F16+F15+F14","v":25.399999999999995},null,{"$f":"H16+H15+H14","v":7.5223824089846865},null,"Container Deposit >100 mL and <=630 mL",0.1,"per container"]
["Container Deposit",{"$f":"IF(AND(B5>=18,OR(B2=\"c\",B2=\"d\")),0,IF(B5<=0.1,0,IF(B5>0.63,$B$7*$K$14,$B$7*$K$13)))","v":0.2},null,{"$f":"B14","v":0.2},null,{"$f":"B14","v":0.2},null,0,null,"Container Deposit >630 mL",0.2,"per container"]
["H.S.T.",{"$f":"(B$13-B14)/(1+$K$18+$K$19)*($K$18+$K$19)","v":3.221238938053097},null,{"$f":"ROUND(B15,2)","v":3.22},null,{"$f":"F16*($K$18+$K$19)","v":2.8991150442477873},null,0,null,"Direct Delivery Rebate",0.2,"ad valorem"]
["Net Licensee Price",null,null,null,null,{"$f":"F19-F18","v":22.30088495575221},null,{"$f":"H19-H18","v":7.5223824089846865},null,"Licensee Markup",0,"ad valorem"]
[null,null,null," ",null,null,null,null,null,"Licensee Discount",0.1,"ad valorem"]
["10% Discount",null,null,null,null,{"$f":"F19*$K$17","v":2.4778761061946906},null,0,null,"HST (GST Portion)",0.05,"ad valorem"]
["Basic Price",{"$f":"B13-B15-B14","v":24.778761061946902},null,{"$f":"D13-D15-D14","v":24.78},null,{"$f":"SUM(F20:F23)","v":24.778761061946902},null,{"$f":"SUM(H20:H23)","v":7.5223824089846865},null,"HST (PST Portion)",0.08,"ad valorem"]
["Environmental Fee/Tax",{"$f":"$B$7*$K$12","v":8.9300000000000004E-2},null,{"$f":"B20","v":8.9300000000000004E-2},null,{"$f":"B20","v":8.9300000000000004E-2},null,0,null,"Non-Refillable Charge",0.04,"ad valorem"]
["Volume Levy/Tax",{"$f":"IF($B$2=\"c\",$B$5*$B$7*$K$11,$B$5*$B$7*$K$10)","v":0.28500000000000003},null,{"$f":"B21","v":0.28500000000000003},null,{"$f":"B21","v":0.28500000000000003},null,0,null,"Cooler MRP (<4.1% alcohol by volume)",{"$f":"LEFT(MRP!F3,6)*1","v":3.7789999999999999},"per litre"]
["LCBO Mark-up/Spirits Basic Tax",{"$f":"IF(B2=\"c\",(B19-SUM(B20:B21))/(1+$K$5)*K5,IF(B2=\"P\",(B19-SUM(B20:B21))/(1+$K$4)*$K$4,(B19-SUM(B20:B21))/(1+$K$3)*$K$3))","v":14.223209054459664},null,{"$f":"(D19-SUM(D20:D21))/(1+K9)*K9","v":9.2938114551083579},null,{"$f":"B22","v":14.223209054459664},null,{"$f":"IF($B$2=\"C\",H23*$K$9,IF(AND($B$2<>\"C\",$B$10=\"Non-Pearson\"),H23*$K$7,IF(AND($B$2<>\"C\",$B$10=\"Pearson\"),H23*$K$6,0)))","v":1.2537304014974477},null,"Cooler MRP (4.1% & <4.9% alcohol by volume)",{"$f":"LEFT(MRP!F4,6)*1","v":3.8340000000000001},"per litre"]
["Total Landed Cost",{"$f":"B19-SUM(B20:B22)","v":10.181252007487238},null,{"$f":"D19-SUM(D20:D22)","v":15.111888544891643},null,{"$f":"SUM(F24:F25)","v":10.181252007487238},null,{"$f":"SUM(H24:H25)","v":6.2686520074872387},null,"Cooler MRP (4.9% & <5.6% alcohol by volume)",{"$f":"LEFT(MRP!F5,6)*1","v":3.9350000000000001},"per litre"]
["Federal Excise Tax ",{"$f":"IF(B2=\"C\",ROUND(B5*B7*K25,4),ROUND(B5*B6*B7*K26,4))","v":3.9125999999999999},null,{"$f":"B24","v":3.9125999999999999},null,{"$f":"D24","v":3.9125999999999999},null,null,null,"Cooler MRP (5.6% -7% litres of absolute alcohol)",{"$f":"LEFT(MRP!F6,7)*1","v":73.064999999999998},"per litre"]
["Supplier Quote",{"$f":"B23-B24","v":6.2686520074872387},null,{"$f":"D23-D24","v":11.199288544891644},null,{"$f":"B25","v":6.2686520074872387},null,{"$f":"B25","v":6.2686520074872387},null,"Cooler Excise",0.33,"per litre"]
[null,null,null,null,null,null,null,null,null,"Excise",13.042,"per LAA"]
["Revenue Distribution $1","LCBO",null,"DRS",null,"Direct Delivery to Licensee",null,"Direct Delivery to Duty Free"]
["Distillery2",{"$f":"B25","v":6.2686520074872387},null,{"$f":"D25","v":11.199288544891644},null,{"$f":"F25+F19*$K$15","v":11.22440421987662},null,{"$f":"H25","v":6.2686520074872387}]
["Provincial3",{"$f":"$K$19*B19+B20+B21+B22","v":16.579809939415416},null,{"$f":"K19*D19+D20+D21+$D$22","v":11.650511455108358},null,{"$f":"$K$19*F16+F20+F21+F22-F18-F19*K15","v":8.9479515323357699},null,{"$f":"H22","v":1.2537304014974477}]
["Federal3",{"$f":"$K$18*B19+B24","v":5.1515380530973456},null,{"$f":"$K$18*D19+D24","v":5.1516000000000002},null,{"$f":"F16*$K$18+F24","v":5.0276442477876104}]
["Container Deposit",{"$f":"B14","v":0.2},null,{"$f":"D14","v":0.2},null,{"$f":"F14","v":0.2},null,{"$f":"H14","v":0}]
["Total",{"$f":"SUM(B28:B31)","v":28.2},null,{"$f":"SUM(D28:D31)","v":28.201400000000003},null,{"$f":"SUM(F28:F31)","v":25.4},null,{"$f":"SUM(H28:H31)","v":7.5223824089846865}]
[]
["Revenue Distribution %1","LCBO",null,"DRS",null,"Direct Delivery to Licensee",null,"Direct Delivery to Duty Free"]
["Distillery2",{"$f":"B28/B$32","v":0.22229262437898009},null,{"$f":"D28/D$32","v":0.39711817657604381},null,{"$f":"F28/F$32","v":0.44190567794789842},null,{"$f":"H28/H$32","v":0.83333333333333337}]
["Provincial3",{"$f":"B29/B$32","v":0.58793652267430552},null,{"$f":"D29/D$32","v":0.41311819466793692},null,{"$f":"F29/F$32","v":0.35228155639117209},null,{"$f":"H29/H$32","v":0.16666666666666666}]
["Federal3",{"$f":"B30/B$32","v":0.1826786543651541},null,{"$f":"D30/D$32","v":0.18267178225194491},null,{"$f":"F30/F$32","v":0.19793874991289806},null,{"$f":"H30/H$32","v":0}]
["Container Deposit",{"$f":"B31/B$32","v":7.0921985815602844E-3},null,{"$f":"D31/D$32","v":7.0918465040742656E-3},null,{"$f":"F31/F$32","v":7.8740157480314977E-3},null,{"$f":"H31/H$32","v":0}]
[]
["Notes:"]
["1.  % distribution may not add to 100% due to rounding."]
["2.  For Direct Delivery, there is a rebate amount paid to the distillery, which is calculated at 20% of the basic price and is deducted from the remittance to the LCBO."]
["3.  HST has been separated into GST(5%) and ORST (8%)."]
["4. LCBO Mark-up, volume levy and environmental fee are not applicable to DRS sales but equivalent taxes are payable to the Ministry of Finance on DRS sales. The spirits basic tax rate is 61.5%."]

{"sheet":"Distillery","index":7,"n_rows":161,"n_cols":2,"rows_kept":161,"cut":false,"hidden":true,"merged":[]}
[{"$f":"TEXT('LCB 2413'!F2,\"mmmyy\")","v":"Jan00"},{"$f":"VLOOKUP('LCB 2413'!B2,Distillery!$A$3:$B$161,2,FALSE)","v":{"$error":"#N/A"}}]
["Distillery","Filename"]
["1000 Islands Distillery Inc.","1000Islands"]
["361 Degrees Inc.","361Degrees"]
["786 Country Squire Distillery","786Country"]
["Ace Beverage Group Inc.","Ace"]
["ACEONE SPIRITS INC.","AceoneSpirits"]
["Alo Food Group","AloFood"]
["Aro Beverage Company","AroBeverage"]
["Artist in Residence","ArtistinRes"]
["Aware Beverages","Aware"]
["BACARDI CANADA INC.","BacardiCanada"]
["BARCHEF Project","Barchef"]
["Barnstormer Brewing Co.","Barnstormer"]
["Bayfield Berry Farm","Bayfield"]
["Beattie's Distillery Inc.","Beatties"]
["Big Rig","BigRig"]
["Birdie Juice Beverages","BirdieJuice"]
["BLACK FLY BEVERAGE COMPANY INC.","BlackFly"]
["Black's Distillery Inc.","Blacks"]
["Bondi Seltzer Ltd.","BondiSeltzer"]
["Bootlegger Distillery Inc.","Bootlegger"]
["Boréal Spirit Co.","BorealSpirits"]
["Brock Street Distilling Company Ltd.","Brock"]
["Brutus Beverages Inc","Brutus"]
["CANADA DRY MOTT'S INC.","CanadaDry"]
["CANADIAN PREMIUM BEVERAGES","CanadianPremium"]
["CHILL INDIA Inc.","ChillIndia"]
["Cicchetto Ltd.","Cicchetto"]
["Clawfoot Stills","Clawfoot"]
["COLLECTIVE ARTS BREWING LIMITED","CollectiveArts"]
["Collingwood Distillery","Collingwood"]
["Copperhead Distillery and Spirits","Copperhead"]
["CORBY SPIRIT AND WINE LIMITED","CorbySpirit"]
["Cowbell Brewing Co.","CowbellBrewing"]
["Craft Papi Inc.","CraftPapi"]
["Crosscut Distillery Ltd.","Crosscut"]
["Denna Lake Spirits","DennaLake"]
["DIAGEO CANADA INC.","DiageoCanada"]
["Dillon's Small Batch Distillers","Dillons"]
["Dixon's Distilled Spirits","Dixons"]
["Do Good Spirits Inc.","DoGood"]
["Dugal & Sons Distillery Co.","Dugal"]
["Dunrobin Distilleries Ltd.","Dunrobin"]
["Durham Distillery Ltd","Durham"]
["Elements Distillery","ElementsDistillery"]
["Elora Distilling Company","Elora"]
["Felix Distillery","FelixDistillery"]
["Fieldbird Cider","Fieldbird"]
["FLYING MONKEYS CRAFT BREWERY","FlyingMonkeys"]
["Forty Creek Distillery","Forty"]
["Founder's Original","Founders"]
["Foundry Pub Inc. O/A Copper Rose Distillery","Foundry"]
["Freshwater Distillery","Freshwater"]
["G&G Spirits Inc.","G&GSpirits"]
["GEORGIAN BAY SPIRIT CO.","GeorgianBay"]
["Giggling Ram","GigglingRam"]
["Good Sunday","GoodSunday"]
["Great Lakes Brewery","GreatLakes"]
["Green Owl Distribution","GreenOwl"]
["H2 Craft Spirits Inc.","H2"]
["Heretic Spirits","Heretic"]
["High Spirits Inc.","High"]
["HIP Beverage Corp","HIPBeverage"]
["Hiram Walker & Sons","Hiram"]
["J Dass Distillery","JDass"]
["J.P. WISER DISTILLERY LIMITED","JPWiser"]
["Jaan Inc","Jaan"]
["Joshua Beach Whiskey Ltd.","JoshuaBeach"]
["Junction 56 Distillery Ltd.","Junction"]
["Junction Craft Brewery","JunctionCraft"]
["Karbon Brewing Corp.","Karbon"]
["Kim's Winery and Distillery Inc.","Kims"]
["King's Lock Craft Distillery Inc.","Kings"]
["Kinsip House of Fine Spirits","Kinsip"]
["Labrador Spirits Ltd.","LabradorSpirits"]
["Laneway Distillers","Laneway"]
["Last Straw Distillery","Last"]
["LaunchPad Branz Inc.","LaunchPad"]
["Legend Spirits Company","LegendSpirits"]
["Levenswater Incorporated","Levenswater"]
["Limited Distilling Corp.","Limited"]
["Little Buddha Cocktail Company Inc.","LittleBuddha"]
["Lost Craft Inc.","Lost"]
["Lower Valley Beverage Company Ltd.","Lower"]
["Lusty Libation","LustyLibation"]
["Magnotta Distillery","Magnotta"]
["Manns Distillery Ltd.","Manns"]
["Maple Ridge Farm","MapleRidge"]
["MAVERICK DISTILLERY LIMITED","MaverickDistillery"]
["Mill Street Brewery","Mill"]
["Molson Canada 2005","Molson2005"]
["Moon Spirits","Moon"]
["Murphy's Law Distillery Ltd.","Murphys"]
["Muskoka Brewery","Muskoka"]
["MVP Brewing Company Ltd","MVPBrewing"]
["NB Distillers","NBDistillers"]
["NE1 Spirits Ltd.","NE1"]
["New Ontario Brewing and Distilling","NewOntario"]
["NIAGARA COLLEGE LEARNING ENTERPRISE CORPORATION","NiagaraCollege"]
["Niagara Distillery","NiagaraDistillery"]
["Niagara Falls Craft Distillers","Niagara"]
["Nickel 9 Distillery Inc.","Nickel"]
["North of 7 Distillery Corporation","North"]
["North Spirit Distillery Inc.","NorthSpirit"]
["Nude Vodka Soda","NudeVodka"]
["OG Distillery","OGDistillery"]
["Ogham Craft Spirits Inc.","Ogham"]
["O'Kenny Craft Spirits","OKenny"]
["Old Son's Distillery Inc.","OldSons"]
["Organic Beverage Solutions","OrganicBev"]
["Paradigm Spirits Company","ParadigmSpirits"]
["Pepprell Distilling Co.","Pepprell"]
["Persian Empire Distillery","Persian"]
["Polonee Distillery","Polonee"]
["Profile Wine Group ","Profile"]
["Pure Spirits","PureSpirits"]
["Reid's Distillery","Reids"]
["Rheault Distilleries","Rheault"]
["RTD CANADA INC.","RTDCanada"]
["Signal Hill Spirits Inc.","SignalHill"]
["Silver Fox Distillery","SilverFox"]
["Sleeman Breweries Ltd. ","Sleeman"]
["Solato Toronto Boutique Inc.","SolatoToronto"]
["Sonic International Corp.","Sonic"]
["Spirit in Niagara","SpiritinNiagara"]
["Spirit of York Distillery Inc.","SpiritofYork"]
["Spring Mill Distillery","Spring"]
["Spy Cider House and Distillery","Spy"]
["Still Waters Distillery","Still"]
["Stone Distillery","StoneDistillery"]
["Storyteller Beverages Inc.","Storyteller"]
["Strati Spirits","StratiSpirits"]
["SUMMER SELTZERS","SummerSeltzers"]
["Tawse Winery Inc.","Tawse"]
["TEQS LIMITED","TEQS"]
["The Barrel Hunter Corporation","Barrel"]
["The Crawler Beverage Company Ltd.","Crawler"]
["The Dairy Distillery","Dairy"]
["The White Distillery","TheWhiteDistillery"]
["Tiny Distillery","TinyDistillery"]
["Top Shelf Distillery","Top"]
["Toronto Distillery Group Inc","TorontoDistillery"]
["Tri Borea Inc.","TriBorea"]
["True Theory Spirits","TrueTheory"]
["Twenty Bench Brewing Company Inc.","Twenty"]
["Umbrel Beverage Co. Inc.","Umbrel"]
["Union Ten Distilling Company","UnionTen"]
["United Craft Inc.","United"]
["Vibe Hard Kombucha Inc.","VibeHardKombucha"]
["Vieni Estates Inc.","Vieni"]
["Vodka Friday Inc.","VodkaFriday"]
["Vodz Beverages","VodzBeverages"]
["WATERLOO BREWING COMPANY","WaterlooBrewing"]
["Wayne Gretzky Winery and Distillery","Wayne"]
["Wellington Brewery","WellingtonBrewery"]
["Whitewater Brewing Company Ltd. ","Whitewater"]
["Willibald Farm Distillery Limited","Willibald"]
["Wolfhead Distillery","Wolfhead"]
["Xing Hua Cun Spirits Ltd.","XingHua"]
["Yongehurst Distillery Company","Yongehurst"]

{"sheet":"MRP","index":8,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[5,4,6,4],[5,5,6,5]]}
["Minimum Retail Price for Class A & Class B Spirits",null,null,null,"Baseline Rates for Low Alcohol Spirits & Coolers"]
["Container size (mL)","Class A","Class B",null,"Low Alcohol Spirits & Coolers","Baseline Rates"]
[40,2.7,1.75,null,"Less than 4.1%","$3.779 per litre"]
[50,3.4000000000000004,2,null,"4.1 to less than 4.9%","$3.834 per litre"]
[60,4.25,2.3000000000000003,null,"4.9 to less than 5.6%","$3.935 per litre"]
[100,4.7,2.85,null,"5.6% up to and including 7%","$73.065 per litre of absolute alcohol as defined in Division 2 of the Food and Drug Regulations"]
[120,5.5,3.8000000000000003]
[150,6.9,4.6499999999999995,null,"Notes:"]
[180,8.1999999999999993,5.35,null,"The minimum retail price for spirits (5.6% or more) and coolers (5.6% up to and including 7%)"]
[200,9.1,5.9,null," is the baseline rate per litre, plus container deposit, plus the environmental levy ($0.0893)"]
[250,10.8,7,null,"per non-refillable container, plus an amount equal to the HST (13%) and 4% of the"]
[280,12.200000000000001,7.7,null,"  of the environmental levy."]
[300,13,8.35]
[350,15.1,9.65]
[360,15.5,10.050000000000001]
[375,16.100000000000001,10.25]
[400,17.150000000000002,10.85]
[500,19.500000000000004,13.200000000000001]
[600,23.300000000000004,15.75]
[650,25.05,17.149999999999999]
[660,25.85,17.649999999999999]
[700,27.150000000000002,18.350000000000001]
[720,27.8,18.75]
[730,28.2,19.3]
[750,28.75,19.650000000000002]
[800,30.650000000000002,20.8]
[1000,38.1,26.1]
[1050,39.850000000000009,27.45]
[1125,42.7,29.3]
[1130,42.95,29.55]
[1140,43.250000000000007,29.75]
[1200,45.550000000000004,31.2]
[1280,48.550000000000004,33.300000000000004]
[1400,53.100000000000009,36.35]
[1500,56.500000000000007,38.650000000000006]
[1750,64.600000000000009,44.800000000000004]
[2000,73.850000000000009,51.100000000000009]
[2600,95.9,66.350000000000009]
[3000,110.80000000000001,76.600000000000009]
[3790,139.6,96.500000000000014]
[3850,141.9,98.100000000000009]
[4000,147,101.60000000000001]
[4500,165.65,114.45]
[]
["Notes:"]
["Minimum retail prices (MRP) and baseline rates are effective March 1, 2022."]
["Minimum retail prices are inclusive of container deposit."]