Processing Information in a File Write a program that read a comma-delimited file of information with the following fields in each record: Part Name - the logical name for a part such as oil filter...

Processing Information in a File

Write a program that read a comma-delimited file of information with the following fields in each record:

• Part Name - the logical name for a part such as oil filter


• Part Number - unique identifier for the part, and can contain a mix of letters such PH8A


• Part Cost - the cost of the part the distributor charges such as 10.75


• Part Markup - percentage markup you have on the part such as 15.5


• Part Quantity of Hand - how many of the part you have inventory (always an integer)

(All of the data in the file is valid.)

Produce an on-screen report with the following:

1. Number of unique parts (count of the list of records).


2. Part Name and Part Number of the part with the highest retail value for an individual part.


3. Part Name and Part Number of the part with the lowest retail value for an individual part.


4. Total cost value ofallof the inventory.


5. Total retail value ofallof the inventory.