dav question 3 part 1.pdf - Hands-on Analysis Quiz 2 Solutions 1 If 2013 Sales numbers were expected to increase by 10 in the following year in all

# dav question 3 part 1.pdf - Hands-on Analysis Quiz 2...

• 6

This preview shows page 1 - 5 out of 6 pages.

Hands-on Analysis Quiz 2 Solutions 1) If 2013 Sales numbers were expected to increase by 10% in the following year in all customer segments, what would be the total estimated sales for Home Office in 2014? 617,498 679,248 2,385,847 Create a new calculated field called 110% of Sales:
Drag Sales into the view and filter on Home Office: Filter on Year of Order Date = 2013 Your view should looks like this:
Double- click the new field “110% of Sales” to add it to the view: So we found the total sales for the Home Office segment in 2013 (\$617,498) and then increased this value by 10% to get the 2014 projection.
2) Which product has the highest ship cost to sales ratio? Hoover® Commercial Lightweight Upright Vacuum Accohide Poly Flexible Ring Binders Kensington 7 Outlet MasterPiece Power Center with Fax/Phone Line Protection Lexmark 4227 Plus Dot Matrix Printer Create a calculated field for ship cost to sales ratio. The sums in the numerator and denominator ensure that we will calculate the total shipping cost

#### You've reached the end of your free preview.

Want to read all 6 pages?

• Winter '19

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern