Google: Fusion Tables - Toys

WORK IN PROGRESS

Import the Toys data file

Download the file (DB 4 Toys Import File - Data.csv) attached to this page.

The file looks like:

Supplier,Buyer,Description,Order Qty,On Hand,Cost,Brand,Order Date

Fun Factory,A. Hayes,Model Cessna,50,7,$8.99,Flying Fun,"July 2, 2014"

Fun Factory,A. Hayes,Model Satellite,65,12,$5.50,Flying Fun,"June 5, 2014"

Fun Factory,A. Hayes,Fortran Learner,50,32,$3.99,Computer Fun,"July 3, 2014"

Create a new Fusion Table by importing the .csv file from your computer.

Add Calculated Fields

After you have imported the data into the database program, add the required calculated fields:

- value of inventory on hand
  - On Hand * Cost
- Qty to Order
  - if('On Hand' < 10, 'Order Qty',0)

Perform Queries

All A. Hayes purchases in July
All toys with a quantity on hand of over 30 and a unit cost of less than $5.00
All toys purchased from Toy Barn with a unit price between $4.99 and $16.00
All toys not purchased by J. Mathers or not supplied by Toy Barn or over $8.00

Create a report that shows the value of inventory on hand by supplier and Brand, include a subtotal for each supplier, each Brand and an overall total.