Advanced Business Spreadsheets

profileyayly 89
Fishing.xlsx
Home>Business & Finance homework help>Accounting homework help>Advanced Business Spreadsheets

Orders

Fishing Division Order Form
Customer Name:
Freight Customer Type (regular, preferred)
Ship to State abbreviation
Ship Method (truck,rail,air,boat)
Item# Description Quantity Volume (cf) $/unit Total
Total Order
Discount
Shipping
Grand Total

Item List

Item# Description Price Schedule Ship Volume (CF)
201 Proline Cast Reel 1 0.50
202 Supra Cast Reel 1 0.50
203 Ultra-Lite Spin Reel 1 0.50
204 Proline Spin Reel 1 0.50
205 Proline Underspin Reel 1 0.50
206 Proline Lite Stick Cast Rod 1 0.60
207 Cyclo Stick Cast Rod 1 0.60
208 Cyclo Stick Spinning Rod 1 0.60
209 Aberdeen Hook Set 1 0.35
210 Baitholder Hook Set 1 0.35
211 Wide Gap Treble Hook Set 1 0.35
212 Trailer Hook Set 1 0.35
213 Mono-filament line spool 1 0.45
214 Florocarbon line spool 1 0.45
215 1/4 lb Fish Line 1 0.45
216 1 lb Fish Line 1 0.50
217 Waders Paints 1 2.25
218 Soft Bait Bulk - Worms 2 0.05

Sched1

Item# $/unit
201 $ 39.99
202 $ 50.99
203 $ 99.99
204 $ 79.99
205 $ 30.95
206 $ 40.50
207 $ 48.99
208 $ 160.99
209 $ 6.50
210 $ 7.50
211 $ 4.29
212 $ 2.15
213 $ 8.00
214 $ 16.99
215 $ 6.00
216 $ 26.99
217 $ 169.95

Sched2

Unit Pricing - Soft Bait Packages
# of Packages $/unit
0 $ 1.99
100 $ 1.69
200 $ 1.39
400 $ 1.29
800 $ 1.00

Discount

Total Order Value $ 0 0 $ 3,000 $ 5,000 $ 10,000 $ 25,000
Discount 0% 2% 3% 4% 6%

Ship

Ship Table 1 - Regular Customer Orders $/CF
Region Truck Rail Air
1 $ 2.25 $ 2.20 $ 30.00
2 $ 2.50 $ 2.40 $ 32.00
3 $ 3.00 $ 2.80 $ 34.00
4 $ 3.50 $ 3.20 $ 35.00
5 $ 4.00 $ 3.50 $ 36.00
Ship Table 2 - Preferred Customer Orders $/CF
Region Truck Rail Air
1 $ 2.48 $ 2.42 $ 27.00
2 $ 2.75 $ 2.64 $ 30.00
3 $ 3.30 $ 3.08 $ 32.00
4 $ 3.85 $ 3.52 $ 33.00
5 $ 4.40 $ 3.85 $ 34.00

States

Name Abbreviation Region Region#
ALABAMA AL SE 2 Region Numbers
ALASKA AK W 5 SE 2
ARIZONA AZ SW 4 W 5
ARKANSAS AR SE 2 SW 4
CALIFORNIA CA W 5 NE 1
COLORADO CO W 5 MW 3
CONNECTICUT CT NE 1
DELAWARE DE NE 1
DISTRICT OF COLUMBIA DC NE 1
FLORIDA FL SE 2
GEORGIA GA SE 2
HAWAII HI W 5
IDAHO ID W 5
ILLINOIS IL MW 3
INDIANA IN MW 3
IOWA IA MW 3
KANSAS KS MW 3
KENTUCKY KY SE 2
LOUISIANA LA SE 2
MAINE ME NE 1
MARYLAND MD NE 1
MASSACHUSETTS MA NE 1
MICHIGAN MI MW 3
MINNESOTA MN MW 3
MISSISSIPPI MS SE 2
MISSOURI MO MW 3
MONTANA MT W 5
NEBRASKA NE MW 3
NEVADA NV W 5
NEW HAMPSHIRE NH NE 1
NEW JERSEY NJ NE 1
NEW MEXICO NM SW 4
NEW YORK NY NE 1
NORTH CAROLINA NC SE 2
NORTH DAKOTA ND MW 3
OHIO OH MW 3
OKLAHOMA OK SW 4
OREGON OR W 5
PENNSYLVANIA PA NE 1
RHODE ISLAND RI NE 1
SOUTH CAROLINA SC SE 2
SOUTH DAKOTA SD MW 3
TENNESSEE TN SE 2
TEXAS TX SW 4
UTAH UT W 5
VERMONT VT NE 1
VIRGINIA VA SE 2
WASHINGTON WA W 5
WEST VIRGINIA WV SE 2
WISCONSIN WI MW 3
WYOMING WY W 5