Labor Pricing Grid-Help

[Dhawk23]

Hello all. We currently have a labor pricing matrix that was copied out of our old software but it has no formula. I need help to find a formula to calculate grid based on labor time entered in A1. We want to increase this rate in the future and need help.

Thanks,

toyota grid (1).xlsx

[6StringJazzer]

Welcome to the Forum Dhawk23!

See tab Solution. The numbers in your sample sheet are all wrong except for 1.0 hours. I have no idea where you could have gotten these numbers.

This way of publishing rates in a table goes back to pre-computer days. Why don't you just have the user enter the number of hours and have a formula to multiply it by the rate? See sheet Even Better.

[Greg M]

Hi there,

The values produced by the following formula doesn't agree 100% with the values in your table, but the layout of the table seems to suggest that the following formula is what you need in Cell B2, copied across and down as appropriate:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[6StringJazzer]

After some thought I think you would want to explicitly round the price up to the next highest $0.01. Let me know if your policy is to round down to the next lowest $0.01.

Please Login or Register  to view this content.

and copy to the rest of the table.

[Dhawk23]

This is a labor time matrix where it also calculates a gradual increase of different percentages when we calculated a few cells it looked closer to 9-15 percent increase. I hope this helps.

[Dhawk23]

You guys are wizards and I appreciate you guys for messing with this.

[6StringJazzer]

it also calculates a gradual increase of different percentages

I'm sorry to say it makes it more confusing. I don't really understand what that means. Do you mean the more hours you bill, the higher the rate gets?

If it's not straight hours x rate, you need to explain how you want to calculate the price.

[Dhawk23]

Can you make it to where it increases the labor rate by .9 percent every additional hour please? We will try to run with that maybe make a cell where we can change the percentage to also have it recalculate.

Thanks,

[JeteMc]

Not sure that I understand, however to include an additional .9% for each hour (row) to Jeff's formula try:

Please Login or Register  to view this content.

Note that I put the results in columns M:W so they could be compared to the original amounts in columns A:K.
Let us know if you have any questions.

[6StringJazzer]

Put this formula in B2 and copy to entire table. It charges the given rate for under 1 hour, then starting at 1.0 hours it increases the rate by 0.9% for each full hour.

Please Login or Register  to view this content.

[Dhawk23]

Looks A lot better thank you guys very much.

[AliGW]

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

[JeteMc]

You're Welcome and thank you for the feedback. As Ali requests, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

Best regards,

Greg M