ATTACHMENT_3_COST_WORKSHEET.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
ENVELOPES (ASSORTMENT) (DGS/OTA)
Solicitation number
0000037164
Issued by
California

About this file

This is a Cost Worksheet template for the California Department of General Services, Procurement Division, for an Envelopes (Assortment) solicitation under Business Unit 7600, Event ID 0000037164. The procurement encompasses twelve line items for various window and non-window envelopes in multiple sizes and specifications. The quantities requested are substantial, ranging from 202,500 thousand to 15,624,000 thousand units across different envelope types, with specifications including envelope dimensions, window sizes and positions, construction details (such as seam type and flap style), and material composition including the requirement for 30% Post-Consumer Recycled Content (PCRC). The line items include #9, #11, and booklet-style envelopes in white or brown kraft with various interior tint options, latex seals, and black printing on select items. Bidders must complete only the yellow input cells, providing unit costs and extension costs for each line item, with the extension cost automatically calculated by multiplying the contract unit price by the quantity ordered.

The cost worksheet requires bidders to include both shipping and handling costs in their unit and extended cost submissions. Bids must be submitted in physical form, as electronic submissions are not permitted for this event. All pricing should be based on the location of shipment, with sales tax calculated accordingly if multiple locations are involved. The procurement official for this solicitation is Evonne Rogers, with Sophanna Lim listed as the backup contact. Bidders should reference the complete Event package for specific submission instructions, due dates, and additional procurement requirements prior to submitting their bids.

View the file

Other files

Show all 19

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 Key

PRICING WORKSHEET KEY
COST WORKSHEET TEMPLATE

(Rev 8/30/2022)

NOTE TO Buyers:

This template is to be used as a guide for Buyers developing cost worksheets for one-time solicitations (IFBs or RFQs). Buyerss are required to review the following information before developing cost worksheets.

● The columns below represent POSSIBLE data fields that could be required in a cost worksheet.

● Each Cost Worksheet should have a worksheet for field definitions or clear completion instructions within the solicitation.

● For ADA Purposes: Provide a data validation input message for every cell (be as descriptive as possible) in the table and every input cell; lock/unlock cells where appropriate; do not merge or split cells within a table; delete or hide all unused rows and columns; rename workbook tabs (be as descriptive as possible); write "End of Sheet" or "End of Worksheet" in the last row for each sheet; set print area; prior to posting, protect sheet allowing "select locked cells" and "select unlocked cells" only.

***Delete these instructions before release***

Column NameContract Line Item Number (CLIN)
Unit of MeasureManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Proposed Product DescriptionContract Unit Price
DescriptionUnique line item number.Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc).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).This is the contractual price for a given line item based on the price that was bid, as relative to the

unit of measure.

END OF SHEET.
END OF SHEET.

Cost Worksheet

Department of General Services - Procurement Division
BU 7600, Event ID 0000037164, OSP /ENVELOPES
Attachment 3 - Cost Worksheet
Bidder:Blank
Instructions: Unit and Extended Cost must include both shipping and handling costs. Refer to IFB Cost Worksheet language for completion instructions. Bidder must complete the Yellow Input Cells only.
Line Item #QuantityUnit of MeasureCommodity DescriptionEnvelope Size in InchesWindow Sizes & Positions, in inchesDiagram NumberProposed Product DescriptionUnit CostExtension Cost
1-1448,000THMCC150103, #11 window envelope, white, black inside tint, sub 24, Class 1, latex seal, flat top flap, 30% PCRC4½ x 10 &
3/81 & 1/8 x 4½ 7/8 from left and
½ from bottom$ - 0
1-2600,000THMCC150104, Catalog window envelope, white, black inside tint, center seam construction, sub 28, Class 3, latex seal, wallet flap, 30% PCRC9 x 11¼1 & 5/16 x 3½
½ from left and 7¾ from bottom$ - 0
1-3225,500THMCC150107, Booklet window envelope, brown Kraft, black inside tint, center seam construction, sub 28, Class 2, wallet flap, black print on
face, folds in half, 30% PCRC9 x 121¾ x 5 & 1/8 3½ from left and ¾ from bottom$ - 0
1-4500,000THCC150066, #11 envelope, white, blue inside tint, diagonal seam construction, sub 24, Class 1,
rounded top flap, 30% PCRC4½ x 10 &
3/8Plain without window$ - 0
1-55,000,000THMCC150061, Booklet window envelope, white, blue inside tint, side seam construction, sub 28, Class 2, black print on face Diagram #9 (print message and indicia), Diagram #10 (print indicia
only), Diagram #11 (print message only), 30% PCRC6 x 9½2 & 5/8 x 4¼ 7/8 from left and 2½ from bottom$ - 0
1-6960,000THMCC150071, #9 window envelope, white, diagonal seam construction, sub 24, Class 1, rounded top flap,
black print on face, 30% PCRC3 & 7/8 x
8 & 7/81 & 1/8 x 4½ 7/8 from left and
½ from bottom$ - 0
1-7202,500THMCC150062, Booklet window envelope, white, blue inside tint, side seam construction, sub 28, Class 2,
black print on face, 30% PCRC9 x 124¼ x 3¼

8 from left and 3 & 7/8 from

bottom$ - 0
1-82,016,000THMCC150075, Booklet window envelope, white, blue inside tint, side seam construction,
sub 28, Class 2, 30% PCRC6 x 9½2 & 5/8 x 4¼ 7/8 from left and 2½ from bottom$ - 0
1-9960,000THMCC150063, #9 envelope, white, blue inside tint, diagonal seam construction, sub 24, Class 1, pointed
top flap, 30% PCRC3 & 7/8 x
8 & 7/8plain without window$ - 0
1-1015,624,000THMCC150061, #28 Booklet spec Win Printed, inside tint ***RED LABEL***6 x 9½$ - 0
1-111,512,000THMCC150061, #28 Booklet spec Win Printed, inside tint ***YELLOW LABEL***6 x 9½$ - 0
1-129,030,000THMCC150061, #28 Booklet spec Win Printed, inside tint ***GREEN LABEL***6 x 9½$ - 0
Subtotal:$ - 0
Sales Tax:$ - 0
Total Cost:$ - 0
Note: Extension is automatically calculated (Contract Unit Price x Quantity)
End of Sheet
SALES TAX BASED ON LOCATION OF SHIPMENT
IF MULTIPLE LOCATIONS USE AVERAGE

Page &P

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