Finances

gosox116 · January 4, 2010, 4:33pm

My financials are in crazy debt! My fuel prices are set to only 99 cents (Southwest Airlines pricing), but I’m still over 3 million in debt. I’ve recalculated finances, but nothing works. Any advise? Thanks!

[table width=670px" align=“center” class=“balancesheet” cellpadding=“0” cellspacing="0]

[tr class=balancesheet_header" style="text-align: center]

[td align=left]Month

[td align=center]Flights

[td align=left]Revenue

[td align=“center” nowrap]Pilot Pay

[td align=left]Expenses

[td align=left]Fuel

[td align=“center” nowrap]Flight

[td align=center]Total

[td align=right]

October

[td align=center]

73

[td align=“right” nowrap]

$ 398,633.00

[td align=“right” nowrap]

$ 20,117.95

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

($ -603,458.00)

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

($ -204,825.00)

[td align=right]

November

[td align=center]

29

[td align=“right” nowrap]

$ 182,113.00

[td align=“right” nowrap]

$ 4,911.95

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

($ -3,910,771,201.00)

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

($ -3,910,589,088.00)

[td align=right]

December

[td align=center]

29

[td align=“right” nowrap]

$ 62,929.00

[td align=“right” nowrap]

$ 6,313.95

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

($ -275,775.00)

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

($ -212,846.00)

[td align=right]

January

[td align=center]

2

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

$ 288.50

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

($ -29,954.00)

[td align=“right” nowrap]

$ 0.00

[td align=“right” nowrap]

($ -29,954.00)

[tr class=balancesheet_header" style="border-bottom: 1px dotted]

[td align=" colspan=“8” style="padding: 1px]

[td align=right" colspan="6][strong]Total:[/strong]

[td align=right" colspan="2][strong]($ -3,911,036,713.00)[/strong]

nabeel · January 4, 2010, 4:38pm

What are your ticket prices? If you look at your PIREPs, what does it give there for the load counts and ticket prices?

gosox116 · January 4, 2010, 8:32pm

Ok, so the majority of my ticket prices were set to 0, so I exported the schedules, changed them all to 150, imported them, and reset my PIREP finances. In the details for each PIREP, we are now making money, but the finances table still shows that we are over (correction) 3 BILLION dollars! Any ideas? Thanks!

joeri · January 4, 2010, 8:44pm

added anny expence?

and something stupid try and change the value off 150 to something way high and see iff it goes positive

nabeel · January 4, 2010, 8:59pm

Ok, so the majority of my ticket prices were set to 0, so I exported the schedules, changed them all to 150, imported them, and reset my PIREP finances. In the details for each PIREP, we are now making money, but the finances table still shows that we are over (correction) 3 BILLION dollars! Any ideas? Thanks!

Try emptying the financedata table

gosox116 · January 4, 2010, 9:17pm

Try emptying the financedata table

I’m really sorry but how do I do this?

nabeel · January 4, 2010, 9:23pm

If you have phpmyadmin, open the database you’re using for phpVMS, and find the phpvms_financedata table, click on it, and there will be an option to empty the table.

TennShadow · January 5, 2010, 2:14am

If you have phpmyadmin, open the database you’re using for phpVMS, and find the phpvms_financedata table, click on it, and there will be an option to empty the table.

Please be very careful in there. Make sure you click “Empty Table” and not delete. I’m talking from experience here.

gosox116 · January 6, 2010, 2:07am

I got into phpmyadmin, selected the finances table, then clicked ‘Empty.’ It showed me this:

Do you really want to :

TRUNCATE TABLE phpvms_financedata

Do I go through with that or is that not the correct process.

I just don’t want to screw anything up. Thanks!

nabeel · January 6, 2010, 3:25am

Yep, that’s correct

gosox116 · January 6, 2010, 4:27pm

It worked great! Now I have over one million dollars in profit. One issue, though, is that it is ADDING money for pilot pay, instead of SUBTRACTING it. Real airlines LOSE money by paying their pilots. Thanks!

nabeel · January 6, 2010, 5:32pm

What do you have entered for your pilot pay? Did you enter a negative value?

joeri · January 6, 2010, 5:33pm

do you mean its not showing as this

Pilot Pay

80

This is what the pilot will be paid, per hour, for this flight

that is correct

or do you mean in the brakedown

there its like this $ 12,281.00

gr joeri

gosox116 · January 6, 2010, 6:29pm

What do you have entered for your pilot pay? Did you enter a negative value?

Nope it’s positive. The weird thing is that when I look at the January summary, it is subtracting money for pilot pay (which it should do), but then it adds it back in the totals. In the end, we do not lose money from paying pilots, which I would like to do.

do you mean its not showing as this

Pilot Pay

80

This is what the pilot will be paid, per hour, for this flight

that is correct

or do you mean in the brakedown

there its like this $ 12,281.00

gr joeri

I mean it in the breakdown. By the way, here it is for January:

Gross Revenue Flights:

Total number of flights: 25 $ 471,393.00

Pilot Payments: ($ -6,961.50) <<<THIS IS GOOD (almost 7k)***

Fuel Costs: ($ -202,599.00)

Flight Expenses: ($ -50,250.00)

Total: $ 211,582.50 <<<<<<<<<COMPARE THIS TO THE TOTAL REVENUE***

EXPENSES (MONTHLY)

None $ 0.00

Expenses Total: $ 0.00

TOTALS

Total Revenue: $ 218,544.00 <<<IT ADDED BACK THE 7k (compared to the Total) (not good)****

Net Worth: $ 218,544.00

Thanks!

joeri · January 6, 2010, 7:47pm

on my site it is correct look

Gross Revenue Flights:

Total number of flights: 17 $ 13,399,299.00

Pilot Payments: ($ -12,281.00)

Fuel Costs: ($ -978,845.00)

Flight Expenses: ($ -2,200,734.00)

Total: $ 10,207,439.00

Expenses (Monthly)

None $ 0.00

Transport Fee’s: ($ -100,000.00)

insurance: ($ -500,000.00)

Expenses Total: $ 600,000.00

Totals

Total Revenue: $ 9,619,720.00

Net Worth: $ 9,619,720.00

nabeel · January 6, 2010, 9:00pm

Joeri, it seems like it’s adding the pilot pay back into yours as well. Actually it seems like it’s not subtracting it. I’m checking it out right now, thanks

joeri · January 6, 2010, 9:07pm

dam thout i was running a good job ;D ;D ;D ;D

nabeel · January 6, 2010, 9:11pm

This is a weird bug

wrenchca · January 6, 2010, 11:52pm

In regards to excessive fuel usage, make sure you let your pilots know that they are not to park next to the default FS fuel depot when they arrive at their arrival airport. This will knock FSAcars for a loop and you will have fuel usage in the millions of pounds for just that one flight.

Setting the parking brake not only stops the recording for FSAcars, but it also automatically refuels your aircraft if you are parked in the area of the fuel depot. Since the refuelling is an inside FS function, it gets done before FSAcars can capture your final fuel. If your final fuel is greater than that which you started… …millions of pounds.

Just a heads up…

Chuck

CYXU