Use the information above to evaluate the current situation $($Note: The ABC

analysis needs to be performed. You may use the ExcelModules for computations,

however you still need to provide the corresponding Spreadsheet file to support your

discussions$).(10$ marks$)$

PAPER CODE: IOM$422/202324/$SEM$2/$Mini$-$Project $2$ P a g e $|4$

$2.$ Given your evaluation, try to develop an integrated inventory control policy

that John should consider. $(10$ marks$)$

$3.$ Is there other information that you would like to see that might help you to

make a more effective policy? If so$,$ what would that information be and how

would you use it to help you? $(10$ marks