Stock Control and Inventory Dynamics with Excel & Python.

سرفصل های دوره

Apply the Best forecasting model and inventory policy for all the Products in your Assortment and much more!!

1 - Introduction

1 - Introduction

2 - Types of inventory

3 - Cycle inventory

4 - Holding cost and ordering cost

5 - Zara and seven eleven

6 - EOQ

7 - EOQOne product

7 - EOQ-Variaattions.xlsx

8 - EOQsame truck

9 - EOQmany suppliers

10 - Algorithm for flexible order subsetting

11 - Algorithm for flexible order subsettingpart2

12 - Product subset part3

13 - Algorithm for product subsetting step 4

13 - EOQ-Variaattions-solved.xlsx

14 - EOQ-DISCOUNTS-UNSOVED.xlsx

14 - Volume discounts

15 - Volume Discounts in Excel

16 - EOQ-DISCOUNTS-SOLVED.xlsx

16 - marginal discounts

17 - EOQ with limited time discounts

18 - Limited time discounts

19 - Demand Curve change with EOQ

20 - Summary

21 - Game plan

2 - Inventory aggregation metrics and distribution

22 - Introduction

23 - A brief on inventory policies

24 - Fill rate and service level for uncertain demand

25 - Bike Co

26 - Bike Co flow time and average inventory

27 - Bike Co Desired service level

28 - Bike co cycle service level

29 - Desired fill rate

30 - Inventory aggregation

31 - Shopico Example

32 - Scenario 1 Disaggregation

33 - Scenario 2 Aggregation

34 - HighMed

35 - HighMed Part 1

36 - HighMed Part 2

37 - Inventory Cost

38 - Which option is better

39 - Temporal aggregation

40 - Conclusion

41 - Summary

3 - Welcome to Python

42 - Python

43 - downloading Anaconda

44 - Installing Anaconda

45 - Spyder overview

46 - Jupiter Notebook overview

47 - Python Libraries

48 - inventorize

49 - Summary

4 - Python Programming Fundmentals

50 - Intro

50 - Python-Data-structures-cheat-sheet.pdf

51 - Dataframes

51 - Section-4.ipynb.zip

52 - Arithmetic calculations with python

52 - online-retail2.csv.zip

53 - Lists

54 - Dictionaries

54 - Pandas-Basics.pdf

55 - Arrays

56 - Importing data in Python

57 - Subsetting Dataframes

58 - Conditions

59 - Writing functions

60 - Mapping

61 - For loops

62 - For looping a function

63 - Mapping on a DataFrame

64 - For looping on a Dataframe

64 - python-cheat-sheet-intermediate.pdf

65 - Summary

66 - Assignment

66 - assignment-questions-python-fundmentals.docx

66 - cars.csv

66 - python-fundmentals-assignment.zip

67 - Assignment answer 1

68 - Assignment answer 2

5 - Inventory with Python

69 - Program for EOQ aalgorithm

70 - Revisiting BikeCo

70 - bikeco-unsolved.zip

71 - Cycle service level in python

72 - Expected item fill rate in python

73 - Goal seek function

74 - Desired fill rate

74 - bikeco.zip

75 - Revisiting EOQ with many suppliers

75 - eoq-not-solved.zip

76 - Introducing the case in python

77 - EOQ with inventorize

78 - Step 2 and step 3

79 - global order frequency for product subsetting

80 - Total cost of the system

80 - eoq-solved.zip

6 - Segmentation classification and inventory simulations

81 - Inventory Dynamics intro

82 - Why we need segmentation

83 - An example in Excel

84 - Product classfication

85 - ABC dynamic with inventorize

85 - sample.csv

85 - segmentation-inventory-not-solved.zip

86 - The long tail

87 - Category mix on multiple products

88 - Min max policy

89 - Min Q and Periodic Policy

90 - RsS and basestockpolicy

91 - Connecting demand with service level

92 - Running the simulation on all articles

93 - Understanding the results

93 - segmentation-inventory-solved.zip

94 - Assignment

94 - assignment-peridodic.zip

94 - assignment-review.xlsx

95 - Assignment solution

95 - assignment-peridodic.zip

96 - Summary

7 - Which forecasting is better for a specific inventory policy

97 - Introduction

98 - Forecasting demonstraion

99 - Max Policy

100 - Preparing the notebook

100 - inventory-with-forecasting-not-solved.zip

101 - Preparing for forecasting

102 - Forecasting our first sku

103 - Forecasting all SKUs

103 - data-forecast.xlsx

104 - MaxpolicyDynamic

105 - Inventory Comparison between KNN and ARIMA

106 - Assigning cycle service level and preparing for simulation

107 - Running the simulation

108 - Which forecast is better in terms of inventory

108 - inventory-with-forecasting-not-solved.zip

8 - Seasonal Inventory

109 - Intro

110 - Seasonal Products

111 - Point of Maximum profit

112 - How much I will sell

113 - Dataable

114 - Critical ratio

115 - Critical ratio in excel

116 - Whats actually happening

117 - Critical ratio in python

117 - retail-clean.csv.zip

117 - section17.zip

118 - Preparing the data for MPN

119 - Creating margin of error

120 - Applying MPN on all data

121 - Conclusion

122 - Seasonal inventory summary

123 - Assignment solution

123 - seasonal-inventory-answer.zip

123 - seasonal-inventory-question.docx

124 - Seasonal inventory answer

125 - Markdown model by JWalker

126 - Markdown model in python

127 - Final note

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy