Cross-Country

Woksheet for Cross-Country (involving 2 worksheets)

NOTE that the results should be given on the Worksheet Summary
compute as indicated in the Worksheet Summary
HINT: click on the cells in Summary to start the formula then click

Cross Country Ski Tours

March 16-18, 2003
No. of
Course Title Students Category Course Fee Total Revenue
Half Day Tour 15 Adult $ 30.00 $ 450.00
Full Day Tour 18 Adult $ 50.00 $ 900.00
Half Day Tour 15 Family $ 35.00 $ 525.00
Full Day Tour 22 Family $ 55.00 $ 1,210.00
Half Day Tour 25 Children $ 30.00 $ 750.00
Full Day Tour 15 Children $ 50.00 $ 750.00
Half Day Tour 16 Teens $ 30.00 $ 480.00
Full Day Tour 12 Teens $ 50.00 $ 600.00
Total 138 $ 5,665.00

Powder Trails Resort

 Cross-Country

y to start the formula then click on the needed cells from Cross-Country
 Cross Country Ski Tours
March 16-18, 2003

Total No. of Students Total Revenue

By Course

Half Day Tours 71 $ 2,205.00

Full Day Tours 67 $ 3,460.00

By Category

Adult 33 $ 1,350.00

Family 37 $ 1,735.00

Children 40 $ 1,500.00

Teens 28 $ 1,080.00
Woksheet for Research Report
Prepare a graph showing the costs of the providers (col H)
Choose the appropriate graph
Click a cell in the last column and you will see the formula. . . . Explain

Analysis of Vail Internet Providers $50.00

Connect Monthly No. of Add'l Hourly Cost for $45.00
ID Company Name Lines Success Rate Hours Rate 50 Hours $40.00
100 Internet Plus 50 90% $ 25 30 $ 0.50 $ 35.00 $35.00
101 Quest 100 86% $ 18 25 $ 0.25 $ 24.25 $30.00
102 Marvel Internet 75 75% $ 30 30 $ 0.50 $ 40.00 $25.00
103 Connect! 150 81% $ 35 30 $ 0.30 $ 41.00 $20.00
104 WebMasters 50 51% $ 20 40 $ 0.25 $ 22.50 $15.00
105 Ace Internet 200 85% $ 25 25 $ 0.75 $ 43.75 $10.00
106 Good Times Plus 100 63% $ 15 15 $ 1.00 $ 50.00 $5.00
107 Surf Dude 75 76% $ 10 12 $ 0.75 $ 38.50 $-
108 Web Mate 150 93% $ 35 40 $ 0.75 $ 42.50 lu
s
e st ne
t
ct
!
er e
e tP Qu t nn
109 Easy Net 40 55% $ 18 25 $ 0.40 $ 28.00
rn In Co
110 Web Spiders 250 86% $ 22 35 $ 0.30 $ 26.50 nte ve
l eb
I ar W
M

The formula montly rate + to

difference of 50 ho
 Chart Title
$50.00
$45.00
$40.00
$35.00
$30.00
$25.00
$20.00
$15.00
$10.00
$5.00
$-
lu
s
e st ne
t
ct
! rs ne
t
u s d e
at
e et rs
e te Pl N de
tP Qu ter nn as ter Du M sy i
rn
e In Co M In es rf eb Ea Sp
te ve
l e b e Ti
m Su W eb
I n ar W Ac W
M od
Go

The formula montly rate + to Add hourly rate then multiply it to the
difference of 50 hours and the number of hours
Woksheet for Music
Sort Table by instrument and Level using the Sort function

Miller Music
Where serving you is our pleasure!
Student Roster

# FirstName LastName Instrument Level Home Town Home State

3 Teri Harn Viola 1 Scottsdale AZ
11 Hope Nguyen Trumpet 1 Minneapolis MN
2 Edward Mardell Trombone 2 Phoenix AZ
7 Ginger Williams Guitar 2 Fargo ND
8 Robert Nilsson Guitar 2 Moab UT
18 Richard Standing Trumpet 2 Sheboygan WI
14 Phil Ridlin Trombone 3 Roanoke VA
16 Robert Carter Trumpet 3 New Orleans LA
17 Rowena Thorsen Clarinet 3 Lake Forest IL
1 Julie Green Flute 4 Portland OR
5 Bill Mardell Trombone 5 Sante Fe NM
10 Beatrice Sbaza Violin 5 Chicago IL
20 Thomas Reed Drums 6 Ridgewood IN
6 Lori Lippin Drums 7 Los Angeles CA
13 Mary Tsironis Violin 7 Lynchburg KY
4 Pilar Marks Trumpet 8 St. Petersburg FL
15 Connie Mardell Flute 8 Albuquerque NM
19 Leonard Vang Drums 8 Los Angeles CA
9 Warren Anderson Keyboard 9 Portland ME
12 Leigh Reed Keyboard 9 Indianapolis IN