A company has 4 salespeople (1 to 4) who sell 5 different products (1 to 5). Every day the company maintains a CSV file for each product sold.

computer science

Description

CS265: Advanced Programming 

 

What to do

  • This assignment is called “Count the Daily Product Sales”
  • You must develop everything on the Drexel cs.tux.drexel.edu servers.

 

Requirements

 

Write a C program, named a2.c, to solve the following problem.

 

A company has 4 salespeople (1 to 4) who sell 5 different products (1 to 5). Every day the company maintains a CSV file for each product sold. A CSV file is a comma-separated values file. The CSV file contains the product, and the total dollar value of that product sold by each salesperson that day. An example CSV file has been provided with the assignment.

 

Write a program that will read all this information for a day’s sales and summarize the total sales by salesperson and by product. After processing all the information for the day, display the results in a tabular format, with each column representing a salesperson and each row representing a particular product. Gross total each row to get the total sales of each product. Gross total each column to get the total sales by salesperson. Your output should include these cross-totals to the right of the totaled rows and to the bottom of the totaled columns.

 

For the sample data provided with the assignment the output could look like this

 

             Seller1      Seller2      Seller3      Seller4    Total

Product1         915         777         886         383        2961

Product2         492         386         335         793        2006

Product3          27         362         421         649        1459

Product4         926         763          59         690        2438

Product5         736         172         426         540        1874

Total           3096        2460        2127        3055           0

 

Tips

 

·         You may assume that each line in the CSV file is not larger than a number of your choice, say no larger than 256.

·         You may assume that there are no spaces or other special characters in the names of the salespeople or products.

·         You may assume that the names of salespeople and products are not larger than a number of your choice, say no larger than 20.

·         You can use character arrays. You do not need to dynamically allocate memory for this assignment.

 

What to submit

Submit the C program a2.c in Blackboard. 

Instruction Files
A22.docx
20.9 KB
sales.csv
167.0 Bytes

Related Questions in computer science category