Answer in Java

CPS 180 - Lab Assignment #8

File I/O Write Text File/Read Text File

Assigned: 6/7/17 Due: 6/14/17 Points: 40

Part 1: Create a program that creates a text file from user input with the following data, which is a list of tools, prices and quantities. There should be 3 columns of data, including 1 String for toolName, 1 double for toolPrice, and 1 int for toolQty.

Hammer	15.00	5
Drill	49.99	3
Screwdriver	3.00	6
Wrench	6.25	4
Pliers	4.00	2
Ratchet	12.50	1
Chisel	8.50	7
Prybar	7.25	4
Saw	14.50	6
Sander	27.99	2

Part 2: Create a program which reads the data file created in Part 1, and displays it as a table report with headings and a 4^th calculated column.

Item	Price	Qty	Ext Price
Hammer	15.00	5	75
Drill	49.99	3	149.97
Screwdriver	3.00	6	18
Wrench	6.25	4	25
Pliers	4.00	2	8
Ratchet	12.50	1	12.5
Chisel	8.50	7	59.5
Prybar	7.25	4	29
Saw	14.50	6	87
Sander	27.99	2	55.98

Also, after the table is printed, include a sum of the Ext. Price at the end, an average of the Price column, and a count of the Qy of items. Sample output:

Total of Ext Price: $999.99

Average Single Item Price: $99.99

Count of all items Qty: 99