Att_12_-_Blank_Pricing_Spreadsheet.xlsx

21 KB Posted

Attached to
Dive Support Boats
Solicitation number
N00024-14-R-2232
Issued by

About this file

From the source

Attachment 12 - Blank Pricing Spreadsheet

View the file

Other files

File Type Posted
Solicitation_14R2232_Q A_Amended_4.29.14.pdf PDF
Solicitation_14R2232_Q A_Update_4.29.14.pdf PDF
N00024-14-R-2232-MOD_0002_Extension.pdf PDF
Solicitation_14R2232_Q A_Update_4.22.pdf PDF
Solicitation_14R2232_Q A_Update_4.17.14.pdf PDF
Solicitation_Add_Att_Q A.pdf PDF
N00024-14-R-2232-0001.pdf PDF
NSWCCD_AEA_Tech_Guidance_(4th_Ed_-_2012).zip ZIP file
Att_03_-_Embarked_Equipment_and_Unique_Dive_Features_6Mar2014.pdf PDF
Att_04_-_Notional_Dive_Support_Boat_Arrangement_13Feb2014.pdf PDF
N00024-14-R-2232_Solicitation.pdf PDF
Att_10_-_ID_of_Non-Commercial_Data_(Updated_10-10-13).doc DOC document
Att_11_-_ID_of_Commercial_Data_(Updated_10-10-13).doc DOC document
Att_06_-_Electrical_One_Line_Drawing_23Jan2014.pdf PDF
Att_09_-_Past_Performance.doc DOC document
Att_08_-_Offeror_Commercial_Warranty.docx DOCX document
Att_07_-_Unique_Item_Identification_13Mar2014.doc DOC document
Att_02_-_Initial_Spare_Parts_List_4Feb14.pdf PDF
Att__1_-_DS_Boat_Specification_Rev_-__19Mar2014.docx DOCX document
Att_05_Electrical_Load_Analysis_sample_20Feb14.pdf PDF
Response_to_Dive_Boat_questions_21_Mar_14.pdf PDF
Att__3_-_Embarked_Equipment_and_Unique_Dive_Features_23Jan2014.pdf PDF
Att__4_-_Notional_Dive_Support_Boat_Arrangement_13Feb2014.pdf PDF
FY14_DSB_SOW_Rev_2_2014_03_05.docx DOCX document
Att__1_-_DS_Boat_Specification_revdraft_26Feb2014.docx DOCX document
Show all 25

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.

EXAMPLE Formulas TO BE DELETED

EXAMPLE VOLUME II COST PROFILE
CLINUnit PriceMax Qty.Extended PriceCLINCost to Ship 1 BoatCost to Ship 2 BoatsCost to Ship 3 BoatsExtended Price*
1001$ 100.003$ 300.001006$ 100.00$ 200.00$ 300.00$ 300.00
10021007$ 1.00$ 2.00$ 3.00$ 3.00
10032006$ 100.00$ 200.00$ 300.00$ 300.00
10042007$ 1.00$ 2.00$ 3.00$ 3.00
10053006$ 200.00$ 300.00$ 400.00$ 600.00
10083007$ 2.00$ 3.00$ 4.00$ 6.00
10094006$ 200.00$ 300.00$ 400.00$ 600.00
10104007$ 2.00$ 2.00$ 4.00$ 6.00
2001$ 101.003$ 303.005006$ 300.00$ 400.00$ 500.00$ 900.00
20025007$ 3.00$ 4.00$ 5.00$ 9.001 East Boat
2003Total$ 2,727.00$ 400.00
2004*Extended price is 3 multiplied by the lowest quantity shipping cost
2005
2008East Coast Delivery
2009QtyShipping CostShipping Cost / Boat
2010Base (1006)2$ 200.00$ 100.00$ 400.00
3001$ 102.003$ 306.00Opt 1 (2006)2$ 200.00$ 100.00
3002Opt 2 (3006)2$ 300.00$ 150.00
3003Opt 3 (4006)1$ 200.00$ 200.00
3004Opt 4 (5006)1$ 300.00$ 300.00
3005$ 170.00
3008
3009West Coast Delivery
3010QtyShipping CostShipping Cost / Boat
4001$ 103.003$ 309.00Base (1007)1$ 1.00$ 1.00
4002Opt 1 (2007)1$ 1.00$ 1.00
4003Opt 2 (3007)1$ 2.00$ 2.00
4004Opt 3 (4007)2$ 2.00$ 1.00
4005Opt 4 (5007)2$ 4.00$ 2.00
4008$ 1.40
4009
4010Total Contract
5001$ 104.003$ 312.00Non Shipping CLINs$ 1,530.00
5002Shipping CLINS$ 2,727.00
5003$ 4,257.00
5004
5005Note: Items highlighted in Yellow will be used to assess cost of Production and Delivery
5008Items highlighted in Blue will be used to assess total contract cost
5009
5010
Total$ 1,530.00

EXAMPLE Spreadsheet

EXAMPLE VOLUME II COST PROFILE
CLINUnit PriceMax Qty.Extended PriceCLINCost to Ship 1 BoatCost to Ship 2 BoatsCost to Ship 3 BoatsExtended Price*
1001$ 100.003$ 300.001006$ 100.00$ 200.00$ 300.00$ 300.00
10021007$ 1.00$ 2.00$ 3.00$ 3.00
10032006$ 100.00$ 200.00$ 300.00$ 300.00
10042007$ 1.00$ 2.00$ 3.00$ 3.00
10053006$ 200.00$ 300.00$ 400.00$ 600.00
10083007$ 2.00$ 3.00$ 4.00$ 6.00
10094006$ 200.00$ 300.00$ 400.00$ 600.00
10101$ 100,000.004007$ 2.00$ 2.00$ 4.00$ 6.00
10115006$ 300.00$ 400.00$ 500.00$ 900.00
2001$ 101.003$ 303.005007$ 3.00$ 4.00$ 5.00$ 9.00
2002Total$ 2,727.00
2003*Extended price is 3 multiplied by the lowest quantity shipping cost
2004
2005East Coast Delivery
2008QtyShipping CostShipping Cost / Boat
2009Base (1006)2$ 200.00$ 100.00
20101$ 100,000.00Opt 1 (2006)2$ 200.00$ 100.00
3001$ 102.003$ 306.00Opt 2 (3006)2$ 300.00$ 150.00
3002Opt 3 (4006)1$ 200.00$ 200.00
3003Opt 4 (5006)1$ 300.00$ 300.00
3004$ 170.00
3005
3008West Coast Delivery
3009QtyShipping CostShipping Cost / Boat
30101$ 100,000.00Base (1007)1$ 1.00$ 1.00
4001$ 103.003$ 309.00Opt 1 (2007)1$ 1.00$ 1.00
4002Opt 2 (3007)1$ 2.00$ 2.00
4003Opt 3 (4007)2$ 2.00$ 1.00
4004Opt 4 (5007)2$ 4.00$ 2.00
4005$ 1.40
4008
4009Total Contract
40101$ 100,000.00Non Shipping CLINs$ 501,530.00
5001$ 104.003$ 312.00Shipping CLINS$ 2,727.00
5002$ 504,257.00
5003
5004Note: Items highlighted in Yellow will be used to assess cost of Production and Delivery
5005Items highlighted in Blue will be used to assess total contract cost
5008
5009
50101$ 100,000.00
Total$ 501,530.00

Blank Pricing Spreadsheet

EXAMPLE VOLUME II COST PROFILE
CLINUnit PriceMax Qty.Extended PriceCLINCost to Ship 1 BoatCost to Ship 2 BoatsCost to Ship 3 BoatsExtended Price*
10011006
10021007
10032006
10042007
10053006
10083007
10094006
10104007
10115006
20015007
2002Total
2003*Extended price is 3 multiplied by the lowest quantity shipping cost
2004
2005East Coast Delivery
2008Qty**Shipping CostShipping Cost / Boat
2009Base (1006)2
2010Opt 1 (2006)2
3001Opt 2 (3006)2
3002Opt 3 (4006)1
3003Opt 4 (5006)1
3004
3005**Shipping Locations and Quantities are estimates
3008
3009West Coast Delivery
3010Qty**Shipping CostShipping Cost / Boat
4001Base (1007)1
4002Opt 1 (2007)1
4003Opt 2 (3007)1
4004Opt 3 (4007)2
4005Opt 4 (5007)2
4008
4009**Shipping Locations and Quantities are estimates
4010
5001Total Contract
5002Non Shipping CLINs
5003Shipping CLINS
5004
5005
5008Note: Items highlighted in Yellow will be used to assess cost of Production and Delivery
5009Items highlighted in Blue will be used to assess total contract cost
5010
Total

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