Hw4-3&4

Hw4-3&4 - 25% 25% 25% 25% Weekly Demand 100 100 100...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1 year 52 weeks/year Holding Cost Rate 25% Weekly Demand 100 Std. Deviation 50 Satisfaction 95% Reliable $5,000 /Transformer Reliable 100 Order Qty R. Lead Time 1 week R. Std Dev 0.1 week Value $4,800 /Transformer Value 1000 Order Qty Lead Time 5 weeks Std. Deviation 4 weeks Reliable Safety Stock 83.8714074083 Reliable Avg. Inventory 133.8714074083 Reliable Holding Cost $167,339.26 Reliable Supply Cost $26,000,000 Reliable Total Cost $26,167,339.26 Value Safety Stock 683.1590194321 Value Avg. Inventory 1183.159019432 Value Holding Cost $1,419,790.82 Value Supply Cost $24,960,000 Value Total Cost $26,379,790.82 I would choose to go with Reliable Components
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Option 1 Option 2 Option 3 All Weeks/year 52 52 52 52 Holding Cost Rate
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 25% 25% 25% 25% Weekly Demand 100 100 100 100 Std. Deviation 50 50 50 50 Satisfaction 95% 95% 95% 95% Value Price/Transformer $4,800 $4,800 $4,800 $4,800 Value Order Qty 1000 800 1000 800 Lead Time 4 5 5 4 Std. Deviation 4 4 3 3 Value Safety Stock 678.1905242601 683.1590194321 526.6101062881 520.1483878756 Value Avg. Inventory 1178.1905242601 1083.1590194321 1026.610106288 920.1483878756 Value Holding Cost $1,413,828.63 $1,299,790.82 $1,231,932.13 $1,104,178.07 Value Supply Cost $24,960,000 $24,960,000 $24,960,000 $24,960,000 Value Total Cost $26,373,828.63 $26,259,790.82 $26,191,932.13 $26,064,178.07 Source From Value No No No Yes...
View Full Document

Page1 / 2

Hw4-3&4 - 25% 25% 25% 25% Weekly Demand 100 100 100...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online