Supply Chain Tutorials
Supply Chain Tutorials
  • 11
  • 273 033
An Application of Newsvendor Problem to Determining the Order Size at a Local Coffee Producer
This video describes the newsvendor problem, goes through the derivation of the critical factor that is used to determine the order size. The video concludes with an example problem that determines the expected demand, order size,and the expected profit associated with this order size.
It is recommended you to read the problem description at sites.google.com/su.edu/orkunbaycik/video-tutorials/supply-chain-tutorials/11-an-application-of-newsvendor-problem-to-determining-the-order-size? before you start watching the video.
zhlédnutí: 22 344

Video

An Application of the Impact of Aggregation on Safety Inventory
zhlédnutí 2,2KPřed 8 lety
This video illustrates an example of the impact of aggregation on safety inventory for a clothing company that sells t-shirts in two locations. We aim to analyze and compare the safety stock levels when (1) the inventory is not centralized (2) the inventory is centralized. It is recommended you to read the problem description at sites.google.com/su.edu/orkunbaycik/video-tutorials/supply-chain-t...
An Application of Economic Order Quantity (EOQ) Model - Multiple Items
zhlédnutí 8KPřed 8 lety
This video illustrates an application of Economic Order Quantity (EOQ) model for the case we consider multiple items. For multiple item case, we have two scenarios: (1) Order the items separately (2) Order the items jointly. We solve an example of ordering two types of ground coffee for a coffee shop, and compare the two scenarios (data are randomly generated). It is recommended you to read the...
Aggregate Planning for a Local Coffee Producer
zhlédnutí 949Před 8 lety
This video illustrates an application of Aggregate Planning problem. The learning objective is to understand the sets, data, and the decision variables to be used in the formulation, and then formulating the mathematical model given these values. It is recommended you to read the problem description at sites.google.com/su.edu/orkunbaycik/video-tutorials/supply-chain-tutorials/8-aggregate-planni...
Forecasting Techniques: Trend and Seasonality-Corrected (Winter's Method)
zhlédnutí 108KPřed 8 lety
It is recommended you to read the problem description at sites.google.com/su.edu/orkunbaycik/video-tutorials/supply-chain-tutorials/7-forecasting-techniques-trend-and-seasonality-corrected-exponentia? before you start watching the video.
Forecasting Techniques: Trend-Corrected Exponential Smoothing Method (Holt's Method)
zhlédnutí 50KPřed 8 lety
This video illustrates an application of Trend-corrected exponential smoothing technique. The goal in this video is to walk through the steps in this forecasting technique, compute the error measurements, and how to find the best parameter values to obtain the minimum error. It is recommended you to read the problem description at sites.google.com/su.edu/orkunbaycik/video-tutorials/supply-chain...
Forecasting Techniques: Simple Exponential Smoothing
zhlédnutí 22KPřed 8 lety
This video illustrates an application of simple exponential smoothing technique. The goal in this video is to walk through the steps in this forecasting technique, compute the error measurements, and how to find the best parameter values to obtain the minimum error. It is recommended you to read the problem description at sites.google.com/su.edu/orkunbaycik/video-tutorials/supply-chain-tutorial...
An Application of Facility Location and Capacity Allocation Problem
zhlédnutí 15KPřed 8 lety
This video illustrates an application of Facility Location and Capacity Allocation problem to opening coffee shops and meeting the coffee demand of the students at RPI campus by minimizing the total cost. The learning objective is to understand the sets, data, and the decision variables to be used in the formulation, and then formulating the mathematical model given these values. It is recommen...
Using Greedy Heuristic to Solve a Weighted Set Cover Problem
zhlédnutí 8KPřed 8 lety
The aim of this video is to demonstrate how to apply Greedy heuristic to solve a weighted set cover problem . The video includes the formulation of the Weighted Set Cover Problem to Opening Coffee Shops and presents the steps followed in Greedy heuristic.
Using Excel Solver to Solve a Given Mathematical Model
zhlédnutí 9KPřed 8 lety
The aim of this video is to demonstrate how to use Excel solver to solve mathematical models to optimality. The video includes the formulation of the Weighted Set Cover Problem to Opening Coffee Shops and presents the steps to find the optimal solution. It also organizes the spreadsheet in a way that the data and the solution found by the solver is readable.
An Application of Set Cover Problem to Opening Coffee Shops
zhlédnutí 26KPřed 8 lety
This video contains an application of the Set Cover Problem to opening coffee shops at RPI campus. It includes the approach to formulate the mathematical formulation of this particular example along with the more generalized form of the Set Cover Problem. It is recommended you to read the problem description atsites.google.com/su.edu/orkunbaycik/video-tutorials/supply-chain-tutorials/1-set-cove...

Komentáře

  • @just_j9621
    @just_j9621 Před 9 měsíci

    Why the expected loss and the expected gain is c times g(Q) ? Can you give me an intuitive explanation plz?

  • @Hattm
    @Hattm Před rokem

    Thanks for the explanation sir!

  • @stayfocused6374
    @stayfocused6374 Před rokem

    Great explanation but your formulas notations seem incorrect. It seems like you are forecasting the future based on future data. Is it that your t+1 refers to cell positioning as opposed to the actual period coding?

  • @yorgundemokrat4615
    @yorgundemokrat4615 Před rokem

    teşekkürler hocam cidden çok sağolun

  • @thagoonlprusiriyodlpru4174

    Thank you so much

  • @katerynashvadchyna1270

    Thanks, I really need the modification of Holt-Winters without seasonality but with trend.

  • @user-fo7hu3lp3t
    @user-fo7hu3lp3t Před 2 lety

    ???????

  • @skillsandresearch2485

    Thanks sir. I have three data points of five years intervals.I want to forecast for 20 years. how I will do it?

  • @salmale3783
    @salmale3783 Před 2 lety

    you have really qualities of great professor thanks ,I understand <3

  • @lushG678
    @lushG678 Před 2 lety

    You're a God, thank you

  • @kaiming3057
    @kaiming3057 Před 3 lety

    Hi how do i find month 11 forecast?

  • @chakki9293
    @chakki9293 Před 3 lety

    Can you please share the excel file...not able to see the formula

  • @ChristineNguyen-dw2yn

    Thanks for this thorough walk through! If I wanted to forecast for week 21+, do I just drag and pull from formula I22 and adjust the changed value in the formula accordingly or is it a different process? Thanks!

  • @herdinanurislamiati4033

    what if the data is quarterly. is the procedure still the same?

  • @kazimsyed7367
    @kazimsyed7367 Před 3 lety

    ans : 2,7,8 ,13 i think

  • @Chanikpop
    @Chanikpop Před 3 lety

    Thank u

  • @aakritijoshi
    @aakritijoshi Před 3 lety

    Pls make more videos

  • @thanhthaovothi3576
    @thanhthaovothi3576 Před 3 lety

    Dear Mr, I'd like to send the greatest thank to your dedication on these useful explanations about this forecasting method. I wonder where you were for these previous years, why didnt you continue, Mr?

  • @scatheroy
    @scatheroy Před 3 lety

    Was going to answer Alpay Dincer's question from 3 years ago, but maybe it's useful for others. Not offering a declarative answer here, just sharing my experience. Paraphrased: "What does it mean if solver gives values of 0 for the smoothing constants?" Solver can certainly give you a values of the smoothing constants at or near zero. You can check this by increasing the number of decimal places excel displays for those cells. However, if you allow unconstrained variables to be negative (by unchecking "Make Unconstrained Variables Non-Negative)", you may get a clearer picture. In my experience this can happen in one of four scenarios: (a) The overall trend is negative or almost non-existent, and needs to be smoothed that way; (b) There aren't enough data points to meaningfully plot, which is confusing solver (do a regression on the forecast and check the f test and R^2); (c) there is little or no seasonality in your data (Same check as in point (b)); or (d) some combination of the previous three. Point (c) can happen if a business isn't properly marketing or promoting their product to create a steadily increasing level of demand; they will be (in effect) subject to exogenous factors (whims of consumers, weather, retail partner sales, etc.). Anyone else have any insights or experience they can share?

  • @1yyymmmddd
    @1yyymmmddd Před 3 lety

    Good explanation, however practical value of this exercise is doubtful as you arrive at no forecast whatsoever if you take Alpha=0.

  • @alvinnoviansyah4838
    @alvinnoviansyah4838 Před 3 lety

    God, this video is very clear, concise, and everything it needs to be. You are a great teacher sir. Thank you for the video.

  • @NazaninYari
    @NazaninYari Před 3 lety

    This video was super helpful. Thank you!

  • @siddharthpatil5775
    @siddharthpatil5775 Před 3 lety

    Thanks for working through this example!

  • @WinterSummerism
    @WinterSummerism Před 3 lety

    Thank you for the very informative video, but I was wondering how would you forecast July? or any months after May?

    • @smaranrai4898
      @smaranrai4898 Před 2 lety

      I had the same question, can somebody please help us with this?

  • @maxusknowledge
    @maxusknowledge Před 3 lety

    Nice Video. You can also refer to our website for more videos (www.maxusknowledge.com) or our CZcams channel czcams.com/users/maxusknowledge

  • @nyume815
    @nyume815 Před 3 lety

    I'll never understand why 6 and 5 were left as non feasible. I suppose that's arbitrary

  • @louiefrancisco501
    @louiefrancisco501 Před 3 lety

    Thank you for sharing ideas

  • @anujnegi5478
    @anujnegi5478 Před 3 lety

    In joint order costing you incorrectly put holding of pumpink as .25 instead of .20

  • @Bruceta
    @Bruceta Před 3 lety

    In fact, in my opinion you do not save any money ordering jointly, vs ordering separately, because the TC/box will be in both cases $7.50

  • @lucadiedolo3421
    @lucadiedolo3421 Před 3 lety

    Objective: 41575.0 Open facilities: y0 y1 y2 Facility-Client assignments: 100.00 0.00 0.00 0.00 80.00 0.00 0.00 90.00 0.00 0.00 0.00 75.00 0.00 0.00 125.00 150.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Nice example BTW, this should be the optimal solution, using the first three facilities, according to Google OR-Tools (CBC_MIXED_INTEGER_PROGRAMMING solver)

    • @lucadiedolo3421
      @lucadiedolo3421 Před 3 lety

      Obs: If you try to decrease capacities, you can see that the demand is splitted among facilities

  • @krishsrinivasan6884
    @krishsrinivasan6884 Před 4 lety

    The link to your website and the read up problem statement is not working. Gives 404 error.

  • @ashurbekislamov6268
    @ashurbekislamov6268 Před 4 lety

    sir, can you send me this file?

  • @claudiaf.2447
    @claudiaf.2447 Před 4 lety

    I have an exam tomorrow and could not for the life of me figure out how to calculate the expected profit when given a stochastic demand. It is very clear to me now, thank you!

  • @mata300147
    @mata300147 Před 4 lety

    thanks you

  • @chapinero017
    @chapinero017 Před 4 lety

    Why can't I get a person like you to be my professor? QQ

  • @Stl71
    @Stl71 Před 4 lety

    I am trying to solve a similar problem but I have a problem : I get variables that are double numbers and of course it can't be accepted, since coffee shops should have at least a variable of 1. Could you help?

  • @user-mv3zu3ny9u
    @user-mv3zu3ny9u Před 4 lety

    Hei. Thank you for the video. Please correct me if I'm wrong, the highlighted section in column 3 starts two cells after and ends two cells before the cells in column two because "p" is equal to 4. What if "p" is 7? How many cells after and before should be the highlighted area? Thank!

  • @Guilopes99
    @Guilopes99 Před 4 lety

    Thanks for the explanation! How could I add the confidence interval's upper and lower bounds?

  • @Guilopes99
    @Guilopes99 Před 4 lety

    Thank you very much! Would this give me equal results as with the forecats tool in excel? Or that one is not trend corrected?

  • @syednazirhussain158
    @syednazirhussain158 Před 4 lety

    Highly appreciated...

  • @mrluthfianto
    @mrluthfianto Před 4 lety

    Hi, do you have the updated link to the slide? The link is dead

  • @lachezardinchev2217
    @lachezardinchev2217 Před 4 lety

    Thank you sooo much for your explanation!

  • @perceptionist6429
    @perceptionist6429 Před 4 lety

    Great video! Beautifully explained.

  • @raperdan
    @raperdan Před 4 lety

    can you tell me how did you programm this? which software did you use?

  • @mikotomione
    @mikotomione Před 4 lety

    Alpha must be higher, than Beta...

  • @corndogs68
    @corndogs68 Před 5 lety

    Fantastic video. Are you at all concerned that solver may overfit your model?

  • @biplabrout9605
    @biplabrout9605 Před 5 lety

    Very well explained. Thank you

  • @joyantamitra8186
    @joyantamitra8186 Před 5 lety

    why s13 for F17

  • @ilucian2792
    @ilucian2792 Před 5 lety

    Ok, good explanations but is there any algorithm that solves the problem?

  • @jacobusjacobs76
    @jacobusjacobs76 Před 5 lety

    Great video. Did you know you can use F4 instead of adding the $ individually? saves a lot of frustrations and time.