Glen Ross Vacation Property Sales employs seven salespeople as follows:

Salespeople
ID NUMBER	NAME
103	Darwin
104	Kratz
201	Shulstad
319	Fortune
367	Wickert
388	Miller
435	Vick

When a salesperson makes a sale, a record is created including the date, time, and dollar amount of the sale, as follows: The time is expressed in hours and minutes, based on a 24-hour clock. The sale amount is expressed in whole dollars.

SALE FIELD DESCRIPTION
File name: SALES
FIELD DESCRIPTION	DATA TYPE	EXAMPLE
Salesperson	Numeric	319
Month	Numeric	02
Day	Numeric	21
Year	Numeric	2008
Time	Numeric	1315
Sale Amount	Numeric	95900

Salespeople earn a commission that differs for each sale, based on the following rate schedule:

Commission Rates

SALE AMOUNT	RATE
$0–$50,000	.04
$50,001–$125,000	.05
$125,001–$200,000	.06
$200,001 and up	.07

Design the output and either the flowchart or pseudocode that produces each of the following reports:

a. A report listing each salesperson number, name, total sales, and total commissions

b. A report listing each month of the year as both a number and a word (for example, “01 January”), and the total sales for the month for all salespeople

c. A report listing total sales as well as total commissions earned by all salespeople for each of the following time frames, based on hour of the day: 00–05, 06–12, 13–18, and 19–23