{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Vendor Cost Analysis"],"not_rendered":{"external_links":2,"defined_names":34,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Vendor Cost Analysis","index":0,"n_rows":130,"n_cols":64,"rows_kept":130,"merged":[[37,1,37,8]]}
[]
[]
[null,"Vendor Cost Analysis"]
[]
[]
[null,"Part Number"]
[null,"Description"]
[]
[null,"Total Requirements (Units)",null,null,{"v":20000,"d":"20,000 "}]
[null,"Number of Vendors",null,null,{"$f":"IF(COUNTA(C15:C19),COUNTA(C15:C19),\"\")","v":5}]
[null,"Requirement per Vendor",null,null,{"$f":"IF(SUM(E10),ROUND(E9/E10,0),\"\")","v":{"v":4000,"d":"4,000 "}}]
[]
[null,"PRICES AND DELIVERY COSTS IN UNITS"]
[null,null,"Vendor",null,"Bid Price ","Delivery ","Total "]
[null,"1. ","Vendor",null,{"v":23.75,"d":"$24"},{"v":0.65,"d":"$1"},{"$f":"IF(E15,E15+F15,\"\")","v":{"v":24.4,"d":"$24"}}]
[null,"2. ","Vendor",null,{"v":20.5,"d":"$21"},{"v":2.15,"d":"$2"},{"$f":"IF(E16,E16+F16,\"\")","v":{"v":22.65,"d":"$23"}}]
[null,"3. ","Vendor",null,{"v":23.25,"d":"$23"},{"v":1.55,"d":"$2"},{"$f":"IF(E17,E17+F17,\"\")","v":{"v":24.8,"d":"$25"}}]
[null,"4. ","Vendor",null,{"v":22.25,"d":"$22"},{"v":1.2,"d":"$1"},{"$f":"IF(E18,E18+F18,\"\")","v":{"v":23.45,"d":"$23"}}]
[null,"5. ","Vendor",null,{"v":22.25,"d":"$22"},{"v":1.2,"d":"$1"},{"$f":"IF(E19,E19+F19,\"\")","v":23.45}]
[null,"Average Delivered Price Per Unit ",{"$nulls":4},{"$f":"IF(SUM(G15:G19),SUM(G15:G19)/(5-(G15=0)-(G16=0)-(G17=0)-(G18=0)-(G19=0)),\"\")","v":{"v":23.75,"d":"$23.75"}}]
[]
[null,"ALLOCATION OF ORDERS AND COSTS"]
[{"$nulls":4},"Manual ","Delivered ","Price vs.","Actual "," Amount  "]
[null,null,"Vendor",null,"Override ","Price/Unit ","Average","Order ","of Order "]
[null,"1. ",{"$f":"IF(CELL(\"type\",C15)=\"l\",C15,\"\")","v":"Vendor"},null,3000,{"$f":"IF(SUM(G15),G15,\"\")","v":{"v":24.4,"d":"$24"}},{"$f":"IF(SUM(F25),F25/$G$20,\"\")","v":{"v":1.0273684210526315,"d":"103%"}},{"$f":"IF(CELL(\"Type\",E25)=\"v\",SUM(E25),IF(SUM(E15)>0,ROUND(SUM(G25)*SUM(E11),2),\"\"))","v":3000},{"$f":"IF(OR(CELL(\"type\",E25)=\"v\",SUM(F25)),SUM(H25)*SUM(F25),\"\")","v":{"v":73200,"d":"$73,200"}}]
[null,"2. ",{"$f":"IF(CELL(\"type\",C16)=\"l\",C16,\"\")","v":"Vendor"},null,10000,{"$f":"IF(SUM(G16),G16,\"\")","v":{"v":22.65,"d":"$23"}},{"$f":"IF(SUM(F26),F26/$G$20,\"\")","v":{"v":0.9536842105263157,"d":"95%"}},{"$f":"IF(CELL(\"Type\",E26)=\"v\",E26,IF(E16>0,ROUND(G26*E11,2),\"\"))","v":10000},{"$f":"IF(OR(CELL(\"type\",E26)=\"v\",SUM(F26)),SUM(H26)*SUM(F26),\"\")","v":{"v":226500,"d":"$226,500"}}]
[null,"3. ",{"$f":"IF(CELL(\"type\",C17)=\"l\",C17,\"\")","v":"Vendor"},null,0,{"$f":"IF(SUM(G17),G17,\"\")","v":{"v":24.8,"d":"$25"}},{"$f":"IF(SUM(F27),F27/$G$20,\"\")","v":{"v":1.0442105263157895,"d":"104%"}},{"$f":"IF(CELL(\"Type\",E27)=\"v\",E27,IF(E17>0,ROUND(G27*E11,2),\"\"))","v":0},{"$f":"IF(OR(CELL(\"type\",E27)=\"v\",SUM(F27)),SUM(H27)*SUM(F27),\"\")","v":{"v":0,"d":"$0"}}]
[null,"4. ",{"$f":"IF(CELL(\"type\",C18)=\"l\",C18,\"\")","v":"Vendor"},null,7000,{"$f":"IF(SUM(G18),G18,\"\")","v":{"v":23.45,"d":"$23"}},{"$f":"IF(SUM(F28),F28/$G$20,\"\")","v":{"v":0.9873684210526316,"d":"99%"}},{"$f":"IF(CELL(\"Type\",E28)=\"v\",E28,IF(E18>0,ROUND(G28*E11,2),\"\"))","v":7000},{"$f":"IF(OR(CELL(\"type\",E28)=\"v\",SUM(F28)),SUM(H28)*SUM(F28),\"\")","v":{"v":164150,"d":"$164,150"}}]
[null,"5. ",{"$f":"IF(CELL(\"type\",C19)=\"l\",C19,\"\")","v":"Vendor"},null,0,{"$f":"IF(SUM(G19),G19,\"\")","v":{"v":23.45,"d":"$23"}},{"$f":"IF(SUM(F29),F29/$G$20,\"\")","v":{"v":0.9873684210526316,"d":"99%"}},{"$f":"IF(CELL(\"Type\",E29)=\"v\",E29,IF(E19>0,ROUND(G29*E11,2),\"\"))","v":0},{"$f":"IF(OR(CELL(\"type\",E29)=\"v\",SUM(F29)),SUM(H29)*SUM(F29),\"\")","v":0}]
[null,{"$f":"\"Total Units \"&IF(ABS(SUM(H25:H29)-E9)>0.49,\"(Out of Balance by \"&FIXED(ABS(SUM(H25:H29)-E9),0,TRUE)&\" Units)\",\"\")","v":"Total Units "},{"$nulls":5},{"$f":"IF(SUM(H25:H29),SUM(H25:H29),\"\")","v":20000}]
[]
[null,"SUMMARY"]
[null,"Total Cost of Orders",null,null,{"$f":"IF(SUM(I25:I29),SUM(I25:I29),\"\")","v":{"v":463850,"d":"$463,850"}}]
[null,"Low Bidder Total",null,null,{"$f":"IF(SUM(E33),MIN(BL126:BL130)*E9,\"\")","v":{"v":453000,"d":"$453,000"}}]
[null,"Multiple Bid Premium and %",null,null,{"$f":"IF(SUM(E34),E33-E34,\"\")","v":{"v":10850,"d":"$10,850"}},{"$f":"IF(SUM(E35),E35/E34,\"\")","v":{"v":0.023951434878587197,"d":"2.40%"}}]
{"$rows_empty":88}
[{"$nulls":63},"Intermediate Calculations"]
[{"$nulls":63},"Do Not Change"]
[{"$nulls":63},{"$f":"IF(G15=0,MAX($G$15:$G$19),G15)","v":24.4}]
[{"$nulls":63},{"$f":"IF(G16=0,MAX($G$15:$G$19),G16)","v":22.65}]
[{"$nulls":63},{"$f":"IF(G17=0,MAX($G$15:$G$19),G17)","v":24.8}]
[{"$nulls":63},{"$f":"IF(G18=0,MAX($G$15:$G$19),G18)","v":23.45}]
[{"$nulls":63},{"$f":"IF(G19=0,MAX($G$15:$G$19),G19)","v":23.45}]