Automatic MRP forecast - help needed

[brazill23]

Hi All,

Im building automatic order point but hit some wall Maybe anyone here is happy to help ?
I have managed to calculate weeks of cover but I want to now add formula with allow me to :

-if weeks of cover lower then 3 place an order
-calculate quantity for "planned orders" to top up back to 6 weeks of stock (how much stock to order to back to 6 weeks again).
- also when no forecast (0) its still deducting weeks not sure is it correct

Im happy to send file if this will help

Forecast	0	500	572	1852	0	0	2316	1852	1636	1158	1852	1636	1158
Opening Stock	3,182	3,182	2,682	2,110	257	257	257	-2,058	-3,911	-5,547	-6,705	-8,557	-10,193
Planned Orders
Stock Cover	5.1	4.1	3.1	2.1	1.1	0.1	-1.1	-2.4	-4.8	-3.6	-5.2	-8.8
			Skip	Order	Order	Order	Order	Order	Order	Order	Order	Order	Order

<tbody>
</tbody>

Stock cover formula for 5.1 (week1) :

=IF(K60>K61,K61/K60,IF(K60+L60>K61,1+(K61-K60)/L60,IF(K60+L60+M60>K61,2+(K61-K60-L60)/M60,IF(K60+L60+M60+N60>K61,3+(K61-K60-L60-M60)/N60,IF(K60+L60+M60+N60+O60>K61,4+(K61-K60-L60-M60-N60)/O60,IF(K60+L60+M60+N60+O60+P60>K61,5+(K61-K60-L60-M60-N60-O60)/P60,IF(K60+L60+M60+N60+O60+P60+Q60>K61,6+(K61-K60-L60-M60-N60-O60-P60)/Q60,IF(K60+L60+M60+N60+O60+P60+Q60+R60>K61,7+(K61-K60-L60-M60-N60-O60-P60-Q60)/R60,"8+"))))))))