Reference no: EM13749781
The Beach Dude (BD) employs a legion of current and former surfers as salespeople who push its surfing-oriented products to various customers (usually retail outlets). This case describes BD's sales and collection process.
Each BD salesperson works with a specific group of customers throughout the year. In fact, they often surf with their customers to try out the latest surf gear. The BD salespeople act laid-back, but they work hard for their sales. Each sale often involves hours of surfing with their customers while the customers sample all the latest surf wear. Since BD makes the best surfing products, the customers look forward to the visits from the BD salespeople. And, they often buy a lot of gear.
Each sale is identified by unique invoice# and usually involves many different products. Customers pay for each sale in full within 30 days, but they can combine payments for multiple sales.
BD manages their clothing inventory by item (e.g., XL BD surfer logo t-shirts), identified by product #, but it also classifies the items by clothing line (the lines are differentiated by price points as well as the intended use of the clothing, e.g., surfing products, casual wear, etc.).
a. Draw a business process model that describes the Beach Dudes sales and collection process. Use either Powerpoint, Visio, or Word.
Your model should be similar to Figure 8.5 in the Perry and Newmark Access book (page 327). You can insert your diagram on the following page (15 points).
b. Using Microsoft Access, implement a relational database from your model.
- Identify at least 3 fields per table.
- Your database should have tables, forms and at least one query.
|
The installment method may be used for sales
: The installment method may be used for sales of all kinds of property with the exception of
|
|
General fund transactions of a revenue or transfer nature
: All revenue and inter fund transfers of the City of Fenton are accounted for on the modified accrual basis. Below is shown a list of Fenton's General Fund transactions of a revenue or transfer nature. State which ones should be recognized by the Gene..
|
|
Write an html document to create a form
: Write an HTML document to create a form with the following capabilities: A text widget to collect the user's name and Four checkboxes, one each for the following items
|
|
Predetermined rate to apply over head
: Carson company uses a predetermined rate to apply over head. At the beginning of the year, Carlson estimated its overhead costs at $320,000, direct labor hours at 45,000. and machine hours at 20,000. Actual overhead costs occurred were $274,860, actu..
|
|
Describes the beach dudes sales and collection process
: Draw a business process model that describes the Beach Dudes sales and collection process. Use either Powerpoint, Visio, or Word
|
|
Explain historical development of police agencies
: Explain Historical Development of Police Agencies and their jurisdiction.
|
|
Verification of cash-inventory and office equipment
: "The best means of verification of cash, inventory, office equipment, and nearly all other assets is a physical count of units; only a physical count gives the auditors complete assurance as to the accuracy of the amounts listed on the balance sheet"..
|
|
Compare and contrast the uml class diagram relationships
: Compare and contrast the UML class diagram relationships that can exist between classes and explain when you would use each type of relationship to model a software project
|
|
Flexible budgeting
: At the beginning of the period, the Assembly Department budgeted direct labor of $123,500 and property tax of $10,000 for 6,500 hours of production. The department actually completed 7,300 hours of production.
|