Scribd
Upload
492 views2 pages

Milk Powder Shipment Cost Analysis

1. Under Option A, 5811 tins of milk powder can be loaded into each container. 2. The average payload exceeds the threshold of 20000kg total shipment weight under both Option A and Option B. 3. The total cost of delivering the milk powder under Option A is $834,275.11.

Uploaded by

Vân Đào
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
492 views2 pages

Milk Powder Shipment Cost Analysis

1. Under Option A, 5811 tins of milk powder can be loaded into each container. 2. The average payload exceeds the threshold of 20000kg total shipment weight under both Option A and Option B. 3. The total cost of delivering the milk powder under Option A is $834,275.11.

Uploaded by

Vân Đào
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Pallet volume= 1.067x 1.067x 1= 1.

1385m3

Container volume= 2.12x 2.28x 11.84= 57.23 m3

Pallet per container = 57.23/ 1.1385= 50 pallet

1. How many tins of milk powder can be loaded into a container under Option A?

Tin volume= (0.21/2)2x 3.14x 0.22=0,00762m3

Tins per pallet = 1.1385/0.00762 = 149 tins

Weight pallet = (149x 3.3.) +15= 506.7

Container: 506.7 x 50 = 25335kg > 20000kg

 Pallet per container= 20000/506.7 =39


 Tins per container= 39x 149= 5811

2. Does the average payload exceed the threshold of total shipment weight under Option
A?

25335kg > 20000kg => the average payload exceed the threshold of total shipment weight
under Option A

3. What are the total costs of delivering the milk powder to the retailer under Option A?

180000/(149x3)=403 pallet

Container= 403/39= 11 container

Tin cost = $3.1

Pallet cost= 157x (3.1+(3x3)) +25 = $1813

Container cost = ($1813 x 39 + $500)x11= $783,277

Insurance = 783,277x3%= 23,498.11

Second shipment = 2500x11= 27,500

Total cost = $783,277 + $23,498.11 + $27,500= $834,275.11

4. How many tins of milk powder can be loaded into a container under Option B?

Tin volume= (0.194/2)2x 3.14x 0.245=0,00723m3

Tins per pallet = 1.1395/0.00723 = 157 tins

Weight pallet = (157x 3.3) +15= 533.1 kg

Container: 533.1 x 50 = 26655kg > 20000kg


 Pallet per container= 20000/533.1 =37
 Tins per container= 37x 157= 5809

5. Does the average payload exceed the threshold of total shipment weight under Option
B?

26655kg > 20000kg => the average payload exceed the threshold of total shipment weight
under Option B

6. What are the total costs of delivering the milk powder to the retailer under Option B?

180000/(149x3)=403 pallet

Container= 403/37= 11 container

Tin cost = $3.1

Pallet cost= 157x (3.1+(3x3)) +25 = $1924.7

Container cost = ($1924,7 x 37 + $500)x11= $788,852.9

Insurance = 788,852.9x3%= 23,665.587

Second shipment = 2500x11= 27,500

Total cost = $788,852.9+ $23,665.587 + $27,500= $840,018.487

You might also like