Sales Report
Brewster's Used Cars, Inc. employs several salespeople. Brewster, the owner of the company, has provided a file that contains sales records for each salesperson for the past month. Each record in the file contains the following two fields:
- The salesperson's ID number, as an integer
- The amount of a sale, as a real number
The records are already sorted by salesperson ID. Brewster wants you to design a
Brewster’s Used Cars, Inc.
Sales Report
Salesperson ID | Sale Amount |
100 | $10,000.00 |
100 | $12,000.00 |
100 | $5,000.00 |
Total sales for this salesperson : $27,000.00
101 | $14,000.00 |
101 | $18,000.00 |
101 | $12,500.00 |
Total sales for this salesperson: $44,500.00
102 | $13,500.00 |
102 | $14,500.00 |
102 | $20,000.00 |
Total sales for this salesperson: $48,000.00
Total of all sales: $119,500.00
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
Additional Engineering Textbook Solutions
C Programming Language
Starting Out with Python (3rd Edition)
Artificial Intelligence: A Modern Approach
Starting Out with Java: Early Objects (6th Edition)
Problem Solving with C++ (9th Edition)
Starting out with Visual C# (4th Edition)
- C++: Matching Program Create a datafile that contains the first name, last name, gender, age, height, smoking preference, eye color and phone number. Add a variety of records to the file. A sample file looks like: Write a program that opens the file and reads the records one by one. The program will skip any records where the gender preference is not a match. Of those records that match the gender preference, check to see if the age and height are between the maximum and minum preferences. Then check to see if the smoking preference and eye color are also a match. If at least 3 of the remaining fields match, consider the record a partial match, and print it in the report. If all 4 of the remaining fields match, the record is a perfect match and print it in the report with an asterisk next to it. At the end of the program, close the file and report how many total records there were of the specified gender, how many were a partial match, and how many were a perfect match. See the…arrow_forwardThis assignment is in Python. My code is at the bottom. 12.11 LAB: Course Grade Write a program that reads the student information from a tab separated values (tsv) file. The program then creates a text file that records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student. A sample of the student information is provided in StudentInfo.tsv. Assume the number of students is at least 1 and at most 20. The program performs the following tasks: Read the file name of the tsv file from the user. Open the tsv file and read the student information. Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: A: 90 =< x B: 80 =< x < 90 C: 70 =< x < 80 D: 60 =< x < 70 F: x < 60 Compute the average of each exam. Output the last names, first names, exam scores, and letter grades…arrow_forwardISBNThis problem is slightly more difficult than the above problem. This one requires a data type that stores 10 digits. BackgroundPublishers and bookstores use a number system called the International Standard Book Number (ISBN) system to identify books. At the start of publication, each book is assigned a unique ISBN. An ISBN, once assigned, can never be re-used. Click here for detailed information on this numbering system.An ISBN consists of exactly 10 digits. The rightmost digit is the check digit. The check digit is validated modulo 11.• multiply each digit from the first to the ninth by a weight from 10 to 2 respectively (the first digit by 10, the second by 9,.., the ninth by 2).• the sum of the products plus the check digit should be divisible without remainder by 11.• if there is a remainder, the whole number is not a valid ISBN SpecificationsDesign a program that validates an ISBN. Your program keeps accepting a whole number and determining if that whole number is a valid…arrow_forward
- COBOL PROGRAMMING you will need to create your own Input file records. You must have at least 10 records in your file. You can make up your own Customer Last Name, First Initial, Car types must be one of the following TOYOTA, OLDSMOBILE, CADILLAC. You can also make up your own Miles and Days rented. Make sure to use the data lengths used in the Customer Record layout. Don't forget to format your output. Hint: You will be using several IF statements for this program. Since the Car-Type is an alphanumeric when you compare your type use quotes. For example .. IF CUST-TYPE-IN = "1" ...... keep in mind you can use double or single quotes. Also, don't forget that the first 100 miles are free regardless of car type. IF YOU USE A INPUT FILE TAKE A PICTURE OF THE INPUT FILE AND INCLUDE THE PICTURE OR INCLUDE THE INPUT FILE TEXT UNDER THE CODE OF THE PROGRAM.arrow_forward(IN THONNY/PYTHON CODE) design an application for the ABC Company that will process inventory from a file called ABC_Inventory.txt (attached to this assignment). The file contains Item ID, Description and list price stored on a separate line in the file. The program should display the contents of each record and then calculate and display the average list price. In python! ABC_INVENTORY BP25003-PERSON TENT75.0BP1000LOUNGE CHAIR50.0BP3000PROPANE HEATER149.0BP0900HIKING BOOTS120.0BP0950BACKPACK100.0BP3050GPS TRACKER130.0arrow_forwardFirst programming homework Create a class of records for a gradebook called Rec. The data should be private, and should include a firstname, lastname, array of three grades, and a field for average grade. Build two constructors: a default constructor and a constructor that takes the first and last name. Build a function to read the data, either from a file or from cin. The read function reads the two names and three grades, but does not read the average grade. Build a write function that writes the data either to a file or to cout. The write function prints all of the data on one line with spaces between fields. Build a function to calculate the average grade field. Build an overloaded operator == to compare two records. This should be implemented as a friend function. Declare the constructors and functions in the body of the class, but implement them outside the class. I will provide you with a driver called hw1.cpp in ~cthorpe/public/142 and with a test file HW1.txt in the same…arrow_forward
- In C language, write the following two functions maintaining a database of entries of type song in a file. Here is the definition of the struct song: typedef struct { char* title; char* artist; int year; } song; int add_song(const char* file_name, const song s); 1. The function gets the name of a file, and a song. If the song is not in the file, the function adds it to the file and returns 1. Otherwise, the function does not modify the file and returns 0. song* find_song(const char* file_name, const char* title); 2. The function gets the name of a file and a title of a song. It searches the file for the song with the given title. If a song is found, it returns a pointer to the song with all the details. If not found, the function returns NULL. You may assume the song titles are unique. Additional instructions and hints: 1. For the instructions on how to read and write to files see section "C Programming Files" in https://www.programiz.com/c-programming or…arrow_forwardIn C language, write the following two functions maintaining a database of entries of type song in a file. Here is the definition of the struct song: typedef struct { char* title; char* artist; int year; } song; int add_song(const char* file_name, const song s); 1. The function gets the name of a file, and a song. If the song is not in the file, the function adds it to the file and returns 1. Otherwise, the function does not modify the file and returns 0. song* find_song(const char* file_name, const char* title); 2. The function gets the name of a file and a title of a song. It searches the file for the song with the given title. If a song is found, it returns a pointer to the song with all the details. If not found, the function returns NULL. You may assume the song titles are unique. Additional instructions and hints: 1. For the instructions on how to read and write to files see section "C Programming Files" in https://www.programiz.com/c-programming or…arrow_forward(Class Average: Reading Student Records from a CSV File) Use Python Use the csv module to read the grades.csv file from the previous exercise (exercise 9.3). Display the data in tabular format, including an additional column showing each student’s average to the right of that student’s three exam grades and an additional row showing the class average on each exam below that exam’s column. This is exercise 9.3 # Importing csv moduleimport csv# empty list to store datadata = []columns = ["firstname", "lastname", "grade1", "grade2", "grade3"]filename = "grades.csv"for i in range(3):firstname = input("Enter First Name : ")lastname = input("Enter Last Name : ")grade1 = float(input("Enter Grade 1 : "))grade2 = float(input("Enter Grade 2 : "))grade3 = float(input("Enter Grade 3 : "))data.append([firstname, lastname, grade1, grade2, grade3])print()# write data and columns as csv filewith open(filename, 'w') as csvfile:# creating a csv writer objectcsvwriter = csv.writer(csvfile)# writing the…arrow_forward
- In C LANGUAGE: You will build a system to manage patients’ data in a hospital. The hospital patient management system stores specific information in the form of health record to keep track of the patients’ data.Your program should read the information from a file called “patients.txt” that should be on the following format: Patient Name#Gender#Date of admission#Date of birth #Illness#Address (City)#Blood typeExample of data input: Abed Mukhles#M#2212019#01012000#Ear Infection#Jenin#O+ Nadia A. Ali#F#01102020#05101970#COVID-19#AlBireh#A-1. You are required to implement a program to help creating the system by including the following operations of an AVL tree:• Read the file patients.txt and load the data (i.e., AVL Tree).• Insert a new patient from user with all its associated data.• Find a patient and give the user the option to update the information of the patient if found.• List all patients in lexicographic order with their associated information.• List all patients that have the…arrow_forward8.8 LAB: Course Grade In Java Please Write a program that reads the student information from a tab separated values (tsv) file. The program then creates a text file that records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student. A sample of the student information is provided in StudentInfo.tsv. Assume the number of students is at least 1 and at most 20. The program performs the following tasks: Read the file name of the tsv file from the user. Open the tsv file and read the student information. Compute the average exam score of each student. Assign a letter grade to each student based on the average exam score in the following scale: A: 90 =< x B: 80 =< x < 90 C: 70 =< x < 80 D: 60 =< x < 70 F: x < 60 Compute the average of each exam. Output the last names, first names, exam scores, and letter grades of the students into a text file named…arrow_forwardC++: You will create a header file with implementation that performs the task. Together with the header and implementation, you create a test program whose main function demonstrates that your functions work as they should. Two files, A and B which they are sorted. The files contain Numbers. Based on the files, create a third file let calles it C . that file C is going to contain all the elements in sorted order from both files A and B. This algorithm is called a merge..arrow_forward
- Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageC++ for Engineers and ScientistsComputer ScienceISBN:9781133187844Author:Bronson, Gary J.Publisher:Course Technology Ptr