Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need to create an rea model... Azure Corporation sells handcrafted surfboards to customers through its network of company salespeople. They sell a limited number of

Need to create an rea model...

Azure Corporation sells handcrafted surfboards to customers through its network of company salespeople. They sell a limited number of each type/design of surfboards. For each design, they have a suggested selling price. Upon employment each salesperson is immediately assigned to service a separate group of customers. In general, each customer is served by one salesperson. When customer data is initially entered into Bowerkates information system, the customer is immediately assigned to a salesperson. A salesperson may negotiate with a customer and agree on a selling price for any surfboard that is lower than that surfboards suggested selling price, especially if the customer is a high volume customer or if that surfboard is a slow seller (i.e., it has been in stock for a long time)

Each sale can include one or more surfboard and can be paid for in any of three ways: (1) immediately in cash/credit card, (2) on the 15th of the following month, or (3) over the course of six months (installments). Some customers like to make one payment for several transactions. Although the vast majority of cash receipts come from customers (any particular cash receipt would be from only one customer) for sales, some cash receipts come from other sources (e.g. bank loans).

No more than one salesperson participates in making a particular sale. Salesperson commission rate is determined per contractual arrangement with each salesperson and for a particular salesperson it is the same percentage rate no matter what items he or she sells. Every cash receipt is processed by exactly one of Bowerkates several cashiers and is deposited into one of Bowerkates bank accounts. Information about surfboards, employees, and customers often needs to be entered into the database before any transactions involving them have occurred. The following data items (attributes) are of interest to potential users of this model:

-surfboard-id-number -cash-account-balance -customer-name -cash-receipt-number -employee-name -SSN -cash-receipt-total-amount -description-of-surfboard -customer-AR-balance -sale-total-amount -sale-number -employee-number -cash-receipt-amount-applied-to-a-sale -cash-account-number -cash-account-type -salesperson-quarterly-sales$ -customer-number -suggested-selling-price-for-a-surfboard -salesperson-commission-rate -actual-selling-price-for-a-surfboard

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sawyers Internal Auditing Enhancing And Protecting Organizational Value

Authors: The Internal Audit Foundation

7th Edition

1634540522, 9781634540520

More Books

Students also viewed these Accounting questions