Q 1: Perform Verify and Count Commands for all three tables and identify any exceptions.
Verify Tests: 0 data validity errors detected in Jaysberg_Auth_Prices, Jaysberg_Sales_Returns, and Jaysberg_Sales_Trans, and the counts were respectively: 101, 55, and 383.
Count Command:
Q 2: Test the accuracy of the monthly postings to the general ledger. Note that the table includes a month code. Monthly sales per the general ledger are provided below:
I compared the monthly postings to the general ledger, and the general ledger amounts and found there were no errors. The accuracy of the monthly postings is satisfactory.
Q 3: Perform the following tests of controls. For each control state the command or commands that you did to test the
…show more content…
Commands: I did a count command on the Shipping document number column, and the sales invoice number column, and both columns contained 383 records. I also visually skimmed the columns to make sure there were no blank cells. I then performed a duplicates command on both columns to make sure there were no duplicates, and each sales invoice had a unique shipping document number.
Results: I have determined there is a shipping document number for each sales invoice number.
b. Determine the two product numbers with the largest total dollar sales for subsequent follow-up to verify the selling prices and quantities shipped.
Commands: I first used the classify command. I used the Product number as the “classify on option”, and the total selling price in the subtotal field. Then, I clicked the File button so I could sort the results by descending order for total selling price. I used the Total command to find the total price of the unit selling price*units shipped, and then compared that with the total selling price. They weren’t the same, so I found the difference.
Results: The two product numbers with the largest unit selling prices were 726, and 988. The unit selling price*units is $7,133.98 higher than the total selling price. We need to do further investigation.
c. Determine the two product numbers with the largest unit selling prices for subsequent follow-up to verify the unit selling prices.
Commands: In the
There are several red flags in the invoices. There are several invoice numbers that are repeated and have an A at the end of the repeated invoice.
I have invoice 2802375 and 2824138 both have item number 100241 (single use aux water jet) that were shipped to Emory Healthcare, however, the invoice states that Medivators shipped the items as EACH instead of a BOX of 50. Meanwhile, I called Medivators customer services and they told me that the items were shipped by the BOX. Therefore, I will need a current invoice that declares the correct unit of measure that was shipped to
2. On the basis of the response to Question 1, discuss the revenue recognition accounting literature
Mark off each invoice on the query against the invoices listed on the inventory (I would make a copy that you can mark off on so that you still have a clean copy to turn in).
| |Check sales invoices against the sales journal to confirm they have been recorded on the|
B: As a certified accountant I only lead my customers to success I would advise Marcia in order to reach her goals of profit and beyond to try to get a better understanding of her suppliers. She should shop around for a cheaper supplier since a big
Need to implement a system in which all reconciled invoices from NetChef can make it to the P&L in time for MOR reporting.
Make sure that the shipping papers and invoices identify the serial numbers of the products being shipped.
b. Why will you fail to sell 4 units (even though average utility > price)?
1. (10 pts). What is the best-selling product, based on the number of orders that contain one or more orders of that product?
c) For every additional dollar spent on advertising we can expect sales to increase by an average of 0.1227 dollars
In the shipping department all bills of lading are pre-numbered and compared to the invoice.
Sales will be high because the company has the licensing and it will help to trust products and services which they provided. Last year the sales were $1.5 million of the whole sales.
An invoice is an important business document that a business sends to a client denoting an obligation to pay a stipulated sum for goods and services provided. The tool is highly useful in tracking transactions and expenses, checking inventory and aiding the release of monthly or periodical financial reports. The authenticity and legality of the invoice also means it can be used in the court of law to argue cases involving unpaid debts and for establishing the legitimacy of a debt. The bill is popular with vendors, suppliers, salespeople and various businesses. The invoice contains several fields needed to complete a transaction, these include: