Data Analytics Question

SQL In-class Assignment

Before we start.

  • Download and install DB Browser for SQLite
  • Download data (invoicing.cvs and receiving.cvs) from the SQL module in Canvas/Assignments.
  • Download the in-class assignment answer sheet.You will complete this and then upload it back to canvas.

Downloads – DB Browser for SQLite (

The problem:

The company usings standard costs for inventory and are billed actual costs.When inventory is received, the company makes the following:


Cr.Inventory Suspense$Standard

When the invoice is received, the following entry is made:

Dr. Inventory Suspense$Actual

Cr.Accounts Payable$Actual

At the end of every month, the Inventory Suspense account does not clear out.

  • What can cause this balance in the suspense account? (Hint: there are 3 main causes)
  • Let’s create 3 reports analyzing these problems. Below are the tables and attributes.
  • Open DB Browser, start a new database, choose folder, give it a name,
  • import csv tables (invoicing.cvs and receiving.cvs).File/Import.Make sure to click on column names in first line box
  • Write and run SQL code for the following Questions


  • What items match on PO, Item#, and what is the variance?Use SQL to create a table for matched items that calculates the variance.Add a criteria for PPV > $5. then export it
  • What inventory items did we receive but have no invoice?
  • What invoice did we receive but have not received the inventory items?

Take screenshots of the above reports and insert them into the answer sheet.You can also export the three tables CSV files.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more