Excel Spreadsheet 2nd Annual Report

Excel Spreadsheet 2nd Annual Report - ROA Year Andrews...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ROA Year Andrews Baldwin Chester Digby Erie Ferris Year Andrews 2010-0.8%-1.0% 3.2% 0.2% 1.7%-2.5% 2010-0.8% 2011 2011 2012 2012 2013 2013 2014 2014 2015 2015 2016 2016 2017 2017 Average Average ROE Asset Turnover Year Andrews Baldwin Chester Digby Erie Ferris Year Andrews 2010-1.7%-2.1% 6.3% 0.4% 3.6%-5.3% 2010 1.0% 2011 2011 2012 2012 2013 2013 2014 2014 2015 2015 2016 2016 2017 2017 Average Average Market Share (% in $) Year Andrews Baldwin Chester Digby Erie Ferris 2010 16.0% 15.0% 19.0% 16.0% 16.0% 18.0% 2011 2012 2013 2014 2015 2016 2017 Average ROS Baldwin Chester Digby Erie Ferris-1.0% 3.3% 0.2% 1.9%-2.4% Baldwin Chester Digby Erie Ferris 1.0% 1.0% 0.9% 1.1% 1.0% Total Units Sold (000) 2009 2010 % Change 2011 % Change 2012 % Change 2013 Andrews Able 999 1,401 140% Acre 1,763 1,398 79% Adam 366 526 144% Aft 358 409 114% Agape 314 397 126% Product 6 N/A Product 7 N/A Baldwin Baker 999 1,015 102% Bead 1,763 1,722 98% Bid 366 492 134% Bold 358 379 106% Buddy 314 388 124% Product 6 N/A Product 7 N/A Chester Cake 999 1,439 144% Cedar 1,763 1,705 97% Cid 366 478 131% Coat 358 461 129% Cure 314 406 129% Product 6 N/A Product 7 N/A Digby Daze 999 1,235 124% Dell 1,763 2,036 115% Dixie 366 274 75% Dot 358 372 104% Dune 314 318 101% Product 6 N/A 0 Product 7 N/A Erie Eat 999 1,271 127% Ebb 1,763 1,524 86% Echo 366 500 137% Edge 358 414 116% Egg 314 409 130% Product 6 N/A Product 7 N/A Ferris Fast 999 1,386 139% Feat 1,763 2,118 120% Fist 366 372 102% Foam 358 506 141% Fume 314 332 106% Product 6 N/A Product 7 N/A % Change 2014 % Change 2015 % Change 2016 % Change 2017 % Change Product Name Product Name Product Nam Year Most Likely Best Case Worst Case Most Likely Best Case Worst Case Most Likely Best Case 2010 2011 2012 2013 2014 2015 2016 2017 Best Case = Stocking out Most likely = Given all the information, this is the most likely to happen Worst Case = Given unexpected events (new products enter the market, etc.), sales should not be below this valu Sales Forecast (# of Units ) Analysis by Product for yo e Product Name Product Name Worst Case Most Likely Best Case Worst Case Most Likely Best Case Worst Case ue our Company Price Analysis by Segment Traditional Year Able Baker Cake Daze Eat Fast Duck Product 8 Product 9 2010 $25.99 $28.00 $28.50 $28.00 $26.50 $26.99 2011 $26.99 $28.00 $27.50 $27.00 $27.00 $26.75 $24.00 2012 2013 2014 2015 2016 2017 Low Year Acre Bead Cedar Dell Ebb Feat Flamer Duck Product 9 2010 $20.99 $19.00 $23.50 $21.00 $19.75 $19.94 2011 $20.99 $19.00 $22.00 $20.50 $19.75 $19.99 $24.00 2012 2013 2014 2015 2016 2017 High Year Adam Bid Cid Dixie Echo Fist Product 7 Product 8 Product 9 2010 $38.49 $38.00 $38.50 $40.00 $39.25 $39.49 2011 $38.49 $38.00 $38.00 $38.75 $38.75 2012 2013 2014 2015 2016 2017 Performance Year Aft Bold Coat Dot Edge Foam Product 7 Product 8 Product 9 2010 $33.49 $33.00 $34.50 $35.00 $34.00 $33.99 2011 $33.99 $33.25 $34.00 $34.00 $33.25 $33.75 2012 2013 2014 2015 2016 2017 Size Year Agape Buddy Cure Dune Egg...
View Full Document

This note was uploaded on 08/08/2011 for the course WCOB 3016 taught by Professor Staff during the Spring '08 term at Arkansas.

Page1 / 73

Excel Spreadsheet 2nd Annual Report - ROA Year Andrews...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online