Bowden Building Supplies Bowden Building Supplies sells building supplies in San Antonio. They offer free deliver) of

Fantastic news! We've Found the answer you've been seeking!

Question:

Bowden Building Supplies Bowden Building Supplies sells building supplies in San Antonio. They offer free deliver) of goods within the city. Bowden uses the following system for recording credit sales to builders.

A builder gives an order to a salesclerk. The salescleik completes a prenumbered delivery slip for the sales order. Two copies of the delivery slip are sent to the warehouse, and one copy is sent to the Billing Department. A warehouse employee uses the delivery slip to pick the goods. The employee gives the goods and the two delivery slips to a driver. The driver delivers the goods to the customer.

The customer signs the delivery slip. The customer keeps one copy and gives the other copy back to the driver. The signed delivery slip is forwarded to tin Billing Department each evening.

The following morning, the billing clerk checks to see that the sequence of prenumbered documents is complete. She calculates the dollar total of the sales using an adding machine. She then enters the information from the delivery slips into the computer. The computer records the sale and updates the customer’s balance and inventory. The computer prints a list of sales, the total number of delivery slips entered, and the total dollar amount of sales. The clerk checks the adding machine totals with the totals generated by the computer. She also verifies that the number of delivery slips entered equals the number of prenumbered slips. The computer prints three copies of customer invoices. The first copy is mailed to the customer, the second is filed by Billing, and the third is forwarded to Accounts Receivable.

Required:

1. Identify the master files in the Bowden Building Supplies’ AIS.

2. For each master file identified in Requirement 1.
a. Give examples of reference data that would the stored in the master file.

b. Give examples of summary data (if any) that would be stored in the master file.

3. Identify one transaction file needed for Bowden’s AIS. Briefly discuss the data that will be stored in this transaction file.