Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Calculating the mileage in an expense claim

Posted on 2013-06-05
Medium Priority
Last Modified: 2013-06-06
You are shown an expense form from Mr Chan.

There are various expenses on the form, marked as December 2004.

1.12.04 - FDB Group - Train Journey - £8.80
1.12.04 - FDB Group - Lunch with client - £16.63
14.12.04 - OD&D Ltd - Mileage to and from presentation - £24.50
17.12.04 - Pickard & Co - Train journey to client - £12.45
23.12.04 - Shah Solicitors - Breakfast meeting - £17.40

Total for month £79.78

* mileage paid at £0.35 per mile for the first 1000 miles each year and £0.25 thereafter.

How many miles did Mr Chan travel on his journey to Reading for the presentation to OD&D Ltd ?

A 35
B 49
C 70
D 98
E Cannot say
Question by:purplesoup
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
LVL 84

Assisted Solution

ozo earned 336 total points
ID: 39221421
What assumptions are we allowed to make?
Should we assume that
14.12.04 - OD&D Ltd - Mileage to and from presentation - £24.50
is a journey to and from  Reading for a presentation to OD&D?
Should we assume that the route taken covered the same distance on the to journey as on the from  journey?
Should we assume that the expense form from Mr Chan is for the travels of Mr Chan?
Should we assume that there were no other mileage expenses that year?
LVL 17

Assisted Solution

by:Thibault St john Cholmondeley-ffeatherstonehaugh the 2nd
Thibault St john Cholmondeley-ffeatherstonehaugh the 2nd earned 664 total points
ID: 39221562
I get either C or D, so it must be E.

As this claim form has been presented to the expenses department I would hope that they have information about his previous mileage claims for the year and they should have provided this along with the form.
If they have such detailed, but varied information about the distances they presumably have a structure in place to pay the appropriate amount without the need for a form to be submitted.
In a previous company I worked for mileage claims were based on a hypothetical return journey between your normal place of work and the other location, subtracting the distance of your normal home to work journey. Those calculations were much more puzzling.
LVL 37

Assisted Solution

TommySzalapski earned 664 total points
ID: 39222120
The question asks how many miles he traveled to the destination so it should be half the round trip.

So it's either A or B depending on whether he has traveled over 1000 miles so far this year.

Since it is December, there are probably expenses that we don't know about.

I would agree that it must be E unless there is more info you have not told us.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 39222210
Ok - thanks - this actually is a real job assessment question a friend of mine got, run by this company


There was no other information provided and I'm sorry to say it didn't tell him if he got it right or not.

The comments made are quite apt - what are we allowed to assume here?

I agree that the answer must - if there is any justice - be E, we don't know what previous expense claims were. We can speculate that even though it is December if Mr Chan submits £24.50 a month he would still be within the first 1000 miles, but there is no way of knowing that.
LVL 37

Assisted Solution

TommySzalapski earned 664 total points
ID: 39222224
I agree completely.
LVL 17

Assisted Solution

by:Thibault St john Cholmondeley-ffeatherstonehaugh the 2nd
Thibault St john Cholmondeley-ffeatherstonehaugh the 2nd earned 664 total points
ID: 39222540
As it is a test question I expect they are looking for attention to detail and so identifying that there could be more than one answer is what they want.
LVL 22

Accepted Solution

Flyster earned 336 total points
ID: 39224452
Not knowing the total miles traveled prior to 14.12.04, "E" would be the only possible answer. If he had traveled 930 miles up to that point, then the next 70 miles would take him to 1000 for the year, all at £.35 per mile, or £24.50 total. If he was already past 1000 miles, then he would have to travel 98 miles (@ £.25) to make the £24.50. Between 70 and 98 miles, there are 13 possible combinations which would yield £24.50: I.E. If he had traveled 955 miles before that date, then the next 80 miles would yield the total of £24.50, 45 miles @ £.35 and 35 @ £.25.


Author Closing Comment

ID: 39224876
Thanks for your comments - it was a interesting format of question, I guess trying to tantalise you into working something out when there wasn't really enough information available.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What monsters are hiding in your child's room? In this article I will share with you a tech horror story that could happen to anyone, along with some tips on how you can prevent it from happening to you.
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question