Chapter 6 - 6.1 a 496 Sales Returns b See attached sheet c...

Info iconThis preview shows pages 1–3. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6.1 a. 496 Sales Returns b. See attached sheet c. Laurel Collectibles with $9069 of returns 6.2 6.3 6.5 b. There were 247 cusomers last year with over $3500 in sales c. 111 Customers will be called by salespeople e. 530 customers had lases between $1,000 and $3,499 last year f. 310 customers will be sent out a mailing 6.6 c. There were 2 customers that did not have a state assigned to them. 6.7 b. 1122 Customers c. 31 States d. California with $207438.52 I used the existing smart list for customer balance, and added the state column. In excel I narrowed to state selection down to the required states and then totaled the amounts for each state. I created a smart list with customer name, total sales YTD, total discounts YTD, and instucted it to omit entries with less that $1 in total sales. I exported to excel and created the percent discounts taken column and totaled the sheet. Jewlery Importers, Inc. Laurel Collectibles Returns List SOP Type Customer Name Document Date Document ID Document Amount Return LAUREL COLLECTIBLES 3/25/2011 RETURN $1,060.00 Return LAUREL COLLECTIBLES 3/4/2011 RETURN $822.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $644.00 Return LAUREL COLLECTIBLES 3/25/2011 RETURN $364.00 Return LAUREL COLLECTIBLES 3/4/2011 RETURN $305.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $304.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $286.00 Return LAUREL COLLECTIBLES 3/4/2011 RETURN $256.00 Return LAUREL COLLECTIBLES 7/6/2011 RETURN $240.00 Return LAUREL COLLECTIBLES 3/4/2011 RETURN $240.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $231.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $224.00 Return LAUREL COLLECTIBLES 7/6/2011 RETURN $202.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $192.00 Return LAUREL COLLECTIBLES 6/8/2011 RETURN $168.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $151.00 Return LAUREL COLLECTIBLES 6/8/2011 RETURN $144.00 Return LAUREL COLLECTIBLES 6/8/2011 RETURN $140.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $122.00 Return LAUREL COLLECTIBLES 4/28/2011 RETURN $120.00 Return LAUREL COLLECTIBLES 6/8/2011 RETURN $120.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $119.00 Return LAUREL COLLECTIBLES 3/4/2011 RETURN $115.00 Return LAUREL COLLECTIBLES 4/28/2011 RETURN $114.00 Return LAUREL COLLECTIBLES 6/9/2011 RETURN $114.00 Return LAUREL COLLECTIBLES 6/8/2011 RETURN $110.00 Return LAUREL COLLECTIBLES 7/6/2011 RETURN $108.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $98.00 Return LAUREL COLLECTIBLES 3/4/2011 RETURN $96.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $90.00 Return LAUREL COLLECTIBLES 6/8/2011 RETURN $90.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $88.00 Return LAUREL COLLECTIBLES 6/9/2011 RETURN $88.00 Return LAUREL COLLECTIBLES 3/4/2011 RETURN $86.00 Return LAUREL COLLECTIBLES 2/26/2011 RETURN $79.00 Return LAUREL COLLECTIBLES 4/28/2011 RETURN $76.00 Return LAUREL COLLECTIBLES 6/9/2011 RETURN $76.00 Return LAUREL COLLECTIBLES 7/6/2011 RETURN $74.00 Return LAUREL COLLECTIBLES 6/8/2011 RETURN...
View Full Document

Page1 / 8

Chapter 6 - 6.1 a 496 Sales Returns b See attached sheet c...

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

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