Attachment_1_-_Pricing_Worksheet_Addendum_2.xlsx

XLSX spreadsheet 34 KB Posted Mar 14, 2024

Attached to: Toner & Ink Cartridges, New OEM
Solicitation number: 0000028763
Issued by: Sacramento County, Sacramento City, California

About this file

Written by GovTribe AI · Apr 2, 2024

This document is a Pricing Worksheet Addendum related to a state and local government contract opportunity for Toner & Ink Cartridges, New OEM. The contract is being issued by the California Department of General Services - Procurement Division and is available to Sacramento County and Sacramento City. The solicitation lists over 176 specific line items for toner and ink cartridges from various manufacturers, with quantities ranging from 124 to 9,387 units per item. Bidders must provide pricing for each line item, including the manufacturer part number, UNSPSC code, unit of measure, and contract unit price. In addition to the core line items, the solicitation includes a non-core line item for an overall catalog discount to be applied to any other catalog items not specifically listed. The contract term and any renewal options are not provided in this document.

Regarding pricing, the Pricing Worksheet instructs bidders to complete the yellow input cells only. The contract unit price and contract discount percentage will be calculated based on the bidder's input. There is no indication of any small business or disadvantaged business set-asides, incumbent contractors, or funding sources and requirements. The solicitation also does not include any details on the current toner/ink cartridge environment or usage patterns.

View the file

Other files

File	Type	Posted
Question___Answer_Set__1.docx	DOCX document	Mar 14, 2024
IFB_Addendum_2_-_Cover_Sheet.docx	DOCX document	Mar 14, 2024
APP_Cover_Page_(rev_1-15).docx	DOCX document	Mar 14, 2024
Attachment_2_-_IFB_Narrative_Response.docx	DOCX document	Mar 14, 2024
Event_No._0000028763,_Addendum_2_.docx	DOCX document	Mar 14, 2024

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Pricing Worksheet Key

PRICING WORKSHEET KEY

PRICING WORKSHEET TEMPLATE

(Rev 3/25/2021)

Column Number

Column 1

Column 2

Column 3

Column 4

Column 5

Column 6

Column 7

Column 8

Column 9

Column 10

Column 11

Column 12

Column Name

Contract Line Item Number (CLIN)

UNSPSC Code

Manufacturer Part Number (OEM #)

Manufacturer (OEM)

SKU # / Item #

Item Description

Unit of Measure

Quantity in

Unit of Measure

(If Applicable)	List Price/MSRP	Contract Unit Price	Contract Discount	Segment ID /Product Category/Group ID
	Description	Unique line item number.	The United Nations Standard Products and Services Code. It’s a global multi-sector standard for efficient, accurate classification of products and services.

This field should document the appropriate UNSPSC Commodity Code for each line item.

Website for codes: http://www.unspsc.org/Search.asp	Identifies manufacturer's unique identifier for a particular line item.	Identifies the manufacturer's name for each line item.	Identifies supplier's unique identifier for a particular line item.	Informational text about the commodity being purchased. Description should be descriptive enough to show the item is consistent with the specifications (high-level).	Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc).	This field will carry the number of base units in the packaging of the products
(i.e. # of pencils in a box).	An independently verifiable public price available to the general public.
	This is the contractual price for a given line item based on the price that was bid, as relative to the
unit of measure.	For commodities with a discount structure - this value represents the contractual discount off the List Price.

For commodities with a fixed price structure, discount is derived based on the following calculation: ((List Price - Contract Price)/List Price) = Contract Discount %.

This non-core identifier will uniquely categorize each commodity grouping to its respective contractual discount(s).

Format

Variable Character

Number

Variable Character

Number

Currency

Percentage

Variable Character

Example

625

43211503

PT-674344457

4576543245-JH/4567C

HP Compaq 8710p Notebook PC

BOX

$2,500.00

$1,650.00

66%

CORE - Often refers to a Fixed Price.

NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.).

END OF SHEET.

(Core & Non-Core)

Department of General Services - Procurement Division
Event ID: 0000028763, Toner/Ink Cartridges, New OEM
Attachment 1 - Pricing Worksheet, Addendum 2
Bidder:				Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
Contract Line Item # (CLIN)	Quantity	Manufacturer Name	Manufacturer Part Number (OEM #)	UNSPSC Code	SKU # / Item #	Catalog List Price/MSRP	Contract Discount	Contract Unit Price	Extension
1	4960	HP	F6U19AN	44103103			ERROR:#DIV/0!		$ - 0
2	4827	HP	C2P06AN	44103103			ERROR:#DIV/0!		$ - 0
3	4790	HP	C2P07AN	44103103			ERROR:#DIV/0!		$ - 0
4	3636	HP	3JA03AN	44103103			ERROR:#DIV/0!		$ - 0
5	6364	HP	C2P05AN	44103103			ERROR:#DIV/0!		$ - 0
6	3147	HP	3JA00AN	44103103			ERROR:#DIV/0!		$ - 0
7	3123	HP	3JA02AN	44103103			ERROR:#DIV/0!		$ - 0
8	3117	HP	3JA01AN	44103103			ERROR:#DIV/0!		$ - 0
9	2338	HP	CF237X	44103103			ERROR:#DIV/0!		$ - 0
10	1478	Brother Industries	TN450	44103103			ERROR:#DIV/0!		$ - 0
11	2110	HP	CF450A	44103103			ERROR:#DIV/0!		$ - 0
12	1796	HP	W2020A	44103103			ERROR:#DIV/0!		$ - 0
13	1658	HP	CF289X	44103103			ERROR:#DIV/0!		$ - 0
14	1398	HP	3HZ99AN	44103103			ERROR:#DIV/0!		$ - 0
15	1364	HP	CF237A	44103103			ERROR:#DIV/0!		$ - 0
16	1319	HP	W2022A	44103103			ERROR:#DIV/0!		$ - 0
17	1318	HP	CF451A	44103103			ERROR:#DIV/0!		$ - 0
18	1315	HP	W2021A	44103103			ERROR:#DIV/0!		$ - 0
19	1314	HP	CF452A	44103103			ERROR:#DIV/0!		$ - 0
20	1305	HP	W2023A	44103103			ERROR:#DIV/0!		$ - 0
21	1297	HP	CF453A	44103103			ERROR:#DIV/0!		$ - 0
22	502	[HP	CF460X	44103103]			ERROR:#DIV/0!		$ - 0
23	1226	HP	CF460X or CF460XC	44103103			ERROR:#DIV/0!		$ - 0
24	1197	HP	CF237Y or CF237YC	44103103			ERROR:#DIV/0!		$ - 0
25	362	[HP	CF237Y	44103103]			ERROR:#DIV/0!		$ - 0
26	653	[HP	W2020X	44103103]			ERROR:#DIV/0!		$ - 0
27	1174	HP	W2020X or W2020XC	44103103			ERROR:#DIV/0!		$ - 0
28	1160	HP	3HZ96AN	44103103			ERROR:#DIV/0!		$ - 0
29	1157	HP	3HZ98AN	44103103			ERROR:#DIV/0!		$ - 0
30	1154	HP	CF289A	44103103					$ - 0
31	1139	HP	3HZ97AN	44103103			ERROR:#DIV/0!		$ - 0
32	925	HP	CF410A	44103103			ERROR:#DIV/0!		$ - 0
33	916	HP	CF217A	44103103			ERROR:#DIV/0!		$ - 0
34	909	HP	W2022X or W2022XC	44103103			ERROR:#DIV/0!		$ - 0
35	895	HP	W2021X or W2021XC	44103103			ERROR:#DIV/0!		$ - 0
36	464	[HP	W2021XC	44103103]			ERROR:#DIV/0!		$ - 0
37	893	[HP	3JA03AN	44103103]			ERROR:#DIV/0!		$ - 0
38	893	HP	W2023X or W2023XC	44103103			ERROR:#DIV/0!		$ - 0
39	459	[HP	W2023XC	44103103]			ERROR:#DIV/0!		$ - 0
40	834	[HP	CF461X	44103103]			ERROR:#DIV/0!		$ - 0
41	2175	HP	CF461X or CF461XC	44103103			ERROR:#DIV/0!		$ - 0
42	833	[HP	CF462X	44103103]			ERROR:#DIV/0!		$ - 0
43	824	HP	3YL65AN	44103103			ERROR:#DIV/0!		$ - 0
44	819	[HP	CF463X	44103103]			ERROR:#DIV/0!		$ - 0
45	809	HP	3JA04AN	44103103			ERROR:#DIV/0!		$ - 0
46	789	Sharp Electronics	MX61NTBA	44103103			ERROR:#DIV/0!		$ - 0
47	788	HP	SU967A	44103103			ERROR:#DIV/0!		$ - 0
48	749	[HP	C2P05AN	44103103]			ERROR:#DIV/0!		$ - 0
49	703	HP	W2010A	44103103			ERROR:#DIV/0!		$ - 0
50	653	[HP	3JA02AN	44103103]			ERROR:#DIV/0!		$ - 0
51	621	[HP	3JA01AN	44103103]			ERROR:#DIV/0!		$ - 0
52	538	Sharp Electronics	MX561NT	44103103			ERROR:#DIV/0!		$ - 0
53	536	Sharp Electronics	MX61NTCA	44103103			ERROR:#DIV/0!		$ - 0
54	532	[HP	SU901A	44103103]			ERROR:#DIV/0!		$ - 0
55	521	HP	3YP00AN	44103103			ERROR:#DIV/0!		$ - 0
56	516	Sharp Electronics	MX61NTYA	44103103			ERROR:#DIV/0!		$ - 0
57	516	Sharp Electronics	MX61NTMA	44103103			ERROR:#DIV/0!		$ - 0
58	510	Lexmark	58D1U00	44103103			ERROR:#DIV/0!		$ - 0
59	1037	HP	CF287X or CF287XC	44103103			ERROR:#DIV/0!		$ - 0
60	383	[HP	CF287X	44103103]			ERROR:#DIV/0!		$ - 0
61	1018	HP	CF258X or CF258XC	44103103			ERROR:#DIV/0!		$ - 0
62	436	[HP	CF258X	44103103]			ERROR:#DIV/0!		$ - 0
63	309	HP	SV098A	44103103			ERROR:#DIV/0!		$ - 0
64	330	HP	C8765WN	44103103			ERROR:#DIV/0!		$ - 0
65	332	Brother Industries	TN-430	44103103			ERROR:#DIV/0!		$ - 0
66	341	HP	CE285A or CE285AC	44103103			ERROR:#DIV/0!		$ - 0
67	124	[HP	CE285AC	44103103]			ERROR:#DIV/0!		$ - 0
68	352	HP	CE270A	44103103			ERROR:#DIV/0!		$ - 0
69	391	[HP	CF410X	44103103]			ERROR:#DIV/0!		$ - 0
70	396	HP	CR314FN	44103103			ERROR:#DIV/0!		$ - 0
71	420	Xerox	006R01513	44103103			ERROR:#DIV/0!		$ - 0
72	427	HP	C8766WN	44103103			ERROR:#DIV/0!		$ - 0
73	427	HP	51645A	44103103			ERROR:#DIV/0!		$ - 0
74	427	[HP	CE255X	44103103]			ERROR:#DIV/0!		$ - 0
75	436	[HP	CE505A	44103103]			ERROR:#DIV/0!		$ - 0
76	466	HP	L0S52AN	44103103			ERROR:#DIV/0!		$ - 0
77	485	HP	CN050AN	44103103			ERROR:#DIV/0!		$ - 0
78	655	HP	C9364WN	44103103			ERROR:#DIV/0!		$ - 0
79	1552	Brother Industries	TN-460	44103103			ERROR:#DIV/0!		$ - 0
80	567	HP	3YL64AN	44103103			ERROR:#DIV/0!		$ - 0
81	564	HP	3YL63AN	44103103			ERROR:#DIV/0!		$ - 0
82	561	HP	3YL62AN	44103103			ERROR:#DIV/0!		$ - 0
83	1620	HP	CE340A or CE340AC	44103103			ERROR:#DIV/0!		$ - 0
84	540	[HP	CE340AC	44103103]			ERROR:#DIV/0!		$ - 0
85	597	HP	CE505A or CE505AC	44103103			ERROR:#DIV/0!		$ - 0
86	199	[HP	CE505A	44103103]			ERROR:#DIV/0!		$ - 0
87	473	[HP	W2022XC	44103103]			ERROR:#DIV/0!		$ - 0
88	406	[HP	CF226XC	44103103]			ERROR:#DIV/0!		$ - 0
89	783	HP	CF226X or CF226XC	44103103			ERROR:#DIV/0!		$ - 0
90	1425	HP	CF258A	44103103			ERROR:#DIV/0!		$ - 0
91	1030	HP	CF289Y or CF289YC	44103103			ERROR:#DIV/0!		$ - 0
92	821	[HP	CF289Y	44103103]			ERROR:#DIV/0!		$ - 0
93	2305	HP	CF411A	44103103			ERROR:#DIV/0!		$ - 0
94	2195	HP	CF411X or CF411XC	44103103			ERROR:#DIV/0!		$ - 0
95	439	[HP	CF411X	44103103]			ERROR:#DIV/0!		$ - 0
96	2310	HP	CF412A	44103103			ERROR:#DIV/0!		$ - 0
97	1195	HP	CF412X or CF412XC	44103103			ERROR:#DIV/0!		$ - 0
98	239	[HP	CF412X	44103103]			ERROR:#DIV/0!		$ - 0
99	2785	HP	CF413A	44103103			ERROR:#DIV/0!		$ - 0
100	334	[HP	CF413X	44103103]			ERROR:#DIV/0!		$ - 0
101	1670	HP	CF413X or CF413XC	44103103			ERROR:#DIV/0!		$ - 0
102	1045	HP	CF462X or CF462XC	44103103			ERROR:#DIV/0!		$ - 0
103	1025	HP	CF463X or CF463XC	44103103			ERROR:#DIV/0!		$ - 0
104	200	[HP	CF470X	44103103]			ERROR:#DIV/0!		$ - 0
105	965	HP	CF470X or CF470XC	44103103			ERROR:#DIV/0!		$ - 0
106	280	[HP	Q2612A	44103103]			ERROR:#DIV/0!		$ - 0
107	940	HP	Q2612A or Q2612AC	44103103			ERROR:#DIV/0!		$ - 0
108	786	HP	CE255A	44103103			ERROR:#DIV/0!		$ - 0
109	1455	HP	CE255X	44103103			ERROR:#DIV/0!		$ - 0
110	3346	HP	F6U15AN#140	44103103			ERROR:#DIV/0!		$ - 0
111	3038	HP	CN045AN#140	44103103			ERROR:#DIV/0!		$ - 0
112	1283	HP	SU220A	44103103			ERROR:#DIV/0!		$ - 0
113	1927	HP	CN049AN#140	44103103			ERROR:#DIV/0!		$ - 0
114	1435	HP	SV061A	44103103			ERROR:#DIV/0!		$ - 0
115	744	HP	CN050AN#140	44103103			ERROR:#DIV/0!		$ - 0
116	718	HP	CN052AN#140	44103103			ERROR:#DIV/0!		$ - 0
117	1357	HP	CN051AN#140	44103103			ERROR:#DIV/0!		$ - 0
118	2409	HP	CN048AN#140	44103103			ERROR:#DIV/0!		$ - 0
119	2342	HP	CN046AN#140	44103103			ERROR:#DIV/0!		$ - 0
120	2372	HP	CN047AN#140	44103103			ERROR:#DIV/0!		$ - 0
121	4733	HP	L0S67AN#140	44103103			ERROR:#DIV/0!		$ - 0
122	4684	HP	L0S61AN#140	44103103			ERROR:#DIV/0!		$ - 0
123	4575	HP	L0S64AN#140	44103103			ERROR:#DIV/0!		$ - 0
124	655	HP	SU086A	44103103			ERROR:#DIV/0!		$ - 0
125	650	HP	SU563A	44103103			ERROR:#DIV/0!		$ - 0
126	595	HP	SU352A	44103103			ERROR:#DIV/0!		$ - 0
127	1739	HP	L0S52AN#140	44103103			ERROR:#DIV/0!		$ - 0
128	2215	HP	L0S49AN#140	44103103			ERROR:#DIV/0!		$ - 0
129	2222	HP	L0S55AN#140	44103103			ERROR:#DIV/0!		$ - 0
130	964	HP	SU919A	44103103			ERROR:#DIV/0!		$ - 0
131	875	HP	CF410X or CF410XC	44103103			ERROR:#DIV/0!		$ - 0
132	298	[HP	CF410X	44103103]			ERROR:#DIV/0!		$ - 0
133	9387	HP	C2P04AN#140	44103103			ERROR:#DIV/0!		$ - 0
134	715	HP	CH563WN#140	44103103			ERROR:#DIV/0!		$ - 0
135	692	HP	SU901A	44103103			ERROR:#DIV/0!		$ - 0
136	900	Brother Industries	TN-880	44103103			ERROR:#DIV/0!		$ - 0
137	705	HP	CF281X	44103103			ERROR:#DIV/0!		$ - 0
138	672	Epson Corporation	T215530-S	44103103			ERROR:#DIV/0!		$ - 0
139	528	HP	W2011A	44103103			ERROR:#DIV/0!		$ - 0
140	525	[Sharp Electronics	MX561NT	44103103]			ERROR:#DIV/0!		$ - 0
141	516	HP	W2012A	44103103			ERROR:#DIV/0!		$ - 0
142	510	HP	W2013A	44103103			ERROR:#DIV/0!		$ - 0
143	498	HP	3YM57AN	44103103			ERROR:#DIV/0!		$ - 0
144	495	[Epson Corporation	T215530-S	44103103]			ERROR:#DIV/0!		$ - 0
145	441	Brother Industries	TN660	44103103			ERROR:#DIV/0!		$ - 0
146	438	HP	CF289A	44103103			ERROR:#DIV/0!		$ - 0
147	435	HP	F6U64AN	44103103			ERROR:#DIV/0!		$ - 0
148	411	HP	CE341A	44103103			ERROR:#DIV/0!		$ - 0
149	378	HP	SU911A	44103103			ERROR:#DIV/0!		$ - 0
150	372	HP	3YM58AN	44103103			ERROR:#DIV/0!		$ - 0
151	360	HP	CE342A	44103103			ERROR:#DIV/0!		$ - 0
152	360	HP	CE343A	44103103			ERROR:#DIV/0!		$ - 0
153	333	HP	3YM56AN	44103103			ERROR:#DIV/0!		$ - 0
154	333	HP	CF330X	44103103			ERROR:#DIV/0!		$ - 0
155	324	HP	CH564WN	44103103			ERROR:#DIV/0!		$ - 0
156	312	HP	CH561WN	44103103			ERROR:#DIV/0!		$ - 0
157	300	Canon, Inc.	8278B001	44103103			ERROR:#DIV/0!		$ - 0
158	297	HP	3YM55AN	44103103			ERROR:#DIV/0!		$ - 0
159	285	Brother Industries	TN760	44103103			ERROR:#DIV/0!		$ - 0
160	279	HP	CF472X	44103103			ERROR:#DIV/0!		$ - 0
161	270	HP	CF471X	44103103			ERROR:#DIV/0!		$ - 0
162	267	Sharp Electronics	MX51NTBA	44103103			ERROR:#DIV/0!		$ - 0
163	258	HP	CH562WN	44103103			ERROR:#DIV/0!		$ - 0
164	258	HP	W2101A	44103103			ERROR:#DIV/0!		$ - 0
165	255	HP	W2100A	44103103			ERROR:#DIV/0!		$ - 0
166	252	HP	F6U63AN	44103103			ERROR:#DIV/0!		$ - 0
167	252	HP	W1470X	44103103			ERROR:#DIV/0!		$ - 0
168	249	Canon, Inc	0473C003	44103103			ERROR:#DIV/0!		$ - 0
169	240	HP	CF473X	44103103			ERROR:#DIV/0!		$ - 0
170	228	HP	W2010X	44103103			ERROR:#DIV/0!		$ - 0
171	225	HP	CF320A	44103103			ERROR:#DIV/0!		$ - 0
172	222	HP	W2102A	44103103			ERROR:#DIV/0!		$ - 0
173	222	HP	W2103A	44103103			ERROR:#DIV/0!		$ - 0
174	216	HP	CN054AN	44103103			ERROR:#DIV/0!		$ - 0
175	216	HP	CN055AN	44103103			ERROR:#DIV/0!		$ - 0
176	204	Sharp Electronics	MX51NTCA	44103103			ERROR:#DIV/0!		$ - 0
CORE ITEMS SUBTOTAL									$ - 0
NON-CORE ITEMS (Discount entered below will be applied off the contractor's list prices)
Segment ID/Group ID	Quantity	Commodity Description	UNSPSC Code	Manufacturer Part Number (OEM #)	Manufacturer (OEM)	SKU # / Item #	Item Description	Unit of Measure	Quantity in

Unit of Measure

List Price/MSRP (for evaluation purposes)

Contract Discount

Contract Price

Extension

Unknown

Discount applied to list price of all catalog items not listed above.

N/A

5,000

$ 5,000.00

NON-CORE ITEMS SUBTOTAL:

$ 5,000.00

GRAND TOTAL:

$ 5,000.00

Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)

Note: Extension is automatically calculate by (Contract Unit Price x Quantity)

End of Sheet

Page &P

File details come from the government source that posted it. Updated Apr 2, 2024.