The following figure shows a packing list received by Frazier Stamping, Inc. When a packing slip arrives at the receiving dock with a shipment, a worker prepares a receiving report. The receiving report triggers the process for payment in accounts payable.

Required:Assume that Frazier Stamping, Inc., is preparing to computerize the manual input processes such as completing a receiving report. Use Microsoft Excel to design an appropriate format for a data entry screen that could be used at the receiving dock to enter information from the packing slip in the company?s expenditures system.

Transcribed Image Text:

Frazier Stamping Corporation Packing Slip 10493 North Oak Street Gainesville, FL Phone (625) 555-9988 Fax (625) 555-9989 Order Date: September 25, 2013 September 30, 2013 Date: 75489 Order Number: Customer Contact: Erin Smithers Purchase Order: PO549364 Customer Account: 5404 Laser, Inc. Laser, Inc. Ship To: Bill To: Attn: Accounts Payable Attn: Research Department 5242 Main Street 5242 Main Street Haverhill, FL 33422 Haverhill, FL. 33422 Unit Order Ship Quantity Backorder Part # Description Type Quantity Quantity Pulley end, 5/8"-18 splined 918-0142 Each 50 50 725-1396 Solenoid Each 80 80 725-0267 Starter switch Each 40 10