The following steps need to be put into an Excel spreadsheet
Sheet1
| Historical Customer Demand | |||||||||||||||||||||||||
| Part Number | Part Description | Supplier | Lead Time (months) | Jan-08 | Feb-08 | Mar-08 | Apr-08 | May-08 | Jun-08 | Jul-08 | Aug-08 | Sep-08 | Oct-08 | Nov-08 | Dec-08 | Jan-09 | Feb-09 | Mar-09 | Apr-09 | May-09 | Jun-09 | Jul-09 | Aug-09 | Sep-09 | Oct-09 |
| 25216-12277 | Vlookup Wrench Set | Macros Plus | 2.5 | 1680 | 1800 | 480 | 840 | 1200 | 360 | 600 | 1200 | 360 | 600 | 480 | 1920 | 1560 | 1680 | 1800 | 840 | 1320 | 840 | 1200 | 840 | 1920 | 480 |