EXCEL ASSIGNMENTS, SUPPLY CHAIN MANAGEMENT

profilesward44
Homework2-Templated.xlsx
Home>Business & Finance homework help>Management homework help>EXCEL ASSIGNMENTS, SUPPLY CHAIN MANAGEMENT

Question 1

Capacity Choice Capacity=
Sales Leftover Capacity Shortage
Demand Probability Demand Satisfied Extra Capacity Deficient Capacity Cumulative Probability
100 0.2
200 0.2
300 0.3
400 0.13
500 0.100
600 0.040
700 0.030
E[sales] E[left] E[short]
Exp.Value Exp. Demand Satisfied Exp. Extra Capacity Exp. Capacity Deficiency
Revenue= $ 250.00 per unit Exp. Profit=
Secondary Revenue= $ 85.00 per unit
Cost of Capacity= $ 100.00 per unit
Exp. Demand Satisfied Exp. Extra Capacity Exp. Capacity Deficiency Exp. Profit
0 0 0 $ - 0
cu= 100 0 0 0 $ - 0
co= 200 0 0 0 $ - 0
300 0 0 0 $ - 0
Critical Ratio
Keskin, Burcu: Keskin, Burcu: CR= (c_u)/(c_u+c_o)		 400 0 0 0 $ - 0
500 0 0 0 $ - 0
600 0 0 0 $ - 0
700 0 0 0 $ - 0

Question 2

Step 1 20 mins
Step 2 50 mins
Step 3 14 mins
setup time 10 mins
working hours 8 hours/day
working minutes 480 minutes/day
Question a: Answer in the green area.
Separate Capacity
demand arrival rate: 30 applications/day
No of Employees processing rate Lead Time (read from the queue_template)
Step 1 2 applications/day days
Step 2 4 applications/day days
Step 3 2 applications/day days
Total Lead Time days
Question b: Answer in the green area.
Pooling Capacity
demand arrival rate: 60 applications/day
new setup time: 11.5 mins
No of Employees processing rate Lead Time (read from the queue_template)
Step 1 4 applications/day days
Step 2 8 applications/day days
Step 3 4 applications/day days
Total Lead Time days

Your comment on why does this merger of processing centers generate the lead time observed? Your comment: