Supply Chain Tutorials
Supply Chain Tutorials
  • 11
  • 276 563
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.
มุมมอง: 22 513

วีดีโอ

An Application of the Impact of Aggregation on Safety Inventory
มุมมอง 2.3K9 ปีที่แล้ว
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
มุมมอง 8K9 ปีที่แล้ว
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
มุมมอง 9769 ปีที่แล้ว
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)
มุมมอง 110K9 ปีที่แล้ว
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)
มุมมอง 51K9 ปีที่แล้ว
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
มุมมอง 22K9 ปีที่แล้ว
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
มุมมอง 16K9 ปีที่แล้ว
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
มุมมอง 8K9 ปีที่แล้ว
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
มุมมอง 9K9 ปีที่แล้ว
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
มุมมอง 26K9 ปีที่แล้ว
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...

ความคิดเห็น

  • @just_j9621
    @just_j9621 ปีที่แล้ว

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

  • @Hattm
    @Hattm ปีที่แล้ว

    Thanks for the explanation sir!

  • @stayfocused6374
    @stayfocused6374 2 ปีที่แล้ว

    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 2 ปีที่แล้ว

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

  • @thagoonlprusiriyodlpru4174
    @thagoonlprusiriyodlpru4174 2 ปีที่แล้ว

    Thank you so much

  • @katerynashvadchyna1270
    @katerynashvadchyna1270 2 ปีที่แล้ว

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

  • @人生休閒
    @人生休閒 2 ปีที่แล้ว

    ???????

  • @skillsandresearch2485
    @skillsandresearch2485 2 ปีที่แล้ว

    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 2 ปีที่แล้ว

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

  • @lushG678
    @lushG678 3 ปีที่แล้ว

    You're a God, thank you

  • @kaiming3057
    @kaiming3057 3 ปีที่แล้ว

    Hi how do i find month 11 forecast?

  • @chakki9293
    @chakki9293 3 ปีที่แล้ว

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

  • @ChristineNguyen-dw2yn
    @ChristineNguyen-dw2yn 3 ปีที่แล้ว

    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
    @herdinanurislamiati4033 3 ปีที่แล้ว

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

  • @dawn-of-newday
    @dawn-of-newday 3 ปีที่แล้ว

    ans : 2,7,8 ,13 i think

  • @ivinymoon
    @ivinymoon 3 ปีที่แล้ว

    Thank u

  • @aakritijoshi
    @aakritijoshi 3 ปีที่แล้ว

    Pls make more videos

  • @thanhthaovothi3576
    @thanhthaovothi3576 3 ปีที่แล้ว

    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 3 ปีที่แล้ว

    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 3 ปีที่แล้ว

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

  • @alvinnoviansyah4838
    @alvinnoviansyah4838 4 ปีที่แล้ว

    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 4 ปีที่แล้ว

    This video was super helpful. Thank you!

  • @siddharthpatil5775
    @siddharthpatil5775 4 ปีที่แล้ว

    Thanks for working through this example!

  • @WinterSummerism
    @WinterSummerism 4 ปีที่แล้ว

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

    • @learn_with_rungmang
      @learn_with_rungmang 3 ปีที่แล้ว

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

  • @maxusknowledge
    @maxusknowledge 4 ปีที่แล้ว

    Nice Video. You can also refer to our website for more videos (www.maxusknowledge.com) or our TH-cam channel th-cam.com/users/maxusknowledge

  • @nyume815
    @nyume815 4 ปีที่แล้ว

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

  • @louiefrancisco501
    @louiefrancisco501 4 ปีที่แล้ว

    Thank you for sharing ideas

  • @anujnegi5478
    @anujnegi5478 4 ปีที่แล้ว

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

  • @Bruceta
    @Bruceta 4 ปีที่แล้ว

    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 4 ปีที่แล้ว

    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 4 ปีที่แล้ว

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

  • @krishsrinivasan6884
    @krishsrinivasan6884 4 ปีที่แล้ว

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

  • @ashurbekislamov6268
    @ashurbekislamov6268 4 ปีที่แล้ว

    sir, can you send me this file?

  • @claudiaf.2447
    @claudiaf.2447 4 ปีที่แล้ว

    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 4 ปีที่แล้ว

    thanks you

  • @chapinero017
    @chapinero017 4 ปีที่แล้ว

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

  • @Stl71
    @Stl71 4 ปีที่แล้ว

    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?

  • @ИлиянКостов-т1щ
    @ИлиянКостов-т1щ 4 ปีที่แล้ว

    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 4 ปีที่แล้ว

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

  • @Guilopes99
    @Guilopes99 4 ปีที่แล้ว

    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 4 ปีที่แล้ว

    Highly appreciated...

  • @mrluthfianto
    @mrluthfianto 4 ปีที่แล้ว

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

  • @lachezardinchev2217
    @lachezardinchev2217 4 ปีที่แล้ว

    Thank you sooo much for your explanation!

  • @perceptionist6429
    @perceptionist6429 4 ปีที่แล้ว

    Great video! Beautifully explained.

  • @raperdan
    @raperdan 5 ปีที่แล้ว

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

  • @iamtamasmiko
    @iamtamasmiko 5 ปีที่แล้ว

    Alpha must be higher, than Beta...

  • @corndogs68
    @corndogs68 5 ปีที่แล้ว

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

  • @biplabrout9605
    @biplabrout9605 5 ปีที่แล้ว

    Very well explained. Thank you

  • @joyantamitra8186
    @joyantamitra8186 5 ปีที่แล้ว

    why s13 for F17

  • @ilucian2792
    @ilucian2792 5 ปีที่แล้ว

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

  • @jacobusjacobs76
    @jacobusjacobs76 5 ปีที่แล้ว

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