Hello ther,

I need help with my finance case study (Ramsey Co. Case study). Please see the attachments for details and instructions.

Thanks,

Ramsey Inc. 2013 Purchase Order Register March 1, 2013 - March 31, 2013 Date Number Purchase Orders 3/1/2013 3/1/2013 3/2/2013 3/2/2013 3/3/2013 3/5/2013 3/5/2013 3/5/2013 3/7/2013 3/7/2013 3/7/2013 3/7/2013 3/11/2013 3/11/2013 3/11/2013 3/11/2013 3/11/2013 3/12/2013 3/15/2013 3/18/2013 3/18/2013 3/18/2013 3/23/2013 3/23/2013 3/23/2013 3/24/2013 3/24/2013 3/24/2013 3/24/2013 3/25/2013 3/25/2013 3/25/2013 Total - Purchase Orders Total Vendor Status Amount Account 1063 Office Depot 1122 Computer Glory 1252 Coopers Office Furniture 1255 Herman Miller Inc. 1066 Office Depot 1056 Alexander Valley Vineyards 1067 Herman Miller Inc. 1072 HP Corporation 1068 Herman Miller Inc. 1074 HP Corporation 1123 Bayer Health Care 1124 Bayer Health Care 1057 Coopers Office Furniture 1058 The Office Shop Inc 1059 The Office Shop Inc 1125 Bayer Health Care 1126 Best Fixture, Inc. 1073 HP Corporation 1078 Coopers Office Furniture 1060 The Office Shop Inc 1061 Koka Office Supplies 1062 The Office Shop Inc 1069 American Computers 1070 American Computers 1071 Office Depot 1075 Coopers Office Furniture 1076 American Computers 1077 Digital Supply 1079 Best Fixture, Inc. 1080 Coopers Office Furniture 1081 The Office Shop Inc 1082 American Computers Pending Bill Pending Bill Fully Billed Fully Billed Pending Bill Fully Billed Pending Bill Pending Receipt Pending Bill Pending Receipt Pending Bill Pending Bill Pending Bill Pending Bill Pending Bill Pending Bill Pending Bill Pending Receipt Pending Billing/ Pending Receipt Pending Receipt Pending Receipt Pending Receipt Pending Bill Pending Bill Pending Receipt Pending Receipt Pending Billing/ Pending Billing/ Fully Billed Pending Bill Pending Receipt $99.90 $10.00 $189.99 $60.00 $49.95 $12,350.00 $3,000.00 $8,223.36 $2,000.00 $3,312.45 $249.75 $249.75 $3,799.80 $148.50 $9.90 $499.50 $499.50 $509.94 $440.68 $14.85 $939.65 $154.70 $25,980.00 $6,160.00 $999.00 $440.68 $2,335.00 $1,490.76 $1,514.90 $19.98 $9.90 $450.00 $76,212.39 $76,212.39 Ramsey Inc. 2013 Open Bills End of Mar 2013 Account Bill NumberVendor UPS 3009 Superior ISP American Computers Pacific Bell Telephone American Computers Superior ISP 3007 Bob Ford, CPA Allsteel Allsteel Allsteel 3018 Superior ISP Herman Miller Inc. HP Corporation Charles Schwab Herman Miller Inc. 2008 Jill Muscat Coopers Office Furniture 3019 Superior ISP Herman Miller Inc. American Computers Allsteel 2007 Jill Muscat 1574791 Hillerman Inc. 8.9E+009 Qual Ltd. Merlin Motorola Herman Miller Inc. Herman Miller Inc. BRID10225Bridgepoint Industries Canon, Inc. 2012 Jill Muscat 7951 AVI Consulting 85K45P IGA Inc Coopers Office Furniture Coopers Office Furniture Coopers Office Furniture Polaroid AL Systems Ltd AL Systems Ltd Koka Office Supplies Coopers Office Furniture Bill Date Memo Date Due 7/1/2011 913465 3/11/2013 12/8/2011 5402-1476 1/7/2013 7/26/2011 109-WE-4973 8/4/2011 35235 2/7/2013 8/7/2011 109-WE-4973 4/13/2013 8/8/2011 5402-1476 5/3/2013 8/15/2011 CC-2354 4/30/2013 11/1/2011 11/1/2011 11/1/2011 11/1/2011 11/2/2011 11/2/2011 5/8/2012 5402-1476 4/7/2013 6/30/2012 7/27/2012 11/15/2012 11/30/2012 11/15/2012 11/30/2012 12/15/2012 1/14/2013 12/18/2012 12/18/2012 12/18/2012 1/17/2013 6/8/2012 5402-1476 2/7/2013 1/2/2013 2/2/2013 1/3/2013 109-WE-4973 3/2/2013 1/24/2013 1/24/2013 1/31/2013 1/31/2013 1/31/2013 3/2/2013 2/1/2013 3/3/2013 2/2/2013 11/15/2012 12/17/2012 2/2/2013 3/1/2013 2/2/2013 3/1/2013 2/2/2013 3/1/2013 2/2/2013 2/2/2013 2/4/2013 3/3/2013 2/6/2013 3/5/2013 2/7/2013 2/7/2013 2/7/2013 2/7/2013 2/3/2013 3/2/2013 2/8/2013 2/8/2013 2/8/2013 2/8/2013 2/8/2013 3/7/2013 2/8/2013 2/8/2013 Koka Office Supplies Herman Miller Inc. Coopers Office Furniture 2009 Jill Muscat 15743599 Hillerman Inc. Coopers Office Furniture Coopers Office Furniture Digital Supply American Express Eric Givens The Office Shop Inc Witt & Anderson Canon, Inc. Alexander Valley Vineyards 1548 Bridgepoint Industries Eric Givens Eric Givens 7979711 Qual Ltd. IGA Inc AL Systems Ltd Eric Givens Best Fixture, Inc. Computer Depot Pacific 2013 Jill Muscat 56990 AVI Consulting Office Depot Herman Miller Inc. Alexander Valley Vineyards Herman Miller Inc. Office Depot 2010 Jill Muscat Coopers Office Furniture Coopers Office Furniture Total - 2000 - Accounts Payable Total 2/8/2013 2/11/2013 2/8/2013 2/12/2013 2/12/2013 2/13/2013 2/13/2013 2/14/2013 2/14/2013 2/15/2013 2/15/2013 2/16/2013 2/16/2013 2/19/2013 2/19/2013 2/22/2013 2/22/2013 2/22/2013 2/24/2013 2/25/2013 2/25/2013 2/25/2013 2/25/2013 3/12/2013 2/26/2013 2/26/2013 3/2/2013 3/5/2013 3/11/2013 3/11/2013 3/12/2013 3/12/2013 3/25/2013 3/10/2013 2/12/2013 3/14/2013 2/13/2013 3/13/2013 2/15/2013 3/15/2013 3/4/2013 3/18/2013 2/22/2013 2/22/2013 3/24/2013 3/23/2013 2/25/2013 2/25/2013 3/24/2013 3/24/2013 3/12/2013 3/25/2013 2/26/2013 4/2/2013 3/20/2013 4/10/2013 3/12/2013 4/12/2013 3/25/2013 Amount Due $344.25 $900.00 ($299.99) $1,216.22 $4,264.80 $900.00 $350.00 $1,185.00 $249.00 $12,500.00 $900.00 $995.00 $849.00 $24,000.00 $150.00 $265.00 $192.98 $900.00 $185.00 $600,000.00 $35,781.00 $525.00 $65,863.63 $9,380.50 ($529.90) $900.00 $25.00 $225.00 $1,039.19 ($330.00) $75.00 $2,150.00 $630.00 $964.90 ($189.99) ($385.96) $18,772.50 $2,375.00 $20,000.00 $2,593.40 $6,724.15 ($2,593.40) $3,250.00 ($3,652.66) $205.00 $2,687.50 ($2,851.90) $2,851.90 $229.00 ($5.00) $6,000.00 $9.99 $1,455.65 ($10.00) $3,000.00 $1,420.59 $750.00 $1,500.00 $7,080.65 $849.50 $12,500.00 $6,000.00 $6,250.00 $3,000.00 $75.00 $863.01 $75.25 $60.00 $12,350.00 $7,500.00 $999.00 $235.00 $189.99 $19.98 $888,928.73 $888,928.73 Ramsey Inc. 2013 Sales End of Apr 2013 Account Sales Invoice Number Invoice Date Invoice Quantity 4539 4540 4541 4542 4543 4544 4545 4546 4547 4548 4549 4550 4551 4552 4553 4554 4555 4556 4557 4558 4559 4560 4561 4562 4563 4564 4565 4566 4567 4568 4569 4570 4571 4572 4573 4574 4575 4576 1/1/2013 1/2/2013 1/3/2013 1/4/2013 1/4/2013 1/7/2013 1/7/2013 1/7/2013 1/7/2013 1/8/2013 1/8/2013 1/8/2013 1/10/2013 1/10/2013 1/11/2013 1/11/2013 1/14/2013 1/15/2013 1/15/2013 1/16/2013 1/17/2013 1/17/2013 1/18/2013 1/18/2013 1/21/2013 1/21/2013 1/22/2013 1/23/2013 1/23/2013 1/23/2013 1/23/2013 1/24/2013 1/25/2013 1/25/2013 1/28/2013 1/28/2013 1/28/2013 1/28/2013 10 3 7 9 3 3 8 8 5 2 6 2 3 9 7 5 6 3 1 3 10 1 9 2 7 3 9 1 6 5 9 5 8 8 2 6 6 8 Price per Unit 7,899.99 7,899.99 3,299.99 9,689.99 7,899.99 9,689.99 9,689.99 9,689.99 7,899.99 9,689.99 3,299.99 3,299.99 7,899.99 9,689.99 7,899.99 7,899.99 9,689.99 7,899.99 9,689.99 3,299.99 7,899.99 9,689.99 7,899.99 7,899.99 7,899.99 3,299.99 7,899.99 7,899.99 9,689.99 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 7,899.99 3,299.99 3,299.99 7,899.99 Invoice Gross Amount 78,999.90 23,699.97 23,099.93 87,209.91 23,699.97 29,069.97 77,519.92 77,519.92 39,499.95 19,379.98 19,799.94 6,599.98 23,699.97 87,209.91 55,299.93 39,499.95 58,139.94 23,699.97 9,689.99 9,899.97 78,999.90 9,689.99 71,099.91 15,799.98 55,299.93 9,899.97 71,099.91 7,899.99 58,139.94 39,499.95 71,099.91 39,499.95 63,199.92 26,399.92 15,799.98 19,799.94 19,799.94 63,199.92 4577 4578 4579 4580 4581 4582 4583 4584 4585 4586 4587 4588 4589 4590 4591 4592 4593 4594 4595 4596 4597 4598 4599 4600 4601 4602 4603 4604 4605 4606 4607 4608 4609 4610 4611 4612 4613 4614 4615 4616 4617 4618 4619 4620 4621 1/28/2013 1/28/2013 1/29/2013 1/30/2013 1/30/2013 1/31/2013 1/31/2013 2/1/2013 2/1/2013 2/4/2013 2/4/2013 2/5/2013 2/5/2013 2/6/2013 2/6/2013 2/6/2013 2/7/2013 2/7/2013 2/8/2013 2/8/2013 2/11/2013 2/11/2013 2/11/2013 2/12/2013 2/12/2013 2/12/2013 2/13/2013 2/14/2013 2/14/2013 2/15/2013 2/15/2013 2/18/2013 2/18/2013 2/20/2013 2/21/2013 2/21/2013 2/22/2013 2/25/2013 2/25/2013 2/25/2013 2/25/2013 2/26/2013 2/26/2013 2/26/2013 2/27/2013 5 10 2 7 7 8 5 10 9 3 7 3 9 8 5 2 7 2 7 4 2 7 6 6 9 9 3 2 7 8 4 9 8 4 6 4 6 5 6 8 4 3 9 3 2 3,299.99 7,899.99 7,899.99 7,899.99 9,689.99 7,899.99 7,899.99 3,299.99 7,899.99 7,899.99 3,299.99 7,899.99 9,689.99 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 7,899.99 7,899.99 9,689.99 7,899.99 3,299.99 7,899.99 7,899.99 9,689.99 7,899.99 3,299.99 7,899.99 3,299.99 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 7,899.99 9,689.99 7,899.99 9,689.99 3,299.99 7,899.99 9,689.99 3,299.99 7,899.99 7,899.99 16,499.95 78,999.90 15,799.98 55,299.93 67,829.93 63,199.92 39,499.95 32,999.90 71,099.91 23,699.97 23,099.93 23,699.97 87,209.91 63,199.92 39,499.95 15,799.98 55,299.93 6,599.98 55,299.93 31,599.96 19,379.98 55,299.93 19,799.94 47,399.94 71,099.91 87,209.91 23,699.97 6,599.98 55,299.93 26,399.92 31,599.96 71,099.91 63,199.92 31,599.96 19,799.94 31,599.96 58,139.94 39,499.95 58,139.94 26,399.92 31,599.96 29,069.97 29,699.91 23,699.97 15,799.98 4622 4623 4624 4625 4626 4627 4628 4629 4630 4631 4632 4633 4634 4635 4636 4637 4638 4639 4640 4641 4642 4643 4644 4645 4646 4647 4648 4649 4650 4651 4652 4653 4654 4655 4656 4657 4658 4659 4660 4661 4662 4663 4664 4665 4666 2/27/2013 2/27/2013 2/28/2013 2/28/2013 3/1/2013 3/1/2013 3/1/2013 3/4/2013 3/4/2013 3/5/2013 3/5/2013 3/6/2013 3/6/2013 3/6/2013 3/6/2013 3/7/2013 3/7/2013 3/8/2013 3/8/2013 3/11/2013 3/11/2013 3/11/2013 3/11/2013 3/12/2013 3/12/2013 3/12/2013 3/12/2013 3/14/2013 3/14/2013 3/15/2013 3/15/2013 3/18/2013 3/18/2013 3/18/2013 3/18/2013 3/19/2013 3/19/2013 3/20/2013 3/20/2013 3/21/2013 3/21/2013 3/22/2013 3/22/2013 3/22/2013 3/22/2013 2 3 3 6 10 5 4 7 3 7 4 1 10 3 7 10 4 4 5 7 3 9 8 5 2 3 3 10 1 4 7 4 4 2 4 5 9 1 8 2 7 7 8 5 8 9,689.99 7,899.99 7,899.99 3,299.99 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 3,299.99 3,299.99 9,689.99 7,899.99 7,899.99 7,899.99 9,689.99 7,899.99 9,689.99 7,899.99 7,899.99 3,299.99 9,689.99 9,689.99 7,899.99 7,899.99 7,899.99 7,899.99 9,689.99 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 3,299.99 3,299.99 7,899.99 3,299.99 7,899.99 9,689.99 9,689.99 3,299.99 7,899.99 3,299.99 3,299.99 7,899.99 19,379.98 23,699.97 23,699.97 19,799.94 78,999.90 39,499.95 31,599.96 55,299.93 9,899.97 23,099.93 13,199.96 9,689.99 78,999.90 23,699.97 55,299.93 96,899.90 31,599.96 38,759.96 39,499.95 55,299.93 9,899.97 87,209.91 77,519.92 39,499.95 15,799.98 23,699.97 23,699.97 96,899.90 7,899.99 31,599.96 55,299.93 31,599.96 13,199.96 6,599.98 13,199.96 39,499.95 29,699.91 7,899.99 77,519.92 19,379.98 23,099.93 55,299.93 26,399.92 16,499.95 63,199.92 4667 4668 4669 4670 4671 4672 4673 4674 4675 4676 4677 4678 4679 4680 4681 4682 4683 4684 4685 4686 4687 4688 4689 4690 4691 4692 4693 4694 4695 4696 4697 4698 4699 4700 4701 4702 4703 4704 4705 4706 4707 4708 4709 4710 4711 3/25/2013 3/25/2013 3/27/2013 3/28/2013 3/28/2013 3/28/2013 3/29/2013 3/29/2013 3/29/2013 4/1/2013 4/1/2013 4/2/2013 4/4/2013 4/5/2013 4/5/2013 4/5/2013 4/5/2013 4/5/2013 4/5/2013 4/5/2013 4/8/2013 4/8/2013 4/9/2013 4/9/2013 4/9/2013 4/9/2013 4/10/2013 4/10/2013 4/11/2013 4/11/2013 4/12/2013 4/12/2013 4/12/2013 4/15/2013 4/15/2013 4/15/2013 4/15/2013 4/17/2013 4/17/2013 4/18/2013 4/18/2013 4/18/2013 4/19/2013 4/19/2013 4/19/2013 3 9 4 2 4 7 2 9 2 5 9 5 10 5 8 7 3 2 7 10 8 6 4 3 8 3 7 6 3 10 8 7 2 5 2 7 8 5 1 6 7 9 4 4 7 7,899.99 3,299.99 7,899.99 7,899.99 9,689.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 7,899.99 7,899.99 9,689.99 3,299.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 7,899.99 7,899.99 7,899.99 3,299.99 7,899.99 7,899.99 7,899.99 9,689.99 3,299.99 9,689.99 3,299.99 7,899.99 3,299.99 7,899.99 3,299.99 3,299.99 23,699.97 29,699.91 31,599.96 15,799.98 38,759.96 55,299.93 15,799.98 71,099.91 15,799.98 39,499.95 71,099.91 39,499.95 78,999.90 16,499.95 63,199.92 55,299.93 29,069.97 6,599.98 55,299.93 78,999.90 63,199.92 47,399.94 31,599.96 23,699.97 63,199.92 23,699.97 55,299.93 47,399.94 9,899.97 78,999.90 63,199.92 55,299.93 6,599.98 39,499.95 15,799.98 55,299.93 77,519.92 16,499.95 9,689.99 19,799.94 55,299.93 29,699.91 31,599.96 13,199.96 23,099.93 4712 4713 4714 4715 4716 4717 4718 4719 4720 4721 4722 4723 4724 4725 4726 4727 4728 4729 4730 4731 4732 4733 4734 4735 4736 4737 4738 4739 4740 4741 4742 4743 4744 4745 4746 4747 4748 4749 4750 4751 4752 4753 4754 4755 4756 4/22/2013 4/23/2013 4/24/2013 4/24/2013 4/25/2013 4/25/2013 4/25/2013 4/26/2013 4/26/2013 4/26/2013 4/26/2013 4/29/2013 4/29/2013 4/29/2013 4/30/2013 4/30/2013 4/30/2013 4/30/2013 5/1/2013 5/1/2013 5/2/2013 5/2/2013 5/2/2013 5/3/2013 5/6/2013 5/6/2013 5/6/2013 5/6/2013 5/7/2013 5/7/2013 5/7/2013 5/7/2013 5/8/2013 5/8/2013 5/8/2013 5/9/2013 5/9/2013 5/9/2013 5/10/2013 5/10/2013 5/13/2013 5/14/2013 5/14/2013 5/14/2013 5/15/2013 4 6 7 7 2 7 9 8 9 2 4 8 3 10 10 9 9 3 9 2 8 8 9 5 9 3 5 4 6 1 4 8 2 3 2 9 3 8 10 8 5 7 3 2 4 9,689.99 3,299.99 9,689.99 9,689.99 7,899.99 9,689.99 9,689.99 9,689.99 7,899.99 7,899.99 7,899.99 9,689.99 3,299.99 9,689.99 7,899.99 3,299.99 7,899.99 9,689.99 7,899.99 7,899.99 9,689.99 9,689.99 9,689.99 3,299.99 7,899.99 7,899.99 9,689.99 7,899.99 9,689.99 7,899.99 9,689.99 7,899.99 3,299.99 3,299.99 9,689.99 3,299.99 7,899.99 3,299.99 9,689.99 9,689.99 9,689.99 7,899.99 7,899.99 3,299.99 9,689.99 38,759.96 19,799.94 67,829.93 67,829.93 15,799.98 67,829.93 87,209.91 77,519.92 71,099.91 15,799.98 31,599.96 77,519.92 9,899.97 96,899.90 78,999.90 29,699.91 71,099.91 29,069.97 71,099.91 15,799.98 77,519.92 77,519.92 87,209.91 16,499.95 71,099.91 23,699.97 48,449.95 31,599.96 58,139.94 7,899.99 38,759.96 63,199.92 6,599.98 9,899.97 19,379.98 29,699.91 23,699.97 26,399.92 96,899.90 77,519.92 48,449.95 55,299.93 23,699.97 6,599.98 38,759.96 4757 4758 4759 4760 4761 4762 4763 4764 4765 4766 4767 4768 4769 4770 4771 4772 4773 4774 4775 4776 4777 4778 4779 4780 4781 4782 4783 4784 4785 4786 4787 4788 4789 4790 4791 4792 4793 4794 4795 4796 4797 4798 4799 4800 4801 5/16/2013 5/16/2013 5/17/2013 5/17/2013 5/17/2013 5/17/2013 5/20/2013 5/20/2013 5/20/2013 5/21/2013 5/23/2013 5/24/2013 5/24/2013 5/27/2013 5/27/2013 5/27/2013 5/28/2013 5/28/2013 5/28/2013 5/28/2013 5/28/2013 5/29/2013 5/29/2013 5/29/2013 5/29/2013 5/29/2013 5/29/2013 5/30/2013 5/30/2013 5/31/2013 5/31/2013 5/31/2013 5/31/2013 6/3/2013 6/3/2013 6/3/2013 6/3/2013 6/3/2013 6/4/2013 6/4/2013 6/4/2013 6/5/2013 6/5/2013 6/5/2013 6/5/2013 3 5 4 7 5 9 5 5 7 7 10 1 6 1 6 3 5 5 10 6 8 4 9 9 4 9 6 3 9 5 10 1 10 9 4 3 5 7 4 10 3 7 1 9 1 7,899.99 3,299.99 3,299.99 3,299.99 7,899.99 3,299.99 3,299.99 9,689.99 7,899.99 9,689.99 7,899.99 9,689.99 9,689.99 3,299.99 3,299.99 7,899.99 7,899.99 7,899.99 9,689.99 3,299.99 9,689.99 7,899.99 9,689.99 3,299.99 3,299.99 9,689.99 7,899.99 3,299.99 3,299.99 7,899.99 7,899.99 7,899.99 3,299.99 9,689.99 7,899.99 3,299.99 9,689.99 7,899.99 9,689.99 3,299.99 9,689.99 9,689.99 7,899.99 9,689.99 7,899.99 23,699.97 16,499.95 13,199.96 23,099.93 39,499.95 29,699.91 16,499.95 48,449.95 55,299.93 67,829.93 78,999.90 9,689.99 58,139.94 3,299.99 19,799.94 23,699.97 39,499.95 39,499.95 96,899.90 19,799.94 77,519.92 31,599.96 87,209.91 29,699.91 13,199.96 87,209.91 47,399.94 9,899.97 29,699.91 39,499.95 78,999.90 7,899.99 32,999.90 87,209.91 31,599.96 9,899.97 48,449.95 55,299.93 38,759.96 32,999.90 29,069.97 67,829.93 7,899.99 87,209.91 7,899.99 4802 4803 4804 4805 4806 4807 4808 4809 4810 4811 4812 4813 4814 4815 4816 4817 4818 4819 4820 4821 4822 4823 4824 4825 4826 4827 4828 4829 4830 4831 4832 4833 4834 4835 4836 4837 4838 4839 4840 4841 4842 4843 4844 4845 4846 6/5/2013 6/6/2013 6/6/2013 6/7/2013 6/7/2013 6/7/2013 6/7/2013 6/10/2013 6/10/2013 6/10/2013 6/11/2013 6/11/2013 6/12/2013 6/13/2013 6/14/2013 6/14/2013 6/14/2013 6/14/2013 6/17/2013 6/17/2013 6/18/2013 6/19/2013 6/19/2013 6/21/2013 6/21/2013 6/24/2013 6/25/2013 6/25/2013 6/25/2013 6/26/2013 6/26/2013 6/27/2013 6/27/2013 6/28/2013 6/28/2013 6/28/2013 6/28/2013 7/1/2013 7/1/2013 7/1/2013 7/2/2013 7/2/2013 7/2/2013 7/3/2013 7/3/2013 5 5 2 2 4 1 10 10 6 1 7 8 4 6 2 7 3 6 9 6 10 4 7 2 8 7 9 8 7 3 5 6 2 2 10 3 9 6 3 9 3 4 1 5 4 3,299.99 3,299.99 3,299.99 7,899.99 3,299.99 7,899.99 3,299.99 9,689.99 7,899.99 3,299.99 3,299.99 3,299.99 9,689.99 9,689.99 3,299.99 3,299.99 7,899.99 3,299.99 7,899.99 7,899.99 3,299.99 3,299.99 3,299.99 7,899.99 7,899.99 9,689.99 3,299.99 9,689.99 9,689.99 9,689.99 3,299.99 9,689.99 3,299.99 7,899.99 9,689.99 9,689.99 3,299.99 7,899.99 9,689.99 7,899.99 3,299.99 9,689.99 7,899.99 9,689.99 3,299.99 16,499.95 16,499.95 6,599.98 15,799.98 13,199.96 7,899.99 32,999.90 96,899.90 47,399.94 3,299.99 23,099.93 26,399.92 38,759.96 58,139.94 6,599.98 23,099.93 23,699.97 19,799.94 71,099.91 47,399.94 32,999.90 13,199.96 23,099.93 15,799.98 63,199.92 67,829.93 29,699.91 77,519.92 67,829.93 29,069.97 16,499.95 58,139.94 6,599.98 15,799.98 96,899.90 29,069.97 29,699.91 47,399.94 29,069.97 71,099.91 9,899.97 38,759.96 7,899.99 48,449.95 13,199.96 4847 4848 4849 4850 4851 4852 4853 4854 4855 4856 4857 4858 4859 4860 4861 4862 4863 4864 4865 4866 4867 4868 4869 4870 4871 4872 4873 4874 4875 4876 4877 4878 4879 4880 4881 4882 4883 4884 4885 4886 4887 4888 4889 4890 4891 7/3/2013 7/5/2013 7/5/2013 7/5/2013 7/5/2013 7/8/2013 7/8/2013 7/9/2013 7/9/2013 7/9/2013 7/9/2013 7/10/2013 7/11/2013 7/11/2013 7/12/2013 7/12/2013 7/15/2013 7/16/2013 7/17/2013 7/18/2013 7/18/2013 7/18/2013 7/18/2013 7/18/2013 7/18/2013 7/19/2013 7/19/2013 7/19/2013 7/19/2013 7/22/2013 7/22/2013 7/22/2013 7/23/2013 7/24/2013 7/24/2013 7/24/2013 7/25/2013 7/26/2013 7/26/2013 7/29/2013 7/29/2013 7/29/2013 7/30/2013 7/30/2013 7/31/2013 7 4 9 8 2 4 4 6 3 9 5 4 9 7 9 5 4 8 2 2 7 3 4 8 3 4 4 5 10 7 8 5 4 9 6 4 6 1 9 5 6 2 3 6 2 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 9,689.99 9,689.99 3,299.99 9,689.99 7,899.99 9,689.99 9,689.99 3,299.99 3,299.99 7,899.99 9,689.99 3,299.99 9,689.99 3,299.99 9,689.99 9,689.99 7,899.99 3,299.99 7,899.99 3,299.99 9,689.99 9,689.99 7,899.99 7,899.99 9,689.99 7,899.99 7,899.99 9,689.99 7,899.99 3,299.99 3,299.99 7,899.99 9,689.99 9,689.99 7,899.99 7,899.99 3,299.99 9,689.99 7,899.99 3,299.99 55,299.93 31,599.96 71,099.91 63,199.92 6,599.98 38,759.96 38,759.96 19,799.94 29,069.97 71,099.91 48,449.95 38,759.96 29,699.91 23,099.93 71,099.91 48,449.95 13,199.96 77,519.92 6,599.98 19,379.98 67,829.93 23,699.97 13,199.96 63,199.92 9,899.97 38,759.96 38,759.96 39,499.95 78,999.90 67,829.93 63,199.92 39,499.95 38,759.96 71,099.91 19,799.94 13,199.96 47,399.94 9,689.99 87,209.91 39,499.95 47,399.94 6,599.98 29,069.97 47,399.94 6,599.98 4892 4893 4894 4895 4896 4897 4898 4899 4900 4901 4902 4903 4904 4905 4906 4907 4908 4909 4910 4911 4912 4913 4914 4915 4916 4917 4918 4919 4920 4921 4922 4923 4924 4925 4926 4927 4928 4929 4930 4931 4932 4933 4934 4935 4936 8/1/2013 8/1/2013 8/1/2013 8/1/2013 8/2/2013 8/2/2013 8/2/2013 8/5/2013 8/5/2013 8/5/2013 8/5/2013 8/6/2013 8/7/2013 8/7/2013 8/7/2013 8/7/2013 8/8/2013 8/8/2013 8/9/2013 8/9/2013 8/12/2013 8/12/2013 8/12/2013 8/13/2013 8/14/2013 8/15/2013 8/15/2013 8/15/2013 8/16/2013 8/16/2013 8/19/2013 8/19/2013 8/20/2013 8/21/2013 8/21/2013 8/21/2013 8/22/2013 8/23/2013 8/23/2013 8/23/2013 8/26/2013 8/27/2013 8/27/2013 8/28/2013 8/28/2013 10 9 9 9 10 4 9 4 5 9 8 7 5 2 7 2 1 4 6 4 7 6 4 3 5 5 4 10 4 4 10 4 3 3 7 6 9 5 6 4 3 2 8 5 5 9,689.99 7,899.99 9,689.99 3,299.99 3,299.99 7,899.99 7,899.99 9,689.99 9,689.99 9,689.99 9,689.99 9,689.99 3,299.99 7,899.99 9,689.99 7,899.99 9,689.99 9,689.99 9,689.99 9,689.99 3,299.99 7,899.99 7,899.99 9,689.99 7,899.99 7,899.99 9,689.99 7,899.99 7,899.99 7,899.99 7,899.99 9,689.99 7,899.99 9,689.99 9,689.99 3,299.99 9,689.99 9,689.99 7,899.99 7,899.99 7,899.99 3,299.99 9,689.99 7,899.99 7,899.99 96,899.90 71,099.91 87,209.91 29,699.91 32,999.90 31,599.96 71,099.91 38,759.96 48,449.95 87,209.91 77,519.92 67,829.93 16,499.95 15,799.98 67,829.93 15,799.98 9,689.99 38,759.96 58,139.94 38,759.96 23,099.93 47,399.94 31,599.96 29,069.97 39,499.95 39,499.95 38,759.96 78,999.90 31,599.96 31,599.96 78,999.90 38,759.96 23,699.97 29,069.97 67,829.93 19,799.94 87,209.91 48,449.95 47,399.94 31,599.96 23,699.97 6,599.98 77,519.92 39,499.95 39,499.95 4937 4938 4939 4940 4941 4942 4943 4944 4945 4946 4947 4948 4949 4950 4951 4952 4953 4954 4955 4956 4957 4958 4959 4960 4961 4962 4963 4964 4965 4966 4967 4968 4969 4970 4971 4972 4973 4974 4975 4976 4977 4978 4979 4980 4981 8/29/2013 8/29/2013 8/30/2013 8/30/2013 9/3/2013 9/3/2013 9/3/2013 9/4/2013 9/4/2013 9/4/2013 9/5/2013 9/6/2013 9/6/2013 9/6/2013 9/9/2013 9/10/2013 9/10/2013 9/11/2013 9/11/2013 9/11/2013 9/11/2013 9/12/2013 9/12/2013 9/12/2013 9/12/2013 9/13/2013 9/13/2013 9/16/2013 9/17/2013 9/18/2013 9/19/2013 9/19/2013 9/19/2013 9/20/2013 9/20/2013 9/23/2013 9/23/2013 9/24/2013 9/25/2013 9/26/2013 9/26/2013 9/26/2013 9/27/2013 9/27/2013 9/30/2013 4 1 10 6 3 5 4 9 7 9 3 2 5 2 2 5 9 7 8 1 3 6 10 8 3 6 7 9 6 6 5 5 8 9 7 10 2 9 9 4 10 5 7 6 4 3,299.99 7,899.99 9,689.99 7,899.99 7,899.99 9,689.99 3,299.99 3,299.99 7,899.99 7,899.99 7,899.99 9,689.99 7,899.99 9,689.99 7,899.99 7,899.99 9,689.99 7,899.99 9,689.99 9,689.99 3,299.99 9,689.99 3,299.99 9,689.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 7,899.99 9,689.99 3,299.99 7,899.99 7,899.99 3,299.99 3,299.99 9,689.99 3,299.99 7,899.99 9,689.99 3,299.99 9,689.99 3,299.99 3,299.99 7,899.99 13,199.96 7,899.99 96,899.90 47,399.94 23,699.97 48,449.95 13,199.96 29,699.91 55,299.93 71,099.91 23,699.97 19,379.98 39,499.95 19,379.98 15,799.98 39,499.95 87,209.91 55,299.93 77,519.92 9,689.99 9,899.97 58,139.94 32,999.90 77,519.92 23,699.97 47,399.94 55,299.93 71,099.91 47,399.94 47,399.94 48,449.95 16,499.95 63,199.92 71,099.91 23,099.93 32,999.90 19,379.98 29,699.91 71,099.91 38,759.96 32,999.90 48,449.95 23,099.93 19,799.94 31,599.96 4982 4983 4984 4985 4986 4987 4988 4989 4990 4991 4992 4993 4994 4995 4996 4997 4998 4999 5000 5001 5002 5003 5004 5005 5006 5007 5008 5009 5010 5011 5012 5013 5014 5015 5016 5017 5018 5019 5020 5021 5022 5023 5024 5025 5026 10/1/2013 10/1/2013 10/1/2013 10/1/2013 10/2/2013 10/2/2013 10/2/2013 10/2/2013 10/3/2013 10/3/2013 10/3/2013 10/4/2013 10/4/2013 10/4/2013 10/4/2013 10/7/2013 10/7/2013 10/7/2013 10/7/2013 10/8/2013 10/9/2013 10/9/2013 10/9/2013 10/9/2013 10/10/2013 10/10/2013 10/11/2013 10/14/2013 10/14/2013 10/14/2013 10/14/2013 10/14/2013 10/15/2013 10/15/2013 10/16/2013 10/16/2013 10/17/2013 10/17/2013 10/17/2013 10/18/2013 10/18/2013 10/18/2013 10/18/2013 10/21/2013 10/21/2013 5 8 7 6 1 7 9 4 5 9 6 5 3 6 3 6 8 1 6 5 6 3 7 4 7 8 4 3 2 8 4 6 3 5 9 4 3 2 4 10 1 9 3 3 7 7,899.99 9,689.99 9,689.99 9,689.99 9,689.99 3,299.99 3,299.99 9,689.99 3,299.99 7,899.99 3,299.99 9,689.99 7,899.99 9,689.99 3,299.99 7,899.99 3,299.99 7,899.99 9,689.99 7,899.99 7,899.99 7,899.99 7,899.99 3,299.99 7,899.99 9,689.99 7,899.99 3,299.99 9,689.99 9,689.99 9,689.99 7,899.99 3,299.99 9,689.99 9,689.99 7,899.99 3,299.99 7,899.99 3,299.99 9,689.99 9,689.99 3,299.99 3,299.99 7,899.99 3,299.99 39,499.95 77,519.92 67,829.93 58,139.94 9,689.99 23,099.93 29,699.91 38,759.96 16,499.95 71,099.91 19,799.94 48,449.95 23,699.97 58,139.94 9,899.97 47,399.94 26,399.92 7,899.99 58,139.94 39,499.95 47,399.94 23,699.97 55,299.93 13,199.96 55,299.93 77,519.92 31,599.96 9,899.97 19,379.98 77,519.92 38,759.96 47,399.94 9,899.97 48,449.95 87,209.91 31,599.96 9,899.97 15,799.98 13,199.96 96,899.90 9,689.99 29,699.91 9,899.97 23,699.97 23,099.93 5027 5028 5029 5030 5031 5032 5033 5034 5035 5036 5037 5038 5039 5040 5041 5042 5043 5044 5045 5046 5047 5048 5049 5050 5051 5052 5053 5054 5055 5056 5057 5058 5059 5060 5061 5062 5063 5064 5065 5066 5067 5068 5069 5070 5071 10/22/2013 10/22/2013 10/23/2013 10/23/2013 10/23/2013 10/23/2013 10/24/2013 10/25/2013 10/25/2013 10/28/2013 10/29/2013 10/30/2013 10/30/2013 10/30/2013 10/30/2013 10/31/2013 11/1/2013 11/1/2013 11/4/2013 11/4/2013 11/4/2013 11/6/2013 11/6/2013 11/7/2013 11/8/2013 11/8/2013 11/11/2013 11/11/2013 11/13/2013 11/14/2013 11/14/2013 11/15/2013 11/15/2013 11/18/2013 11/18/2013 11/19/2013 11/19/2013 11/19/2013 11/20/2013 11/20/2013 11/20/2013 11/25/2013 11/26/2013 11/26/2013 11/27/2013 3 7 6 3 2 7 2 2 1 3 3 5 7 8 5 4 8 10 5 3 8 3 2 7 3 8 5 2 7 8 4 3 7 7 9 8 3 9 8 2 2 2 3 3 2 9,689.99 7,899.99 9,689.99 9,689.99 9,689.99 9,689.99 3,299.99 3,299.99 3,299.99 7,899.99 9,689.99 9,689.99 9,689.99 9,689.99 3,299.99 9,689.99 9,689.99 9,689.99 9,689.99 3,299.99 3,299.99 3,299.99 3,299.99 7,899.99 7,899.99 3,299.99 9,689.99 7,899.99 9,689.99 9,689.99 7,899.99 9,689.99 9,689.99 9,689.99 9,689.99 7,899.99 7,899.99 9,689.99 9,689.99 3,299.99 7,899.99 3,299.99 7,899.99 7,899.99 3,299.99 29,069.97 55,299.93 58,139.94 29,069.97 19,379.98 67,829.93 6,599.98 6,599.98 3,299.99 23,699.97 29,069.97 48,449.95 67,829.93 77,519.92 16,499.95 38,759.96 77,519.92 96,899.90 48,449.95 9,899.97 26,399.92 9,899.97 6,599.98 55,299.93 23,699.97 26,399.92 48,449.95 15,799.98 67,829.93 77,519.92 31,599.96 29,069.97 67,829.93 67,829.93 87,209.91 63,199.92 23,699.97 87,209.91 77,519.92 6,599.98 15,799.98 6,599.98 23,699.97 23,699.97 6,599.98 5072 5073 5074 5075 5076 5077 5078 5079 5080 5081 5082 5083 5084 5085 5086 5087 5088 5089 5090 5091 5092 5093 5094 5095 5096 5097 5098 5099 5100 5101 5102 5103 5104 5105 5106 5107 5108 5109 5110 5111 5112 5113 5114 5115 5116 11/27/2013 11/27/2013 11/28/2013 11/29/2013 11/29/2013 11/29/2013 12/2/2013 12/2/2013 12/3/2013 12/3/2013 12/3/2013 12/4/2013 12/4/2013 12/5/2013 12/6/2013 12/6/2013 12/6/2013 12/10/2013 12/10/2013 12/12/2013 12/12/2013 12/12/2013 12/13/2013 12/13/2013 12/13/2013 12/16/2013 12/16/2013 12/17/2013 12/18/2013 12/19/2013 12/19/2013 12/19/2013 12/19/2013 12/20/2013 12/20/2013 12/20/2013 12/23/2013 12/23/2013 12/24/2013 12/26/2013 12/26/2013 12/27/2013 12/27/2013 12/30/2013 12/30/2013 6 5 4 6 1 5 2 6 6 9 5 3 10 4 5 9 5 8 2 3 8 2 3 1 3 5 7 6 9 8 7 8 10 3 4 6 10 10 7 4 2 6 2 4 4 7,899.99 7,899.99 7,899.99 3,299.99 3,299.99 3,299.99 3,299.99 7,899.99 9,689.99 7,899.99 7,899.99 3,299.99 3,299.99 9,689.99 9,689.99 7,899.99 7,899.99 7,899.99 9,689.99 9,689.99 9,689.99 9,689.99 7,899.99 3,299.99 3,299.99 3,299.99 7,899.99 9,689.99 9,689.99 3,299.99 9,689.99 9,689.99 7,899.99 7,899.99 9,689.99 7,899.99 3,299.99 7,899.99 9,689.99 7,899.99 7,899.99 7,899.99 3,299.99 9,689.99 7,899.99 47,399.94 39,499.95 31,599.96 19,799.94 3,299.99 16,499.95 6,599.98 47,399.94 58,139.94 71,099.91 39,499.95 9,899.97 32,999.90 38,759.96 48,449.95 71,099.91 39,499.95 63,199.92 19,379.98 29,069.97 77,519.92 19,379.98 23,699.97 3,299.99 9,899.97 16,499.95 55,299.93 58,139.94 87,209.91 26,399.92 67,829.93 77,519.92 78,999.90 23,699.97 38,759.96 47,399.94 32,999.90 78,999.90 67,829.93 31,599.96 15,799.98 47,399.94 6,599.98 38,759.96 31,599.96 5117 5118 5119 12/30/2013 12/31/2013 12/31/2013 9 9 3 7,899.99 3,299.99 9,689.99 71,099.91 29,699.91 29,069.97 Discount Discount Percentage 0.00 0.00 0.00 -4,360.50 -711.00 -581.40 -3,876.00 -3,876.00 -1,975.00 0.00 -792.00 0.00 0.00 -2,616.30 -3,871.00 -1,580.00 -2,907.00 -1,185.00 -193.80 -990.00 0.00 -290.70 -2,133.00 -474.00 0.00 -495.00 -5,687.99 -395.00 0.00 0.00 -2,844.00 -1,580.00 -2,528.00 0.00 0.00 -594.00 -990.00 -1,896.00 0% 0% 0% 5% 3% 2% 5% 5% 5% 0% 4% 0% 0% 3% 7% 4% 5% 5% 2% 10% 0% 3% 3% 3% 0% 5% 8% 5% 0% 0% 4% 4% 4% 0% 0% 3% 5% 3% Invoice Net Amount 78,999.90 23,699.97 23,099.93 82,849.41 22,988.97 28,488.57 73,643.92 73,643.92 37,524.95 19,379.98 19,007.94 6,599.98 23,699.97 84,593.61 51,428.93 37,919.95 55,232.94 22,514.97 9,496.19 8,909.97 78,999.90 9,399.29 68,966.91 15,325.98 55,299.93 9,404.97 65,411.92 7,504.99 58,139.94 39,499.95 68,255.91 37,919.95 60,671.92 26,399.92 15,799.98 19,205.94 18,809.94 61,303.92 Inventory Item B B A C B C C C B C A A B C B B C B C A B C B B B A B B C B B B B A B A A B -660.00 -7,899.99 -790.00 -1,659.00 -3,391.50 -4,423.99 -3,950.00 -660.00 -1,422.00 -948.00 -462.00 -2,370.00 -4,360.50 -3,160.00 790.00 -790.00 -2,212.00 -198.00 0.00 -1,264.00 -969.00 -4,423.99 -1,386.00 -3,792.00 -1,422.00 0.00 -474.00 0.00 -2,765.00 0.00 0.00 0.00 -2,528.00 -1,580.00 -1,386.00 -3,160.00 -1,162.80 -1,975.00 -1,744.20 0.00 -948.00 -2,325.60 0.00 -474.00 -1,264.00 4% 10% 5% 3% 5% 7% 10% 2% 2% 4% 2% 10% 5% 5% -2% 5% 4% 3% 0% 4% 5% 8% 7% 8% 2% 0% 2% 0% 5% 0% 0% 0% 4% 5% 7% 10% 2% 5% 3% 0% 3% 8% 0% 2% 8% 15,839.95 71,099.91 15,009.98 53,640.93 64,438.43 58,775.93 35,549.96 32,339.90 69,677.91 22,751.97 22,637.93 21,329.97 82,849.41 60,039.92 40,289.95 15,009.98 53,087.93 6,401.98 55,299.93 30,335.96 18,410.98 50,875.94 18,413.94 43,607.94 69,677.91 87,209.91 23,225.97 6,599.98 52,534.93 26,399.92 31,599.96 71,099.91 60,671.92 30,019.96 18,413.94 28,439.96 56,977.14 37,524.95 56,395.74 26,399.92 30,651.96 26,744.37 29,699.91 23,225.97 14,535.98 A B B B C B B A B B A B C B B B B A B B C B A B B C B A B A B B B B A B C B C A B C A B B -969.00 0.00 -948.00 0.00 0.00 0.00 -2,528.00 -1,106.00 -693.00 -462.00 0.00 193.80 0.00 -711.00 0.00 -4,845.00 632.00 -2,713.20 -3,950.00 -2,765.00 -396.00 -6,104.69 0.00 -3,950.00 -474.00 0.00 0.00 -7,751.99 -237.00 0.00 -1,659.00 0.00 -660.00 -660.00 -1,320.00 -3,160.00 -2,078.99 -158.00 0.00 0.00 0.00 -4,423.99 -2,111.99 -1,155.00 -6,319.99 5% 0% 4% 0% 0% 0% 8% 2% 7% 2% 0% -2% 0% 3% 0% 5% -2% 7% 10% 5% 4% 7% 0% 10% 3% 0% 0% 8% 3% 0% 3% 0% 5% 10% 10% 8% 7% 2% 0% 0% 0% 8% 8% 7% 10% 18,410.98 23,699.97 22,751.97 19,799.94 78,999.90 39,499.95 29,071.96 54,193.93 9,206.97 22,637.93 13,199.96 9,883.79 78,999.90 22,988.97 55,299.93 92,054.91 32,231.96 36,046.76 35,549.96 52,534.93 9,503.97 81,105.22 77,519.92 35,549.96 15,325.98 23,699.97 23,699.97 89,147.91 7,662.99 31,599.96 53,640.93 31,599.96 12,539.96 5,939.98 11,879.96 36,339.95 27,620.92 7,741.99 77,519.92 19,379.98 23,099.93 50,875.94 24,287.93 15,344.95 56,879.93 C B B A B B B B A A A C B B B C B C B B A C C B B B B C B B B B A A A B A B C C A B A A B -1,896.00 -2,375.99 0.00 0.00 -3,876.00 -1,106.00 -790.00 -5,687.99 -1,106.00 -1,185.00 0.00 -1,975.00 -3,950.00 0.00 -2,528.00 -2,765.00 -1,453.50 0.00 0.00 0.00 -1,896.00 0.00 0.00 -2,370.00 -1,896.00 -1,185.00 -1,659.00 -1,896.00 -297.00 -1,580.00 -5,055.99 -2,765.00 -462.00 -790.00 -790.00 0.00 -7,751.99 -330.00 -193.80 -1,584.00 -3,871.00 -2,375.99 -3,160.00 -1,320.00 0.00 8% 8% 0% 0% 10% 2% 5% 8% 7% 3% 0% 5% 5% 0% 4% 5% 5% 0% 0% 0% 3% 0% 0% 10% 3% 5% 3% 4% 3% 2% 8% 5% 7% 2% 5% 0% 10% 2% 2% 8% 7% 8% 10% 10% 0% 21,803.97 27,323.92 31,599.96 15,799.98 34,883.96 54,193.93 15,009.98 65,411.92 14,693.98 38,314.95 71,099.91 37,524.95 75,049.91 16,499.95 60,671.92 52,534.93 27,616.47 6,599.98 55,299.93 78,999.90 61,303.92 47,399.94 31,599.96 21,329.97 61,303.92 22,514.97 53,640.93 45,503.94 9,602.97 77,419.90 58,143.93 52,534.93 6,137.98 38,709.95 15,009.98 55,299.93 69,767.93 16,169.95 9,496.19 18,215.94 51,428.93 27,323.92 28,439.96 11,879.96 23,099.93 B A B B C B B B B B B B B A B B C A B B B B B B B B B B A B B B A B B B C A C A B A B A A -3,876.00 -1,979.99 -3,391.50 -2,034.90 0.00 0.00 -1,744.20 -3,876.00 -7,109.99 -316.00 -3,160.00 -1,550.40 -693.00 -3,876.00 -7,899.99 0.00 -2,133.00 -581.40 -1,422.00 -1,580.00 -1,550.40 -1,550.40 -8,720.99 -495.00 -3,555.00 0.00 0.00 -2,212.00 0.00 0.00 0.00 0.00 0.00 -198.00 -969.00 -891.00 -474.00 -792.00 -9,689.99 0.00 -2,422.50 -5,529.99 -474.00 -132.00 -3,100.80 10% 10% 5% 3% 0% 0% 2% 5% 10% 2% 10% 2% 7% 4% 10% 0% 3% 2% 2% 10% 2% 2% 10% 3% 5% 0% 0% 7% 0% 0% 0% 0% 0% 2% 5% 3% 2% 3% 10% 0% 5% 10% 2% 2% 8% 34,883.96 17,819.95 64,438.43 65,795.03 15,799.98 67,829.93 85,465.71 73,643.92 63,989.92 15,483.98 28,439.96 75,969.52 9,206.97 93,023.90 71,099.91 29,699.91 68,966.91 28,488.57 69,677.91 14,219.98 75,969.52 75,969.52 78,488.92 16,004.95 67,544.91 23,699.97 48,449.95 29,387.96 58,139.94 7,899.99 38,759.96 63,199.92 6,599.98 9,701.97 18,410.98 28,808.91 23,225.97 25,607.92 87,209.91 77,519.92 46,027.45 49,769.94 23,225.97 6,467.98 35,659.16 C A C C B C C C B B B C A C B A B C B B C C C A B B C B C B C B A A C A B A C C C B B A C -1,185.00 0.00 -924.00 0.00 -3,160.00 -594.00 -1,155.00 -3,391.50 -1,659.00 0.00 -3,950.00 -969.00 -2,907.00 0.00 0.00 -1,185.00 -1,580.00 0.00 -2,907.00 -792.00 0.00 0.00 -1,744.20 -891.00 0.00 -4,360.50 0.00 -792.00 0.00 0.00 -1,580.00 0.00 0.00 -6,976.79 -1,580.00 0.00 0.00 0.00 0.00 0.00 -872.10 -5,426.39 -395.00 0.00 -237.00 5% 0% 7% 0% 8% 2% 7% 7% 3% 0% 5% 10% 5% 0% 0% 5% 4% 0% 3% 4% 0% 0% 2% 3% 0% 5% 0% 8% 0% 0% 2% 0% 0% 8% 5% 0% 0% 0% 0% 0% 3% 8% 5% 0% 3% 22,514.97 16,499.95 12,275.96 23,099.93 36,339.95 29,105.91 15,344.95 45,058.45 53,640.93 67,829.93 75,049.91 8,720.99 55,232.94 3,299.99 19,799.94 22,514.97 37,919.95 39,499.95 93,992.90 19,007.94 77,519.92 31,599.96 85,465.71 28,808.91 13,199.96 82,849.41 47,399.94 9,107.97 29,699.91 39,499.95 77,419.90 7,899.99 32,999.90 80,233.12 30,019.96 9,899.97 48,449.95 55,299.93 38,759.96 32,999.90 28,197.87 62,403.54 7,504.99 87,209.91 7,662.99 B A A A B A A C B C B C C A A B B B C A C B C A A C B A A B B B A C B A C B C A C C B C B 0.00 0.00 0.00 -1,264.00 -660.00 0.00 0.00 0.00 0.00 -66.00 0.00 0.00 0.00 -2,325.60 -198.00 -693.00 -2,370.00 -594.00 -1,422.00 -4,739.99 0.00 -660.00 0.00 -474.00 -3,160.00 -2,713.20 -1,188.00 -1,550.40 -6,782.99 -2,034.90 0.00 -2,907.00 0.00 -632.00 -7,751.99 0.00 -594.00 -948.00 0.00 0.00 -396.00 -1,938.00 -237.00 -1,938.00 0.00 0% 0% 0% 8% 5% 0% 0% 0% 0% 2% 0% 0% 0% 4% 3% 3% 10% 3% 2% 10% 0% 5% 0% 3% 5% 4% 4% 2% 10% 7% 0% 5% 0% 4% 8% 0% 2% 2% 0% 0% 4% 5% 3% 4% 0% 16,499.95 16,499.95 6,599.98 14,535.98 12,539.96 7,899.99 32,999.90 96,899.90 47,399.94 3,233.99 23,099.93 26,399.92 38,759.96 55,814.34 6,401.98 22,406.93 21,329.97 19,205.94 69,677.91 42,659.95 32,999.90 12,539.96 23,099.93 15,325.98 60,039.92 65,116.73 28,511.91 75,969.52 61,046.94 27,035.07 16,499.95 55,232.94 6,599.98 15,167.98 89,147.91 29,069.97 29,105.91 46,451.94 29,069.97 71,099.91 9,503.97 36,821.96 7,662.99 46,511.95 13,199.96 A A A B A B A C B A A A C C A A B A B B A A A B B C A C C C A C A B C C A B C B A C B C A 0.00 -3,160.00 -3,555.00 -2,528.00 -462.00 0.00 -3,876.00 0.00 -2,325.60 0.00 -4,845.00 -775.20 0.00 0.00 -3,555.00 -3,391.50 0.00 -7,751.99 0.00 0.00 0.00 -1,659.00 -1,320.00 0.00 -693.00 -3,100.80 0.00 -1,185.00 -1,580.00 0.00 -6,319.99 -1,185.00 -1,938.00 -1,422.00 0.00 0.00 -2,370.00 -484.50 -8,720.99 -790.00 -948.00 0.00 -1,453.50 -948.00 0.00 0% 10% 5% 4% 7% 0% 10% 0% 8% 0% 10% 2% 0% 0% 5% 7% 0% 10% 0% 0% 0% 7% 10% 0% 7% 8% 0% 3% 2% 0% 10% 3% 5% 2% 0% 0% 5% 5% 10% 2% 2% 0% 5% 2% 0% 55,299.93 28,439.96 67,544.91 60,671.92 6,137.98 38,759.96 34,883.96 19,799.94 26,744.37 71,099.91 43,604.96 37,984.76 29,699.91 23,099.93 67,544.91 45,058.45 13,199.96 69,767.93 6,599.98 19,379.98 67,829.93 22,040.97 11,879.96 63,199.92 9,206.97 35,659.16 38,759.96 38,314.95 77,419.90 67,829.93 56,879.93 38,314.95 36,821.96 69,677.91 19,799.94 13,199.96 45,029.94 9,205.49 78,488.92 38,709.95 46,451.94 6,599.98 27,616.47 46,451.94 6,599.98 B B B B A C C A C B C C A A B C A C A C C B A B A C C B B C B B C B A A B C C B B A C B A -9,689.99 -2,844.00 0.00 -1,188.00 0.00 0.00 -1,422.00 0.00 -969.00 -2,616.30 -2,325.60 -3,391.50 0.00 0.00 -3,391.50 -316.00 -775.20 -3,100.80 0.00 0.00 -693.00 0.00 -948.00 -2,907.00 0.00 -1,580.00 -2,713.20 -7,899.99 -948.00 -1,264.00 -3,160.00 0.00 -711.00 -1,453.50 -2,713.20 -1,979.99 -1,744.20 -4,845.00 -1,896.00 -2,212.00 -474.00 -198.00 -7,751.99 0.00 0.00 10% 4% 0% 4% 0% 0% 2% 0% 2% 3% 3% 5% 0% 0% 5% 2% 8% 8% 0% 0% 3% 0% 3% 10% 0% 4% 7% 10% 3% 4% 4% 0% 3% 5% 4% 10% 2% 10% 4% 7% 2% 3% 10% 0% 0% 87,209.91 68,255.91 87,209.91 28,511.91 32,999.90 31,599.96 69,677.91 38,759.96 47,480.95 84,593.61 75,194.32 64,438.43 16,499.95 15,799.98 64,438.43 15,483.98 8,914.79 35,659.16 58,139.94 38,759.96 22,406.93 47,399.94 30,651.96 26,162.97 39,499.95 37,919.95 36,046.76 71,099.91 30,651.96 30,335.96 75,839.90 38,759.96 22,988.97 27,616.47 65,116.73 17,819.95 85,465.71 43,604.96 45,503.94 29,387.96 23,225.97 6,401.98 69,767.93 39,499.95 39,499.95 C B C A A B B C C C C C A B C B C C C C A B B C B B C B B B B C B C C A C C B B B A C B B 0.00 -790.00 -3,876.00 -1,896.00 -474.00 -1,938.00 -660.00 -594.00 -5,529.99 0.00 -1,896.00 -775.20 0.00 -387.60 -1,264.00 -2,765.00 0.00 -2,765.00 0.00 0.00 -198.00 -4,069.80 -1,320.00 -1,550.40 -948.00 -1,422.00 -4,423.99 -4,976.99 0.00 -1,422.00 -3,391.50 -330.00 -5,055.99 -7,109.99 -1,847.99 -2,639.99 -581.40 0.00 0.00 -3,100.80 -1,320.00 -2,422.50 0.00 0.00 -3,160.00 0% 10% 4% 4% 2% 4% 5% 2% 10% 0% 8% 4% 0% 2% 8% 7% 0% 5% 0% 0% 2% 7% 4% 2% 4% 3% 8% 7% 0% 3% 7% 2% 8% 10% 8% 8% 3% 0% 0% 8% 4% 5% 0% 0% 10% 13,199.96 7,109.99 93,023.90 45,503.94 23,225.97 46,511.95 12,539.96 29,105.91 49,769.94 71,099.91 21,803.97 18,604.78 39,499.95 18,992.38 14,535.98 36,734.95 87,209.91 52,534.93 77,519.92 9,689.99 9,701.97 54,070.14 31,679.90 75,969.52 22,751.97 45,977.94 50,875.94 66,122.92 47,399.94 45,977.94 45,058.45 16,169.95 58,143.93 63,989.92 21,251.94 30,359.91 18,798.58 29,699.91 71,099.91 35,659.16 31,679.90 46,027.45 23,099.93 19,799.94 28,439.96 A B C B B C A A B B B C B C B B C B C C A C A C B B B B B B C A B B A A C A B C A C A A B 0.00 -1,550.40 0.00 -1,162.80 -193.80 -1,847.99 -594.00 0.00 -1,155.00 -3,555.00 -990.00 0.00 0.00 -2,325.60 -495.00 0.00 0.00 0.00 -1,744.20 -3,950.00 -1,896.00 -1,659.00 -5,529.99 0.00 -3,871.00 -6,201.59 -1,580.00 -495.00 -1,550.40 0.00 -3,100.80 -1,896.00 0.00 -3,391.50 -6,976.79 -2,212.00 0.00 -316.00 -528.00 -7,751.99 -775.20 0.00 -990.00 -948.00 -1,847.99 0% 2% 0% 2% 2% 8% 2% 0% 7% 5% 5% 0% 0% 4% 5% 0% 0% 0% 3% 10% 4% 7% 10% 0% 7% 8% 5% 5% 8% 0% 8% 4% 0% 7% 8% 7% 0% 2% 4% 8% 8% 0% 10% 4% 8% 39,499.95 75,969.52 67,829.93 56,977.14 9,496.19 21,251.94 29,105.91 38,759.96 15,344.95 67,544.91 18,809.94 48,449.95 23,699.97 55,814.34 9,404.97 47,399.94 26,399.92 7,899.99 56,395.74 35,549.96 45,503.94 22,040.97 49,769.94 13,199.96 51,428.93 71,318.33 30,019.96 9,404.97 17,829.58 77,519.92 35,659.16 45,503.94 9,899.97 45,058.45 80,233.12 29,387.96 9,899.97 15,483.98 12,671.96 89,147.91 8,914.79 29,699.91 8,909.97 22,751.97 21,251.94 B C C C C A A C A B A C B C A B A B C B B B B A B C B A C C C B A C C B A B A C C A A B A -581.40 0.00 -2,325.60 -1,453.50 -387.60 -3,391.50 -528.00 -528.00 0.00 0.00 -581.40 0.00 -2,713.20 -7,751.99 -1,650.00 -1,162.80 0.00 0.00 -2,422.50 0.00 -2,111.99 -198.00 0.00 0.00 -1,659.00 0.00 -4,845.00 0.00 -2,034.90 -3,876.00 -948.00 0.00 -2,713.20 0.00 -4,360.50 -5,055.99 -1,659.00 0.00 -1,550.40 -660.00 0.00 0.00 -948.00 0.00 0.00 2% 0% 4% 5% 2% 5% 8% 8% 0% 0% 2% 0% 4% 10% 10% 3% 0% 0% 5% 0% 8% 2% 0% 0% 7% 0% 10% 0% 3% 5% 3% 0% 4% 0% 5% 8% 7% 0% 2% 10% 0% 0% 4% 0% 0% 28,488.57 55,299.93 55,814.34 27,616.47 18,992.38 64,438.43 6,071.98 6,071.98 3,299.99 23,699.97 28,488.57 48,449.95 65,116.73 69,767.93 14,849.96 37,597.16 77,519.92 96,899.90 46,027.45 9,899.97 24,287.93 9,701.97 6,599.98 55,299.93 22,040.97 26,399.92 43,604.96 15,799.98 65,795.03 73,643.92 30,651.96 29,069.97 65,116.73 67,829.93 82,849.41 58,143.93 22,040.97 87,209.91 75,969.52 5,939.98 15,799.98 6,599.98 22,751.97 23,699.97 6,599.98 C B C C C C A A A B C C C C A C C C C A A A A B B A C B C C B C C C C B B C C A B A B B A -1,896.00 -1,185.00 -2,528.00 -1,584.00 -99.00 -825.00 -660.00 0.00 -1,744.20 -7,109.99 0.00 -198.00 -3,299.99 0.00 0.00 -2,133.00 0.00 -1,264.00 -1,356.60 0.00 0.00 -1,356.60 -711.00 -165.00 -198.00 -1,320.00 -1,659.00 -1,744.20 -6,976.79 -1,847.99 -3,391.50 -3,876.00 0.00 -2,370.00 0.00 0.00 -3,299.99 -5,529.99 -1,356.60 0.00 -1,106.00 -948.00 -132.00 -3,100.80 -632.00 4% 3% 8% 8% 3% 5% 10% 0% 3% 10% 0% 2% 10% 0% 0% 3% 0% 2% 7% 0% 0% 7% 3% 5% 2% 8% 3% 3% 8% 7% 5% 5% 0% 10% 0% 0% 10% 7% 2% 0% 7% 2% 2% 8% 2% 45,503.94 38,314.95 29,071.96 18,215.94 3,200.99 15,674.95 5,939.98 47,399.94 56,395.74 63,989.92 39,499.95 9,701.97 29,699.91 38,759.96 48,449.95 68,966.91 39,499.95 61,935.92 18,023.38 29,069.97 77,519.92 18,023.38 22,988.97 3,134.99 9,701.97 15,179.95 53,640.93 56,395.74 80,233.12 24,551.93 64,438.43 73,643.92 78,999.90 21,329.97 38,759.96 47,399.94 29,699.91 73,469.91 66,473.33 31,599.96 14,693.98 46,451.94 6,467.98 35,659.16 30,967.96 B B B A A A A B C B B A A C C B B B C C C C B A A A B C C A C C B B C B A B C B B B A C B -2,844.00 -2,375.99 0.00 4% 8% 0% 68,255.91 27,323.92 29,069.97 B A C Salesperson Number Invoice Status Financial Quarter 2 1 2 3 2 5 1 3 5 2 3 4 5 6 3 2 3 5 3 1 6 6 5 2 2 4 6 5 5 4 4 4 4 3 1 5 5 3 Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 5 2 6 5 4 5 3 3 1 2 5 5 6 4 6 1 4 5 2 4 5 3 6 6 6 4 2 3 6 2 4 3 3 4 5 2 5 1 3 5 5 2 6 6 Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 6 2 1 5 3 4 5 1 4 3 1 5 3 2 5 5 5 3 5 2 4 4 4 5 2 2 4 5 3 4 3 4 1 5 2 6 5 6 4 1 4 5 6 2 5 Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5 5 1 4 5 4 2 6 3 6 6 5 1 2 3 6 5 4 3 4 3 3 4 5 3 1 2 4 4 6 5 5 2 3 5 3 1 6 2 6 2 5 5 5 4 Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 5 1 2 2 4 6 4 5 2 2 5 3 2 2 5 4 3 4 2 5 6 4 5 2 6 5 1 2 5 4 6 1 4 4 5 3 4 6 5 6 5 5 1 3 6 Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 5 2 2 5 5 6 1 4 2 3 5 5 5 6 1 5 1 4 6 2 3 6 4 4 1 5 3 3 2 2 4 1 3 3 5 6 3 6 3 2 2 5 5 6 3 Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 3 3 4 2 2 5 3 3 2 2 6 6 1 2 1 2 3 4 5 3 1 3 2 6 6 4 3 2 1 4 5 6 4 5 4 3 3 3 6 4 5 4 2 1 Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 1 5 6 1 3 4 5 2 5 3 5 4 1 3 6 5 3 5 3 2 2 3 5 1 5 1 2 3 4 4 5 2 1 2 6 4 5 4 5 1 1 3 6 2 2 Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 4 2 6 2 6 6 3 1 2 1 6 2 2 4 2 5 5 3 2 6 3 1 3 6 6 5 5 3 6 4 5 4 5 6 3 6 5 5 5 4 1 5 6 6 Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 3 5 4 2 4 2 1 5 2 1 4 3 4 5 5 2 1 1 4 5 4 4 2 6 1 5 5 2 4 5 2 3 2 5 3 4 2 1 5 2 4 4 3 5 Paid Paid Paid Open Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Paid 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 5 6 3 2 5 1 2 5 5 3 1 5 4 4 3 2 3 3 3 3 5 4 5 5 5 4 4 5 2 6 4 3 6 1 1 3 5 3 4 4 6 5 5 4 Paid Paid Paid Paid Paid Open Paid Paid Open Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Paid Open 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 5 3 5 3 2 3 1 3 2 3 3 4 5 5 6 1 2 2 6 2 2 3 1 4 5 4 5 6 6 4 3 5 5 3 3 2 4 2 4 2 3 5 5 5 6 Paid Paid Open Open Paid Paid Open Paid Paid Open Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Open Paid Paid Paid Paid Open Paid Paid Paid Paid Paid Paid Paid Paid Paid Paid Open Paid Open Paid Paid Paid Paid Paid Paid 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 6 2 6 5 3 3 1 2 6 6 6 5 2 4 6 1 1 2 6 2 2 3 3 2 4 5 4 2 1 6 6 1 6 4 5 5 3 4 2 6 4 1 5 5 Open Paid Paid Paid Open Paid Paid Open Paid Open Open Paid Open Open Open Paid Paid Open Paid Open Paid Open Open Open Open Paid Paid Paid Open Open Paid Paid Paid Paid Paid Paid Paid Open Open Paid Paid Open Paid Open Paid 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 3 2 Paid Paid Paid 4 4 4 MSFS 670 - ActiveData Graded Homework Assignment The attached Excel workbook contains data that has been extracted from NetSuite (via the Export to CVS file function at the bottom right of all reports - I simply am saving you this step). Use the data and the workbook to complete the following homework questions. Perform all analyses in this Excel workbook and answer the narrative questions on the same page as the analysis (use Insert Text Box) so that you only submit ONE file to your Assignment Folder according to the date in the Syllabus. Remember to rename the workbook under your name so that it can be easily identified for grading. You should have experience with all of these Active Data functions from the Session 8 and you may refer to the demo videos at http://www.informationactive.com/iaplayer.cgi?x=play&v=&p=ad/videos&i=adVideos.csv. Part 1 Purchase Order Summary/Pivot Analysis Go to the Tab named \"PO Register\". \"Clean\" the data according to the following instructions. Note: The concept of how data should be presented inorder for Active Data commands to work, applies all the time. This process of \"cleaning\" or preparing data for analysis is common in many data analysis packages. a. Most of ActiveData's commands require that the column names be in row 1 and that row 2 and beyond contain the data. In addition to this, ActiveData (and often Excel) looks at the first couple of rows of each column to determine what type of data the column contains (text, numbers or dates). Your csv file has 5 rows before the column names and an extra row after the column names with a title in it and then the raw data rows. Remove the first 5 rows and row 7: Remove Grand Total rows and rename the resulting worksheet, \"PO Analysis\". a. As the CFO/Controller, you would like to see this report summarized by vendor, with amount totals, displayed in a pivot table that shows Status across the top, with Vendors down the left side, with amounts and grand totals. (Check your pivot totals to your data totals as a last step.) b. Question: As CFO/Controller, verbally describe in a narrative whether there are any things Ramsey PO Clerks should be looking out for or doing better in their data entry. c. Question: As CFO/Controller, verbally describe the results, and do you have any concerns in the summary that you see? Part 2 Vendor Duplicate Payment Analysis Go to the Tab named \"Payments\" in the Excel workbook. Make sure your data is clean and prepped for analysis. Perform an analysis using ActiveData to extract a list of duplicate payment amounts from the raw data. Rename the resulting worksheet, \"Dup Pymt Analysis\". a. Question: Do any duplicate amounts appear? b. Question: After investigating these amounts, what is your conclusion as to their status (are they indeed duplicate payments)? c. Question: As CFO/Controller, verbally describe in a narrative whether there are any things Ramsey PO Clerks should be looking out for or doing a better job of in the course of their data entry? Part 3 - Analysis of Sales Discounts Granted Several years ago, in an effort targeted at maintaining customer satisfaction, the Sales Manager granted his salespeople the ability to offer customer discounts in order to match competitor pricing. Although Ramsey prices their air products competitively, at times a competitor will offer special volume promotions or other sales that the Company is willing to match. Also, the salespeople are authorized to grant a preferred customer discount to their top customers. Generally, sales discounts range from 2% to 5%, although the salespeople are authorized to grant a discount up to 10% in exceptional conditions in order to close a sale. Historically, the annual sales discounts granted by Ramsey have averaged at just below 2% of gross sales revenue. This year, however, the controller has brought to the attention of the Sales Manager that the sales discounts granted have increased dramatically, to nearly 4% of gross sales revenue. The Sales Manager has been tasked with providing an explanation for this increase. Impressed with the functionality of ActiveData in generating the requested compensation reports, the Sales Manager has requested that you use ActiveData to analyze the unexpectedly high sales discounts granted in 2013. a. Begin on the worksheet titled \"2013_Sales\". Recognizing that it will be more helpful to analyze sales discounts as a percentage of the Invoice Gross Amount, insert a Calculated Column to the right of the Discount column. Name the new column, \"Discount Percentage\". Determine the appropriate formula to be entered to complete this calculation. Ensure that the discount percentages are shown as positive amounts and are formatted as Percent Style. NOTE: After completing this step, you may or may not show a large value in cell G58? (depending on your worksheet layout. Simply delete this number (if it is in your worksheet) - it is not a figure you will need as you progress through the assignment. b. On the \"2013_Sales\" tab, to the right of the Invoice Status column, insert a Calculated Column to identify the Financial Quarter associated with each sales invoice. Name the new column, \"Financial Quarter.\" You may have to cut and paste the column to show it in the correct location in the worksheet. c. To begin to analyze the percent sales discounts granted in 2013, use ActiveData's Strata function. Select the Discount Percentage column as both the Column to Stratify and the Column to Total. Manually enter the Stratification Bands in 0.02 increments beginning at 0 and ending at 0.10. Include a sixth band from 0.10 - 1.0 to pick up all discounts granted at 10% and higher. Group this first stratification by Financial Quarter and only chart the \"Percentage of Total Count\" stratification results. Rename the resulting worksheet, \"Stratified by Qtr\". HINT: The chart output requested above is not the standard chart output. You may need to make modifications to the chart to reflect the final answer. d. Analyze the stratification results and related charts for each of the financial quarters. What observations can you make regarding the increased sales discounts in 2013? Were any discounts granted to customers in violation of the company's policy? Insert the textbox with your response to the right of the first chart on the \"Stratified by Qtr\" worksheet. e. To further analyze the percent sales discounts granted in 2013, perform a second stratification. Again, select the Discount Percentage column as both the Column to Stratify and the Column to Total. Manually enter the Stratification Bands in 0.02 increments beginning at 0 and ending at 0.10. Include a sixth band from 0.10 - 1.0 to pick up all discounts granted at 10% and higher. However, group this stratification by Salesperson Number and, again, only chart the \"Percentage of Total Count\" stratification results. Rename the resulting worksheet, \"Stratified by Salesperson\". HINT: The chart output requested above is not the standard chart output. f. Analyze the stratification results and related charts for the sales discounts granted by each of the salespeople. What observations can you make regarding the increased sales discounts in 2013? Considering the observations made at step d, above, why do you believe the sales discounts have nearly doubled in 2013? Are there any suggestions for how the Company could lower the total sales discounts for 2014? Insert the textbox with your response to the right of the chart on the \"Stratified by Salesperson\" worksheet. Team Task 3 (T3-S4) Instructions Team Task #3 (Due at the end of Session 4) Jump ahead from the RFP and the company has picked NetSuite! Part 1: You've seen NetSuite and have gotten a feel for the system. You know your project requirements. Prepare a detailed implementation plan that communicates to company personnel the following: Short introduction to vendor selected Approach to implementation (phased, pilot, big bang) Timeline based on approach selected Who's managing what for Ramsey and by the vendor Other steps and important information that your team thinks is necessary to document for a successful implementation Part 2: Using a Social Technology After you complete Part 1 design a simple social technology site for the Ramsey ERP implementation. Using one of the following social technologies listed below (or a similar free product that you may have access to or are familiar with), create a place where stakeholders in the ERP implementation (as determined by you) may interact and collaborate over the project. One paragraph on your team's social site should explain how the site will be used during the project implementation process. For example, is it only for your consulting team and management, or will other stakeholders, like employees be able to access the site and engage? You may use all, some, or augment the content from your prior team tasks. Try as many of the sites features as you can. Everyone on the team should become familiar with the technology, be able to use it, and show evidence of its use on the site. At the end of Session 4, submit a Word document that explains to me how to access your social technology (for most this means sending me the team leads login and id). I will evaluate the site. I will also share screenshots with the entire class. Possible social technology* applications (free) to use: Clinked at http://clinked.com/ Zoho Wiki at https://www.zoho.com/wiki/ Wedoist Project at https://wedoist.com/ Blogger at http://blogger.com/ (requires Google Account) Teambox at http://teambox.com/ Huddle at http://www.huddle.com/ Flowdock at https://www.flowdock.com/ 5PM Project at https://www.5pmweb.com/login.php *Always remember to be cautious with personal information. I know the many of these technologies are new for us, but don't be stressed. Look at this activity as fun. Really role-play and think of how the tool you choose would be beneficial in the implementation context. I've picked these technologies for their ease of use. They meet my rule of \"Tech in Ten\MSFS 670 - The Ramsey Company Case The Company Ramsey, Inc. formed in 2001, is a wholesale distribution company that buys from various manufacturers and resells the items to retailers. The retailers in turn, sell to the public end user. In its role as a distributor, Ramsey acts as the sales and service representative for its various manufacturers/suppliers and generally earns its revenues through markups on products sold to retailers. The company has contractual relationships with each of its manufacturers/suppliers that vary in terms of discounts, distribution territories/rights and service responsibilities. It works diligently to maintain an active network of retailers who buy the products of the manufacturers that Ramsey represents. As a link between manufacturer and retailer, Ramsey serves a vital role in the product distribution channel and the flow of goods from initial production to the final customer, as shown in the illustration. Ramsey holds inventory, markets manufacturers' products, ships manufacturer goods, and provides credit to retailers. Ramsey houses products in distribution centers at its three principle locations and ships them on-demand to its retailers, eliminating the need for manufacturers to maintain their own distribution centers, shipping and credit facilities. Ramsey employs inside and outside sales representatives who contact retailers, convince them to carry products form Ramsey manufacturers and manage the ongoing relationships. The outside sales reps find new clients, while the inside reps call on existing clients and renew orders. Like many wholesalers, Ramsey stocks a range of products from several manufacturers, focusing on the following business segments: Computing and Office Supplies, Medical UMUC, Klose, 2013 Page 1 Supplies, Sporting Goods and Beverage Distribution. Its manufacturer/suppliers include companies like Hewlett Packard, Canon, National Instrument, Herman Miller, Glaxco, Bayer, Natures Own, Riddle Sports and Alexander Vineyards. Its retailers include office supply and furniture depots, computer and software chains, drug stores, sporting goods shops, and beverage retailers. The company is a member of National Association of Wholesales: http://www.naw.org/ The company is privately held with 68 employees with plans to increase to 125 over 5 years. Ramsey headquarters are located in San Mateo, California (San Francisco Bay Area), but it also has locations in Boston and Los Angeles. 40 employees work in the headquarters, 14 in Los Angeles, and 14 in Boston. Each division office has 4 Sales Representatives, with Boston based reps covering the Eastern sales territory. San Francisco reps focus on the Western sales territory, while reps based in LA work both the East and West. The company operates in the US, Canada and Europe. The company's organizational chart appears in Attachment B. The Ramsey Mission The following is the company's mission as contained in its Annual Report: \"Our mission is to distribute branded retail merchandise and provide superior customer service to our loyal customers. We will strive to exceed the expectations of our stakeholders and build long-term relationships with our customers, suppliers and employees.\" The Products and Services The company maintains an inventory of a wide variety of products from office, sports and medical supplies, to computers, peripherals, and software and business furniture. The company houses inventory in its three principle locations and employs a perpetual inventory system. Some inventory, such as computers require assembly or customization. To stay ahead of this competitors, Ramsey must provide exceptional customers service. It needs to offer prompt and reliable delivery, offer a process for returns and handling damaged goods and provide credit on sales. In addition, Ramsey's sales and customer sales representatives have to understand the products of the manufacturers that the company represents as well as the needs of the retail businesses to whom they sell. Financial Information UMUC, Klose, 2013 Page 2 Ramsey is classified under SIC Code519908, General Merchandise-Wholesale and NAICS Code 424990, Other Non-Durable Goods Merchant Whls in industry reports. As a privately held company, it is owned by 6 investors. The company pays periodic dividends from profits, but has not done so for the last two years as they reinvest in operations. A buyout agreement is in place that lays out the steps that the company must follow should a shareholder leave the company and sets the sales price per share based on a predetermined formula of 3x sales. The Competition As general merchandise distributor in the small to mid-range of the wholesaler segment, Ramsey competes most frequently with the following companies: Company General Merchandise Distrs. Inc. Atlanta, GA Umya Wholesale Merchandise Macon, GA United Wholesale Fresno, CA Source: Products Private company categorized under Wholesale Giftwares. Our records show it was established in 1985 and incorporated in Georgia. Current estimates show this company has an annual revenue of $1 to 2.5 million. Private company categorized under Wholesale General Merchandise. Current estimates show this company has an annual revenue of $2.5 to 5 million. Private company categorized under Wholesale General Merchandise. Our records show it was established in 2009 and incorporated in California. Current estimates show this company has annual revenue of $5,000,000. http://www.manta.com One advantage that Ramsey has over its competitors is that it has developed a website to advertise to new potential retail customers. The site also allows current retail customers to order online via its membership and customer support area. The current CEO strives to model Ramsey's website presence after Price Master Corp (http://www.pricemaster.com/), a national distributor of convenience and dollar store products located in Queens, New York. The company carries 3000+ item product line that includes products from leading brands such as Duracell, Tylenol, Colgate, Bic, Chapstick, Kodak, and hundreds more. Price Master offers competitive pricing, wide product variety, and outstanding service with stock availability of over 95% and most orders are shipped within 1 business day. UMUC, Klose, 2013 Page 3 Existing Financial Information System and Technology Structures The company currently has several units: Accounting, Partner Support, E-commerce/Web, Employee Support, Sales, Executive Team, Marketing, Shipping, Customer Support and Vendor Support. The company has several non-integrated systems. It uses Great Plains for its accounting software, Timesheets for its time and billing software, and Goldmine for sales prospecting and tracking. Payroll and benefits are outsourced to ADP (Automated Data Processing). As an established wholesaler, Ramsey spends most of its time tracking shipments and managing orders, and much of this process is done manually. The non-integrated systems are difficult and costly to maintain and result in unproductive efforts to perform tasks that are dependent on financial, material, and asset management information located in disparate sources. The company's CEO has asked the CFO to put together a team to investigate an integrated Enterprise Resource Planning (ERP) solution. The company's business functions are summarized in the following Great Plains Function Authorized Users Current Processes Timesheets Function Authorized Users Current Processes UMUC, Klose, 2013 Accounting, including inventory control, AR, AP, GL, and asset management. Payroll is outsourced to ADP. CFO/Controller- access to all. Accounting Staff per their function. CEO, emergency, all access. Payroll file prepared by ADP, all other entries from other systems, manually prepared. The controller prepares financial statements in accounting system and exports them to Excel and emails them to the CFO for review. Time entry and reporting for payroll. Labor hours on assembly are NOT tracked by project. A standard hourly overhead rate is captured in product pricing. The Controller and the payroll coordinator have full access to the software. All company employees enter their time directly into the system. Managers have approval level access for review and changes. Accounting manually aggregates payroll reporting to ADP via ADPs's online system. ADP creates a GL entry file for the Great Plains system. Project managers review time spent on projects and make adjustments as necessary. Draft invoices from Timesheets software are manually entered into Great Plains system and sent as final. GL entries are manually made for revenue recognition adjustments (work completed, but not yet billable per contract). Page 4 Goldmine Function Authorized Users Current Processes The sales force enters leads, customer prospects and sales orders into the system. The sales director manages the sales funnel from these reports and sales orders are used to pull and/or purchase inventory upon signed order. Sales Manager and Sales Force. Only the Sales Manager and President have full access to the software. Sales orders are photocopied and placed in a customer file, which follows the sales through picking and shipment (the fulfillment process). The sales order must be re-entered into the Great Plains accounting system by the purchasing agent, and manually moved to invoice status when sale is ready to invoice. Sales reports must be run in Goldmine and emailed to interested users. The company has not had to rely on custom software to meet its needs, but it does have some specific growth requirements that are motivating its interest in enhancing its information systems. It recently engaged a consultant that tested the company's physical network wiring and infrastructure to make sure that it could withstand additional daily network usage and traffic. All data cabling and hubs to wireless