{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Forecast","Product Info"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Forecast","index":0,"n_rows":48,"n_cols":18,"rows_kept":48,"cut":false,"hidden":false,"merged":[[8,1,8,2],[5,1,5,2],[2,1,2,2],[31,0,31,16],[32,0,32,16]]}
[]
[]
[null,"New Commodity Pound Alottment"]
[null,"Bulk Potatoes (100506)"]
[]
[null,"Remaining Entitlement from last yr."]
[null,"Bulk Potatoes (100506)",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Pound Balance"]
[null,"Total Pounds Drawn Down",{"$f":"M29","v":0}]
[null,"Total Pounds Remaining",{"$f":"(C4+C7)-C10","v":0}]
[]
[]
["SEPDS Code","Cavendish UPC Code","Product Description","Pack Size","Net Weight Per Case","Servings Per Case","Net Weight Per 1/2 Cup  (Grams)","# Pieces per 1/2 Cup Serving","Daily Servings","Days Served Each Month","Est. Total Monthly Servings","Finished Cases Needed Monthly","# of Months to be Served during School Year","Annual Raw LBS of Donated Food","Approximate Annual Finished LBS      DF x 55%","USDA Average Commodity Cost for Bulk Potatoes, 100506","Commodity Dollars Required","Click To Clear Line"]
[]
[null,{"$f":"IF(ISBLANK(A16),\" \",VLOOKUP(A16,Products,2,FALSE))","v":" "},{"$f":"IF(ISBLANK(A16),\" \",VLOOKUP(A16,Products,3,FALSE))","v":" "},{"$f":"IF(ISBLANK(A16),\" \",VLOOKUP(A16,Products,4,FALSE))","v":" "},{"$f":"IF(ISBLANK(A16),\" \",VLOOKUP(A16,Products,6,FALSE))","v":" "},{"$f":"IF(ISBLANK(A16),\" \",VLOOKUP(A16,Products,7,FALSE))","v":" "},{"$f":"IF(ISBLANK(A16),\" \",VLOOKUP(A16,Products,11,FALSE))","v":" "},{"$f":"IF(ISBLANK(A16),\" \",VLOOKUP(A16,Products,16,FALSE))","v":" "},null,null,{"$f":"IF(ISBLANK(J16),\"\",(I16*J16))","v":""},{"$f":"IF(ISBLANK(J16),\" \",ROUNDUP((K16/F16),0))","v":" "},null,{"$f":"IFERROR(VLOOKUP(A16,'Product Info'!A:E,5,FALSE)*L16*M16, \" \")","v":" "},{"$f":"IF(ISBLANK(J16),\"\",(N16*0.55))","v":""},"$0.1313/lb",{"$f":"IF(ISBLANK(J16),\"\",(N16*VLOOKUP(A16,Products,8,FALSE)))","v":""}]
[null," "," "," "," "," "," "," ",null,null,"",{"$f":"IF(ISBLANK(J17),\" \",ROUNDUP((K17/F17),0))","v":" "},null,{"$f":"IFERROR(VLOOKUP(A17,'Product Info'!A:E,5,FALSE)*L17*M17, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," ",null,{"$f":"IFERROR(VLOOKUP(A18,'Product Info'!A:E,5,FALSE)*L18*M18, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," ",null,{"$f":"IFERROR(VLOOKUP(A19,'Product Info'!A:E,5,FALSE)*L19*M19, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," ",null,{"$f":"IFERROR(VLOOKUP(A20,'Product Info'!A:E,5,FALSE)*L20*M20, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," "," ",{"$f":"IFERROR(VLOOKUP(A21,'Product Info'!A:E,5,FALSE)*L21*M21, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," "," ",{"$f":"IFERROR(VLOOKUP(A22,'Product Info'!A:E,5,FALSE)*L22*M22, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," "," ",{"$f":"IFERROR(VLOOKUP(A23,'Product Info'!A:E,5,FALSE)*L23*M23, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," "," ",{"$f":"IFERROR(VLOOKUP(A24,'Product Info'!A:E,5,FALSE)*L24*M24, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," "," ",{"$f":"IFERROR(VLOOKUP(A25,'Product Info'!A:E,5,FALSE)*L25*M25, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,""," ",null,{"$f":"IFERROR(VLOOKUP(A26,'Product Info'!A:E,5,FALSE)*L26*M26, \" \")","v":" "},"","$0.1313/lb",""]
[null," "," "," "," "," "," "," ",null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A27,'Product Info'!A:E,5,FALSE)*L27*M27, \" \")","v":" "},"","$0.1313/lb",""]
[]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(L16:L27)","v":0},{"$f":"SUM(N16:N27)","v":0},{"$f":"SUM(O16:O27)","v":0},{"$f":"SUM(P16:P27)","v":0},{"$f":"SUM(Q16:Q27)","v":0}]
[]
[]
["Annual Planner"]
["Instructions: In the monthly columns below, enter the number of cases that are expected to be used each month for each product. The column entitled \"Yearly Total Planned\" shows the number of cases that you have planned based on the information entered in this monthly table. The column entitled \"Yearly Total Needed\" shows the number of cases that you need to order, based on the information calculated in the table above. "]
["SEPDS Code","Cavendish UPC Code","Product Description","July","Aug","Sept","Oct","Nov","Dec","Jan","Feb ","Mar","Apr","May","June","Yearly Total Planned","Yearly Total Needed"]
[]
[1486930216,"14869 30216","Cavendish Prairie Select 1/2\" Oven Crinkle",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D36:O36)","v":0},{"$f":"IFERROR((VLOOKUP(B36,B:Q,11,FALSE))*(VLOOKUP(B36,B:Q,12,FALSE)),\" \")","v":0}," "]
[5621034500,"56211 34500-2","Cavendish Foodservice Patties",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D37:O37)","v":0},{"$f":"IFERROR((VLOOKUP(B37,B:Q,11,FALSE))*(VLOOKUP(B37,B:Q,12,FALSE)),\" \")","v":0}]
[5621004101,"56210 04101-2","Cavendish Oven Nuggets",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005222,"56210 05222-2","Cavendish Seasoned Chunky Diced",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005307,"56210 05307","Cavendish Clear Coat Reduce Sodium 3/8\"",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005301,"56210 05301-2","Cavendish Clear Coat 3/8\" Regular Cut",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005311,"56210 05311-2","Cavendish Clear Coat 1/4\" Shoestring",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005361,"56210 05361","Cavendish CrispToGo 3/8\" (formerly DeliverCrisp)",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005501,"56210 05501-2","Cavendish Fine Coat 1/4\" Shoestring",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005502,"56210 05502-2","Cavendish Fine Coat Reg 3/8\" Straight Cut",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005503,"56210 05503-2","Cavendish Fine Coat 5/16\" Straight Cut",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621005505,"56210 05505-2","Cavendish Fine Coat Thin SC Skin On",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5621035101,"56210 35101-2","Cavendish Select Spicy 3/8\" Straight Cut",null,null,null,null,null,null,null,null,null,null,null,null,0,0]

{"sheet":"Product Info","index":1,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,25,0,28],[21,27,26,27]]}
[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,"Jamestown, North Dakota"]
[" 100506 Bulk Potatoes ","Bulk Potato Program: Cavendish     UPC Code","Products on Approved           SY21-22 SEPDS","Pack Size"," DF Pounds","Net Weight Per Case","Servings Per Case","USDA Average Commodity Cost for Bulk Potatoes, 100506","Commodity Dollars Drawn Down per case","1/2 Serving Size (oz)","Net Weight Per 1/2 Cup of Vegetables (Grams)","Child Serving Size","Calories","Sodium mg","Calories from Fat","# Pieces per 1/2 Cup Serving"]
["Example","Example","Using a 30/lb net case with 190 serv per cs","6/5",null,30,190,null,null,null,"71g",null,null,null,null,8,"Cavendish Farms                                                        "]
["Example","Example","Using a 27/lb net case with 191 serv per cs","6/4.5",null,27,191,null,null,null,"63g",null,null,null,null,12,"Cavendish Farms                                                        "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cavendish Farms                                                        "]
["SEPDS Code","Internal Dash 2 added when appropriate"]
[]
[1486930216,"14869 30216","Prairie Select 1/2\" Oven Crinkle Cut","6/5",{"$f":"F8/0.55","v":54.54545454545454},30,243,0.1313,{"$f":"E8*H8","v":7.1618181818181812},2.25,"55g","1/2 cup",70,15,18,10]
[5621034500,"56211 34500-2","Cavendish Hash Brown Patties","6/5",54.54545454545454,30,97,0.1313,{"$f":"E9*H9","v":7.1618181818181812},4.9000000000000004,"138g","1/2 cup",260,490,126,2]
[5621004101,"56210 04101-2","Cavendish Oven Nuggets","6/5",54.54545454545454,30,190,0.1313,7.1618181818181812,2.52,"71g","1/2 cup",130,250,54,8]
[5621005222,"56210 05222-2","Cavendish Flavor Crisp Seasoned Diced","6/5",54.54545454545454,30,153,0.1313,7.1618181818181812,3.1,"88g","1/2 cup",130,470,36,20]
[5621005307,"56210 05307","Cavendish Clear Coat Reduce Sodium 3/8\"","6/5",54.54545454545454,30,212,0.1313,7.1618181818181812,2.2999999999999998,"64g","1/2 cup",128,120,60,12]
[5621005301,"56210 05301-2","Cavendish Clear Coat 3/8\" Straight Cut","6/4.5",49.090909090909086,27,191,0.1313,6.4456363636363632,2.2999999999999998,"64g","1/2 cup",110,340,36,12]
[5621005311,"56210 05311-2","Cavendish Clear Coat 1/4\" Shoestring","6/4.5",49.090909090909086,27,191,0.1313,6.4456363636363632,2.2999999999999998,"64g","1/2 cup",110,360,41,24]
[5621005361,"56210 05361","Cavendish CrispToGo 3/8\" SC (formerly DeliverCrisp)","6/4.5",{"$f":"F15/0.55","v":49.090909090909086},27,187,0.1313,{"$f":"E15*H15","v":6.4456363636363632},2.2999999999999998,"64g","1/2 cup",110,360," ",8]
[5621005501,"56210 05501-2","Cavendish Fine Coat 1/4\" Shoestring","6/4.5",49.090909090909086,27,191,0.1313,6.4456363636363632,2.2999999999999998,"64g","1/2 cup",105,330,32,18]
[5621005502,"56210 05502-2","Cavendish Fine Coat Reg 3/8\" Straight Cut","6/5",54.54545454545454,30,212,0.1313,7.1618181818181812,2.2999999999999998,"64g","1/2 cup",90,305,23,12]
[5621005503,"56210 05503-2","Cavendish Fine Coat 5/16\" Straight Cut","6/5",54.54545454545454,30,212,0.1313,7.1618181818181812,2.2999999999999998,"64g","1/2 cup",100,325,27,12]
[5621005505,"56210 05505-2","Cavendish Fine Coat Thin SC Skin On","6/5",54.54545454545454,30,212,0.1313,7.1618181818181812,2.2999999999999998,"64g","1/2 cup",100,325,27,12]
[5621035101,"56210 35101-2","Cavendish Select Spicy 3/8\" Straight Cut","6/4.5",49.090909090909086,27,175,0.1313,6.4456363636363632,2.2999999999999998,"64g","1/2 cup",100,300,27,12]
[1486930216,"14869 30216","Cavendish Prairie Select 1/2\" Oven Crinkle","6/5",30,null,null,0.1018,null,243,"55g",null,null,null,null,null,null,null,10,null,null,{"$f":"SUM(T21*U21)","v":0},{"$f":"SUM(V21/J21)","v":0},{"$f":"SUM(W21*54.55)","v":0},{"$f":"SUM(X21*0.55)","v":0},"$0.1013/lb",{"$f":"SUM(X21*0.1013)","v":0}]
[null,null,"SAMPLE"]
[null,null,"Cavendish Oven Nuggets","6/5",30,null,null,null,null,190,"71g",null,null,null,null,null,null,null,8,100,4,{"$f":"SUM(T23*U23)","v":400},{"$f":"SUM(V23/190)","v":2.1052631578947367},{"$f":"SUM(W23*54.55)","v":114.84210526315788},{"$f":"SUM(X23*0.55)","v":63.163157894736834},"$0.1018/lb",{"$f":"SUM(X23*0.1013)","v":11.633505263157893}]
[null,null,"Cavendish Clear Coat 3/8\" Regular Cut","6/4.5",27,null,null,null,null,191,"63g",null,null,null,null,null,null,null,12,5000,3,{"$f":"SUM(T24*U24)","v":15000},{"$f":"SUM(V24/191)","v":78.534031413612567},{"$f":"SUM(W24*49.09)","v":3855.2356020942411},{"$f":"SUM(X24*0.55)","v":2120.379581151833},"$0.1018/lb",{"$f":"SUM(X24*0.1013)","v":390.53536649214664}]
[]
[]
["Delivery by Case by Month"]
[]
[null,null,"Fee For Service","July","Aug",null,null,null,null,"Sept","Oct",null,null,null,null,null,null,null,"Nov","Dec","Jan","Feb ","Mar","Apr","May","June","Total",0]
[null,"14869 30216","Cavendish Prairie Select 1/2\" Oven Crinkle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:Z30)","v":0},{"$f":"AB29-(AA30*54.55)","v":0}]
[null,"56211 34500-2","Cavendish Foodservice Patties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB30-(AA31*54.55)","v":0}]
[null,"56210 04101-2","Cavendish Oven Nuggets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB30-(AA32*54.55)","v":0}]
[null,"56210 05222-2","Cavendish Seasoned Chunky Diced",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB32-(AA33*54.55)","v":0}]
[null,"56210 05307","Cavendish Clear Coat Reduce Sodium 3/8\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB33-(AA34*54.55)","v":0}]
[null,"56210 05301-2","Cavendish Clear Coat 3/8\" Regular Cut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB30-(AA35*49.09)","v":0}]
[null,"56210 05311-2","Cavendish Clear Coat 1/4\" Shoestring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB35-(AA36*49.09)","v":0}]
[null,"56210 05501-2","Cavendish Fine Coat 1/4\" Shoestring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB36-(AA37*49.09)","v":0}]
[null,"56210 05502-2","Cavendish Fine Coat Reg 3/8\" Straight Cut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB37-(AA38*54.55)","v":0}]
[null,"56210 05503-2","Cavendish Fine Coat 5/16\" Straight Cut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"56210 05505-2","Cavendish Fine Coat Thin SC Skin On",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"56209 06601-2","Cavendish Always Crisp Shoestring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB40-(AA41*49.09)","v":0}]
[null,"56210 06604-2","Cavendish Always Crisp 3/8\" Crinkle Cut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB41-(AA42*54.55)","v":0}]
[null,"56210 06607-2","Cavendish Always Crisp 10 Cut Wedge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB42-(AA43*54.55)","v":0}]
[null,"56210 35101-2","Cavendish Select Spicy 3/8\" Straight Cut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AB43-(AA44*49.09)","v":0}]
[null,"14869 30216","Cavendish Prairie Select 1/2\" Oven Crinkle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D30:D45)","v":0},0,null,null,null,null,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"By entering your total allocation of pounds below the yellow arrrow and then entering your number of cases to delivered monthly, this chart will provide Cavendish the ability to "]
[null,"properly forecast your needs for the school year and will show approximately how many cases you will purchase commercially once your allocation has been depleted.  "]