Thread: MRP Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Angela Angela is offline
external usenet poster
 
Posts: 85
Default 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?