excel oct 2004

1
Information Table Make-up 5% 10% Number of items Treadmills 7 Date Equipment Type Purchase pric Make-up price Retail Price June 24 2004 Treadmill Programmable $ 999.00 49.95 1048.95 June 30 2004 Treadmill Pulse controlled $ 2,250.00 112.5 2362.5 July 6 2004 Exercise bike Fitness $ 350.00 35 385 July 15 2004 Treadmill Manual $ 495.00 49.5 544.5 July 19 2004 Treadmill Programmable $ 1,870.00 93.5 1963.5 July 20 2004 Exercise bike Racumbent $ 570.00 28.5 598.5 July 26 2004 Treadmill Electronic Foldaway $ 2,485.00 124.25 2609.25 August 2 2004 Exercise bike Magnetic $ 749.00 37.45 786.45 August 2 2004 Treadmill Electronic Foldaway $ 729.00 36.45 765.45 August 7 2004 Treadmill Programmable $ 3,195.00 159.75 3354.75 August 17 2004 Exercise bike Swing folding $ 599.00 29.95 628.95 August 22 2004 Exercise bike Magnetic $ 279.00 27.9 306.9

Upload: anny

Post on 07-Dec-2015

212 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Excel Oct 2004

Information TableMake-up 5% 10%

Number of items Treadmills 7

Date Equipment Type Purchase price Make-up price Retail Price June 24 2004 Treadmill Programmable $ 999.00 49.95 1048.95June 30 2004 Treadmill Pulse controlled $ 2,250.00 112.5 $ 2,362.50 July 6 2004 Exercise bike Fitness $ 350.00 35 $ 385.00 July 15 2004 Treadmill Manual $ 495.00 49.5 $ 544.50 July 19 2004 Treadmill Programmable $ 1,870.00 93.5 $ 1,963.50 July 20 2004 Exercise bike Racumbent $ 570.00 28.5 $ 598.50 July 26 2004 Treadmill Electronic Foldaway $ 2,485.00 124.25 $ 2,609.25 August 2 2004 Exercise bike Magnetic $ 749.00 37.45 $ 786.45 August 2 2004 Treadmill Electronic Foldaway $ 729.00 36.45 $ 765.45 August 7 2004 Treadmill Programmable $ 3,195.00 159.75 $ 3,354.75 August 17 2004 Exercise bike Swing folding $ 599.00 29.95 $ 628.95 August 22 2004 Exercise bike Magnetic $ 279.00 27.9 $ 306.90