So, you think you can plan inventory? Why not try your skills.
You have been called in as in interim inventotry manager your predecessor having been fired for incompetence
Below you will find some basic data and 6 period of inventory movement history for a typical non-seasonal item
Your task is to manage the inventory for the next 18 periods.
Examine the past sales to determine the likely sales rate (The item is not seasonal)
Decide how variable these sales are and set a minimum stock level
Place orders (in the order column) on a period by period basis
Each time you place an order, the next period's demand will be show along with the other stock numbers
The chart will recalculate when you hit the tab key or press recalculate.
Good Luck
	Financial and Supply Details of the Item to be Managed
						Service
Item Cost		Lead Time	2	Cost/Order	£20	Av Stk
Sarting Stock	6	Stock Holding	20%	Cost /Lost Sale	£5	Tot Cost
	OPENING				CLOSING	LOST	PERIOD
PERIOD	STOCK	SALES	RECEIPTS	ORDERS	STOCK	SALES	COST
19				29
20				33
21				25
22				18
23				45
24				36
25
				Ordering	Lost Sale	Stock	Total