board77

So, I was watching people come on and off tonight, and it's rather funny.

In the space of twenty minutes:

I think I saw Squiddy here, but then she left.

Jnyusa was here, but no one else was, and she left.

Then halplm was here, but no one else was, and he left.

Then Voronwe came, but no one else was here, and he left.

And Eru is here... hasn't left yet, but has only posted once




If ya'll just stuck around for five extra minutes, we'd have a party

*comes in, and leaves*

Busy amending my sig so no posting right now.

It's soon time for bed though.

Griffy -


Eru - Yeah, same here. I shouldn't say anything about no one staying on, as I am not normally on at this time of night.

My sleeping schedule is all messed up cause the past four days I've been going to bed late, getting up early, then going to back to bed again - is not good. So I'll be off pretty soon myself

I forgot it's an hour later for you. You are up kinda late. Though Iavas has been worse lately....going to be at 4am.

Yeah. My normal time schedule - if I just go to bed when I want and wake up when I want - is generally to go to sleep about 2-3am and wake up at about 10:30-11am.

Wish we could all work around what our normal sleep schedule is


Wish I could get a job

Stoopfid economy

That would be my preferred sleep schedule except I'd be in bed by 1-1:30am.. I'm a night owl, but I have to get up around 7am so I can get to my lessons on time.

What kind of job are you looking for?

Iavas hasn't even been able to look for a job because he doesn't have his EAD yet, but he has an appointment concerning it on Feb. 24. We're hoping that he may get it then. I can't help but worry about him finding a job once he gets it. My dad has been unemployed for over three years now. Part of it is his age, but honestly I don't know how hard he's been looking. Who knows, but it sucks for my mom having to be the sole bread winner.

How's this messing with you're time frames... i was in Boston this morning, and I'm in California now... I've just realized I've been up the last 20 hours...

halplm, for God's sake go to bed. You'll need lots of energy for agreeing with Iavas tomorrow.

Party? Party? You're lucky. It's 1:30am and I've just finished this memo:

Alex, as discussed, please use this revised Management Reporting database which is already populated with the 2005 Budget and reprogrammed to take into account the underlying currency. Instructions are below.

Dear All,

Regarding currencies, I’ve been doing some thinking. Please note the following:

Management Reports Budget
Because we are forced by International Accounting Standards 21 to translate the P/L at an average rate rather than the forward rate as we had planned, so are the Budget numbers in this version. As a result, the budget is floating and subject to the vagaries of exchange rate movements during the year. (IAS 21 has got it wrong in my opinion – badly wrong).

However, because we have forward rates in place to pretty much fix the budget, there needs to be more sophistication in the budget programming here. It needs to take the difference between the forward rates and the average rate, and post the difference to FX gain/loss in the P/L (602300). Thus the bottom line is fixed, but the individual line items may be different. This will take some serious reprogramming which I will not be able to do this month – especially since Alex needs to send out cubes tomorrow, but I’m not sure whether for Month 1 it will be significant anyway.

The idea about posting the difference to FX gain/loss should approximate what happens in real life in the companies. Take the prime case of Euro costs in CEPH (a dollar denominated company) in January. They posted EUR 500k of salaries in mid-Jan into the P/L not at any forward rate, but at the rate Coda had at the time – the December rate. After the month end when all the income and costs had been calculated, they made the calculation for Dutch tax. That was entered in their books in the P/L at, again, the rate Coda had at the time – in this case since the booking was made a few days into February, it used the January month end rate.

This method will be repeated in February – salaries posted at January rates, the tax (and any other post month end bookings for Euros) at February’s rate, etc etc.

To summarize, the actual bookings made into the P/L on a line by line basis are a mish-mash of the prior month end rate or the current month end rate. This is true of all such companies.

When they then come to revalue the balance sheet, that is where the P/L gets a credit or debit (in FX gain / loss) because of the forward rates used to source the foreign currency in the first place.

Therefore, my plan to fix the budget in the management report by having floating individual line numbers (with the FX gain / loss being the balancing number) closely follows what actually happens in the companies.

Local Budgets
Having seen in detail what a company does in real life, it begs the question whether we have populated Coda correctly using the forward rates for the line items.

I don’t think we have (although the bottom line should be correct). I think every month end we need to populate the Coda the same way as I have suggested above – use the previous month end rate for the line items, the current month end for tax, and the net difference to FX gain / loss.

Thus when Peter K reviews actual vs budget, if his Euro expenses are in line with budget, he should see no variance in his local TB.


Alex,

1 Back up your current Management Reporting.mdb to another name

2 Unzip this file.

3 Repopulate the following tables with whatever you have from the old file:
Financial Adjustments
Geneva Download
History
Management Adjustments

4 Run the Cube

Now, where's the friggin' alcohol?

Alassante_Estel at 5:47am wrote:

Yeah, same here. I shouldn't say anything about no one staying on, as I am not normally on at this time of night.

Time of night? That's about exactly when my alarm clock's going off.

Actually, you're right, that is the middle of the night. :(:P

5:47 am!? You have to get up at 6?!

Shudders

*pops in*

Isn't it against company regulations to post internal memos to messageboards?

*pops out*

Oh the joys of an international messageboard.

I'm at work now, and banging my head against the desk because I stayed up until 2am last night (around when the Americans were posting) writing a seminar for today and I've left the file in my home laptop - emailed myself the wrong file.

Impenitent wrote:

5:47 am!? You have to get up at 6?!

Shudders

No WE have to get up at 6 frickin am , in the cold and wet. We have moonlight and streetlights to guide us to the station . *grrrrrrrr*

Still, waking up is good, just the getting dragged out of bed is bad

Waking up would be better if it were at 10am.

*pouts*

Mummpizz,

Of course. But you know my history of sharing e-mails...

I was rather shocked by his posting it as well.


Leoba, Din

Well fine, ignore my question Estel.

I see you are regaining your strength and returning to your spamming ways. You're posting lots and are on all the time!

I only have to get up around 6:30-7:30am. It cahnged each day because my lessons start at different times. Luckily only one day of the week it's the 6:30am time.

Back in the summer after I graduated high school, I had to get up at 3am everyday for my job. I worked the morning shift at a coffee house in the airport. I had to get up by at the latest 3:15am so I could leave by 4am, so I could arrive at the airport by 4:30am, take the tram in, pass security, walk through the terminals and finally get to the stand at 5am. Then I had to open it up by 6am. I worked long shifts too because I wouldn't get out of there until around 3-4pm. I made some good money that summer though. It was worth it even though I was so tired since my body refused to go to sleep before 11pm.

So sorry that Din and Leoba have to do that walk to the station every morning! I hate mornings as is, but if doing that walk every morning (especially in the winter!) would make them even more unpleasant! The two of you do have quite the commute to work, but it's probably worth it for the area you live in. I found it to be nice.

Sorry Eru I'm hoping to get a job in a library. Unfortunatly, I haven't found one that is hiring.

When I was still in Texas, I would get up an extra hour early to go on TORC, and then get on the computer as soon as I got home and stay on till I went to bed.

Yes, know - it's sad Don't care