Supply Chain Management

profilellulu677
355Data.xlsx
Home>Business & Finance homework help>Operations Management homework help>Supply Chain Management

Sheet2

Average Daily Demand Asia Pacific Year 1 Asia Pacific Year 2
Month Year 1 Year 2 LT (Days) 56 LT (Days) 56
August 1,774 2,129 Dd 1369.8630136986 Dd 1639.3442622951
September 1,667 2,000 σd 180.889877873 σd 220.6555203046
October 1,290 1,548 DLT 76712.3287671233 DLT 91803.2786885246
November 1,333 1,600 σLT 1353.655896 σLT 1651.234715
December 1,452 1,742 Z.95 1.645 Z.95 1.645
January 1,129 1,355 SS 2227 SS 2717
February 1,250 1,448 R* 78940 R* 94520
March 1,290 1,548
April 1,333 1,600 CanDo Year 1 CanDo Year 2
May 1,290 1,548 LT (Days) 21 LT (Days) 21
June 1,333 1,600 Dd 1369.8630136986 Dd 1639.3442622951
July 1,290 1,548 σd 180.889877873 σd 220.6555203046
St. Dv. 180.889877873 220.6555203046 DLT 28767.1232876712 DLT 34426.2295081967
σLT 828.941558 σLT 1011.170624
Year 1 Cost Analysis (Initial Safety Stock) Z.97 1.881 Z.97 1.881
Unit price Transportation Ordering D/C/I/T QNC SS Tooling Total SS 1560 SS 1903
AP $129 $17 $3 $12.50 $1.73 $23.22 $5 $95,722,500 R* 30327 R* 36329
CD $146 $5.50 $4.50 $2 $3.13 $12.13 $6 $89,627,500
DI $144 $12 $2.50 $2 $1.63 $11.96 $7 $90,542,500 Davis Industries Year 1 Davis Industries Year 1
DT $132 $16 $1.50 $11.50 $1.13 $23.76 $5.50 $95,692,500 LT (Days) 21 LT (Days) 21
Dd 1369.8630136986 Dd 1639.3442622951
Year 2 Cost Analysis (Initial Safety Stock) σd 180.889877873 σd 220.6555203046
Unit price Transportation Ordering D/C/I/T QNC SS Tooling Total DLT 28767.1232876712 DLT 34426.2295081967
AP $129 $17 $3 $12.50 $1.73 $23.22 $4.17 $95,307,500 σLT 828.941558 σLT 1011.170624
CD $146 $5.50 $4.50 $2 $3.13 $12.13 $5 $89,127,500 Z.995 2.807 Z.995 2.807
DI $144 $12 $2.50 $2 $1.63 $11.96 $5.83 $89,957,500 SS 2327 SS 2839
DT $132 $16 $1.50 $11.50 $1.13 $23.76 $4.58 $95,232,500 R* 31094 R* 37265
Year 1 Cost Analysis (Calculated Safety Stock) Dihachi Technologies Dihachi Technologies
Unit price Transportation Ordering D/C/I/T QNC SS Tooling Total LT (Days) 70 LT (Days) 70
AP $129 $17 $3 $12.50 $1.73 $1.24 $5 $84,732,500 Dd 1369.8630136986 Dd 1639.3442622951
CD $146 $5.50 $4.50 $2 $3.13 $2.13 $6 $84,627,500 σd 180.889877873 σd 220.6555203046
DI $144 $12 $2.50 $2 $1.63 $3.14 $7 $86,132,500 DLT 95890.4109589041 DLT 114754.098360656
DT $132 $16 $1.50 $11.50 $1.13 $2.23 $5.50 $84,927,500 σLT 1513.4333 σLT 1846.136535
Z.99 2.58 Z.99 2.58
Year 2 Cost Analysis (Calculated Safety Stock) SS 3905 SS 4764
Unit price Transportation Ordering D/C/I/T QNC SS Tooling Total R* 99796 R* 119518
AP $129 $17 $3 $12.50 $1.73 $1.26 $4.17 $84,327,500
CD $146 $5.50 $4.50 $2 $3.13 $2.16 $5 $84,142,500
DI $144 $12 $2.50 $2 $1.63 $3.19 $5.83 $85,572,500
DT $132 $16 $1.50 $11.50 $1.13 $2.26 $4.58 $84,482,500
Year 1 and 2 ISS Total Cost
AP $191,030,000
CD $178,755,000
DI $180,500,000
DT $190,925,000
Year 1 and 2 CSS Total Cost
AP $169,060,000
CD $168,770,000
DI $171,705,000
DT $169,410,000