1 / 11

Bill’s Bells

Bill’s Bells.

mills
Télécharger la présentation

Bill’s Bells

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Bill’s Bells Bill's Bells is a company that sells several kinds of bells to customers. Offered are cow bells, sleigh bells, dinner bells, bicycle bells, etc. Each bell style comes in various sizes. Bill is the chief purchasing agent for Bill's Bells, but there are several other purchasing agents as well. Bill prefers certain vendors for different bells; for instance he likes to buy cow bells from Bessie's Wholesale Bells. However, he sometimes purchases cow bells from Farm-time Follies. He has one preferred vendor and at least one back-up vendor for each type of bell. A vendor can be the preferred vendor for more than one kind of bell. Bill pays for all purchases made from a vendor during a given month on the last day of that month. Bill has several salespeople who are paid on commission. If a customer's assigned salesperson is not working when the customer comes in, another salesperson may assist that customer. The resulting commission would be split between the two salespeople. No sale is allowed without the customer paying at least 25% down at the time of the sale. Most customers pay the 25%, and then make 3 more equal monthly installments. Some customers pay in full at the time of the sale. Most cash receipts are from customers. Cashiers process all cash receipts and cash disbursements. Bill's Bells has several different types of cash accounts into which cash receipts are deposited.

  2. Inventory Sales Sales Rep Customer Cash Receipts Cashier Cash

  3. (0,N) (1,N) (1,N) (0,N) (?,N) (1,1) (1,N) (?,1) (0,N) (0,N) (0,N)or (0,1) (0,1) (0,N) (1,1) (0,N) (1,1)

  4. Most Likely case

  5. Bill’s Bells Bill's Bells is a company that sells several kinds of bells to customers. Offered are cow bells, sleigh bells, dinner bells, bicycle bells, etc. Each bell style comes in various sizes. Bill is the chief purchasing agent for Bill's Bells, but there are several other purchasing agents as well. Bill prefers certain vendors for different bells; for instance he likes to buy cow bells from Bessie's Wholesale Bells. However, he sometimes purchases cow bells from Farm-time Follies. He has one preferred vendor and at least one back-up vendor for each type of bell. A vendor can be the preferred vendor for more than one kind of bell. Bill pays for all purchases made from a vendor during a given month on the last day of that month. Bill has several salespeople who are paid on commission. If a customer's assigned salesperson is not working when the customer comes in, another salesperson may assist that customer. The resulting commission would be split between the two salespeople. No sale is allowed without the customer paying at least 25% down at the time of the sale. Most customers pay the 25%, and then make 3 more equal monthly installments. Some customers pay in full at the time of the sale. Most cash receipts are from customers. Cashiers process all cash receipts and cash disbursements. Bill's Bells has several different types of cash accounts into which cash receipts are deposited.

  6. PurchaseAgent Inventory Purchase Vendor CashDisb. Cash Cashier

  7. (1,N) (0,N) (1,N) (1,1) (0,N) (0,N) (1,1) (0,1) (0,N) (0,N) (0,1) (0,N) (0,N) (1,1) (1,1) (0,N)

More Related