Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Lasell Beverage sells energy drinks to local restaurants. The following tables illustrate some of the records from its Access data base for a quarter. Using
Lasell Beverage sells energy drinks to local restaurants. The following tables illustrate some of the records from its Access data base for a quarter. Using concepts learned from Access data bases, answer questions a-e: : Sales by Inventory Number Invoice Number Number Quantity Price Each Sales by Invoice Number Invoice . Customer Number Amount Number Salesperso Number Date V. V-1 V.2 3- NONOOM 2,000 2,000 1,575 3,000 3,500V- 1,000 600 300 4,000 3,000 5,000 5,000 7,200 C-1 10,000C -2 16,000 , C-5 10,000 C-2 16,600 : C-5 35,000C -3 23,000C -4 July 1. July 12 July 22 July 26 July 31 Aug 1 Aug 2 S-12 S-10 S-10 S-10 S-10 S-10 S-11 1 V-6 V-3 V-1 V-5 V-3 V-7 V-2 V-4 V-5 V-7 ? 5,000 7,000 Sales by Salesperson Salesperson Quarterly Commission Number Sales Rate 9-10 . ? .10 . S-11 S-12 S-78 .10 : Customer Data Customer Payments Invoice Remittance Number Advice Number Amount Customer Number Customer Name Accounts: Receivable Sales- Amount person V-1 7,200 1,666 ? V-2 V-2 V-3 V-4 V-5 R-3 R-1 R-5 R-4 R-2 R-4. 16,000 10,000 16,600 Dunn, Inc. J. P. Carpenter Mabadera Corp. Ghymn and Sons D. Lund, Inc. S-12 S-10 S-10 S-99 S-10 C-5 - ? a What was the name of the customer that made the purchase represented by invoice V-3? b What inventory items (Item Number) did the customer in a. above purchase? What are the quarterly sales amounts for each sales rep. S-10, S-11 and S-12? Rep S-10 Rep S-11 Rep S-12 d What amount of commissions will be paid to each sales reps in c. above? Rep S-10 Rep S-11 Rep S-12
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started