|
|
Intermediate
Spreadsheet Concepts Exercise 5 Model Answer
The following
spreadsheet is an example of how your spreadsheet should look, you can
feel free to try different colour combinations.
|
Mike's
Mail Order Company
|
|
Item
|
Price
|
Delivery
Charge
|
Delivered
Cost
|
Ordered
This Month
|
Monthly
Item Income
|
Monthly
Delivery Income
|
Total
Monthly Income
|
|
Bath
Towels
|
$6.95
|
$5.00
|
$11.95
|
319
|
$2,217.05
|
$1,595.00
|
$3,812.05
|
|
Bathroom
Radio
|
$24.95
|
$8.00
|
$32.95
|
150
|
$3,742.50
|
$1,200.00
|
$4,942.50
|
|
Bathroom
Scales
|
$99.95
|
$10.00
|
$109.95
|
63
|
$6,296.85
|
$630.00
|
$6,926.85
|
|
BBQ
|
$199.95
|
$20.00
|
$219.95
|
38
|
$7,598.10
|
$760.00
|
$8,358.10
|
|
Beach
Towels
|
$9.95
|
$5.00
|
$14.95
|
412
|
$4,099.40
|
$2,060.00
|
$6,159.40
|
|
Board
Games
|
$39.95
|
$8.00
|
$47.95
|
95
|
$3,795.25
|
$760.00
|
$4,555.25
|
|
Book
Ends
|
$29.95
|
$10.00
|
$39.95
|
241
|
$7,217.95
|
$2,410.00
|
$9,627.95
|
|
Book
Shelf
|
$49.95
|
$15.00
|
$64.95
|
168
|
$8,391.60
|
$2,520.00
|
$10,911.60
|
|
Camera
|
$69.95
|
$10.00
|
$79.95
|
112
|
$7,834.40
|
$1,120.00
|
$8,954.40
|
|
Card
Games
|
$14.95
|
$5.00
|
$19.95
|
243
|
$3,632.85
|
$1,215.00
|
$4,847.85
|
|
Carving
Fork
|
$17.95
|
$5.00
|
$22.95
|
177
|
$3,177.15
|
$885.00
|
$4,062.15
|
|
Clothes
Hanger
|
$4.95
|
$5.00
|
$9.95
|
588
|
$2,910.60
|
$2,940.00
|
$5,850.60
|
|
Computer
Games
|
$89.95
|
$5.00
|
$94.95
|
126
|
$11,333.70
|
$630.00
|
$11,963.70
|
|
Cooking
Timer
|
$21.95
|
$5.00
|
$26.95
|
169
|
$3,709.55
|
$845.00
|
$4,554.55
|
|
Cordless
Telephone
|
$119.95
|
$10.00
|
$129.95
|
87
|
$10,435.65
|
$870.00
|
$11,305.65
|
|
Curtain
Rails
|
$129.95
|
$10.00
|
$139.95
|
94
|
$12,215.30
|
$940.00
|
$13,155.30
|
|
Curtains
|
$124.95
|
$8.00
|
$132.95
|
317
|
$39,609.15
|
$2,536.00
|
$42,145.15
|
|
Digital
Camera
|
$999.95
|
$10.00
|
$1,009.95
|
349
|
$348,982.55
|
$3,490.00
|
$352,472.55
|
|
Digital
Clock
|
$99.95
|
$10.00
|
$109.95
|
476
|
$47,576.20
|
$4,760.00
|
$52,336.20
|
|
Double
Sheets
|
$49.95
|
$5.00
|
$54.95
|
355
|
$17,732.25
|
$1,775.00
|
$19,507.25
|
|
Electric
Blender
|
$299.95
|
$20.00
|
$319.95
|
122
|
$36,593.90
|
$2,440.00
|
$39,033.90
|
|
Electric
Knife
|
$149.95
|
$10.00
|
$159.95
|
52
|
$7,797.40
|
$520.00
|
$8,317.40
|
|
Electric
Mixer
|
$399.95
|
$20.00
|
$419.95
|
12
|
$4,799.40
|
$240.00
|
$5,039.40
|
|
Fan
Cooker
|
$199.95
|
$20.00
|
$219.95
|
49
|
$9,797.55
|
$980.00
|
$10,777.55
|
|
Fire
Extinguishers
|
$249.95
|
$20.00
|
$269.95
|
79
|
$19,746.05
|
$1,580.00
|
$21,326.05
|
|
Hand
Towels
|
$7.95
|
$5.00
|
$12.95
|
513
|
$4,078.35
|
$2,565.00
|
$6,643.35
|
|
King
Sheets
|
$69.95
|
$5.00
|
$74.95
|
299
|
$20,915.05
|
$1,495.00
|
$22,410.05
|
|
Kitchen
Scales
|
$89.95
|
$15.00
|
$104.95
|
83
|
$7,465.85
|
$1,245.00
|
$8,710.85
|
|
Kitchen
Utensils
|
$29.95
|
$10.00
|
$39.95
|
197
|
$5,900.15
|
$1,970.00
|
$7,870.15
|
|
Microwave
Oven
|
$799.95
|
$20.00
|
$819.95
|
42
|
$33,597.90
|
$840.00
|
$34,437.90
|
|
Model
Boat
|
$59.95
|
$10.00
|
$69.95
|
179
|
$10,731.05
|
$1,790.00
|
$12,521.05
|
|
Model
Plane
|
$99.95
|
$10.00
|
$109.95
|
134
|
$13,393.30
|
$1,340.00
|
$14,733.30
|
|
Model
Yacht
|
$64.95
|
$10.00
|
$74.95
|
187
|
$12,145.65
|
$1,870.00
|
$14,015.65
|
|
Night
Light
|
$29.95
|
$8.00
|
$37.95
|
262
|
$7,846.90
|
$2,096.00
|
$9,942.90
|
|
Pillow
Slips
|
$7.95
|
$5.00
|
$12.95
|
578
|
$4,595.10
|
$2,890.00
|
$7,485.10
|
|
Pillows
|
$19.95
|
$10.00
|
$29.95
|
345
|
$6,882.75
|
$3,450.00
|
$10,332.75
|
|
Plant
Pots
|
$9.95
|
$5.00
|
$14.95
|
899
|
$8,945.05
|
$4,495.00
|
$13,440.05
|
|
Queen
Sheets
|
$59.95
|
$5.00
|
$64.95
|
444
|
$26,617.80
|
$2,220.00
|
$28,837.80
|
|
Rotary
Oven
|
$249.95
|
$20.00
|
$269.95
|
68
|
$16,996.60
|
$1,360.00
|
$18,356.60
|
|
Security
Lights
|
$64.95
|
$10.00
|
$74.95
|
81
|
$5,260.95
|
$810.00
|
$6,070.95
|
|
Serving
Spoon
|
$9.95
|
$5.00
|
$14.95
|
164
|
$1,631.80
|
$820.00
|
$2,451.80
|
|
Single
Sheets
|
$29.95
|
$5.00
|
$34.95
|
475
|
$14,226.25
|
$2,375.00
|
$16,601.25
|
|
Smoke
Detectors
|
$19.95
|
$5.00
|
$24.95
|
687
|
$13,705.65
|
$3,435.00
|
$17,140.65
|
|
Stop
Watch
|
$34.95
|
$5.00
|
$39.95
|
265
|
$9,261.75
|
$1,325.00
|
$10,586.75
|
|
Tea
Towels
|
$18.95
|
$5.00
|
$23.95
|
947
|
$17,945.65
|
$4,735.00
|
$22,680.65
|
|
Tennis
Balls
|
$8.95
|
$5.00
|
$13.95
|
1,421
|
$12,717.95
|
$7,105.00
|
$19,822.95
|
|
Wall
Clock
|
$49.95
|
$10.00
|
$59.95
|
186
|
$9,290.70
|
$1,860.00
|
$11,150.70
|
|
Wine
Opener
|
$29.95
|
$5.00
|
$34.95
|
197
|
$5,900.15
|
$985.00
|
$6,885.15
|
|
Wine
Racks
|
$79.95
|
$20.00
|
$99.95
|
59
|
$4,717.05
|
$1,180.00
|
$5,897.05
|
|
Fruit
Bowl
|
$29.95
|
$5.00
|
$34.95
|
799
|
$23,930.05
|
$3,995.00
|
$27,925.05
|
|
Carving
Knife
|
$19.95
|
$5.00
|
$24.95
|
1,254
|
$25,017.30
|
$6,270.00
|
$31,287.30
|
|
Tooth
Picks
|
$3.95
|
$5.00
|
$8.95
|
2,233
|
$8,820.35
|
$11,165.00
|
$19,985.35
|
|
Screwdriver
Set
|
$19.95
|
$5.00
|
$24.95
|
588
|
$11,730.60
|
$2,940.00
|
$14,670.60
|
|
Drill
Set (10 Piece)
|
$24.95
|
$5.00
|
$29.95
|
472
|
$11,776.40
|
$2,360.00
|
$14,136.40
|
|
Electric
Tooth Brush
|
$23.95
|
$5.00
|
$28.95
|
991
|
$23,734.45
|
$4,955.00
|
$28,689.45
|
|
Coffee
Cup Set
|
$14.95
|
$10.00
|
$24.95
|
631
|
$9,433.45
|
$6,310.00
|
$15,743.45
|
|
Tea
Set
|
$39.95
|
$10.00
|
$49.95
|
481
|
$19,215.95
|
$4,810.00
|
$24,025.95
|
|
Lipstick
Selection
|
$21.95
|
$5.00
|
$26.95
|
999
|
$21,928.05
|
$4,995.00
|
$26,923.05
|
|
Quick
Burner
|
$19.95
|
$5.00
|
$24.95
|
1,087
|
$21,685.65
|
$5,435.00
|
$27,120.65
|
|
BBQ
Lighters
|
$9.95
|
$5.00
|
$14.95
|
2,378
|
$23,661.10
|
$11,890.00
|
$35,551.10
|
|
Cup
Hooks
|
$2.95
|
$5.00
|
$7.95
|
2,594
|
$7,652.30
|
$12,970.00
|
$20,622.30
|
|
Table
Tennis Bats
|
$10.95
|
$5.00
|
$15.95
|
276
|
$3,022.20
|
$1,380.00
|
$4,402.20
|
|
Table
Tennis Balls
|
$1.95
|
$5.00
|
$6.95
|
552
|
$1,076.40
|
$2,760.00
|
$3,836.40
|
|
Table
Mats
|
$12.95
|
$10.00
|
$22.95
|
773
|
$10,010.35
|
$7,730.00
|
$17,740.35
|
|
Chopping
Board
|
$14.95
|
$15.00
|
$29.95
|
182
|
$2,720.90
|
$2,730.00
|
$5,450.90
|
|
House
Alarm System
|
$199.95
|
$20.00
|
$219.95
|
95
|
$18,995.25
|
$1,900.00
|
$20,895.25
|
|
Massage
Pillow
|
$49.95
|
$10.00
|
$59.95
|
423
|
$21,128.85
|
$4,230.00
|
$25,358.85
|
|
Christmas
Tree Lights
|
$29.95
|
$10.00
|
$39.95
|
432
|
$12,938.40
|
$4,320.00
|
$17,258.40
|
|
Christmas
Decorations
|
$24.95
|
$10.00
|
$34.95
|
587
|
$14,645.65
|
$5,870.00
|
$20,515.65
|
|
Dinner
Set
|
$38.95
|
$20.00
|
$58.95
|
333
|
$12,970.35
|
$6,660.00
|
$19,630.35
|
|
Potato
Masher
|
$9.95
|
$5.00
|
$14.95
|
199
|
$1,980.05
|
$995.00
|
$2,975.05
|
|
Potato
Peeler
|
$7.95
|
$5.00
|
$12.95
|
156
|
$1,240.20
|
$780.00
|
$2,020.20
|
|
Potato
Eye Remover
|
$5.95
|
$5.00
|
$10.95
|
123
|
$731.85
|
$615.00
|
$1,346.85
|
|
Apple
Core Remover
|
$5.95
|
$5.00
|
$10.95
|
138
|
$821.10
|
$690.00
|
$1,511.10
|
|
Electric
Toaster
|
$99.95
|
$15.00
|
$114.95
|
185
|
$18,490.75
|
$2,775.00
|
$21,265.75
|
|
Camping
Oven
|
$149.95
|
$20.00
|
$169.95
|
50
|
$7,497.50
|
$1,000.00
|
$8,497.50
|
|
Tent
(2 person)
|
$189.95
|
$20.00
|
$209.95
|
42
|
$7,977.90
|
$840.00
|
$8,817.90
|
|
Tent
(4 person)
|
$249.95
|
$20.00
|
$269.95
|
68
|
$16,996.60
|
$1,360.00
|
$18,356.60
|
|
|
|
|
|
|
|
|
|
|
Totals
|
$6,790.10
|
$742.00
|
$7,532.10
|
$32,726.00
|
$1,267,841.70
|
$218,687.00
|
$1,486,528.70
|
The following spreadsheet shows the formula's you need to complete
the spreadsheet.
 |
Download the Mikes Mail Order Company.zip
file. You need a Zip program like WinZip to extract the
Excel file from the Zip file. See our Links
Page for a link to the WinZip web site. |
Click the BACK
button on your browser, to return to the previous page. 
|
