Help Trying to MAke A formula

Exodus

New Member
Joined
Jun 10, 2008
Messages
2
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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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)
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

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?

Disable AdBlock

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

Disable AdBlock Plus

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
Back
Top