Container Utilization Data Project
For this challenge, you may be utilizing the info offered on this module entitled “Container Assessment Data.” The aim of this Assessment is to show you pivot tables, actual world knowledge examples, and so that you can perceive how one can “inform a narrative with knowledge!”
It is a challenge that I needed to full whereas working within the trade and may be very related to knowledge that will be handed to you in a real-world state of affairs.
When submitting this task, make sure you WORK ALONE, submit each the excel sheet and your phrase doc with display pictures if needed.
You will want the next data to finish this task.
Max Weight and Dice and transport container sizes
Container Dimension Tare (Container) Weight Max Weight Max Dice in Meters Max Dice in Ft
20DV 5220 66430 33.2 1172
40DV 8885 62765 67.7 2390
40HC 8840 62810 76.three 2694
45HC 11130 60520 86.1 3041
*These numbers can range however it is a good scale to go by as they won’t be a lot totally different throughout totally different ocean carriers.
These are the headers that you’ll use to finish the challenge.
FEASIBLE MAX WEIGHT FEASIBLE MAX CFT FEASIBLE MAX CBM CUBE UTILIZATION PCT WEIGHT UTILIZATION PCT
You’ll reply the next questions:
1. What’s the common dice utilization in proportion?
2. What’s the common weight utilization in proportion?
three. Are we using the container dice and weight effectively?
four. Are there any areas that look notably inefficient at container utilization?
5. What would trigger the burden proportion to be excessive however the dice proportion to be low?
6. What would trigger the dice proportion to be excessive and the burden proportion to be low?
