Medium question 1
Read the following description regarding the business data and its processing, and answer questions Q89 through Q92.
Ms. F is hired by a cosmetic company which is running a membership-based mail-order cosmetics business. She works in the sales department and analyzes sales performance data under a senior staff. Each product has a unique name without duplication and is classified into an appropriate category. For data analysis, the sales performance data for the past year and the membership ledger are as follows:
[ Sales Performance Data ]
Sales _ date |
Member _ number |
Product _ name |
Category |
Unit price |
Quantity |
Sales _ amount |
20071006 |
123001 |
Emulsion A |
Basic skin care |
3,000 |
1 |
3,000 |
20071007 |
100302 |
Rouge C |
Lipstick |
2,000 |
2 |
4,000 |
20071008 |
110210 |
Lotion B |
Basic skin care |
1,500 |
1 |
1,500 |
[ Member Ledger ]
Member _ number |
Member _ name |
Address _ 1 |
Address _ 2 |
Telephone _ number |
100001 |
Susan |
New York |
500 Washington |
914-XXX-XXXX |
|
Johnson |
|
Ave., Kingston |
|
100002 |
Anna Smith |
Florida |
2200 Yamato Road, |
561-XXX-XXXX |
|
|
|
Boca Raton |
|
100003 |
Helen Brown |
North Carolina |
4100 Capital Blvd., Raleigh |
919-XXX-XXXX |
Note: Address _ 1 indicates the State part of each member’ s address information and Address _ 2, the remaining part of the address information.
Practice exam 1
Q89.
Technology
Ms. F is to summarize monthly sales performance in a table, by product. To compute the monthly sales performance by product, which of the following combinations of the sales performance data is required at a bare minimum?
Answer group: a) Product _ name and Sales _ amount b) Sales _ date, Product _ name, and Sales _ amount c) Sales _ date, Product _ name, Category, and Sales _ amount d) Sales _ date, Product _ name, Category, Unit _ price, and Sales _ amount
332