Help Trying to MAke A formula

Exodus

New Member
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

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Exodus

New Member
I suppose What I really Need is to be able to create a Formula to Basically to Say Find x where Results = 0

Gas Cost on Motorcyle = (((336miles*(x%)/55MPG)*3.83Gallon)

Gas Cost on Truck = (((336miles*(1-x%)/16MPG)*3.83Gallon)

Replies
7
Views
539
Replies
2
Views
342
Replies
0
Views
543
Replies
0
Views
218
Replies
2
Views
433

1,191,717
Messages
5,988,257
Members
440,145
Latest member
arxoon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back