To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R01_Table that contains the following data:
|
Week |
Demand |
Ending Inventory |
|
2/3/2020 |
0 |
49,813 |
|
2/10/2020 |
11,360 |
36,961 |
|
2/17/2020 |
7,952 |
37,859 |
|
2/24/2020 |
7,485 |
32,876 |
|
3/2/2020 |
7,131 |
24,875 |
|
3/9/2020 |
6,785 |
76,385 |
|
3/16/2020 |
6,854 |
73,152 |
|
3/23/2020 |
7,132 |
80,563 |
|
3/30/2020 |
5,820 |
76,131 |
|
4/6/2020 |
7,272 |
68,177 |
|
4/13/2020 |
7,344 |
58,538 |
|
4/20/2020 |
7,200 |
54,853 |
|
4/27/2020 |
3,994 |
52,142 |
|
5/4/2020 |
2,577 |
44,728 |
|
5/11/2020 |
2,629 |
44,950 |
|
5/18/2020 |
2,706 |
42,347 |
|
5/25/2020 |
4,279 |
37,142 |
|
6/1/2020 |
8,158 |
28,262 |
|
6/8/2020 |
8,319 |
31,203 |
|
6/15/2020 |
7,835 |
22,365 |
The R01_Table table represents the weekly inventory and sales levels. The Demand column represents inventory that is sold or taken out of stock during the week, while the Ending Inventory column represents the stock level of inventory at the end of the week. It should be noted that you cannot simply subtract the next week's demand from the current week's Ending Inventory to arrive at the figure for next week's Ending Inventory as additional inventory may be added during any given week.