Frank Fasano (“Fa”) was pleased to see that the Supply Chain…

Frank Fasano (“Fa”) was pleased to see that the Supply Chain Planning team was taking his concerns seriously at Straight Laced. Yet, he still was not satisfied with the accuracy of the forecasting techniques the company was using. He felt that there were plenty of ups and downs in the business – some under the company’s control and many others not, but he felt that they should be able to anticipate those sales movements in the future. You could hear him from across the room with a common refrain: “We need to up our forecasting game, people!!!”
Dejected, but undeterred Simone Williams asks you to take a closer look at a product that had long been a source of frustration, the Rojas Tiki-taka soccer cleat. The shoe has been among its bestselling soccer cleats, where Straight Laced was a relative newcomer. Yet, when they signed soccer phenomenon Dani Rojas to an exclusive deal, they expected to dominate the category. That domination remains to be seen.
Use the instructions below along with the Excel workbook that accompanies this assignment.
Follow the instructions closely in order to generate and present the proper graphs, forecasts, and error calculations.