Good day,
I am driving myself crazy with trying to figure this out. Please save me!
I need a formula that will tell me how many miles are needed to be driven annually, based off of a Cents Per Mile and Driver Salary. Need help figuring out the "###" parts.
Web example can be found here. Basically I am re-creating this in Excel and changing it to my specifications. However this functionality will help in the long run with estimations.
http://www.thetruckersplace.com/OwnerWrkSheet.aspx
Example;
<TBODY>
</TBODY>
I am driving myself crazy with trying to figure this out. Please save me!
I need a formula that will tell me how many miles are needed to be driven annually, based off of a Cents Per Mile and Driver Salary. Need help figuring out the "###" parts.
Web example can be found here. Basically I am re-creating this in Excel and changing it to my specifications. However this functionality will help in the long run with estimations.
http://www.thetruckersplace.com/OwnerWrkSheet.aspx
Example;
Annual Costs | Monthly Costs | Cents Per Mile | |
Actual Cost of Operation | 1.57 | ||
Drivers Income | $50,000 | =B3/12 ($4,166.67) | =B3/Miles Needed (###) |
Miles Needed: | ### |
<TBODY>
</TBODY>