I have attempted to reply to each point, do let me know if I missed any.
However what is missing is allowing someone to put in minimums ie if I sold less than 4 items per month I could have max and min set to zero.
If I understand correctly you are wanting to edit the current values with any you choose. This is already possible by typing in the fields that are directly opposite the Qty/Week display for each stock code.
Also the calculation of max/min should only allow whole numbers. Round down.
While whole numbers may apply to your inventory, it does not all apply to all.
This would allow a person to set the max/min all at once for items sold enough to carry inventory.
Are you suggesting to have an auto-accept option? If so, because the function provides live edits and there is no option to double-check or reverse the action, this could result in unintended updates.
Also in the existing system to find a stock code you have to scroll down a long list.
iif you start typing the stock code it does not jump to it.
As the function provides live edits to the stock codes, the intention is to populate the grid in small batches of stock codes and work through those line-by-line. Also note the check box to limit the display to exclude any stock code that is within range.