{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Fee Calc","bulk CREAM","bulk Condensed SKIM","bulk Condensed MILK"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":3,"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":"Fee Calc","index":0,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,4,63,8],[63,10,63,11],[30,3,30,7],[32,3,32,7],[1,1,1,13],[2,1,2,13],[3,1,3,13],[26,3,26,7],[6,12,6,13],[7,11,7,13],[6,10,6,11],[6,7,6,9]]}
[null,"PMMB-62 MLFC (rev. 08/16)",null,null,null,null,null,null,null,null,null,null,null,"Due the 25th of each month"]
[null,"Pennsylvania Milk Marketing Board"]
[null,"Monthly License Fee Calculation"]
[null," for newly licensed dealers"]
[]
[]
[null,null,"Dealer License #: ",null,null,null,"Dealer Name: ",null,null,null,"Month/Year: "]
[null,null,null,null,null,null,null,null,null,null,null,"for which fee is being calculated"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PMMB-62"]
[null,"LINE NO.","SOURCE",null,null,null,null,null,null,"POUNDS",null,"RATE","FEE"]
[null,null,null,null,null,null,null,null,null,null,null,"per POUND"]
[null,"1.","Part 1","Total Producer milk  (do not include Own Farm milk)"]
[]
[null,"2.","Part 2","Total receipts from Non-PA dealers  (include Bulk Cream and Bulk Condensed purchases)"]
[]
[null,"If purchased BULK CREAM, BULK CONDENSED MILK or BULK CONDENSED SKIM then complete Line Nos. 2a thru 2c.  Otherwise skip to Line No. 3."]
[]
[null,null,"2a.","Bulk CREAM included in Line 2 above.",null,null,null,null,null,3000,"Product lbs."]
[null,null,null,"(convert to Fluid Milk Equivalent pounds by dividing 'BF lbs.' by .035.)",null,null,null,null,null,1000,"BF lbs."]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J27/0.035,0)","v":28571},"equiv. lbs."]
[]
[null,null,"2b.","Bulk CONDENSED MILK included in Line 2 above.",null,null,null,null,null,{"$f":"ROUND(L30/0.035,0)","v":28571},1000,1000]
[null,null,null,"(convert to Fluid Milk Equivalent pounds by dividing 'BF lbs.' by .035.)",null,null,null,null,null,"equiv. lbs.","Product lbs.","BF lbs."]
[null,null,"2b.","Bulk SKIM CONDENSED MILK included in Line 2 above.",null,null,null,null,null,{"$f":"ROUND(L32/0.0875,0)","v":11429},1000,1000]
[null,null,null,"(convert to Fluid Milk Equivalent pounds by dividing 'NFMS lbs.' by .0875.)",null,null,null,null,null,"equiv. lbs.","Product lbs.","NFMS lbs."]
[null,null,null,"Note: Line No. 3 is applicable only if Bulk Cream and/or Bulk Condensed Milk/Skim were purchased from Non-PA dealer(s)."]
[null,null,null,"  *  If NOT applicable, then skip down to Line No. 4."]
[null,null,null,"  *  If applicable, then complete supplementary 'Bulk' worksheet(s) and enter result(s) on Line No. 3.  Worksheets can be printed from our website (www.mmb.pa.gov)."]
[null,"3.","Part 2","Net Effect of Bulk purchases from Non-PA dealers",null,null,null,null,null,{"$f":"'bulk CREAM'!J32+'bulk Condensed MILK'!I32+'bulk Condensed SKIM'!F32","v":0}]
[]
[]
[null,"4.","Part 2","Receipts from Juggers (License # 8888800)"]
[]
[null,"5.",null,"Total Receipts  (Line 1 + Line 2 + Line 3 + Line 4)",null,null,null,null,null,{"$f":"IF(J20+J22+J37+J40=0,\"\",J20+J22+J37+J40)","v":""}]
[]
[null,"6.","Part 5","Diversions from Non-PA producers to Non-PA dealers"]
[]
[null,"7.",null,"Basis for Calculation  (Line 5 - Line 6)",null,null,null,null,null,{"$f":"IF(J42=\"\",\"\",J42-J44)","v":""}]
[]
[null,"8.","Part 3","Controlled  PA Milk Sales  (Areas 1-0, 2-0, 3-0, 4-0, 5-0 & 6-0; REGULATED)",null,null,null,null,null,null,"X",{"$f":"0.045/100","v":4.4999999999999999E-4},{"$f":"IF(J48=\"\",\"\",ROUND(J48*L48,2))","v":""}]
[]
[null,"9.",null,"Non-Controlled milk sales  (Line 7 - Line 8)      ",null,null,null,null,"if result is negative, then round up to 0.",{"$f":"IF(J46=\"\",\"\",IF(J46-J48<0,\"\",J46-J48))","v":""},"X",{"$f":"0.0057/100","v":5.7000000000000003E-5},{"$f":"IF(J50=\"\",\"\",ROUND(J50*L50,2))","v":""}]
[]
[null,"10.",null,"Total License Fee  (Line 8 + Line 9)",null,null,null,null,null,null,null,null,{"$f":"IF(M48=\"\",IF(M50=\"\",\"\",M50),IF(M50=\"\",M48,M48+M50))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Completed by: ",null,null,null,null,null,"Date: "]

{"sheet":"bulk CREAM","index":1,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[11,4,11,5],[0,2,0,5],[1,2,1,4],[2,2,2,4]]}
["Dealer Name:",null,{"$f":"'Fee Calc'!H7","v":0}]
["Dealer License No.:",null,{"$f":"'Fee Calc'!D7","v":0}]
["Month/Year:",null,{"$f":"'Fee Calc'!M7","v":"00:00:00"}]
["Monthly License Fee Calculation worksheet"]
["Bulk CREAM purchases from non-PA dealers (PMMB-62; Part 2)"]
["Conversion to whole milk equivalents"]
[]
[]
[null,null,"(A)",null,"(B)","(C)",null,"(D)",null,"(E)"]
[]
[null,null,null,null,null,"(A) x (B)",null,null,null,"(C) ÷ (D)"]
[null,"PRODUCT","PRODUCT",null,"Butter fat ",null,null,"Conversion",null,"Whole Milk "]
[null,"Code","Pounds",null,"Percent","Pounds",null,"Factor",null,"Equivalents"]
[1,"210X",null,null,null,{"$f":"ROUND(C14*E14,0)","v":0},null,3.5000000000000003E-2,null,{"$f":"+ROUND(F14/H14,0)","v":0}]
[2,null,null,null,null,{"$f":"ROUND(C15*E15,0)","v":0},null,3.5000000000000003E-2,null,{"$f":"+ROUND(F15/H15,0)","v":0}]
[3,null,null,null,null,0,null,3.5000000000000003E-2,null,0]
[4,null,null,null,null,0,null,3.5000000000000003E-2,null,0]
[5,null,null,null,null,0,null,3.5000000000000003E-2,null,0]
[6,null,null,null,null,0,null,3.5000000000000003E-2,null,0]
[7,null,null,null,null,0,null,3.5000000000000003E-2,null,0]
[8,null,null,null,null,0,null,3.5000000000000003E-2,null,0]
[9,null,null,null,null,0,null,3.5000000000000003E-2,null,0]
[10,null,null,null,null,0,null,3.5000000000000003E-2,null,0]
[]
[null,null,"(F)",null,null,null,null,null,null,"(G)"]
[]
["TOTALs",null,{"$f":"SUM(C14:C23)","v":0},null,null,null,null,null,null,{"$f":"SUM(J14:J23)","v":0}]
[null,null,"Pounds Received",null,null,null,null,null,null,"Whole Milk Equivs."]
[]
[null,null,null,null,null,null,null,null,null,"(H) "]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J27-C27","v":0},null,"equals (G) - (F)"]
[null,null,null,null,null,null,null,null,null,"Net Effect"]
[null,null,null,null,null,null,null,null,null,"Bulk CREAM"]
[]
[null,null,null,null,null,null,null,null,null,"Amount per cell (H) gets carried over to 'Fee Calc' worksheet (Line No. 3)"]

{"sheet":"bulk Condensed SKIM","index":2,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,2,4],[0,2,0,6]]}
["Dealer Name:",null,{"$f":"'Fee Calc'!H7","v":0}]
["Dealer License No.:",null,{"$f":"'Fee Calc'!D7","v":0}]
["Month/Year:",null,{"$f":"'Fee Calc'!M7","v":"00:00:00"}]
["Monthly License Fee Calculation worksheet"]
["Bulk Condensed SKIM purchases from non-PA dealers (PMMB-62; Part 2)"]
["Conversion to whole milk equivalents"]
[]
[]
[null,null,"(A)",null,"(B)",null,"(C)",null,"(D)"]
[]
[null,null,null,null,null,null,null,null,"(B) ÷ (C)"]
[null,"PRODUCT","PRODUCT",null,"NFMS",null,"Conversion",null,"Whole Milk "]
[null,"Code","Pounds",null,"Pounds",null,"Factor",null,"Equivalents"]
[1,"250X",null,null,null,null,8.7999999999999995E-2,null,{"$f":"+ROUND(E14/G14,0)","v":0}]
[2,null,null,null,null,null,8.7999999999999995E-2,null,{"$f":"+ROUND(E15/G15,0)","v":0}]
[3,null,null,null,null,null,8.7999999999999995E-2,null,0]
[4,null,null,null,null,null,8.7999999999999995E-2,null,0]
[5,null,null,null,null,null,8.7999999999999995E-2,null,0]
[6,null,null,null,null,null,8.7999999999999995E-2,null,0]
[7,null,null,null,null,null,8.7999999999999995E-2,null,0]
[8,null,null,null,null,null,8.7999999999999995E-2,null,0]
[9,null,null,null,null,null,8.7999999999999995E-2,null,0]
[10,null,null,null,null,null,8.7999999999999995E-2,null,0]
[]
[null,null,"(E)",null,null,null,null,null,"(F)"]
[]
["TOTALs",null,{"$f":"SUM(C14:C23)","v":0},null,null,null,null,null,{"$f":"SUM(I14:I23)","v":0}]
[null,null,"Pounds Received",null,null,null,null,null,"Whole Milk Equivs."]
[]
[null,null,null,null,null,null,null,null,"(G) "]
[]
[null,null,null,null,null,null,null,null,{"$f":"I27-C27","v":0},"equals (F) - (E)"]
[null,null,null,null,null,null,null,null,"Net Effect"]
[null,null,null,null,null,null,null,null,"Condensed SKIM"]
[]
[null,null,null,null,null,null,null,null,"Amount per cell (G) gets carried over to 'Fee Calc' worksheet (Line No. 3)"]

{"sheet":"bulk Condensed MILK","index":3,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,2,4],[0,2,0,6]]}
["Dealer Name:",null,{"$f":"'Fee Calc'!H7","v":0}]
["Dealer License No.:",null,{"$f":"'Fee Calc'!D7","v":0}]
["Month/Year:",null,{"$f":"'Fee Calc'!M7","v":"00:00:00"}]
["Monthly License Fee Calculation worksheet"]
["Bulk Condensed MILK purchases from non-PA dealers (PMMB-62; Part 2)"]
["Conversion to whole milk equivalents"]
[]
[]
[null,null,"(A)",null,"(B)",null,"(C)",null,"(D)"]
[]
[null,null,null,null,null,null,null,null,"(B) ÷ (C)"]
[null,"PRODUCT","PRODUCT",null,"NFMS",null,"Conversion",null,"Whole Milk "]
[null,"Code","Pounds",null,"Pounds",null,"Factor",null,"Equivalents"]
[1,"280X",null,null,null,null,8.7999999999999995E-2,null,{"$f":"+ROUND(E14/G14,0)","v":0}]
[2,null,null,null,null,null,8.7999999999999995E-2,null,{"$f":"+ROUND(E15/G15,0)","v":0}]
[3,null,null,null,null,null,8.7999999999999995E-2,null,0]
[4,null,null,null,null,null,8.7999999999999995E-2,null,0]
[5,null,null,null,null,null,8.7999999999999995E-2,null,0]
[6,null,null,null,null,null,8.7999999999999995E-2,null,0]
[7,null,null,null,null,null,8.7999999999999995E-2,null,0]
[8,null,null,null,null,null,8.7999999999999995E-2,null,0]
[9,null,null,null,null,null,8.7999999999999995E-2,null,0]
[10,null,null,null,null,null,8.7999999999999995E-2,null,0]
[]
[null,null,"(E)",null,null,null,null,null,"(F)"]
[]
["TOTALs",null,{"$f":"SUM(C14:C23)","v":0},null,null,null,null,null,{"$f":"SUM(I14:I23)","v":0}]
[null,null,"Pounds Received",null,null,null,null,null,"Whole Milk Equivs."]
[]
[null,null,null,null,null,null,null,null,"(G) "]
[]
[null,null,null,null,null,null,null,null,{"$f":"I27-C27","v":0},"equals (F) - (E)"]
[null,null,null,null,null,null,null,null,"Net Effect"]
[null,null,null,null,null,null,null,null,"Condensed MILK"]
[]
[null,null,null,null,null,null,null,null,"Amount per cell (G) gets carried over to 'Fee Calc' worksheet (Line No. 3)"]