# data[].attributes.body
The case study has 8 questions including summary.
After discussing, there will be one person do 2 questions relating to an option which is option A. Option B and C have 4 questions ( number of tins and total cost) will be done by 4 people, one of us will summarize the case also. The final question (question 7) will be discussed later after we finish questions from 1 to 6.

# data[].attributes.headline
QUESTION 6: What are the total costs of delivering the milk powder to the retailer under Option C?

# data[].attributes.subject
QUESTION 6: What are the total costs of delivering the milk powder to the retailer under Option C?

# data[].attributes.headline
QUESTION 1:  How many tins of milk powder can be loaded into a container under Option A?

# data[].attributes.subject
QUESTION 1:  How many tins of milk powder can be loaded into a container under Option A?

# data[].attributes.body
Tins per pallet:
1.067/0.21 = 5 tins in length
1.067/0.21 = 5 tins in width
1/0.22 = 4 tins in height
=> 5*5*4 = 100 tins
Pallets per container:
11.84/1.067 = 11 pallets in length
2.28/1.067 = 2 pallets in width
2.12/1 = 2 pallets in height
=> 11*2*2 = 44 pallets
Therefore, we have 4400 tins per container (4400 = 44*100).

# data[].attributes.body
The Adelaide Dairy Company (ADC) is an Australian milk-processing company. Recently, a retailer in Singapore placed orders for 60,000 3-kilogram tins of milk powder to be delivered progressively over 6 months.

There are 3 options, namely option A, option B, option C to discuss. Many considerations, such as  total costs of delivering the milk powder,  products’ physical characteristics,… must be taken into account when the packaging and materials handling decision is made.

Below are a brief summary of each option’s characteristics:
Option A:

1. Package the milk powder in tins ($3/kilogram) (3.3 kilograms/ tin)

2. Palletize ($25/ pallet) these tins ($3/ tin) and shrink-wrap to withstand a sea journey

3. These tins are loaded into temperature-controlled shipping containers ($500/ containter)

4. The loaded containers would be trucked from the processing plant to the port of adelaide

5. Ship from port of adelaide to any address in singapore (ocean freight: $2,500/ container)

Option B:

1. Package the milk powder in a new design tins ($3/kilogram) (3kg/ tin)

2. Palletize ($25/ pallet)  these tins ($3.1/ tin) and shrink-wrap to withstand a sea journey

3. These tins are loaded into temperature-controlled shipping containers ($500/ containter)

4. The loaded containers would be trucked from the processing plant to the Port of Adelaide

5. Ship from Port of Adelaide to any address in Singapore (ocean freight: $2,500/ container)

Option C:

1. shipping milk powder in bulk (using unpalletized stackable drums loaded into shipping containers) from Adelaide to Singapore. These drums are reusable. ($100/ drum, could be resold for $80)

2. A qualified contractor could then be hired in Singapore to repackage the milk powder into 3-kilogram tins ($2/ tin) identical to the ones in Option A.

3. deliver the milk powder locally to the retailer’s warehouse. ($0.50/ kilogram to repackage and deliver)

# data[].attributes.headline
QUESTION 2: How many tins of milk powder can be loaded into a container under Option B?

# data[].attributes.subject
QUESTION 2: How many tins of milk powder can be loaded into a container under Option B?

# data[].attributes.body
Tins per pallet:

1.067 / 0.194 = 5 tins

1.067 / 0.194 = 5 tins

1 / 0.245 = 4 tins

5 x 5 x 4 + 20 = 120 tins
Pallet per container: 44 pallets

Tins per container: 44 x 120 = 5280 tins

# data[].attributes.headline
QUESTION 3: How many drums of milk powder can be loaded into a container under Option C?

# data[].attributes.subject
QUESTION 3: How many drums of milk powder can be loaded into a container under Option C?

# data[].attributes.body
Number of drums can be loaded in the width of a container: 2.28/0.75 = 3 drums

Number of drums can be loaded in the length of a container: 11.84/0.75 = 15 drums

Number of drums can be loaded in the height of a container: 2.12/1 = 2 drums

So, the total number of drums can be loaded in a container: 3*15*2 = 90 drums

However, the total shipment weight could not exceed 20,000 kilograms per container, the total number of drums of milk powder can be loaded into a container under Option C is: 86 drums (86*(200 + 32) = 19,952kg)

# data[].attributes.headline
QUESTION 4: What are the total costs of delivering the milk powder to the retailer under Option A?

# data[].attributes.subject
QUESTION 4: What are the total costs of delivering the milk powder to the retailer under Option A?

# data[].attributes.headline
QUESTION 5: What are the total costs of delivering the milk powder to the retailer under Option B?

# data[].attributes.subject
QUESTION 5: What are the total costs of delivering the milk powder to the retailer under Option B?

# data[].attributes.headline
QUESTION 7: Which option would you recommend? Why?

# data[].attributes.subject
QUESTION 7: Which option would you recommend? Why?

# data[].attributes.body
We will choose option B which is ADC’s supplier proposed a new tin
design, so that pallet density could be increased.  According to the calculations above, option B can load 5280 tins of milk powder per container, which is more than option A & C can load.  Option B has the total costs of delivering the milk powder to the retailer of $796835, whereas option A has the total costs of $799260 and total cost of Option C is $817905. It means option C can load more drums of milk powder per container

for less total costs.