# Chapter 7 - \$304.55 Customer Name Best Business Practices...

This preview shows page 1. Sign up to view the full content.

Chapter 07 - Exercise 10 ROCKFORD OFFICE SUPPLIES 4211 Beach Street Beaumont, KY 42321 Invoice No. 5487-5454 Order No. 89-10-16 Date 3/18/2002 Sales No. 21-86 Terms 3/10, n/45 Item QTY Total P-8403 Ruled Pad—8 columns 5 \$3.95 \$19.75 R-1287 Plastic Sheet Protectors 3 \$33.20 \$99.60 R-9750 Paper Cutter—legal size 2 \$52.40 \$104.80 S-6912 Paper Clips—large 8 \$3.46 \$27.68 W-3324 Wastebasket 6 \$12.95 \$77.70 D-9382 Red Pens—fine tip 3 \$3.87 \$11.61 Subtotal \$341.14 Less Returns \$47.16 \$293.98 Subtotal with Discount \$285.16 Sales Tax—6.8% \$19.39 Subtotal \$304.55 Shipping Charges \$0.00 Total Amount Due
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: \$304.55 Customer Name Best Business Practices 118 Farrel Lane Richardson, TX 75081 Directions: a. Change the Less Returns from \$52.13 to \$47.16. b. Change the Terms in Cell B8 from 2/10, n/30 to 3/10, n/45. c. Revise the formula in Cell F20 to reflect the changed Terms percent—3%. d. Delete Shipping Charges of \$57.46 from this customer's invoice. Enter \$0.00 in Cell F23. e. Format dollar entries for Currency, 2 Decimal places, and \$. Stock Number Unit Price f. Save the file as ch07ex10a.xls....
View Full Document

## This note was uploaded on 04/13/2010 for the course BUSINESS 15643 taught by Professor Schilz during the Spring '10 term at École Normale Supérieure.

Ask a homework question - tutors are online