Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    M A Te Ria LC o ST S: Center of Circle

    Uploaded by

    Rachel Young
    The document contains tables of data with metrics like size, performance, and price over multiple years and scenarios. It shows traditional, low end, high end, and performance projections for factors like size and price from 2015 to 2023. It also includes forecasts and actual values for different rounds of various products.

    Copyright:

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

    M A Te Ria LC o ST S: Center of Circle

    Uploaded by

    Rachel Young
    16 views12 pages
    The document contains tables of data with metrics like size, performance, and price over multiple years and scenarios. It shows traditional, low end, high end, and performance projections for factors like size and price from 2015 to 2023. It also includes forecasts and actual values for different rounds of various products.

    Original Title

    J411 1.2.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains tables of data with metrics like size, performance, and price over multiple years and scenarios. It shows traditional, low end, high end, and performance projections for factors like size and price from 2015 to 2023. It also includes forecasts and actual values for different rounds of various products.

    Copyright:

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

    M A Te Ria LC o ST S: Center of Circle

    Uploaded by

    Rachel Young
    The document contains tables of data with metrics like size, performance, and price over multiple years and scenarios. It shows traditional, low end, high end, and performance projections for factors like size and price from 2015 to 2023. It also includes forecasts and actual values for different rounds of various products.

    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 12

    Center of Circle

    Round

    Traditional
    Pfmn
    Size
    0
    5
    1
    5.7
    2
    6.4
    3
    7.1
    4
    7.8
    5
    8.5
    6
    9.2
    7
    9.9
    8
    10.6

    Optimal
    Round
    0
    1
    2
    3
    4
    5
    6
    7
    8

    Low End
    Pfmn
    Size
    15
    2.5
    14.3
    3
    13.6
    3.5
    12.9
    4
    12.2
    4.5
    11.5
    5
    10.8
    5.5
    10.1
    6
    9.4
    6.5

    Able
    Pfmn
    5
    5.7
    6.4
    7.1
    7.8
    8.5
    9.2
    9.9
    10.6

    High End
    Pfmn
    17.5
    7.5
    17
    8.4
    16.5
    9.3
    16
    10.2
    15.5
    11.1
    15
    12
    14.5
    12.9
    14
    13.8
    13.5
    14.7

    Acre

    Traditional
    Size
    15
    14.3
    13.6
    12.9
    12.2
    11.5
    10.8
    10.1
    9.4

    Able

    Acre

    Adam

    Adam

    Low End
    Pfmn
    Size
    1.7
    18.3
    2.2
    17.8
    2.7
    17.3
    3.2
    16.8
    3.7
    16.3
    4.2
    15.8
    4.7
    15.3
    5.2
    14.8
    5.7
    14.3

    High End
    Pfmn
    8.9
    9.8
    10.7
    11.6
    12.5
    13.4
    14.3
    15.2
    16.1

    2015

    2017

    28.00 $
    Change
    $
    $
    Change
    %
    Decr. Price for 30% CM
    Decr. Price for 50% CM

    2016

    27.00
    (1.00) $ (27.00)
    -3.57% -100.00%
    -$0.70
    -$18.90
    -$0.50
    -$13.50

    21.00
    Change
    $
    $
    (21.00) $
    Change
    %
    -100.00%
    #DIV/0!
    Decr. Price for 30% CM
    -$14.70
    $0.00
    Decr. Price for 50% CM
    -$10.50
    $0.00

    ter

    Change
    Change

    38.00
    $
    $
    (38.00) $
    %
    -100.00%
    #DIV/0!

    Decr. Price for 30% CM


    Decr. Price for 50% CM

    Aft

    Agape

    -$26.60
    -$19.00

    $0.00
    $0.00

    33.00
    Change
    $
    $
    (33.00) $
    Change
    %
    -100.00%
    #DIV/0!
    Decr. Price for 30% CM
    -$23.10
    $0.00
    Decr. Price for 50% CM
    -$16.50
    $0.00
    33.00
    Change
    $
    $
    (33.00) $
    Change
    %
    -100.00%
    #DIV/0!
    Decr. Price for 30% CM
    -$23.10
    $0.00
    Decr. Price for 50% CM
    -$16.50
    $0.00

    Acme

    $ 999.00
    Change
    $
    $ (999.00) $
    Change
    %
    -100.00%
    #DIV/0!
    Decr. Price for 30% CM
    -$699.30
    $0.00
    Decr. Price for 50% CM
    -$499.50
    $0.00

    Awe

    $ 999.00
    Change
    $
    $ (999.00) $
    Change
    %
    -100.00%
    #DIV/0!
    Decr. Price for 30% CM
    -$699.30
    $0.00
    Decr. Price for 50% CM
    -$499.50
    $0.00

    Avid

    $ 999.00
    Change
    $
    $ (999.00) $
    Change
    %
    -100.00%
    #DIV/0!
    Decr. Price for 30% CM
    -$699.30
    $0.00
    Decr. Price for 50% CM
    -$499.50
    $0.00

    +/- From Center


    Size

    Performance
    Pfmn
    Size
    12.5
    8
    11.6
    9
    10.7
    10
    9.8
    11
    8.9
    12
    8
    13
    7.1
    14
    6.2
    15
    5.3
    16

    Adam

    Size
    Pfmn
    17
    16.3
    15.6
    14.9
    14.2
    13.5
    12.8
    12.1
    11.4

    Aft

    High End
    Size
    11.1
    10.2
    9.3
    8.4
    7.5
    6.6
    5.7
    4.8
    3.9

    2018

    Pfmn
    Traditiona
    0
    Low End
    -0.8
    High End
    1.4
    Performan
    1.4
    Size
    1

    Size
    3
    3.7
    4.4
    5.1
    5.8
    6.5
    7.2
    7.9
    8.6

    12
    11
    10
    9
    8
    7
    6
    5
    4

    Change Each Year

    Agape

    Performance
    Pfmn
    Size
    9.4
    16
    10.4
    15.3
    11.4
    14.6
    12.4
    13.9
    13.4
    13.2
    14.4
    12.5
    15.4
    11.8
    16.4
    11.1
    17.4
    10.4

    Pfmn
    4
    4.7
    5.4
    6.1
    6.8
    7.5
    8.2
    8.9
    9.6

    Size
    13.6
    9.6
    8.6
    7.6
    6.6
    5.6
    4.6
    3.6
    2.6

    2019

    2021

    2022

    2020

    Size

    Pfmn
    Traditiona
    Low End
    High End
    Performan
    Size

    2023

    $
    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!

    +
    0.7
    0.5
    0.9
    1
    0.7

    $0.00
    $0.00

    $0.00
    $0.00

    $0.00
    $0.00

    $0.00
    $0.00

    $0.00
    $0.00

    $0.00
    $0.00

    $
    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    m Center
    Size
    0
    0.8
    -1.4
    -1
    -1.4

    Each Year
    Size -0.7
    -0.5
    -0.9
    -0.7
    -1

    Total Segment Demand


    Segment Traditional Low End High End Performance
    Size
    Growth
    Rate
    9.20%
    11.70%
    16.20%
    19.80%
    18.30%
    0
    7387
    8960
    2554
    1915
    1984
    1
    8067
    10008
    2968
    2294
    2347
    2
    8809
    11179
    3449
    2748
    2777
    3
    9619
    12487
    4007
    3293
    3285
    4
    10504
    13948
    4656
    3945
    3886
    5
    11470
    15580
    5411
    4726
    4597
    6
    12526
    17403
    6287
    5661
    5438
    7
    13678
    19439
    7306
    6782
    6433
    8
    14937
    21714
    8489
    8125
    7611
    robo way
    3600
    Traditional (Able)
    sould have 2626 to 2862
    Rounds
    1
    2
    3
    4
    5
    frocast
    worst (mar 1395.2911 1616.2107 1919.645 1484.347826 1985.217
    Base
    1604.5848 1858.6424 2207.591
    1707
    2283
    Best (pro) 1845.2725 1970.1609 2340.047
    1843.56 2625.45
    Actual
    1434
    1656
    1672
    1844
    2307
    low end
    acre
    3850
    4072
    Rounds
    1
    2
    3
    4
    5
    frocast
    worst (mar 1740.5774 1633.149 2345.435 2631.980065 2590.383
    Base
    2001.664 1878.1213 2697.25 3026.777075 2978.94
    Best (pro) 2301.9136 2065.9334 3047.893 3268.919241 3306.623
    Actual
    1746
    2066
    2772
    2846
    3342
    high end Adam
    1400
    Rounds
    1
    2
    3
    4
    5
    frocast
    worst (mar 516.13009 407.82535 745.6847 615.4476996 479.9034
    Base
    593.5496 468.99915 857.5374 707.7648545 551.889
    Best (pro) 682.58204 539.34902 1003.319 799.7742856 634.6723
    Actual
    458
    540
    690
    724
    576
    proformance Aft
    2760
    2238
    Rounds
    1
    2
    3
    4
    5
    frocast
    worst (mar 398.98609 1015.7188 1405.798 1633.381383 1955.969
    Base
    458.834 1168.0767 1616.668 1878.38859 2249.364
    Best (pro)
    527.6591 1284.8843 1826.834 2066.227449 2474.301
    Actual
    623
    1188
    1467
    1900
    2045
    size
    Agape
    2700
    1881
    Rounds
    1
    2
    3
    4
    5
    frocast
    worst (mar 408.18643 992.32776 1249.615 1283.478261 2282.463
    Base
    469.4144 1141.1769 1437.057
    1476 2624.832
    Best (pro) 539.82656 1312.3535 1652.615
    1549.8 2756.074

    frocast

    frocast

    Actual
    Low (Acme)
    Rounds
    worst (mar
    Base
    Best (pro)
    Actual
    High (Apple)
    Rounds
    worst (mar
    Base
    Best (pro)
    Actual

    459

    1294
    1243
    1514
    1881
    1000
    -2697
    1
    2
    3
    4
    5
    0 251.24034 251.2403 907.6823398 661.1437
    288.9264 288.9264 1043.834691 760.3152
    0 306.26198 332.2654 1106.464772 874.3625
    241
    312
    594
    660
    1300
    15662
    1
    2
    3
    4
    5
    0
    0
    0
    701.693
    0
    0
    250 806.9469
    0
    0
    0
    927.989
    64
    853

    for Acme
    593.9656

    15 day recivable lag

    6
    7
    8
    2436.532 2735.625 2987.302
    2802.011 3145.969 3435.398
    3222.313 3617.864 3950.708

    6
    7
    8
    4903.139 3042.67 4153.921
    5638.61 3499.071 4777.009
    6371.629 3953.95 5398.02

    up pro

    6
    7
    8
    789.4543 863.9823 1003.947
    907.8725 993.5797 1154.54
    1044.053 1142.617 1327.721
    up roduction
    6
    7
    8
    1946.087 2653.879 3179.347
    2238 3051.961 3656.25
    2573.7 3509.755 4204.687

    6
    7
    8
    1943.543 2299.211 2719.967
    2235.074 2644.093 3127.962
    2570.335 3040.707 3597.156

    6
    7
    8
    3121.628 3486.858 3894.821
    3589.872 4009.887 4479.044
    4128.353 4611.37
    5150.9

    6
    7
    8
    741.8968 1259.694 1463.764
    853.1814 1448.648 1683.329
    981.1586 1665.945 1935.828

    2015

    2016

    2017

    2018

    Able

    $ 11.28 $ 11.25
    Change
    $
    $ (0.03) $ (11.25) $
    Change
    %
    -0.27% -100.00%
    #DIV/0!
    Change Price for 30% CM
    -$0.02
    -$7.88
    $0.00
    Change Pricefor 50% CM
    -$0.01
    -$5.63
    $0.00

    Acre

    $
    7.63 $
    6.97
    Change
    $
    $ (0.66) $ (6.97) $
    Change
    %
    -8.65% -100.00%
    #DIV/0!
    Change Price for 30% CM
    -$0.46
    -$4.88
    $0.00
    Change Pricefor 50% CM
    -$0.33
    -$3.49
    $0.00

    osts
    ial C

    Adam

    $ 16.25
    $
    0.72 $ (16.25) $
    4.64% -100.00%
    #DIV/0!
    $0.50
    -$11.38
    $0.00
    $0.36
    -$8.13
    $0.00

    Aft

    $ 15.79
    $
    0.34 $ (15.79) $
    2.20% -100.00%
    #DIV/0!
    $0.24
    -$11.05
    $0.00
    $0.17
    -$7.90
    $0.00

    Agape

    $ 13.42
    $
    0.19 $ (13.42) $
    1.44% -100.00%
    #DIV/0!
    $0.13
    -$9.39
    $0.00
    $0.09
    -$6.71
    $0.00

    $ 15.53
    Change
    $
    Change
    %
    Change Price for 30% CM
    Change Pricefor 50% CM
    $ 15.45
    Change
    $
    Change
    %
    Change Price for 30% CM
    Change Pricefor 50% CM
    $ 13.23
    Change
    $
    Change
    %
    Change Price for 30% CM
    Change Pricefor 50% CM

    Acme

    $ 17.04 $ 17.04
    Change
    $
    $
    $ (17.04) $
    Change
    %
    0.00% -100.00%
    #DIV/0!
    Change Price for 30% CM
    $0.00
    -$11.93
    $0.00
    Change Pricefor 50% CM
    $0.00
    -$8.52
    $0.00

    Awe

    $ 999.00
    Change
    $
    $(999.00) $
    $
    Change
    %
    -100.00%
    #DIV/0!
    #DIV/0!
    Change Price for 30% CM
    -$699.30
    $0.00
    $0.00
    Change Pricefor 50% CM
    -$499.50
    $0.00
    $0.00

    Avid
    $ 999.00
    Change
    $
    $(999.00) $
    $
    Change
    %
    -100.00%
    #DIV/0!
    #DIV/0!
    Change Price for 30% CM
    -$699.30
    $0.00
    $0.00
    Change Pricefor 50% CM
    -$499.50
    $0.00
    $0.00

    2019

    2020

    2021

    2022

    2023

    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    $
    $
    $
    $
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    #DIV/0!
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00
    $0.00

    You might also like