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
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 |
Step by Step Solution
3.54 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
The Sales Journal is as follows b Sales Order form i...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 2 attachments)
635d9dad250d2_177320.pdf
180 KBs PDF File
635d9dad250d2_177320.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started