I am beginning to develop a new forecast and demand planning that will utilize the production plan of my customer to tell me how many of each products I will need on a weekly, monthly and yearly basis. I don't want a true forecast because I have the production data. Can any provide any insight into how to develop this spreadsheet?