Financials

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 8

Timeline Values Forecast Lower Confidence Bound Upper Confidence Bound

01/09/2013 $21,817.23
01/10/2013 $23,682.79 $45,000.00
01/11/2013 $21,871.49 $40,000.00
01/12/2013 $19,758.97
$35,000.00
01/01/2014 $23,257.96
01/02/2014 $32,815.64 $30,000.00

01/03/2014 $19,701.97 $25,000.00


01/04/2014 $27,352.49 $20,000.00
01/05/2014 $23,675.43
$15,000.00
01/06/2014 $21,053.63
01/07/2014 $27,172.52 $10,000.00

01/08/2014 $22,601.90 $5,000.00


01/09/2014 $29,232.35 $0.00
01/10/2014 $25,456.94 01/09/2013 0
01/11/2014 $17,274.29
01/12/2014 $29,790.68 $29,790.68 $29,790.68 $29,790.68
01/01/2015 $26,970.16 $17,690.43 $36,249.88
01/02/2015 $28,166.01 $18,811.75 $37,520.27
01/03/2015 $23,468.06 $14,038.69 $32,897.44
01/04/2015 $27,479.51 $17,973.28 $36,985.74
01/05/2015 $28,675.36 $19,092.89 $38,257.83
01/06/2015 $23,977.41 $14,318.14 $33,636.68
$45,000.00

$40,000.00

$35,000.00

$30,000.00

$25,000.00

$20,000.00

$15,000.00

$10,000.00

$5,000.00

$0.00
01/09/2013 01/12/2013 01/03/2014 01/06/2014 01/09/2014 01/12/2014 01/03/2015 01/06/2015

Values Forecast
Lower Confidence Bound Upper Confidence Bound
Date Sales Forecast(Sales) Lower Confidence Bound(Sales)
01/09/2013 $128,114.29
01/10/2013 $132,794.44
01/11/2013 $207,634.38
01/12/2013 $153,384.03
01/01/2014 $188,793.19
01/02/2014 $208,500.90
01/03/2014 $159,624.57
01/04/2014 $198,993.57
01/05/2014 $177,434.60
01/06/2014 $135,984.20
01/07/2014 $231,512.01
01/08/2014 $167,560.64
01/09/2014 $182,819.92
01/10/2014 $176,797.43
01/11/2014 $153,834.69
01/12/2014 $171,411.26 $171,411.26 $171,411.26
01/01/2015 $178,020.58 $120,796.48
01/02/2015 $157,611.77 $98,612.62
01/03/2015 $174,182.33 $113,446.42
01/04/2015 $180,795.64 $97,269.84
01/05/2015 $160,386.83 $75,605.80
01/06/2015 $176,957.39 $90,929.75
Upper Confidence Bound(Sales)

$300,000.00

$250,000.00

$200,000.00

$150,000.00

$100,000.00

$50,000.00

$171,411.26 $0.00
$235,244.68 01/09/2013 01/12/2013 01/03/2014 01/06/2014 01/09/2014 01/12/2014 01/0

$216,610.93 Sales Forecast(Sales)


$234,918.24 Lower Confidence Bound(Sales) Upper Confidence Bound(Sales)
$264,321.44
$245,167.86
$262,985.02
014 01/09/2014 01/12/2014 01/03/2015 01/06/2015

Forecast(Sales)
Upper Confidence Bound(Sales)
Segment Country Product Discount Units Sold Manufacturi Sale Price Gross Sales
Band ng Price
Midmarket France Paseo None $549.00 $10.00 $15.00 $8,235.00
Small Business Mexico Paseo None $788.00 $10.00 $300.00 $236,400.00
Government France VTT None $1,527.00 $250.00 $350.00 $534,450.00
Enterprise United States o Carretera Low $330.00 $3.00 $125.00 $41,250.00
Small Business United States o Montana Low $2,498.00 $5.00 $300.00 $749,400.00
Channel Partners United States o Amarilla Low $1,989.00 $260.00 $12.00 $23,868.00
Government Germany Montana Low $1,797.00 $5.00 $350.00 $628,950.00
Government Mexico Paseo Low $1,760.00 $10.00 $7.00 $12,320.00
Government United States o Velo Low $736.00 $120.00 $20.00 $14,720.00
Government Canada Velo Low $2,646.00 $120.00 $20.00 $52,920.00
Government United States o VTT Low $349.00 $250.00 $350.00 $122,150.00
Government Canada Paseo Medium $2,349.00 $10.00 $7.00 $16,443.00
Government Mexico Montana Medium $720.00 $5.00 $350.00 $252,000.00
Government Mexico Carretera Medium $1,834.00 $3.00 $20.00 $36,680.00
Government France Paseo Medium $1,031.00 $10.00 $7.00 $7,217.00
Channel Partners Germany VTT Medium $2,215.00 $250.00 $12.00 $26,580.00
Midmarket United States o Paseo Medium $2,931.00 $10.00 $15.00 $43,965.00
Small Business Germany Paseo Medium $1,123.00 $10.00 $300.00 $336,900.00
Enterprise Germany Amarilla Medium $994.00 $260.00 $125.00 $124,250.00
Small Business Canada Montana Medium $1,283.00 $5.00 $300.00 $384,900.00
Government Germany Paseo Medium $2,409.00 $10.00 $7.00 $16,863.00
Small Business France Montana Medium $322.00 $5.00 $300.00 $96,600.00
Channel Partners France VTT Medium $2,234.00 $250.00 $12.00 $26,808.00
Channel Partners Mexico VTT High $1,005.00 $250.00 $12.00 $12,060.00
Government France Velo High $2,805.00 $120.00 $20.00 $56,100.00
Midmarket Mexico Velo High $655.00 $120.00 $15.00 $9,825.00
Enterprise Mexico Amarilla High $947.00 $260.00 $125.00 $118,375.00
Government United States o Paseo High $380.00 $10.00 $7.00 $2,660.00
Enterprise Canada Carretera High $2,416.00 $3.00 $125.00 $302,000.00
Government Canada VTT High $623.00 $250.00 $350.00 $218,050.00
Channel Partners Canada Amarilla High $2,761.00 $260.00 $12.00 $33,132.00
Government Germany Carretera High $442.00 $3.00 $20.00 $8,840.00
Midmarket Germany Velo High $660.00 $120.00 $15.00 $9,900.00
Enterprise France Carretera High $1,023.00 $3.00 $125.00 $127,875.00
Midmarket Canada Paseo High $2,470.00 $10.00 $15.00 $37,050.00
Discounts Sales COGS Profit Date Month Month Year
Number
$8,235.00 $5,490.00 $2,745.00 01/09/2013 9 September 2013
$236,400.00 $197,000.00 $39,400.00 01/09/2013 9 September 2013
$534,450.00 $397,020.00 $137,430.00 01/09/2013 9 September 2013
$412.50 $40,837.50 $39,600.00 $1,237.50 01/09/2013 9 September 2013
$7,494.00 $741,906.00 $624,500.00 $117,406.00 01/09/2013 9 September 2013
$238.68 $23,629.32 $5,967.00 $17,662.32 01/09/2013 9 September 2013
$18,868.50 $610,081.50 $467,220.00 $142,861.50 01/09/2013 9 September 2013
$369.60 $11,950.40 $8,800.00 $3,150.40 01/09/2013 9 September 2013
$588.80 $14,131.20 $7,360.00 $6,771.20 01/09/2013 9 September 2013
$2,116.80 $50,803.20 $26,460.00 $24,343.20 01/09/2013 9 September 2013
$4,886.00 $117,264.00 $90,740.00 $26,524.00 01/09/2013 9 September 2013
$822.15 $15,620.85 $11,745.00 $3,875.85 01/09/2013 9 September 2013
$12,600.00 $239,400.00 $187,200.00 $52,200.00 01/09/2013 9 September 2013
$2,567.60 $34,112.40 $18,340.00 $15,772.40 01/09/2013 9 September 2013
$505.19 $6,711.81 $5,155.00 $1,556.81 01/09/2013 9 September 2013
$1,860.60 $24,719.40 $6,645.00 $18,074.40 01/09/2013 9 September 2013
$3,077.55 $40,887.45 $29,310.00 $11,577.45 01/09/2013 9 September 2013
$23,583.00 $313,317.00 $280,750.00 $32,567.00 01/09/2013 9 September 2013
$8,697.50 $115,552.50 $119,280.00 -$3,727.50 01/09/2013 9 September 2013
$30,792.00 $354,108.00 $320,750.00 $33,358.00 01/09/2013 9 September 2013
$1,349.04 $15,513.96 $12,045.00 $3,468.96 01/09/2013 9 September 2013
$8,694.00 $87,906.00 $80,500.00 $7,406.00 01/09/2013 9 September 2013
$2,412.72 $24,395.28 $6,702.00 $17,693.28 01/09/2013 9 September 2013
$1,326.60 $10,733.40 $3,015.00 $7,718.40 01/09/2013 9 September 2013
$6,171.00 $49,929.00 $28,050.00 $21,879.00 01/09/2013 9 September 2013
$1,080.75 $8,744.25 $6,550.00 $2,194.25 01/09/2013 9 September 2013
$13,021.25 $105,353.75 $113,640.00 -$8,286.25 01/09/2013 9 September 2013
$292.60 $2,367.40 $1,900.00 $467.40 01/09/2013 9 September 2013
$36,240.00 $265,760.00 $289,920.00 -$24,160.00 01/09/2013 9 September 2013
$26,166.00 $191,884.00 $161,980.00 $29,904.00 01/09/2013 9 September 2013
$3,975.84 $29,156.16 $8,283.00 $20,873.16 01/09/2013 9 September 2013
$1,149.20 $7,690.80 $4,420.00 $3,270.80 01/09/2013 9 September 2013
$1,287.00 $8,613.00 $6,600.00 $2,013.00 01/09/2013 9 September 2013
$17,902.50 $109,972.50 $122,760.00 -$12,787.50 01/09/2013 9 September 2013
$5,187.00 $31,863.00 $24,700.00 $7,163.00 01/09/2013 9 September 2013
Day

Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday
Sunday

You might also like