Following is a sales order form for Winter's World of Wines, Inc. This form is prepared manually
Question:
Following is a sales order form for Winter's World of Wines, Inc. This form is prepared manually by a sales clerk, and is 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. (The sales order is also available for download at the end of the prompt.)
Sales Order | ||||
Winter's World of Wines, Inc. | No. 35610 | |||
Bill to: | Cust. # 42004 | Ship to: | ||
Date: 5/27/2013 | Preferred Shipping Method: | |||
Item Number | Description | Quantity | Unit Price | Extended Price |
1046R | Merlot | 12 | 6.99 | $83.88 |
1047R | Zinfandel | 12 | 7.99 | 95.88 |
1049R | Cabernet Sauvignon | 24 | 7.49 | 179.76 |
2025W | Pinot Grigio | 24 | 7.49 | 179.76 |
2027W | Riesling | 12 | 6.49 | 77.88 |
$617.16 | ||||
Authorized by: H.B Clayton | Date: 5/27/13 |
Required:
Use Microsoft Excel to prepare a sales journal with appropriate column headings. Enter the relevant information from the preceding sales order into your spreadsheet.
In addition to completing the spreadsheet, write a brief paper that explains the following:
What is the purpose of a sales order form and a sales journal?
What controls are needed in the sales process?
Sales Order Form for Winter's World of Wines, Inc.
Sales Order | ||||
---|---|---|---|---|
Winter's World of Wines, Inc. | No. 35610 | |||
Bill to: | Cust. # 42004 | Ship to: | ||
Date: 5/27/2013 | Preferred Shipping Method: | |||
Item Number | Description | Quantity | Unit Price | Extended Price |
1046R | Merlot | 12 | 6.99 | $83.88 |
1047R | Zinfandel | 12 | 7.99 | 95.88 |
1049R | Cabernet Sauvignon | 24 | 7.49 | 179.76 |
2025W | Pinot Grigio | 24 | 7.49 | 179.76 |
2027W | Riesling | 12 | 6.49 | 77.88 |
$617.16 | ||||
Authorized by: H.B Clayton | Date: 5/27/13 |
Marketing Research An Applied Orientation
ISBN: 978-0136085430
6th edition
Authors: Naresh K Malhotra