Attachment 8B Excel Collection Tool

International Price Program U.S. Import and Export Price Indexes

Attachment 8B.xlsx

OMB: 1220-0025

Document [xlsx]
Download: xlsx | pdf

Overview

Exports
Imports
Procedures


Sheet 1: Exports
















Import/Export Item Price Survey













U.S. Department of Labor













Bureau of Labor Statistics













International Price Program





























Export Prices




























Mr. Tester













ipp.helpdesk@bls.gov



























Item Code Item Description Provide Current Price for July 2023 Estimated / Not Traded Discontinued / Replaced Reasons for Price Change / Other Comments Country of Destination Currency Unit of Sale Price Basis Transaction Type Discounts / Surcharges Class of Seller 10-Digit ScheduleB Price Specific to Quantity Ordered?
D3422842 Item Description: Make any updates or corrections to the item description here. Please use a color other than black and explain the changes in the 'Reasons for Price Change/Other Comments' field to the right. EXPORT Dummy Reporter 5/Item 1 for hedonic repricing 0.0000

Comments: If price has changed, please explain why here. Also note any other comments related to changes in the item description or other price factors.
Country: Please make changes if needed and note reasons in 'Comments' box to the left. CHINA/HONG KONG Currency: Please make changes if needed and note reasons in 'Comments' box to the left. INDEX Unit of Sale: Please make changes if needed and note reasons in 'Comments' box to the left. EACH Price Basis: This indicates the shipping terms associated with the wholesale transaction. Please make changes if needed and note reasons in 'Comments' box to the left. Please provide. Market Sale Discounts/Surcharges: Enter any discounts or surcharges associated with the transaction in dollar or percent format. Note whether or not it is included in the price in the 'Comments' box to the left.
Class of Seller: If the seller is affiliated with your company, note affiliation here. CLASS DOES NOT AFFECT THE PRICE Schedule B: Note the 10-digit Schedule B number reported to U.S. Customs, if known. Please provide ScheduleB if known. Price Specific to Quantity: If the price is specific to the quantity ordered, enter the related quantity here. When price changes due to a change in quantity, adjust quantity and note reason in 'Comments' box.
D5812641 Item Description: Make any updates or corrections to the item description here. Please use a color other than black and explain the changes in the 'Reasons for Price Change/Other Comments' field to the right. EXPORT TEST 1/16/2020 0.0000

Comments: If price has changed, please explain why here. Also note any other comments related to changes in the item description or other price factors.
Country: Please make changes if needed and note reasons in 'Comments' box to the left. AUSTRIA/SWITZERLAND Currency: Please make changes if needed and note reasons in 'Comments' box to the left. UK POUND Unit of Sale: Please make changes if needed and note reasons in 'Comments' box to the left. DOZEN Price Basis: This indicates the shipping terms associated with the wholesale transaction. Please make changes if needed and note reasons in 'Comments' box to the left. Please provide. Intra Company Transfer: Cost-based Pricing Discounts/Surcharges: Enter any discounts or surcharges associated with the transaction in dollar or percent format. Note whether or not it is included in the price in the 'Comments' box to the left.
Class of Seller: If the seller is affiliated with your company, note affiliation here. CLASS DOES NOT AFFECT THE PRICE Schedule B: Note the 10-digit Schedule B number reported to U.S. Customs, if known. B2222111111 Price Specific to Quantity: If the price is specific to the quantity ordered, enter the related quantity here. When price changes due to a change in quantity, adjust quantity and note reason in 'Comments' box.















Please click on the green 'Imports' tab located on the bottom left of the screen to provide us with your import price information.













Click on the blue 'Procedures' tab located on the bottom left of the screen to aid you in completing the form.













Thank you.





























































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 2: Imports

















Import/Export Item Price Survey














U.S. Department of Labor














Bureau of Labor Statistics














International Price Program































Import Prices






























Mr. Tester














ipp.helpdesk@bls.gov





























Item Code Item Description Provide Current Price for July 2023 Estimated / Not Traded Discontinued / Replaced Reasons for Price Change / Other Comments Country of Import Currency Unit of Sale Price Basis Transaction Type Discounts / Surcharges Duty Class of Buyer 10-Digit HTSUSA Price Specific to Quantity Ordered?
D3021831 Item Description: Make any updates or corrections to the item description here. Please use a color other than black and explain the changes in the 'Reasons for Price Change/Other Comments' field to the right. IMPORT Dummy Reporter 5/Item 2 for Web Repricing. 0.0000

Comments: If price has changed, please explain why here. Also note any other comments related to changes in the item description or other price factors.
Country: Please make changes if needed and note reasons in 'Comments' box to the left. AFRICA (EXCL. SOUTH AFRICA) Currency: Please make changes if needed and note reasons in 'Comments' box to the left. EURO Unit of Sale: Please make changes if needed and note reasons in 'Comments' box to the left. SQUARE Price Basis: This indicates the shipping terms associated with the wholesale transaction. Please make changes if needed and note reasons in 'Comments' box to the left. Please provide. Intra Company Transfer: Market-based Pricing Discounts/Surcharges: Enter any discounts or surcharges associated with the transaction in dollar or percent format. Note whether or not it is included in the price in the 'Comments' box to the left.
Duty: If there is a duty included in this transaction, enter it here.
Class of Buyer: If the buyer is affiliated with your company, note affiliation here.
HTSUSA: Note the 10-digit HTSUSA number reported to U.S. Customs, if known. T111122111 Price Specific to Quantity: If the price is specific to the quantity ordered, enter the related quantity here. When price changes due to a change in quantity, adjust quantity and note reason in 'Comments' box. 3
D7970936 Item Description: Make any updates or corrections to the item description here. Please use a color other than black and explain the changes in the 'Reasons for Price Change/Other Comments' field to the right. EXPORT Dummy Reporter 5/Item 3 for Web. 6 inch wafer cost of mod edit 0.0000

Comments: If price has changed, please explain why here. Also note any other comments related to changes in the item description or other price factors.
Country: Please make changes if needed and note reasons in 'Comments' box to the left. AFRICA/PERU/SPAIN Currency: Please make changes if needed and note reasons in 'Comments' box to the left. UK POUND Unit of Sale: Please make changes if needed and note reasons in 'Comments' box to the left. BAG Price Basis: This indicates the shipping terms associated with the wholesale transaction. Please make changes if needed and note reasons in 'Comments' box to the left. Please provide. Other Non-Market based Pricing Discounts/Surcharges: Enter any discounts or surcharges associated with the transaction in dollar or percent format. Note whether or not it is included in the price in the 'Comments' box to the left.
Duty: If there is a duty included in this transaction, enter it here.
Class of Buyer: If the buyer is affiliated with your company, note affiliation here.
HTSUSA: Note the 10-digit HTSUSA number reported to U.S. Customs, if known. T9999999999 Price Specific to Quantity: If the price is specific to the quantity ordered, enter the related quantity here. When price changes due to a change in quantity, adjust quantity and note reason in 'Comments' box. 100
D8057249 Item Description: Make any updates or corrections to the item description here. Please use a color other than black and explain the changes in the 'Reasons for Price Change/Other Comments' field to the right. IMPORT TEST 1/16/2020 0.0000

Comments: If price has changed, please explain why here. Also note any other comments related to changes in the item description or other price factors.
Country: Please make changes if needed and note reasons in 'Comments' box to the left. SINT MAARTEN Currency: Please make changes if needed and note reasons in 'Comments' box to the left. U.S. DOLLAR Unit of Sale: Please make changes if needed and note reasons in 'Comments' box to the left. DRUM Price Basis: This indicates the shipping terms associated with the wholesale transaction. Please make changes if needed and note reasons in 'Comments' box to the left. Please provide. Market Sale Discounts/Surcharges: Enter any discounts or surcharges associated with the transaction in dollar or percent format. Note whether or not it is included in the price in the 'Comments' box to the left.
Duty: If there is a duty included in this transaction, enter it here.
Class of Buyer: If the buyer is affiliated with your company, note affiliation here. Sister company HTSUSA: Note the 10-digit HTSUSA number reported to U.S. Customs, if known. Please provide HTSUSA if known. Price Specific to Quantity: If the price is specific to the quantity ordered, enter the related quantity here. When price changes due to a change in quantity, adjust quantity and note reason in 'Comments' box. 100
















Please click on the red 'Exports' tab located on the bottom left of the screen to provide us with your export price information.














Click on the blue 'Procedures' tab located on the bottom left of the screen to aid you in completing the form.














Thank you.















































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 3: Procedures

U.S. Department of Labor









OMB No. 1220-0025

Bureau of Labor Statistics









(expires: April 30, 2025)

International Price Program






























Import/Export Item Price Survey






















The Bureau of Labor Statistics, its employees, agents, and partner statistical agencies, will use the information you provide for statistical purposes only and will hold the information












in confidence to the full extent permitted by law. In accordance with the Confidential Information Protection and Statistical Efficiency Act (44 U.S.C. 3572) and other applicable












Federal laws, your responses will not be disclosed in identifiable form without your informed consent. Per the Federal Cybersecurity Enhancement Act of 2015, Federal information












systems are protected from malicious activities through cybersecurity screening of transmitted data.












Paperwork Reduction Act Public Burden Statement: We estimate that completing each form will take an average of 5 minutes (varying from 1 to 30 minutes). This estimate takes












into account time for reviewing instructions, searching existing data sources, gathering and maintaining the necessary data, and completing and reviewing the information. The












obligation to respond to this collection is voluntary. If you have any comments regarding this estimate or any other aspects of this information collection, including suggestions for












reducing this burden, you may send them to the Bureau of Labor Statistics by email to BLS_PRA_Public@bls.gov. The OMB control number for IPP's survey is 1220-0025. Without a












currently valid OMB number BLS would not be able to conduct this survey.


























The attached survey asks you to report current price information for select items. This survey is designed to measure changes in U.S. import and export












prices. If you have any questions, please contact the analyst indicated in the body of the email. For further information on the International Price Program












and how your data is being used, please visit our website at http://www.bls.gov/mxp. Thank you for your cooperation.


























Instructions on Saving and Attaching Your Data:












After entering/revising your data, go to 'File' and 'Save As'. Please leave the file name unchanged and save it to a location on your hard drive.












Next, reply to the to the original email this spreadsheet was attached to and insert the saved file from your hard drive.


























Item Code: This code is used for internal purposes by IPP.


























Item Description: This is a description of the item you are providing an import/export price for.


























Country of Destination (Export Items Only): Please provide price information for items exported to the specified destination only. If you previously












indicated that the price charted to buyers was the same regardless of destination, 'World' will appear as the destination for exports.


























Country of Import (Import Items Only): Please provide price information for items imported to the specified destination only.


























Currency: The currency used to price this item.


























Unit of Sale: The unit of measurement used to price this item. (e.g., per pound, each, dozen, case)


























Price Basis: Indicates the shipping terms used to complete the transaction. Some examples include: CIF U.S. Port, FOB Foreign Port for imports,












and FAS/FOB Port, FOB Border, FPB Factory, FAF (Fly Away Factory), DAF (Delivered at Frontier) for exports.


























Intracompany Transfer: Is this a transaction between two related companies? (e.g., between a subsidiary and parent company) If so, please enter












yes', if not, enter 'no.'


























Discounts/Surcharges: Please indicate discounts or surcharges (quantity discount, commission, fuel surcharge, etc.) and the percentage or dollar amount












of each. Please specify whether you have already deducted the discount from the price you provided or whether you have already added the surcharge.


























Duty (Import Items Only): Please indicate any duty that in included in the price in the form of a dollar amount.


























Class of Buyer/Seller: Please provide the Class of Buyer (Export Items) or Seller (Import Items) if the class affects the price. Examples of Classes of












Buyer/Seller include Parent Company, Affiliate, Subsidiary Sister Company, Distributor, Dealer, End User, etc. If the price does not vary with different












buyers or sellers, please enter 'Class does not affect the price.'


























10-Digit HTSUSA (Import Items Only)/Schedule B (Export Items Only): The 10-digit number from the Harmonized Tariff Schedule of the U.S. Annotated












or Schedule B under which you import or export this item.


























Is Price Specific to Quantity Ordered?: Does the price vary according to the quantity ordered? If so, please indicate a quantity for which you will












consistently provide price information.


























Current Price: Transaction prices are preferred, however, we do accept intracompany, average and estimated prices. Transaction prices are prices at












which you actually bought the item (imports) or sold the item (exports).


























Estimated/Not Traded: If the item was not traded this month, please enter 'Estimated' in the field. If you cannot provide an estimated price, then please












enter 'NT' in the field.


























Discontinued/Replaced: If the item has been discontinued and replaced by a new item, please enter 'Replaced' in the field and enter












description and related information in the row below the discontinued item row. Enter the reason for the replacement in the 'Reasons for Price Change' field.












If the item has been discontinued and there is no replacement item available, please enter 'Discontinued, No Replacement' in the field and provide












the reason for the discontinuation in the 'Reasons for Price Change' field.












enter 'NT' in the field.












Please contact the analyst listed at the phone number/email address in the email to provide more specific information regarding the discontinuation, if you wish.


























Reasons for Price Change: If the current price differs from the last reported price, please indicate why the price has changed.








































Thank you for your participation in this survey! Your information is very important to us. Please do not hesitate to contact the analyst with any












questions or concerns about the survey:


























Jill Craven












(202) 691-7099












craven_j@mailgate.bls.gov












File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy