Following is a sales order form for Winter?s World of Wines, Inc. This form is prepared manually by a sales clerk and based on a telephone order from a customer. This form represents the source document that triggers the revenue process at Winter?s World of Wines.

Required:

Use Microsoft Excel to perform the following:

a. Design an appropriate format for a data entry screen that could be used in the accounting department to enter information from the sales order in the company?s revenues software program.

b. Prepare a sales journal with appropriate column headings. Enter the relevant information from the preceding sales order into your spreadsheet.

Transcribed Image Text:

Sales Order Winter's World of Wines, Inc. No. 35610 802 Ashmore Ave. Weston, CA 95718 Ship to: La Cheaux Magnique Bill to: La Cheaux Partners 412 Bridge Blvd. Bridgetown, AK 37616 8212 Hampton Place Bridgetown, AK 37615 Cust. # 42004 Preferred Shipping Method: 2-day USP Payment Terms: 30 days Date: 5/27/2013 Unit Price Extended Price Item Number Description Quantity 1046R $8.88 Merlot 12 6.99 1047R 7.99 95.88 Zinfandel 12 1049R 7.49 179.76 Cabernet Sauvignon 24 Pinot Grigio 7.49 2025W 24 179.76 Riesling 77.88 2027W 12 6.49 $617.16 Date: 5/27/13 Authorized by: H.B Clayton