We are a freight and logistics organisation based in Malawi, Africa.
We arrange logistics and shipment of cargo to and from rest of the World and Malawi. Malawi is a landlocked country with no direct access to sea coast.
The cargo is usually packed into shipping containers and various means of transportation is used including/combination, air, sea, road and rail. Various services are provided by numerous service providers.
All the shipments have to be tracked through various phases of the journey and record kept of any changes in shipment status. All changes amendments to be recorded and note to be kept of reason for changes,
Possibility of attaching correspondence on particular shipment.
Record of any reason for delay of shipment at Port of Load, Port of Transhipment, delay sin oncarrier vessel from Port of Transhipment to Port of Discharge etc to be entered and reason for same to be attached.
Documents have to be sent to the relevant agents at origin port, transhipment port, destination port for clearance. A record to be kept on date each document was sent depending on the type of shipment.
I have attached a sample report y Port of Discharge attached. We have a separate excell sheet for each port of Discharge/Import and Port of Load/Export. The reports are then used to sort data out by customer and we then copy/paste onto new worksheet to report to individual customers.
However at present we are unable to track changes, attach files/correspondence, keep record of changes on shipment caused by delays due to many different reasons.
Report on Shipments/Containers by
- Containers Arrived Destination
- Under Clearance
- Awaiting Delivery
- Awaiting Empty Turn IN
- KPI's (Shipments approaching KPI's and/or missed KPI's alerts for same)
- Track Changes made in Cells
- Possiblility to embed/attach a link/file/email for supporting documents
- Prepare Shipment/Container Release Form
- Prepare Shipment Details Cover Form
*Beira Status, *Nacala, *Anchor (Client Report), *Camy Soap (Client Report)
We current use above Excell sheets to populate data. and then cut and past to prepare
individual customer reports.
Shipment Status - provides summary and templates of reports we would want from this
19 freelancers are bidding on average £1342 for this job
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards.
Hi, there i read your initial requirements and i have some question regarding to your flight tracking [login to view URL] can we discuss it on chat ?
Hello! You need a complete system to track all of this. My quote includes all features for tracking and communication for your shipping business. Regards, Joseph Cardwell