Question 1) Design an application for the Homestead Furniture Store that gets sales transaction data, including an account number, customer name, and purchase price. Output the account number and name, then output the customer's payment each month for the next 12 months. Assume that there is no finance charge, that the customer makes no new purchases, and that the customer pays off the balance with equal monthly payments.
b. Modify the Homestead Furniture Store application so it executes continuously for any number of customers until a sentinel value is supplied for the account number.
Question 2) Design an application for Domicile Designs that gets sales transaction data, including an account number, customer name, and purchase price. The store charges 1.25 percent interest on the balance due each month. Output the account number and name, then output the customer's projected balance each month for the next 12 months. Assume that when the balance reaches $25 or less, the customer can pay off the account. At the beginning of every month, 1.25 percent interest is added to the balance, and then the customer makes a payment equal to 7 percent of the current balance. Assume that the customer makes no new purchases.
b. Modify the Domicile Designs application so it executes continuously for any number of customers until a sentinel value is supplied for the account number.
Question 3) Yabe Online Auctions requires its sellers to post items for sale for a six-week period during which the price of any unsold item drops 12 percent each week. For example, an item that costs $10.00 during the first week costs 12 percent less, or $8.80, during the second week. During the third week, the same item is 12 percent less than $8.80, or $7.74. Design an application that allows a user to input prices until an appropriate sentinel value is entered. Program output is the price of each item during each week, one through six.
Question 4) Design the application logic for a company that wants a report containing a breakdown of payroll by department. Input includes each employee's department number, hourly salary, and number of hours worked. The output is a list of the seven departments in the company and the total gross payroll (rate times hours) for each department. The department names are shown in
Table: Department numbers and names
Department Number
|
Department Name |
| 1 |
Personnel |
| 2 |
Marketing |
| 3 |
Manufacturing |
| 4 |
Computer Services |
| 5 |
Sales |
| 6 |
Accounting |
| 7 |
Shipping |
5) Glen Ross Vacation Property Sales employs seven salespeople, as shown in Table 6-8.
| Glen Ross salespeople |
| ID Number |
Salesperson 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. The time is expressed in hours and minutes, based on a 24-hour clock. The sale amount is expressed in whole dollars. Salespeople earn a commission that differs for each sale, based on the rate schedule in Table 6-9.
Table 6-9: Glen Ross commission schedule
| Sale Amount ($) |
Commission Rate (%) |
| 0-50,999 |
4 |
| 51,000-125,999 |
5 |
| 126,000-200,999 |
6 |
| 201,000 and up |
7 |
Design an application that produces each of the following:
a. A list of each salesperson number, name, total sales, and total commissions
b. A list of 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 list of 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
Question 6) Laramie Park District has files of participants in its summer and winter programs this year. Each file is in participant ID number order and contains additional fields for first name, last name, age, and class taken (for example, Beginning Swimming).
a. Design the logic for a program that merges the files for summer and winter programs to create a list of the first and last names of all participants for the year in ID number order.
b. Modify the program so that if a participant has more than one record, the participant's ID number and name are output only once.
c. Modify the program so that if a participant has more than one record, the ID number and name are output only once along with a count of the total number of classes the participant has taken.
Question 7) The Timely Talent Temporary Help Agency maintains an employee master file that contains an employee ID number, last name, first name, address, and hourly rate for each temporary worker. The file has been sorted in employee ID number order. Each week, a transaction file is created with a job number, address, customer name, employee ID, and hours worked for every job filled by Timely Talent workers. The transaction file is also sorted in employee ID order.
a. Design the logic for a program that matches the current week's transaction file records to the master file and outputs one line for each transaction, indicating job number, employee ID number, hours worked, hourly rate, and gross pay. Assume that each temporary worker works at most one job per week. Output one line for each worker, even if the worker has completed no jobs during the current week.
b. Modify the help agency program to output lines only for workers who have completed at least one job during the current week.
c. Modify the help agency program so that any temporary worker can work any number of separate jobs during the week. Output one line for each job that week.
d. Modify the help agency program so that it accumulates the worker's total pay for all jobs in a week and outputs one line per worker.