New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!

# 200329 Supply Chain Management

Published : 12-Oct,2021  |  Views : 10

## Question:

The item-A passes through a four stage (echelon) supply chain. Refer the schematic Supply chain diagram presented below. Item-A is assembled in a plant, shipped to its distribution centre (plant DC) for storage and waiting for a Retailer DC’s order for supply. The retail store then places order to its Retailer DC to get the merchandise shipped.

 1. Days of supply 0 60 45 30 2. Direct material, labour and overheads to assemble (direct cost) \$500 \$500 \$500 \$500 a. Freight (given) \$0 \$75 \$75 \$75 c. Space (\$0.25/sq.ft/month x20sq.ft x12 months) \$0 \$5 \$5 \$5

Consider the following assumptions/data:

1. Inventory carrying costs begin to accrue at the plant DC
2. All variable-based cost (L3.a to L3.d) value-based cost (L6.a to L6.d) must be prorated for each supply chain location based on the days of supply for that location.
3. A year is 12 months =365 days
4. Space cost is kept fixed in case of renting a private warehouse. That is \$5 per item stored per year.
5. Plant DC, retailer Dc and retailer have same space of 20 sq.ft individually.
6. Variable-based cost are out of pocket expenses e.g freight expenses. It increases every time an item is moved and stored.
7. Value-based expenses use total direct cost at each location. For example taxes are calculated on the basis of total variable-based cost.

Calculate the carrying cost (L11) for Plant DC, Retailer DC and Retailer. Calculate the values in the rows above to arrive at the answer.

What’s your explanation on the carrying cost for four locations

ABC Analysis and classification

 Item code       (C1) Item code       (C2) Volume (unit)       (C3) Unit cost (\$)     (C4) 1 A1 600 14.17 2 A2 2000 0.60 3 B1 250 0.60 4 B2 350 42.86 5 C1 1000 12.50 6 C2 1550 17.00 7 D1 500 154.00 8 D2 100 8.50 9 E1 1200 0.42 10 E2 1000 90.00
1. Complete the calculation for the columns in the table. ABC classification is based on the total dollar value of an item.
2. General rule of ABC classification can be followed as 20/30/50 for A,B and C respectively. That means initial 20% will be A-category, then 30% will be B and 50% will be C-category. However your judgement will help a lot if there is a variation from the above per cent.
3. Plot the graph between C9 and C10.

 Item code Item code Volume Unit cost Dollar value (\$) Dollar value % of total dollar value Cumulative % dollar value Classify as A/B/C item Item cumulative (C1) (C2) (C3) (C4) (C5)=c3 x c4 (C6) (C7) (C8) (C9) (C10) 1 A1 600 14.17 8502 90000 38.78% 90000 B 38.78% 2 A2 2000 0.6 1200 77000 33.18% 167000 B 71.97% 3 B1 250 0.6 150 26350 11.35% 193350 A 83.32% 4 B2 350 42.86 15001 15001 6.46% 208351 A 89.78% 5 C1 1000 12.5 12500 12500 5.39% 220851 A 95.17% 6 C2 1550 17 26350 8502 3.66% 229353 A 98.83% 7 D1 500 154 77000 1200 0.52% 230553 A 99.35% 8 D2 100 8.5 850 850 0.37% 231403 A 99.72% 9 E1 1200 0.42 504 504 0.22% 231907 A 99.94% 10 E2 1000 90 90000 150 0.06% 232057 A 100.00%

### Our Amazing Features

No matter how close the deadline is, you will find quick solutions for your urgent assignments.

#### 100% Plagiarism-free content

All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.

#### 500+ subject matter experts

Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.

#### Covers all subjects

We offer academic help services for a wide array of subjects.

#### Pocket-friendly rate

We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.

## Getting started with MyEssayAssignmentHelp is FREE

15,000+ happy customers and counting!