Slope-Intercept Formula to Determine the Annual Increase Essay Example for Free

Slope-Intercept Formula to Determine the Annual Increase EssaySelect an stock certificate management problem that applies to your work or personal life.Prepare a project proposal in which youDescribe the organization, the breed problem it faces, and the expected benefits that are motivating the organization to implement a solution. metamorphose time series selective information collected in Week Two to seasonal indices. You may need to use the University of capital of Arizona genuine Summer Historical Inventory Data or University of Phoenix Material Winter Historical Inventory Data if the data you collected is insufficient. Use seasonal indices to analyze the schedule data.oUse the slope-intercept formula to determine the annual increase in inventory.oProvide monthly seasonal indices for the given data.oIdentify the busy months of year.oIdentify the long-winded months of year.Construct a histogram of the inventory data using Microsoft Excel.Forecast the future inventory b e using time value of money concepts.University of Phoenix Summer Historical Inventory DataThe University of Phoenix Summer Historical Inventory Data is the source for developing Team Bs inventory management proposal. Annual track lines were plotted in Microsoft Excel to display the inventory amounts for each year. The trend line in this case is positive, which indicates that the likelihood of inventory levels in the subsequent years will concern to rise without considering any additional factors that may influence the business. Factorsto support the observation include economic imbalance from stock market volatility, a decline in consumer confidence, severe weather, and acts of terrorism. Table 1 shows the existing data and includes the fifth year projections. Figure 1 displays the trend line.