Question: Quick Jolt Electronics manufactures and sells specialized electronic components to customers across the country. The tables in Figure 14-19 illustrate some of the records in

Quick Jolt Electronics manufactures and sells specialized electronic components to customers across the country. The tables in Figure 14-19 illustrate some of the records in its accounting databases. Thus, for example, the Sales by Inventory Number records show detailed sales data for each of the companys inventory items, and the Customer Payments records indicate customer cash payments, listed by invoice number. Use the information in these tables to answer the following questions.

Item Number Invoice Number Quantity Price Each
I-1 V-1 1 2,000
V-3 1 2,000
V-6 3 1,575
I-2 V-5 2 3,000
V-6 10 3,500
I-3 V-3 6 1,000
I-4 V-1 2 600
V-5 2 300
I-5 V-3 2 4,000
V-7 3 3,000
I-6 V-2 2 5,000
V-4 2 5,000
V-5 2 5,000
V-7 2 7,000
Invoice Number Remittance Advice Number Amount
V-1 R-3 7,200
V-2 R-1 1,666
V-2 R-5 1,666
V-3 R-4 16,000
V-4 R-2 10,000
V-5 R-4 16,600
Invoice Number Amount Customer Number Date Salesperson Number
V-1 7,200 C-1 July 1 S-12
V-2 10,000 C-2 July 12 S-10
V-3 16,000 C-5 July 22 S-10
V-4 10,000 C-2 July 26 S-10
V-5 16,600 C-5 July 31 S-10
V-6 35,000 C-3 August 1 S-10
V-7 23,000 C-4 August 2 S-11
Salesperson Number Quarterly Sales Commission Rate
S-10 ? 0.10
S-11 ? 0.10
S-12 ? 0.12
S-78 0 0.08
Customer Number Customer Name AccountsReceivable Amount Sales-person
C-1 Dunn, Inc. ? S-12
C-2 J. P. Carpenter ? S-10
C-3 Mabadera Corp. ? S-10
C-4 Ghymn and Sons ? S-99
C-5 D. Lund, Inc. ? S-10

FIGURE 14-19 Sample of some of the records in the Quick Jolt accounting database.

Requirements

  1. In the Sales by Invoice Number, what is the total amount of sales on invoice V-2? What was the name of the customer that made this purchase? What specific inventory items did this customer purchase? How much did this customer pay for each item?
  2. Customers can choose among one of three payment options: (1) 5% discount if immediate cash payment, (2) 2% discount off list amount if total invoice paid by the 15th day of the month following purchase, or (3) deferred payment plan, using 6 monthly payments. Which option does J. P. Carpenter appear to be using for invoice V-2?
  3. Using just the information provided, what are the quarterly sales amounts for salespeople S-10, S-11, and S-12?
  4. Assume that customers C-1 through C-5 began this quarter with net accounts-receivable balances of zero. What are their balances now?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!