jagomart
digital resources
picture1_Excel Sheet Download 31126 | Hotrolledplatesteelimporterquestionnairespreadsheets


 179x       Filetype XLS       File size 0.06 MB       Source: www.industry.gov.au


File: Excel Sheet Download 31126 | Hotrolledplatesteelimporterquestionnairespreadsheets
sheet 1 part bcost to import amp sell part b cost to import and sell 1 january 2012 to 31 december 2012 hot rolled plate steel exported from the people ...

icon picture XLS Filetype Excel XLS | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Part B-Cost to Import & Sell
Part B - Cost to Import and Sell (1 January 2012 to 31 December 2012)


























Hot rolled plate steel - exported from the People's Republic of China, the Republic of Korea, Japan, Indonesia and Taiwan


























IMPORTER DETAILS:


























Importer












Company Name:












Address:


























Invoice details
SHIPMENT 1 SHIPMENT 2 SHIPMENT 3 SHIPMENT 4 SHIPMENT 5 SHIPMENT 6 SHIPMENT 7 SHIPMENT 8 SHIPMENT 9 SHIPMENT 10 SHIPMENT 11 SHIPMENT 12
Customs entry number












Country of origin












Supplier name












Order number












Order confirmation date












Invoice number












Invoice date












Credit terms












Terms of sale (e.g. C&F, FOB)












No. of containers












Product type












Quantity (tonnes)












Packaging type












Invoice price












Invoice currency












Rate of exchange












Invoice price ($AU)












Invoice price ($AU/T)


























Shipment costs












Bill of lading number












Overseas freight (specify currency)












Overseas freight ($AU)












Insurance (specify currency)












Insurance ($AU)












FOB Price (in $AU)












FOB Price ($AU/tonne)


























Australian Importation Costs (excl GST)












Customs entry fee












Customs brokers fees












Quarantine charges












Fumigation












Wharf storage












Port service charges












Delivery












Tailgate












Bank charges












Any other costs (please list each item)












Total importation costs












Unit importation costs ($AU/T)


























Selling, general and admin costs












Estimate of SG&A costs as % of sales revenue












Other (please list each item)


























TOTAL COST TO IMPORT AND SELL


























Selling price (if available on per shipment basis)












Customer 1 (name)












Customer 1 (date of sale)












Customer 1 (invoice value)












Customer 1 (quantity)


























Customer 2 (name)












Customer 2 (date of sale)












Customer 2 (invoice value)












Customer 2 (quantity)


























Total revenue for shipment












Unit revenue for shipment


























Profit












Total profit for shipment ($A)












Unit profit for shipment ($A/tonne)









































Sheet 2: Part B - Forward Orders
Part B – Forward Orders














Hot rolled plate steel - exported from the People's Republic of China, the Republic of Korea, Japan, Indonesia and Taiwan














Supplier Shipping terms Expected arrival date Volume (Tonnes) Quantity (pieces) Product/ model/ description Total price Unit price

















































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet part bcost to import amp sell b cost and january december hot rolled plate steel exported from the people s republic of china korea japan indonesia taiwan importer details company name address invoice shipment customs entry number country origin supplier order confirmation date credit terms sale eg c f fob no containers product type quantity tonnes packaging price currency rate exchange au aut costs bill lading overseas freight specify insurance in autonne australian importation excl gst fee brokers fees quarantine charges fumigation wharf storage port service delivery tailgate bank any other please list each item total unit selling general admin estimate sg a as sales revenue if available on per basis customer value for profit atonne forward orders ndash shipping expected arrival volume pieces model description...

no reviews yet
Please Login to review.