sapads
06-13-2012, 12:52 PM
I have a list of products made during the last twelve months on a daily basis (see test data below). If there is a bank holiday or weekend then the volume would be nill.
I need to be able to setup a formula that will look at those days with volumes greater than zero and provide me with a number (the optimum capacity) that would meet 90% of all the days capacity.
Can anyone help?
Test Data
Mon0Tue472Wed1911Thu391Fri64Sat596Sun0Mon157Tue0Wed327Thu297Fri0Sat214Sun18 2Mon4Tue538Wed619Thu1644Fri939Sat594Sun5314Mon741Tue0Wed0Thu0Fri0Sat1286Sun 1846Mon479Tue0
I need to be able to setup a formula that will look at those days with volumes greater than zero and provide me with a number (the optimum capacity) that would meet 90% of all the days capacity.
Can anyone help?
Test Data
Mon0Tue472Wed1911Thu391Fri64Sat596Sun0Mon157Tue0Wed327Thu297Fri0Sat214Sun18 2Mon4Tue538Wed619Thu1644Fri939Sat594Sun5314Mon741Tue0Wed0Thu0Fri0Sat1286Sun 1846Mon479Tue0