Exhibit_11.28(1)_-_Cost_Worksheet_Group_1_Addendum__1.xlsx

XLSX spreadsheet 48 KB Posted

Attached to
Printers and Multi-Functional Devices
Solicitation number
0000000258
Issued by
California

About this file

This is a cost worksheet template for a printer procurement contract, provided as Exhibit 11.28(1) with Addendum #1. The solicitation covers four categories of printers: Group 1A (Color Desktop Printers - 1,000 units), Group 1B (Personal Monochrome Printers - 6,000 units), Group 1C (All-in-One Printers - 2,000 units), and Group 1D (Mobile Desktop Printers - 500 units). Each printer category includes a mandatory 3-year ship exchange warranty with options for extended coverage. The worksheet includes requirements for consumables sufficient to produce specified image counts based on 60-months usage at 5% of required monthly duty cycles.

The pricing structure requires bidders to complete yellow-highlighted cells with manufacturer details, list prices, and contract discounts (limited to two decimal places). Consumables pricing must account for all components needed to produce the specified number of prints according to ISO standards 19752, 19798, or 24711. Value-added services include asset tagging, installation, data wiping, disposal services, and deployment logistics. A sample bid shows contract discounts ranging from 20-55% off list prices. The worksheet automatically calculates extended prices and total evaluated costs for each printer group.

View the file

Other files

File Type Posted
Exhibit_11.26_-_Statement_of_Work.pdf PDF
Exhibit_11.28_-_VAS_Definitions.pdf PDF
Exhibit_11_22A_-_Configuration_Specification_Questoinaire.xlsx XLSX spreadsheet
Glossary.pdf PDF
Section_1_-_Introduction_and_Overview_of_Requirements.pdf PDF
Section_4_-_Proposed_System.pdf PDF
Section_9_-_Evaluation.pdf PDF
Exhibit_11.28(2)-_Cost_Worksheet_Group_2_Addendum__1.xlsx XLSX spreadsheet
Exhibit_11.5_-_Customer_Reference_Form.docx DOCX document
Exhibit_11_22_-_Printer_and_MFD_Specifications_Addendum_3.xlsx XLSX spreadsheet
Q_A_Set_2.pdf PDF
Section_11_-_Exhibits.pdf PDF
Addendum_1.pdf PDF
Addendum_3.pdf PDF
Approved_OEM_URLs.pdf PDF
Section_2_-_Rules_Governing_Competition.pdf PDF
Section_3_-_Current_System.pdf PDF
Section_5_-_Administrative_Requirements.pdf PDF
Table_of_Contents,_Addendum__1.pdf PDF
Addendum_2.pdf PDF
Addendum_4.pdf PDF
Exhibit_11.24_Standard_Agreement_(STD_213).pdf PDF
Exhibit_11.25_-_Administrative_Requirements_Response.doc DOC document
Exhibit_11.28(3)-_Cost_Worksheet_Group_3_Addednum__1.xlsx XLSX spreadsheet
Q_A_Set_1.pdf PDF
Q_A_Set_3.pdf PDF
Section_10_-_Demonstration.pdf PDF
Section_6_-_Technical_Requirements_Addendum__1.pdf PDF
Section_7_-_Cost,_Addendum__1.pdf PDF
Section_8_-_Bid_Format_Addendum__1.pdf PDF
Title_Page.pdf PDF
Show all 31

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

Directions The Following instructions must be followed when completing the Cost Worksheets.

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 proposal being rejected. If the printer doesn't require a consumable listed in statement 5, enter the quantity (each) at "0" and continue to complete the cost and percentage. Every yellow box must be completed.

2. The Evaluated Total tab displays the total calculated bid price for the relevant Group derived from the aggregate of the Standard Device, Consumables, Upgrades 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 figures shall be entered to no more than two (2) decimal places (i.e., $150.75, 10.67%). Any figures exceeding two (2) decimal places shall be rounded to the nearest two (2) decimal places.

5. Bidder shall quote consumable materials (ink/toner cartridges, fusers, drums, rollers belts etc. as applicable) for Groups 1,2,3 and 4 as identified in Exhibit 11.28, Pricing Worksheet, sufficient to produce a designated number of images (specified in Exhibit 11.28(1-4), Pricing Worksheet). The number of images is based on 60-months’ usage at 5% of the required monthly duty cycle and coverage per ISO standard 19752, 19798, or 24711 (as applicable).

Event ID #: 0000000258 Addendum #1 &"Arial,Bold"&14COST WORKSHEET DIRECTIONS Exhibit 11.28 (1)

Page &P of &N March 29, 2016

Sample Bidder: Mike's Printer Service

Fill in ALL Yellow Cells

STD DEVICEContract Line Item Number (CLIN)UNSPSC CodeEstimated UsageManufacturer NameManufacturer's ModelManufacturer's Part NumberSKU #Item DescriptionUnit of MeasureQuantity in Unit of MeasureList PriceContract DiscountContract PriceExtended Price
Color Desktop Printer as defined by Exhibit 11-22 . Includes 3-Year Ship Exchange within 3 Business Days Warranty as defined by Section 6.6, Warranty1004312104 Ink Jet 4312105 Laser1,000Printer CompanyColor Printer 2500lRX123456789Color Desktop PrinterEach1$100.0030.00%$70.00$70,000.00
CONSUMABLES
Black (include everything needed to print 15,000 copies as defined by Section 6.4.6)200
Toner/Ink Cartridge43212104/051,000Printer Companyxl50RX54326790TonerEach4$100.0020.00%$80.00$320,000.00
Other43212104/051,000Printer Companyxl60RX54336800FuserEach1$200.0020.00%$160.00$160,000.00
Other43212104/051,000Printer Companyxl70RX54346810DrumEach2$300.0020.00%$240.00$480,000.00
Other43212104/051,000n/an/an/an/an/aEach0$0.0020.00%$0.00$0.00
Other43212104/051,000n/an/an/an/an/aEach0$0.0020.00%$0.00$0.00
Other43212104/051,000n/an/an/an/an/aEach0$0.0020.00%$0.00$0.00
Color (include everything needed to print 15,000 copies as defined by Section 6.4.6)
CyanToner/Ink Cartridge20143212104/051,000Printer Companyxl80RX54356820TonerEach1$100.0020.00%$80.00$80,000.00
Other43212104/051,000Printer Companyxl90RX54366830FuserEach1$200.0020.00%$160.00$160,000.00
Other43212104/051,000Printer Companyxl100RX54376840DrumEach1$300.0020.00%$240.00$240,000.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
Magenta Toner/Ink Cartridge20243212104/051,000Printer Companyxl110RX54386850TonerEach1$100.0020.00%$80.00$80,000.00
Other43212104/051,000Printer Companyxl120RX54396860FuserEach1$200.0020.00%$160.00$160,000.00
Other10443212104/051,000Printer Companyxl130RX54406870DrumEach1$300.0020.00%$240.00$240,000.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
Yellow Toner/Ink Cartridge20343212104/051,000Printer Companyxl140RX54416880TonerEach1$100.0020.00%$80.00$80,000.00
Other43212104/051,000Printer Companyxl150RX54426890FuserEach1$200.0020.00%$160.00$160,000.00
Other10543212104/051,000Printer Companyxl160RX54436900DrumEach1$300.0020.00%$240.00$240,000.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
Other43212104/051,000n/an/an/an/an/aEach1$0.0020.00%$0.00$0.00
OPTIONS (average percentage for all options will be the Non-Core Option Discount for the contract - calculated below)
4-Year Ship Exchange within 3 Business Days Warranty, as defined by Section 6.6, Warranty30043212104/0550Printer Companyw1234RX56788000Extended WarrantyEach1$500.0055.00%$225.00$11,250.00
VALUE ADDED SERVICES
Asset Tagging - Bidder administration of State provided tag (with number)400100Each1$10.0020.00%$8.00$800.00
Disposition & Disposal Services401100Hour1$50.0020.00%$40.00$4,000.00
Total$2,486,050.00
OEM Price List Location:www.abccompany.com
Non-Core Options Discount:55.00%

&"Arial,Regular"Event ID #: 0000000258

Addendum #1&"Arial,Bold"&14PRICING WORKSHEET GROUP 1A&"Arial,Regular"&11
Color Desktop Printer&"Arial,Regular"Exhibit 11.28 (1)

Page &P of &N March 29, 2016

Sample Sample http://www.abccompany.com/ Group 1A Bidder:

Complete ALL Yellow Cells

STD DEVICEContract Line Item Number (CLIN)UNSPSC CodeEstimated UsageManufacturer NameManufacturer's ModelManufacturer's Part NumberSKU #Item DescriptionUnit of MeasureQuantity in Unit of MeasureList PriceContract DiscountContract PriceExtended Price
Color Desktop Printer as defined by Exhibit 11-22 . Includes 3-Year Ship Exchange within 3 Business Days Warranty as defined by Section 6.6, Warranty1A-100432121051,000Each1.00$0.00$0.00
CONSUMABLES
Black (include everything needed to print 15,000 copies as defined by Section 6.4.6)1A-200
Toner/Ink Cartridge43212104/051,000Each$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Color (include everything needed to print 15,000 copies as defined by Section 6.4.6)
CyanToner/Ink Cartridge1A-20143212104/051,000Each$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Magenta Toner/Ink Cartridge1A-20243212104/051,000Each$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Yellow Toner/Ink Cartridge1A-20343212104/051,000Each$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other10543212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
Other43212104/051,000Each0.00%$0.00$0.00
OPTIONS (average percentage for all options will be the Non-Core Option Discount for the contract - calculated below)
One (1)-Year Ship Exchange within 3 Business Days. Extended warranty begins after 3 year mandatory warry included with the machine and can be purchesed in one (1) year increments.1A-30043212104/0550Each1.00$0.00$0.00
VALUE ADDED SERVICES
Asset Tagging - Bidder administration of State provided tag (with number)1A-400100Each1.00$0.00$0.00
Installation1A-40150Each1.00$0.00$0.00
DoD 5220 22-M Data Wipe1A-40250Each1.00$0.00$0.00
Take Back/Disposition & Disposal Services1A-40350Each1.00$0.00$0.00
Depolyment and Logisitics1A-40425Hour1.00$0.00$0.00
Total$0.00
OEM Price List Location:
Non-Core Options Discount:0.00%

&"Arial,Regular"Event ID #: 0000000258

Addendum #1&"Arial,Bold"&14PRICING WORKSHEET GROUP 1A
&"Arial,Regular"&12Color Desktop Printer&"Arial,Regular"Exhibit 11.28 (1)

Page &P of &N March 29, 2016

Group 1B Bidder:

Fill in ALL Yellow Cells

STD DEVICEContract Line Item Number (CLIN)UNSPSC CodeEstimated UsageManufacturer NameManufacturer's ModelManufacturer's Part NumberSKU #Item DescriptionUnit of MeasureQuantity in Unit of MeasureList PriceContract DiscountContract PriceExtended Price
Personal Monochrome Printer as defined by Exhibit 11-22 . Includes 3-Year Ship Exchange within 3 Business Days Warranty as defined by Section 6.6, Warranty1B-100432121056,000Each1$0.00$0.00
CONSUMABLES
Black (include everything needed to print 36,000 copies as defined by Section 6.4.6)1B-200
Toner/Ink Cartridge431211056000Each$0.00$0.00
Other431211056000Each0.00%$0.00$0.00
Other431211056000Each0.00%$0.00$0.00
Other431211056000Each0.00%$0.00$0.00
Other431211056000Each0.00%$0.00$0.00
Other431211056000Each0.00%$0.00$0.00
OPTIONS (average percentage for all options will be the Non-Core Option Discount for the contract - calculated below)
One (1)-Year Ship Exchange within 3 Business Days. Extended warranty begins after 3 year mandatory warry included with the machine and can be purchesed in one (1) year increments.1B-30043212105300Each1$0.00$0.00
VALUE ADDED SERVICES
Asset Tagging - Bidder administration of State provided tag (with number)1B-400100Each1$0.00$0.00
Installation1B-40150Each1$0.00$0.00
DoD 5220 22-M Data Wipe1B-40250Each1$0.00$0.00
Take Back/Disposition & Disposal Services1B-40350Each1$0.00$0.00
Depolyment and Logisitics1B-40425Hour1$0.00$0.00
Total$0.00
OEM Price List Location:
Non-Core Options Discount:0.00%

&"Arial,Regular"Event ID #: 0000000258

Addendum #1&"Arial,Bold"&14PRICING WORKSHEET GROUP 1B
&"Arial,Regular"&12Personal Monochrome Printer&"Arial,Regular"Exhibit 11.28 (1)

Page &P of &N March 29, 2016

Group 1C Bidder:

Fill in ALL Yellow Cells

STD DEVICEContract Line Item Number (CLIN)UNSPSC CodeEstimated UsageManufacturer NameManufacturer's ModelManufacturer's Part NumberSKU #Item DescriptionUnit of MeasureQuantity in Unit of MeasureList PriceContract DiscountContract PriceExtended Price
All-In-One Printer as defined by Exhibit 11-22 . Includes 3-Year Ship Exchange within 3 Business Days Warranty as defined by Section 6.6, Warranty1C-100432121052,000Each1$0.00$0.00
CONSUMABLES
Black (include everything needed to print 30,000 copies as defined by Section 6.4.6). Assume 18,000 black and white and 12,000 color.1C-200
Toner/Ink Cartridge43212104/052000Each$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Color (include everything needed to print 30,000 copies as defined by Section 6.4.6). Assume 12,000 color prrints.
CyanToner/Ink Cartridge1C-201432121042000Each$0.00$0.00
Other432121042000Each0.00%$0.00$0.00
Other432121042000Each0.00%$0.00$0.00
Other432121042000Each0.00%$0.00$0.00
Other432121042000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Magenta Toner/Ink Cartridge1C-20243212104/052000Each$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other30443212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other43212104/152000Each0.00%$0.00$0.00
Yellow Toner/Ink Cartridge1C-20343212104/052000Each$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other30543212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
Other43212104/052000Each0.00%$0.00$0.00
OPTIONS (average percentage for all options will be the Non-Core Option Discount for the contract - calculated below)
One (1)-Year Ship Exchange within 3 Business Days. Extended warranty begins after 3 year mandatory warranty included with the machine and can be purchesed in one (1) year increments.30043212104/05100Each1$0.00$0.00
VALUE ADDED SERVICES
Asset Tagging - Bidder administration of State provided tag (with number)1C-400100Each1$0.00$0.00
Installation1C-40150Each1$0.00$0.00
DoD 5220 22-M Data Wipe1C-40250Each1$0.00$0.00
Take Back/Disposition & Disposal Services1C-40350Each1$0.00$0.00
Depolyment and Logisitics1C-40425Hour1$0.00$0.00
Total$0.00
OEM Price List Location:
Non-Core Options Discount:0.00%

&"Arial,Regular"Event ID #: 0000000258

Addendum #1&"Arial,Bold"&14PRICING WORKSHEET GROUP 1C
&"Arial,Regular"&12All-In-One Printer&"Arial,Regular"Exhibit 11.28 (1)

Page &P of &N March 29, 2016

Group 1D Bidder:

Fill in ALL Yellow Cells

STD DEVICEContract Line Item Number (CLIN)UNSPSC CodeEstimated UsageManufacturer NameManufacturer's ModelManufacturer's Part NumberSKU #Item DescriptionUnit of MeasureQuantity in Unit of MeasureList PriceContract DiscountContract PriceExtended Price
Mobile Desktop Printer as defined by Exhibit 11-22 . Includes 3-Year Ship Exchange within 3 Business Days Warranty as defined by Section 6.6, Warranty1D-10043212105500Each1$0.00$0.00
CONSUMABLES
Black (include everything needed to print 1,500 copies as defined by Section 6.4.6)1D-200
Toner/Ink Cartridge43212104500Each$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Color (include everything needed to print 1,500 copies as defined by Section 6.4.6)
CyanToner/Ink Cartridge1D-20143212104500Each$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Magenta Toner/Ink Cartridge1D-20243212104500Each$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Yellow Toner/Ink Cartridge1D-20343212104500Each$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other40543212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
Other43212104500Each0.00%$0.00$0.00
OPTIONS (average percentage for all options will be the Non-Core Option Discount for the contract - calculated below)
One (1)-Year Ship Exchange within 3 Business Days. Extended warranty begins after 3 year mandatory warry included with the machine and can be purchesed in one (1) year increments.1D-3004321210425Each1$0.00$0.00
VALUE ADDED SERVICES
Asset Tagging - Bidder administration of State provided tag (with number)1D-400100Each1$0.00$0.00
Installation1D-40150Each1$0.00$0.00
DoD 5220 22-M Data Wipe1D-40250Each1$0.00$0.00
Take Back/Disposition & Disposal Services1D-40350Each1$0.00$0.00
Depolyment and Logisitics1D-40425Hour1$0.00$0.00
Total$0.00
OEM Price List Location:
Non-Core Options Discount:0.00%

&"Arial,Regular"Event ID#: 0000000258

Addendum #1&"Arial,Bold"&14PRICING WORKSHEET GROUP 1D
&"Arial,Regular"&12Mobile Printer&"Arial,Regular"Exhibit 11.28 (1)

Page &P of &N March 29, 2016

Evaluated Total

Group 1
Bidder:
Group 1AGroup 1BGroup 1CGroup 1DEvaluated Total
$0.00$0.00$0.00$0.00$0.00

&"Arial,Regular"Event ID #: 0000000258

Addendum #1&"Arial,Bold"&14COST WORKSHEET
EVALUATED TOTAL&"Arial,Regular"Exhibit 11.28 (1)

Page &P of &N March 29, 2016

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