Here is a screenshot of the assignment. I will copy and paste the tables below for your convenience. Thanks!

Parameter	Notation	Value	Measurement
Mean daily demand	D	6	units per day
Standard deviation of daily demand	sD	3	units per day
Mean lead time	L	3	days
Standard deviation of lead time	sL	2	day
Inventory holding cost factor	k	0.002	per day per dollar of average inventory
Unit purchase cost	C	2.8	per unit
Holding cost per unit per day	H		per unit per day
Backordering cost per unit	P	0.22	per unit backordered
Ordering cost per order	S	4	per order
Order Quantity	Q		units
Mean demand during the lead time	DL		units per lead time
Standard deviation of demand during the lead time	sDL		units per lead time	=SQRT(L*sD^2+D^2*sL^2)
Type 1 Service Level	alpha
Standard normal variate	z
Safety Stock	SS		units
Expected units out of stock during the lead time	nR		units per cycle	=sDL*NORMDIST(z,0,1,0)-SS*(1-NORMDIST(z,0,1,1))
Type 2 Service Level	beta
Reorder point	R		units
Annual Cycle Stock Holding Cost	CSH		per year
Annual Safety Stock Holding Cost	SSH		per year
Annual Ordering Cost	OC		per year
Annual Backordering Cost	BC		per year
Annual Total Relevant Cost	G(Q,R)		per year

B D E H T 8 points. Every time Company XYZ places an order for SKU 1234, it orders 50 units. You suspect that this order quantity is far from optimal. Your boss, however, is not convinced that the order quantity should change. Question 1. What is XYZ's current total relevant logistics cost GQ, R)? Question 2. What will be XYZ's total relevant logistics costs if they implement your proposed order quantity? How would the total relevant logitics cost change %) if XYZ adopts your proposed order quantity? Notation ANSWERS GIQ,R) Q.1 Value 6 3 3 2 0.002 2.8 Q.2 G(QR)* % cost change 1 2 3 4 5 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 0.22 Parameter Mean daily demand Standard deviation of daily demand Mean lead time Standard deviation of lead time Inventory holding cost factor Unit purchase cost Holding cost per unit per day Backordering cost per unit Ordering cost per order Order Quantity Mean demand during the lead time Standard deviation of demand during the lead time Type 1 Service Level Standard normal variate Safety Stock Expected units out of stock during the lead time Type 2 Service Level Reorder point Annual Cycle Stock Holding Cost Annual Safety Stock Holding Cost Annual Ordering Cost Annual Backordering Cost Annual Total Relevant Cost Measurement units per day units per day days day per day per dollar of average inventory per unit per unit per day per unit backordered per order units units per lead time units per lead time 4 19-vanda - 4 * 3 588 -SQRT{ LD^2D^2'sL^2) units units per cycle =sDL NORMDIST[3,0,1,01-58*(1-NORMDIST[3,0,1,1]) units per year per year per year per year per year B D E H T 8 points. Every time Company XYZ places an order for SKU 1234, it orders 50 units. You suspect that this order quantity is far from optimal. Your boss, however, is not convinced that the order quantity should change. Question 1. What is XYZ's current total relevant logistics cost GQ, R)? Question 2. What will be XYZ's total relevant logistics costs if they implement your proposed order quantity? How would the total relevant logitics cost change %) if XYZ adopts your proposed order quantity? Notation ANSWERS GIQ,R) Q.1 Value 6 3 3 2 0.002 2.8 Q.2 G(QR)* % cost change 1 2 3 4 5 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 0.22 Parameter Mean daily demand Standard deviation of daily demand Mean lead time Standard deviation of lead time Inventory holding cost factor Unit purchase cost Holding cost per unit per day Backordering cost per unit Ordering cost per order Order Quantity Mean demand during the lead time Standard deviation of demand during the lead time Type 1 Service Level Standard normal variate Safety Stock Expected units out of stock during the lead time Type 2 Service Level Reorder point Annual Cycle Stock Holding Cost Annual Safety Stock Holding Cost Annual Ordering Cost Annual Backordering Cost Annual Total Relevant Cost Measurement units per day units per day days day per day per dollar of average inventory per unit per unit per day per unit backordered per order units units per lead time units per lead time 4 19-vanda - 4 * 3 588 -SQRT{ LD^2D^2'sL^2) units units per cycle =sDL NORMDIST[3,0,1,01-58*(1-NORMDIST[3,0,1,1]) units per year per year per year per year per year