I obviously Cant Wrap my head around this and I already have a lot of work done... BUT..
I am Trying To Create a Formula that will give me the $0+ Profit Margin for Owning a Motorcycle A month. Maybe someone Here may be able to assist me. I think If you read my formulas you'll have a better Idea of what I'm trying to do than I Explain it and confuse Everyone.....
(((Assumed Mileage * Percentage Riding Bike)/MotorCycle_MPG)*Gas_Cost) = Gas Cost for Motorcyle a Week
(((Assumed Mileage * (1-Percentage Riding Bike))/Truck_MPG)*Gas_Cost) = Gas Cost for Truck a Week
(Gas_Cost_Truck + Gas_Cost_MotorCycle) = Total Fuel Cost for Week
(((Assumed Mileage/Truck_MPG)*FuelCost)-(Total_Fuel_Cost+MotorCycle_Monthly_Payment))=Profit Margin(Can be Negative indicating a Loss or 0 or a + indicating a Profit)
I am Trying to create a Formula that Will Show the Percentage of Bike Riding I would have to do to have a 0+ Profit Margin. This is the Percentage that I am at 0 Loss, and not making a Profit.)
Here is an Example of my Formulas at work.
Variables I have Set.
FUEL STATS
Gas Cost = 3.83 (its higher now I know)
Assumed Milage = 336 (on average this is what I drive in a Week)
MOTORCYCLE STATS
Loan Ammount 117.58
Fuel Economy 55MPG
TRUCK STATS
Fuel Economy 16
EXAMPLE 1
51% Riding Bike
Gas Cost on Motorcyle = (((336miles*(51%)/55MPG)*3.83Gallon) = $11.93288727
Gas Cost on Truck = (((336miles*(49%)/16MPG)*3.83Gallon)= $39.4107
Total Fuel Cost = ($11.93288727 + $39.4107)
NOTE: The *4 in the Next Formula Takes the Gas cost from Weekly to Monthly (assuming there are 4 weeks in a Month)
Savings a Month Compared to Just Riding Truck = (((336Miles/16MPG)*$3.83Gallon)*4)-((Total_Fuel_Cost*4)+MotorCycleLoanPayment)= $-1.23
In the Above Example I am LOOSING $1.23 When I ride a Bike 51% of the Time.
EXAMPLE 2
52% Riding Bike
Gas Cost on Motorcyle = (((336miles*(52%)/55MPG)*3.83Gallon) = $12.16686545
Gas Cost on Truck = (((336miles*(48%)/16MPG)*3.83Gallon)= $38.6064
Total Fuel Cost = ($11.93288727 + $39.4107)
NOTE: As above *4 for four weeks a month
Savings a Month Compared to Just Riding Truck = (((336Miles/16MPG)*$3.83Gallon)*4)-((Total_Fuel_Cost*4)+MotorCycleLoanPayment)= $1.05
In the Above Example I am Gaining $$1.05 When I ride a Bike 52% of the Time.
Is it Possible to Write a Formula that Would Give me the Exact Percentage where I meet the 0 Dollar Profit Margin.
I would like to have this because It enables me to modify the Price of Gas Per Gallon and Show how the % Increases and Decreases According to Gas Cost
I am Trying To Create a Formula that will give me the $0+ Profit Margin for Owning a Motorcycle A month. Maybe someone Here may be able to assist me. I think If you read my formulas you'll have a better Idea of what I'm trying to do than I Explain it and confuse Everyone.....
(((Assumed Mileage * Percentage Riding Bike)/MotorCycle_MPG)*Gas_Cost) = Gas Cost for Motorcyle a Week
(((Assumed Mileage * (1-Percentage Riding Bike))/Truck_MPG)*Gas_Cost) = Gas Cost for Truck a Week
(Gas_Cost_Truck + Gas_Cost_MotorCycle) = Total Fuel Cost for Week
(((Assumed Mileage/Truck_MPG)*FuelCost)-(Total_Fuel_Cost+MotorCycle_Monthly_Payment))=Profit Margin(Can be Negative indicating a Loss or 0 or a + indicating a Profit)
I am Trying to create a Formula that Will Show the Percentage of Bike Riding I would have to do to have a 0+ Profit Margin. This is the Percentage that I am at 0 Loss, and not making a Profit.)
Here is an Example of my Formulas at work.
Variables I have Set.
FUEL STATS
Gas Cost = 3.83 (its higher now I know)
Assumed Milage = 336 (on average this is what I drive in a Week)
MOTORCYCLE STATS
Loan Ammount 117.58
Fuel Economy 55MPG
TRUCK STATS
Fuel Economy 16
EXAMPLE 1
51% Riding Bike
Gas Cost on Motorcyle = (((336miles*(51%)/55MPG)*3.83Gallon) = $11.93288727
Gas Cost on Truck = (((336miles*(49%)/16MPG)*3.83Gallon)= $39.4107
Total Fuel Cost = ($11.93288727 + $39.4107)
NOTE: The *4 in the Next Formula Takes the Gas cost from Weekly to Monthly (assuming there are 4 weeks in a Month)
Savings a Month Compared to Just Riding Truck = (((336Miles/16MPG)*$3.83Gallon)*4)-((Total_Fuel_Cost*4)+MotorCycleLoanPayment)= $-1.23
In the Above Example I am LOOSING $1.23 When I ride a Bike 51% of the Time.
EXAMPLE 2
52% Riding Bike
Gas Cost on Motorcyle = (((336miles*(52%)/55MPG)*3.83Gallon) = $12.16686545
Gas Cost on Truck = (((336miles*(48%)/16MPG)*3.83Gallon)= $38.6064
Total Fuel Cost = ($11.93288727 + $39.4107)
NOTE: As above *4 for four weeks a month
Savings a Month Compared to Just Riding Truck = (((336Miles/16MPG)*$3.83Gallon)*4)-((Total_Fuel_Cost*4)+MotorCycleLoanPayment)= $1.05
In the Above Example I am Gaining $$1.05 When I ride a Bike 52% of the Time.
Is it Possible to Write a Formula that Would Give me the Exact Percentage where I meet the 0 Dollar Profit Margin.
I would like to have this because It enables me to modify the Price of Gas Per Gallon and Show how the % Increases and Decreases According to Gas Cost