Durian & Co has five salespersons who sell three different types of durians. Once a day, each salesperson records for each type of the product that they have sold. Develop an application to record the information consists of the salesperson's name, the type of durian and the total number of durians has been sold that day. Day 1 Musang Udang D24 King 7 Day 2 Musang Udang Merah D24 Merah King Johari 10 8. 4 10 Ah Chong 5 10 7 8. 4 Muthu 7 3 12 6 Siti 12 8. 6. 4 8 10 Danial 20 4 7 10 The program will initialize the information for last two days' sales (see Table 1) into 2-dimensional arrays. The columns of Day 1 and Day 2 represent the type of durian, and the rows represent the salesperson. By using for loop and two-dimensional array, the program then summarize: 1) The total number of durians sold by each salesperson and by product. 2) Cross total each row to get the total sales of each durian for last 2 days. 3) Cross total each column to get the total sales by salesperson for last 2 days. 4) List salespersons that sold lowest number of durians below the average.
Durian & Co has five salespersons who sell three different types of durians. Once a day, each salesperson records for each type of the product that they have sold. Develop an application to record the information consists of the salesperson's name, the type of durian and the total number of durians has been sold that day. Day 1 Musang Udang D24 King 7 Day 2 Musang Udang Merah D24 Merah King Johari 10 8. 4 10 Ah Chong 5 10 7 8. 4 Muthu 7 3 12 6 Siti 12 8. 6. 4 8 10 Danial 20 4 7 10 The program will initialize the information for last two days' sales (see Table 1) into 2-dimensional arrays. The columns of Day 1 and Day 2 represent the type of durian, and the rows represent the salesperson. By using for loop and two-dimensional array, the program then summarize: 1) The total number of durians sold by each salesperson and by product. 2) Cross total each row to get the total sales of each durian for last 2 days. 3) Cross total each column to get the total sales by salesperson for last 2 days. 4) List salespersons that sold lowest number of durians below the average.
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 4.4CP
Related questions
Topic Video
Question
Write a C program
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage