cpt_109_lesson_6_solution

cpt_109_lesson_6_solution - Month January February March...

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

View Full Document Right Arrow Icon
Month Analysis I Analysis II Analysis III January 910 10,300 February 820 5,600 March 610 5,700 April 610 7,000 May 900 12,100 June 800 9,500 July 870 1,000 August 800 9,300 September 810 9,100 October 950 6,200 November 710 9,000 December 640 7,000 Customers 2005 Revenue 2005
Image of page 1

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

View Full Document Right Arrow Icon
Analysis IV Budget 2006
Image of page 2
Month Analysis I Analysis II Analysis III Analysis IV January 910 10,300 Good 1,047 11,330 February 820 5,600 Bad month Difficult to achieve 0 6,160 March 610 5,700 Bad month 0 5,700 April 610 7,000 Bad month Difficult to achieve 0 7,700 May 900 12,100 Good 1,035 13,310 June 800 9,500 Good 920 10,450 July 870 1,000 Bad month 0 1,100 August 800 9,300 Good 920 10,230 September 810 9,100 Good 932 10,010 October 950 6,200 0 6,200 November 710 9,000 Good 0 9,900 December 640 7,000 Bad month Difficult to achieve 0 7,700 Customers 2005 Revenue 2005 Budget 2006 A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13
Image of page 3

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

View Full Document Right Arrow Icon
Autumn 2006 BOS1-E Week 11 Exercise 1 Excel 2003 THE POLE STAR GARAGE 2005 SALES Vehicle sales quota per model 20 Model Category Sale price Analysis 1 Analysis 2 JEEP CJ5 Higher 38,000.00 15 0.00 0.00% I II PAJERO Average 34,000.00 19 0.00 0.00% I II LAND ROVER Higher 39,000.00 6 0.00 0.00% I II DISCOVERY Higher 48,000.00 8 0.00 0.00% I II PATROL Average 43,000.00 2 0.00 0.00% I II CHEROKEE Higher 55,000.00 27 0.00 0.00% I II TROOPER
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the 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