课程: Excel Supply Chain Analysis: Solving Procurement Problems

免费学习该课程！

今天就开通帐号，24,600 门业界名师课程任您挑！

Forecast demand

Forecast demand

课程: Excel Supply Chain Analysis: Solving Procurement Problems

开始一个月试用 购买团队方案

Forecast demand

“

- [Instructor] Kinetico needs to have enough products on hand to fill customer orders, but they don't want to buy a bunch of inventory that's going to sit around gathering dust. So how do we decide how much to buy? Accurate demand forecasting is essential for effective inventory management so we can have the right amount of stock to meet customer demand without overstocking. Let's walk through the process of using Excel to create a demand forecast for an item based on our historical data. The easiest way to generate a demand forecast is to use historical data for the item we want to buy. The key components we'll work with include our dates or the time period for which we have sales data, our sales volume, the number of units that were sold during each period, and our forecast period, the future time period that we want to forecast. If you've downloaded the exercise files, open up 02_02 Forecast Demand. Otherwise, you can set up your Excel sheet to look like mine. Before we move to the…

内容