> &% \pSoverenity Enterprises Inc. Ba==-[,8X@"1SArial1SArial1SArial1SArial1SArial1SArial1SArial1
SArial1SArial1SArial1SArial1@SArial1SArial1$SArial1
SArial15SArial1SArial1SArial1SArial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"$"#,##0.00"Yes";"Yes";"No""True";"True";"False""On";"On";"Off" + ) , *
# # # # # " " " " " " "
# " " # " " " " &" " " " ! !
! # `Sheet1'Sheet2(Sheet3"R+&Evening (no dogs)One day (no dogs)Full weekend (no dogs)Total fees for teachingf
To use this calculator, please insert the variables you know of. Green numbers are free input
parameters for you to chaneg as you want. Insert whichever values you decide in those fields,
and the calculations are done for you. Red number are minimum values which you should adjust
if you know of reasons to do so, but it will not be accepted that you use lower values than those
already inserted.
Start with the number of students you expect, and count noses. Dogs have noses too. Insert
the estimated number in the row that represents your planned activity. Make sure that the
numbers of students in all other activities are set at 0.
Then insert the number of days and nights you expect Mogens Eliasen will need away from
home in Creston, BC (just north of the Idaho border). Meals and accommodations are set at $60
and $120, as a start, but if you know they will be different in your case, please use more accurate
numbers.
The travel expenses are then calculated by your getting a quote for a plane ticket, or by suggesting
traveling the entire distance by road, in which last case you insert the mileage, either in miles or
in km, as you prefer. The travel distance to the nearest International Airport (Calgary, AB) is
326 miles (522 km), and the travel time 7 hours. The hours needed for travel count from Mogens
leaving home till start of the assignment, and the return travel time counts from end of the
assignment till he is back home. For assignments covering several days, you must calculate
one day off for every 5 days. Such days with no teachings are to be counted as "stand-by"
time. Days with only an evening seminar count as half days, with half a day "stand-by" time
to be added.
Add any additional costs you know will be relevant, such as teaching tools, if you want Mogens
to bring his own along. You simply replace the 0 with a 1 then.
You can freely change all green numbers as you wish, by simply "playing with the variables",
and you will get a total calculated. The red numbers should be changed only with caution.
Use this calculator to to get answers to all your "what if" questions!
BG}
Stand-by timeWhiteboard/blackboard:Assignments:hours @ km @ mi @Total:Deposit:Rate:Grand total:Overhead projector:Meals:Accommodation:Other reimbursements:Travel time, out:Travel time, return:Mileage (if in km):Mileage (if in miles):
Logistics:days @nights @Air plane tickets:&Use 1 if to be brought, 0 if provided:1K9joy Fee Calculation for out-of-town assignmentsSpecial (as agreed):parking at airportTotal expenses for travelTaxi:Car rental:One day with dogsFull weekend with dogsFull week with dogsNoses:*!G2 ;&
cc
&
dMbP?_*+%MJaws PDF CreatorS
od,,LetterPRIV0''''P4()6"d,,??U}}}}}$}I}
@
@
&
&;
.//////
-------
55
%
!@e@!4@0\RL=LL
L
LBB
!q@!>@0
"!q@!>@0h7
! |@!I@0
# ! |@!I@0
$
! @!@@0
##08
66''(#)
%
55
~
1
!~
$N@!DD
~
1
!~
$^@!DD
~
2
22D
~
1
~
$4@!DD
444'DDD
!~
3
+~
$Y@!DD
~
0
~
!$@!DD
~
0
~
!Y@! DD
~
0
~
!$@!DD
~
0
~
"4@!DD
~
0
~
"@@!DD
444#
%
,,~
0 DK
,,~
08 D2
66**(#)
%
77!%DD<$$PIIIIIIG"]]I]U]]]]]]QWWG>@<dR
7lAN2D:\Business\K9joy\Dog training\FeeCalculation.htmlFeeCalculation_8001e
(
dMbP?_*+%"??:\U>@7
)
dMbP?_*+%"??:\U>@7
Oh+'0HPh
Mogens EliasenMogens EliasenMicrosoft Excel@HN@{2M@6՜.+,0 PX|
Soverenity Enterprises Inc.Sheet1Sheet2Sheet3Worksheets
!"#$Root Entry F*/Workbook)SummaryInformation(DocumentSummaryInformation8