Excel assignment

profilellmurbayz
sauce.xlsx
Home>Computer Science homework help>Excel assignment

Documentation

The Sauce Shoppe
Author
Date
Purpose To provide an order form worksheet to record orders to the Sauce Shoppe

Order Form

The Sauce Shoppe
Order Form
Customer
Order No.
Shipping Address
Address 1
Address 2
City
State
ZIP
Phone
Billing Address
Address 1
Address 2
City
State
ZIP
Phone
Date of Order Credit Card Security Code
Delivery Card Number
Workdays to Deliver Exp. Date
Est. Delivery Date Name
Product ID NAME PRICE QTY CHARGE
Subtotal
Sales Tax @ 3%
Shipping & Handling
TOTAL

Copy Shipping Address --->

Delivery Calculator

The Sauce Shoppe
Delivery Calculator
Merchandise Subtotal Shipping Fee
$0 $5.95
$25 $7.95
$50 $9.95
$75 $11.95
$100 $13.95
$125 $0.00
Delivery Type Surcharge Est. Delivery Days
Standard $0.00 5
3 Day $9.95 3
2 Day $12.95 2
Overnight $19.95 1
Delivery Holidays
1/1/13
1/21/13
5/27/13
7/4/13
9/2/13
11/28/13
12/25/13
1/1/14
1/20/14
5/26/14
7/4/14
9/1/14
11/27/14
12/25/14
1/1/15
1/19/15
5/25/15
7/4/15
9/7/15
11/26/15
12/25/15
1/1/16
1/18/16
5/30/16
7/4/16
9/5/16
11/24/16
12/25/16
1/1/17
1/16/17
5/29/17
7/4/17
9/4/17
11/23/17
12/25/17
1/1/18
1/15/18
5/28/18
7/4/18
9/3/18
11/22/18
12/25/18
1/1/19
1/21/19
5/27/19
7/4/19
9/2/19
11/28/19
12/25/19
1/1/20
1/20/20
5/25/20
7/4/20
9/7/20
11/26/20
12/25/20

Product List

The Sauce Shoppe
Product List