Requirements : deep assignment provide with some historical inventory data for two seasons
Convert time series data collected to seasonal indices. .Use seasonal indices to analyze the inventory data: o Use the slope intercept formula to determine the annual increase in inventory o Provide the monthly seasonal indices for the given data o Identify the busy months of the year o Identify the slow months of the year .Construct a histogram of the inventory data using Microsoft Excel .Forecast the future inventory costs using time value of money concept I need to understand your concepts, how you arrived at your details.