Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    Historical Sales Figure of Company X Year Sales (In Pesos) % Growth Rate

    Uploaded by

    sherryl cao
    The document summarizes the historical sales figures of Company X from 2001 to 2010. It shows the sales amount and growth rate for each year. The average growth rate over the period was 21.96%. Projected sales for 2011 and 2012 were then calculated by applying the average growth rate to 2010 sales. A second table presents corresponding sales data for Company Y along with a cross-tabulation of year and sales for both companies.

    Copyright:

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

    Historical Sales Figure of Company X Year Sales (In Pesos) % Growth Rate

    Uploaded by

    sherryl cao
    16 views2 pages
    The document summarizes the historical sales figures of Company X from 2001 to 2010. It shows the sales amount and growth rate for each year. The average growth rate over the period was 21.96%. Projected sales for 2011 and 2012 were then calculated by applying the average growth rate to 2010 sales. A second table presents corresponding sales data for Company Y along with a cross-tabulation of year and sales for both companies.

    Original Title

    Forecasting

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document summarizes the historical sales figures of Company X from 2001 to 2010. It shows the sales amount and growth rate for each year. The average growth rate over the period was 21.96%. Projected sales for 2011 and 2012 were then calculated by applying the average growth rate to 2010 sales. A second table presents corresponding sales data for Company Y along with a cross-tabulation of year and sales for both companies.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    16 views2 pages

    Historical Sales Figure of Company X Year Sales (In Pesos) % Growth Rate

    Uploaded by

    sherryl cao
    The document summarizes the historical sales figures of Company X from 2001 to 2010. It shows the sales amount and growth rate for each year. The average growth rate over the period was 21.96%. Projected sales for 2011 and 2012 were then calculated by applying the average growth rate to 2010 sales. A second table presents corresponding sales data for Company Y along with a cross-tabulation of year and sales for both companies.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 2

    Historical Sales Figure of Company X

    Year Sales(In Pesos) % Growth Rate


    2001 23,200,000 0
    2002 24,100,000 3.88%
    2003 40,300,000 67.22%
    2004 30,200,000 -25.06%
    2005 35,800,000 18.54%
    2006 15,600,000 -56.42%
    2007 24,900,000 59.62%
    2008 25,800,000 3.61%
    2009 52,700,000 104.26%
    2010 52,705,000 0.01%
    175.66%

    Average Growth Rate= 175.66%


    8
    21.96%

    Projected Values For Year 2011

    Growth = 52,705,000 x 21.96% 11,572,605


    2010 52,705,000
    2011 64,277,605

    Projected Values For Year 2012

    Growth = 64,277,605 x 21.96% 14,113,639


    2011 64,277,605
    2012 78,391,244

    Historical Sales Figure of Company Y


    Year X Sales In Pesos(Y) XY
    2001 (4) 23,200,000 (92,800,000)
    2002 (3) 24,100,000 (72,300,000)
    2003 (2) 40,300,000 (80,600,000)
    2004 (1) 30,200,000 (30,200,000)
    2005 0 35,800,000 -
    2006 1 15,600,000 15,600,000
    2007 2 24,900,000 49,800,000
    2008 3 25,800,000 77,400,000
    2009 4 52,700,000 210,800,000
    272,600,000 77,700,000
    16
    9
    4
    1
    0
    1
    4
    9
    16
    60

    You might also like