Tech Ex 12.49 Data File - Added sheet for new subsidiary...

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

View Full Document Right Arrow Icon
SSID3101 Premium Colombian Coffee Sales Analysis Contents User Log Change Log Premium Colombian Sales Premium Colombian Sales Analysis Instructions Documentation Use information provided in chapte spreadsheet. Use data entry validation tool wher Add a hyperlink to the Contents sh Data provided in the Premium Colom Colombian Sales Analysis sheets are exercise will help students to learn a and controlled spreadsheet.
Image of page 1

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

View Full Document Right Arrow Icon
er 12 to complete this rever is required. heet in all other sheets mbian Sales and Premium re just an example. This about a better managed
Image of page 2
DATE TIME USER ID NOTES 10.04.2014 9:00 AM ajaan DATA ENTRY Updated September sales 10.20.2014 2:30 PM ajaan DATA ANALYSIS Forecast Q1 2014 sales DATA: Entry/Analysis/Report
Image of page 3

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

View Full Document Right Arrow Icon
DATE TIME USER ID FROM: 11.30.2014 10:58 AM dajaan SHEET 11.30.2014 11:30 AM dajaan FORMULA DESIGN CHANGE: FORMULA/SHEET/DATA
Image of page 4
To: NOTES:REASON FOR CHANGE
Image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
Image of page 7

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

View Full Document Right Arrow Icon
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Added sheet for new subsidiary Updated formulas Year Market Demand EspressoCoffee Production Lagged 2002 487000 487000 $5.92 2003 560000 487000 73000 $6.06 2004 601000 560000 41000 $6.33 2005 689000 601000 88000 $6.79 2006 788000 689000 99000 $6.93 2007 854000 788000 66000 $7.25 2008 902000 854000 48000 $7.51 2009 957000 902000 55000 $8.76 2010 991000 957000 34000 $9.42 2011 1010000 991000 19000 $10.11 EspressoCoffee Sales Price Revenue Lost Revenue Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 200000 400000 600000 800000 1000000 1200000 1 2 3 4 5 6 7 8 9 10 $0.00 $2.00 $4.00 $6.00 $8.00 $10.00 $12.00 Revenue Lost Revenue Market Demand...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern