MRP Formulas
A B C
D E F
4ABA-0001 A150 LOWER COVER RH Order 2420 1210
5MIN INV. 1 WK 483N Usage 1940 1845
6ATS CANADA 1210 per box Inventory 2420 2900 2265
E4 =Round((EF+F5+((G5*.05)-D6)/1210,0)*1210
E5 IS LINKED TO A SPREADSHEET CALLED CUSTOMER FORECAST AND EF FORMULA IS
LISTED AS =CUSTOMER FORECAST!B3+CUSTOMER FORECAST!B36
E6 FORMULA IS =D6+E4-E5
I need to know is there a way that a can reformulate E4 to show by hours of
production instead of weekly usage, is this possible?
|