Hello there,

I need help with Finance homework assignment. Please see attachment details information 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 Individual HW-S5 Instructions Part 1-A: Draw systems flowchart of how you would expect the customer payment process to work at Ramsey with the installation of NetSuite. Part 1-B: As the CFO, you want to see what features in the NetSuite system will help you track outstanding AR. Explore the system and determine the following What customer(s) has unpaid invoices greater than 60 days? Which customers accounted for the highest and lowest sales volumes in 2014? What is the company's average days outstanding? Run all reports as of December 31, 2014. \"Show and tell\" where you obtained the information by using screenshots and identifying on-screen view or report that you used to locate your response. Part 1-C: As the CFO, what processes and technologies might you use to follow-up with customers who are past due on their accounts? How might you enable or encourage customers to pay on time? Are there any practices of particular concern for wholesalers like Ramsey? 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 access points, switches and routers were tested. It tested the company's LAN and supporting Windows and SQL server software. An inventory of the applications that the company can support in addition to expanded accounting and finance ERP, include: Network file and remote printing services User directory and authentication services E-mail and collaboration software Content management software Web applications Network security and anti-virus Network fax Accounting systems Database applications Remote access software Network backup Though the company appears to have the capability to support an integrated ERP, it is open to recommendations and will budget for additional infrastructure. UMUC, Klose, 2013 Page 5 Job Classifications The company currently has the following job classifications in place. Accounting Manager/Controller Admin - CSR Admin - New Bus Dev Admin - Sales AP Clerk AR Clerk CEO/President Chief Financial Officer Chief Operating Officer Customer Service Rep Customer Service Manager Driver Graphic Artist HR/Office Manager Implementation Specialist IT Manager IT Support New Bus Development Mgr New Business Developer Payroll Specialist Receiving Clerk Sales Director Sales Representative Shipping Clerk VP Sales Warehouse Manager Warehouse Worker Driven by Sales and Customer Service Ramsey's success is driven by sales and customers service. New business development (3 employees located in San Mateo) concentrate on lining up manufacturers to represent, while the 12 sales people (4 at each location) concentrate on targeting new and calling on existing retailers (Ramsey's customers). Customer Service Representatives (CSRs) with 4 located in Boston, 4 in San Mateo, and 1 in Los Angeles focus on supporting the existing retailer network. San Mateo and Los Angeles locations concentrate on sales and service in the Western Region, including Alaska and Western Canada. Boston handles the Eastern Region, including Eastern Canada and Europe. Ramsey Sales and Customer Service Map UMUC, Klose, 2013 Page 6 The company maintains CSR Desks at the three locations that operate 7AM EST to 8PM PST. The COO would like to be able to easily access information that shows how much time the support team spends servicing each customer and how many on-site visits are required, in order to gather information for product costing. He is also interested in maintaining high service standards to ensure customer retention. Having excellent sales and service organizations are essential to the company's profitability. The sales people are trained by experienced mentors. The CEO would like to be able to view key information about the company from his desktop. He was golfing with the CEO of Davis Wholesale and heard all about the company's use of performance dashboards. He's not sure if he got all the facts, but is sure this feature would benefit his company. He wants to learn more about them. The company has decided to look at an information system that would combine transaction processing, decision-support, management information, and executive support in one enterprise-wide integrated ERP solution. Your Role as the CFO & ERP Implementation Team UMUC, Klose, 2013 Page 7 This semester you will play the role of a member of the internal consulting team that the Controller/CFO has put together of Ramsey's top CFO/CIO people, who will handle the evaluation, selection, acquisition, implementation, and management through cut-over of the new ERP. The phases of the project are outlined in the following table: Beginning in Session 2, your team will begin working on the Ramsey ERP project that runs throughout the semester and serves as one activity to guide our learning about the role of information systems in financial management. Most of the information that you need for the project is contained in this case summary. Any additional information will be provided during weekly sessions. Post any questions about the tasks/homework in the sessions \"Questions for this Week\" conference. Since this is a hypothetical case, there is some \"role-playing\" involved, in that the activities are intended to allow you to demonstrate how you would handle an ERP implementation and certain financial management activities in the real world. The activities require you to draw from all of your prior learning in financial management and information systems and may require that you look back to your prior studies to complete the tasks. This is done intentionally so that you have an opportunity to review many of the important concepts and skills you've learned. When completing your tasks, there will probably be some information gaps about Ramsey's operations that you'll have to address. You'll have to make some assumptions that as a wholesaler the company functions in a certain way. The key here is that you simply state all assumptions in your work. These assumptions have to REASONABLE, however, meaning they have to be founded on accepted business and financial management principles, and demonstrate your understanding of such principles. Your work related to the ERP project will be graded on the following dimensions 1) the reasonableness, accuracy, and completeness of the content of presentations, 2) writing (communication) skills, 3) supplemental research (which MUST be properly cited according to APA style), 4) understanding of the subject matter, 5) integration of current and/or prior learning and knowledge (not materials - no recycling of prior homework or projects!), and when applicable, 6) quality of group participation, as seen in group conferences. Session 2 3 4 UMUC, Klose, 2013 Task Team Task #1 - Ramsey Case Vision, Business Case, & Candidates Team Task #2 - Request for Proposal Team Task #4 - Ramsey Implementation Plan with Social Media Site Page 8 Attachment A Ramsey Inc. Organizational Chart Pres/CEO Dale Williams Customer Service - East David Garcia Chief Operating Officer CIO & Web Services Chief Financial Officer VP of Sales Mark Jones Brenda Wilsom Randy Unger Mark Bidwell Customer Service - West Brenda Jones Warehouse/Shipping Mgr Tom Kess Accounting Manager HR Department Director - East Director - West New Sales Aiden Somerhalder Carmen Mathews George Phelps Miles Grey Brad Sparling Accounting & Payroll Clerks UMUC, Klose, 2013 Page 9