Explain the organization, inventory problem it faces, and expected benefits which are motivating organization to implement a solution.

Use seasonal indices to examine the inventory data.

o Use slope-intercept formula to find out annual increase in inventory.
o Give monthly seasonal indices for the given data.
o Recognize the busy months of year.
o Recognize the slow months of year.

Create the histogram of inventory data using Microsoft Excel.

Predict future inventory costs using time value of money concept