Hi all,
I am currently working on an excel sheet to forecast sales of spareparts. For this, i am seeking to combine two datasets.
Dataset 1 comprises a list of product compositions. Dataset 2 comprises a list of sales, both new sales and sales of spareparts.
My goal: based on a combination of new sales and historical spareorders, forecast the amount of spareparts that i am expected to having to deliver in the upcoming 3 months.
Not sure yet what would be the best way to do this, maybe by means of a pivot or by graphing the trends or something??
Anyone got any suggestions on how to operationalize this?
I included the sheet in this thread
Bookmarks