Scribd Logo
Upload

Welcome to Scribd!

  • 144 views

    Forecasting Assignment

    Uploaded by

    hamza asad
    Students are instructed to form groups and forecast demand for 4 items over the next 6 periods using historical demand data provided. They are to analyze trends in the data using Excel and calculate forecasts using trend line equations. The demand data and forecasts are to be entered into separate Excel sheets for each item.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Forecasting Assignment

    Uploaded by

    hamza asad
    144 views8 pages
    Students are instructed to form groups and forecast demand for 4 items over the next 6 periods using historical demand data provided. They are to analyze trends in the data using Excel and calculate forecasts using trend line equations. The demand data and forecasts are to be entered into separate Excel sheets for each item.

    Original Description:

    forecasting assignment

    Original Title

    forecasting assignment

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Students are instructed to form groups and forecast demand for 4 items over the next 6 periods using historical demand data provided. They are to analyze trends in the data using Excel and calculate forecasts using trend line equations. The demand data and forecasts are to be entered into separate Excel sheets for each item.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    144 views8 pages

    Forecasting Assignment

    Uploaded by

    hamza asad
    Students are instructed to form groups and forecast demand for 4 items over the next 6 periods using historical demand data provided. They are to analyze trends in the data using Excel and calculate forecasts using trend line equations. The demand data and forecasts are to be entered into separate Excel sheets for each item.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 8

    Instructions

    1 Students are required to make a group of 3 or 4 students.


    2 You have been given previous demand figures of 4 different items.
    3 Each group's assignment is to forecast demand for the next 6 periods for each item (P13, P14, P15, P16
    4 You have 5 Excel sheets. Fill each item in it's respective Sheet.
    5 Attempt this assignment in Excel.

    Item # Period Quantity Item #1 M-4L942L-D


    S-7KI75P-A 7 520 Item #2 T-4VL39S-C
    T-4VL39S-C 5 337 Item #3 I-2CR64J-E
    I-2CR64J-E 4 375 Item #4 S-7KI75P-A
    I-2CR64J-E 8 239
    M-4L942L-D 3 728
    S-7KI75P-A 2 352
    I-2CR64J-E 3 483
    T-4VL39S-C 9 433
    I-2CR64J-E 12 587
    M-4L942L-D 2 741
    S-7KI75P-A 4 313
    M-4L942L-D 12 756
    T-4VL39S-C 10 459
    S-7KI75P-A 3 416
    M-4L942L-D 6 752
    M-4L942L-D 9 729
    S-7KI75P-A 10 550
    M-4L942L-D 8 768
    T-4VL39S-C 4 314
    T-4VL39S-C 2 268
    T-4VL39S-C 3 289
    S-7KI75P-A 1 287
    M-4L942L-D 11 748
    S-7KI75P-A 9 449
    I-2CR64J-E 2 618
    M-4L942L-D 7 736
    T-4VL39S-C 11 481
    I-2CR64J-E 11 457
    I-2CR64J-E 7 210
    M-4L942L-D 5 718
    T-4VL39S-C 8 409
    I-2CR64J-E 1 666
    S-7KI75P-A 6 440
    M-4L942L-D 4 773
    M-4L942L-D 10 777
    T-4VL39S-C 7 391
    S-7KI75P-A 12 489
    I-2CR64J-E 5 303
    M-4L942L-D 1 751
    S-7KI75P-A 8 391
    I-2CR64J-E 6 242
    I-2CR64J-E 9 342
    T-4VL39S-C 6 367
    T-4VL39S-C 12 500
    S-7KI75P-A 11 650
    T-4VL39S-C 1 250
    S-7KI75P-A 5 359
    I-2CR64J-E 10 396
    ons
    of 3 or 4 students.
    4 different items.
    each item (P13, P14, P15, P16, P17, P18).
    spective Sheet.
    l.
    item#1 period(x) quantity(y)
    M-4L942L-D 1 751
    2 741
    3 728
    4 773
    5 718
    6 752
    7 736
    8 768
    9 729
    10 777
    11 748
    12 756
    13 757
    14 758
    15 759
    16 760
    17 762
    18 763
    trend line equation: y=a+bx
    a= y intercept
    b= slope of the line

    slope=1.31

    1.3111888112

    y intercept=739.56

    739.5606060606
    trend line equation: y=1.31x+739.56

    using trend line equation to calculate the demand


    p13=757
    p14=758
    p15=759
    p16=760
    p17=762
    p18=763
    item#2 Period(x) Quantity(y) trend line equation: y=a+bx
    T-4VL39S-C 1 250 a= y intercept
    2 268 b= slope of the line
    3 289
    4 314 23.3986013986
    5 337 slope=23.4
    6 367
    7 391 222.7424242424
    8 409 y intercept= 222.74
    9 433
    10 459 trend line equation: y=222.74+23.4x
    11 481
    12 500 using trend line equation to calculate the demand
    13 527 p13=527
    14 550 p14=550
    15 574 p15=574
    16 597 p16=597
    17 620 p17=620
    18 644 p18=644
    item#3 Period Quantity trend line equation: y=bx+a
    I-2CR64J-E 1 666 a= y intercept
    2 618 b= slope of the line
    3 483
    4 375 -11.5944055944
    5 303 slope= -11.59
    6 242
    7 210 485.196969697
    8 239 y intercept= 485.19
    9 342
    10 396 trend line equation: y= -11.59x+458.19
    11 457
    12 587 using trend line equation to calculate the demand
    13 308 p13=308
    14 296 p14=296
    15 284 p15=284
    16 273 p16=273
    17 261 p17=261
    18 250 p18=250
    item#4 Period Quantity trend line eqution: y=bx+a
    S-7KI75P-A 1 287 a= y intercept
    2 352 b= slope of the line
    3 416
    4 313 23.4195804196
    5 359 slope=23.42
    6 440
    7 520 282.4393939394
    8 391 y intercept=282.44
    9 449
    10 550 trend line eqution: y=23.42x+282.44
    11 650
    12 489 Using trend line equation to calculate the demand
    13 587 p13=587
    14 610 p14=610
    15 634 p15=634
    16 657 p16=657
    17 681 p17=681
    18 704 p18=704

    You might also like