Guillermo Furniture Store Recommendation

Inventory Systems Summary

QRB 501

Dr. Ahmed Kamel

Forecasting with Indices

The purpose of this paper is to discuss a summary of winter inventory for four years. The annual inventories provide the basis for establishing historical trends. The trends can be many factors that influence tracking progress. Factors affecting the winter inventory might include the economy, changes in weather, such as tornados. A way of testing the relationship between the sample data is to test the relationship between independent and dependent variables. In doing so the sample looks at increase and decrease of inventory over four 4 years to determine the economic outcome for each year.

| |Typical Seasonal Demand for Winter Highs | |

| | | | | | | |

| | | |Actual Demands (in units) | | | |

| | | | | | | |

|Month |Year 1 |Year 2 |Year 3 |Year 4 |Forecast | |

|1 |55,200 |39,800 |32,180 |62,300 | | |

|2 |57,350 |64,100 |38,600 |66,500 | | |

|3 |15,400 |47,600 |25,020 |31,400 | | |

|4 |27,700 |43,050 |51,300 |36,500 | | |

|5 |21,400 |39,300 |31,790 |16,800 | | |

|6 |17,100 |10,300 |31,100 |18,900 |...