• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cost should be calculated 4 standard Km, & how to transfer for more Km to the next year.

GVN KUMAR

Member
For standard kilometers, there is a list of things that need to be replaced by those items for the vehicle.

Items that need to be replaced are expensive on that list.

How do we know how much it will cost in that financial year?

Example
Each vehicle has to change filters every 10000 kilometers.

But that vehicle had a range of 46000 kilometers that year.

So change the filters 4 times and calculate the cost only 4 times.
We will calculate the kilometer that is longer together for the next year.

We will calculate the number of kilometers in the following year as well as in the following year.

Calculating 46000 kilometers in the formula we wrote. That is, more than 40000 is also worth 6000 kilometers
Biting.

We only have to change the object 4 times for 40000 kilometers and how to calculate the cost.

The following formula is required.

How much does it cost to change filters per standard kilometer?

How to transfer kilometers that are more than the standard kilometers in that year to the next year?

To the best of my knowledge what I wrote was not correct. Hope that helps you a little bit.

financial year
1-4-22
31-3-23

79240
 

Attachments

  • travels.xlsx
    15.2 KB · Views: 3
Back
Top