Addendum_3_Exhibit_11.28_D_Lenovo_Worksheet.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
Tablets (IT)
Solicitation number
0000000669
Issued by
Los Angeles County, California

About this file

This is a cost worksheet template and evaluation model specification for a tablet computer procurement opportunity (Event ID: 0000000669), specifically for Lenovo devices, dated May 3, 2016. The document outlines specifications for two evaluation models: a medium configuration ThinkPad 10 (Model 20C1CTO1WW) with a 10.1" screen and Windows 10 Pro, and a large configuration ThinkPad Helix 2nd Gen (Model 20CGCTO1WW) with an 11.6" screen and Windows 10 Pro. Both models include specific requirements for processors, storage, memory, battery, wireless capabilities, and warranty requirements.

The pricing structure requires bidders to complete yellow cells only in the cost worksheet, with entries limited to two decimal places for dollar amounts and whole numbers for percentages. The worksheet is divided into four main pricing categories: Hardware, Accessories/Peripherals Upgrades, Warranty/Services, and Value Added Services. Specific line items include docking stations, mice, sleeves, keyboards, power adapters, extended warranties, accidental damage protection, asset tagging, imaging, and deployment services. The worksheet automatically calculates the total evaluated price based on the bidder's inputs.

View the file

Other files

File Type Posted
Addendum_1_Event_ID_0000000669_Section_6_-_Technical_REQs.pdf PDF
Addendum_1_Exhibit_11.22_Tablets_Minimum_Requirements.xlsx XLSX spreadsheet
Addendum_1_Exhibit_11.28_F_Worksheet.xlsx XLSX spreadsheet
Addendum_2_Event_ID_0000000669_-_Table_of_Contents.pdf PDF
Addendum_2_Event_ID_0000000669_Section_1_-_Intro_Overview.pdf PDF
Addendum_2_Event_ID_0000000669_Solicitation.pdf PDF
Addendum_3_Event_ID_0000000669_-_Table_of_Contents.pdf PDF
Addendum_3_Event_ID_0000000669_Section_11_-_Exhibits.pdf PDF
Addendum_3_Exhibit_11.24_Standard_Agreement_(STD_213).doc DOC document
Addendum_3_Exhibit_11.28_F_Samsung_Worksheet.xlsx XLSX spreadsheet
Addendum_4_Event_ID_0000000669_Solicitation.pdf PDF
Addendum_5_Question_and_Answer_Set_3.pdf PDF
Exhibit_11.22_Tablets_Minimum_Requirements.xlsx XLSX spreadsheet
Exhibit_11.28_D_Lenovo_Evaluation_and_Cost_Worksheet.xlsx XLSX spreadsheet
Exhibit_11.5_Customer_Reference_Form.docx DOCX document
Exhibit_11_28_E_Microsoft_Evaluation_and_Cost_Worksheet.xlsx XLSX spreadsheet
Question_and_Answer_(Q___A)_Set_1.pdf PDF
Addendum_1_Event_ID_0000000669_Section_4_-_Proposed_System.pdf PDF
Addendum_1_Event_ID_0000000669_Section_5_-_Admin_REQs.pdf PDF
Addendum_1_Exhibit_11.25_Administrative_Requirements.doc DOC document
Addendum_1_Exhibit_11.28_B_Dell_Worksheet.xlsx XLSX spreadsheet
Addendum_1_Exhibit_11.28_C_HP_Worksheet.xlsx XLSX spreadsheet
Addendum_1_Exhibit_11.28_D_Lenovo_Worksheet.xlsx XLSX spreadsheet
Addendum_1_Exhibit_11.28_E_Microsoft_Worksheet.xlsx XLSX spreadsheet
Addendum_3_Event_ID_0000000669_Section_1_-_Introduction_Reqs.pdf PDF
Addendum_3_Event_ID_0000000669_Section_7_-_Cost.pdf PDF
Addendum_3_Exhibit_11.28_A_Apple_Worksheet.xlsx XLSX spreadsheet
Addendum_3_Exhibit_11.28_C_HP_Worksheet.xlsx XLSX spreadsheet
Addendum_3_Exhibit_11.28_E_Microsoft_Worksheet.xlsx XLSX spreadsheet
Addendum_3_Response_to_Request_for_Changes_Set_2.pdf PDF
Addendum_4_Event_ID_0000000669_Section_1_-_Introduction_Reqs.pdf PDF
Addendum_4_Revision_Response_to_Request_for_Changes_Set_2.pdf PDF
Event_ID_0000000669_Solicitation.pdf PDF
Exhibit_11.24_Standard_Agreement_(STD_213).doc DOC document
Exhibit_11.25_Administrative_Requirements_Response.doc DOC document
Exhibit_11.26_Statement_of_Work.pdf PDF
Exhibit_11.28_C_HP_Evaluation_and_Cost_Worksheet.xlsx XLSX spreadsheet
Addendum_1_Event_ID_0000000669_-_Table_of_Contents.pdf PDF
Addendum_1_Event_ID_0000000669_Section_7_-_Cost.pdf PDF
Addendum_1_Event_ID_0000000669_Section_8_-_Proposal_Format.pdf PDF
Addendum_1_Event_ID_0000000669_Solicitation.pdf PDF
Addendum_2_Event_ID_0000000669_Section_4_-_Proposed_System.pdf PDF
Addendum_2_Event_ID_0000000669_Section_5_-_Admin_Req.pdf PDF
Addendum_2_Event_ID_0000000669_Section_7_-_Cost.pdf PDF
Addendum_2_Event_ID_0000000669_Section_8_-_Proposal_Format.pdf PDF
Addendum_2_Response_to_Request_for_Changes.pdf PDF
Addendum_3_Event_ID_0000000669_Section_5_-_Admin_Reqs.pdf PDF
Addendum_3_Exhibit_11.28_B_Dell_Worksheet.xlsx XLSX spreadsheet
Addendum_3_Exhibit_11.28_G_Rugged_Worksheet.xlsx XLSX spreadsheet
Addendum_3_Exhibit_11.4_APP_Regulations.pdf PDF
Show 40 more

50 files listed here. See the rest on GovTribe.

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Cost Worksheet Directions

Cost Worksheet Directions

The Following instructions must be followed when completing the Cost Worksheet.

1) The Bidder will fill out the yellow cells only. All other cells have been locked; any modification of other cells may result in the bid being rejected. Every yellow box must be completed.

2) The Evaluated Total tab displays the total calculated bid price for the relevant Silo derived from the aggregate of the Hardware, Accessories/Peripherals Upgrades, Warranty/Services, and Value Added Services.

3) The Evaluated Total tab is locked and will be populated automatically.

4) Per Section 7.2.5, Pricing/Discount Format, all dollar figures must be entered to no more than two (2) decimal places (i.e., $150.75). All percentages entered shall be whole numbers (i.e., 75%).

Event ID: 0000000669 Tablets Exhibit 11.28 D &"-,Bold Italic"&KFF0000Addendum 3&"-,Regular"&K01+000 Cost Worksheet Directions

&P of &N &"-,Bold Italic"&KFF000005/03/2016

OEM Lenovo Evaluation Model

OEM Lenovo Silo - Evaluation Model

SizeModelScreenOperating SystemProcessorStorageMemoryBatteryWireless LANWarranty
MediumThinkPad 10 PN 20C1CTO1WW10.1" WUXGA (1920x1200) IPS Multi-touch, Digitizer Pen, BlackWindows 10 Pro
Intel Atom Z3795 Processor (2MB Cache, up to 2.4 GHz) Onboard64GB eMMC Integrated Storage2GB PC3-8500 DDR3 on MB
2 Cell Li-Polymer Battery 33 WhWiFi / BT 802.11 abgn with Bluetooth v4.0 Antenna type 2x23 Year Depot or Carry-in
LargeThinkPad Helix 2nd Gen: 11.6" PN 20CGCTO1WW11.6" FHD (1920x1080) Multitouch, Digitizer Pen, BlackWindows 10 Pro
Intel Core M-5Y10c Processor (4MB Cache, up to 2.00GHz) Onboard128GB Solid State Drive, Serial ATA
4GB PC3-12800L on MB
2-cell Li-Polymer Battery, 35 WhIntel Dual Band Wireless-AC/B/G/N 7265, Bluetooth Version 4.03 Year Depot or Carry-in

&"Arial,Regular"&10Event ID: 0000000669 Tablets &"Arial,Regular"&10Exhibit 11.28D &"Arial,Bold Italic"&KFF0000Addendum 3&"Arial,Regular"&K01+000 Evaluation Model

&"Arial,Regular"&10Refer to Exhibit 11.28D Cost Worksheet &"Arial,Regular"&10&P of &N &"Arial,Bold Italic"&10 &KFF000005/03/2016

OEM Lenovo Cost Worksheet

OEM Lenovo Silo - Cost Worksheet

Bidder:

OEM Index / MSRP: Index Date:

Category IDCLINItem DescriptionQuantityManufacturer Part NumberManufacturer (OEM)SKU NumberUOMQuantity in UOMList Price/MSRPContract DiscountContract PriceExtended Total
Sample100iPad Mini 41MF544LL/AApple, IncMF544LL/AEach1$479.0045%$263.45$263.45
Hardware*100Medium Configuration
ThinkPad 10 PN 20C1CTO1WW1Each$0.00$0.00
101Large Configuration
ThinkPad Helix 2nd Gen PN 20CGCTO1WW1Each$0.00$0.00
Accessories / Peripherals Upgrades200Thinkpad USB 3.0 Dock PN 4X10A066871Each$0.00$0.00
201Lenovo N700 Wireless & Bluetooth Mouse and Laser Pointer 8880154501Each$0.00$0.00
202Lenovo Yoga Tablet Pro 13 Sleeve and Film 8880173641Each$0.00$0.00
203Lenovo Preferred Pro USB Fingerprint Keyboard - US English1Each$0.00$0.00
204ThinkPad 90W AC Adapter (slim tip) - US/Can/LA 0B469941Each$0.00$0.00
Warranty / Services300Extended 5 Year Warranty1Each$0.00$0.00
301Accidental Damage Protection1Each$0.00$0.00
302Keep Your Drive1Each$0.00$0.00
Value Added Services400Asset Tagging1Each$0.00$0.00
401Basic Imaging1Each$0.00$0.00
402Basic Deployment and Logistics1Hour$0.00$0.00
Total Evaluated Price:$0.00

&"Arial,Regular"&10Event ID: 0000000669 Tablets &"Arial,Regular"&10Exhibit 11.28D &"Arial,Bold Italic"&KFF0000Addendum 3&"Arial,Regular"&K01+000 Cost Worksheet

&"Arial,Regular"&10* Refer to Exhibit 11.28D Evaluation Model &"Arial,Regular"&10&P of &N &"Arial,Bold Italic"&10&KFF0000 05/03/2016

File details come from the government source that posted it. Updated .