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? |
All times are GMT +1. The time now is 10:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com