Operation Management hep

ic14.xlsx_bahanshal.xlsx

Sheet1

			Weeks	1	2	3	4	5	6	7	8	9
	Item	A	Gross Requirements									1250
	Lead Time	2	Scheduled Receipts	0	0	0	0	0	0	0	0
	On Hand	50	Projected Available Balance	50	50	50	50	50	50	50	50	50
	Safety Stock	0	Net Requirements									1200
	Order Quantity	1	Planned Order Receipts
			Plannned Order Releases							1200
	Item	B	Gross Requirements					250				470
	Lead Time	2	Scheduled Receipts	0	0	0	0	10	0	0	0
	On Hand	60	Projected Available Balance	60	60	60	60	70	70	70	70	70
	Safety Stock	0	Net Requirements									400
	Order Quantity	Lot	Planned Order Receipts
			Plannned Order Releases							400
	Item	C	Gross Requirements							1600		470
	Lead Time	1	Scheduled Receipts	0	0	0	0	0	0	0	0
	On Hand	40	Projected Available Balance	35	35	35	35	35	35	35
	Safety Stock	5	Net Requirements							1565	435	435
	Order Quantity	2000	Planned Order Receipts							2000
			Plannned Order Releases						2000
									4000	1200
		Weeks		2	3	4	5	6	7	8	9
Item	d	Gross Requirements	1								1250
Lead Time	1	Scheduled Receipts	0	0	0	0	0	0	0	0
On Hand	200	Projected Available Balance	180	180	180	280	280	280	1280	80	180
Safety Stock	20	Net Requirements							3720
Order Quantity	5000	Planned Order Receipts							5000
		Plannned Order Releases						5000