• Resources: Week Two Assignment, University of Phoenix Material: Summer
Historical Inventory Data, or University of Phoenix Material: Winter Historical
• Select an inventory management problem that applies to your work or personal life.
• Prepare a project proposal in which you:
o Describe the organization, the inventory problem it faces, and the expected
benefits that are motivating the organization to implement a solution.
o Convert time series data collected in Week Two to seasonal indices. You may
choose to use the University of Phoenix Material: Summer Historical Inventory
Data or University of Phoenix Material: Winter Historical Inventory Data if the
data you collected is insufficient.
o Use seasonal indices to analyze the inventory data.
Use the slope-intercept formula to determine the annual increase in
Provide monthly seasonal indices for the given data.
Identify the busy months of year.
Identify the slow months of year.
o Construct a histogram of the inventory data using Microsoft®
o Forecast the future inventory costs using time value of money concepts.