You can use Excel Solver, a built-in tool in Microsoft Excel, to solve linear optimization problems in various fields and applications, such as business, engineering, finance, and operations research.

Added monthly_predictions.xlsx. I only added this as an example of one hot encoding. I don't really like this method of predicting in most cases becauses I doubt the likelihood the trend will continue ...