Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a production schedule
I have a sheet with amounts that have to delivered in every week. (Delivery
Schedule). The first column (a1,a2, etc) of the sheet contains the item number. The second column of the sheet contains the production capacity of a week All the folowing colums (c,d,e, etc) are the need of each week. (column c contains the need of week 1; column d contains the need of week 2) Now I need a second sheet that creates a production planning, using the information above (Production schedule) Since he first column (a1,a2, etc) of each sheet contains a equal variable, the item number, I can use VLOOKUP to find the accompanying capacity of each item. But how do I calculate that I need to produce 2 pieces in week 1 and 5 pieces in week 2, because I need to deliver 7 pieces in week 3 and my capacity is 5 per week? Hope my question is clear! Thanx in advance. -- Kees Vos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Calculation production schedule using solver | Excel Worksheet Functions | |||
Looking for a production schedule excel/access & user friendly? | Setting up and Configuration of Excel | |||
I AM LOOKING FOR A SIMPLE PRODUCTION SCHEDULE FOR MANUFACTURING | Excel Discussion (Misc queries) | |||
Figuring out loop for a production schedule | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |